# Registered aircraft: Lake City, MI

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

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

- [N131BB](https://openairdocs.org/aircraft/N131BB.md): Blackmore William D ZENITH STOL CH 750 · S/N 75-8967 · Blackmore William D
- [N1636D](https://openairdocs.org/aircraft/N1636D.md): Cessna 170B · S/N 20278 · Built 1952 · Deruiter Don DBA
- [N197D](https://openairdocs.org/aircraft/N197D.md): David B Ford RV10 · S/N 40738 · Built 2017 · Ford David B
- [N2216A](https://openairdocs.org/aircraft/N2216A.md): Piper PA-22-135 · S/N 22-619 · Built 1952 · Holliday Thomas E
- [N227LG](https://openairdocs.org/aircraft/N227LG.md): Lloyd G Crandall SEAREY LSX · S/N 1LK542C · Built 2014 · Crandall Lloyd G
- [N2WB](https://openairdocs.org/aircraft/N2WB.md): Bernard THORP T-18B · S/N 151 · Built 1977 · Paquette Daniel
- [N3746J](https://openairdocs.org/aircraft/N3746J.md): Cessna 150G · S/N 15065046 · Built 1966 · Crandall Lloyd G
- [N39079](https://openairdocs.org/aircraft/N39079.md): Luscombe 8A · S/N 1840 · Christy Ronald
- [N4242E](https://openairdocs.org/aircraft/N4242E.md): Aeronca 11CC · S/N 11CC-127 · Built 1947 · Morrell Samuel C
- [N457KW](https://openairdocs.org/aircraft/N457KW.md): Rotorsport UK MTOSPORT 2017 · S/N RSUK-M01968 · Built 2022 · Wallingford Kenneth H
- [N516D](https://openairdocs.org/aircraft/N516D.md): Ford David B RV6 · S/N 25692 · Built 2004 · Ford David B
- [N5397C](https://openairdocs.org/aircraft/N5397C.md): Cessna 140A · S/N 15530 · Built 1950 · Fontana Andrew W
- [N5617F](https://openairdocs.org/aircraft/N5617F.md): Alon A2 · S/N A-217 · Built 1966 · Niemi Fred H
- [N7072B](https://openairdocs.org/aircraft/N7072B.md): Piper PA-18A 150 · S/N 18-5147 · Jenema Jerry W
- [N7339A](https://openairdocs.org/aircraft/N7339A.md): Cessna 172 · S/N 29439 · Built 1957 · Rentfrow Jack D
- [N7427H](https://openairdocs.org/aircraft/N7427H.md): Piper J3C-65 · S/N 20689 · Built 1946 · Deruiter Donald R
- [N77454](https://openairdocs.org/aircraft/N77454.md): Cessna 120 · S/N 11898 · Built 1946 · Granger William B
- [N7919X](https://openairdocs.org/aircraft/N7919X.md): Cessna 172B · S/N 17248419 · Built 1961 · Airheads LLC
- [N8629V](https://openairdocs.org/aircraft/N8629V.md): Bellanca 7ECA · S/N 1087-75 · Horvath Stephen L
- [N91JP](https://openairdocs.org/aircraft/N91JP.md): Beech V35B · S/N D-9810 · Built 1975 · Jackson Gerald M

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

This list as a web page: https://openairdocs.org/faa-place/MI/Lake%20City/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, except the copies of manufacturers’ service documents, which belong to their rights holders.
