# Registered aircraft: Three Rivers, MI

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

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

- [N10540](https://openairdocs.org/aircraft/N10540.md): Terry Lee Brokaw BERKUT · S/N 020 · Brokaw Terry L
- [N1417H](https://openairdocs.org/aircraft/N1417H.md): Aeronca 15AC · S/N 15AC-475 · Built 1949 · Hoag Michael R
- [N1430Q](https://openairdocs.org/aircraft/N1430Q.md): Cessna 150L · S/N 15072730 · Built 1971 · Gearhart Robert H
- [N1917B](https://openairdocs.org/aircraft/N1917B.md): Luscombe 8F · S/N 6344 · Craig Gearhart
- [N209A](https://openairdocs.org/aircraft/N209A.md): Cessna 140 · S/N 14662 · Built 1948 · Lawson Dustin M
- [N2384Q](https://openairdocs.org/aircraft/N2384Q.md): Beech 23 · S/N M-464 · Tailwind Ventures LLC
- [N32711](https://openairdocs.org/aircraft/N32711.md): Piper PA-28-140 · S/N 28-7525102 · Built 1974 · Three Rivers Aero LLC
- [N3700C](https://openairdocs.org/aircraft/N3700C.md): DJI AGRAS T40 · S/N 1581F574B238900100Q4 · Carpenter Tyler A
- [N37PA](https://openairdocs.org/aircraft/N37PA.md): Beech 95-B55 (T42A) · S/N TC-1267 · Three Rivers Aero LLC
- [N3935E](https://openairdocs.org/aircraft/N3935E.md): Aeronca 11BC · S/N 11BC-17 · Built 1947 · Hoag Michael R
- [N48853](https://openairdocs.org/aircraft/N48853.md): Aeronca 0-58B · S/N 0-58B1842 · Hoag Michael R
- [N503WA](https://openairdocs.org/aircraft/N503WA.md): Cessna 172M · S/N 17265025 · Built 1975 · Three Rivers Aero Inc
- [N5114Y](https://openairdocs.org/aircraft/N5114Y.md): Aeronca 15AC · S/N 15AC-326 · Built 1950 · Hoag Michael R
- [N5989A](https://openairdocs.org/aircraft/N5989A.md): Cessna 172 · S/N 28589 · Built 1956 · Brokaw Terry L
- [N6533Y](https://openairdocs.org/aircraft/N6533Y.md): Destiny Powered Parachutes DESTINY XLT · S/N 1B0158 · Built 2001 · Rouch Joel D
- [N734XD](https://openairdocs.org/aircraft/N734XD.md): Cessna 172N · S/N 17269189 · Built 1977 · Byrne David
- [N8168U](https://openairdocs.org/aircraft/N8168U.md): Cessna 150M · S/N 15077905 · Sale reported · Built 1976
- [N8394C](https://openairdocs.org/aircraft/N8394C.md): Piper PA-28-181 · S/N 28-7690132 · Built 1976 · Three Rivers Aero LLC
- [N8481U](https://openairdocs.org/aircraft/N8481U.md): Cessna 172F · S/N 17252381 · Built 1964 · Three Rivers Aero LLC
- [N911GG](https://openairdocs.org/aircraft/N911GG.md): Gearhart J/Gearhart C GA-1 · S/N 01 · Built 2001 · Gearhart Joe L

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

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