Skip to content

Registered aircraft · 252

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

N185WMWithrotor Aviation Inc · Lakeview, ORBuilt 1967 · S/N 185-1215 N185WSStotlar William B · Pinckneyville, ILBuilt 1971 · S/N 18501855 N185WYBrantner Brian P · Spokane Valley, WABuilt 1967 · S/N 185-1229 N185ZWab Air LLC · Butte, MTBuilt 1968 · S/N 1851363 N185ZZLeading Edge LLC · Scottsdale, AZBuilt 1966 · S/N 185-1029 N186VAplikowski Aviation LLC · Lino Lakes, MNBuilt 1969 · S/N 185-1511 N1917UPinewood Homes LLC · Hayward, WIBuilt 1969 · S/N 185-1588 N1922UFriedrich Richard R · Newtown, CTS/N 185-1593 N1932UFryer Charles Trustee · Glendale, AZBuilt 1969 · S/N 18501623 N1950U3 Stones Productions LLC · Anchorage, AKBuilt 1970 · S/N 18501659 N1954UAircraft Structural Repair Inc · Hamilton, MTBuilt 1970 · S/N 18501665 N1972USparrow Thomas E · Hawley, MNBuilt 1970 · S/N 18501702 N1977UErsland Nile P · Anchorage, AKBuilt 1970 · S/N 18501715 N1978UKilbourn Aldean G · Fairbanks, AKBuilt 1970 · S/N 18501718 N1979UDreger Dean R · Wilbur, WABuilt 1970 · S/N 18501723 N1983UAlpine Air LLC · Cordova, AKBuilt 1970 · S/N 18501731 N1994UBoney C Steven · Bethel, AKBuilt 1970 · S/N 18501761 N1995URegistered aircraftBuilt 1970 · S/N 18501764 N1996USmith Aviation LLC · Sitka, AKBuilt 1970 · S/N 18501765 N1999UKarr Brandon · Everett, WABuilt 1970 · S/N 18501768 N19ECSerra Decca Company LLC · Seattle, WABuilt 1967 · S/N 185-1306 N20RSStendal Russell M · Hollywood, FLBuilt 1970 · S/N 18501826 N210ZZCollins Michael P · Cordova, AKBuilt 1971 · S/N 18501866 N211TCMayer William P · Anchorage, AKS/N 185-1380 N2215TBackcountry Wagons LLC · Kalispell, MTBuilt 1968 · S/N 185-1367 N2217TTango LLC · Anchorage, AKBuilt 1968 · S/N 185-1369 N2219TDls Holdings Inc · Arlington, TXBuilt 1968 · S/N 185-1371 N2223TC & R Leasing LLC · Fairbanks, AKBuilt 1968 · S/N 185-1375 N2229XByers Gary F · Wasilla, AKBuilt 1969 · S/N 185-1509 N2231THewitt David E · Newcastle, MEBuilt 1968 · S/N 185-1383 N2233TSeward Air Taxi LLC · Seward, AKS/N 185-1386 N2236TParks Walter G · Chugiak, AKBuilt 1968 · S/N 185-1390 N2241TWhittock Tyson H · Anchorage, AKS/N 185-1397 N2252TRegistration Pending · Hayward, WIRegistration pending, pending cancellationBuilt 1968 · S/N 185-1410 N2258TJetage Cutting Tech · Henderson, COBuilt 1968 · S/N 185-1416 N2262TMarsh John E · Washington, DCBuilt 1968 · S/N 185-1420 N2267TAeropod Inc · Aurora, COS/N 185-1427 N2303YBentz Fence Company Inc · Lewiston, IDBuilt 1971 · S/N 185-01868 N23CCMadrid Jorge M · Tucson, AZBuilt 1967 · S/N 185-1236 N23FBHektner Douglas M · Girdwood, AKBuilt 1966 · S/N 185-1186 N24187Heil Brad C · Homer, AKBuilt 1972 · S/N 18502031 N2429EByrd David Phillip · King Salmon, AKBuilt 1966 · S/N 185-1172 N2531QRegistered aircraftBuilt 1968 · S/N 185-1373 N25SCBlain Robert John · Billings, MTBuilt 1966 · S/N 185 1055 N2724JHorseshoe Air LLC · Pella, IAS/N 185-1474 N2747JRamstad Phillip J Trustee · Anchorage, AKBuilt 1969 · S/N 185-1497 N2749JFithian Cody D · Wasilla, AKBuilt 1969 · S/N 185-1499 N2756JSquatch Air LLC · Wasilla, AKBuilt 1969 · S/N 185-1506 N2764JMcgregor Daniel A · Denali Park, AKBuilt 1969 · S/N 185-1514 N2768JRussell Mark Alex · Fairbanks, AKBuilt 1969 · S/N 185-1518

Back to Cessna A185E