# Registered aircraft: Ham Lake, MN

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

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

- [N20029](https://openairdocs.org/aircraft/N20029.md): Cessna 172M · S/N 17260944 · Built 1972 · Kedrowski Daniel J
- [N221RL](https://openairdocs.org/aircraft/N221RL.md): Lorenz Richard RV4 · S/N 223 · Built 2023 · Lorenz Richard A
- [N22771](https://openairdocs.org/aircraft/N22771.md): Cessna 150H · S/N 15068508 · Built 1968 · Whitney Walter F
- [N2355R](https://openairdocs.org/aircraft/N2355R.md): Cessna 182G · S/N 18255455 · Built 1964 · Lima Mike Inc
- [N3007W](https://openairdocs.org/aircraft/N3007W.md): Beech 58 · S/N TH-365 · Built 1973 · Lima Mike Inc
- [N46368](https://openairdocs.org/aircraft/N46368.md): Ryan NAVION A · S/N NAV-4-393 · Knoll Thomas R
- [N46380](https://openairdocs.org/aircraft/N46380.md): Ryan NAVION · S/N NAV41152 · Knoll Thomas R
- [N4900K](https://openairdocs.org/aircraft/N4900K.md): Navion NAVION A · S/N NAV-4-1900 · Built 1949 · Knoll Thomas R
- [N50245](https://openairdocs.org/aircraft/N50245.md): Cessna 150H · S/N 15069163 · Built 1968 · Christian Martha J
- [N6627F](https://openairdocs.org/aircraft/N6627F.md): Cessna 150F · S/N 15063227 · Leading Phase LLC
- [N70291](https://openairdocs.org/aircraft/N70291.md): Piper J3C-65 · S/N 17301 · Built 1946 · Kedrowski Daniel J
- [N716B](https://openairdocs.org/aircraft/N716B.md): David J Urban PIPISTREL VIRUS SW · S/N 716 SWN 100IS KIT · Urban David
- [N730ET](https://openairdocs.org/aircraft/N730ET.md): Mooney M20C · S/N 3226 · Wolfgram Patrick Michael
- [N7810](https://openairdocs.org/aircraft/N7810.md): Cessna 182N · S/N 18260671 · Built 1971 · Danger Zone Aviation LLC
- [N7854A](https://openairdocs.org/aircraft/N7854A.md): Cessna 180A · S/N 32751 · Built 1957 · Macglover Richard A
- [N9050X](https://openairdocs.org/aircraft/N9050X.md): Cessna 182D · S/N 18253450 · Built 1961 · Classy Cockpits LLC
- [N9780B](https://openairdocs.org/aircraft/N9780B.md): Cessna 180A · S/N 50078 · Built 1957 · Kedrowski Daniel J

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

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