home / openregs

documents

Regulatory documents from Regulations.gov including rules, proposed rules, notices, and supporting materials.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

78 rows where docket_id = "DOT-OST-2007-0066" sorted by posted_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: subtype, posted_month, open_for_comment, withdrawn, posted_date (date), comment_start_date (date), comment_end_date (date), last_modified (date)

posted_year 14

  • 2015 14
  • 2008 13
  • 2017 9
  • 2007 7
  • 2009 6
  • 2016 6
  • 2018 6
  • 2019 5
  • 2012 4
  • 2023 3
  • 2013 2
  • 2014 1
  • 2021 1
  • 2022 1

document_type 2

  • Other 76
  • Notice 2

agency_id 1

  • DOT 78
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-2007-0066-0079 DOT None DOT-OST-2007-0066 Notice of Action Taken re: Hainan Airlines Holding Company Limited Other Decision 2023-11-08T05:00:00Z 2023 11 2023-11-08T05:00:00Z   2024-11-12T06:22:10Z   1 0 090000648622b7ea
DOT-OST-2007-0066-0078 DOT None DOT-OST-2007-0066 Application of Hainan Airlines Holding Company Limited for an Exemption Other Application-Other 2023-11-08T05:00:00Z 2023 11 2023-11-08T05:00:00Z   2024-11-12T06:20:59Z   1 0 0900006486228d37
DOT-OST-2007-0066-0077 DOT None DOT-OST-2007-0066 Application of Hainan Airlines Holding Company Limited for Renewal of Exemption Other Application-Other 2023-01-06T05:00:00Z 2023 1 2023-01-06T05:00:00Z   2024-11-12T23:49:55Z   1 0 09000064855a3a81
DOT-OST-2007-0066-0076 DOT None DOT-OST-2007-0066 Notice of Action Taken re: Hainan Airlines Holding Company Limited Other Decision 2022-01-07T05:00:00Z 2022 1 2022-01-07T05:00:00Z   2024-11-07T00:36:21Z   1 0 0900006484f14159
DOT-OST-2007-0066-0075 DOT None DOT-OST-2007-0066 Application of Hainan Airlines Holding Company Limited for an Exemption Other Application-Other 2021-12-06T05:00:00Z 2021 12 2021-12-06T05:00:00Z   2024-11-07T00:34:33Z   1 0 0900006484ea526a
DOT-OST-2007-0066-0074 DOT None DOT-OST-2007-0066 2019-6-14 Final Order Other Order 2019-06-25T04:00:00Z 2019 6 2019-06-25T04:00:00Z   2024-11-12T23:03:32Z   1 0 0900006483d40caa
DOT-OST-2007-0066-0073 DOT None DOT-OST-2007-0066 2019-4-3 Final Order Other Order 2019-04-03T04:00:00Z 2019 4 2019-04-03T04:00:00Z   2024-11-12T22:57:50Z   1 0 0900006483b607d8
DOT-OST-2007-0066-0072 DOT None DOT-OST-2007-0066 2019-3-16 Order Granting Exemption and to Show Cause Other Order 2019-04-02T04:00:00Z 2019 4 2019-04-02T04:00:00Z   2024-11-12T22:58:15Z   1 0 0900006483b5b1fc
DOT-OST-2007-0066-0071 DOT None DOT-OST-2007-0066 Hainan Airlines Holding Company, Ltd. - Amendment to Application for an Exemption and Amended Air Carrier Permit for CTU-ORD Route Other Amendment 2019-02-19T05:00:00Z 2019 2 2019-02-19T05:00:00Z   2024-11-12T22:54:02Z   1 0 0900006483a890a0
DOT-OST-2007-0066-0070 DOT None DOT-OST-2007-0066 Hainan Airlines Holding Company, Ltd. (Amendment to Application for an Exemption and Amended Foreign Air Carrier Permit) Other Amendment 2019-01-28T05:00:00Z 2019 1 2019-01-28T05:00:00Z   2024-11-12T22:53:35Z   1 0 0900006483a1c348
DOT-OST-2007-0066-0069 DOT None DOT-OST-2007-0066 Motion for Confidential Treatment Under Rule 12 Other Motion 2018-12-11T05:00:00Z 2018 12 2018-12-11T05:00:00Z   2024-11-12T22:53:30Z   1 0 0900006483984eab
DOT-OST-2007-0066-0068 DOT None DOT-OST-2007-0066 Application of Hainan Airlines Holding Company Limited for an Exemption and Amended Foreign Air Carrier Permit Other Application-Other 2018-12-11T05:00:00Z 2018 12 2018-12-11T05:00:00Z   2024-11-12T22:51:54Z   1 0 090000648397a956
DOT-OST-2007-0066-0067 DOT None DOT-OST-2007-0066 2018-12-2 Order Granting Exemption and to Show Cause Other Order 2018-12-04T05:00:00Z 2018 12 2018-12-04T05:00:00Z   2024-11-12T22:50:53Z   1 0 090000648393dcda
DOT-OST-2007-0066-0066 DOT None DOT-OST-2007-0066 Hainan Airlines Co., Limited - Updated Ownership Information Other Additional Information 2018-11-14T05:00:00Z 2018 11 2018-11-14T05:00:00Z   2024-11-12T22:50:18Z   1 0 09000064838d7f6a
DOT-OST-2007-0066-0065 DOT None DOT-OST-2007-0066 Motion for Confidential Treatment Under Rule 12 Other Motion 2018-09-05T04:00:00Z 2018 9 2018-09-05T04:00:00Z   2024-11-07T01:37:03Z   1 0 09000064836a7fc3
DOT-OST-2007-0066-0064 DOT None DOT-OST-2007-0066 Application of Hainan Airlines Holding Company Limited for an Exemption and Amended Foreign Air Carrier Permit Other Application-Other 2018-09-05T04:00:00Z 2018 9 2018-09-05T04:00:00Z   2024-11-07T01:36:57Z   1 0 09000064836a6093
DOT-OST-2007-0066-0063 DOT None DOT-OST-2007-0066 2017-8-14 Final Order Other Order 2017-08-15T04:00:00Z 2017 8 2017-08-15T04:00:00Z   2024-11-07T01:08:25Z   1 0 0900006482a32c0e
DOT-OST-2007-0066-0062 DOT None DOT-OST-2007-0066 2017-5-11 Order Granting Exemption and to Show Cause Other Order 2017-05-17T04:00:00Z 2017 5 2017-05-17T04:00:00Z   2024-11-07T00:58:37Z   1 0 09000064825d7aac
DOT-OST-2007-0066-0061 DOT None DOT-OST-2007-0066 2017-4-10 Final Order Other Order 2017-04-14T04:00:00Z 2017 4 2017-04-14T04:00:00Z   2024-11-07T00:54:58Z   1 0 0900006482557283
DOT-OST-2007-0066-0060 DOT None DOT-OST-2007-0066 Motion for Confidential Treatment Under Rule 12 Other Motion 2017-04-04T04:00:00Z 2017 4 2017-04-04T04:00:00Z   2024-11-07T00:57:33Z   1 0 090000648253a922
DOT-OST-2007-0066-0059 DOT None DOT-OST-2007-0066 Application of Hainan Airlines Co., Ltd. for an Exemption and Amended Foreign Air Carrier Permit Other Application-Other 2017-04-04T04:00:00Z 2017 4 2017-04-04T04:00:00Z   2024-11-07T00:55:33Z   1 0 0900006482538c51
DOT-OST-2007-0066-0058 DOT None DOT-OST-2007-0066 2017-1-21 Order Granting Exemption and to Show Cause Other Order 2017-01-18T05:00:00Z 2017 1 2017-01-18T05:00:00Z   2024-11-11T21:35:07Z   1 0 09000064824827db
DOT-OST-2007-0066-0057 DOT None DOT-OST-2007-0066 Answer of American Airlines, Inc. to Application of Hainan Airlines Co., Ltd. Other Answer 2017-01-17T05:00:00Z 2017 1 2017-01-17T05:00:00Z   2024-11-11T21:33:32Z   1 0 090000648247efb6
DOT-OST-2007-0066-0056 DOT None DOT-OST-2007-0066 Motion for Confidential Treatment Under Rule 12 Other Motion 2017-01-05T05:00:00Z 2017 1 2017-01-05T05:00:00Z   2024-11-12T06:17:28Z   1 0 090000648244d755
DOT-OST-2007-0066-0055 DOT None DOT-OST-2007-0066 Application of Hainan Airlines Co., Ltd. for an Exemption and Amended Foreign Air Carrier Permit Other Application-Other 2017-01-03T05:00:00Z 2017 1 2017-01-03T05:00:00Z   2024-11-07T23:52:52Z   1 0 0900006482447c92
DOT-OST-2007-0066-0054 DOT None DOT-OST-2007-0066 2016-12-2 Final Order Other Order 2016-12-06T05:00:00Z 2016 12 2016-12-06T05:00:00Z   2024-11-12T06:17:01Z   1 0 09000064823e5ae1
DOT-OST-2007-0066-0053 DOT None DOT-OST-2007-0066 Motion for Confidential Treatment Under Rule 12 Other Motion 2016-12-02T05:00:00Z 2016 12 2016-12-02T05:00:00Z   2024-11-12T06:17:24Z   1 0 09000064823dc083
DOT-OST-2007-0066-0052 DOT None DOT-OST-2007-0066 Application of Hainan Airlines Co., Ltd. for an Exemption and Amended Foreign Air Carrier Permit Other Application-Other 2016-12-01T05:00:00Z 2016 12 2016-12-01T05:00:00Z   2024-11-12T06:18:13Z   1 0 09000064823d8619
DOT-OST-2007-0066-0051 DOT None DOT-OST-2007-0066 2016-9-9 Order Granting Exemption and to Show Cause Other Order 2016-09-09T04:00:00Z 2016 9 2016-09-09T04:00:00Z   2024-11-11T21:30:50Z   1 0 09000064821eb3ac
DOT-OST-2007-0066-0049 DOT None DOT-OST-2007-0066 Motion for Confidential Treatment Under Rule 12 Other Motion 2016-08-05T04:00:00Z 2016 8 2016-08-05T04:00:00Z   2024-11-12T06:11:44Z   1 0 0900006482159544
DOT-OST-2007-0066-0048 DOT None DOT-OST-2007-0066 Application of Hainan Airlines Co., Ltd. for an Exemption and Amended Foreign Air Carrier Permit Other Application-Other 2016-08-04T04:00:00Z 2016 8 2016-08-04T04:00:00Z   2024-11-12T06:12:48Z   1 0 0900006482155492
DOT-OST-2007-0066-0047 DOT None DOT-OST-2007-0066 2015-11-16 Final Order Other Order 2015-11-19T05:00:00Z 2015 11 2015-11-19T05:00:00Z   2024-11-07T23:33:35Z   1 0 0900006481d5cd3c
DOT-OST-2007-0066-0046 DOT None DOT-OST-2007-0066 2015-8-24 Order Granting Exemption and to Show Cause Other Order 2015-08-26T04:00:00Z 2015 8 2015-08-26T04:00:00Z   2024-11-12T05:42:29Z   1 0 0900006481c3c60f
DOT-OST-2007-0066-0045 DOT None DOT-OST-2007-0066 Application of Hainan Airlines Co., LTD. for an Exemption and Amended Foreign Air Carrier Permit Other Application 2015-07-15T04:00:00Z 2015 7 2015-07-15T04:00:00Z   2015-07-15T21:02:34Z   0 0 0900006481b85121
DOT-OST-2007-0066-0044 DOT None DOT-OST-2007-0066 2015-5-8 Final Order Other Order 2015-05-12T04:00:00Z 2015 5 2015-05-12T04:00:00Z   2024-11-07T23:20:24Z   1 0 0900006481adcd8a
DOT-OST-2007-0066-0043 DOT None DOT-OST-2007-0066 Certificates of Public Convenience and Necessity and Foreign Air Carrier Permits; Applications Notice   2015-03-12T00:00:00Z 2015 3     2024-11-07T23:12:12Z   0 1 0900006481a3f25e
DOT-OST-2007-0066-0042 DOT None DOT-OST-2007-0066 Certificates of Public Convenience and Necessity and Foreign Air Carrier Permits; Applications Notice   2015-03-12T00:00:00Z 2015 3     2024-11-07T23:12:11Z   0 1 0900006481a3f1d0
DOT-OST-2007-0066-0041 DOT None DOT-OST-2007-0066 Hainan Airlines, Co., Limited (Updated Exhibits to its Application) Other Additional Information 2015-02-18T05:00:00Z 2015 2 2015-02-18T05:00:00Z   2024-11-07T23:15:36Z   1 0 0900006481a07027
DOT-OST-2007-0066-0040 DOT None DOT-OST-2007-0066 2015-2-7 Order Granting Exemption and to Show Cause Other Order 2015-02-13T05:00:00Z 2015 2 2015-02-13T05:00:00Z   2024-11-07T23:15:33Z   1 0 0900006481a0324e
DOT-OST-2007-0066-0038 DOT None DOT-OST-2007-0066 Norman Y. Mineta San Jose International Airport (Correspondence) Other Correspondence 2015-01-26T05:00:00Z 2015 1 2015-01-26T05:00:00Z   2024-11-11T20:55:43Z   1 0 09000064819dd306
DOT-OST-2007-0066-0036 DOT None DOT-OST-2007-0066 Sam Liccardo, Mayor of the City of San Jose (Correspondence) Other Correspondence 2015-01-26T05:00:00Z 2015 1 2015-01-26T05:00:00Z   2024-11-12T05:29:47Z   1 0 09000064819dd28f
DOT-OST-2007-0066-0039 DOT None DOT-OST-2007-0066 San Jose Silicon Valley Chamber of Commerce (Correspondence) Other Correspondence 2015-01-26T05:00:00Z 2015 1 2015-01-26T05:00:00Z   2024-11-11T20:55:44Z   1 0 09000064819dd04b
DOT-OST-2007-0066-0037 DOT None DOT-OST-2007-0066 Silicon Valley Leadership Group (Correspondence) Other Correspondence 2015-01-26T05:00:00Z 2015 1 2015-01-26T05:00:00Z   2024-11-11T20:55:44Z   1 0 09000064819dd2db
DOT-OST-2007-0066-0035 DOT None DOT-OST-2007-0066 Application of Hainan Airlines Co., Ltd. for an Exemption and Amended Foreign Air Carrier Permit Other Application-SubPartB 2015-01-20T05:00:00Z 2015 1 2015-01-20T05:00:00Z   2024-11-12T05:29:01Z   1 0 09000064819d2ff2
DOT-OST-2007-0066-0034 DOT None DOT-OST-2007-0066 Application of Hainan Airlines Co., Ltd. for an Exemption and Amended Foreign Air Carrier Permit Other Application-SubPartB 2015-01-14T05:00:00Z 2015 1 2015-01-14T05:00:00Z   2024-11-12T05:31:32Z   1 0 09000064819c9df7
DOT-OST-2007-0066-0033 DOT None DOT-OST-2007-0066 2014-2-15 Final Order Other Order 2014-02-21T05:00:00Z 2014 2 2014-02-21T05:00:00Z   2024-11-11T20:49:27Z   1 0 0900006481595510
DOT-OST-2007-0066-0032 DOT None DOT-OST-2007-0066 2013-11-26 Order Granting Exemption and to Show Cause Other Order 2013-11-27T05:00:00Z 2013 11 2013-11-27T05:00:00Z   2024-11-12T05:23:00Z   1 0 090000648149db4b
DOT-OST-2007-0066-0031 DOT None DOT-OST-2007-0066 Application of Hainan Airlines Co., Ltd. for an Exemption and Amended Foreign Air Carrier Permit Other Application-SubPartB 2013-11-13T05:00:00Z 2013 11 2013-11-13T05:00:00Z   2024-11-12T05:24:36Z   1 0 0900006481477a83
DOT-OST-2007-0066-0030 DOT None DOT-OST-2007-0066 2012-10-15 Final Order Other Order 2012-10-11T04:00:00Z 2012 10 2012-10-11T04:00:00Z   2024-11-11T20:41:41Z   1 0 090000648113c455
DOT-OST-2007-0066-0029 DOT None DOT-OST-2007-0066 2012-7-14 Order Granting Exemption and To Show Cause Other Order 2012-07-19T04:00:00Z 2012 7 2012-07-19T04:00:00Z   2024-11-11T20:42:39Z   1 0 09000064810a3ea3
DOT-OST-2007-0066-0028 DOT None DOT-OST-2007-0066 Chicago Department of Aviation Other Letter(s) in Support 2012-07-09T04:00:00Z 2012 7 2012-07-09T04:00:00Z   2012-07-09T13:09:00Z   0 0 0900006481079657
DOT-OST-2007-0066-0027 DOT None DOT-OST-2007-0066 Application of Hainan Airlines Co., Ltd. for an Exemption and Amended Foreign Air Carrier Permit Other Application-SubPartB 2012-06-28T04:00:00Z 2012 6 2012-06-28T04:00:00Z   2024-11-11T20:40:14Z   1 0 090000648106dda9
DOT-OST-2007-0066-0026 DOT None DOT-OST-2007-0066 2009-12-10 Final Order Other Order 2009-12-15T05:00:00Z 2009 12 2009-12-15T05:00:00Z   2018-02-27T15:32:05Z   0 0 0900006480a6b313
DOT-OST-2007-0066-0025 DOT None DOT-OST-2007-0066 2009-9-11 Order Granting Exemption and to Show Cause Other Order 2009-09-18T04:00:00Z 2009 9 2009-09-18T04:00:00Z   2024-11-12T04:40:54Z   1 0 0900006480a26e83
DOT-OST-2007-0066-0024 DOT None DOT-OST-2007-0066 Governor Linda Lingle Other Correspondence 2009-08-18T04:00:00Z 2009 8 2009-08-18T04:00:00Z   2013-07-27T22:51:43Z   0 0 0900006480a07d75
DOT-OST-2007-0066-0023 DOT None DOT-OST-2007-0066 Hainan Airlines Co., Limited Other Correspondence 2009-08-04T04:00:00Z 2009 8 2009-08-04T04:00:00Z   2013-07-27T22:50:34Z   0 0 09000064809fde78
DOT-OST-2007-0066-0022 DOT None DOT-OST-2007-0066 2009-5-7 Final Order Other Order 2009-05-11T04:00:00Z 2009 5 2009-05-11T04:00:00Z   2013-07-27T22:44:30Z   0 0 0900006480988519
DOT-OST-2007-0066-0021 DOT None DOT-OST-2007-0066 DANA Liquidating Trust Other Correspondence 2009-03-09T04:00:00Z 2009 3 2009-03-09T04:00:00Z   2013-07-27T22:39:27Z   0 0 09000064808ea41b
DOT-OST-2007-0066-0020 DOT None DOT-OST-2007-0066 DANA Liquidating Trust Other Correspondence 2008-12-30T05:00:00Z 2008 12 2008-12-30T05:00:00Z   2013-07-27T22:34:27Z   0 0 09000064807f92be
DOT-OST-2007-0066-0019 DOT None DOT-OST-2007-0066 Dana Liquidating Trust Other Correspondence 2008-11-05T05:00:00Z 2008 11 2008-11-05T05:00:00Z   2013-07-27T22:29:35Z   0 0 0900006480792b86
DOT-OST-2007-0066-0018 DOT None DOT-OST-2007-0066 Dana Liquidating Trust Other Correspondence 2008-10-29T04:00:00Z 2008 10 2008-10-29T04:00:00Z   2013-07-27T22:28:52Z   0 0 090000648077f58a
DOT-OST-2007-0066-0017 DOT None DOT-OST-2007-0066 Response of Dana Liquidating Trust to Hainan Airlines Co., Limited’s Reply to Dana Liquidating Trust for Leave to File and Petition for Reconsideration of Grant of Exemption Authority; Answer in Opposition to Grant of Amended Foreign Air Carrier Permit; and Motion to Revoke 14 CFR Part 212 Statement of Authorization Other Response(s) 2008-10-08T04:00:00Z 2008 10 2008-10-08T04:00:00Z   2013-07-27T22:26:58Z   0 0 090000648073cba8
DOT-OST-2007-0066-0016 DOT None DOT-OST-2007-0066 Hainan Airlines, Co., Limited Other Correspondence 2008-10-03T04:00:00Z 2008 10 2008-10-03T04:00:00Z   2013-07-27T22:26:36Z   0 0 0900006480733c1d
DOT-OST-2007-0066-0015 DOT None DOT-OST-2007-0066 DANA Liquidating Trust Other Correspondence 2008-09-24T04:00:00Z 2008 9 2008-09-24T04:00:00Z   2024-11-12T04:23:31Z   1 0 090000648071e199
DOT-OST-2007-0066-0014 DOT None DOT-OST-2007-0066 2008-9-17 Order Granting Exemption, Statement of Authorization, and to Show Cause Other Order 2008-09-12T04:00:00Z 2008 9 2008-09-12T04:00:00Z   2013-07-27T22:24:52Z   0 0 0900006480702a43
DOT-OST-2007-0066-0013 DOT None DOT-OST-2007-0066 Application of Hainan Airlines Co. Limited for an Amended Foreign Air Carrier Permit, Exemption Authority, and Statement of Authorization Other Application-SubPartB 2008-08-19T04:00:00Z 2008 8 2008-08-19T04:00:00Z   2024-11-12T04:17:34Z   1 0 09000064806cdbc1
DOT-OST-2007-0066-0012 DOT None DOT-OST-2007-0066 2008-4-29 Final Order Other Order 2008-04-18T04:00:00Z 2008 4 2008-04-18T04:00:00Z   2013-07-27T21:24:35Z   0 0 09000064805127a1
DOT-OST-2007-0066-0011 DOT None DOT-OST-2007-0066 Christine O. Gregoire, Governor of the State of Washington Other Correspondence 2008-02-14T05:00:00Z 2008 2 2008-02-14T05:00:00Z   2024-11-07T21:50:22Z   1 0 09000064803af07f
DOT-OST-2007-0066-0010 DOT None DOT-OST-2007-0066 2008-1-29 Order Granting Exemption and to Show Cause Other Order 2008-01-31T05:00:00Z 2008 1 2008-01-31T05:00:00Z   2013-07-27T20:33:11Z   0 0 09000064803a604a
DOT-OST-2007-0066-0009 DOT None DOT-OST-2007-0066 Hainan Airlines Co., Limited Other Correspondence 2008-01-08T05:00:00Z 2008 1 2008-01-08T05:00:00Z   2013-07-27T20:31:29Z   0 0 09000064803903e1
DOT-OST-2007-0066-0008 DOT None DOT-OST-2007-0066 Motion of Hainan Airlines, Co., Limited for Confidential Treatment Other Motion 2008-01-04T05:00:00Z 2008 1 2008-01-04T05:00:00Z   2024-11-12T04:04:59Z   1 0 0900006480382476
DOT-OST-2007-0066-0006 DOT None DOT-OST-2007-0066 Washington State China Relations Council Other Correspondence 2007-12-27T05:00:00Z 2007 12 2007-12-27T05:00:00Z   2013-08-11T02:28:29Z   0 0 090000648037e9b7
DOT-OST-2007-0066-0004 DOT None DOT-OST-2007-0066 Association of Washington Business Other Correspondence 2007-12-27T05:00:00Z 2007 12 2007-12-27T05:00:00Z   2024-11-07T21:45:07Z   1 0 090000648037e99a
DOT-OST-2007-0066-0005 DOT None DOT-OST-2007-0066 Seattle's Convention and Visitors Bureau Other Correspondence 2007-12-27T05:00:00Z 2007 12 2007-12-27T05:00:00Z   2024-11-07T21:45:08Z   1 0 090000648037e9af
DOT-OST-2007-0066-0007 DOT None DOT-OST-2007-0066 Greater Seattle Chameber of Commerce Other Correspondence 2007-12-27T05:00:00Z 2007 12 2007-12-27T05:00:00Z   2013-07-27T20:28:50Z   0 0 090000648037e9ba
DOT-OST-2007-0066-0003 DOT None DOT-OST-2007-0066 Port of Seattle Other Correspondence 2007-12-11T05:00:00Z 2007 12 2007-12-11T05:00:00Z   2013-07-27T20:28:00Z   0 0 0900006480377aeb
DOT-OST-2007-0066-0002 DOT None DOT-OST-2007-0066 Port of Seattle Other Correspondence 2007-11-30T05:00:00Z 2007 11 2007-11-30T05:00:00Z   2024-11-11T21:36:36Z   1 0 090000648036b3a0
DOT-OST-2007-0066-0001 DOT None DOT-OST-2007-0066 Application of Hainan Airlines Co., Limited for an Exemption and Foreign Air Carrier Permit Other Application-SubPartB 2007-11-14T05:00:00Z 2007 11 2007-11-14T05:00:00Z 2007-11-30T04:59:59Z 2024-11-07T21:47:21Z   1 0 090000648036263c

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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;
Powered by Datasette · Queries took 14.471ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API