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 ('2072434')
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 ('2072434')
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.
N9193GMach One Velocity LLC · Macomb Twp, MIN91QSFly Diablo Inc · North Wales, PAN9246NWestways Aviation LLC · El Cajon, CAN9283CFoerschler Dale · North Aurora, ILN92FRGliem Robert E Jr · Eddystone, PAN9301ERyan Aircraft Holding LLC · Orlando, FLN9314EHall Kenneth B · Merritt Island, FLN9315ESmith Mark S · Cornville, AZN9321EMertinez Matos Daniel Enrique · Fajardo, PRN9323ESchock Richard F II · Peoria, ILN9326EWest Bend Air Inc · West Bend, WIN9337EMarianas Air Transfer Inc · Saipan, MPN934GRGrossman Robert W · Andover, MAN934TRAris Leasing Inc · Sunnyvale, CAN9358ELechmanski Philip J · Shelter Island, NYN936AZN936az LLC · Miami, FLN936MBBergstrom Aircraft Inc · Pasco, WAN9389ELandr One LLC · Bozeman, MTN938AZN938az LLC · Miami, FLN9390EAmerigo Intl LLC · Miami, FLN9391EGoodin David James · Yerington, NVN9399E9 Echo LLC · Muskogee, OKN9400EVan Anda Aviation LLC · Apopka, FLN940FSYogini Modi · Homestead, FLN9414HVandewalle Robert H · East Tawas, MIN9420EAero Quest LLC · Costa Mesa, CAN9421EStroemsvik Kristian · Strasburg, VAN9424EAero Equities LLC · Ventura, CAN9426EDarcy Aviation LLC · Danbury, CTN9433EKozma Peter · San Diego, CAN9439ESilverhawk Aviation Academy LLC · Caldwell, IDN943KSStark James E Trustee · Sun City, AZN9452EDew Jason L · Krum, TXN9466EGood Flight Aviation LLC · Stockton, CAN9469EParker Duane E · Louisville, KYN946CHCritchfield Flying Service LLC · Rupert, IDN9475EBerzinis Wayne T · Windham, MEN9478EColeman Richard · Menominee, MIN9480EMoyer Aviation Inc · Tobyhanna, PAN9488GTap Solutions Inc · San Diego, CAN949CDDupont Samuel F C · Mount Solon, VAN94CPAhlhorn Travis Wayne · New Braunfels, TXN950DRRjc Skyhawk LLC · Middletown, DEN9568GTakai Hiroyasu · San Jose, CAN964AAFlorida Flight Training Center Inc · Venice, FLN9685GAltitude Asset Management LLC · Waukesha, WIN969JHJls Aviation LLC DBA · Fredericksburg, VAN972FCBlackhawk Holding Corp · Wilmington, DEN975BWWeidendorf Investments LLC · Hinckley, MNN977SQFrech Egon Trustee · Lexington Park, MD
Back to Cessna 172N