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.

N732KUnited States Department Of The Interior · Boise, IDBuilt 1980 · S/N 18504103 N7330HKibler Joseph T · Mount Airy, MDBuilt 1977 · S/N 18503365 N7336HGerace William L · Anchorage, AKBuilt 1977 · S/N 18503366 N734HBCalkins David M · Anchorage, AKBuilt 1973 · S/N 18502260 N735AXState Of North Carolina · Raleigh, NCBuilt 1985 · S/N 18504439 N735DNState Of North Carolina · Raleigh, NCBuilt 1985 · S/N 185-04441 N735EACivil Air Patrol · Maxwell Afb, ALBuilt 1985 · S/N 18504442 N735EDState Of North Carolina · Morehead City, NCBuilt 1985 · S/N 185-04443 N735EKState Of North Carolina · Raleigh, NCBuilt 1985 · S/N 185-04444 N735GECianchette Family 3 LLC · Portland, MES/N 18504447 N735HBPierson Bradley A · Anchor Point, AKBuilt 1985 · S/N 18504448 N7372HLindholm Michael D · Anchorage, AKBuilt 1977 · S/N 18503378 N7377HProcaccini Donald Jr · Spring Hill, FLBuilt 1977 · S/N 18503382 N737DMAbove & Beyond Aviation Inc · Anchorage, AKBuilt 1977 · S/N 18503307 N7380HCoggins Craig C · Nome, AKS/N 18503384 N7395HWild Alaska Real Estate LLC · Anchorage, AKBuilt 1977 · S/N 18503388 N73BJJewett Brandon M · Brighton, COBuilt 1975 · S/N 18502798 N73EKOgrin Kirk W · Bigfork, MTBuilt 1978 · S/N 18503464 N73JJJj Ventures LLC · Billings, MTBuilt 1981 · S/N 18504241 N7424NBuck Carl W · Longmont, COBuilt 1981 · S/N 18504325 N747AQQuadrani Anthony L · Kingsford, MIBuilt 1974 · S/N 18502333 N7483QDawson Stewart J · Celina, TXBuilt 1978 · S/N 18503606 N7485CYanover Joseph J · Traverse City, MIBuilt 1974 · S/N 18502373 N749United States Department Of Interior · Boise, IDBuilt 1982 · S/N 18504354 N74CFWincar Air LLC · Doniphan, NEBuilt 1974 · S/N 18502557 N74DFRegistered aircraftS/N 18502474 N74JSHoots Husky LLC · Helena, MTBuilt 1980 · S/N 18504139 N74TWWichmann Gregory Scott · Las Vegas, NVBuilt 1980 · S/N 18504043 N750PMWunsch John D · Anchorage, AKBuilt 1975 · S/N 18502843 N7558HAlaska Bear Safaris LLC · Homer, AKS/N 18503394 N7560HRio Brazos Aviation LLC · Waco, TXBuilt 1977 · S/N 18503396 N7562QKaihai Corp · Wilmington, DEBuilt 1978 · S/N 18503610 N7564HYukon Air Service Inc · Fairbanks, AKBuilt 1977 · S/N 18503397 N7565HWright Kim B · Anchorage, AKBuilt 1977 · S/N 18503398 N757United States Department Of Interior · Boise, IDBuilt 1981 · S/N 18504306 N7573QSpielman Karl K · Cortez, COBuilt 1978 · S/N 18503615 N7574NFloat Plane Services LLC · Saint Petersburg, FLBuilt 1981 · S/N 18504326 N7575HShepp Carl Richard Sr · Billings, MTBuilt 1977 · S/N 18503400 N7593NCenac Towing Co LLC · Houma, LABuilt 1981 · S/N 18504327 N7595QSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 18503622 N7597HCulhane Tim R · Anchorage, AKBuilt 1977 · S/N 18503408 N75CWilliam Roy S · Kendallville, INBuilt 1978 · S/N 18503664 N75CGRichter Aviation Inc · Maxwell, CABuilt 1973 · S/N 18502214 N75TRHale Mitchell D · Chugiak, AKS/N 18502790 N7609QPierson Janice R Trustee · Scio, ORBuilt 1978 · S/N 18503626 N76185Snell Marion Lea · Ackerly, TXS/N 18503013 N761AFranz Construction Inc · Sidney, MTS/N 18504424 N76PHHarker James P · Forest Lake, MNS/N 18503142 N76SCBeaver Creek Adventures LLC · Bangor, MEBuilt 1981 · S/N 18504206 N7701FRegistered aircraftBuilt 1977 · S/N 18503245

Back to Cessna A185F