OpenAirDocs.org
Kingsford, MI

Registered aircraft · 18

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 = 'KINGSFORD'
  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.

N11FWConsolidated Vultee BT-13A · S/N 5274Registration pendingBuilt 1942N218HCBeech C18S · S/N 8281Invader Leasing LLCN237CSPiper PA-28-140 · S/N 28-24230Built 1968 · Horizon Flyers LLCN26VQDouglas A-26B · S/N 41-39486Built 1941 · Continental Aviation IncN36729Stinson 10A · S/N 8129O'Brion Nathan WN57BWCessna 310N · S/N 310N-0154Built 1968 · Northwoods Airlifeline LtdN606PABeech C-45H · S/N 52-10897Registration pendingBuilt 1952N66VQU T V A 66(V-51) · S/N 0857Invader Leasing LLCN6778ACessna 172 · S/N 28878Built 1956 · Quadrani AnthonyN6851XCessna 441 · S/N 441-0212Built 1981 · Upper Peninsula Aviation LLCN693TCCommander 114TC · S/N 20018Built 1997 · Brooks Janousek LLCN697YAPiper PA-28-140 · S/N 28-7125636Built 1971 · Horizon Flyers LLCN7256ABeech A36 · S/N E-2257Built 1985 · Northwoods Airlifeline LtdN747AQCessna A185F · S/N 18502333Built 1974 · Quadrani Anthony LN7797ECessna 150 · S/N 17597Registration pendingBuilt 1959N8455RPiper PA-28-140 · S/N 28-22356Horizon Flyers LLCN858ACCessna 441 · S/N 441-0321Built 1983 · Conquest Enterprises Of Marquette LLCN99420Douglas B-26B · S/N 44-34104Built 1944 · Invader Leasing LLC
Back to Kingsford, MI