Skip to content

Registered aircraft · 98

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

N1322RMccormick Philip G · Pine Grove, CABuilt 1980 · S/N 18504122 N158DNiehaus James O · Erie, COBuilt 1961 · S/N 1850232 N185ALBohannon James A III · Montgomery, TXBuilt 1961 · S/N 185 0047 N185BCShackelford John S · Roanoke, TXBuilt 1961 · S/N 1850021 N185EEThinair Ventures LLC · Kalispell, MTBuilt 1961 · S/N 1850105 N185EMAikins Laurie R · Bonners Ferry, IDBuilt 1961 · S/N 1850078 N185GBelz John W · Salt Lake City, UTBuilt 1961 · S/N 1850163 N185HHCoyne Greg · Hondo, TXBuilt 1961 · S/N 1850049 N185QBMcinelly Jessica N · Anchorage, AKS/N 185-0131 N185RAA-T Enterprises Ltd · Three Forks, MTBuilt 1967 · S/N 185-1209 N185SNJones Kyle H · Anchorage, AKBuilt 1972 · S/N 185-01943 N185URamin Reuben F · Tomball, TXBuilt 1961 · S/N 185-0230 N185UVClark Stanley E Trustee · Redmond, ORBuilt 1961 · S/N 185-0171 N185WBFodor Scott M · Barryton, MIBuilt 1980 · S/N 18504105 N185YTSutton Aircraft Salvage LLC · Palmer, AKS/N 185-0145 N186DMann Thomas A · Ford, WABuilt 1961 · S/N 185-0127 N23CBNb Tweet And Sons · Nome, AKS/N 18503331 N23FGState Of California Dept Of Fish & Game · Sacramento, CABuilt 1980 · S/N 18504035 N23LHHill Lawrence E · Marion, MTBuilt 1974 · S/N 18502433 N2781DFejes Guide Service Ltd · Anchorage, AKBuilt 1979 · S/N 185-03892 N29970Andrecheck Cynthia R · Bethel, AKBuilt 1981 · S/N 185-04292 N29972Windblown Ranch Inc · Echo, ORBuilt 1981 · S/N 185-04162 N331DFDc-3 Pro Services LLC · Hailey, IDBuilt 1961 · S/N 185-0164 N331DTTolkach Dennis G · Dunlevy, PAS/N 18504238 N345BBBaas Brian J Trustee · Cambridge, MNBuilt 1977 · S/N 18503301 N34VVWattum Investments LLC · Kodiak, AKBuilt 1961 · S/N 185-0036 N389BHHorn Bradley P · Waterloo, ILBuilt 1961 · S/N 185-0098 N4001YHill James J · Saint Helen, MIBuilt 1961 · S/N 1850201 N4014YFogglifter LLC · Mccall, IDS/N 185-0214 N4017Y17y LLC · Parma, IDBuilt 1961 · S/N 185-0217 N4019YWitt William A · Ennis, MTBuilt 1961 · S/N 185-0219 N4022YKelley Kitty K · Albion, IDBuilt 1961 · S/N 185-0222 N4024YJr Aviation LLC · Temple, TXS/N 1850224 N4026YOlsen Scott M · Forest Lake, MNBuilt 1961 · S/N 185-0226 N4031YPemberton Addison J · Spokane, WABuilt 1961 · S/N 1850231 N4037YVfr Ltd · Wilmington, DES/N 1850237 N481HWilliams Stephen C · Georgetown, MEBuilt 1961 · S/N 185-0116 N481USalter 11x LLC · Duluth, MNS/N 18504438 N5011XPro Air LLC · Alexandria, LAS/N 185-0033 N73DAFlying Alaska LLC · Anchorage, AKS/N 185-0119 N7680YMeekin Michael J · Palmer, AKBuilt 1961 · S/N 1850190 N78DEStanley Ryan G · Mossyrock, WAS/N 18503701 N8209UWrangell Mountain Air Inc · Palmer, AKBuilt 1961 · S/N 185-0213 N8541LGreat Basin Aviation LLC · Eagle River, AKS/N 185-0118 N85BPPearce William · Grants Pass, ORBuilt 1961 · S/N 185-0183 N88016Mark Cochran Leasing LLC · Pullman, WAS/N 185-0225 N8AARovey Land And Cattle Co Inc · Parker, AZBuilt 1961 · S/N 185-0208 N907EEEriksen Eric Edward · South Fork, COBuilt 1961 · S/N 1850087 N969KMSk Aircraft LLC · Anchorage, AKBuilt 1961 · S/N 185-0024 N9802XMeise Fred W · Moses Lake, WABuilt 1961 · S/N 1850002

Back to Cessna 185