# Registered aircraft: Clear Lake, MN

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

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

- [N124HU](https://openairdocs.org/aircraft/N124HU.md): Aviat A-1A · S/N 1413 · Built 1998 · Leaders Kurt W
- [N13PK](https://openairdocs.org/aircraft/N13PK.md): Cessna 310R · S/N 310R2127 · Built 1981 · Oaks Aviation LLC
- [N149MA](https://openairdocs.org/aircraft/N149MA.md): Estumkeda Ltd DBA Micco Acft MAC-145B · S/N 260005 · Built 2001 · Oaks Aviation LLC
- [N2831P](https://openairdocs.org/aircraft/N2831P.md): Consolidated Aeronautics LAKE LA-4-200 · S/N 922 · Built 1978 · Oaks Aviation LLC
- [N285D](https://openairdocs.org/aircraft/N285D.md): Beech F17D · S/N 256 · Leaders Bob
- [N293CC](https://openairdocs.org/aircraft/N293CC.md): Cochran Charles Julian BAKENG DUCE · S/N HOMEBUILT · Oaks Aviation LLC
- [N318A](https://openairdocs.org/aircraft/N318A.md): Beech 95-C55 · S/N TE-229 · Built 1966 · Leaders Robert O
- [N42080](https://openairdocs.org/aircraft/N42080.md): Piper J3C-65 · S/N 14307 · Leaders Bob O
- [N4308H](https://openairdocs.org/aircraft/N4308H.md): Piper PA-15 · S/N 15-91 · Built 1948 · Leaders Bob O
- [N46015](https://openairdocs.org/aircraft/N46015.md): Cessna 172I · S/N 17256988 · Leaders Flying Service LLC
- [N5149H](https://openairdocs.org/aircraft/N5149H.md): Piper PA-14 · S/N 14-159 · Built 1948 · Leaders Bob O
- [N5716H](https://openairdocs.org/aircraft/N5716H.md): Piper PA-16 · S/N 16-328 · Built 1949 · Leaders Flying Service LLC
- [N5877T](https://openairdocs.org/aircraft/N5877T.md): Cessna 185D · S/N 185-0777 · Leaders Kurt W
- [N595D](https://openairdocs.org/aircraft/N595D.md): Cessna 170B · S/N 20747 · Lieberg Craig
- [N6014W](https://openairdocs.org/aircraft/N6014W.md): Piper PA-28-140 · S/N 28-20014 · Built 1964 · Leaders Bob O
- [N70699](https://openairdocs.org/aircraft/N70699.md): Piper PA-18-150 · S/N 18-8357 · Built 1966 · Cencer Kevin J
- [N720RT](https://openairdocs.org/aircraft/N720RT.md): Toby Ronald E VOL SPORTSMAN VJ-22 · S/N 678 · Built 1985 · Leaders Kurt W
- [N7252G](https://openairdocs.org/aircraft/N7252G.md): Cessna 172K · S/N 17258952 · Built 1970 · Leaders Flying Service LLC
- [N7301M](https://openairdocs.org/aircraft/N7301M.md): Cessna 175 · S/N 55601 · Built 1958 · Leaders Bob O
- [N783E](https://openairdocs.org/aircraft/N783E.md): Cessna 180D · S/N 18051001 · Built 1961 · Lieberg Craig M
- [N80680](https://openairdocs.org/aircraft/N80680.md): Globe GC-1B · S/N 1085 · Leaders Bob
- [N8133Y](https://openairdocs.org/aircraft/N8133Y.md): Piper PA-30 · S/N 30-1245 · Built 1966 · Leaders Bob O
- [N81910](https://openairdocs.org/aircraft/N81910.md): Aeronca 7EC · S/N 7AC-533 · Leaders Bob
- [N8590M](https://openairdocs.org/aircraft/N8590M.md): Beech P35 · S/N D-7293 · Leaders Chase N
- [N9449B](https://openairdocs.org/aircraft/N9449B.md): Cessna 175 · S/N 55249 · Built 1958 · Leaders Bob O
- [N9716E](https://openairdocs.org/aircraft/N9716E.md): Aeronca 11AC · S/N 11AC-1359 · Ervin William B

## 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 = 'MN' AND g.registrant_city = 'CLEAR LAKE'
ORDER BY g.n_number
```

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