Skip to content

Registered aircraft · 1,121

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.

N6613NBarreto Manufacturing Inc · La Grande, ORBuilt 1981 · S/N 18504312 N666SBBredin Robert R · Pacific Palisades, CABuilt 1980 · S/N 18503994 N667BCWithrotor Aviation Inc · Lakeview, ORBuilt 1979 · S/N 18503849 N6688HSamaritans Purse · Boone, NCS/N 18503335 N66BLLemon Bryant William Jr · Albuquerque, NMBuilt 1981 · S/N 185-04175 N6705HKobuk Valley Outfitters Co · Kiana, AKBuilt 1977 · S/N 18503337 N686MGMike Golf Holdings LLC · Pinellas Park, FLBuilt 1981 · S/N 18504314 N6895HNyholm Kurt S · Duluth, MNS/N 18503342 N6942FGold Cap LLC · Bremerton, WAS/N 18504018 N6955NSweet Fred A · Loves Park, ILBuilt 1981 · S/N 18504315 N6994HMach 2 LLC · Fairbanks, AKS/N 18503349 N69GVSaltz Clyde · Soldotna, AKBuilt 1975 · S/N 18502725 N6JVRanney Gayle · Cordova, AKBuilt 1974 · S/N 18502397 N70333Northland Aircraft Sales LLC · Fairbanks, AKBuilt 1972 · S/N 18502115 N70341Michels LLC · Wasilla, AKBuilt 1972 · S/N 18502119 N70358Mcgugin Donald W · Anacortes, WAS/N 18502129 N70391Sutton Aircraft Salvage LLC · Palmer, AKBuilt 1973 · S/N 18502144 N70394Halford Richard W · Eagle River, AKS/N 18502147 N70438Sneller Heath E · Annandale, MNBuilt 1973 · S/N 18502170 N70462Alis Russell D · Fairbanks, AKBuilt 1973 · S/N 18502178 N70468Poschwatta Jeffrey R · Kent, WAS/N 18502182 N70487Picazo Daniel M · Rogersville, TNBuilt 1973 · S/N 18502190 N70488Hand Kevin D · Anchorage, AKBuilt 1973 · S/N 18502191 N704BNWipaire Inc · South Saint Paul, MNBuilt 1982 · S/N 18504380 N70712Ivany Hugh Scott · Anchorage, AKBuilt 1976 · S/N 18503059 N70AUQty LLC · Wilmington, DES/N 18503082 N70FFGlassy Water LLC · Portsmouth, NHBuilt 1978 · S/N 18503674 N711FHAntler Air LLC · Klamath Falls, ORBuilt 1980 · S/N 18504014 N714United States Department Of Interior · Boise, IDBuilt 1975 · S/N 18502711 N714JEAllred Mark · Farmington, UTBuilt 1983 · S/N 18504398 N714JQDepartment Of Marine Resources · Augusta, MES/N 18504399 N714KHFlying Moose Alaska LLC · Clear, AKBuilt 1983 · S/N 18504400 N714LSHard Luck Aviation LLC · Tok, AKBuilt 1983 · S/N 18504402 N714MXKubeck Roger A · Dearing, GABuilt 1983 · S/N 18504404 N714NKState Of Alaska · Anchorage, AKBuilt 1983 · S/N 18504405 N714NTJ&K Transportation LLC · Tucson, AZBuilt 1983 · S/N 18504406 N714QKStrittmatter Joseph · Aubrey, TXBuilt 1983 · S/N 18504410 N714QRCannon Mark · Yucaipa, CABuilt 1983 · S/N 18504411 N714QZ20925 Harper Rd LLC · Bend, ORBuilt 1983 · S/N 18504412 N714TLHarshman Jeff C DBA · Cedar Point, KSS/N 18504419 N714ZKWhite Blaine Scott · Castlewood, VABuilt 1985 · S/N 18504440 N71RTaliaferro Aviation LLC · Ardmore, OKS/N 18503942 N720FHParadigm Aviation LLC · Anchorage, AKBuilt 1982 · S/N 18504375 N7239EEnsey Gary D · Finley, OKS/N 18502642 N727United States Department Of Interior · Boise, IDBuilt 1982 · S/N 18504371 N728VPLkc Holdings Inc · Dover, DEBuilt 1978 · S/N 18503614 N72WEWest Elk Air LLC · Gunnison, COBuilt 1979 · S/N 18503854 N7307QN7307q LLC · Wickenburg, AZBuilt 1978 · S/N 18503600 N7318HMichaud Francis G · Marine St Crx, MNBuilt 1977 · S/N 18503359 N7320HAlaska Trophy Safaris Inc · Chugiak, AKBuilt 1977 · S/N 18503360

Back to Cessna A185F