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.
N37257Wilmington Trust Co Trustee · Wilmington, DEN37278United Airlines Inc · Chicago, ILN37295United Airlines Inc · Chicago, ILN37297United Airlines Inc · Chicago, ILN37305Umb Bank Na Trustee · Salt Lake City, UTN37307United Airlines Inc · Chicago, ILN37308Umb Bank Na Trustee · Salt Lake City, UTN37313Umb Bank Na Trustee · Salt Lake City, UTN37318Umb Bank Na Trustee · Salt Lake City, UTN37319Umb Bank Na Trustee · Salt Lake City, UTN37324United Airlines Inc · Chicago, ILN37325Umb Bank Na Trustee · Salt Lake City, UTN37342Umb Bank Na Trustee · Salt Lake City, UTN37348United Airlines Inc · Chicago, ILN37351Umb Bank Na Trustee · Salt Lake City, UTN37352United Airlines Inc · Chicago, ILN37353United Airlines Inc · Chicago, ILN37354United Airlines Inc · Chicago, ILN37365United Airlines Inc · Chicago, ILN37367United Airlines Inc · Chicago, ILN37368United Airlines Inc · Chicago, ILN37371United Airlines Inc · Chicago, ILN37372United Airlines Inc · Chicago, ILN378SCWilmington Trust Co Trustee · Wilmington, DEN3ERegistered aircraftN471USU S Department Of Homeland Security · Arlington, VAN47275United Airlines Inc · Chicago, ILN47280United Airlines Inc · Chicago, ILN47281United Airlines Inc · Chicago, ILN47282United Airlines Inc · Chicago, ILN47284United Airlines Inc · Chicago, ILN47288United Airlines Inc · Chicago, ILN47291United Airlines Inc · Chicago, ILN47293Umb Bank Na Trustee · Salt Lake City, UTN47298United Airlines Inc · Chicago, ILN47330United Airlines Inc · Chicago, ILN47332Umb Bank Na Trustee · Salt Lake City, UTN47340Umb Bank Na Trustee · Salt Lake City, UTN47343Umb Bank Na Trustee · Salt Lake City, UTN47345United Airlines Inc · Chicago, ILN47357United Airlines Inc · Chicago, ILN47360United Airlines Inc · Chicago, ILN47369United Airlines Inc · Chicago, ILN47370United Airlines Inc · Chicago, ILN479AMUmb Bank Na Trustee · Salt Lake City, UTN562BJRegistration Pending · North Salt Lake, UTRegistration pendingN57286United Airlines Inc · Chicago, ILN57299Wilmington Trust Co Trustee · Wilmington, DEN67350United Airlines Inc · Chicago, ILN7378SRegistered aircraft
Back to Boeing 737-8