# Registered aircraft: Lakeview, MI

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

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

- [N19202](https://openairdocs.org/aircraft/N19202.md): Piper J-2 · S/N 1602 · Built 1937 · Jacobs James A
- [N209JM](https://openairdocs.org/aircraft/N209JM.md): James Murphy VANS RV-10 · S/N 40981 · Built 2015 · Newell George C
- [N2121A](https://openairdocs.org/aircraft/N2121A.md): Piper PA-22-135 · S/N 22-564 · Built 1952 · Gitre Daniel J
- [N26811](https://openairdocs.org/aircraft/N26811.md): Piper J3F-50 · S/N 4191 · Built 1940 · Jacobs James A
- [N376NK](https://openairdocs.org/aircraft/N376NK.md): DJI AGRAS T40 · S/N 1581F574B236300100UP · Kyler Behrenwald LLC
- [N38HA](https://openairdocs.org/aircraft/N38HA.md): Thrush S2R-G10 · S/N G10-170 · Built 2011 · Heritage Ag LLC
- [N4004K](https://openairdocs.org/aircraft/N4004K.md): Ayres S2R-600 · S/N 2488R · Built 1978 · Heritage Ag LLC
- [N41637](https://openairdocs.org/aircraft/N41637.md): Culver LFA · S/N 396 · Jacobs James A
- [N4206P](https://openairdocs.org/aircraft/N4206P.md): Ayres S2R-G10 · S/N G10-166 · Built 2001 · Heritage Ag LLC
- [N4717M](https://openairdocs.org/aircraft/N4717M.md): Piper PA-11 · S/N 11226 · Built 1947 · Jake Air LLC
- [N473YK](https://openairdocs.org/aircraft/N473YK.md): Xag P150 · S/N 186324P1822350826Y2R · Kyler Behrenwald LLC
- [N6386E](https://openairdocs.org/aircraft/N6386E.md): Cessna 172N · S/N 17272013 · Built 1979 · R M Aviation Inc
- [N75007](https://openairdocs.org/aircraft/N75007.md): Boeing 75 · S/N 75-007 · Built 1945 · Draper James V
- [N760BF](https://openairdocs.org/aircraft/N760BF.md): Ayres S2R-G10 · S/N G10-154 · Built 1999 · Heritage Ag LLC
- [N8365B](https://openairdocs.org/aircraft/N8365B.md): Cessna 172 · S/N 36165 · Built 1957 · Hallada David M
- [N8389S](https://openairdocs.org/aircraft/N8389S.md): Cessna 182H · S/N 18256489 · Built 1965 · Griffith Kevin D
- [N915HA](https://openairdocs.org/aircraft/N915HA.md): Thrush S2R-G10 · S/N G10-176 · Built 2013 · Heritage Ag LLC

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

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