OpenAirDocs.org
Sturgis, MI

Registered aircraft · 32

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

N143MECessna 172S · S/N 172S8427Built 2000 · Gateway Of Sturgis LLCN177JLCessna 177B · S/N 17702713Built 1977 · Risko Michael RobertN22LZZepp Lawrence P ZODIAC CH 650B · S/N 65-7560Built 2021 · Zepp Lawrence PN2423BDJI AGRAS T40 · S/N 1581F574B235K00100DECropwatch LLCN283MFDJI AGRAS T40 · S/N 1581F574B226A00101YWFinn & Co Drones LLCN2973WPiper PA-28-161 · S/N 28-8016010Warrior Aircraft CorpN315TRaytheon B36TC · S/N EA-669Bartelt Aviation IncN325ARDJI AGRAS T40 · S/N 1581F574B239K001004CCropwatch LLCN406PEPowrachute PEGASUS · S/N A 406 PEGBuilt 2005 · Dickerson DarwinN4074ASoaring Concepts SKY TREK · S/N 2002008Built 2002 · Gonser Duane JN4101NPiper PA-31-350 · S/N 31-8252010Built 1981 · Gateway Of Sturgis LLCN4317FDJI AGRAS T50 · S/N 1581F6BUB234D00100RXFinn And Co Drones LLCN432CFDJI AGRAS T50 · S/N 1581F6BUB2449001DRD8Finn And Co Drones LLCN451MJBeech A36 · S/N E-2246Built 1985 · Roost Leasing LLCN4577Cessna 172S · S/N 172S8285Built 1999 · Gateway Of Sturgis LLCN47262Aeronca 0-58B · S/N 058B-13213Built 1944 · Rumsey Todd AN4904LPiper PA-28-180 · S/N 28-4271Built 1967 · Schmick David DN493TBeech 35-A33 · S/N CD-309Built 1961 · Soaring Concepts IncN5058PPiper PA-24-250 · S/N 24-507Built 1958 · Bakeman Michael GN619UBDJI AGRAS T100 · S/N 1581F8ZLC258Q0021KV1Cropwatch LLCN64382Cessna 180K · S/N 18052896Built 1977 · Roost Leasing LLCN816WLWoodley James V JR GLASAIR SUPR II S-RG · S/N 2412Built 2009 · Rumsey ToddN823CSCessna 182T · S/N 18282323Built 2012 · Rouch TimothyN83ECPiper PA 46-350P · S/N 4636307Built 2000 · Carter Associates IncN840BCDJI AGRAS T100 · S/N 1581F82LC255800232W1Finn And Co Drones LLCN841BCDJI AGRAS T40 · S/N 1581F574B237600100SNFinn And Co Drones LLCN842BCDJI AGRAS T100 · S/N 1581F8ZLC256A0027MDDFinn And Co Drones LLCN84947Aeronca 7AC · S/N 7AC-3669Built 1946 · Keeslar David LN85474Soaring Concepts SKY TREK · S/N 2004027Built 2004 · Keeslar David LN881RVGrajek Allan J VANS RV-8A · S/N 81574Built 2004 · Keeslar David LN966AAPiper PA-44-180 · S/N 44-7995120Built 1978 · Gateway Of Sturgis LLCN99TLLink John H RV-4 · S/N 1721Built 1998 · Rumsey Todd A
Back to Sturgis, MI