documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
97 rows where docket_id = "DOT-OST-1996-1901" sorted by posted_date descending
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)
| 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-1996-1901-0105 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Department of Transportation's Response to Letter Dated November 6, 2014 | Other | Response(s) | 2015-02-24T05:00:00Z | 2015 | 2 | 2015-02-24T05:00:00Z | 2024-11-07T23:16:25Z | 1 | 0 | 0900006481a0c96f | ||
| DOT-OST-1996-1901-0104 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Alamogordo-White Sands Regional Airport (Correspondence Requesting the Department Request Proposals to Provide Subsidized Service) | Other | Correspondence | 2014-12-30T05:00:00Z | 2014 | 12 | 2014-12-30T05:00:00Z | 2024-11-12T05:31:14Z | 1 | 0 | 090000648197db3e | ||
| DOT-OST-1996-1901-0103 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Final Order 2012-2-14 Terminating Eligibility And Allowing Suspension Of Service | Other | Order | 2012-02-17T05:00:00Z | 2012 | 2 | 2012-02-17T05:00:00Z | 2024-11-12T04:59:22Z | 1 | 0 | 0900006480fb96dd | ||
| DOT-OST-1996-1901-0102 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Pacific Wings, L.L.C. d/b/a New Mexico Airlines | Other | Correspondence | 2012-01-06T05:00:00Z | 2012 | 1 | 2012-01-06T05:00:00Z | 2024-11-11T21:36:23Z | 1 | 0 | 0900006480f8ea51 | ||
| DOT-OST-1996-1901-0101 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Ron Griggs, Mayor of the City of Alamogordo | Other | Correspondence | 2012-01-04T05:00:00Z | 2012 | 1 | 2012-01-04T05:00:00Z | 2024-11-08T03:46:53Z | 1 | 0 | 0900006480f8ce77 | ||
| DOT-OST-1996-1901-0100 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | 2011-12-8 Tentative Order Regarding Termination of EAS Eligibility and Setting Short-Term Subsidy Rates | Other | Order | 2011-12-15T05:00:00Z | 2011 | 12 | 2011-12-15T05:00:00Z | 2024-11-11T21:35:48Z | 1 | 0 | 0900006480f83d35 | ||
| DOT-OST-1996-1901-0099 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Proposal of Pacific Wings L.L.C. dba New Mexico Airlines | Other | Proposal(s) | 2011-08-11T04:00:00Z | 2011 | 8 | 2011-08-11T04:00:00Z | 2024-11-07T22:33:27Z | 1 | 0 | 0900006480edd02b | ||
| DOT-OST-1996-1901-0098 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Order 2011-7-2 Requesting Proposals | Other | Order | 2011-07-01T04:00:00Z | 2011 | 7 | 2011-07-01T04:00:00Z | 2011-07-01T19:08:21Z | 0 | 0 | 0900006480eb8503 | ||
| DOT-OST-1996-1901-0097 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | 2009-11-28 Erratum | Other | Order | 2009-11-30T05:00:00Z | 2009 | 11 | 2009-11-30T05:00:00Z | 2024-11-12T04:47:06Z | 1 | 0 | 0900006480a60ad1 | ||
| DOT-OST-1996-1901-0096 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | 2009-11-28 Erratum | Other | 2009-11-30T00:00:00Z | 2009 | 11 | 2024-11-12T04:47:02Z | 0 | 1 | 0900006480a60a93 | ||||
| DOT-OST-1996-1901-0095 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | 2009-11-28 Erratum | Other | 2009-11-30T00:00:00Z | 2009 | 11 | 2013-07-27T23:01:05Z | 0 | 1 | 0900006480a60a7c | ||||
| DOT-OST-1996-1901-0094 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | 2009-11-14 Order Selecting Carrier and Setting Final Subsidy | Other | Order | 2009-11-19T05:00:00Z | 2009 | 11 | 2009-11-19T05:00:00Z | 2024-11-12T04:46:52Z | 1 | 0 | 0900006480a5af43 | ||
| DOT-OST-1996-1901-0093 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | FHWA Driving Miles to (Nearest Large or Medium Hub Airport) Albuquerque | Other | Correspondence | 2009-11-05T05:00:00Z | 2009 | 11 | 2009-11-05T05:00:00Z | 2024-11-07T22:09:55Z | 1 | 0 | 0900006480a525a6 | ||
| DOT-OST-1996-1901-0092 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | FHWA Driving Miles to (Nearest Large or Medium Hub Airport) Albuquerque | Supporting & Related Material | 2009-11-05T00:00:00Z | 2009 | 11 | 2024-11-12T04:47:15Z | 0 | 1 | 0900006480a52107 | ||||
| DOT-OST-1996-1901-0090 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Alamogordo - White Sand Regional Airport | Other | Letter(s) | 2009-09-28T04:00:00Z | 2009 | 9 | 2009-09-28T04:00:00Z | 2024-11-12T04:44:49Z | 1 | 0 | 0900006480a2bd9b | ||
| DOT-OST-1996-1901-0089 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Pacific Wings, L.L.C. | Other | Proposal(s) | 2009-09-18T04:00:00Z | 2009 | 9 | 2009-09-18T04:00:00Z | 2024-11-12T04:46:34Z | 1 | 0 | 0900006480a26d98 | ||
| DOT-OST-1996-1901-0088 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | 2009-8-15 Order Requesting Proposals | Other | Order | 2009-08-24T04:00:00Z | 2009 | 8 | 2009-08-24T04:00:00Z | 2024-11-12T04:40:25Z | 1 | 0 | 0900006480a0fbe7 | ||
| DOT-OST-1996-1901-0087 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | 2008-6-1 Order Setting Final Rates for Air Midwest | Other | Order | 2008-06-02T04:00:00Z | 2008 | 6 | 2008-06-02T04:00:00Z | 2013-07-27T22:15:31Z | 0 | 0 | 090000648060c5c9 | ||
| DOT-OST-1996-1901-0086 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | 2007-12-15 Order Extending Service Obligation | Other | Order | 2007-12-20T05:00:00Z | 2007 | 12 | 2007-12-20T05:00:00Z | 2024-11-07T21:46:22Z | 1 | 0 | 090000648037ce8f | ||
| DOT-OST-1996-1901-0085 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | 2007-12-10 Order Approving an Alternate Service Pattern | Other | Order | 2007-12-17T05:00:00Z | 2007 | 12 | 2007-12-17T05:00:00Z | 2024-11-08T03:46:25Z | 1 | 0 | 090000648037b2fa | ||
| DOT-OST-1996-1901-0084 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | City of Alamogordo | Other | Correspondence | 2007-12-04T05:00:00Z | 2007 | 12 | 2007-12-04T05:00:00Z | 2008-01-07T22:52:00Z | 0 | 0 | 090000648036ff6f | ||
| DOT-OST-1996-1901-0083 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | 2007-11-16 Order Extending Service Obligation | Other | Order | 2007-11-21T05:00:00Z | 2007 | 11 | 2024-11-07T21:47:26Z | 1 | 0 | 0900006480367336 | |||
| DOT-OST-1996-1901-0082 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | 2007-10-17 Order Extending Service Obligation | Other | Order | 2007-10-15T04:00:00Z | 2007 | 10 | 2007-10-15T04:00:00Z | 2024-11-07T17:41:43Z | 1 | 0 | 09000064803009f0 | ||
| DOT-OST-1996-1901-0081 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | 2007-9-29 Order Selecting Carrier and Setting Final Subsidy Rates | Other | Order | 2007-09-26T04:00:00Z | 2007 | 9 | 2007-09-26T04:00:00Z | 2007-09-27T03:59:59Z | 2024-11-08T05:30:59Z | 1 | 0 | 09000064802e885a | |
| DOT-OST-1996-1901-0080 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | 2007-9-1 Order Extending Service Obligation | Other | Order | 2007-09-04T04:00:00Z | 2007 | 9 | 2007-09-04T04:00:00Z | 2007-09-05T03:59:59Z | 2024-11-11T21:45:45Z | 1 | 0 | 09000064802a2cf0 | |
| DOT-OST-1996-1901-0073 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | U.S. DOT/FAA - Request for Final Comments | Other | Request | 2007-08-10T04:00:00Z | 2007 | 8 | 2007-08-10T04:00:00Z | 2007-08-11T03:59:59Z | 2024-11-11T21:45:23Z | 1 | 0 | 09000064802a2ce8 | |
| DOT-OST-1996-1901-0076 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | U.S. DOT/OST - Request for Final Comments | Other | Request | 2007-08-10T04:00:00Z | 2007 | 8 | 2007-08-10T04:00:00Z | 2007-08-11T03:59:59Z | 2024-11-11T21:45:45Z | 1 | 0 | 09000064802a2ceb | |
| DOT-OST-1996-1901-0075 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | U.S. DOT/OST - Request for Final Comments | Other | Request | 2007-08-10T04:00:00Z | 2007 | 8 | 2007-08-10T04:00:00Z | 2007-08-11T03:59:59Z | 2024-11-11T21:45:45Z | 1 | 0 | 09000064802a2cea | |
| DOT-OST-1996-1901-0074 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | U.S. DOT/OST - Request for Final Comments | Other | Request | 2007-08-10T04:00:00Z | 2007 | 8 | 2007-08-10T04:00:00Z | 2007-08-11T03:59:59Z | 2024-11-11T21:45:45Z | 1 | 0 | 09000064802a2ce9 | |
| DOT-OST-1996-1901-0077 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | U.S. DOT/OST - Request for Final Comments | Other | Request | 2007-08-10T04:00:00Z | 2007 | 8 | 2007-08-10T04:00:00Z | 2007-08-11T03:59:59Z | 2024-11-11T21:45:45Z | 1 | 0 | 09000064802a2cec | |
| DOT-OST-1996-1901-0071 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Pacific Wings, L.L.C. dba New Mexico Airlines | Other | Proposal(s) | 2007-08-09T04:00:00Z | 2007 | 8 | 2007-08-09T04:00:00Z | 2007-08-10T03:59:59Z | 2024-11-07T21:46:52Z | 1 | 0 | 09000064803823e7 | |
| DOT-OST-1996-1901-0070 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Great Lakes Aviation, Ltd. | Other | Proposal(s) | 2007-08-08T04:00:00Z | 2007 | 8 | 2007-08-08T04:00:00Z | 2007-08-09T03:59:59Z | 2024-11-11T21:45:23Z | 1 | 0 | 09000064802a2ce6 | |
| DOT-OST-1996-1901-0072 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Mesa Air Group, Inc., d/b/a Air Midwest | Other | Proposal(s) | 2007-08-08T04:00:00Z | 2007 | 8 | 2007-08-08T04:00:00Z | 2007-08-09T03:59:59Z | 2024-11-11T21:45:23Z | 1 | 0 | 09000064802a2ce7 | |
| DOT-OST-1996-1901-0069 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Notice | Notice | Notice | 2007-07-12T04:00:00Z | 2007 | 7 | 2007-07-12T04:00:00Z | 2007-07-13T03:59:59Z | 2024-11-11T21:45:23Z | 1 | 0 | 09000064802a2ce4 | |
| DOT-OST-1996-1901-0068 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | 2007-6-13 Order Prohibiting Suspension of Service And Requesting Proposals | Other | Order | 2007-06-18T04:00:00Z | 2007 | 6 | 2007-06-18T04:00:00Z | 2007-06-19T03:59:59Z | 2024-11-11T21:45:23Z | 1 | 0 | 09000064802a2ce3 | |
| DOT-OST-1996-1901-0067 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | City of Alamogordo | Other | Correspondence | 2007-06-05T04:00:00Z | 2007 | 6 | 2007-06-05T04:00:00Z | 2007-06-06T03:59:59Z | 2024-11-11T21:45:22Z | 1 | 0 | 09000064802a2ce2 | |
| DOT-OST-1996-1901-0066-0002 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Notice of Air Midwest, Inc. to Terminate Scheduled Air Service at Alamogordo, New Mexico | Notice | Notice | 2007-05-22T04:00:00Z | 2007 | 5 | 2007-05-22T04:00:00Z | 2007-05-23T03:59:59Z | 2024-11-11T21:45:22Z | 1 | 0 | 09000064802a2ce1 | |
| DOT-OST-1996-1901-0066-0001 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Notice of Air Midwest, Inc. to Terminate Scheduled Air Service at Alamogordo, New Mexico | Notice | Notice | 2007-05-22T04:00:00Z | 2007 | 5 | 2007-05-22T04:00:00Z | 2007-05-23T03:59:59Z | 2024-11-11T21:45:22Z | 1 | 0 | 09000064802a2ce0 | |
| DOT-OST-1996-1901-0065 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | City of Alamogordo | Other | Correspondence | 2007-04-04T04:00:00Z | 2007 | 4 | 2007-04-04T04:00:00Z | 2007-04-05T03:59:59Z | 2024-11-11T21:45:22Z | 1 | 0 | 09000064802a2cdf | |
| DOT-OST-1996-1901-0063 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Department of the Air Force | Other | Correspondence | 2006-07-31T04:00:00Z | 2006 | 7 | 2006-07-31T04:00:00Z | 2006-08-01T03:59:59Z | 2024-11-11T21:45:22Z | 1 | 0 | 09000064802a2cdd | |
| DOT-OST-1996-1901-0062 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | The Honorable Jeff Bingaman | Other | Correspondence | 2006-07-07T04:00:00Z | 2006 | 7 | 2006-07-07T04:00:00Z | 2006-07-08T03:59:59Z | 2024-11-11T21:45:02Z | 1 | 0 | 09000064802a2cdc | |
| DOT-OST-1996-1901-0061 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | 2006-5-24 Order Tentatively Selecting Carrier | Other | Order | 2006-05-26T04:00:00Z | 2006 | 5 | 2006-05-26T04:00:00Z | 2006-05-27T03:59:59Z | 2024-11-11T21:45:01Z | 1 | 0 | 09000064802a2cdb | |
| DOT-OST-1996-1901-0060 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | City of Alamogordo | Other | Correspondence | 2006-05-11T04:00:00Z | 2006 | 5 | 2006-05-11T04:00:00Z | 2006-05-12T03:59:59Z | 2024-11-11T21:45:01Z | 1 | 0 | 09000064802a2cda | |
| DOT-OST-1996-1901-0059 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Mesa Air Group, Inc. d/b/a Air Midwest | Other | Correspondence | 2006-05-03T04:00:00Z | 2006 | 5 | 2006-05-03T04:00:00Z | 2006-05-04T03:59:59Z | 2024-11-11T21:45:01Z | 1 | 0 | 09000064802a2cd8 | |
| DOT-OST-1996-1901-0057 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | The Honorable David E. Carroll | Other | Letter(s) | 2006-04-27T04:00:00Z | 2006 | 4 | 2006-04-27T04:00:00Z | 2006-04-28T03:59:59Z | 2024-11-11T21:45:01Z | 1 | 0 | 09000064802a2cd6 | |
| DOT-OST-1996-1901-0058 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Rudy Clark | Other | Letter(s) | 2006-04-27T04:00:00Z | 2006 | 4 | 2006-04-27T04:00:00Z | 2006-04-28T03:59:59Z | 2024-11-11T21:45:01Z | 1 | 0 | 09000064802a2cd7 | |
| DOT-OST-1996-1901-0054 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Mesa Air Group, Inc. d/b/a Air Midwest | Other | Proposal(s) | 2006-04-17T04:00:00Z | 2006 | 4 | 2006-04-17T04:00:00Z | 2006-04-18T03:59:59Z | 2024-11-11T21:45:00Z | 1 | 0 | 09000064802a2cd3 | |
| DOT-OST-1996-1901-0056 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Proposal to Provide Essential Air Service at Alamogordo/Holloman Air Force Base, New Mexico | Other | Proposal(s) | 2006-04-17T04:00:00Z | 2006 | 4 | 2006-04-17T04:00:00Z | 2006-04-18T03:59:59Z | 2024-11-11T21:45:01Z | 1 | 0 | 09000064802a2cd5 | |
| DOT-OST-1996-1901-0055 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Island Express Airlines, LLC | Other | Proposal(s) | 2006-04-17T04:00:00Z | 2006 | 4 | 2006-04-17T04:00:00Z | 2006-04-18T03:59:59Z | 2024-11-11T21:45:00Z | 1 | 0 | 09000064802a2cd4 | |
| DOT-OST-1996-1901-0053 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Request to Correct Distance Measurement between the Community of Alamogordo/Holloman AFB, NM to the nearest L/M Hub; and Removal of Subsidy Cap Limitation;In re DOT Order # 2006-3-26; Docket OST-1996-1901 | Other | Letter(s) | 2006-04-04T04:00:00Z | 2006 | 4 | 2006-04-04T04:00:00Z | 2006-04-05T03:59:59Z | 2024-11-11T21:45:00Z | 1 | 0 | 09000064802a2cd2 | |
| DOT-OST-1996-1901-0052 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | 2006-3-26 Order Requesting Proposals on an Emergency Basis | Other | Order | 2006-03-27T05:00:00Z | 2006 | 3 | 2006-03-27T05:00:00Z | 2006-03-28T04:59:59Z | 2024-11-11T21:45:00Z | 1 | 0 | 09000064802a2cd1 | |
| DOT-OST-1996-1901-0051 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Extension of Qualification of Application for Essential Air Service Contract | Other | Request | 2005-12-14T05:00:00Z | 2005 | 12 | 2005-12-14T05:00:00Z | 2005-12-15T04:59:59Z | 2024-11-11T21:44:42Z | 1 | 0 | 09000064802a2cd0 | |
| DOT-OST-1996-1901-0050 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | 2005-10-16 Order Selecting Carrier | Other | Order | 2005-10-18T04:00:00Z | 2005 | 10 | 2005-10-18T04:00:00Z | 2005-10-19T03:59:59Z | 2024-11-11T21:44:42Z | 1 | 0 | 09000064802a2ccf | |
| DOT-OST-1996-1901-0046 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | City of Alamogordo | Other | Request | 2005-08-25T04:00:00Z | 2005 | 8 | 2005-08-25T04:00:00Z | 2005-08-26T03:59:59Z | 2024-11-11T21:44:42Z | 1 | 0 | 09000064802a2cca | |
| DOT-OST-1996-1901-0047 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Grant of Extension to File Comments on Carrier Selection | Other | Letter(s) | 2005-08-25T04:00:00Z | 2005 | 8 | 2005-08-25T04:00:00Z | 2005-08-26T03:59:59Z | 2024-11-11T21:44:42Z | 1 | 0 | 09000064802a2ccb | |
| DOT-OST-1996-1901-0045 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Request for the Comments of the Mayor of Alamogordo | Other | Request | 2005-08-18T04:00:00Z | 2005 | 8 | 2005-08-18T04:00:00Z | 2005-08-19T03:59:59Z | 2024-11-11T21:44:41Z | 1 | 0 | 09000064802a2cc9 | |
| DOT-OST-1996-1901-0042 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Request for the Comments of the Director, New Mexico Department of Transportation, Aviation Division | Other | Request | 2005-08-18T04:00:00Z | 2005 | 8 | 2005-08-18T04:00:00Z | 2005-08-19T03:59:59Z | 2024-11-11T21:44:41Z | 1 | 0 | 09000064802a2cc6 | |
| DOT-OST-1996-1901-0043 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Request for the Comments of the Commanding Officer, Holloman Air Force Base | Other | Request | 2005-08-18T04:00:00Z | 2005 | 8 | 2005-08-18T04:00:00Z | 2005-08-19T03:59:59Z | 2024-11-11T21:44:41Z | 1 | 0 | 09000064802a2cc7 | |
| DOT-OST-1996-1901-0044 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Request for the Comments of the Airport Manager, White Sands Regional Airport | Other | Request | 2005-08-18T04:00:00Z | 2005 | 8 | 2005-08-18T04:00:00Z | 2005-08-19T03:59:59Z | 2024-11-11T21:44:41Z | 1 | 0 | 09000064802a2cc8 | |
| DOT-OST-1996-1901-0041 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Proposal to Provide Essential Air Service | Other | Proposal(s) | 2005-08-17T04:00:00Z | 2005 | 8 | 2005-08-17T04:00:00Z | 2005-08-18T03:59:59Z | 2024-11-11T21:44:41Z | 1 | 0 | 09000064802a2cc5 | |
| DOT-OST-1996-1901-0040 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Proposal of Valley, Inc. Air Express | Other | Proposal(s) | 2005-08-15T04:00:00Z | 2005 | 8 | 2005-08-15T04:00:00Z | 2005-08-16T03:59:59Z | 2024-11-11T21:44:23Z | 1 | 0 | 09000064802a2cc4 | |
| DOT-OST-1996-1901-0039 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | 2005-7-26 Order Requesting Proposals on an Emergency Basis | Other | Order | 2005-07-27T04:00:00Z | 2005 | 7 | 2005-07-27T04:00:00Z | 2005-07-28T03:59:59Z | 2024-11-11T21:44:23Z | 1 | 0 | 09000064802a2cc2 | |
| DOT-OST-1996-1901-0038 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Notice of Service Cancellation of Westward Airways, Inc. | Notice | Notice | 2005-07-25T04:00:00Z | 2005 | 7 | 2005-07-25T04:00:00Z | 2005-07-26T03:59:59Z | 2024-11-11T21:44:08Z | 1 | 0 | 09000064802a2cc1 | |
| DOT-OST-1996-1901-0037 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | 2004-10-9 Order Selecting Carrier | Other | Order | 2004-10-18T04:00:00Z | 2004 | 10 | 2004-10-18T04:00:00Z | 2004-10-19T03:59:59Z | 2024-11-11T21:44:07Z | 1 | 0 | 09000064802a2cc0 | |
| DOT-OST-1996-1901-0036 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | A.R.C. | Other | Correspondence | 2004-10-04T04:00:00Z | 2004 | 10 | 2004-10-04T04:00:00Z | 2004-10-05T03:59:59Z | 2024-11-11T21:44:07Z | 1 | 0 | 09000064802a2cbf | |
| DOT-OST-1996-1901-0033 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Notice of Extension | Notice | Notice | 2004-08-11T04:00:00Z | 2004 | 8 | 2004-08-11T04:00:00Z | 2004-08-12T03:59:59Z | 2024-11-11T21:44:07Z | 1 | 0 | 09000064802a2cbc | |
| DOT-OST-1996-1901-0031 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | City of Alamogordo | Other | Request | 2004-08-10T04:00:00Z | 2004 | 8 | 2004-08-10T04:00:00Z | 2004-08-11T03:59:59Z | 2024-11-11T21:44:07Z | 1 | 0 | 09000064802a2cba | |
| DOT-OST-1996-1901-0030 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Great Lakes Aviation. Ltd. | Other | Certificate of Service | 2004-08-04T04:00:00Z | 2004 | 8 | 2004-08-04T04:00:00Z | 2004-08-05T03:59:59Z | 2024-11-11T21:44:07Z | 1 | 0 | 09000064802a2cb9 | |
| DOT-OST-1996-1901-0028 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Brigadier General Kurt Cichowski | Other | Letter(s) | 2004-07-26T04:00:00Z | 2004 | 7 | 2004-07-26T04:00:00Z | 2004-07-27T03:59:59Z | 2024-11-11T21:43:48Z | 1 | 0 | 09000064802a2cb6 | |
| DOT-OST-1996-1901-0027 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Rudy Clark, Manager of White Sands Regional Airport | Other | Letter(s) | 2004-07-26T04:00:00Z | 2004 | 7 | 2004-07-26T04:00:00Z | 2004-07-27T03:59:59Z | 2024-11-11T21:43:48Z | 1 | 0 | 09000064802a2cb5 | |
| DOT-OST-1996-1901-0029 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | The Honorable Donald E. Carroll | Other | Letter(s) | 2004-07-26T04:00:00Z | 2004 | 7 | 2004-07-26T04:00:00Z | 2004-07-27T03:59:59Z | 2024-11-11T21:44:07Z | 1 | 0 | 09000064802a2cb7 | |
| DOT-OST-1996-1901-0026 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Wayne P. York, Acting Director for New Mexico Department of Transportation, Aviaition Division | Other | Letter(s) | 2004-07-26T04:00:00Z | 2004 | 7 | 2004-07-26T04:00:00Z | 2004-07-27T03:59:59Z | 2024-11-11T21:43:48Z | 1 | 0 | 09000064802a2cb4 | |
| DOT-OST-1996-1901-0025 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Arizona Express Airlines | Other | Proposal(s) | 2004-07-16T04:00:00Z | 2004 | 7 | 2004-07-16T04:00:00Z | 2004-07-17T03:59:59Z | 2024-11-11T21:43:47Z | 1 | 0 | 09000064802a2cb3 | |
| DOT-OST-1996-1901-0023 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Great Lakes Aviation, Ltd. | Other | Proposal(s) | 2004-07-16T04:00:00Z | 2004 | 7 | 2004-07-16T04:00:00Z | 2004-07-17T03:59:59Z | 2024-11-11T21:43:47Z | 1 | 0 | 09000064802a2cb1 | |
| DOT-OST-1996-1901-0024 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Mesa Air Group, Inc. d/b/a Air Midwest | Other | Proposal(s) | 2004-07-16T04:00:00Z | 2004 | 7 | 2004-07-16T04:00:00Z | 2004-07-17T03:59:59Z | 2024-11-11T21:43:47Z | 1 | 0 | 09000064802a2cb2 | |
| DOT-OST-1996-1901-0022 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Westward Airways, Inc. | Other | Proposal(s) | 2004-07-14T04:00:00Z | 2004 | 7 | 2004-07-14T04:00:00Z | 2004-07-15T03:59:59Z | 2024-11-11T21:43:47Z | 1 | 0 | 09000064802a2cb0 | |
| DOT-OST-1996-1901-0021 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | 2004-7-1 Order Setting Interim Subsidy Rate | Other | Order | 2004-07-01T04:00:00Z | 2004 | 7 | 2004-07-01T04:00:00Z | 2004-07-02T03:59:59Z | 2024-11-11T21:43:47Z | 1 | 0 | 09000064802a2caf | |
| DOT-OST-1996-1901-0020 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | 2004-6-23 Order Requesting Proposals on an Emergency Basis | Other | Order | 2004-06-25T04:00:00Z | 2004 | 6 | 2004-06-25T04:00:00Z | 2004-06-26T03:59:59Z | 2024-11-11T21:43:47Z | 1 | 0 | 09000064802a2cae | |
| DOT-OST-1996-1901-0019 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | 2004-3-21 Order Establishing Final Subsidy Rates | Other | Order | 2004-03-22T05:00:00Z | 2004 | 3 | 2004-03-22T05:00:00Z | 2004-03-23T04:59:59Z | 2024-11-11T21:43:46Z | 1 | 0 | 09000064802a2cac | |
| DOT-OST-1996-1901-0018 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | 2003-5-25 Order Setting Interim Subsidy Rates | Other | Order | 2003-05-23T04:00:00Z | 2003 | 5 | 2003-05-23T04:00:00Z | 2003-05-24T03:59:59Z | 2024-11-11T21:43:25Z | 1 | 0 | 09000064802a2cab | |
| DOT-OST-1996-1901-0017 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | 2002-4-18 Order Selecting Carrier and Setting Final Rate | Other | Order | 2002-04-22T04:00:00Z | 2002 | 4 | 2002-04-22T04:00:00Z | 2002-04-23T03:59:59Z | 2024-11-11T21:43:25Z | 1 | 0 | 09000064802a2caa | |
| DOT-OST-1996-1901-0016 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Department of the Air Force | Other | Correspondence | 2002-04-04T05:00:00Z | 2002 | 4 | 2002-04-04T05:00:00Z | 2002-04-05T04:59:59Z | 2024-11-11T21:43:25Z | 1 | 0 | 09000064802a2ca9 | |
| DOT-OST-1996-1901-0015 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | City of Alamogordo | Other | Correspondence | 2002-03-22T05:00:00Z | 2002 | 3 | 2002-03-22T05:00:00Z | 2002-03-23T04:59:59Z | 2024-11-11T21:43:24Z | 1 | 0 | 09000064802a2ca8 | |
| DOT-OST-1996-1901-0014 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | EAS Comment Period Extension | Other | Extension of Time | 2002-01-24T05:00:00Z | 2002 | 1 | 2002-01-24T05:00:00Z | 2002-01-25T04:59:59Z | 2024-11-11T21:43:24Z | 1 | 0 | 09000064802a2ca7 | |
| DOT-OST-1996-1901-0013 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Otero County Economic Development Council, Inc. | Other | Correspondence | 2001-09-13T04:00:00Z | 2001 | 9 | 2001-09-13T04:00:00Z | 2001-09-14T03:59:59Z | 2024-11-11T21:43:24Z | 1 | 0 | 09000064802a2ca6 | |
| DOT-OST-1996-1901-0012 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Mesa Air Group | Other | Objection(s) | 2001-08-28T04:00:00Z | 2001 | 8 | 2001-08-28T04:00:00Z | 2001-08-29T03:59:59Z | 2024-11-11T21:43:24Z | 1 | 0 | 09000064802a2ca5 | |
| DOT-OST-1996-1901-0011 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Objections of the Regional Aviation Partners | Other | Objection(s) | 2001-08-27T04:00:00Z | 2001 | 8 | 2001-08-27T04:00:00Z | 2001-08-28T03:59:59Z | 2024-11-11T21:43:24Z | 1 | 0 | 09000064802a2ca4 | |
| DOT-OST-1996-1901-0010 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Response to Order 2001-8-9 | Other | Response(s) | 2001-08-20T04:00:00Z | 2001 | 8 | 2001-08-20T04:00:00Z | 2001-08-21T03:59:59Z | 2024-11-11T21:43:24Z | 1 | 0 | 09000064802a2ca3 | |
| DOT-OST-1996-1901-0009 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | 2001-8-9 Statement of Proposed Policy Regarding Program Reductions | Other | Order | 2001-08-07T04:00:00Z | 2001 | 8 | 2001-08-07T04:00:00Z | 2001-08-08T03:59:59Z | 2024-11-11T21:45:46Z | 1 | 0 | 09000064802a2cf1 | |
| DOT-OST-1996-1901-0008 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Proposal of Rio Grande Air to Provide Essential Air Service at Alamogordo/Holloman Air Force Base, New Mexico | Other | Proposal(s) | 2001-07-02T04:00:00Z | 2001 | 7 | 2001-07-02T04:00:00Z | 2001-07-03T03:59:59Z | 2024-11-11T21:45:45Z | 1 | 0 | 09000064802a2cef | |
| DOT-OST-1996-1901-0007 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | 2001-5-18 Order To Show Cause | Other | Show Cause Order | 2001-05-15T04:00:00Z | 2001 | 5 | 2001-05-15T04:00:00Z | 2001-05-16T03:59:59Z | 2024-11-11T21:45:23Z | 1 | 0 | 09000064802a2ce5 | |
| DOT-OST-1996-1901-0006 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | 99-9-17 Final Order | Other | Order | 1999-09-27T04:00:00Z | 1999 | 9 | 1999-09-27T04:00:00Z | 1999-09-28T03:59:59Z | 2024-11-11T21:45:01Z | 1 | 0 | 09000064802a2cd9 | |
| DOT-OST-1996-1901-0005 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | Northeast Aviation Acquisition Corporation - Proposal to Provide Essential Air Service at Alamogordo/Holloman Air Force Base and SIlver City/Hurley/Deming, New Mexico | Other | Proposal(s) | 1999-01-14T05:00:00Z | 1999 | 1 | 1999-01-14T05:00:00Z | 1999-01-15T04:59:59Z | 2024-11-11T21:44:42Z | 1 | 0 | 09000064802a2cce | |
| DOT-OST-1996-1901-0004 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | 98-12-26 Order To Show Cause | Other | Show Cause Order | 1998-12-22T05:00:00Z | 1998 | 12 | 1998-12-22T05:00:00Z | 1998-12-23T04:59:59Z | 2024-11-11T21:44:23Z | 1 | 0 | 09000064802a2cc3 | |
| DOT-OST-1996-1901-0003 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | 97-11-9 Order Revising Service Levels and Subsidy Rates | Other | Order | 1997-11-06T05:00:00Z | 1997 | 11 | 1997-11-06T05:00:00Z | 1997-11-07T04:59:59Z | 2024-11-11T21:44:07Z | 1 | 0 | 09000064802a2cb8 | |
| DOT-OST-1996-1901-0002 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | 97-8-14 Order Authorizing Subsidy for Increased Service Program-Wide | Other | Order | 1997-08-14T04:00:00Z | 1997 | 8 | 1997-08-14T04:00:00Z | 1997-08-15T03:59:59Z | 2024-11-11T21:43:47Z | 1 | 0 | 09000064802a2cad | |
| DOT-OST-1996-1901-0001 | DOT | 96-10-39 Order to Show Cause - Essential Air Service - Alamogordo/Holloman Air Force Base, New Mexico DOT-OST-1996-1901 | 96-10-39 Order to Show Cause - Essential Air Service - Kingman and Prescott, Arizona | Other | Show Cause Order | 1996-10-25T04:00:00Z | 1996 | 10 | 1996-10-25T04:00:00Z | 1996-10-26T03:59:59Z | 2024-11-11T21:43:23Z | 1 | 0 | 09000064802a2ca2 |
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;