Proposed ADs

duckdb -csv -c "SELECT docket_number, fr_document_number, action, title, makes, models, publication_date, comment_due_date, final_ad_id
  FROM 'https://openairdocs.org/data/latest/faa_proposed_directive.parquet'
  ORDER BY publication_date DESC, proposal_id DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT docket_number, fr_document_number, action, title, makes, models, publication_date, comment_due_date, final_ad_id
FROM 'https://openairdocs.org/data/latest/faa_proposed_directive.parquet'
ORDER BY publication_date DESC, proposal_id DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.