Skip to content

Registered aircraft · 22

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

N111EZMayes Robert C · Boise, IDBuilt 1964 · S/N 1850753 N14407Hanson Rod D · Wasilla, AKBuilt 1964 · S/N 185-0676 N185DLLong Steven W · Sheridan, MIBuilt 1964 · S/N 1850690 N185PTHansen Peter N · Wellington, NVBuilt 1964 · S/N 185-0760 N23RGRogers Ralph R · Winifred, MTBuilt 1964 · S/N 185-0693 N2673ZFiske James K · North Andover, MABuilt 1963 · S/N 185-0673 N2679ZRonalter John M · Norristown, PABuilt 1963 · S/N 185-0679 N2691ZHoppert Barry E · Merritt Island, FLBuilt 1964 · S/N 1850691 N393MUsda Forest Service Fepp · Helena, MTBuilt 1964 · S/N 185-0684 N48071Burns Craft LLC · Wilmington, DEBuilt 1964 · S/N 185-0705 N55AXWhite Drew C · Granbury, TXBuilt 1964 · S/N 185-0723 N564CMurray Robert G · Eudora, KSBuilt 1964 · S/N 185-0656 N5803TD&R Aviation LLC · Calhoun, GABuilt 1964 · S/N 185-0703 N5806TSwaz Aviation LLC · Mesa, AZBuilt 1964 · S/N 185-0706 N5811TZurovski Stephen S · Pueblo, COBuilt 1964 · S/N 185-0711 N5813TSimmons David J · Bedford, MABuilt 1964 · S/N 185-0713 N5815TYoung Alexander · Petaluma, CAS/N 185-0715 N5842TArapaho Air LLC · Walnut Grove, CABuilt 1964 · S/N 185-0742 N725Butler Harris K III · Towanda, KSBuilt 1964 · S/N 185-0737 N878JWRegistered aircraftBuilt 1964 · S/N 185-0689 N90PDPj Aviation Holding LLC Trustee · Eden Prairie, MNS/N 1850663 N99HPMckee Eli · Brighton, COBuilt 1964 · S/N 185-0709

Back to Cessna 185C