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 ('2072502')
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 ('2072502')
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.
N7002MApte John W · Biddeford, MEN7007MDouble 07 Mike Flyers Inc · Kalispell, MTN7015MWalters Larry L · Venango, NEN7017MDoughty Robert W · Casa Grande, AZN7021MCorro Lee A · Holden, MEN7025MHelms Everett L · Creighton, MON7026MLoerzel Loren · Blair, NEN7031MClarity Aviation LLC · Anchorage, AKN7037MEissinger Joshua · Circle, MTN7039MFurdal Lukasz · Hillsborough, NJN7040MHood Shawn D · Weatherford, TXN7046MCrosby Kenneth R · Trapper Creek, AKN7047MAtkins Daniel S · Verona, WIN7049MBarnett Ruben · Bardstown, KYN7050MCassill Aircraft Leasing · Cedar Rapids, IAN7051MForrest Trevor G · Moorpark, CAN7062MWieler Jay H · Nome, AKFirst renewal noticeN7065MPamair Inc · Wilmington, DEN7068MStaples Norman J · Sussex, WIN7069MJohnson Roger N · Winnemucca, NVN7072MWhisler Jon N · Shady Shores, TXN7075MPs Aviation Inc · Granada, MNN7079MArmstrong Bruce · Port Orchard, WAN7080MMelvin Scott W · Cookson, OKN7084MRush David · Homer, AKN7088MCrouse Dewayne O · Eagle River, AKN7089MWolgemuth Mark P · Lowell, INN7092MBohlke Cliff J · Prosser, WAN7093MSentz Daniel J · Wasilla, AKN7097MLevine Jay Jacob · Los Angeles, CAN7099MLake Rodney D · Alturas, CAN7100MWhiteley Jeffrey L · Jefferson, ORN7107MRussell Dale Christopher · Sierra Vista, AZN7109MFlathead Flying Inc · Bigfork, MTN7111MPlatt Aaron Eugene · Heppner, ORN7113MOgle Tyler E · Eufaula, OKFirst renewal noticeN7114MJohnson Mark A · Bellevue, IDN7115MSatanta Flying Service Inc · Satanta, KSN7117MFly 2 Hope LLC · Hilliard, FLN7119MSutton Aircraft Salvage LLC · Palmer, AKN7124MNelson Daniel G · Meadow, SDN7126MDarling Charles R · Albany, ORN7127MSlinkard Andrew L · Mesa, WAN7128MReid Brian M · Boise, IDN7134MTravis Craig W · Fallon, NVN7143MMiles Richard B · Lompoc, CAN7144MKeno Dale J · Worley, IDN7146MWright Roy E · Tulelake, CAN7149MBarton Danny B Trustee · White City, ORN7153MKeel Jeffrey A · Fort Myers, FL
Back to Cessna 175