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 ('2073704')
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 ('2073704')
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.
N30128Mizani Air LLC · San Antonio, TXN30133Ts Fliers LLC · Mount Pleasant, MIN30139Heinitz Bradford C · Arlington, WAN30142Marshman Robert M · Murfreesboro, TNN30145Keno Aviation LLC · Marshfield, MAN30148Tyler Marion B · Lacey, WAN30151Miller Jacob G · Harrison, ARFirst renewal noticeN30153Waters Donovan D · Peoria, AZN30157Cardinal Aviation LLC · Pelham, NHN30158Segroves Jeffrey S · Milledgeville, GAN30166De Jager Henry · Smithville Flats, NYN30179Kowatra Anil K · Lilburn, GAN3017CRoland Kenneth R · Tell City, INN30182Johnson Arnold R · Mina, SDN30189Onguard Aviation LLC · Cottonwood Falls, KSN30195Palmer Peter L · Mission, TXN30198Thomas Mark J · Vacaville, CAN30218Mckillip Kirby G · Kemah, TXN30225Hall Curtis B · Shepherdsville, KYN30231Pankratz Paul J · Lakeville, MNN30235Booher Harold D · Manchester, MON30238Nunley Dwight · Hawkins, TXN30239Jones Gary E · Orange, CAN30250O'Connor Sean J · Newburyport, MAN302DBHouston Chet H · Beaufort, SCN30357Cammack Brian W · Edgewood, NMN30390Rimmer Nathan S · Seattle, WAN3104TBrobst David D · Durango, CON3105TColburn Lant R · Cleburne, TXN3107TRichardson Kroy · Littleton, CON3109TS-J Air LLC · Salem, MON3114TClark Thomas J · Saint George, UTN3118TButts Thomas E · Alma, GAN3121THall Tyler · Billings, MTN3125THamilton Brian H · Currie, MNN3126TNicholson Homer L · Ponca City, OKN3129TMcdaniel Timothy A · Hutchinson, MNN3132TUballe Ruben · Axtell, TXN3133TGiddy Up Aviation LLC · Ada, OKN3138TJones Daniel D · Ekron, KYN3140TSuggs Helen T · Jacksonville, FLN3141TN3141t LLC · Saint Johns, MIN3142TTri State Airmotive LLC · Berryville, ARN3144TKinsfather John D · Fowler, CAN3147TClinton Grant A · Portage Des Sioux, MON3148TMiller John W · Bluffton, INN3149TShugart Fredrick William · Canfield, OHN3153TRegistered aircraftN3155TRobbins Charles R · Trout Creek, MTN3156TSpring Mitchell L · Saint Cloud, FL
Back to Cessna 177