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 ('8850350')
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 ('8850350')
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.
N29553Eggert Robert S · Port Townsend, WAN29575Gregory Robert · Glenwood, MNN29640Dean James J · Sanford, NCN29642Rankins Virginia J · Tracys Landing, MDN29663Mack Robert E · Ivanhoe, MNN29670Fitch James M · Saint Francisville, LAN29682Rowlett David · Sulphur Rock, ARFirst renewal noticeN29683Sale Reported · Weirton, WVSale reportedN29684Hawkins Brennan J · Superior, WIN29759Gray Shane C · Interlochen, MIN29809Timmons David L · Pierre, SDN29815Franzen Chase M · San Diego, CAN29819Brown Warren W · Foley, ALN29823Sota Charles G Jr · Kirkland, WAN29847Stith Donald M · Fort Worth, TXN29886Lubeck Thomas L · Anchorage, AKN32102Benton Paul N · Manhattan, KSN33927Royer Duane R · Tucson, AZN33931Boehm Darryl K · Mountain Grove, MOFirst renewal noticeN33997Mitchell Trans · Timnath, COFirst renewal noticeN33999Athol Orange Aero Club Inc · Athol, MAN34002Koen Michael L · Kannapolis, NCN34023Boyer Joseph S · Custar, OHN36020Jones Paul W · Fort Wayne, INN36090Verell Edward T · Williamsburg, VAN36102Gallodoro Dolores M · Prattsville, NYN36147Goldsborough Darryl S · Coatesville, PAN36168Sale Reported · Augusta, GASale reported, canceledN36189Winter Stewart J · Edgerton, WIN36218Hvizdak George D · Colliers, WVN36432Walker Andrew J · Knoxville, TNN428Kurtz Daniel · Circleville, OHN7093DTaylor Kenneth R · Seminole, OKN741TCRegistration Pending · Kansas City, MORegistration pending
Back to Taylorcraft BL-65