OpenAirDocs.org
Gaylord, MI

Registered aircraft · 27

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 = 'MI' AND g.registrant_city = 'GAYLORD'
  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.

N13SHRiter PITTS S1A · S/N 102RBuilt 1974 · Schlemmer Kenneth RN160SFBeech 200 · S/N BB-32Built 1975 · Triumph Aviation LLCN214DFCessna 421B · S/N 421B0461Built 1973 · Gaylord Hangars LLCN2155KMooney M20R · S/N 29-0164Built 1998 · Current Obsession LLCN2516APiper PA-18-135 · S/N 18-2141Built 1953 · Ascension Aviation LLCN30482Piper J3C-65 · S/N 4863Ascension Aviation LLCN31WPBeech E-90 · S/N LW-99Sale reported, pending cancellationBuilt 1974N3615HErcoupe 415-C · S/N 4240Kent Larry AN39749Piper PA-28-181 · S/N 28-7990017Built 1978 · Lentz Kenneth CN4068JCessna 150G · S/N 15065368Built 1966 · Sutton Thomas AN4343UCessna 150D · S/N 15060343Burke Jonathan DN442ZDiamond Aircraft Ind DA 40 · S/N 40.1124Built 2011 · Cowan Holdings Management LLCN5048MTaylorcraft BC12-D · S/N 10348Built 1946 · Anderson Robert DN5165MCessna 172R · S/N 17281092Built 2002 · Al & Zal CorpN627CMNick Smith SMITH CUB 18 · S/N 0085Built 2009 · Ascension Aviation LLCN62HFAngelbear AIRCAM · S/N AC186Built 2016 · Angelbear LLCN67352Beech 58 · S/N TH-1098Built 1979 · Ascension Aviation LLCN6798VCessna 421C · S/N 421C1254Built 1982 · Gaylord Hangars LLCN701NCBeech E-90 · S/N LW-18Built 1972 · North Country Aviation IncN702NCCessna 421B · S/N 421B-0875Eagle Leasing IncN705NCBeech 58 · S/N TH-595Built 1975 · Eagle Leasing IncN706NCCessna 421C · S/N 421C0037Built 1975 · Gaylord Hangers LLCN709NCBeech E-90 · S/N LW-276Built 1978 · Ascension Aviation LLCN710NCBeech 200 · S/N BB-322Built 1977 · North Country Aviation IncN737RXCessna 172N · S/N 17269626Built 1977 · Buckleitner Eric MN8164TCessna 175B · S/N 17556864Kent Larry AN9186ACessna 170A · S/N 18947Built 1949 · Gaylord Hangars LLC
Back to Gaylord, MI