OpenAirDocs.org
Brookfield, WI

Registered aircraft · 29

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

Query with SQL
duckdb -csv -c "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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

N106LWLet L-23 SUPER BLANIK · S/N 938106Built 1993 · Cross Counrty Soaring LLCN1245TCostruzioni Aeronautiche Tecna P2008 · S/N 137Built 2017 · Lease A Plane IncN226SRCirrus Design SR22 · S/N 9179Built 2023 · Dairyaire LLCN27EMCirrus Design SR22 · S/N 1798Built 2006 · Stair ColinN28573Grumman American Avn. AA-5B · S/N AA5B0689Built 1977 · Bearpaw Aviation LLCN28800Grumman American Avn. AA-5B · S/N AA5B0821El Tigre Aviation LLCN3310RCessna 182L · S/N 18258610Built 1967 · Seitz Martin VN340NPJeffrey G Williams EUROPA XS · S/N A157Built 2022 · Williams Jeffrey GN341SWPiper PA-32-300 · S/N 32-40592Built 1969 · 13:4 Aviation LLCN3421DCessna 170B · S/N 26964Built 1955 · Gultch Dale RN4023NCessna 120 · S/N 13481Built 1947 · Zembinski RobertN515CDCirrus Design SF50 · S/N 0539Built 2024 · Doering Leasing CoN546KCessna 182T · S/N 18281013Built 2001 · Ward Mark EN5481WPiper PA-28-150 · S/N 28-564Built 1962 · Bawden Frederick MN5548FPiper PA-28-140 · S/N 28-24886Built 1968 · Mueller AlbertN6193MCessna 182T · S/N 18282058Built 2008 · Freiesleben Thomas KN6403ECessna 172 · S/N 46503Built 1959 · Gultch Dale RN6461QMooney M20F · S/N 680003Built 1967 · Ganos ChristN678AJBeech B-60 · S/N P363Built 1975 · Aj Air LLCN73WHPiper PA-23-250 · S/N 27-7305184Bumble Bee Aviation LLCN7412RPiper PA-28-140 · S/N 28-21929Built 1966 · Zembinski Robert AN83429Aeronca 7AC · S/N 7AC-2096Built 1946 · Gultch Dale RN8534NPiper PA-28-235 · S/N 28-11333Built 1969 · Vilar MitchN902KDCirrus Design SR22T · S/N 10364Registration pendingBuilt 2024N92430Piper J3C-65 · S/N 16897Built 1946 · Lange JamesN9361QBeech F33A · S/N CE-359Built 1971 · 61q LLCN9454ACessna 140A · S/N 15275Built 1949 · Zembinski Robert AN956CARaytheon HAWKER 850XP · S/N 258806Premier 850xp LLCN99EEBenardo Mark LANCAIR 360 · S/N 768-320-610Built 2012 · Kwasny David J
Back to Brookfield, WI