Skip to content

Registered aircraft · 30

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 ('2072812')
  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 ('2072812')
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.

N1318PDye Paul C · Mc Neal, AZBuilt 1965 · S/N 185-0871 N147SHDe Camara Robert Michael · Boone, NCS/N 185-0960 N1508FHaley Wayne C · Okeechobee, FLBuilt 1964 · S/N 1850816 N1512FJordan S G · Wasilla, AKBuilt 1965 · S/N 185-0833 N1515FCain Ronald A · Slidell, TXBuilt 1965 · S/N 185-0844 N1517FSalter 11x LLC · Duluth, MNS/N 185-0854 N1523FGray Rex Lee · Palmer, AKBuilt 1965 · S/N 185-0866 N1526FRegistered aircraftBuilt 1965 · S/N 1850869 N1529FLloyd David M · Grants Pass, ORBuilt 1965 · S/N 185-0872 N1531FWrangell Mountain Air Inc · Palmer, AKS/N 185-0874 N1534FDieckman Raymond DBA · Hamilton, MTBuilt 1965 · S/N 185-0877 N1541FRwr Air Inc · Tok, AKBuilt 1966 · S/N 185-0896 N1554FNovember 1554 Foxtrot LLC · Wilmington, DES/N 185-0921 N1557FFeaga Charles C Jr · Abbot, MEBuilt 1965 · S/N 185-0928 N1559FSchrage Timothy J · Anchorage, AKBuilt 1965 · S/N 185-0930 N1566FSelhay Michael J · Anchorage, AKBuilt 1965 · S/N 185-0943 N1573FSmith David J · Duluth, MNBuilt 1965 · S/N 185-0949 N185AAEoff Joe · Salem, ORS/N 185-0881 N185GCChennault Flying Services LLC · Colorado Springs, COBuilt 1965 · S/N 1850802 N185TADash Aero LLC · Lewes, DEBuilt 1965 · S/N 185-0925 N5700MPangaea Air Service Inc · Aspen, COBuilt 1965 · S/N 185-0857 N5877TLeaders Kurt W · Clear Lake, MNS/N 185-0777 N5885TSale Reported · Cleveland, GASale reportedS/N 185-0785 N5891THutchison John N · Big Lake, AKBuilt 1964 · S/N 1850791 N5892THayden Daniel · North Pole, AKBuilt 1964 · S/N 185-0792 N5895THeligray LLC · Kalispell, MTBuilt 1964 · S/N 185-0795 N5899TBrignac Flying Service LLC · Columbus, MSBuilt 1965 · S/N 1850799 N685LACorr Joshua · Santa Paula, CABuilt 1965 · S/N 185-0876 N75LERegistered aircraftBuilt 1965 · S/N 185-0870 N922MAirline Maintenance Service Inc · Nashville, TNBuilt 1965 · S/N 185-0907

Back to Cessna 185D