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 ('2072431')
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 ('2072431')
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.
N758FV758 Flyers LLC · Longmont, CON758FWLarsen Don A · Kenosha, WIN758FZWright Base Flight Training LLC · Tullahoma, TNN758GBDaystar Aviation LLC · Eugene, ORN758GCAndrews Ralph M · Jacksonville, FLN758GFInflyt LLC · Carlsbad, CAN758HARegistration Pending · Jacksonville, ARRegistration pendingN758HCCentral Air Parts Inc · Staunton, ILN758HKAir Pierre LLC · Orlando, FLN758HLCunningham Robert F · Gibraltar, MIN758HMBwg Hanger LLC · Los Angeles, CAN758HSEdge Of The World Inc · Banner Elk, NCN758HTStinnett Raymond C · Bozeman, MTN758HVLozoya Luis G · Yuma, AZN758JBYuen Kin Chun · Elk Grove, CAN758JDHancock Gregory C · Eastsound, WAN758JGMorton Frank W · Harwinton, CTN758JRTownsend Robert J · Leavenworth, WAN758JSHenderson Scott · Tucson, AZN758JTEdwards Thomas G Trustee · Jacksonville, ORN758JZReaka Dean James Trustee · Troy, MON758KCMccormick Robert C · Vlg Of Lakewd, ILN758KFMorgan Kenneth J · Norridgewock, MEN758KMStrong Janet L · Vancouver, WAN758KRKairys Steven A · Encino, CAN758KVAk Denali Group LLC · Anchorage, AKN758LCDepino Damian P · Dummerston, VTN758LEBernheim Karen M · Sisters, ORN758LJPeery William R · Beckley, WVN758LMSwenson Karine · Anchorage, AKN758LNLittle 8 Mile Ranch LLC · Missoula, MTN758LPTony Joe Aviation LLC · Sheridan, WYN758LRWood Tyler J · Creston, CAN758LSKomizo Enterprises LLC · Fort Worth, TXN758LWTeton Leasing LLC · Pocatello, IDN758LYDixon Craig S · Rimrock, AZN758MHFantasy Flyer LLC · Ojai, CAN758MLStrong Ronald E · Phoenix, AZN758MNTritt Scott W · Bolivar, OHN758MPPickle Brad R · Pottsboro, TXN758MQSarkissian Hovannes · Pasadena, CAN758MSRegistered aircraftN758MTTurbine Financial Group LLC · Ogden, UTN758MVCarson Flying Feeders LLC · Carson, IAN758MWHaddock Debra E · Shelby, NCN758MYMcclellan Steven D · Blackfoot, IDN758MZMowry Valetta J · Greensburg, PAN758NAManabe Osamu · Kapolei, HIN758NBMcdonald Sporting Goods · Murfreesboro, TNN758NCWatkins Herbert L Jr · Durango, CO
Back to Cessna R172K