Advisory circulars

duckdb -csv -c "SELECT ac_number, ac_family, title, status, approval_date, page_count
  FROM 'https://openairdocs.org/data/latest/faa_advisory_circular.parquet'
  QUALIFY row_number() OVER (PARTITION BY ac_family ORDER BY status = 'Current' DESC, approval_date DESC) = 1
  ORDER BY ac_family"

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 ac_number, ac_family, title, status, approval_date, page_count
FROM 'https://openairdocs.org/data/latest/faa_advisory_circular.parquet'
QUALIFY row_number() OVER (PARTITION BY ac_family ORDER BY status = 'Current' DESC, approval_date DESC) = 1
ORDER BY ac_family

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.