Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('13843FZ', '13844GD')
ORDER BY n_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 n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('13843FZ', '13844GD')
ORDER BY n_numberRun 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.
N7201SBoeing Co · Renton, WAN7202UBoeing Company · Renton, WAN7203UBoeing Co · Renton, WAN7204UBoeing Co · Renton, WAN7205UBoeing Co · Renton, WAN7206UBoeing Co · Renton, WAN7207ZBoeing Co · Renton, WAN7208UBoeing Co · Renton, WAN7209UBoeing Co · Renton, WAN7210UBoeing Co · Renton, WAN7211UBoeing Co · Renton, WAN7212ZBoeing Co · Renton, WAN7213UBoeing Co · Renton, WAN7214UBoeing Co · Renton, WAN7215UBoeing Co · Renton, WAN7216UBoeing Co · Renton, WAN7217UBoeing Co · Renton, WAN7218UBoeing Co · Renton, WAN7219RBoeing Co · Renton, WAN7220ZBoeing Co · Renton, WAN7221UBoeing Co · Renton, WAN7222UBoeing Co · Renton, WAN7223UBoeing Co · Renton, WAN7224XBoeing Co · Renton, WAN7225ZBoeing Co · Renton, WAN7226UBoeing Co · Renton, WAN7227RBoeing Co · Renton, WAN7229UBoeing Co · Renton, WAN7230UBoeing Co · Renton, WAN7300ZBoeing Co · Renton, WA
Back to Boeing 737-7