# Registered aircraft: Union Grove, WI

A list on [Union Grove, WI](https://openairdocs.org/faa-place/WI/Union%20Grove.md).

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

- [N16423](https://openairdocs.org/aircraft/N16423.md): Monocoupe 90A · S/N A-750 · Niemyjski Trevor G
- [N19373](https://openairdocs.org/aircraft/N19373.md): Waco YKS-7 · S/N 5204 · Built 1938 · Niemyjski Trevor G
- [N2825N](https://openairdocs.org/aircraft/N2825N.md): Lockwood Leeza DRIFTER · S/N XP-50398 · Built 1988 · Erickson Joshua J
- [N28988](https://openairdocs.org/aircraft/N28988.md): Piper PA-28-201T · S/N 28-7921029 · Built 1979 · Wittbrich LLC
- [N31931](https://openairdocs.org/aircraft/N31931.md): Aeronca 65-LB · S/N L-12091 · Built 1941 · Evans Cameron Steven
- [N3452T](https://openairdocs.org/aircraft/N3452T.md): Cessna 177 · S/N 17700752 · Kordus Robert A
- [N3884E](https://openairdocs.org/aircraft/N3884E.md): Aeronca 11AC · S/N 11AC-S-78 · Built 1947 · Niemyjski Trevor G
- [N403K](https://openairdocs.org/aircraft/N403K.md): Fleet 2 · S/N 126 · Niemyjski Trevor Gregory
- [N4717](https://openairdocs.org/aircraft/N4717.md): Wille PIENTENPOL AIRCAMPER · S/N AAA-1 · Sale reported
- [N54751](https://openairdocs.org/aircraft/N54751.md): Taylorcraft DCO-65 · S/N 5764 · Built 1943 · Ditcheit Joseph C
- [N6486A](https://openairdocs.org/aircraft/N6486A.md): Cessna 182 · S/N 33286 · Built 1956 · Erickson Jon W
- [N7623B](https://openairdocs.org/aircraft/N7623B.md): Piper J3C-65 · S/N 13963 · Built 1956 · Scheffner Henry W
- [N80422](https://openairdocs.org/aircraft/N80422.md): Slipstream REVELATION · S/N 98013 · Built 1998 · Erickson Joshua J
- [N90485](https://openairdocs.org/aircraft/N90485.md): Washburn Ron FIRESTAR KXP · S/N 297 · Erickson Joshua J
- [N912WK](https://openairdocs.org/aircraft/N912WK.md): Wagner Vern GENESIS · S/N GE01/0001 · Erickson Joshua J
- [N942K](https://openairdocs.org/aircraft/N942K.md): Kelch Frederick W JUST ACFT HIGHLANDER · S/N JA197-02-10 · Built 2010 · Kelch Frederick W

## 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 = 'WI' AND g.registrant_city = 'UNION GROVE'
ORDER BY g.n_number
```

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