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.
N8728QUmb Bank Na Trustee · Salt Lake City, UTN8729HUmb Bank Na Trustee · Salt Lake City, UTN872CBSouthwest Airlines Co · Dallas, TXN8730QUmb Bank Na Trustee · Salt Lake City, UTN8731JUmb Bank Na Trustee · Salt Lake City, UTN8732SUmb Bank Na Trustee · Salt Lake City, UTN8733MBank Of Utah Trustee · Salt Lake City, UTN8734QBank Of Utah Trustee · Salt Lake City, UTN8735LBank Of Utah Trustee · Salt Lake City, UTN8736JWilmington Trust Co Trustee · Wilmington, DEN8737LWilmington Trust Co Trustee · Wilmington, DEN8738KWilmington Trust Company Trustee · Wilmington, DEN8739LWilmington Trust Co Trustee · Wilmington, DEN8740AUmb Bank Na Trustee · Salt Lake City, UTN8741LUmb Bank Na Trustee · Salt Lake City, UTN8742MUmb Bank Na Trustee · Salt Lake City, UTN8743KUmb Bank Na Trustee · Salt Lake City, UTN8744BUmb Bank Na Trustee · Salt Lake City, UTN8745KUmb Bank Na Trustee · Salt Lake City, UTN8746QUmb Bank Na Trustee · Salt Lake City, UTN8747QUmb Bank Na Trustee · Salt Lake City, UTN8748QUmb Bank Na Trustee · Salt Lake City, UTN8749QUmb Bank Na Trustee · Salt Lake City, UTN8750QUmb Bank Na Trustee · Salt Lake City, UTN8751RUmb Bank Na Trustee · Salt Lake City, UTN8752QSouthwest Airlines Co · Dallas, TXN8753QSouthwest Airlines Co · Dallas, TXN8754SSouthwest Airlines Co · Dallas, TXN8755LSouthwest Airlines Co · Dallas, TXN8756SSouthwest Airlines Co · Dallas, TXN8757LSouthwest Airlines Co · Dallas, TXN8758LSouthwest Airlines Co · Dallas, TXN8759QSouthwest Airlines Co · Dallas, TXN8760LSouthwest Airlines Co · Dallas, TXN8761LSouthwest Airlines Co · Dallas, TXN8762QSouthwest Airlines Co · Dallas, TXN8763LSouthwest Airlines Co · Dallas, TXN8764QSouthwest Airlines Co · Dallas, TXN8765QSouthwest Airlines Co · Dallas, TXN8766TSouthwest Airlines Co · Dallas, TXN8767MSouthwest Airlines Co · Dallas, TXN8768QSouthwest Airlines Co · Dallas, TXN8769QSouthwest Airlines Co · Dallas, TXN8770QSouthwest Airlines Co · Dallas, TXN8771DSouthwest Airlines Co · Dallas, TXN8772MSouthwest Airlines Co · Dallas, TXN8773QSouthwest Airlines Co · Dallas, TXN8774QSouthwest Airlines Co · Dallas, TXN8775QSouthwest Airlines Co · Dallas, TXN8776LSouthwest Airlines Co · Dallas, TX
Back to Boeing 737-8