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.
N17362United Airlines Inc · Chicago, ILN17363United Airlines Inc · Chicago, ILN17364United Airlines Inc · Chicago, ILN17373United Airlines Inc · Chicago, ILN173AMBank Of Utah Trustee · Salt Lake City, UTN1776RSouthwest Airlines Co · Dallas, TXN1801USouthwest Airlines Co · Dallas, TXN1802USouthwest Airlines Co · Dallas, TXN1803USouthwest Airlines Co · Dallas, TXN1804USouthwest Airlines Co · Dallas, TXN1805USouthwest Airlines Co · Dallas, TXN1806USouthwest Airlines Co · Dallas, TXN1807USouthwest Airlines Co · Dallas, TXN1808USouthwest Airlines Inc · Dallas, TXN1809USouthwest Airlines Co · Dallas, TXN1810USouthwest Airlines Co · Dallas, TXN1811USouthwest Airlines Co · Dallas, TXN188AMBank Of Utah Trustee · Salt Lake City, UTN1TSWilmington Trust Co Trustee · Wilmington, DEN209AMUmb Bank N A Trustee · Salt Lake City, UTN27251Wilmington Trust Co Trustee · Wilmington, DEN27252Wilmington Trust Co Trustee · Wilmington, DEN27253Wilmington Trust Co Trustee · Wilmington, DEN27255Wilmington Trust Co Trustee · Wilmington, DEN27256Wilmington Trust Co Trustee · Wilmington, DEN27258Wilmington Trust Co Trustee · Wilmington, DEN27260Wilmington Trust Co Trustee · Wilmington, DEN27261Wilmington Trust Co Trustee · Wilmington, DEN27263Wilmington Trust Co Trustee · Wilmington, DEN27266Wilmington Trust Co Trustee · Wilmington, DEN27267United Airlines Inc · Chicago, ILN27268United Airlines Inc · Chicago, ILN27269United Airlines Inc · Chicago, ILN27270United Airlines Inc · Chicago, ILN27271United Airlines Inc · Chicago, ILN27273United Airlines Inc · Chicago, ILN27274United Airlines Inc · Chicago, ILN27276United Airlines Inc · Chicago, ILN27277United Airlines Inc · Chicago, ILN27283United Airlines Inc · Chicago, ILN27287United Airlines Inc · Chicago, ILN27290United Airlines Inc · Chicago, ILN27292Umb Bank Na Trustee · Salt Lake City, UTN27304Umb Bank Na Trustee · Salt Lake City, UTN27323Umb Bank Na Trustee · Salt Lake City, UTN27334United Airlines Inc · Chicago, ILN27366United Airlines Inc · Chicago, ILN285AMBank Of Utah Trustee · Salt Lake City, UTN300UBAmerican Airlines Inc · Fort Worth, TXN301UCAmerican Airlines Inc · Fort Worth, TX
Back to Boeing 737-8