documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
30 rows where docket_id = "DOT-OST-2005-20398" 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 15
agency_id 1
- DOT 30
| 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-2005-20398-0025 | DOT | None DOT-OST-2005-20398 | Notice of Action Taken re: Aero-Sami, S.A. de C.V. | Other | Decision | 2026-01-23T05:00:00Z | 2026 | 1 | 2026-01-23T05:00:00Z | 2026-01-23T21:30:23Z | 1 | 0 | 09000064b917c9b8 | ||
| DOT-OST-2005-20398-0024 | DOT | None DOT-OST-2005-20398 | Application of Aero-Sami, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2025-12-08T05:00:00Z | 2025 | 12 | 2025-12-08T05:00:00Z | 2025-12-08T19:49:55Z | 1 | 0 | 09000064b90b2f89 | ||
| DOT-OST-2005-20398-0023 | DOT | None DOT-OST-2005-20398 | Notice of Action Taken re: Aero-Sami, S.A. de C.V. | Other | Decision | 2023-12-27T05:00:00Z | 2023 | 12 | 2023-12-27T05:00:00Z | 2024-11-12T06:24:41Z | 1 | 0 | 090000648635e268 | ||
| DOT-OST-2005-20398-0022 | DOT | None DOT-OST-2005-20398 | Application of Aero-Sami, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2023-02-21T05:00:00Z | 2023 | 2 | 2023-02-21T05:00:00Z | 2024-11-07T00:48:29Z | 1 | 0 | 09000064856baa09 | ||
| DOT-OST-2005-20398-0021 | DOT | None DOT-OST-2005-20398 | Notice of Action Taken re: Aero-Sami, S.A. de C.V. | Other | Decision | 2021-02-18T05:00:00Z | 2021 | 2 | 2021-02-18T05:00:00Z | 2024-11-12T23:29:18Z | 1 | 0 | 0900006484a3c990 | ||
| DOT-OST-2005-20398-0020 | DOT | None DOT-OST-2005-20398 | Application of Aero-Sami, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2020-07-02T04:00:00Z | 2020 | 7 | 2020-07-02T04:00:00Z | 2024-11-12T23:22:19Z | 1 | 0 | 09000064847234a3 | ||
| DOT-OST-2005-20398-0019 | DOT | None DOT-OST-2005-20398 | Notice of Action Taken re: Aero Sami, S.A. de C.V. | Other | Decision | 2018-07-03T04:00:00Z | 2018 | 7 | 2018-07-03T04:00:00Z | 2024-11-07T01:33:33Z | 1 | 0 | 090000648349c38b | ||
| DOT-OST-2005-20398-0018 | DOT | None DOT-OST-2005-20398 | Application of Aero-Sami, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2018-04-03T04:00:00Z | 2018 | 4 | 2018-04-03T04:00:00Z | 2024-11-07T01:25:06Z | 1 | 0 | 090000648309093f | ||
| DOT-OST-2005-20398-0017 | DOT | None DOT-OST-2005-20398 | Notice of Action Taken (Corrected) re: Aero Sami, S.A. de C.V. | Other | Decision | 2016-04-19T04:00:00Z | 2016 | 4 | 2016-04-19T04:00:00Z | 2024-11-11T21:28:03Z | 1 | 0 | 0900006481f75173 | ||
| DOT-OST-2005-20398-0016 | DOT | None DOT-OST-2005-20398 | Notice of Action Taken re: Aero Sami, S.A. de C.V. | Other | Decision | 2016-04-05T04:00:00Z | 2016 | 4 | 2016-04-05T04:00:00Z | 2024-11-07T23:41:16Z | 1 | 0 | 0900006481f28333 | ||
| DOT-OST-2005-20398-0015 | DOT | None DOT-OST-2005-20398 | Application of Aero-Sami, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2015-12-24T05:00:00Z | 2015 | 12 | 2015-12-24T05:00:00Z | 2024-11-11T21:19:16Z | 1 | 0 | 0900006481dcf83a | ||
| DOT-OST-2005-20398-0014 | DOT | None DOT-OST-2005-20398 | Notice of Action Taken re: Aero-Sami, S.A. de C.V., Aerovics, S.A. de C.V., and Servicios Ejecutivos Gosa, S.A. de C.V. | Other | Decision | 2014-01-02T05:00:00Z | 2014 | 1 | 2015-12-07T05:00:00Z | 2024-11-11T21:15:47Z | 1 | 0 | 0900006481d8b4ad | ||
| DOT-OST-2005-20398-0013 | DOT | None DOT-OST-2005-20398 | Application of Aero-Sami, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2013-12-06T05:00:00Z | 2013 | 12 | 2013-12-06T05:00:00Z | 2024-11-12T05:24:47Z | 1 | 0 | 09000064814a8c1c | ||
| DOT-OST-2005-20398-0012 | DOT | None DOT-OST-2005-20398 | Notice of Action Taken re: Aerovics, S.A. de C.V., Servicios Ejecutivos Gosa, S.A. de C.V., Aero-Sami, S.A. de C.V., Plan Aeronaves, S.A. de C.V., and Servicios Aereos Interestatales, S.A. de C.V. | Other | Decision | 2011-12-06T05:00:00Z | 2011 | 12 | 2011-12-06T05:00:00Z | 2024-11-12T04:22:16Z | 1 | 0 | 0900006480f7c828 | ||
| DOT-OST-2005-20398-0011 | DOT | None DOT-OST-2005-20398 | Application of Aero-Sami, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2011-11-21T05:00:00Z | 2011 | 11 | 2011-11-21T05:00:00Z | 2024-11-07T22:41:05Z | 1 | 0 | 0900006480f6abce | ||
| DOT-OST-2005-20398-0010 | DOT | None DOT-OST-2005-20398 | Notice of Action Taken re: Aero Sami, S.A. de C.V. | Other | Notice | 2009-11-18T05:00:00Z | 2009 | 11 | 2009-11-18T05:00:00Z | 2013-07-27T23:00:11Z | 0 | 0 | 0900006480a5a61d | ||
| DOT-OST-2005-20398-0009 | DOT | None DOT-OST-2005-20398 | Aero Sami, S.A. de C.V. | Other | Correspondence | 2009-10-29T04:00:00Z | 2009 | 10 | 2009-10-29T04:00:00Z | 2013-08-11T03:04:50Z | 0 | 0 | 0900006480a4c92f | ||
| DOT-OST-2005-20398-0008 | DOT | None DOT-OST-2005-20398 | Notice of Action Taken re: Aero Sami, Aerosafin, Ronso, and Aerovics, S.A. de C.V. | Other | Adjudication Notice | 2007-10-31T04:00:00Z | 2007 | 10 | 2007-10-31T04:00:00Z | 2013-07-27T20:25:45Z | 0 | 0 | 090000648035c0f7 | ||
| DOT-OST-2005-20398-0007-0001 | DOT | None DOT-OST-2005-20398 | Aero Sami, S.A. de C.V. | Other | Correspondence | 2007-09-06T04:00:00Z | 2007 | 9 | 2007-09-06T04:00:00Z | 2007-09-07T03:59:59Z | 2024-11-08T04:16:19Z | 1 | 0 | 09000064802b6964 | |
| DOT-OST-2005-20398-0007-0002 | DOT | None DOT-OST-2005-20398 | Aero Sami, S.A. de C.V. | Other | Correspondence | 2007-09-06T04:00:00Z | 2007 | 9 | 2007-09-06T04:00:00Z | 2007-09-07T03:59:59Z | 2024-11-08T04:16:19Z | 1 | 0 | 09000064802b6965 | |
| DOT-OST-2005-20398-0006-0002 | DOT | None DOT-OST-2005-20398 | Application fro a Renewal of an Exemption Filed by Aero Sami, S.A. de CV. for a Period of Two Years | Other | Application-Other | 2007-07-31T04:00:00Z | 2007 | 7 | 2007-07-31T04:00:00Z | 2007-08-01T03:59:59Z | 2024-11-08T04:16:19Z | 1 | 0 | 09000064802b6963 | |
| DOT-OST-2005-20398-0006-0001 | DOT | None DOT-OST-2005-20398 | Application fro a Renewal of an Exemption Filed by Aero Sami, S.A. de CV. for a Period of Two Years | Other | Application-Other | 2007-07-31T04:00:00Z | 2007 | 7 | 2007-07-31T04:00:00Z | 2007-08-01T03:59:59Z | 2024-11-08T04:16:19Z | 1 | 0 | 09000064802b6962 | |
| DOT-OST-2005-20398-0005-0002 | DOT | None DOT-OST-2005-20398 | Application of Aero Sami, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2007-07-27T04:00:00Z | 2007 | 7 | 2007-07-27T04:00:00Z | 2007-07-28T03:59:59Z | 2024-11-08T04:16:19Z | 1 | 0 | 09000064802b6961 | |
| DOT-OST-2005-20398-0005-0001 | DOT | None DOT-OST-2005-20398 | Application of Aero Sami, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2007-07-27T04:00:00Z | 2007 | 7 | 2007-07-27T04:00:00Z | 2007-07-28T03:59:59Z | 2024-11-08T04:16:19Z | 1 | 0 | 09000064802b6960 | |
| DOT-OST-2005-20398-0004 | DOT | None DOT-OST-2005-20398 | Notice of Action Taken re: Aero Sami, S.A. de C.V. | Notice | Notice | 2006-08-02T04:00:00Z | 2006 | 8 | 2006-08-02T04:00:00Z | 2006-08-03T03:59:59Z | 2024-11-08T04:16:18Z | 1 | 0 | 09000064802b695f | |
| DOT-OST-2005-20398-0003-0002 | DOT | None DOT-OST-2005-20398 | Application for a Renewal of an Exemption Filed by Aero Sami, S.A. de C.V. | Other | Application-Other | 2006-06-29T04:00:00Z | 2006 | 6 | 2006-06-29T04:00:00Z | 2006-06-30T03:59:59Z | 2024-11-08T04:15:52Z | 1 | 0 | 09000064802b695e | |
| DOT-OST-2005-20398-0003-0001 | DOT | None DOT-OST-2005-20398 | Application for a Renewal of an Exemption Filed by Aero Sami, S.A. de C.V. | Other | Application-Other | 2006-06-29T04:00:00Z | 2006 | 6 | 2006-06-29T04:00:00Z | 2006-06-30T03:59:59Z | 2024-11-08T04:15:52Z | 1 | 0 | 09000064802b695d | |
| DOT-OST-2005-20398-0002 | DOT | None DOT-OST-2005-20398 | Notice of Action Taken re: Aero Sami S.A. de C.V. | Notice | Notice | 2005-07-08T04:00:00Z | 2005 | 7 | 2005-07-08T04:00:00Z | 2005-07-09T03:59:59Z | 2024-11-08T04:15:52Z | 1 | 0 | 09000064802b695c | |
| DOT-OST-2005-20398-0001-0001 | DOT | None DOT-OST-2005-20398 | Application of Aero Sami, S.A. de C.V. for an Exemption | Other | Application-Other | 2005-02-11T05:00:00Z | 2005 | 2 | 2005-02-11T05:00:00Z | 2005-02-12T04:59:59Z | 2025-12-13T07:21:34Z | 1 | 0 | 09000064802b695a | |
| DOT-OST-2005-20398-0001-0002 | DOT | None DOT-OST-2005-20398 | Application of Aero Sami, S.A. de C.V. for an Exemption | Other | Application-Other | 2005-02-11T05:00:00Z | 2005 | 2 | 2005-02-11T05:00:00Z | 2005-02-12T04:59:59Z | 2024-11-08T04:15:52Z | 1 | 0 | 09000064802b695b |
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;