Skip to content

Registered aircraft · 1,120

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 ('2072821', '2070107')
  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 ('2072821', '2070107')
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.

N185VMGardner Marvin L II · Addison, TXBuilt 1984 · S/N 18504422 N185VPSongbird Aviation Services LLC · Wilmington, DEBuilt 1978 · S/N 18503547 N185VVJetran LLC · Horseshoe Bay, TXBuilt 1985 · S/N 18504435 N185WZeiger William O Jr · Bend, ORBuilt 1978 · S/N 18503589 N185WAEverel Floatplane LLC · Sandia Park, NMBuilt 1976 · S/N 18503054 N185WGPioneer General Engineering Inc · Fallon, NVBuilt 1977 · S/N 18503193 N185WPArrowhead Holdings Inc · Wilmington, DEBuilt 1979 · S/N 18503936 N185WRNorthwoods Aviation Inc · Cadillac, MIBuilt 1976 · S/N 18503121 N185WVScenic Air LLC · Kalispell, MTBuilt 1977 · S/N 18503252 N185WWWright John M · Bellevue, IDBuilt 1981 · S/N 18504310 N185WXChew Scott E · Estes Park, COBuilt 1975 · S/N 18502633 N185WZB H Hildebrand Construction Inc · Cataldo, IDBuilt 1980 · S/N 18504102 N185XSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1982 · S/N 18504220 N185XLBryant Theodore M · Wasilla, AKBuilt 1981 · S/N 18504211 N185XSJepsen John S · Anchorage, AKBuilt 1977 · S/N 18503315 N185XVN185xv LLC · Austin, TXS/N 18503778 N185YLee Bryan D · Rexburg, IDFirst renewal noticeS/N 18502224 N185YHMcdaniel Robert M · Tonasket, WAS/N 18503551 N185YMBarber Michael E · Prescott Valley, AZBuilt 1977 · S/N 18503441 N185YVCul-Aircorp Inc · Wellington, FLBuilt 1978 · S/N 18503546 N185YYDagostino Thomas J · Wasilla, AKS/N 18503195 N185ZMDragon Wagon LLC · Clackamas, ORBuilt 1981 · S/N 18504324 N186AZIz Air LLC · Miami, FLBuilt 1976 · S/N 18503192 N18DADye Paul C · Mcneal, AZBuilt 1977 · S/N 18503439 N1920QAcadian Aircraft Leasing LLC · Rangeley, MEBuilt 1977 · S/N 18503502 N1926QVonimhof Rudolph F · Anchorage, AKBuilt 1977 · S/N 18503503 N192JRCessna 185 LLC · Birmingham, MIS/N 18502286 N1931QKlaes Sheldon T · Fairbanks, AKBuilt 1977 · S/N 18503504 N1951TBachmann Jochen W · Hudson, OHBuilt 1980 · S/N 185-04134 N1977XOne Pft LLC · Denton, MTBuilt 1977 · S/N 18503405 N1979FCote Steven · Carson City, NVS/N 18503753 N1979TOmalley Theodore J · Willow, AKBuilt 1978 · S/N 18503686 N197RDCrockett R · Glenwood Springs, COBuilt 1978 · S/N 18503681 N19DEchelon Right LLC · Nicholasville, KYBuilt 1980 · S/N 18504097 N1RMMeggers Roger D · Baker, MTBuilt 1975 · S/N 18502686 N1SBHattan John A · Goddard, KSBuilt 1974 · S/N 18502377 N205NRState Of Minnesota · Grand Rapids, MNBuilt 1981 · S/N 18504317 N20752Thoft Matthew M · Wasilla, AKBuilt 1976 · S/N 18503041 N20786State Of Alaska · Anchorage, AKBuilt 1976 · S/N 18503042 N2085YLima Romeo Kilo Golf Lp · Worthington, INBuilt 1973 · S/N 18502151 N208SSSeldom Seen Aviation Northwest Inc · Stevensville, MTBuilt 1974 · S/N 18502452 N20969Kembel Robert D · Saint Ignatius, MTBuilt 1976 · S/N 18503049 N211SWOrion Aviation LLC · Jeffersonville, INBuilt 1977 · S/N 18503327 N21218Street Raymond E Jr Trustee · Palmer, AKBuilt 1976 · S/N 18503051 N21546Schroth Charles D · Gustavus, AKBuilt 1976 · S/N 18503062 N2154QBailey John Bryan · Eagle River, AKBuilt 1978 · S/N 18503510 N2167QAnderson Kevin W · Whitman, NES/N 18502483 N21709N 2 Alaska LLC · Talkeetna, AKBuilt 1976 · S/N 18503064 N2171FRegistration Pending · Eagle River, AKRegistration pendingBuilt 1981 · S/N 18504266 N21832Shuman Cecil R Trustee · Chugiak, AKS/N 18503069

Back to Cessna A185F