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 ('21101NX')
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 ('21101NX')
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.
N8942RRichards Penny L · Saint Jo, TXN8985RChapman William H · Dayton, OHN9002BWicklander Richard O · Spanaway, WAN9009BSmith Jeffrey · Helena, ALN9016BGray David W · Gnadenhutten, OHN9017BPancake C William Jr · Keyser, WVN9029BWyatt Mary Ellen Personal Representative · Weirsdale, FLN9031BVan Winkle Randy M · Van Buren, MON9032BThurmond Paul J · Huntley, MTN9038BJohnson William Julian · Holly Grove, ARN9039BSpencer Jeffrey D · Rushsylvania, OHN9040BKrog Steven L · Hartford, WIN9042BWennen Erik J · Fairbanks, AKN9043BJohnson Darren R · Greenville, PAN9048BMark A Lenbom · Cameron, WIN9050BKarge Kent K · Quincy, CAN9052BLucas John C · Sutter Creek, CAN9053BKraken Aero LLC · Newport News, VAN9054BOber John A · Candor, NYN9056BPompeo John M · Gorham, MEN9058BHigh Daniel M · Houston, TXN9060BWaite Myron A · Pawlet, VTN9064BHogan Frederick D · Hamilton, OHN9069BDemello Michael B · Phoenix, ORN9070BDavis Hunter R · Morgan, TXN9071BLaney Kevin D · Maiden, NCN9074BWasik Marvin B · Hernando, FLN9075BLaney Charles A · Maiden, NCN9077BMcdaniel Terry · Gig Harbor, WAN9080BAirline Pilot'S Historical Society · St Charles, ILN9084BDorn Kevin J · De Pere, WIN9088BRindler Michael · Apalachicola, FLN9092BBoatright Michael L · Live Oak, FLN9094BKirby Bob O · Moreno Valley, CAN9096BAtkins Steven D · Valley Head, ALN9097BIrvine Paul E · Antioch, CAN91004Dill Terry L · Delphi, INN9128RExtraspecial LLC · Wilmington, DEN945MMurray Richard H · Celina, OHN9805YDavis Richard · Reno, NVN9816YJones Stephen C · Wadsworth, ILN9840YBrown Michael D · Columbia, TNN9851YElliott Carlton P Jr · Rustburg, VAN9857BSouthern Aircraft Consultancy Inc Trustee · Casper, WYN9858YMclaughlin Paul E · Mansfield, OHN9859BMcfag LLC · Delaware, OHN9862BSunny Flying LLC · Kindred, NDN9862YTreml Edward I · Kewaunee, WIN9869YThompson Curtis W · Battleview, NDN9870BAspenglow LLC · Talkeetna, AK
Back to Champion 7FC