Airworthiness concern sheets · 16

duckdb -csv -c "SELECT acs_number, title, issue_date
  FROM 'https://openairdocs.org/data/latest/faa_concern_sheet.parquet'
  WHERE EXISTS (SELECT 1 FROM unnest(jasc_codes) AS j(code) WHERE j.code LIKE '5700 %')
  ORDER BY issue_date 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 acs_number, title, issue_date
FROM 'https://openairdocs.org/data/latest/faa_concern_sheet.parquet'
WHERE EXISTS (SELECT 1 FROM unnest(jasc_codes) AS j(code) WHERE j.code LIKE '5700 %')
ORDER BY issue_date 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.