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 ('2072439', '2072442')
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 ('2072439', '2072442')
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.
N638AGSkywest Leasing Inc · St George, UTN638CTCoast Flight Training And Management Inc · San Diego, CAN639CTCoast Flight Training & Management Inc · San Diego, CAN639EREmbry-Riddle Aeronautical University Inc · Prescott, AZN639SPSpengler Raymond Francis Jr · Longview, TXN63JAWings Over Texas Holdings LLC · Denton, TXN640SPJet Air Inc · Iowa City, IAN641SPRhode Island Air LLC · Providence, RIN642KMNick Heir LLC · Lexington, KYFirst renewal noticeN642SPBlue Sky Aviation Association Inc · Readington, NJN643SPRegistered aircraftN645EPChristiansen Aviation LLC · Wilmington, DEN645PAzul Services LLC · Bozeman, MTN645PD150th Aero Flying Club · Morristown, NJN645SPRegistration Pending · Bennett, CORegistration pendingN645XAzul Services LLC · Bozeman, MTN645ZAzul Services LLC · Bozeman, MTN64657Elite Approach LLC · Chesterfield, MON646DWChristiansen Aviation LLC · Wilmington, DEN646SPVermeylen Donna Lynn · Altamont, TNN647CRChristiansen Aviation LLC · Wilmington, DEN647SPElizabeth City State University · Elizabeth City, NCN648SPHillsboro Aero Academy LLC · Hillsboro, ORN649TCSpartan Education Group LLC · Tulsa, OKN652515280 Flying Club LLC · Castle Pines, CON65290So Cal Leasing LLC · El Cajon, CAN652NDInternational Air Services Inc Trustee · Carson City, NVN652SPChristiansen Aviation LLC · Wilmington, DEN65311Mustang Sally Aviation LLC · Camden, SCN65329Advanced Aviation Group LLC · Frederick, MDN65330Flight Training Aircraft LLC · Wilmington, DEN65331Maxxum Financial Group Inc · Destrehan, LAN65380Mikol Gabriel · Burlington, WIN653KBSkyhawk Aviation Inc · Marietta, GAN653NDPelican Flight Training LLC · San Carlos, CAN65411Simmons Guy M · Paso Robles, CAN65447Maxxum Financial Group Inc · Destrehan, LAN6545365453 LLC · Blaine, MNN65471Overland Aviation LLC · Williston, NDN65499Pacific Quality Controls Inc · Wrightwood, CAN654CSCharlies Angel LLC · New Castle, DEN654NDInternational Air Services Inc Trustee · Carson City, NVN654SPJm Air Holdings LLC · Stevensburg, VAN65501Right Rudder Arizona LLC · Litchfield Park, AZN65537Aces High Aviation LLC · Long Beach, CAN65575Flight Training Aircraft LLC · Wilmington, DEN655NDInternational Air Services Inc Trustee · Carson City, NVN655PDJls Aviation LLC · Sarasota, FLN65637N65637 LLC · Manassas, VAN65647Jmc Aviation LLC · Santa Rosa, CA
Back to Cessna 172S