documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
26 rows where docket_id = "FAA-2001-10583" sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: title, subtype, posted_month, last_modified, open_for_comment, posted_date (date), comment_start_date (date), comment_end_date (date), last_modified (date)
| id | agency_id | docket_id | title | document_type | subtype | posted_date ▲ | posted_year | posted_month | comment_start_date | comment_end_date | last_modified | fr_doc_num | open_for_comment | withdrawn | object_id |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FAA-2001-10583-0027 | FAA | Exemption/Rulemaking - Aero Sports Connection FAA-2001-10583 | U.S. DOT/FAA - Decision | Other | Decision | 2024-09-23T04:00:00Z | 2024 | 9 | 2024-09-23T04:00:00Z | 2024-11-12T22:43:57Z | 1 | 0 | 090000648676bee8 | ||
| FAA-2001-10583-0026 | FAA | Exemption/Rulemaking - Aero Sports Connection FAA-2001-10583 | Exemption/Rulemaking - Aero Sports Connection (Request for Extension) | Other | Request for Extension | 2024-06-18T04:00:00Z | 2024 | 6 | 2024-06-18T04:00:00Z | 2024-11-12T22:36:27Z | 1 | 0 | 09000064865bd4eb | ||
| FAA-2001-10583-0025 | FAA | Exemption/Rulemaking - Aero Sports Connection FAA-2001-10583 | US DOT/FAA- Decision | Other | Decision | 2022-11-30T05:00:00Z | 2022 | 11 | 2022-11-30T05:00:00Z | 2022-11-30T19:12:27Z | 0 | 0 | 0900006485508ae0 | ||
| FAA-2001-10583-0024 | FAA | Exemption/Rulemaking - Aero Sports Connection FAA-2001-10583 | Aero Sports Connection - Exemption/Rulemaking | Other | Petition(s) | 2022-10-25T04:00:00Z | 2022 | 10 | 2022-10-25T04:00:00Z | 2024-11-07T00:43:30Z | 1 | 0 | 09000064854507eb | ||
| FAA-2001-10583-0023 | FAA | Exemption/Rulemaking - Aero Sports Connection FAA-2001-10583 | Decision | Other | Decision | 2020-11-23T05:00:00Z | 2020 | 11 | 2020-11-23T05:00:00Z | 2020-11-23T19:02:00Z | 0 | 0 | 090000648497138d | ||
| FAA-2001-10583-0022 | FAA | Exemption/Rulemaking - Aero Sports Connection FAA-2001-10583 | Aero Sports Connection - Exemption/Rulemaking | Other | Petition(s) | 2020-10-01T04:00:00Z | 2020 | 10 | 2020-10-01T04:00:00Z | 2024-11-06T23:39:19Z | 1 | 0 | 09000064848a2d06 | ||
| FAA-2001-10583-0021 | FAA | Exemption/Rulemaking - Aero Sports Connection FAA-2001-10583 | U.S. DOT/FAA - Decision | Other | Decision | 2018-08-14T04:00:00Z | 2018 | 8 | 2018-08-14T04:00:00Z | 2024-11-07T01:36:40Z | 1 | 0 | 0900006483620187 | ||
| FAA-2001-10583-0020 | FAA | Exemption/Rulemaking - Aero Sports Connection FAA-2001-10583 | Aero Sports Connection - Exemption/Rulemaking (Amendment) | Other | Petition(s) | 2018-08-13T04:00:00Z | 2018 | 8 | 2018-08-13T04:00:00Z | 2018-08-13T20:08:44Z | 0 | 0 | 0900006483618fe1 | ||
| FAA-2001-10583-0019 | FAA | Exemption/Rulemaking - Aero Sports Connection FAA-2001-10583 | Aero Sports Connection - Exemption/Rulemaking | Other | Petition(s) | 2018-05-09T04:00:00Z | 2018 | 5 | 2018-05-09T04:00:00Z | 2024-11-07T01:29:37Z | 1 | 0 | 090000648325029d | ||
| FAA-2001-10583-0018 | FAA | Exemption/Rulemaking - Aero Sports Connection FAA-2001-10583 | Record of Conversation | Other | Record of Meeting/Phone Conversation | 2016-12-08T05:00:00Z | 2016 | 12 | 2016-12-08T05:00:00Z | 2016-12-08T19:55:44Z | 0 | 0 | 09000064823ee81f | ||
| FAA-2001-10583-0017 | FAA | Exemption/Rulemaking - Aero Sports Connection FAA-2001-10583 | U.S. DOT/FAA - Decision | Other | Decision | 2016-12-01T05:00:00Z | 2016 | 12 | 2016-12-01T05:00:00Z | 2016-12-01T18:52:49Z | 0 | 0 | 09000064823cf224 | ||
| FAA-2001-10583-0016 | FAA | Exemption/Rulemaking - Aero Sports Connection FAA-2001-10583 | Aero Sports Connection - Exemption/Rulemaking | Other | Petition(s) | 2016-11-03T04:00:00Z | 2016 | 11 | 2016-11-03T04:00:00Z | 2024-11-11T21:32:24Z | 1 | 0 | 090000648236ee89 | ||
| FAA-2001-10583-0015 | FAA | Exemption/Rulemaking - Aero Sports Connection FAA-2001-10583 | U.S. DOT/FAA - Decision | Other | Decision | 2014-12-01T05:00:00Z | 2014 | 12 | 2014-12-01T05:00:00Z | 2014-12-01T21:18:58Z | 0 | 0 | 0900006481952558 | ||
| FAA-2001-10583-0014 | FAA | Exemption/Rulemaking - Aero Sports Connection FAA-2001-10583 | Aero Sports Connection - Exemption/Rulemaking | Other | Petition(s) | 2014-10-27T04:00:00Z | 2014 | 10 | 2014-10-27T04:00:00Z | 2024-11-07T23:09:34Z | 1 | 0 | 09000064818f7b40 | ||
| FAA-2001-10583-0013 | FAA | Exemption/Rulemaking - Aero Sports Connection FAA-2001-10583 | U.S. DOT/FAA - Decision | Other | Decision | 2012-07-02T04:00:00Z | 2012 | 7 | 2012-07-02T04:00:00Z | 2024-11-07T22:42:47Z | 1 | 0 | 09000064810719f0 | ||
| FAA-2001-10583-0012 | FAA | Exemption/Rulemaking - Aero Sports Connection FAA-2001-10583 | Aero Sports Connection - Exemption/Rulemaking | Other | Petition(s) | 2012-06-07T04:00:00Z | 2012 | 6 | 2012-06-07T04:00:00Z | 2024-11-12T05:04:19Z | 1 | 0 | 090000648103a032 | ||
| FAA-2001-10583-0011 | FAA | Exemption/Rulemaking - Aero Sports Connection FAA-2001-10583 | U.S. DOT/FAA - Decision | Other | Decision | 2010-09-21T04:00:00Z | 2010 | 9 | 2010-09-21T04:00:00Z | 2013-07-27T23:30:39Z | 0 | 0 | 0900006480b4e3e0 | ||
| FAA-2001-10583-0010 | FAA | Exemption/Rulemaking - Aero Sports Connection FAA-2001-10583 | Aero Sports Connection, Inc. - Exemption/Rulemaking | Other | Petition(s) | 2010-08-26T04:00:00Z | 2010 | 8 | 2010-08-26T04:00:00Z | 2013-07-27T23:29:07Z | 0 | 0 | 0900006480b39ea1 | ||
| FAA-2001-10583-0009 | FAA | Exemption/Rulemaking - Aero Sports Connection FAA-2001-10583 | U.S. DOT/FAA - Decision | Other | Decision | 2008-11-25T05:00:00Z | 2008 | 11 | 2008-11-25T05:00:00Z | 2013-08-11T02:58:05Z | 0 | 0 | 09000064807be44f | ||
| FAA-2001-10583-0007 | FAA | Exemption/Rulemaking - Aero Sports Connection FAA-2001-10583 | Aero Sports Connection - Exemption/Rulemaking | Other | Petition(s) | 2008-03-20T04:00:00Z | 2008 | 3 | 2008-03-20T04:00:00Z | 2013-07-28T01:31:02Z | 0 | 0 | 0900006480401067 | ||
| FAA-2001-10583-0006 | FAA | Exemption/Rulemaking - Aero Sports Connection FAA-2001-10583 | U.S. DOT/FAA - Grant of Petition | Other | Decision | 2006-04-25T04:00:00Z | 2006 | 4 | 2006-04-25T04:00:00Z | 2006-04-26T03:59:59Z | 2024-11-11T21:50:40Z | 1 | 0 | 09000064802ad849 | |
| FAA-2001-10583-0005 | FAA | Exemption/Rulemaking - Aero Sports Connection FAA-2001-10583 | Aero Sports Connection - Exemption/Rulemaking | Other | Petition(s) | 2005-12-30T05:00:00Z | 2005 | 12 | 2005-12-30T05:00:00Z | 2005-12-31T04:59:59Z | 2024-11-11T21:50:40Z | 1 | 0 | 09000064802ad848 | |
| FAA-2001-10583-0004 | FAA | Exemption/Rulemaking - Aero Sports Connection FAA-2001-10583 | U.S. DOT/FAA - Notice of Dispositions of Prior Petitions | Rule | Federal Register Publication | 2004-06-23T04:00:00Z | 2004 | 6 | 2004-06-23T04:00:00Z | 2004-06-24T03:59:59Z | 2024-11-11T21:50:39Z | 1 | 0 | 09000064802ad847 | |
| FAA-2001-10583-0003 | FAA | Exemption/Rulemaking - Aero Sports Connection FAA-2001-10583 | U.S. DOT/FAA - Grant of Exemption | Other | Decision | 2004-06-01T04:00:00Z | 2004 | 6 | 2004-06-01T04:00:00Z | 2004-06-02T03:59:59Z | 2024-11-11T21:50:39Z | 1 | 0 | 09000064802ad846 | |
| FAA-2001-10583-0002 | FAA | Exemption/Rulemaking - Aero Sports Connection FAA-2001-10583 | AERO Sports Connection (ASC) - Supplemental Information | Supporting & Related Material | Supplement | 2001-10-24T04:00:00Z | 2001 | 10 | 2024-11-11T21:50:39Z | 0 | 0 | 09000064802ad845 | |||
| FAA-2001-10583-0001 | FAA | Exemption/Rulemaking - Aero Sports Connection FAA-2001-10583 | Aero Sports Connection - Exemption/Rulemaking | Other | Petition(s) | 2001-08-17T04:00:00Z | 2001 | 8 | 2001-08-17T04:00:00Z | 2001-08-18T03:59:59Z | 2024-11-11T21:50:39Z | 1 | 0 | 09000064802ad844 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE documents (
id TEXT PRIMARY KEY,
agency_id TEXT,
docket_id TEXT REFERENCES dockets(id),
title TEXT,
document_type TEXT,
subtype TEXT,
posted_date TEXT,
posted_year INTEGER,
posted_month INTEGER,
comment_start_date TEXT,
comment_end_date TEXT,
last_modified TEXT,
fr_doc_num TEXT,
open_for_comment INTEGER,
withdrawn INTEGER,
object_id TEXT
);
CREATE INDEX idx_docs_agency ON documents(agency_id);
CREATE INDEX idx_docs_docket ON documents(docket_id);
CREATE INDEX idx_docs_date ON documents(posted_date);
CREATE INDEX idx_docs_year ON documents(posted_year);
CREATE INDEX idx_docs_type ON documents(document_type);
CREATE INDEX idx_docs_frnum ON documents(fr_doc_num);
CREATE INDEX idx_docs_comment_end ON documents(comment_end_date) WHERE comment_end_date IS NOT NULL AND withdrawn = 0;