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 ('2072401')
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 ('2072401')
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.
N7265BHolladay Aviation LLC · Jacksonville, FLN7265YAv8r LLC · Manchester Center, VTN7265ZAtp Aircraft 2 LLC · Wilmington, DEN72662Jwa Flight School LLC · Bolingbrook, ILN72664Advanced Aviation Group LLC · Frederick, MDN7273MPalm Beach Flight Training Corp · Lantana, FLN7275CAvolant Aviation LLC · Mooresville, NCN7275DMoody Bible Institute Of Chicago · Spokane, WAN72788Christiansen Aviation LLC · Wilmington, DEN745BACsa Aircraft Leasing LLC · Salt Lake City, UTN745ZZin Services LLC · Dover, DEN747KTIasco Flight Training Inc · Redding, CAN760BWBridgewater State University · Bridgewater, MAN77LUGerman Farms Inc · Fullerton, NDN781BGVan Anda Aviation LLC · Apopka, FLN782BGMt Aviation LLC · Fairbanks, AKN782WWDraco Flight School DBA · Chino, CAN783BGAir Shares LLC · Casper, WYN784BGSuperior Flying Services LLC · Superior, WIN785BGVermont Flight Academy · South Burlington, VTN789BGM9c146 Aviation LLC · Boynton Beach, FLN793WTRaritan Valley Flying School · Princeton, NJN801PAAnson Air LLC · Sugar Land, TXN808TPAvian Leasing LLC · Bremerton, WAN810KSFargo Jet Center LLC · Fargo, NDN811KSFargo Jet Center LLC · Fargo, NDN812KSUniversity Of Central Missouri · Warrensburg, MON813GFChristiansen Aviation LLC · Wilmington, DEN813KSFargo Jet Center LLC · Fargo, NDN814HAIasco Flight Training Inc · Redding, CAN814KSFargo Jet Center LLC · Fargo, NDN814SAMarion Military Institute · Marion, ALN815CTCoast Flight Training And Management Inc · San Diego, CAN815KSPenner Bruce Wade · Hot Springs, SDN816HAAtp Aircraft 4 LLC · Wilmington, DEN817HAIasco Flight Training Inc · Redding, CAN819CFParlor City Flying Club Inc · Bloomsburg, PAN819KSN819ks LLC · Palm City, FLN820KSUniversity Of Central Missouri · Warrensburg, MON822KTJet Air Inc · Iowa City, IAN823KSKansas State University Salina · Salina, KSN824KSPlanelease LLC · Venice, CAN825KSPlanelease LLC · Venice, CAN826KSPlanelease LLC · Venice, CAN827KSPlanelease LLC · Venice, CAN827MAPs N827ma LLC · Green Bay, WIN828BMChristiansen Aviation LLC · Wilmington, DEN828CFChristiansen Aviation LLC · Wilmington, DEN828FSPerformance Aircraft Sales Inc · Lincoln, NEN8292Gulf Coast Helicopters Inc · Pearland, TX
Back to Cessna 172R