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.
N759AMUmb Bank Na Trustee · Salt Lake City, UTN77259Wilmington Trust Co Trustee · Wilmington, DEN783BABoeing Aircraft Holding Company · Renton, WAN801AKAlaska Airlines Inc · Seattle, WAN803AKAlaska Airlines Inc · Seattle, WAN804AKAlaska Airlines Inc · Seattle, WAN805AKAlaska Airlines Inc · Seattle, WAN806AKAlaska Airlines Inc · Seattle, WAN809AKAlaska Airlines Inc · Seattle, WAN812AKAlaska Airlines Inc · Seattle, WAN812UPAmerican Airlines Inc · Fort Worth, TXN813AKAlaska Airlines Inc · Seattle, WAN814AKAlaska Airlines Inc · Seatac, WAN815AKAlaska Airlines Inc · Seattle, WAN816AKAlaska Airlines Inc · Seattle, WAN821AKAlaska Airlines Inc · Seatac, WAN823AKAlaska Airlines Inc · Seatac, WAN838AKAlaska Airlines Inc · Seatac, WAN839AKAlaska Airlines Inc · Seattle, WAN842AKAlaska Airlines Inc · Seattle, WAN845AKAlaska Airlines Inc · Seattle, WAN846AKAlaska Airlines Inc · Seattle, WAN849AKAlaska Airlines Inc · Seatac, WAN868AMAlc B378 65188 LLC · Los Angeles, CAN8701QSouthwest Airlines Co · Dallas, TXN8702LUmb Bank Na Trustee · Salt Lake City, UTN8704QSouthwest Airlines Co · Dallas, TXN8705QSouthwest Airlines Co · Dallas, TXN8706WSouthwest Airlines Co · Dallas, TXN8707PSouthwest Airlines Co · Dallas, TXN8708QSouthwest Airlines Co · Dallas, TXN8709QSouthwest Airlines Co · Dallas, TXN8710MSouthwest Airlines Co · Dallas, TXN8711QSouthwest Airlines Co · Dallas, TXN8712LSouthwest Airlines Co · Dallas, TXN8714QSouthwest Airlines Co · Dallas, TXN8715QSouthwest Airlines Co · Dallas, TXN8716BSouthwest Airlines Co · Dallas, TXN8717MSouthwest Airlines Co · Dallas, TXN8718QSouthwest Airlines Co · Dallas, TXN8719QSouthwest Airlines Co · Dallas, TXN871HKSouthwest Airlines Co · Dallas, TXN8720LSouthwest Airlines Co · Dallas, TXN8721JSouthwest Airlines Co · Dallas, TXN8722LUmb Bank Na Trustee · Salt Lake City, UTN8723QUmb Bank Na Trustee · Salt Lake City, UTN8724JUmb Bank Na Trustee · Salt Lake City, UTN8725LUmb Bank Na Trustee · Salt Lake City, UTN8726HSouthwest Airlines Co · Dallas, TXN8727MSouthwest Airlines Co · Dallas, TX
Back to Boeing 737-8