# Registered aircraft: Saint Joseph, MI

A list on [Saint Joseph, MI](https://openairdocs.org/faa-place/MI/Saint%20Joseph.md).

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

- [N10WR](https://openairdocs.org/aircraft/N10WR.md): Beech S35 · S/N D-7689 · Built 1964 · Wilson Keith
- [N1337Y](https://openairdocs.org/aircraft/N1337Y.md): Cessna 172C · S/N 17249037 · Built 1961 · Gaipa Aircraft Inc
- [N140JK](https://openairdocs.org/aircraft/N140JK.md): Gerald F Kalin RV-14 · S/N 140601 · Gfk Investments LLC
- [N18594](https://openairdocs.org/aircraft/N18594.md): Cessna 150L · S/N 15073970 · Built 1972 · Robinson Ronald W
- [N201EB](https://openairdocs.org/aircraft/N201EB.md): Mooney M20J · S/N 24-0112 · First renewal notice · Built 1977 · Israel Raj
- [N205CS](https://openairdocs.org/aircraft/N205CS.md): Mooney M20J · S/N 24-0223 · Built 1977 · Fillwock Bryan T
- [N2662U](https://openairdocs.org/aircraft/N2662U.md): Cessna 172D · S/N 17250262 · Built 1963 · Deal Sarah M
- [N276JK](https://openairdocs.org/aircraft/N276JK.md): Piper PA 46-350P · S/N 4636520 · Gfk Investments LLC
- [N287RL](https://openairdocs.org/aircraft/N287RL.md): Piper PA46-500TP · S/N 4697342 · Built 2008 · Southshore Aviation LLC
- [N30TJ](https://openairdocs.org/aircraft/N30TJ.md): Piper PA-30 · S/N 30-762 · Built 1965 · Fiskars Equipment Co
- [N315MS](https://openairdocs.org/aircraft/N315MS.md): Mark Stone SONEX B · S/N SNB 0036 · Built 2025 · Stone Mark E
- [N31HP](https://openairdocs.org/aircraft/N31HP.md): Honda HA-420 · S/N 42000225 · Built 2022 · Tyl Leasing LLC
- [N325U](https://openairdocs.org/aircraft/N325U.md): Cessna 150M · S/N 15076531 · Built 1974 · Kilo Fox Aviation LLC
- [N37HP](https://openairdocs.org/aircraft/N37HP.md): Dunker Dennis L AIR CAM · S/N AC067 · Built 1999 · Tyl Holdings LLC
- [N38HP](https://openairdocs.org/aircraft/N38HP.md): Zohar Krivorot AIR-CAM · S/N AC250 · Built 2018 · Tyl Holdings LLC
- [N404SE](https://openairdocs.org/aircraft/N404SE.md): Piper PA-28R-200 · S/N 28R-7435223 · Built 1974 · Baird Jonathan D
- [N4970Y](https://openairdocs.org/aircraft/N4970Y.md): Yamokoski William GLASTAR · S/N 5377 · Built 2002 · Yamokoski William
- [N529HP](https://openairdocs.org/aircraft/N529HP.md): Cessna T240 · S/N T24002054 · Built 2014 · Tyl Holdings LLC
- [N5848H](https://openairdocs.org/aircraft/N5848H.md): Piper PA-16 · S/N 16-467 · Built 1949 · White Terry W
- [N62724](https://openairdocs.org/aircraft/N62724.md): North American SNJ-5 · S/N 43724 · Built 1958 · Gaipa Aircraft Inc
- [N6759H](https://openairdocs.org/aircraft/N6759H.md): Piper J3C-65 · S/N 19972 · Gaipa Aircraft Inc
- [N71016](https://openairdocs.org/aircraft/N71016.md): Cessna 182M · S/N 18259459 · Built 1968 · Fiesbeck Kirt E
- [N73116](https://openairdocs.org/aircraft/N73116.md): Cessna 172M · S/N 17267272 · Built 1976 · Taildraggers Flyers Inc
- [N733ZP](https://openairdocs.org/aircraft/N733ZP.md): Cessna 172N · S/N 17268681 · Built 1977 · Fruit Belt Flyers Inc
- [N7609S](https://openairdocs.org/aircraft/N7609S.md): Cessna 182Q · S/N 18265257 · Built 1976 · Butzbaugh Elden W Jr
- [N76871](https://openairdocs.org/aircraft/N76871.md): Cessna 140 · S/N 11305 · Built 1946 · Gaipa Tim
- [N7919B](https://openairdocs.org/aircraft/N7919B.md): DJI PHANTOM 4 · S/N 07DDD770B10071 · Vosburg Judson P Jr
- [N8448Z](https://openairdocs.org/aircraft/N8448Z.md): Piper PA-32R-301T · S/N 32R-8129112 · Built 1981 · Bliss Air LLC
- [N845S](https://openairdocs.org/aircraft/N845S.md): Cirrus Design SR22T · S/N 10558 · Built 2025 · Stanage Daniel L
- [N8492Y](https://openairdocs.org/aircraft/N8492Y.md): Piper PA-30 · S/N 30-1655 · Built 1967 · Gaipa Timothy A
- [N94114](https://openairdocs.org/aircraft/N94114.md): Engineering & Research 415-C · S/N 1437 · Built 1946 · Sprunger Gary E
- [N95192](https://openairdocs.org/aircraft/N95192.md): Piper PA-28-140 · S/N 28-25837 · Built 1969 · Kilo Fox Aviation LLC
- [N9795K](https://openairdocs.org/aircraft/N9795K.md): Stinson 108-2 · S/N 108-2795 · Built 1947 · Godfrey Jay D

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

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