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 ('2074512')
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 ('2074512')
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.
N117WWNowak Jerome S · Elmhurst, ILN13BPN13bp LLC · Walla Walla, WAN15DSAll Attitude Aviation Inc · Edgewater, FLN3304QMcnutt Brian K · Mojave, CAN3308QDodson International Parts Inc · Rantoul, KSN3309QB & R Aerial Crop Care Inc · Connell, WAN3315QTcf Ventures LLC · Wilmington, DEN3316QPerson Michael · West Chester, PAN3317QSkynight 17q LLC · Roseville, CAN3318Q2400 Rickenbacker LLC DBA · Auburn, CAN3319QNeuschaefer George H · White Hills, AZN3325QWinrick LLC · Flagstaff, AZN372JCompass Rose Services Inc · Powell Butte, ORN398PGeorge Monte C · Ashland, ORN3VBHarrison Ted W · Grapevine, TXN4123TRace Dean · Chicken, AKN4130TSteven J Leavitt · Avondale, AZN4135TNehls Chevrolet Olds Cadillac · Marshall, TXN4138TLindquist Holdings LLC · Noblesville, INN4154TNunya Business LLC · Middletown, DEN4156TRichard Brady K · Farmers Branch, TXN4159TGholami Amir H · Santa Rosa, CAN4163TKasper Heath · Albany, ORN4181TKeystone Aerial Surveys Inc · Philadelphia, PAN4186TRegistered aircraftN566AGarrett Flying Service Inc · Danbury, TXN590FMTrrek Enterprises LLC · Sunriver, ORN68RDWilliams Gerald L · Malibu, CAN77770Bredder Brett A · Brighton, CON7AEMitchell Michael J · Colcord, OK
Back to Cessna 320D