# Registered aircraft: Brookfield, WI

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

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

- [N106LW](https://openairdocs.org/aircraft/N106LW.md): Let L-23 SUPER BLANIK · S/N 938106 · Built 1993 · Cross Counrty Soaring LLC
- [N1245T](https://openairdocs.org/aircraft/N1245T.md): Costruzioni Aeronautiche Tecna P2008 · S/N 137 · Built 2017 · Lease A Plane Inc
- [N226SR](https://openairdocs.org/aircraft/N226SR.md): Cirrus Design SR22 · S/N 9179 · Built 2023 · Dairyaire LLC
- [N27EM](https://openairdocs.org/aircraft/N27EM.md): Cirrus Design SR22 · S/N 1798 · Built 2006 · Stair Colin
- [N28573](https://openairdocs.org/aircraft/N28573.md): Grumman American Avn. AA-5B · S/N AA5B0689 · Built 1977 · Bearpaw Aviation LLC
- [N28800](https://openairdocs.org/aircraft/N28800.md): Grumman American Avn. AA-5B · S/N AA5B0821 · El Tigre Aviation LLC
- [N3310R](https://openairdocs.org/aircraft/N3310R.md): Cessna 182L · S/N 18258610 · Built 1967 · Seitz Martin V
- [N340NP](https://openairdocs.org/aircraft/N340NP.md): Jeffrey G Williams EUROPA XS · S/N A157 · Built 2022 · Williams Jeffrey G
- [N341SW](https://openairdocs.org/aircraft/N341SW.md): Piper PA-32-300 · S/N 32-40592 · Built 1969 · 13:4 Aviation LLC
- [N3421D](https://openairdocs.org/aircraft/N3421D.md): Cessna 170B · S/N 26964 · Built 1955 · Gultch Dale R
- [N4023N](https://openairdocs.org/aircraft/N4023N.md): Cessna 120 · S/N 13481 · Built 1947 · Zembinski Robert
- [N515CD](https://openairdocs.org/aircraft/N515CD.md): Cirrus Design SF50 · S/N 0539 · Built 2024 · Doering Leasing Co
- [N546K](https://openairdocs.org/aircraft/N546K.md): Cessna 182T · S/N 18281013 · Built 2001 · Ward Mark E
- [N5481W](https://openairdocs.org/aircraft/N5481W.md): Piper PA-28-150 · S/N 28-564 · Built 1962 · Bawden Frederick M
- [N5548F](https://openairdocs.org/aircraft/N5548F.md): Piper PA-28-140 · S/N 28-24886 · Built 1968 · Mueller Albert
- [N6193M](https://openairdocs.org/aircraft/N6193M.md): Cessna 182T · S/N 18282058 · Built 2008 · Freiesleben Thomas K
- [N6403E](https://openairdocs.org/aircraft/N6403E.md): Cessna 172 · S/N 46503 · Built 1959 · Gultch Dale R
- [N6461Q](https://openairdocs.org/aircraft/N6461Q.md): Mooney M20F · S/N 680003 · Built 1967 · Ganos Christ
- [N678AJ](https://openairdocs.org/aircraft/N678AJ.md): Beech B-60 · S/N P363 · Built 1975 · Aj Air LLC
- [N73WH](https://openairdocs.org/aircraft/N73WH.md): Piper PA-23-250 · S/N 27-7305184 · Bumble Bee Aviation LLC
- [N7412R](https://openairdocs.org/aircraft/N7412R.md): Piper PA-28-140 · S/N 28-21929 · Built 1966 · Zembinski Robert A
- [N83429](https://openairdocs.org/aircraft/N83429.md): Aeronca 7AC · S/N 7AC-2096 · Built 1946 · Gultch Dale R
- [N8534N](https://openairdocs.org/aircraft/N8534N.md): Piper PA-28-235 · S/N 28-11333 · Built 1969 · Vilar Mitch
- [N902KD](https://openairdocs.org/aircraft/N902KD.md): Cirrus Design SR22T · S/N 10364 · Registration pending · Built 2024
- [N92430](https://openairdocs.org/aircraft/N92430.md): Piper J3C-65 · S/N 16897 · Built 1946 · Lange James
- [N9361Q](https://openairdocs.org/aircraft/N9361Q.md): Beech F33A · S/N CE-359 · Built 1971 · 61q LLC
- [N9454A](https://openairdocs.org/aircraft/N9454A.md): Cessna 140A · S/N 15275 · Built 1949 · Zembinski Robert A
- [N956CA](https://openairdocs.org/aircraft/N956CA.md): Raytheon HAWKER 850XP · S/N 258806 · Premier 850xp LLC
- [N99EE](https://openairdocs.org/aircraft/N99EE.md): Benardo Mark LANCAIR 360 · S/N 768-320-610 · Built 2012 · Kwasny David 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 = 'WI' AND g.registrant_city = 'BROOKFIELD'
ORDER BY g.n_number
```

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