documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
27 rows where docket_id = "FAA-2009-0520" and document_type = "Other" sorted by posted_date descending
This data as json, CSV (advanced)
| 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-2009-0520-0030 | FAA | None FAA-2009-0520 | FlightSafety International - Cessna - Exemption/Rulemaking (Additional Information) | Other | Additional Information | 2026-02-02T05:00:00Z | 2026 | 2 | 2026-02-02T05:00:00Z | 2026-02-02T21:23:48Z | 1 | 0 | 09000064b918b8aa | ||
| FAA-2009-0520-0029 | FAA | None FAA-2009-0520 | FlightSafety International - Cessna - Exemption/Rulemaking (Request for Extension) | Other | Request for Extension | 2026-01-08T05:00:00Z | 2026 | 1 | 2026-01-08T05:00:00Z | 2026-01-08T20:25:00Z | 1 | 0 | 09000064b911eba6 | ||
| FAA-2009-0520-0026 | FAA | None FAA-2009-0520 | FlightSafety International - Cessna - Exemption/Rulemaking (Response) | Other | Response(s) | 2025-09-24T04:00:00Z | 2025 | 9 | 2025-09-24T04:00:00Z | 2025-09-24T21:53:24Z | 1 | 0 | 09000064b8fd942a | ||
| FAA-2009-0520-0025 | FAA | None FAA-2009-0520 | U.S. DOT/FAA - Request for Information | Other | Request | 2025-09-10T04:00:00Z | 2025 | 9 | 2025-09-10T04:00:00Z | 2025-09-10T21:22:42Z | 1 | 0 | 09000064b8f66e76 | ||
| FAA-2009-0520-0024 | FAA | None FAA-2009-0520 | FlightSafety International - Cessna - Exemption/Rulemaking (Amendment) | Other | Amendment | 2025-03-07T05:00:00Z | 2025 | 3 | 2025-03-07T05:00:00Z | 2025-03-07T13:54:50Z | 1 | 0 | 09000064869b6e02 | ||
| FAA-2009-0520-0023 | FAA | None FAA-2009-0520 | U.S. DOT/FAA - Decision | Other | Decision | 2024-04-29T04:00:00Z | 2024 | 4 | 2024-04-29T04:00:00Z | 2025-03-09T01:31:31Z | 1 | 0 | 0900006486522728 | ||
| FAA-2009-0520-0022 | FAA | None FAA-2009-0520 | FlightSafety International - Cessna - Exemption/Rulemaking (Request for Extension) | Other | Request for Extension | 2023-12-04T05:00:00Z | 2023 | 12 | 2023-12-04T05:00:00Z | 2024-11-12T06:23:38Z | 1 | 0 | 09000064862d6264 | ||
| FAA-2009-0520-0021 | FAA | None FAA-2009-0520 | Record of Conversation | Other | Record of Meeting/Phone Conversation | 2021-04-16T04:00:00Z | 2021 | 4 | 2021-04-16T04:00:00Z | 2021-04-16T13:11:18Z | 0 | 0 | 0900006484aa948f | ||
| FAA-2009-0520-0020 | FAA | None FAA-2009-0520 | Decision | Other | Decision | 2021-04-09T04:00:00Z | 2021 | 4 | 2021-04-09T04:00:00Z | 2021-04-09T18:13:51Z | 0 | 0 | 0900006484aa1e07 | ||
| FAA-2009-0520-0019 | FAA | None FAA-2009-0520 | FlightSafety International - Cessna - Exemption/Rulemaking | Other | Petition(s) | 2021-03-09T05:00:00Z | 2021 | 3 | 2021-03-09T05:00:00Z | 2021-03-09T14:02:05Z | 0 | 0 | 0900006484a64114 | ||
| FAA-2009-0520-0018 | FAA | None FAA-2009-0520 | Withdrawal of Petition for Exemption | Other | Withdrawal | 2020-08-20T04:00:00Z | 2020 | 8 | 2020-08-20T04:00:00Z | 2020-08-20T19:44:48Z | 0 | 0 | 0900006484815a3f | ||
| FAA-2009-0520-0017 | FAA | None FAA-2009-0520 | FlightSafety International - Exemption/Rulemaking | Other | Petition(s) | 2020-08-07T04:00:00Z | 2020 | 8 | 2020-08-07T04:00:00Z | 2024-11-12T23:23:35Z | 1 | 0 | 09000064847e38a4 | ||
| FAA-2009-0520-0016 | FAA | None FAA-2009-0520 | FlightSafety International - Exemption/Rulemaking | Other | 2020-08-04T00:00:00Z | 2020 | 8 | 2024-11-12T23:24:27Z | 0 | 1 | 09000064847d0c19 | ||||
| FAA-2009-0520-0014 | FAA | None FAA-2009-0520 | Decision | Other | Decision | 2019-04-11T04:00:00Z | 2019 | 4 | 2019-04-11T04:00:00Z | 2019-04-11T18:50:09Z | 0 | 0 | 0900006483b807a7 | ||
| FAA-2009-0520-0013 | FAA | None FAA-2009-0520 | FlightSafety International - Exemption/Rulemaking | Other | Petition(s) | 2019-01-23T05:00:00Z | 2019 | 1 | 2019-01-23T05:00:00Z | 2024-11-12T22:52:47Z | 1 | 0 | 0900006483a02d07 | ||
| FAA-2009-0520-0012 | FAA | None FAA-2009-0520 | U.S. DOT/FAA - Decision | Other | Decision | 2017-01-10T05:00:00Z | 2017 | 1 | 2017-01-10T05:00:00Z | 2017-01-10T16:28:22Z | 0 | 0 | 0900006482456777 | ||
| FAA-2009-0520-0011 | FAA | None FAA-2009-0520 | FlightSafety International - Cessna - Exemption/Rulemaking (Amendment) | Other | Petition for Exemption on Section 333 | 2016-04-20T04:00:00Z | 2016 | 4 | 2016-04-20T04:00:00Z | 2024-11-11T21:27:10Z | 1 | 0 | 0900006481f79af0 | ||
| FAA-2009-0520-0010 | FAA | None FAA-2009-0520 | U.S. DOT/FAA - Decision | Other | Decision | 2015-07-20T04:00:00Z | 2015 | 7 | 2015-07-20T04:00:00Z | 2015-07-20T15:47:15Z | 0 | 0 | 0900006481b83b4c | ||
| FAA-2009-0520-0009 | FAA | None FAA-2009-0520 | Flight Safety International - Exemption/Rulemaking | Other | Petition(s) | 2015-01-16T05:00:00Z | 2015 | 1 | 2015-01-16T05:00:00Z | 2024-11-12T05:31:35Z | 1 | 0 | 09000064819cc479 | ||
| FAA-2009-0520-0008 | FAA | None FAA-2009-0520 | U.S. DOT/FAA - Decision | Other | Decision | 2013-06-27T04:00:00Z | 2013 | 6 | 2013-06-27T04:00:00Z | 2024-11-11T20:45:13Z | 1 | 0 | 0900006481346912 | ||
| FAA-2009-0520-0007 | FAA | None FAA-2009-0520 | FlightSafety International - Exemption/Rulemaking | Other | Petition(s) | 2013-02-12T05:00:00Z | 2013 | 2 | 2013-02-12T05:00:00Z | 2024-11-07T22:49:02Z | 1 | 0 | 09000064811f2b5f | ||
| FAA-2009-0520-0006 | FAA | None FAA-2009-0520 | U.S. DOT/FAA - Decision | Other | Decision | 2012-04-03T04:00:00Z | 2012 | 4 | 2012-04-03T04:00:00Z | 2012-04-03T20:37:03Z | 0 | 0 | 0900006480fe7bed | ||
| FAA-2009-0520-0005 | FAA | None FAA-2009-0520 | Flight Safety International, LLC - Exemption/Rulemaking | Other | Petition(s) | 2011-11-01T04:00:00Z | 2011 | 11 | 2011-11-01T04:00:00Z | 2024-11-07T22:39:59Z | 1 | 0 | 0900006480f62370 | ||
| FAA-2009-0520-0004 | FAA | None FAA-2009-0520 | U.S. DOT/FAA - Decision | Other | Decision | 2011-02-28T05:00:00Z | 2011 | 2 | 2011-02-28T05:00:00Z | 2013-08-11T01:40:09Z | 0 | 0 | 0900006480bfa545 | ||
| FAA-2009-0520-0003 | FAA | None FAA-2009-0520 | Flight Safety International, LLC - Exemption/Rulemaking | Other | Petition(s) | 2011-02-08T05:00:00Z | 2011 | 2 | 2011-02-08T05:00:00Z | 2024-11-12T04:57:33Z | 1 | 0 | 0900006480bdd710 | ||
| FAA-2009-0520-0002 | FAA | None FAA-2009-0520 | U.S. DOT/FAA - Decision | Other | Decision | 2009-07-21T04:00:00Z | 2009 | 7 | 2009-07-21T04:00:00Z | 2013-07-27T22:49:56Z | 0 | 0 | 09000064809f73b5 | ||
| FAA-2009-0520-0001 | FAA | None FAA-2009-0520 | FlightSafety International - Cessna - Exemption/Rulemaking | Other | Petition(s) | 2009-06-03T04:00:00Z | 2009 | 6 | 2009-06-03T04:00:00Z | 2013-07-27T22:46:15Z | 0 | 0 | 09000064809c307f |
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;