documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
27 rows where docket_id = "DOT-OST-2004-17867" sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: title, subtype, posted_date, posted_month, comment_start_date, comment_end_date, last_modified, open_for_comment, posted_date (date), comment_start_date (date), comment_end_date (date), last_modified (date)
posted_year 13
agency_id 1
- DOT 27
| 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-17867-0024 | DOT | None DOT-OST-2004-17867 | Notice of Action Taken re: Aerotransporte de Carga Union, S.A. de C.V. | Other | Decision | 2016-04-12T04:00:00Z | 2016 | 4 | 2016-04-12T04:00:00Z | 2024-11-12T06:10:31Z | 1 | 0 | 0900006481f62677 | ||
| DOT-OST-2004-17867-0023 | DOT | None DOT-OST-2004-17867 | Application of Aerotransporte de Carga Union, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2016-03-15T04:00:00Z | 2016 | 3 | 2016-03-15T04:00:00Z | 2024-11-12T06:05:29Z | 1 | 0 | 0900006481ec2217 | ||
| DOT-OST-2004-17867-0022 | DOT | None DOT-OST-2004-17867 | Notice of Action Taken re: Aerotransporte de Carga Union, S.A. de C.V. | Other | Decision | 2015-04-16T04:00:00Z | 2015 | 4 | 2015-04-16T04:00:00Z | 2024-11-12T05:35:40Z | 1 | 0 | 0900006481aaa1b2 | ||
| DOT-OST-2004-17867-0021 | DOT | None DOT-OST-2004-17867 | Application for Renewal of Exemption Authority | Other | Application-Other | 2015-03-03T05:00:00Z | 2015 | 3 | 2015-03-03T05:00:00Z | 2024-11-07T23:18:22Z | 1 | 0 | 0900006481a108bc | ||
| DOT-OST-2004-17867-0020 | DOT | None DOT-OST-2004-17867 | Notice of Action Taken re: Aerotransporte de Carga Union, S.A. de C.V. | Other | Decision | 2014-03-26T04:00:00Z | 2014 | 3 | 2014-03-26T04:00:00Z | 2014-03-26T13:54:54Z | 0 | 0 | 090000648167f535 | ||
| DOT-OST-2004-17867-0019 | DOT | None DOT-OST-2004-17867 | Application for Renewal of Exemption Authority | Other | Application-Other | 2013-11-19T05:00:00Z | 2013 | 11 | 2013-11-19T05:00:00Z | 2024-11-12T05:23:59Z | 1 | 0 | 090000648148aa74 | ||
| DOT-OST-2004-17867-0018 | DOT | None DOT-OST-2004-17867 | Notice of Action Taken re: Aerotransporte de Carga Union, S.A. de C.V. | Other | Decision | 2012-12-19T05:00:00Z | 2012 | 12 | 2012-12-19T05:00:00Z | 2024-11-12T05:09:36Z | 1 | 0 | 0900006481192ec0 | ||
| DOT-OST-2004-17867-0017 | DOT | None DOT-OST-2004-17867 | Application for Renewal of Exemption Authority | Other | Application-Other | 2012-11-26T05:00:00Z | 2012 | 11 | 2024-11-12T05:08:40Z | 1 | 0 | 0900006481172c4d | |||
| DOT-OST-2004-17867-0016 | DOT | None DOT-OST-2004-17867 | Notice of Action Taken re: Aerotransporte de Carga Union, S.A. de C.V. | Other | Decision | 2011-12-22T05:00:00Z | 2011 | 12 | 2011-12-22T05:00:00Z | 2024-11-11T21:36:41Z | 1 | 0 | 0900006480f8827a | ||
| DOT-OST-2004-17867-0015 | DOT | None DOT-OST-2004-17867 | Application for Renewal of Exemption Authority | Other | Application-Other | 2011-12-05T05:00:00Z | 2011 | 12 | 2011-12-05T05:00:00Z | 2024-11-12T04:23:34Z | 1 | 0 | 0900006480f7b7df | ||
| DOT-OST-2004-17867-0014 | DOT | None DOT-OST-2004-17867 | Notice of Action Taken re: Aerotransporte de Carga Union S.A. de C.V. | Other | Notice | 2011-01-11T05:00:00Z | 2011 | 1 | 2011-01-11T05:00:00Z | 2024-11-07T22:26:55Z | 1 | 0 | 0900006480bc8d99 | ||
| DOT-OST-2004-17867-0013 | DOT | None DOT-OST-2004-17867 | Aerotransporte de Carga Union, S.A. de C.V. | Other | Correspondence | 2010-12-10T05:00:00Z | 2010 | 12 | 2010-12-10T05:00:00Z | 2024-11-12T05:00:15Z | 1 | 0 | 0900006480bb1bd3 | ||
| DOT-OST-2004-17867-0012 | DOT | None DOT-OST-2004-17867 | Notice of Action Taken re: Aerotransporte de Carga Union, S.A. de C.V. | Other | Notice | 2010-01-07T05:00:00Z | 2010 | 1 | 2010-01-07T05:00:00Z | 2024-11-07T22:11:37Z | 1 | 0 | 0900006480a79396 | ||
| DOT-OST-2004-17867-0011 | DOT | None DOT-OST-2004-17867 | Aerotransporte de Carga Union, S.A. de C.V. | Other | Correspondence | 2009-12-29T05:00:00Z | 2009 | 12 | 2009-12-29T05:00:00Z | 2013-08-11T04:37:02Z | 0 | 0 | 0900006480a6bdb5 | ||
| DOT-OST-2004-17867-0010 | DOT | None DOT-OST-2004-17867 | Notice of Action Taken re: Aerotransporte de Carga Union, S.A. de C.V. | Other | Notice | 2009-01-23T05:00:00Z | 2009 | 1 | 2009-01-23T05:00:00Z | 2024-11-12T04:31:00Z | 1 | 0 | 090000648082c676 | ||
| DOT-OST-2004-17867-0009 | DOT | None DOT-OST-2004-17867 | Aerotransporte de Carga Union, S.A. de C.V. | Other | Correspondence | 2009-01-05T05:00:00Z | 2009 | 1 | 2009-01-05T05:00:00Z | 2013-08-11T02:58:56Z | 0 | 0 | 090000648080c00c | ||
| DOT-OST-2004-17867-0008 | DOT | None DOT-OST-2004-17867 | Notice of Action Taken re: Aerotransporte de Carga Union, S.A. de C.V. | Other | Notice | 2008-01-29T05:00:00Z | 2008 | 1 | 2008-01-29T05:00:00Z | 2013-07-27T20:32:58Z | 0 | 0 | 09000064803a45df | ||
| DOT-OST-2004-17867-0007 | DOT | None DOT-OST-2004-17867 | Aerotransporte de Carga Union, S.A. de C.V. | Other | Application-Other | 2008-01-07T05:00:00Z | 2008 | 1 | 2008-01-07T05:00:00Z | 2013-08-11T04:02:11Z | 0 | 0 | 0900006480385264 | ||
| DOT-OST-2004-17867-0006 | DOT | None DOT-OST-2004-17867 | Notice of Action Taken re: Aerotransporte de Carga Union, S.A. de C.V. | Notice | Notice | 2007-02-15T05:00:00Z | 2007 | 2 | 2007-02-15T05:00:00Z | 2007-02-16T04:59:59Z | 2024-11-08T04:06:48Z | 1 | 0 | 09000064802b2856 | |
| DOT-OST-2004-17867-0005-0001 | DOT | None DOT-OST-2004-17867 | Application for Renewal Exemption Authority | Other | Application-Other | 2006-10-04T04:00:00Z | 2006 | 10 | 2006-10-04T04:00:00Z | 2006-10-05T03:59:59Z | 2024-11-08T04:06:48Z | 1 | 0 | 09000064802b2854 | |
| DOT-OST-2004-17867-0005-0002 | DOT | None DOT-OST-2004-17867 | Application for Renewal Exemption Authority | Other | Application-Other | 2006-10-04T04:00:00Z | 2006 | 10 | 2006-10-04T04:00:00Z | 2006-10-05T03:59:59Z | 2024-11-08T04:06:48Z | 1 | 0 | 09000064802b2855 | |
| DOT-OST-2004-17867-0004 | DOT | None DOT-OST-2004-17867 | Notice of Action Taken re: Aerotransporte de Carga Union, S.A. de C.V. | Notice | Notice | 2005-11-08T05:00:00Z | 2005 | 11 | 2005-11-08T05:00:00Z | 2005-11-09T04:59:59Z | 2024-11-08T04:06:48Z | 1 | 0 | 09000064802b2853 | |
| DOT-OST-2004-17867-0003-0002 | DOT | None DOT-OST-2004-17867 | Application for Renewal Exemption Authority | Other | Application-Other | 2005-09-22T04:00:00Z | 2005 | 9 | 2005-09-22T04:00:00Z | 2005-09-23T03:59:59Z | 2024-11-08T04:06:24Z | 1 | 0 | 09000064802b2852 | |
| DOT-OST-2004-17867-0003-0001 | DOT | None DOT-OST-2004-17867 | Application for Renewal Exemption Authority | Other | Application-Other | 2005-09-22T04:00:00Z | 2005 | 9 | 2005-09-22T04:00:00Z | 2005-09-23T03:59:59Z | 2024-11-08T04:06:24Z | 1 | 0 | 09000064802b2851 | |
| DOT-OST-2004-17867-0002 | DOT | None DOT-OST-2004-17867 | U.S. DOT/OST - Aerotransporte de Carga Union, S.A. de C.V. | Notice | Notice | 2004-10-08T04:00:00Z | 2004 | 10 | 2004-10-08T04:00:00Z | 2004-10-09T03:59:59Z | 2024-11-08T04:06:24Z | 1 | 0 | 09000064802b2850 | |
| DOT-OST-2004-17867-0001-0002 | DOT | None DOT-OST-2004-17867 | Application for an Exemption | Other | Application-Other | 2004-05-14T04:00:00Z | 2004 | 5 | 2004-05-14T04:00:00Z | 2004-05-15T03:59:59Z | 2024-11-08T04:06:24Z | 1 | 0 | 09000064802b284f | |
| DOT-OST-2004-17867-0001-0001 | DOT | None DOT-OST-2004-17867 | Application for an Exemption | Other | Application-Other | 2004-05-14T04:00:00Z | 2004 | 5 | 2004-05-14T04:00:00Z | 2004-05-15T03:59:59Z | 2024-11-08T04:06:23Z | 1 | 0 | 09000064802b284d |
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;