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 ('21101P3')
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 ('21101P3')
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.
N5068XNobles Ronny · Live Oak, FLN5069XWright Bruce M · Rosharon, TXN5070XN566rm LLC · Wilsonville, ORN5077XLussier John A · Greene, RIN5083XFlytails LLC · Pace, MSFirst renewal noticeN5085XAzzalin Giorgio · Jacksonville, FLN5086XJacono Bruce L · Ramona, CAN5087XRichardson Ethan Mack · Mount Pleasant, SCN5096XKanooth Michael L · Washougal, WAN5098XFontenot Reginald J · Church Point, LAN5099XBailey Carlton D · Huntington, WVN5101XWilliams Charles Edward · Scottsdale, AZN5103XPlane And Simple LLC · Lakewood, CON5115XArbaczauskas Stanislaus · Daphne, ALN5124TAnderson Bryan C · Arlington, TNN5129XSmall Aviation No 2 LLC · Villa Rica, GAN5139XGlatthaar Richard J · Burbank, WAN5153TChampion Phyllis W · Reno, NVN5154XTevlin Neal L · Valley, WAN5155TWilkes Marcus W · Simmesport, LAFirst renewal noticeN5155XMassey Karl E L · Monterey, CAN5156XHorton Kelly · Hollis, OKN5163THendrickson Duane J · Rocklake, NDN5166XRegistered aircraftN5168TVrooman Lawrence M · Winterville, NCN5176XThiel Douglas E · Chowchilla, CAN5179XKor Reese W · Piedmont, SDN5180XSouthern Sky Holdings LLC · Macon, GAN5181XKummer Nicolas · Wenatchee, WAN5183TMinier Tryg · Corralitos, CAN5185TRomano Serge · Beaverton, ORN5187TLopes Steve R · Lancaster, WIN5195XSears Wes L · Tacoma, WAN5199XGallarate Raymond D · Sonoma, CAN51GTBowen Austin T · Prairie Township, NDN5221XVandegrift Robert W · Waynesboro, VAN5228XAirbatic LLC · Huntsville, ALN5229XG B Acro Inc · Grandville, MIN5231XHolloway David G · Auburn, CAN5273XToledo Jorge A · Miami, FLN5274XStallings Aircraft Propeller LLC · Wynne, ARN5275XKirschner David R · Mckeesport, PAN5276XSanders Curtis E · Morrison, MON5278XFisher Bryan S · Galveston, TXN5280XHonebein Stacey Allen · Seward, AKN5282XGallentine Gene W · Clayton, KSN5284XJay Heather R · Chico, CAN5BJLinrud Michael A · Velva, NDN6300NGriesman Scott W · Sandy Valley, NVN6303NTaylor Timothy P · Watford City, ND
Back to Champion 7KCAB