# Registered aircraft: Sturgis, MI

A list on [Sturgis, MI](https://openairdocs.org/faa-place/MI/Sturgis.md).

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

- [N143ME](https://openairdocs.org/aircraft/N143ME.md): Cessna 172S · S/N 172S8427 · Built 2000 · Gateway Of Sturgis LLC
- [N177JL](https://openairdocs.org/aircraft/N177JL.md): Cessna 177B · S/N 17702713 · Built 1977 · Risko Michael Robert
- [N22LZ](https://openairdocs.org/aircraft/N22LZ.md): Zepp Lawrence P ZODIAC CH 650B · S/N 65-7560 · Built 2021 · Zepp Lawrence P
- [N2423B](https://openairdocs.org/aircraft/N2423B.md): DJI AGRAS T40 · S/N 1581F574B235K00100DE · Cropwatch LLC
- [N283MF](https://openairdocs.org/aircraft/N283MF.md): DJI AGRAS T40 · S/N 1581F574B226A00101YW · Finn & Co Drones LLC
- [N2973W](https://openairdocs.org/aircraft/N2973W.md): Piper PA-28-161 · S/N 28-8016010 · Warrior Aircraft Corp
- [N315T](https://openairdocs.org/aircraft/N315T.md): Raytheon B36TC · S/N EA-669 · Bartelt Aviation Inc
- [N325AR](https://openairdocs.org/aircraft/N325AR.md): DJI AGRAS T40 · S/N 1581F574B239K001004C · Cropwatch LLC
- [N406PE](https://openairdocs.org/aircraft/N406PE.md): Powrachute PEGASUS · S/N A 406 PEG · Built 2005 · Dickerson Darwin
- [N4074A](https://openairdocs.org/aircraft/N4074A.md): Soaring Concepts SKY TREK · S/N 2002008 · Built 2002 · Gonser Duane J
- [N4101N](https://openairdocs.org/aircraft/N4101N.md): Piper PA-31-350 · S/N 31-8252010 · Built 1981 · Gateway Of Sturgis LLC
- [N4317F](https://openairdocs.org/aircraft/N4317F.md): DJI AGRAS T50 · S/N 1581F6BUB234D00100RX · Finn And Co Drones LLC
- [N432CF](https://openairdocs.org/aircraft/N432CF.md): DJI AGRAS T50 · S/N 1581F6BUB2449001DRD8 · Finn And Co Drones LLC
- [N451MJ](https://openairdocs.org/aircraft/N451MJ.md): Beech A36 · S/N E-2246 · Built 1985 · Roost Leasing LLC
- [N4577](https://openairdocs.org/aircraft/N4577.md): Cessna 172S · S/N 172S8285 · Built 1999 · Gateway Of Sturgis LLC
- [N47262](https://openairdocs.org/aircraft/N47262.md): Aeronca 0-58B · S/N 058B-13213 · Built 1944 · Rumsey Todd A
- [N4904L](https://openairdocs.org/aircraft/N4904L.md): Piper PA-28-180 · S/N 28-4271 · Built 1967 · Schmick David D
- [N493T](https://openairdocs.org/aircraft/N493T.md): Beech 35-A33 · S/N CD-309 · Built 1961 · Soaring Concepts Inc
- [N5058P](https://openairdocs.org/aircraft/N5058P.md): Piper PA-24-250 · S/N 24-507 · Built 1958 · Bakeman Michael G
- [N619UB](https://openairdocs.org/aircraft/N619UB.md): DJI AGRAS T100 · S/N 1581F8ZLC258Q0021KV1 · Cropwatch LLC
- [N64382](https://openairdocs.org/aircraft/N64382.md): Cessna 180K · S/N 18052896 · Built 1977 · Roost Leasing LLC
- [N816WL](https://openairdocs.org/aircraft/N816WL.md): Woodley James V JR GLASAIR SUPR II S-RG · S/N 2412 · Built 2009 · Rumsey Todd
- [N823CS](https://openairdocs.org/aircraft/N823CS.md): Cessna 182T · S/N 18282323 · Built 2012 · Rouch Timothy
- [N83EC](https://openairdocs.org/aircraft/N83EC.md): Piper PA 46-350P · S/N 4636307 · Built 2000 · Carter Associates Inc
- [N840BC](https://openairdocs.org/aircraft/N840BC.md): DJI AGRAS T100 · S/N 1581F82LC255800232W1 · Finn And Co Drones LLC
- [N841BC](https://openairdocs.org/aircraft/N841BC.md): DJI AGRAS T40 · S/N 1581F574B237600100SN · Finn And Co Drones LLC
- [N842BC](https://openairdocs.org/aircraft/N842BC.md): DJI AGRAS T100 · S/N 1581F8ZLC256A0027MDD · Finn And Co Drones LLC
- [N84947](https://openairdocs.org/aircraft/N84947.md): Aeronca 7AC · S/N 7AC-3669 · Built 1946 · Keeslar David L
- [N85474](https://openairdocs.org/aircraft/N85474.md): Soaring Concepts SKY TREK · S/N 2004027 · Built 2004 · Keeslar David L
- [N881RV](https://openairdocs.org/aircraft/N881RV.md): Grajek Allan J VANS RV-8A · S/N 81574 · Built 2004 · Keeslar David L
- [N966AA](https://openairdocs.org/aircraft/N966AA.md): Piper PA-44-180 · S/N 44-7995120 · Built 1978 · Gateway Of Sturgis LLC
- [N99TL](https://openairdocs.org/aircraft/N99TL.md): Link John H RV-4 · S/N 1721 · Built 1998 · Rumsey Todd A

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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
```

This list as a web page: https://openairdocs.org/faa-place/MI/Sturgis/aircraft

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.