Every issue · 24

duckdb -csv -c "-- One row per file; the page lists issues, each a drs_guid
  SELECT drs_guid, record_status, stc_status, status_date, role, position, file_name, bytes
  FROM 'https://openairdocs.org/data/latest/faa_stc_file.parquet'
  WHERE stc_number = 'SA02268CH'
  ORDER BY record_status = 'Current' DESC, status_date DESC NULLS LAST, drs_guid, position"

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.

-- One row per file; the page lists issues, each a drs_guid
SELECT drs_guid, record_status, stc_status, status_date, role, position, file_name, bytes
FROM 'https://openairdocs.org/data/latest/faa_stc_file.parquet'
WHERE stc_number = 'SA02268CH'
ORDER BY record_status = 'Current' DESC, status_date DESC NULLS LAST, drs_guid, position

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.