FAA repair stations: Propeller

duckdb -csv -c "SELECT s.certificate_number, s.display_name, s.dba, s.city, s.state_province, s.country, s.listed, s.difficulty_reports
  FROM 'https://openairdocs.org/data/latest/faa_repair_station.parquet' s
  WHERE s.listed
    AND s.certificate_number IN (SELECT certificate_number FROM 'https://openairdocs.org/data/latest/faa_repair_station_rating.parquet' WHERE rating = 'Propeller')
  ORDER BY lower(s.display_name), s.certificate_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 s.certificate_number, s.display_name, s.dba, s.city, s.state_province, s.country, s.listed, s.difficulty_reports
FROM 'https://openairdocs.org/data/latest/faa_repair_station.parquet' s
WHERE s.listed
  AND s.certificate_number IN (SELECT certificate_number FROM 'https://openairdocs.org/data/latest/faa_repair_station_rating.parquet' WHERE rating = 'Propeller')
ORDER BY lower(s.display_name), s.certificate_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.