documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
38 rows where docket_id = "DOT-OST-2004-19978" sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: title, subtype, posted_month, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DOT-OST-2004-19978-0039 | DOT | None DOT-OST-2004-19978 | 2021-5-4 Final Order | Other | Order | 2021-05-06T04:00:00Z | 2021 | 5 | 2021-05-06T04:00:00Z | 2024-11-06T23:46:33Z | 1 | 0 | 0900006484ad47c4 | ||
| DOT-OST-2004-19978-0038 | DOT | None DOT-OST-2004-19978 | 2021-2-4 Order Granting Amended Exemption and to Show Cause | Other | Order | 2021-02-10T05:00:00Z | 2021 | 2 | 2021-02-10T05:00:00Z | 2024-11-06T23:45:12Z | 1 | 0 | 0900006484a2d5b0 | ||
| DOT-OST-2004-19978-0037 | DOT | None DOT-OST-2004-19978 | Application of Longtail Aviation International Limited for Amended Exemption Authority and a Foreign Air Carrier Permit | Other | Application-Other | 2020-12-18T05:00:00Z | 2020 | 12 | 2020-12-18T05:00:00Z | 2024-11-12T23:26:43Z | 1 | 0 | 09000064849a94ef | ||
| DOT-OST-2004-19978-0036 | DOT | None DOT-OST-2004-19978 | Notice of Action Taken re: Longtail Aviation International Limited | Other | Decision | 2020-06-30T04:00:00Z | 2020 | 6 | 2020-06-30T04:00:00Z | 2024-11-06T23:37:03Z | 1 | 0 | 090000648471b32b | ||
| DOT-OST-2004-19978-0035 | DOT | None DOT-OST-2004-19978 | Longtail Aviation (Polling Letter) | Other | Letter(s) | 2020-06-29T04:00:00Z | 2020 | 6 | 2020-06-29T04:00:00Z | 2024-11-12T23:22:39Z | 1 | 0 | 09000064847183ef | ||
| DOT-OST-2004-19978-0034 | DOT | None DOT-OST-2004-19978 | Response to Answer of Atlas Air, Inc. to Request of Longtail Aviation International Limited to Renew and Amend Exemption Authority | Other | Response(s) | 2020-06-25T04:00:00Z | 2020 | 6 | 2020-06-25T04:00:00Z | 2024-11-12T23:22:28Z | 1 | 0 | 090000648470c564 | ||
| DOT-OST-2004-19978-0033 | DOT | None DOT-OST-2004-19978 | Answer of Atlas Air, Inc. to Request of Longtail Aviation International Limited to Renew and Amend Exemption Authority | Other | Answer | 2020-06-25T04:00:00Z | 2020 | 6 | 2020-06-25T04:00:00Z | 2024-11-12T23:22:37Z | 1 | 0 | 090000648470ac3f | ||
| DOT-OST-2004-19978-0032 | DOT | None DOT-OST-2004-19978 | Clarification of Request of Longtail Aviation International Limited to Renew and Amend Exemption Authority | Other | Clarification | 2020-06-23T04:00:00Z | 2020 | 6 | 2020-06-23T04:00:00Z | 2024-11-06T23:37:44Z | 1 | 0 | 0900006484702b32 | ||
| DOT-OST-2004-19978-0031 | DOT | None DOT-OST-2004-19978 | Request of Longtail Aviation International Limited to Renew and Amend Exemption Authority | Other | Application-Other | 2020-06-22T04:00:00Z | 2020 | 6 | 2020-06-22T04:00:00Z | 2024-11-12T23:22:25Z | 1 | 0 | 09000064846fe57a | ||
| DOT-OST-2004-19978-0030 | DOT | None DOT-OST-2004-19978 | Application for Renewal of an Exemption | Other | Application-Other | 2020-04-16T04:00:00Z | 2020 | 4 | 2020-04-16T04:00:00Z | 2024-11-06T23:34:45Z | 1 | 0 | 09000064844ae15c | ||
| DOT-OST-2004-19978-0029 | DOT | None DOT-OST-2004-19978 | Notice of Action Taken re: Longtail Aviation International Limited | Other | Decision | 2019-04-23T04:00:00Z | 2019 | 4 | 2019-04-23T04:00:00Z | 2024-11-12T22:59:41Z | 1 | 0 | 0900006483be4e9d | ||
| DOT-OST-2004-19978-0028 | DOT | None DOT-OST-2004-19978 | Application for Renewal of an Exemption | Other | Application-Other | 2019-03-15T04:00:00Z | 2019 | 3 | 2019-03-15T04:00:00Z | 2024-11-12T22:57:14Z | 1 | 0 | 0900006483ae7e64 | ||
| DOT-OST-2004-19978-0027 | DOT | None DOT-OST-2004-19978 | Notice of Action Taken re: Longtail Aviation International Limited | Other | Decision | 2018-07-16T04:00:00Z | 2018 | 7 | 2018-07-16T04:00:00Z | 2024-11-07T01:35:25Z | 1 | 0 | 0900006483502be2 | ||
| DOT-OST-2004-19978-0026 | DOT | None DOT-OST-2004-19978 | Application for Renewal of an Exemption | Other | Application-Other | 2018-03-30T04:00:00Z | 2018 | 3 | 2018-03-30T04:00:00Z | 2024-11-07T01:24:48Z | 1 | 0 | 09000064830751ee | ||
| DOT-OST-2004-19978-0025 | DOT | None DOT-OST-2004-19978 | Notice of Action Taken re: Longtail Aviation International Limited | Other | Decision | 2017-06-05T04:00:00Z | 2017 | 6 | 2017-06-05T04:00:00Z | 2024-11-07T01:01:29Z | 1 | 0 | 0900006482691655 | ||
| DOT-OST-2004-19978-0024 | DOT | None DOT-OST-2004-19978 | Application for Renewal of an Exemption | Other | Application-Other | 2017-05-05T04:00:00Z | 2017 | 5 | 2017-05-05T04:00:00Z | 2024-11-07T00:58:19Z | 1 | 0 | 09000064825954ac | ||
| DOT-OST-2004-19978-0023 | DOT | None DOT-OST-2004-19978 | Notice of Action Taken re: Longtail Aviation International Limited | Other | Decision | 2016-10-28T04:00:00Z | 2016 | 10 | 2016-10-28T04:00:00Z | 2024-11-12T06:15:11Z | 1 | 0 | 090000648235aab1 | ||
| DOT-OST-2004-19978-0022 | DOT | None DOT-OST-2004-19978 | Application for Renewal of an Exemption Filed by Longtail Aviation International Limited | Other | Application-Other | 2016-03-02T05:00:00Z | 2016 | 3 | 2016-03-02T05:00:00Z | 2024-11-12T05:53:11Z | 1 | 0 | 0900006481e99c6d | ||
| DOT-OST-2004-19978-0021 | DOT | None DOT-OST-2004-19978 | Notice of Action Taken re: Longtail Aviation International Limited | Other | Decision | 2015-05-26T04:00:00Z | 2015 | 5 | 2015-05-26T04:00:00Z | 2024-11-11T20:56:35Z | 1 | 0 | 0900006481af7957 | ||
| DOT-OST-2004-19978-0020 | DOT | None DOT-OST-2004-19978 | Application for Renewal of an Exemption Filed by Longtail Aviation International Limited | Other | Application-Other | 2015-05-22T04:00:00Z | 2015 | 5 | 2015-05-22T04:00:00Z | 2024-11-07T23:20:26Z | 1 | 0 | 0900006481aec155 | ||
| DOT-OST-2004-19978-0019 | DOT | None DOT-OST-2004-19978 | Notice of Action Taken re: Longtail Aviation International Limited | Other | Decision | 2014-04-11T04:00:00Z | 2014 | 4 | 2014-04-11T04:00:00Z | 2014-04-11T13:14:41Z | 0 | 0 | 09000064816ae40b | ||
| DOT-OST-2004-19978-0018 | DOT | None DOT-OST-2004-19978 | Supplement #2 to Application for Renewal of an Exemption Filed by Longtail Aviation International Limited | Supporting & Related Material | Supplement | 2014-03-26T04:00:00Z | 2014 | 3 | 2024-11-07T23:05:53Z | 0 | 0 | 0900006481674a89 | |||
| DOT-OST-2004-19978-0017 | DOT | None DOT-OST-2004-19978 | Supplement #1 to Application for Renewal of an Exemption Filed by Longtail Aviation International Limited | Supporting & Related Material | Supplement | 2014-03-26T04:00:00Z | 2014 | 3 | 2024-11-07T23:05:31Z | 0 | 0 | 090000648166db0f | |||
| DOT-OST-2004-19978-0016 | DOT | None DOT-OST-2004-19978 | Application for Renewal of an Exemption Filed by Longtail Aviation International Limited | Other | Application-Other | 2014-03-05T05:00:00Z | 2014 | 3 | 2014-03-05T05:00:00Z | 2024-11-12T05:25:23Z | 1 | 0 | 09000064815f86e7 | ||
| DOT-OST-2004-19978-0015 | DOT | None DOT-OST-2004-19978 | Notice of Action Taken re: Longtail Aviation International Limited | Other | Decision | 2013-03-07T05:00:00Z | 2013 | 3 | 2013-03-07T05:00:00Z | 2024-11-07T22:50:04Z | 1 | 0 | 090000648121db55 | ||
| DOT-OST-2004-19978-0014 | DOT | None DOT-OST-2004-19978 | Application for Renewal of an Exemption filed by Longtail Aviation International Limited | Other | Application-Other | 2013-01-28T05:00:00Z | 2013 | 1 | 2013-01-28T05:00:00Z | 2024-11-12T05:13:08Z | 1 | 0 | 09000064811d3e1a | ||
| DOT-OST-2004-19978-0013 | DOT | None DOT-OST-2004-19978 | Notice of Action Taken re: Longtail Aviation International Limited | Other | Decision | 2012-01-27T05:00:00Z | 2012 | 1 | 2012-01-27T05:00:00Z | 2024-11-07T21:58:02Z | 1 | 0 | 0900006480fa7aee | ||
| DOT-OST-2004-19978-0012 | DOT | None DOT-OST-2004-19978 | Application for Renewal of an Exemption Filed by Longtail Aviation International Limited | Other | Application-Other | 2011-12-23T05:00:00Z | 2011 | 12 | 2011-12-23T05:00:00Z | 2024-11-11T21:35:42Z | 1 | 0 | 0900006480f871eb | ||
| DOT-OST-2004-19978-0011 | DOT | None DOT-OST-2004-19978 | Notice of Action Taken re: Longtail Aviation International Limited | Other | Notice | 2011-01-11T05:00:00Z | 2011 | 1 | 2011-01-11T05:00:00Z | 2024-11-07T22:25:55Z | 1 | 0 | 0900006480bc8e6e | ||
| DOT-OST-2004-19978-0010 | DOT | None DOT-OST-2004-19978 | Application for Renewal of an Exemption Filed by Longtail Aviation International Limited | Other | Other | 2010-12-22T05:00:00Z | 2010 | 12 | 2010-12-22T05:00:00Z | 2024-11-07T22:27:29Z | 1 | 0 | 0900006480bbcefe | ||
| DOT-OST-2004-19978-0009 | DOT | None DOT-OST-2004-19978 | Application for Renewal of an Exemption filed by Longtail Aviation International Ltd. | Other | Application-Other | 2010-04-29T04:00:00Z | 2010 | 4 | 2010-04-29T04:00:00Z | 2024-11-07T22:17:21Z | 1 | 0 | 0900006480ade7d8 | ||
| DOT-OST-2004-19978-0008 | DOT | None DOT-OST-2004-19978 | Notice of Action Taken re: Longtail Aviation International Limited | Other | Notice | 2010-03-19T04:00:00Z | 2010 | 3 | 2010-03-19T04:00:00Z | 2024-11-12T04:51:27Z | 1 | 0 | 0900006480ac19b0 | ||
| DOT-OST-2004-19978-0007 | DOT | None DOT-OST-2004-19978 | Application for Renewal of Exemption Filed by Longtail Aviation International Limited | Other | Application-Other | 2010-02-01T05:00:00Z | 2010 | 2 | 2010-02-01T05:00:00Z | 2013-08-11T03:06:35Z | 0 | 0 | 0900006480a869f4 | ||
| DOT-OST-2004-19978-0006 | DOT | None DOT-OST-2004-19978 | Notice of Action Taken re: Longtail Aviation Ltd. | Other | Notice | 2009-02-03T05:00:00Z | 2009 | 2 | 2009-02-03T05:00:00Z | 2024-11-12T04:31:50Z | 1 | 0 | 090000648084476a | ||
| DOT-OST-2004-19978-0004 | DOT | None DOT-OST-2004-19978 | Notice of Action Taken re: Longtail Aviation Ltd. | Notice | Notice | 2006-11-02T05:00:00Z | 2006 | 11 | 2006-11-02T05:00:00Z | 2006-11-03T04:59:59Z | 2024-11-07T16:56:19Z | 1 | 0 | 09000064802bc15f | |
| DOT-OST-2004-19978-0003 | DOT | None DOT-OST-2004-19978 | Application for Renewal of an Exemption Filed by Longtail Aviation Ltd. | Other | Application-Other | 2006-01-23T05:00:00Z | 2006 | 1 | 2006-01-23T05:00:00Z | 2006-01-24T04:59:59Z | 2024-11-07T16:56:19Z | 1 | 0 | 09000064802bc15e | |
| DOT-OST-2004-19978-0002 | DOT | None DOT-OST-2004-19978 | Notice of Action Taken re: Longtail Aviation Ltd. (Longtail Aviation) | Notice | Notice | 2005-02-18T05:00:00Z | 2005 | 2 | 2005-02-18T05:00:00Z | 2005-02-19T04:59:59Z | 2024-11-07T16:56:19Z | 1 | 0 | 09000064802bc15d | |
| DOT-OST-2004-19978-0001 | DOT | None DOT-OST-2004-19978 | Application for an Exemption filed by Longtail Aviation, Ltd. | Other | Application-Other | 2004-12-27T05:00:00Z | 2004 | 12 | 2004-12-27T05:00:00Z | 2004-12-28T04:59:59Z | 2024-11-07T16:56:19Z | 1 | 0 | 09000064802bc15c |
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;