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.

N6135EAce Aviation LLC · Mankato, MNBuilt 1980 · S/N 18504003 N61368Department Of Inland Fisheries And Wildlife · Augusta, MEBuilt 1980 · S/N 18504159 N61387Stash Ventures LLC · Virginia Beach, VABuilt 1980 · S/N 18504168 N61388Seidler Matthew J · Anchorage, AKBuilt 1980 · S/N 18504169 N61405Rovey George A · Cove, ORBuilt 1980 · S/N 18504174 N61423State Of Utah · Salt Lake City, UTBuilt 1980 · S/N 18504180 N61438Peot James J · Woodinville, WABuilt 1980 · S/N 18504189 N61441Cook Sterling S · Wasilla, AKBuilt 1980 · S/N 18504191 N61471N484rf LLC · Jackman, MES/N 18504202 N61473U S Department Of Interior · Boise, IDBuilt 1981 · S/N 18504204 N61516Zaikof Bay LLC · Jackson, WYBuilt 1981 · S/N 18504223 N61522Zipay Michael A · Willow, AKS/N 18504226 N61556Clark William J · Kuna, IDBuilt 1981 · S/N 18504230 N61562Airhound Inc · Indian Lake, NYBuilt 1981 · S/N 18504231 N61609Eriksen Bjorn A · Polson, MTBuilt 1981 · S/N 18504235 N61616Wolstenholme Ralph E · Westfield, PABuilt 1981 · S/N 18504237 N6166NBrian C Haggerty LLC · Pembroke Pines, FLBuilt 1981 · S/N 18504302 N6167NMillhorn Farms Inc · Worley, IDS/N 18504303 N616JHHarcatco LLC · Corsicana, TXS/N 18504290 N61742Fox James R · Saint Paul, MNBuilt 1981 · S/N 18504246 N61747Lakes Aircraft LLC · Little Canada, MNBuilt 1981 · S/N 18504248 N61749Kellogg Wade A · Chelsea, MIBuilt 1981 · S/N 18504249 N61757Smith Bradford W · Duluth, MNS/N 18504251 N61766Strange Keith · Lincoln, MES/N 18504253 N617MBKlinger Ronald S Trustee · Olympia, WABuilt 1977 · S/N 18503316 N61811Schok Jr Richard N · Fairbanks, AKBuilt 1981 · S/N 18504259 N61861Pulley Richard A · Chugiak, AKBuilt 1981 · S/N 18504265 N61885Libby Stephen R Trustee · Anchorage, AKBuilt 1981 · S/N 18504269 N61919Tailspin LLC · Belle Chasse, LABuilt 1981 · S/N 18504274 N61955Tommys Flying Service Inc · Sherrill, ARBuilt 1981 · S/N 18504280 N61963Grier Timothy R · Anchorage, AKBuilt 1981 · S/N 18504282 N619VMHalberg Barri R · Yacolt, WABuilt 1981 · S/N 18504284 N61ECBald Mountain LLC · Dedham, MEBuilt 1983 · S/N 18504403 N622DCCarter Aviation LLC · Denver, COBuilt 1977 · S/N 18503465 N6275EValiair Limited Co Trustee · Casper, WYBuilt 1980 · S/N 18504017 N627DJLarocque Daniel · Anchorage, AKBuilt 1975 · S/N 18502634 N62ECSharp Aviation LLC · Pauls Valley, OKBuilt 1985 · S/N 18504428 N6307BCarpenter Alan B · Wasilla, AKBuilt 1979 · S/N 18503742 N6325EHaider Ronald J · Southlake, TXBuilt 1980 · S/N 18504024 N6328EFlies & Floats LLC · Baton Rouge, LABuilt 1980 · S/N 18504025 N6397ENorth Country Aviation Aircraft Leasing LLC · Bingham, MEBuilt 1980 · S/N 18504039 N63MGKounis John T · Glendale, CAS/N 18504042 N6420NSouth Aero LLC · Albuquerque, NMBuilt 1981 · S/N 18504307 N646DCMacdonell Randolph A · Grand Rapids, MNBuilt 1975 · S/N 18502781 N6482NBoerboon Jeffrey T · Cave Creek, AZBuilt 1981 · S/N 18504311 N6497EPeoples Mike · Rockwall, TXBuilt 1980 · S/N 18504050 N6504EDietrich Robert R · Elizabeth, COBuilt 1980 · S/N 18504051 N6536HThree Rivers Lake Creek LLC · Kapolei, HIS/N 18503332 N6586EJordan Sidney G · Wasilla, AKBuilt 1980 · S/N 18504057 N6590EHarbor Air LLC · Sitka, AKS/N 18504058

Back to Cessna A185F