OpenAirDocs.org
Turner, MT

Registered aircraft · 39

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 = 'MT' AND g.registrant_city = 'TURNER'
  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.

N1013EBellanca 7GCBC · S/N 970-77Built 1977 · Fouts Chester LN1105APiper PA-18-125 · S/N 18-693Built 1951 · Van Voast Mark AN1529UAir Tractor AT-402 · S/N 402-0849Built 1992 · Snider Scott E DBAN185SQCessna A185F · S/N 18503306Built 1977 · Snider Helicopter Service LLCN2160JCessna T188C · S/N T18803397TBuilt 1979 · Snider Scott DBAN2272ZPiper PA-18 · S/N 18-3549Built 1954 · Mohar Fred B JrN2329YPiper PA-36-300 · S/N 36-8160002Built 1981 · Heppe Andrew S DBAN2831CCessna 170B · S/N 26374Built 1954 · Mohar Fred B JrN2975NCessna 140 · S/N 13233Built 1947 · Van Voast Francis LN3154BCessna 170B · S/N 25396Registration pending, pending cancellationBuilt 1952N3811DCessna 182A · S/N 34511Registration pending, pending cancellationBuilt 1957N3854ZPiper PA-18-150 · S/N 18-7614Warren Air LLCN4212SBeech V35B · S/N D-9954Built 1976 · Colburn Reno BryanN4642MPiper PA-11 · S/N 11-150Built 1947 · Snider Scott EN4695YPiper PA-18-150 · S/N 18-7309019Built 1973 · Snider Scott E DBAN4706HPiper PA-11 · S/N 11496Built 1948 · Snider Scott EN4958DCessna 182A · S/N 51058Built 1958 · Harmon Jon EN4958QCessna A188B · S/N 18802692TBuilt 1976 · Snider Scott E DBAN54972Piper PA-18-150 · S/N 18-7709027Built 1976 · Snider Scott EN579MACessna 150H · S/N 15068081Built 1967 · Jones Andrew WN5859PPiper PA-24-250 · S/N 24-941Built 1959 · Snider Scott EN6134YAir Tractor AT-502B · S/N 502B-0308Built 1995 · Esoteric Aviation LLCN7099XCessna 150A · S/N 15059199Built 1961 · Cornell Donald EN7246PPiper PA-24-250 · S/N 24-2420Built 1960 · Alex John RN731TQCessna A188B · S/N 18803146TSnider Scott E DBAN7532TCessna 172A · S/N 47132Built 1959 · Van Voast Carla JN77165Cessna 140 · S/N 11627Built 1946 · Mohar Fred B JrN787MTPiper PA-18-150 · S/N 18-8425Built 1966 · Heppe Andrew S DBAN8501LPiper PA-25-235 · S/N 25-4915Built 1969 · Snider Scott E DBAN87109Bellanca 7GCBC · S/N 711-74Built 1974 · Van Voast Carla JN8973DPiper PA-18A 150 · S/N 18-6412Built 1958 · Snider Scott E DBAN90987Bellanca 7ECA · S/N 907-73Registration pendingBuilt 1973N9172GCessna A188B · S/N 18801408TRegistration pendingBuilt 1973N92593Cessna A188B · S/N 18802067TBuilt 1975 · Snider Scott E DBAN9391DPiper PA-18A 150 · S/N 18-6663Built 1958 · Snider Scott E DBAN9620ZAviat A-1 · S/N 1195Built 1991 · Baker JoeN9842DPiper PA-22-160 · S/N 22-6733Snider Scott E DBAN9867DPiper PA-18A 150 · S/N 18-6885Built 1959 · Stewart Jacob AN98978Piper PA-12 · S/N 12-335Built 1946 · Harmon Jon E
Back to Turner, MT