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.
N927GHB R S Leasing Inc · Wilmington, DEN9287MRkm Leasing LLC · Greenwich, CTN928FGMustang Sally Aviation LLC · Camden, SCN928LPMontana Freedom Riders LLC · Corvallis, MTN92970Elizabeth City State University · Elizabeth City, NCN92HFHeritage Asset Leasing LLC · Ronkonkoma, NYN9303NWings Over Texas Holdings LLC · Denton, TXN9305NRancho Av Leasing LLC · Temecula, CAN9342TChristiansen Aviation LLC · Wilmington, DEN9347TLewis University · Romeoville, ILN934AZN934az LLC · Miami, FLN9362MRegistered aircraftN93673Flight Trainer LLC · Wilmington, DEN93707Vertol Systems Co Inc · Destin, FLN9370RFlight Trainer LLC · Wilmington, DEN937SAAdvanced Aviation Group LLC · Frederick, MDN938SAAa-Aero LLC · Lewes, DEN939SPAero Aircraft 12 LLC · Jacksonville, FLN93HFHeritage Asset Leasing LLC · Ronkonkoma, NYN940RMSchool Of Missionary Aviation Technology · Ionia, MIN941RBTexas Flight Training Aircraft 8 LLC · Wilmington, DEN942FAPropability One LLC · Daytona Beach, FLN943SPLittle Airplanes LLC · Aurora, ORN94461Daytona Aircraft Leasing LLC · Daytona Beach, FLN944AAWings Over Texas Holdings LLC · Denton, TXN944TTSoutheast Aircraft Leasing LLC · Jacksonville, FLN9459CFlight Trainer LLC · Wilmington, DEN945MCPacific Northwest Aircraft Leasing Inc · Meridian, IDN945SAJahawk Leasing LLC · Sugar Grove, ILN94618Flight Trainer LLC · Wilmington, DEN94631Flight Trainer LLC · Wilmington, DEN9463LFlight Trainer LLC · Wilmington, DEN9466XFlight Trainer LLC · Wilmington, DEN94682Flight Trainer LLC · Wilmington, DEN94901Liberty University · Lynchburg, VAN949SPN949sp LLC · California, MDN950LPAmeriflyers Of Texas Inc · Addison, TXN951JAAerochatt LLC · Cleveland, TNN951MCSky Mates Inc · Wilmington, DEN951SCJuliet Charlie Aviation LLC · Scottsdale, AZN951SPN591sp LLC A Series Of Aero Lease LLC · San Antonio, TXN951TAKb Land And Cattle Company LLC · Hood River, ORN9520ZK2 Aviation LLC · Greenwood Village, CON952JAHuerta Holdings Inc · Santa Ana, CAN952SCMike Charlie Aviation LLC · Scottsdale, AZN9530HHorizon Aircraft Sales & Leasing Inc · Chesapeake, VAN95314Menagerie Enterprises Inc · Denison, TXN954JAAdvanced Aviation Group LLC · Frederick, MDN955ACNaples Air Center Inc · Naples, FLN955JAAero Equities LLC · Ventura, CA
Back to Cessna 172S