documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
14 rows where docket_id = "DOT-OST-1997-3289" and posted_year = 2002 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, 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-1997-3289-0070 | DOT | Delta Air Lines, Inc. and Aerovias de Mexico, S.A. de C.V. - Exemption/Statement of Authorization - United States-Mexico Code-Sharing DOT-OST-1997-3289 | Notice of Action Taken re: Aerovias de Mexico, S.A. de C.V. (Aeromexico) | Notice | Notice | 2002-10-29T05:00:00Z | 2002 | 10 | 2002-10-29T05:00:00Z | 2002-10-30T04:59:59Z | 2024-11-07T01:56:10Z | 1 | 0 | 09000064802a493c | |
| DOT-OST-1997-3289-0069-0003 | DOT | Delta Air Lines, Inc. and Aerovias de Mexico, S.A. de C.V. - Exemption/Statement of Authorization - United States-Mexico Code-Sharing DOT-OST-1997-3289 | Aerovias de Mexico, S.A. de C.V. and Delta Air Lines, Inc. | Other | Correspondence | 2002-09-10T04:00:00Z | 2002 | 9 | 2002-09-10T04:00:00Z | 2002-09-11T03:59:59Z | 2024-11-07T01:56:09Z | 1 | 0 | 09000064802a493a | |
| DOT-OST-1997-3289-0069-0002 | DOT | Delta Air Lines, Inc. and Aerovias de Mexico, S.A. de C.V. - Exemption/Statement of Authorization - United States-Mexico Code-Sharing DOT-OST-1997-3289 | Aerovias de Mexico, S.A. de C.V. and Delta Air Lines, Inc. | Other | Correspondence | 2002-09-10T04:00:00Z | 2002 | 9 | 2002-09-10T04:00:00Z | 2002-09-11T03:59:59Z | 2024-11-07T01:56:09Z | 1 | 0 | 09000064802a4939 | |
| DOT-OST-1997-3289-0069-0001 | DOT | Delta Air Lines, Inc. and Aerovias de Mexico, S.A. de C.V. - Exemption/Statement of Authorization - United States-Mexico Code-Sharing DOT-OST-1997-3289 | Aerovias de Mexico, S.A. de C.V. and Delta Air Lines, Inc. | Other | Correspondence | 2002-09-10T04:00:00Z | 2002 | 9 | 2002-09-10T04:00:00Z | 2002-09-11T03:59:59Z | 2024-11-07T01:56:09Z | 1 | 0 | 09000064802a4938 | |
| DOT-OST-1997-3289-0068-0002 | DOT | Delta Air Lines, Inc. and Aerovias de Mexico, S.A. de C.V. - Exemption/Statement of Authorization - United States-Mexico Code-Sharing DOT-OST-1997-3289 | 30-Day Notice of Delta Air Lines, Inc. and Aerovias de Mexico, S.A. de C.V. | Notice | Notice | 2002-06-04T04:00:00Z | 2002 | 6 | 2002-06-04T04:00:00Z | 2002-06-05T03:59:59Z | 2024-11-07T01:56:09Z | 1 | 0 | 09000064802a4936 | |
| DOT-OST-1997-3289-0068-0003 | DOT | Delta Air Lines, Inc. and Aerovias de Mexico, S.A. de C.V. - Exemption/Statement of Authorization - United States-Mexico Code-Sharing DOT-OST-1997-3289 | 30-Day Notice of Delta Air Lines, Inc. and Aerovias de Mexico, S.A. de C.V. | Notice | Notice | 2002-06-04T04:00:00Z | 2002 | 6 | 2002-06-04T04:00:00Z | 2002-06-05T03:59:59Z | 2024-11-07T01:56:09Z | 1 | 0 | 09000064802a4937 | |
| DOT-OST-1997-3289-0068-0001 | DOT | Delta Air Lines, Inc. and Aerovias de Mexico, S.A. de C.V. - Exemption/Statement of Authorization - United States-Mexico Code-Sharing DOT-OST-1997-3289 | 30-Day Notice of Delta Air Lines, Inc. and Aerovias de Mexico, S.A. de C.V. | Notice | Notice | 2002-06-04T04:00:00Z | 2002 | 6 | 2002-06-04T04:00:00Z | 2002-06-05T03:59:59Z | 2024-11-07T01:56:09Z | 1 | 0 | 09000064802a4935 | |
| DOT-OST-1997-3289-0067-0001 | DOT | Delta Air Lines, Inc. and Aerovias de Mexico, S.A. de C.V. - Exemption/Statement of Authorization - United States-Mexico Code-Sharing DOT-OST-1997-3289 | 30-Day Notice of Delta Air Lines, Inc. and Aerovias de Mexico, S.A. de C.V. | Notice | Notice | 2002-04-24T04:00:00Z | 2002 | 4 | 2002-04-24T04:00:00Z | 2002-04-25T03:59:59Z | 2024-11-07T01:55:41Z | 1 | 0 | 09000064802a4932 | |
| DOT-OST-1997-3289-0067-0003 | DOT | Delta Air Lines, Inc. and Aerovias de Mexico, S.A. de C.V. - Exemption/Statement of Authorization - United States-Mexico Code-Sharing DOT-OST-1997-3289 | 30-Day Notice of Delta Air Lines, Inc. and Aerovias de Mexico, S.A. de C.V. | Notice | Notice | 2002-04-24T04:00:00Z | 2002 | 4 | 2002-04-24T04:00:00Z | 2002-04-25T03:59:59Z | 2024-11-07T01:56:38Z | 1 | 0 | 09000064802a4934 | |
| DOT-OST-1997-3289-0067-0002 | DOT | Delta Air Lines, Inc. and Aerovias de Mexico, S.A. de C.V. - Exemption/Statement of Authorization - United States-Mexico Code-Sharing DOT-OST-1997-3289 | 30-Day Notice of Delta Air Lines, Inc. and Aerovias de Mexico, S.A. de C.V. | Notice | Notice | 2002-04-24T04:00:00Z | 2002 | 4 | 2002-04-24T04:00:00Z | 2002-04-25T03:59:59Z | 2024-11-07T01:55:41Z | 1 | 0 | 09000064802a4933 | |
| DOT-OST-1997-3289-0066 | DOT | Delta Air Lines, Inc. and Aerovias de Mexico, S.A. de C.V. - Exemption/Statement of Authorization - United States-Mexico Code-Sharing DOT-OST-1997-3289 | Approval of Application | Other | Decision | 2002-04-09T04:00:00Z | 2002 | 4 | 2002-04-09T04:00:00Z | 2002-04-10T03:59:59Z | 2024-11-07T01:55:41Z | 1 | 0 | 09000064802a4931 | |
| DOT-OST-1997-3289-0065 | DOT | Delta Air Lines, Inc. and Aerovias de Mexico, S.A. de C.V. - Exemption/Statement of Authorization - United States-Mexico Code-Sharing DOT-OST-1997-3289 | Joint Application of Delta Air Lines, Inc., Atlantic Southeast Airlines, Inc., Comair, Inc. and Aerovias de Mexico, S.A. de C.V. for Amended Statements of Authorization and a Special Authorization | Other | Application-Other | 2002-03-19T05:00:00Z | 2002 | 3 | 2002-03-19T05:00:00Z | 2002-03-20T04:59:59Z | 2024-11-07T01:55:40Z | 1 | 0 | 09000064802a4930 | |
| DOT-OST-1997-3289-0064 | DOT | Delta Air Lines, Inc. and Aerovias de Mexico, S.A. de C.V. - Exemption/Statement of Authorization - United States-Mexico Code-Sharing DOT-OST-1997-3289 | 30-Day Notice of Delta, ASA, Comair and Aeromexico (Intra-U.S. Codesharing) | Notice | Notice | 2002-03-15T05:00:00Z | 2002 | 3 | 2002-03-15T05:00:00Z | 2002-03-16T04:59:59Z | 2024-11-07T01:55:40Z | 1 | 0 | 09000064802a492f | |
| DOT-OST-1997-3289-0063 | DOT | Delta Air Lines, Inc. and Aerovias de Mexico, S.A. de C.V. - Exemption/Statement of Authorization - United States-Mexico Code-Sharing DOT-OST-1997-3289 | 30-Day Notice of Delta Air Lines, Inc. and Aerovias de Mexico, S.A. de C.V. | Notice | Notice | 2002-02-05T05:00:00Z | 2002 | 2 | 2002-02-05T05:00:00Z | 2002-02-06T04:59:59Z | 2024-11-07T01:55:40Z | 1 | 0 | 09000064802a492e |
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;