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 ('1384414')
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 ('1384414')
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.
N807XAWilmington Trust Co Trustee · Wilmington, DEN813VLUmb Bank Na Trustee · Salt Lake City, UTN823SYSun Country Inc · Minneapolis, MNN824SYSun Country Inc · Minneapolis, MNN839SYBank Of Utah Trustee · Salt Lake City, UTN840SYBank Of Utah Trustee · Salt Lake City, UTN8501VSouthwest Airlines Co · Dallas, TXN8502ZSouthwest Airlines Co · Dallas, TXN8503ASouthwest Airlines Co · Dallas, TXN8504GSouthwest Airlines Co · Dallas, TXN8507CSouthwest Airlines Co · Dallas, TXN8508WSouthwest Airlines Co · Dallas, TXN8509USouthwest Airlines Co · Dallas, TXN8510ESouthwest Airlines Co · Dallas, TXN8511KSouthwest Airlines Co · Dallas, TXN8512USouthwest Airlines Co · Dallas, TXN8513FSouthwest Airlines Co · Dallas, TXN8514FSouthwest Airlines Co · Dallas, TXN8515XSouthwest Airlines Co · Dallas, TXN8517FSouthwest Airlines Co · Dallas, TXN8518RSouthwest Airlines Co · Dallas, TXN8519RSouthwest Airlines Co · Dallas, TXN8520QSouthwest Airlines Co · Dallas, TXFirst renewal noticeN8522PSouthwest Airlines Co · Dallas, TXN8523WSouthwest Airlines Co · Dallas, TXN8524ZSouthwest Airlines Co · Dallas, TXN8525SSouthwest Airlines Co · Dallas, TXN8526WSouthwest Airlines Co · Dallas, TXFirst renewal noticeN8527QSouthwest Airlines Co · Dallas, TXFirst renewal noticeN8528QSouthwest Airlines Co · Dallas, TXFirst renewal noticeN8529ZSouthwest Airlines Co · Dallas, TXN8530WSouthwest Airlines Co · Dallas, TXN8531QSouthwest Airlines Co · Dallas, TXN8532SSouthwest Airlines Co · Dallas, TXN8533SSouthwest Airlines Co · Dallas, TXN8534ZSouthwest Airlines Co · Dallas, TXN8535SSouthwest Airlines Co · Dallas, TXN8536ZSouthwest Airlines Co · Dallas, TXN8537ZSouthwest Airlines Inc · Dallas, TXN8538VSouthwest Airlines Co · Dallas, TXN8539VSouthwest Airlines Co · Dallas, TXN8540VSouthwest Airlines Co · Dallas, TXN8541WSouthwest Airlines Co · Dallas, TXN8542ZSouthwest Airlines Co · Dallas, TXN8543ZSouthwest Airlines Co · Dallas, TXN8544ZSouthwest Airlines Co · Dallas, TXN8545VSouthwest Airlines Co · Dallas, TXN8546VSouthwest Airlines Co · Dallas, TXN8547VSouthwest Airlines Co · Dallas, TXN8548PSouthwest Airlines Co · Dallas, TX
Back to Boeing 737-800