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 ('13844FZ', '13845FZ')
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 ('13844FZ', '13845FZ')
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.
N8777QSouthwest Airlines Co · Dallas, TXN8778QSouthwest Airlines Co · Dallas, TXN8779QSouthwest Airlines Co · Dallas, TXN8780QSouthwest Airlines Co · Dallas, TXN8781QSouthwest Airlines Co · Dallas, TXN8782QSouthwest Airlines Co · Dallas, TXN8783LSouthwest Airlines Co · Dallas, TXN8784QSouthwest Airlines Co · Dallas, TXN8785LSouthwest Airlines Co · Dallas, TXN8786QSouthwest Airlines Co · Dallas, TXN8787KSouthwest Airlines Co · Dallas, TXN8788LSouthwest Airlines Co · Dallas, TXN8789QSouthwest Airlines Co · Dallas, TXN8790QSouthwest Airlines Co · Dallas, TXN8791DSouthwest Airlines Co · Dallas, TXN8792QSouthwest Airlines Co · Dallas, TXN8793QSouthwest Airlines Co · Dallas, TXN8794QSouthwest Airlines Co · Dallas, TXN8795LSouthwest Airlines Co · Dallas, TXN8796LSouthwest Airlines Co · Dallas, TXN8797QSouthwest Airlines Co · Dallas, TXN8798QSouthwest Airlines Co · Dallas, TXN8800LSouthwest Airlines Co · Dallas, TXN8801QSouthwest Airlines Co · Dallas, TXN8802QSouthwest Airlines Co · Dallas, TXN8803LSouthwest Airlines Co · Dallas, TXN8804LSouthwest Airlines Co · Dallas, TXN8805LSouthwest Airlines Co · Dallas, TXN8806QSouthwest Airlines Co · Dallas, TXN8807LSouthwest Airlines Co · Dallas, TXN8808QSouthwest Airlines Co · Dallas, TXN8809LSouthwest Airlines Co · Dallas, TXN8810LSouthwest Airlines Co · Dallas, TXN8811LSouthwest Airlines Co · Dallas, TXN8812QSouthwest Airlines Co · Dallas, TXN8813QSouthwest Airlines Co · Dallas, TXN8814KSouthwest Airlines Co · Dallas, TXN8815LSouthwest Airlines Co · Dallas, TXN8816QSouthwest Airlines Co · Dallas, TXN8817LSouthwest Airlines Co · Dallas, TXN8818QSouthwest Airlines Co · Dallas, TXN8819LSouthwest Airlines Co · Dallas, TXN8820LSouthwest Airlines Co · Dallas, TXN8821SSouthwest Airlines Co · Dallas, TXN8822QSouthwest Airlines Co · Dallas, TXN8823QSouthwest Airlines Co · Dallas, TXN8824QSouthwest Airlines Co · Dallas, TXN8825QSouthwest Airlines Co · Dallas, TXN8826QSouthwest Airlines Co · Dallas, TXN8827QSouthwest Airlines Co · Dallas, TX
Back to Boeing 737-8