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 ('2072418')
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 ('2072418')
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.
N9779VCoombs Eric S · Louisburg, NCN977KJFalcon Aviation Inc · Southfield, MIN9782VOn Glideslope LLC · Middletown, DEFirst renewal noticeN9792VHavu Aviation LLC · Irvine, CAN9794VCooke George C IV Trustee · Richland, WAN9796VKelley Aircraft LLC · Weyers Cave, VAN979PTCappe Ivestment Group LLC · Homestead, FLN97BSSidewinder Services LLC · Genoa, NVN97MWRudderworks Aviation LLC · Fairfax Station, VAN9811VSteffek Mark E · Alturas, CAN9813VArf Corporation · Brooklyn, NYN9822VJohnson Mark W · Valrico, FLN9824VSafety In Motion Flight Center · Puyallup, WAN982SKRowe Andrew L Jr · Hope, MEN9830VLeading Edge Flight Academy LLC · Bend, ORN9833VMartin Kendall L · Wills Point, TXN9838VWaypoint Equipment LLC · Mckinney, TXN9843VAnderson Erik H · Trinity Center, CAN9844VKorte Daniel J · Marlette, MIN9847VWinder Editha S · Columbus, NMN9848VSuperhawk Flight LLC · Plano, TXN9849QBriggs Christopher T · Manchester, NHN9850VPropability One LLC · Daytona Beach, FLN9859VClayton Jeff · Ivy, VAN985FAFreedom Aviation Inc · Lynchburg, VAN9860QKennedy Roxanne L · Half Moon Bay, CAFirst renewal noticeN9861QFallon Muni Flyers LLC · Fallon, NVN9864QWayman Keith · Longmont, CON9865VPierce Aero LLC · Moore, SCN9867QJohnson Barney · Belleville, ILN9868QStone Aviation Holdings LLC · Myrtle Beach, SCN9868VUsaerogroup Inc · Greenville, SCN9869QFort Smith Flying Club Inc · Fort Smith, ARN986FAFreedom Aviation Inc · Lynchburg, VAN9873QMf Aviation Inc · Reston, VAN9873VChester Charter Inc · Chester, CTN9874QRodas Mary P · Blue Jay, CAN9874VSisler Allen R · Terra Alta, WVN9876QRegistered aircraftN9876VDelhotal Raymond K · West Brooklyn, ILN9878QNesland Patricia M · Burton, WAN9879QCoker Design Group LLC · Campobello, SCN9880QAircraft Resource Center Inc · Lakeville, MNN9881QSky Drivers LLC · Lavalette, WVFirst renewal noticeN9881VShackleford Developments Of Sc LLC · Mount Pleasant, SCN9884VShockley James F · Loves Park, ILN9885QAngel Aviation Inc · Peoria, AZN9885VNix Jacob DBA · Johnson, KSN9886VBognar John W III · Sardinia, NYN9887QTupelo Aeronautics Inc · Tupelo, MS
Back to Cessna 172M