documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
45 rows where docket_id = "DOT-OST-1997-2073" sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: title, subtype, posted_month, comment_end_date, last_modified, open_for_comment, posted_date (date), comment_start_date (date), comment_end_date (date), last_modified (date)
posted_year 22
agency_id 1
- DOT 45
| 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-2073-0040 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Notice of Action Taken re: Cemex Operaciones Mexico, S.A. de C.V. | Other | Decision | 2026-01-23T05:00:00Z | 2026 | 1 | 2026-01-23T05:00:00Z | 2026-01-23T22:26:20Z | 1 | 0 | 09000064b917c9f7 | ||
| DOT-OST-1997-2073-0039 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Application of Cemex Operaciones Mexico, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2025-12-01T05:00:00Z | 2025 | 12 | 2025-12-01T05:00:00Z | 2025-12-02T23:46:38Z | 1 | 0 | 09000064b90a7efc | ||
| DOT-OST-1997-2073-0038 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Notice of Action Taken re: Cemex Operaciones Mexico, S.A. de C.V. | Other | Decision | 2023-12-27T05:00:00Z | 2023 | 12 | 2023-12-27T05:00:00Z | 2024-11-12T06:24:45Z | 1 | 0 | 090000648635e808 | ||
| DOT-OST-1997-2073-0037 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Supplement to Application of Cemex Operaciones Mexico, S.A. de C.V. for Renewal of Exemption | Other | Supplement (SUP) | 2023-10-04T04:00:00Z | 2023 | 10 | 2023-10-04T04:00:00Z | 2024-11-07T00:53:21Z | 1 | 0 | 09000064860326ee | ||
| DOT-OST-1997-2073-0036 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Application of Cemex Operaciones Mexico, S.A. de C.V. f/k/a Cemex Central, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2021-12-27T05:00:00Z | 2021 | 12 | 2021-12-27T05:00:00Z | 2021-12-27T13:28:56Z | 0 | 0 | 0900006484efd217 | ||
| DOT-OST-1997-2073-0035 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Notice of Action Taken re: Cemex Central, S.A. de C.V. | Other | Decision | 2020-01-23T05:00:00Z | 2020 | 1 | 2020-01-23T05:00:00Z | 2024-11-12T23:16:18Z | 1 | 0 | 09000064842ded68 | ||
| DOT-OST-1997-2073-0034 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Application of Cemex Central, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2019-10-09T04:00:00Z | 2019 | 10 | 2019-10-09T04:00:00Z | 2024-11-12T23:10:23Z | 1 | 0 | 09000064840690d6 | ||
| DOT-OST-1997-2073-0033 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Notice of Action Taken re: Cemex Central, S.A. de C.V. | Other | Decision | 2017-11-09T05:00:00Z | 2017 | 11 | 2017-11-09T05:00:00Z | 2024-11-07T01:09:56Z | 1 | 0 | 0900006482c62ef5 | ||
| DOT-OST-1997-2073-0032 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Notice of Action Taken re: Aviacion Comercial de America, S.A. de C.V. (September 4, 2015) | Other | Decision | 2017-08-16T04:00:00Z | 2017 | 8 | 2017-08-16T04:00:00Z | 2024-11-07T01:08:45Z | 1 | 0 | 0900006482a3e77d | ||
| DOT-OST-1997-2073-0031 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Application of Cemex Central, S.A. de C.V. (f/k/a Aviacion Comercial de America, S.A. de C.V.) for Renewal of Exemption | Other | Application-Other | 2017-08-02T04:00:00Z | 2017 | 8 | 2017-08-02T04:00:00Z | 2024-11-07T01:07:52Z | 1 | 0 | 0900006482994bd8 | ||
| DOT-OST-1997-2073-0030 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Application of Aviacion Comercial de America, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2015-06-22T04:00:00Z | 2015 | 6 | 2015-06-22T04:00:00Z | 2015-06-22T13:15:05Z | 0 | 0 | 0900006481b4904a | ||
| DOT-OST-1997-2073-0029 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Notice of Action Taken re: Corporacion Aero Angeles, S.A. de C.V., Aviacion Comercial De America, S.A. de C.V. and Servicios Aereos Gana, S.A. de C.V. | Other | Decision | 2013-07-31T04:00:00Z | 2013 | 7 | 2013-07-31T04:00:00Z | 2024-11-07T22:53:09Z | 1 | 0 | 0900006481386f6b | ||
| DOT-OST-1997-2073-0028 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Application of Aviacion Comercial de America, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2013-07-10T04:00:00Z | 2013 | 7 | 2013-07-10T04:00:00Z | 2024-11-07T22:56:44Z | 1 | 0 | 0900006481358c70 | ||
| DOT-OST-1997-2073-0027 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Notice of Action Taken re: Servicios Aeros Gana, S.A. de C.V. and Aviacion Comercial de America, S.A. de C.V. | Other | Decision | 2011-08-05T04:00:00Z | 2011 | 8 | 2011-08-05T04:00:00Z | 2024-11-07T22:33:01Z | 1 | 0 | 0900006480ed8d52 | ||
| DOT-OST-1997-2073-0026 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Application of Avicion Comercial de America, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2011-07-20T04:00:00Z | 2011 | 7 | 2011-07-20T04:00:00Z | 2011-07-20T19:06:56Z | 0 | 0 | 0900006480ec4b2a | ||
| DOT-OST-1997-2073-0025 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Notice of Action Taken re: Aviacion Comercial de America, S.A. de C.V. | Other | Notice | 2009-08-14T04:00:00Z | 2009 | 8 | 2009-08-14T04:00:00Z | 2024-11-12T04:36:00Z | 1 | 0 | 0900006480a09f14 | ||
| DOT-OST-1997-2073-0024 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Application of Aviacion Comercial de America, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2009-07-13T04:00:00Z | 2009 | 7 | 2009-07-13T04:00:00Z | 2024-11-12T04:41:57Z | 1 | 0 | 09000064809ee427 | ||
| DOT-OST-1997-2073-0023 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Notice of Action Taken re: Aeropycsa, Aeromodelo, Aviacion Comercial de America, Taxis Aereos del Valle de Toluca, Aero Servicios Azteca, S.A. de C.V. | Notice | Notice | 2007-09-26T04:00:00Z | 2007 | 9 | 2007-09-26T04:00:00Z | 2007-09-27T03:59:59Z | 2024-11-12T02:13:01Z | 1 | 0 | 09000064802e8869 | |
| DOT-OST-1997-2073-0022-0001 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Application of Avicion Comercial de America, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2007-08-14T04:00:00Z | 2007 | 8 | 2007-08-14T04:00:00Z | 2007-08-15T03:59:59Z | 2024-11-11T21:48:12Z | 1 | 0 | 09000064802a319f | |
| DOT-OST-1997-2073-0022-0002 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Application of Avicion Comercial de America, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2007-08-14T04:00:00Z | 2007 | 8 | 2007-08-14T04:00:00Z | 2007-08-15T03:59:59Z | 2024-11-11T21:48:12Z | 1 | 0 | 09000064802a31a0 | |
| DOT-OST-1997-2073-0021 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Notice of Action Taken re: Aviacion Comercial de America, S.A. de C.V. | Notice | Notice | 2006-11-01T05:00:00Z | 2006 | 11 | 2006-11-01T05:00:00Z | 2006-11-02T04:59:59Z | 2024-11-11T21:48:12Z | 1 | 0 | 09000064802a319e | |
| DOT-OST-1997-2073-0020 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Application of Aviacion Comercial de America, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2006-09-25T04:00:00Z | 2006 | 9 | 2006-09-25T04:00:00Z | 2006-09-26T03:59:59Z | 2024-11-11T21:48:12Z | 1 | 0 | 09000064802a319d | |
| DOT-OST-1997-2073-0019 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Notice of Action Taken re: Aviacion Comercial de America, S.A. de C.V. | Notice | Notice | 2005-10-24T04:00:00Z | 2005 | 10 | 2005-10-24T04:00:00Z | 2005-10-25T03:59:59Z | 2024-11-11T21:48:12Z | 1 | 0 | 09000064802a319b | |
| DOT-OST-1997-2073-0018-0001 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Application of Aviacion Comercial de America, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2005-09-23T04:00:00Z | 2005 | 9 | 2005-09-23T04:00:00Z | 2005-09-24T03:59:59Z | 2024-11-11T21:48:11Z | 1 | 0 | 09000064802a3199 | |
| DOT-OST-1997-2073-0018-0002 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Application of Aviacion Comercial de America, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2005-09-23T04:00:00Z | 2005 | 9 | 2005-09-23T04:00:00Z | 2005-09-24T03:59:59Z | 2024-11-11T21:48:12Z | 1 | 0 | 09000064802a319a | |
| DOT-OST-1997-2073-0017 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Notice of Action Taken re: Aviacion Comercial de America, S.A. de C.V. | Notice | Notice | 2004-10-20T04:00:00Z | 2004 | 10 | 2004-10-20T04:00:00Z | 2004-10-21T03:59:59Z | 2024-11-11T21:48:11Z | 1 | 0 | 09000064802a3198 | |
| DOT-OST-1997-2073-0016-0002 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Application of Aviacion Comercial de American, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2004-09-24T04:00:00Z | 2004 | 9 | 2004-09-24T04:00:00Z | 2004-09-25T03:59:59Z | 2024-11-11T21:47:45Z | 1 | 0 | 09000064802a3197 | |
| DOT-OST-1997-2073-0016-0001 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Application of Aviacion Comercial de American, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2004-09-24T04:00:00Z | 2004 | 9 | 2004-09-24T04:00:00Z | 2004-09-25T03:59:59Z | 2024-11-11T21:47:45Z | 1 | 0 | 09000064802a3196 | |
| DOT-OST-1997-2073-0015 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Notice of Action Taken re: Aviacion Commercial de America, S.A. de C.V. | Notice | Notice | 2003-10-20T04:00:00Z | 2003 | 10 | 2003-10-20T04:00:00Z | 2003-10-21T03:59:59Z | 2024-11-11T21:47:44Z | 1 | 0 | 09000064802a3195 | |
| DOT-OST-1997-2073-0014-0002 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Application of Aviacion Commercial de America, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2003-09-23T04:00:00Z | 2003 | 9 | 2003-09-23T04:00:00Z | 2003-09-24T03:59:59Z | 2024-11-11T21:47:44Z | 1 | 0 | 09000064802a3194 | |
| DOT-OST-1997-2073-0014-0001 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Application of Aviacion Commercial de America, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2003-09-23T04:00:00Z | 2003 | 9 | 2003-09-23T04:00:00Z | 2003-09-24T03:59:59Z | 2024-11-11T21:47:44Z | 1 | 0 | 09000064802a3193 | |
| DOT-OST-1997-2073-0013 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Notice of Action Taken re: Aviacion Comercial de America, S.A. de C.V. | Notice | Notice | 2002-09-23T04:00:00Z | 2002 | 9 | 2002-09-23T04:00:00Z | 2002-09-24T03:59:59Z | 2024-11-11T21:47:44Z | 1 | 0 | 09000064802a3192 | |
| DOT-OST-1997-2073-0012-0002 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Application of Aviacion Commercial de America, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2002-09-05T04:00:00Z | 2002 | 9 | 2002-09-05T04:00:00Z | 2002-09-06T03:59:59Z | 2024-11-11T21:47:44Z | 1 | 0 | 09000064802a3191 | |
| DOT-OST-1997-2073-0012-0001 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Application of Aviacion Commercial de America, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2002-09-05T04:00:00Z | 2002 | 9 | 2002-09-05T04:00:00Z | 2002-09-06T03:59:59Z | 2024-11-11T21:47:44Z | 1 | 0 | 09000064802a3190 | |
| DOT-OST-1997-2073-0011 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Notice of Action Taken re: Aviacion Comercial de America, S.A. de C.V. | Notice | Notice | 2001-07-02T04:00:00Z | 2001 | 7 | 2001-07-02T04:00:00Z | 2001-07-03T03:59:59Z | 2024-11-11T21:47:44Z | 1 | 0 | 09000064802a318f | |
| DOT-OST-1997-2073-0010 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Application of Aviacion Comercial de America, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2001-06-06T04:00:00Z | 2001 | 6 | 2001-06-06T04:00:00Z | 2001-06-07T03:59:59Z | 2024-11-11T21:47:44Z | 1 | 0 | 09000064802a318e | |
| DOT-OST-1997-2073-0009 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Notice of Action Taken re: Aviacion Comercial de America, S.A. de C.V. | Notice | Notice | 2000-06-08T04:00:00Z | 2000 | 6 | 2000-06-08T04:00:00Z | 2000-06-09T03:59:59Z | 2024-11-11T21:48:39Z | 1 | 0 | 09000064802a31a7 | |
| DOT-OST-1997-2073-0008 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Aviacion Comercial de America, S.A. de C.V. - Exemption/Renewal - United States Mexico | Other | Application-Other | 2000-03-20T05:00:00Z | 2000 | 3 | 2000-03-20T05:00:00Z | 2000-04-14T03:59:59Z | 2024-11-11T21:48:39Z | 1 | 0 | 09000064802a31a6 | |
| DOT-OST-1997-2073-0007 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Notice of Action Taken re: Aviacion Comercial de America, S.A. de C.V. | Notice | Notice | 1999-04-16T04:00:00Z | 1999 | 4 | 1999-04-16T04:00:00Z | 1999-04-17T03:59:59Z | 2024-11-11T21:48:39Z | 1 | 0 | 09000064802a31a5 | |
| DOT-OST-1997-2073-0006 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Aviacion Comercial de America, S.A. de C.V. - Exemption/Renewal - United States - Mexico Charter Air Transportation | Other | Application-Other | 1999-02-19T05:00:00Z | 1999 | 2 | 1999-02-19T05:00:00Z | 1999-03-17T04:59:59Z | 2024-11-11T21:48:39Z | 1 | 0 | 09000064802a31a4 | |
| DOT-OST-1997-2073-0005 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | 98-4-13 Order | Other | Order | 1998-04-13T04:00:00Z | 1998 | 4 | 1998-04-13T04:00:00Z | 1998-04-14T03:59:59Z | 2024-11-11T21:48:39Z | 1 | 0 | 09000064802a31a3 | |
| DOT-OST-1997-2073-0004 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Notice of Action Taken re: Aviacion Comercial de America, S.A. de C.V. | Notice | Notice | 1998-03-11T05:00:00Z | 1998 | 3 | 1998-03-11T05:00:00Z | 1998-03-12T04:59:59Z | 2024-11-11T21:48:13Z | 1 | 0 | 09000064802a31a2 | |
| DOT-OST-1997-2073-0003 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Aviacion Comercial de America, S.A. de C.V. - Exemption/Renewal - United States-Mexico Charter Air Transportation | Other | Application-Other | 1998-02-10T05:00:00Z | 1998 | 2 | 1998-02-10T05:00:00Z | 1998-03-05T04:59:59Z | 2024-11-11T21:48:13Z | 1 | 0 | 09000064802a31a1 | |
| DOT-OST-1997-2073-0002 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | 97-4-5 Order | Other | Order | 1997-04-03T05:00:00Z | 1997 | 4 | 1997-04-03T05:00:00Z | 1997-04-04T04:59:59Z | 2024-11-11T21:48:12Z | 1 | 0 | 09000064802a319c | |
| DOT-OST-1997-2073-0001 | DOT | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation DOT-OST-1997-2073 | Aviacion Comercial de America, S.A. de C.V. - Exemption - Mexico-United States Charter Air Transportation | Other | Application-Other | 1997-01-14T05:00:00Z | 1997 | 1 | 1997-01-14T05:00:00Z | 1997-01-15T04:59:59Z | 2024-11-11T21:47:20Z | 1 | 0 | 09000064802a318d |
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;