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.
N29548Novelli William L · Orangevale, CAN2954XWilson Katelyn · Parkville, MON29554Eagle Sky Patrol · Deadwood, SDN29563Brown Winn D Jr · Horn Lake, MSN29581Bas Part Sales LLC · Greeley, CON29584Eagle Sky Patrol Inc · Deadwood, SDN29585Ramold Corey M · Gretna, NEN2958XCooper Ronald C · Fowlerville, MIN29592Reyner Matthew J · Georgetown, TXN29593Else John J · Toledo, IAN29595Delta Fox Corp · Schaumburg, ILN29596Murray Charles W · Reno, NVN2959XCiochetti David · Kimberly, ORN29617Abbott Barry · Tempe, AZN29619Loudenslager Donald F · Collinsville, OKN2961XLaurina Peter · Knoxville, TNN29625Sale Reported · Fort Myers, FLSale reportedN2962XRomine John M · Broken Arrow, OKN2963XWayner Ronald P · Sutton, AKN29643Campbell Robert A · Dayton, TXN29645Borgman Dale A · Rescue, CAN29651Geurs John Z · Ossian, INN2965XLynch Thomas L · Fort Collins, CON29667Viles Timothy · Bartlett, TNN29673Olson Andrew S · Copper Canyon, TXN2968XJansen Edward M · Hummelstown, PAN2970XMonroe William R · Hawk Point, MON297XWillwerth Lee J · Saline, MIN2982XSale Reported · Lakeland, FLSale reported, canceledN2985XFrazier James R · Adamsville, TNN2988XDoyle Thomas P · San Diego, CAN2989XLabadie Enrique L · Tucson, AZN2991XDewald David J · Fort Wayne, INN2993XKreutzer Charles · Springfield, ILN2994XBas Part Sales LLC · Greeley, CON2996XEagle Sky Patrol Inc · Deadwood, SDN2999XPoore Zack W · Mcdonald, KSN2KFLivingston H Clark · Akron, ALN30013Patton Mark E · Dryden, NYN30014Tri-State Aviators LLC · Ironton, OHN30017Landon Kasiri · Lancaster, CAN30033Mission Aviation Training Academy · Arlington, WAN30040Schaller Neil J · New Athens, ILN30043Singer Mark D · Stafford, VAN30044Air Data Solutions LLC · Natchitoches, LAN30064Avarix Inc · Cool, CAN30096Sirek David G · Fritch, TXN30098Humbert Randy M · Tumtum, WAN30112Leonard Kevin J · Wagner, SDN30116Registration Pending · Benson, AZRegistration pending
Back to Cessna 177