Skip to content

Registered aircraft · 14

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

N135ANegative Ghost Rider LLC · Bangor, MEBuilt 1966 · S/N 185-0986 N1591FBaer Monte Wayne · Ronan, MTBuilt 1966 · S/N 185-0973 N1592FReynolds Frederick A · Pilot Point, AKBuilt 1966 · S/N 185-0974 N1595FVertical Horizon Aviation LLC · Sandown, NHBuilt 1966 · S/N 185-0977 N185FCAlaska Dream Center · Wasilla, AKS/N 185-0982 N185NVLanding Gear Works LLC · Renton, WABuilt 1965 · S/N 185-0984 N185ZAPlane Fun Inc Tr Trustee · Snellville, GABuilt 1965 · S/N 185-0983 N4508FStotz Jon · Rockford, MIBuilt 1966 · S/N 185-0990 N459CCLemon James M · Billings, MTBuilt 1971 · S/N 18501916 N4702QDriggs Daniel H · Anchorage, AKBuilt 1966 · S/N 185-1156 N520KWWood Stephen J · Winthrop, MEBuilt 1970 · S/N 18501825 N58302Gillett John W · Hillsboro, ORBuilt 1972 · S/N 18501966 N6968ZMeili Charles E · Kingwood, TXBuilt 1965 · S/N 185-0968 N850WBMorris John A · Phoenix, AZBuilt 1968 · S/N 185-1350

Back to Cessna 185E