Supplemental type certificates

duckdb -csv -c "SELECT stc_number, description, holder, status, status_date
  FROM 'https://openairdocs.org/data/latest/faa_stc.parquet'
  ORDER BY status_date DESC NULLS LAST, stc_number"

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 stc_number, description, holder, status, status_date
FROM 'https://openairdocs.org/data/latest/faa_stc.parquet'
ORDER BY status_date DESC NULLS LAST, stc_number

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.