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 ('2072434')
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 ('2072434')
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.
N6263GPerfect Aircraft LLC · Ocala, FLN6265DCommander Funk Llp · Portland, ORN6268DSafety In Motion Flight Center Inc · Puyallup, WAN6269DCongressional Flying Club Inc · Gaithersburg, MDN6274DOracle Aviation LLC · Omaha, NEN6277DBockstiegel Bill C · Leadville, CON6278GAvila Sarah · Long Beach, CAN6282DPlane Junkies LLC · Dover, DEN6285FWright Base Flight Training LLC · Tullahoma, TNN6288DRickwalt David L · Fort Mohave, AZN6289DYecny Enterprises Inc · San Luis Obispo, CAN6289FSbk Aviation LLC · Festus, MON6293GMindy Limited LLC · Muscatine, IAN6295DCandace A Larned Enterprises Inc · Long Beach, CAN6296FCivil Air Patrol Inc · Maxwell Afb, ALN6299DJav Air Services LLC · Anchorage, AKN62GKAugusta Flying Club Inc · Martinez, GAN6301DR&R Aero Services LLC · Eden Prairie, MNN6301EJc Air Academy Inc · Stockton, CAN6306FBaymax Aviation LLC · Ronkonkoma, NYN6307JMiloud Chadd · Fort Worth, TXN6308JKatuzienski Joseph C · Yorktown, VAN6313FTeens In Flight Inc · Palm Coast, FLN6316DRuiz Edinson · Bakersfield, CAN6317DJkg LLC · Murfreesboro, TNN6320FJohn D Strohsahl Pa Trustee · Fort Lauderdale, FLN6325DCox Ronnie L · Whitesburg, GAN6326EKevin Formica Inc · Boca Raton, FLN6326FAirtime Holdings LLC · Charleston, SCN6332DBlue River Aviation LLC · Wasilla, AKN6333FMattuski Joseph C Jr · Parker, COFirst renewal noticeN6337DHomerace Inc DBA · Tulsa, OKN6338FRaritan Valley Flying School · Princeton, NJN6339DContrails II Inc · Kerrville, TXN633MTMajor Air LLC · Charleston, SCN6341JAbriam Darryl Mods B · Jacksonville, FLN6342DCourtney Walter William · Cameron Park, CAN6343DAir One Aircraft LLC · Portage Des Sioux, MON6343ECatskill Mountain Air LLC · Milford, NYN6346D6d Leasing LLC · Englewood, CON6347DAnthelion LLC · Flemington, NJN6349DSprinkle Brent · Hillsboro, TXN6349JH & H Aviation Enterprises LLC · Fairfield, OHN6350DMazza Salvatore M · West Creek, NJN6353DDeland Aviation LLC · Deland, FLN6357DRice John Jr · Maddock, NDN6359DFlying Vikings Inc · Hayward, CAN6364DSuburban Aircraft Leasing And Sales LLC · Sylvania, OHN6365FRindo David J · Lowell, MAN6366FDerose Joseph F · Salt Springs, FL
Back to Cessna 172N