OpenAirDocs.org
Cooperstown, ND

Registered aircraft · 25

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_state = 'ND' AND g.registrant_city = 'COOPERSTOWN'
  ORDER BY g.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.

N1531SAir Tractor AT-802 · S/N 802-0002Built 1991 · Wakefield Aircraft LLCN157LAAir Tractor AT-802A · S/N 802A-0157Built 2003 · Wakefield Aircraft LLCN1816JCessna 182R · S/N 182-68574Wakefield Aircraft LLCN1827BLuscombe T-8F · S/N 6254Built 1948 · Wakefield John DBA SkywaysN2556RPiper PA-31T1 · S/N 31T-8004003Built 1979 · Red Willow Rescue IncN363PTAyres S2R-T34 · S/N T34-013Wakefield Aircraft LLCN38197Piper PA-28-161 · S/N 28-7716231Built 1977 · Anderson LoranN389CCPiper/Cub Crafters PA-18-150 · S/N 9943CCBuilt 2002 · Aerial Timber Applicators IncN40039Ayres S-2R · S/N 2490RBuilt 1978 · Wakefield Aircraft LLCN425LSGulfstream-Schweizer A/C GULFSTREAM AM G-164B · S/N 598BRed Willow Rescue IncN433FLPiper PA-28-140 · S/N 28-7125217Built 1971 · True North Aviation LLCN4523TDJI AGRAS T50 · S/N 7TNBMEW004089VMueller Dane CN4574JPiper PA-28R-180 · S/N 28R-30439Built 1968 · Wakefield Aircraft LLCN48436Grumman Acft ENG Cor-Schweizer G-164B · S/N 78BBuilt 1976 · Wakefield John DBAN48614Grumman Acft ENG Cor-Schweizer G-164B · S/N 86BBuilt 1976 · Red Willow Rescue IncN4927QCessna A188B · S/N 18802662TBuilt 1976 · Wakefield Aircraft LLCN711BBGrumman Acft ENG Cor-Schweizer G-164A · S/N 1361Red Willow Rescue IncN76ELPiper PA-18 · S/N 18-6189Built 1957 · Red Willow Rescue IncN802KCAir Tractor AT-802A · S/N 802A-0262Built 2007 · Wakefield Aircraft LLCN805DGAir Tractor AT-802A · S/N 802A-0156Built 2003 · Wakefield Aircraft LLCN8098KGulfstream-Schweizer A/C GULFSTREAM AM G-164B · S/N 563BAerial Timber Applicators IncN82196Piper PA-18-150 · S/N 18-7909070Built 1979 · Flying W Ranch JvN8504TAir Tractor AT-802A · S/N 802A-0218Built 2005 · Wakefield Aircraft LLCN9002KAir Tractor AT-802 · S/N 802-0078Built 1999 · Aerial Timber Applicators IncN91092Air Tractor AT-802A · S/N 802A-0005Built 1993 · Wakefield Aircraft LLC
Back to Cooperstown, ND