documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
23 rows where docket_id = "FAA-2011-0598" and posted_year = 2011 sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: subtype, posted_date, posted_month, comment_start_date, last_modified, posted_date (date), comment_start_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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FAA-2011-0598-0019 | FAA | None FAA-2011-0598 | 16-10-02 Respondent's Reply to Complainant's Response for Additional Information | Other | Reply | 2011-11-15T05:00:00Z | 2011 | 11 | 2011-11-15T05:00:00Z | 2013-07-28T00:07:35Z | 0 | 0 | 0900006480f680e7 | ||
| FAA-2011-0598-0023 | FAA | None FAA-2011-0598 | U.S. DOT/FAA - 16-10-02 Notice of Extension of Time dtd 10/12/11 | Other | Extension of Time | 2011-11-15T05:00:00Z | 2011 | 11 | 2011-11-15T05:00:00Z | 2013-07-28T00:07:46Z | 0 | 0 | 0900006480f68596 | ||
| FAA-2011-0598-0018 | FAA | None FAA-2011-0598 | 16-10-02 CKornegay Letter dtd 10/01/10 | Other | Letter(s) | 2011-11-15T05:00:00Z | 2011 | 11 | 2011-11-15T05:00:00Z | 2013-07-28T00:07:35Z | 0 | 0 | 0900006480f680df | ||
| FAA-2011-0598-0022 | FAA | None FAA-2011-0598 | 16-10-02 Complainant's Responses to Respondent's Answers to FAA's Request for Additional Information | Other | Response(s) | 2011-11-15T05:00:00Z | 2011 | 11 | 2011-11-15T05:00:00Z | 2013-07-28T00:07:46Z | 0 | 0 | 0900006480f68594 | ||
| FAA-2011-0598-0020 | FAA | None FAA-2011-0598 | 16-10-02 Respondent's Response to Request for Additional Information | Other | Response(s) | 2011-11-15T05:00:00Z | 2011 | 11 | 2011-11-15T05:00:00Z | 2013-07-28T00:07:35Z | 0 | 0 | 0900006480f680ea | ||
| FAA-2011-0598-0021 | FAA | None FAA-2011-0598 | 16-10-02 Respondent's Supplemental Response to FAA's Request for Additional Information - Question 6 | Other | Response(s) | 2011-11-15T05:00:00Z | 2011 | 11 | 2011-11-15T05:00:00Z | 2013-07-28T00:07:45Z | 0 | 0 | 0900006480f68591 | ||
| FAA-2011-0598-0017 | FAA | None FAA-2011-0598 | 16-10-02 CKornegay Letter dtd 8-27-10 | Other | Letter(s) | 2011-11-15T05:00:00Z | 2011 | 11 | 2011-11-15T05:00:00Z | 2013-08-11T04:48:31Z | 0 | 0 | 0900006480f680dc | ||
| FAA-2011-0598-0013 | FAA | None FAA-2011-0598 | Sun Valley Aviation, Inc. - Response To Request For Additional Information | Other | Response(s) | 2011-06-07T04:00:00Z | 2011 | 6 | 2011-06-07T04:00:00Z | 2013-07-27T23:52:43Z | 0 | 0 | 0900006480c6d928 | ||
| FAA-2011-0598-0012 | FAA | None FAA-2011-0598 | City Of Harlingen, Texas, Valley International Airport - Rebuttal In Support Of Motion To Dismiss And Answer Subject Thereto | Other | Rebuttal | 2011-06-07T04:00:00Z | 2011 | 6 | 2011-06-07T04:00:00Z | 2013-07-27T23:48:52Z | 0 | 0 | 0900006480c141d1 | ||
| FAA-2011-0598-0016 | FAA | None FAA-2011-0598 | Sun Valley Aviation, Inc. - Motion To Dismiss And Answer Subject Thereto | Other | Motion | 2011-06-07T04:00:00Z | 2011 | 6 | 2011-06-07T04:00:00Z | 2013-07-27T23:48:52Z | 0 | 0 | 0900006480c141d9 | ||
| FAA-2011-0598-0014 | FAA | None FAA-2011-0598 | U.S. DOT/FAA - Additional Information and Notice of Extension of Time | Other | Additional Information | 2011-06-07T04:00:00Z | 2011 | 6 | 2011-06-07T04:00:00Z | 2013-08-11T01:41:39Z | 0 | 0 | 0900006480c7a04a | ||
| FAA-2011-0598-0011 | FAA | None FAA-2011-0598 | City Of Harlingen, Texas, Valley International Airport - Motion For Extension Of Time | Other | Motion | 2011-06-07T04:00:00Z | 2011 | 6 | 2011-06-07T04:00:00Z | 2013-07-27T23:48:52Z | 0 | 0 | 0900006480c141cf | ||
| FAA-2011-0598-0015 | FAA | None FAA-2011-0598 | Sun Valley Aviation, Inc. - Exhibit E Motion & Answer | Other | Exhibit(s) | 2011-06-07T04:00:00Z | 2011 | 6 | 2011-06-07T04:00:00Z | 2013-08-11T04:44:54Z | 0 | 0 | 0900006480c14191 | ||
| FAA-2011-0598-0002 | FAA | None FAA-2011-0598 | Sun Valley Aviation, Inc. - Exhibit C Motion & Answer | Other | Exhibit(s) | 2011-06-06T04:00:00Z | 2011 | 6 | 2011-06-06T04:00:00Z | 2013-07-27T23:55:05Z | 0 | 0 | 0900006480e3d415 | ||
| FAA-2011-0598-0004 | FAA | None FAA-2011-0598 | Sun Valley Aviation, Inc. - Exhibit C Part 2, Motion & Answer | Other | Exhibit(s) | 2011-06-06T04:00:00Z | 2011 | 6 | 2011-06-06T04:00:00Z | 2013-07-27T23:55:07Z | 0 | 0 | 0900006480e3d57a | ||
| FAA-2011-0598-0008 | FAA | None FAA-2011-0598 | Sun Valley Aviation, Inc. - Exhibit D-F Motion & Answer | Other | Exhibit(s) | 2011-06-06T04:00:00Z | 2011 | 6 | 2011-06-06T04:00:00Z | 2013-07-27T23:48:51Z | 0 | 0 | 0900006480c141ab | ||
| FAA-2011-0598-0007 | FAA | None FAA-2011-0598 | Sun Valley Aviation, Inc. - Exhibit G Motion & Answer | Other | Exhibit(s) | 2011-06-06T04:00:00Z | 2011 | 6 | 2011-06-06T04:00:00Z | 2013-07-27T23:48:51Z | 0 | 0 | 0900006480c141a9 | ||
| FAA-2011-0598-0006 | FAA | None FAA-2011-0598 | Sun Valley Aviation, Inc. - Exhibit F Motion & Answer | Other | Exhibit(s) | 2011-06-06T04:00:00Z | 2011 | 6 | 2011-06-06T04:00:00Z | 2013-07-27T23:48:51Z | 0 | 0 | 0900006480c141a7 | ||
| FAA-2011-0598-0001 | FAA | None FAA-2011-0598 | Sun Valley Aviation, Inc. - Exhibits A-B Motion & Answer | Other | Exhibit(s) | 2011-06-06T04:00:00Z | 2011 | 6 | 2011-06-06T04:00:00Z | 2013-08-11T01:42:02Z | 0 | 0 | 0900006480e3d348 | ||
| FAA-2011-0598-0009 | FAA | None FAA-2011-0598 | Sun Valley Aviation, Inc. - Exhibit H-O Motion & Answer | Other | Exhibit(s) | 2011-06-06T04:00:00Z | 2011 | 6 | 2011-06-06T04:00:00Z | 2013-07-27T23:48:51Z | 0 | 0 | 0900006480c141ad | ||
| FAA-2011-0598-0003 | FAA | None FAA-2011-0598 | Sun Valley Aviation, Inc. - Exhibit C Part 1, Motion & Answer | Other | Exhibit(s) | 2011-06-06T04:00:00Z | 2011 | 6 | 2011-06-06T04:00:00Z | 2013-07-27T23:55:07Z | 0 | 0 | 0900006480e3d576 | ||
| FAA-2011-0598-0005 | FAA | None FAA-2011-0598 | Sun Valley Aviation, Inc. - Exhibit D Motion & Answer | Other | Exhibit(s) | 2011-06-06T04:00:00Z | 2011 | 6 | 2011-06-06T04:00:00Z | 2013-08-11T03:13:57Z | 0 | 0 | 0900006480c1418f | ||
| FAA-2011-0598-0010 | FAA | None FAA-2011-0598 | Sun Valley Aviation, Inc. - Exhibit A&B Motion & Answer | Other | Exhibit(s) | 2011-06-06T04:00:00Z | 2011 | 6 | 2011-06-06T04:00:00Z | 2013-07-27T23:48:51Z | 0 | 0 | 0900006480c141b0 |
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;