Skip to content

Registered aircraft · 537

Aircraft of this model in the FAA registry, by N-number.

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_number

Run 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.

N649ARSmith Roy Dennis · Buckeye, AZBuilt 1959 · S/N 55953 N6501ERobinson James W · Henderson, NVBuilt 1959 · S/N 56001 N6505EHeman Darrick L · Blue Springs, MOBuilt 1959 · S/N 56005 N6506EArmstrong Bruce · Port Orchard, WABuilt 1959 · S/N 56006 N6510EScherer Luis R · Kent, OHBuilt 1959 · S/N 56010 N6511EMckenna Francis · Granville, PABuilt 1959 · S/N 56011 N6517ERed Baron LLC · Middletown, DES/N 56017 N6518EMozingo James C · Hernando, FLBuilt 1959 · S/N 56018 N6520ENichols Matthew Q · Maple Valley, WABuilt 1959 · S/N 56020 N6521EWeaver Clifford A · East Berlin, PABuilt 1959 · S/N 56021 N6523ESkeen Andrew · Lindon, UTBuilt 1959 · S/N 56023 N6524EWhite Wings LLC · Anchorage, AKBuilt 1959 · S/N 56024 N6527ETaylor Carey A · Rainier, WABuilt 1959 · S/N 56027 N6532ERegistration Pending · Maize, KSRegistration pendingS/N 56032 N6537EDittmer Michael C · Springtown, TXS/N 56037 N6540EAerial Crop Care Co · Hebron, NDBuilt 1959 · S/N 56040 N6541EAkers Sean M · East Wenatchee, WAS/N 56041 N6542EBond Ward Thomas · Salem, MOBuilt 1959 · S/N 56042 N6544ESando Jan R · St Louis Park, MNS/N 56044 N6546EMenard Keith L · Bellevue, TXS/N 56046 N6549ENewton Donald H · Lewistown, MTBuilt 1959 · S/N 56049 N6551EMoore Henry J · Deer Park, WABuilt 1959 · S/N 56051 N6557EClor Rosalee G · Saint Clair, MIS/N 56057 N6559ECarlson Garrett R · Ramsey, MNS/N 56059 N6560EAeschliman Arlie W · Tribune, KSBuilt 1959 · S/N 56060 N6563EWorld Aircraft Inc · San Antonio, TXBuilt 1959 · S/N 56063 N6564EAtcheson John R · Franklin, GAS/N 56064 N6565EGeyer Brian E · Souderton, PAS/N 56065 N6567EHastings Larry K · Lubbock, TXBuilt 1959 · S/N 56067 N6571ELersner Bradley D · Katy, TXBuilt 1959 · S/N 56071 N6572EKadlecik John Keith · Boise, IDBuilt 1959 · S/N 56072 N6574EGoodman Bert D · Canaan, MEBuilt 1959 · S/N 56074 N6575EPoutre Robert P · Osceola, WIBuilt 1959 · S/N 56075 N6579ESkinner William T III · Little Rock, ARBuilt 1959 · S/N 56079 N6580EReady Aim Flyer LLC · New Castle, DEBuilt 1959 · S/N 56080 N6592EPreszler Terence H · Braddock, NDBuilt 1959 · S/N 56092 N6596ELaughrey Jeffrey L · Soddy Daisy, TNBuilt 1959 · S/N 56096 N6597EPrintz Thomas L · Springfield, OHBuilt 1959 · S/N 56097 N6601EBiloff Chet A · Palmer, AKBuilt 1959 · S/N 56101 N6602ERivera Joel · Carolina, PRBuilt 1959 · S/N 56102 N6603ERequa Kerry E · Twin Falls, IDBuilt 1959 · S/N 56103 N6605ESmith Daniel · Kingsland, TXS/N 56105 N6607EHoly Cow Flying Club · Fairbanks, AKBuilt 1959 · S/N 56107 N6608EMans David A · Spearman, TXBuilt 1959 · S/N 56108 N6609EClark Andrew M · Bend, ORBuilt 1959 · S/N 56109 N6612EReeser Michael C · Paige, TXBuilt 1959 · S/N 56112 N6615EBranstner August M · Taft, CABuilt 1959 · S/N 56115 N6616EBurger Rodney K · Monroe, UTBuilt 1959 · S/N 56116 N6618EWilson Eliott R · Gallipolis, OHBuilt 1959 · S/N 56118 N6619ECutrubus C Nina DBA · Ogden, UTBuilt 1959 · S/N 56119

Back to Cessna 175