PMA parts approved under this STC · 85

duckdb -csv -c "SELECT drs_guid, part_number, part_name, holder, pma_number, supplement_date, status
  FROM 'https://openairdocs.org/data/latest/faa_stc_pma.parquet'
  WHERE stc_number = 'SR01597NY-D'
  ORDER BY status = 'Current' DESC, supplement_date DESC, drs_guid 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 drs_guid, part_number, part_name, holder, pma_number, supplement_date, status
FROM 'https://openairdocs.org/data/latest/faa_stc_pma.parquet'
WHERE stc_number = 'SR01597NY-D'
ORDER BY status = 'Current' DESC, supplement_date DESC, drs_guid 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.