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.
N734FQBraithwait Leonard D · Washougal, WAN734FRWhite Jack A Jr · Naples, FLN734FSDouble Bridges Aviation LLC · Enterprise, ALN734FZArdent Air LLC · Byhalia, MSN734GAN734ga LLC · Wilmington, DEN734GEGoebel Marvin A · Colorado Springs, CON734GFSchroeder Clarence H · Big Lake, AKN734GRN734gr LLC · Grand Prairie, TXN734GSLeverock Richard C · Port Saint Lucie, FLN734GUMidwest Consulting & Management LLC · Oneill, NEN734GXSundance Aviation Inc · Richland, WAN734GYFisher Global LLC · Conway, ARN734HCChandler Air Service Inc · Chandler, AZN734HDState University Of New York · Farmingdale, NYN734HJMb Airworks LLC · Saint Petersburg, FLN734HMWhite Carlos W · Rathdrum, IDN734HVKeaney Patrick A · Auburn, MAN734HZAster Labs Inc · Shoreview, MNN734JAAerodyme Corp · South Burlington, VTN734JBYoung John A · Honea Path, SCN734JDBergman James H · Buckley, WAN734JKKingsky Flight Academy LLC · Lakeland, FLN734JNLyon Logan W · Yukon, OKN734JPVolatus LLC · Limon, CON734JRTraveling Toes LLC · Wilmington, DEN734JSCheek Steve · Monroe, LAN734JXRobinson Miles H Jr · Wister, OKN734JYGriffin Bernard · Peckville, PAN734KAH&M Air LLC · Metamora, MIN734KFMerrill Aviation LLC · Anchorage, AKN734KTFoster Aviation LLC · Germantown, TNN734KUNorthwest Wings LLC · Hillsboro, ORN734KWGrandair Aviation Inc · Grand Ledge, MIN734LAKool Wings Leasing LLC · Indianapolis, INN734LESomsen Max L · Sandy, UTN734LGEdwards Jeffrey S · Raleigh, NCN734LJHarpy Aviation LLC · Renton, WAN734LPSkys The Limit N734lp LLC · Port Saint Lucie, FLN734LQSnohomish Flying Service Inc · Snohomish, WAN734LWDiaz John F · Kingsley, PAN734MCRcfc LLC · Spindale, NCN734MESt Hilaire John A · Turner, MEFirst renewal noticeN734MGVan Anda Aviation LLC · Apopka, FLN734MJAdd Ventures Holdings LLC · Puyallup, WAN734MKFlyby Aviation LLC · Logan, UTN734MNSkynick Enterprises Inc · Tarzana, CAN734MTTca Equities LLC · Advance, NCN734MWFlying Holm LLC · Phoenix, AZN734MXLondon-Corbin Airport Board · London, KYN734NAKramer Thomas F · Lawrenceville, NJ
Back to Cessna 172N