documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
20 rows where docket_id = "DOT-OST-2003-15060" sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: title, subtype, posted_month, last_modified, open_for_comment, posted_date (date), comment_start_date (date), comment_end_date (date), last_modified (date)
agency_id 1
- DOT 20
| 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-2003-15060-0020 | DOT | None DOT-OST-2003-15060 | 2018-9-8 Order Granting Exemption, Dismissing Exemption Renewal, and to Show Cause | Other | Order | 2018-09-06T04:00:00Z | 2018 | 9 | 2018-09-06T04:00:00Z | 2024-11-07T01:37:16Z | 1 | 0 | 09000064836b4e5c | ||
| DOT-OST-2003-15060-0019 | DOT | None DOT-OST-2003-15060 | Application for Renewal of an Exemption filed by Canadian North Inc. | Other | Application-Other | 2018-07-24T04:00:00Z | 2018 | 7 | 2018-07-24T04:00:00Z | 2024-11-07T23:55:06Z | 1 | 0 | 0900006483537b50 | ||
| DOT-OST-2003-15060-0018 | DOT | None DOT-OST-2003-15060 | Notice of Action Taken re: Canadian North Inc. c/o/b/a Canadian North | Other | Decision | 2016-01-27T05:00:00Z | 2016 | 1 | 2016-01-27T05:00:00Z | 2024-11-12T05:58:35Z | 1 | 0 | 0900006481e33692 | ||
| DOT-OST-2003-15060-0017 | DOT | None DOT-OST-2003-15060 | Application for Renewal of an Exemption Filed by Canadian North, Inc. | Other | Application-Other | 2015-12-24T05:00:00Z | 2015 | 12 | 2015-12-24T05:00:00Z | 2024-11-11T21:18:45Z | 1 | 0 | 0900006481dd0e45 | ||
| DOT-OST-2003-15060-0016 | DOT | None DOT-OST-2003-15060 | Notice of Action Taken re: Canadian North Inc. c/d/b/a Canadian North | Other | Decision | 2014-04-10T04:00:00Z | 2014 | 4 | 2014-04-10T04:00:00Z | 2014-04-10T18:52:29Z | 0 | 0 | 09000064816ae495 | ||
| DOT-OST-2003-15060-0015 | DOT | None DOT-OST-2003-15060 | Application for Renewal of an Exemption Filed by Canadian North Inc. | Other | Application-Other | 2014-01-17T05:00:00Z | 2014 | 1 | 2014-01-17T05:00:00Z | 2024-11-07T23:02:17Z | 1 | 0 | 090000648151167b | ||
| DOT-OST-2003-15060-0014 | DOT | None DOT-OST-2003-15060 | Notice of Action Taken re: Canadian North Inc. c/o/b/a Canadian North | Other | Decision | 2012-02-24T05:00:00Z | 2012 | 2 | 2012-02-24T05:00:00Z | 2024-11-12T04:38:10Z | 1 | 0 | 0900006480fc065d | ||
| DOT-OST-2003-15060-0013 | DOT | None DOT-OST-2003-15060 | Application for Renewal of an Exemption Filed by Canadian North Inc. | Other | Application | 2012-01-30T05:00:00Z | 2012 | 1 | 2012-01-30T05:00:00Z | 2024-11-07T22:28:11Z | 1 | 0 | 0900006480fa7561 | ||
| DOT-OST-2003-15060-0012 | DOT | None DOT-OST-2003-15060 | Notice of Action Taken re: Canadian North Inc. c/o/b Canadian North | Other | Notice | 2010-03-12T05:00:00Z | 2010 | 3 | 2010-03-12T05:00:00Z | 2024-11-12T04:50:40Z | 1 | 0 | 0900006480abc168 | ||
| DOT-OST-2003-15060-0011 | DOT | None DOT-OST-2003-15060 | Application for Renewal of an Exemption filed by Canadian North, Inc. | Other | Application-Other | 2010-02-19T05:00:00Z | 2010 | 2 | 2010-02-19T05:00:00Z | 2024-11-12T04:48:21Z | 1 | 0 | 0900006480aa5529 | ||
| DOT-OST-2003-15060-0010 | DOT | None DOT-OST-2003-15060 | Notice of Action Taken re: Canadian North Inc. c/o/b Canadian North | Other | Notice | 2008-05-28T04:00:00Z | 2008 | 5 | 2008-05-28T04:00:00Z | 2013-07-27T22:15:11Z | 0 | 0 | 0900006480603e55 | ||
| DOT-OST-2003-15060-0009 | DOT | None DOT-OST-2003-15060 | Application for Renewal of an Exemption Filed by Canadian North Inc. | Other | Application-Other | 2008-05-12T04:00:00Z | 2008 | 5 | 2008-05-12T04:00:00Z | 2013-07-28T01:48:05Z | 0 | 0 | 09000064805a6361 | ||
| DOT-OST-2003-15060-0008 | DOT | None DOT-OST-2003-15060 | Notice of Action Taken re: Canadian North Inc. | Notice | Notice | 2007-02-12T05:00:00Z | 2007 | 2 | 2007-02-12T05:00:00Z | 2007-02-13T04:59:59Z | 2024-11-07T02:15:33Z | 1 | 0 | 09000064802b0cc5 | |
| DOT-OST-2003-15060-0007 | DOT | None DOT-OST-2003-15060 | Application for Renewal of an Exemption Filed by Canadian North Inc. | Other | Application-Other | 2006-07-19T04:00:00Z | 2006 | 7 | 2006-07-19T04:00:00Z | 2006-07-20T03:59:59Z | 2024-11-07T02:15:33Z | 1 | 0 | 09000064802b0cc4 | |
| DOT-OST-2003-15060-0006 | DOT | None DOT-OST-2003-15060 | Notice of Action Taken re: Air Norterra Inc. c/o/b Canadian North | Notice | Notice | 2005-08-15T04:00:00Z | 2005 | 8 | 2005-08-15T04:00:00Z | 2005-08-16T03:59:59Z | 2024-11-07T02:15:33Z | 1 | 0 | 09000064802b0cc3 | |
| DOT-OST-2003-15060-0005 | DOT | None DOT-OST-2003-15060 | Application for Renewal of an Exemption Filed by Air NorTerra Inc. | Other | Application-Other | 2005-07-13T04:00:00Z | 2005 | 7 | 2005-07-13T04:00:00Z | 2005-07-14T03:59:59Z | 2024-11-07T02:15:33Z | 1 | 0 | 09000064802b0cc2 | |
| DOT-OST-2003-15060-0004 | DOT | None DOT-OST-2003-15060 | Notice of Action Taken re Air Norterra Inc. d/b/a Canadian North | Notice | Notice | 2004-07-20T04:00:00Z | 2004 | 7 | 2004-07-20T04:00:00Z | 2004-07-21T03:59:59Z | 2024-11-07T02:15:32Z | 1 | 0 | 09000064802b0cc1 | |
| DOT-OST-2003-15060-0003 | DOT | None DOT-OST-2003-15060 | Application of Renewal of an Exemption Filed by Air Norterra Inc. | Other | Application-Other | 2004-05-19T04:00:00Z | 2004 | 5 | 2004-05-19T04:00:00Z | 2004-05-20T03:59:59Z | 2024-11-07T02:15:32Z | 1 | 0 | 09000064802b0cbd | |
| DOT-OST-2003-15060-0002 | DOT | None DOT-OST-2003-15060 | Notice of Action Taken re Air Norterra Inc. c/o/b Canadian North | Notice | Notice | 2003-07-29T04:00:00Z | 2003 | 7 | 2003-07-29T04:00:00Z | 2003-07-30T03:59:59Z | 2024-11-07T02:15:32Z | 1 | 0 | 09000064802b0cbc | |
| DOT-OST-2003-15060-0001 | DOT | None DOT-OST-2003-15060 | Application for an Exemption Filed by Air Norterra Inc. d/b/a Canadian North | Other | Application-Other | 2003-04-28T04:00:00Z | 2003 | 4 | 2003-04-28T04:00:00Z | 2003-04-29T03:59:59Z | 2024-11-07T02:15:32Z | 1 | 0 | 09000064802b0cba |
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;