# Registered aircraft: Shelby, MI

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

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

- [N2084T](https://openairdocs.org/aircraft/N2084T.md): Piper PA-28R-200 · S/N 28R-7135028 · Built 1970 · Heiss Bryan G
- [N2331W](https://openairdocs.org/aircraft/N2331W.md): Beech A23A · S/N M-928 · Built 1965 · Empire Contractors
- [N2404K](https://openairdocs.org/aircraft/N2404K.md): Silvaire LUSCOMBE 8E · S/N 5131 · Built 1947 · Studer Rodney J
- [N2559J](https://openairdocs.org/aircraft/N2559J.md): Cessna T188C · S/N T18803482T · Built 1979 · Studer Alfred C
- [N3650K](https://openairdocs.org/aircraft/N3650K.md): Piper J3C-65 · S/N 22344 · Mladonicky Jospeh R
- [N3834H](https://openairdocs.org/aircraft/N3834H.md): Ercoupe 415-D · S/N 4535 · Studer Rodney J
- [N4660J](https://openairdocs.org/aircraft/N4660J.md): Cessna T188C · S/N T18803759T · Built 1980 · Studer Al C
- [N5324A](https://openairdocs.org/aircraft/N5324A.md): DJI AGRAS T100 · S/N 1581F8ZLC258K002N0X5 · Better View Farm LLC
- [N5327B](https://openairdocs.org/aircraft/N5327B.md): DJI AGRAS T100 · S/N 1581F8ZLC258K002HVXX · Better View Farm LLC
- [N5367D](https://openairdocs.org/aircraft/N5367D.md): Cessna 180A · S/N 50265 · Built 1958 · Bandrowicz Leon A
- [N62983](https://openairdocs.org/aircraft/N62983.md): Cessna 150F · S/N 15063618 · Studer Rodney J
- [N7066Z](https://openairdocs.org/aircraft/N7066Z.md): Piper PA-25-235 · S/N 25-2848 · Built 1964 · Studer Alfred C
- [N7506Z](https://openairdocs.org/aircraft/N7506Z.md): Piper PA-25-235 · S/N 25-3538 · Built 1965 · Studer Al C
- [N8095P](https://openairdocs.org/aircraft/N8095P.md): Piper PA-24-250 · S/N 24-3344 · Built 1962 · Gramas Illya W
- [N82059](https://openairdocs.org/aircraft/N82059.md): Aeronca 7AC · S/N 7AC-685 · Built 1946 · Studer Rod J
- [N83600](https://openairdocs.org/aircraft/N83600.md): Aeronca 7DC · S/N 7AC-2276 · Built 1946 · Studer Pat
- [N8876M](https://openairdocs.org/aircraft/N8876M.md): Beech A23 · S/N M-618 · Built 1964 · Lohman Curtis
- [N9083R](https://openairdocs.org/aircraft/N9083R.md): Cessna A188B · S/N 18802104T · Built 1975 · Studer Alfred C
- [N9540P](https://openairdocs.org/aircraft/N9540P.md): Piper PA-25-235 · S/N 25-7405628 · Built 1974 · Studer Al C

## 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 = 'SHELBY'
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-place/MI/Shelby/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.