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 ('3940005', '3940305')
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 ('3940005', '3940305')
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.
N368DNDelta Air Lines Inc · Atlanta, GAN369DNDelta Air Lines Inc · Atlanta, GAN370DNDelta Air Lines Inc · Atlanta, GAN371DNDelta Air Lines Inc · Atlanta, GAN372DNBank Of Utah Trustee · Salt Lake City, UTN373DXBank Of Utah Trustee · Salt Lake City, UTN374DXBank Of Utah Trustee · Salt Lake City, UTN375DNDelta Air Lines Inc · Atlanta, GAN376DNDelta Air Lines Inc · Atlanta, GAN377DNDelta Air Lines Inc · Atlanta, GAN378DNBank Of Utah Trustee · Salt Lake City, UTN379DNBank Of Utah Trustee · Salt Lake City, UTN380DNBank Of Utah Trustee · Salt Lake City, UTN381DZBank Of Utah Trustee · Salt Lake City, UTN382DNDelta Air Lines Inc · Atlanta, GAN383DZDelta Air Lines Inc · Atlanta, GAN384DNDelta Air Lines Inc · Atlanta, GAN385DZDelta Air Lines Inc · Atlanta, GAN386DNBank Of Utah Trustee · Salt Lake City, UTN387DNDelta Air Lines Inc · Atlanta, GAN388DNBank Of Utah Trustee · Salt Lake City, UTN389DNBank Of Utah Trustee · Salt Lake City, UTN390DNDelta Air Lines Inc · Atlanta, GAN391DNBank Of Utah Trustee · Salt Lake City, UTN392DNDelta Air Lines Inc · Atlanta, GAN393DNDelta Air Lines Inc · Atlanta, GAN394DXDelta Air Lines Inc · Atlanta, GAN395DZDelta Air Lines Inc · Atlanta, GAN396DNDelta Air Lines Inc · Atlanta, GAN397DNDelta Air Lines Inc · Atlanta, GAN398DNBank Of Utah Trustee · Salt Lake City, UTN701FRUmb Bank Na Trustee · Salt Lake City, UTN702FRBank Of Utah Trustee · Salt Lake City, UTN704FRBank Of Utah Trustee · Salt Lake City, UTN705FRBank Of Utah Trustee · Salt Lake City, UTN706FRBank Of Utah Trustee · Salt Lake City, UTN708FRWilmington Trust Co Trustee · Wilmington, DEN709FRWilmington Trust Co Trustee · Wilmington, DEN710FRWilmington Trust Co Trustee · Wilmington, DEN711FRBank Of Utah Trustee · Salt Lake City, UTN712FRWilmington Trust Co Trustee · Wilmington, DEN713FRBank Of Utah Trustee · Salt Lake City, UTN714FRBank Of Utah Trustee · Salt Lake City, UTN715FRWilmington Trust Co Trustee · Wilmington, DEN716FRWells Fargo Trust Co Na Trustee · Salt Lake City, UTN717FRBank Of Utah Trustee · Salt Lake City, UTN718FRUmb Bank Na Trustee · Salt Lake City, UTN719FRWells Fargo Trust Co Na Trustee · Columbia, MDN720FRWilmington Trust Co Trustee · Wilmington, DEN721FRBank Of Utah Trustee · Salt Lake City, UT
Back to Airbus A321-211