OpenAirDocs.org
Middleton, WI

Registered aircraft · 43

Aircraft may not be kept in the town where they are registered. This site does not publish street address information.

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 = 'MIDDLETON'
  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.

N114JMAmerican Champion 8GCBC · S/N 481-2006Built 2006 · C29 Taildragger LLCN122YYCubcrafters CC11-160 · S/N CC11-00283Built 2013 · Kuhn Joseph GN150DRBeech F33A · S/N CE-1473Built 1990 · Van Den Heuvel Michael EN17082Beech D17S · S/N 137Built 1940 · Scaletta Samuel LN18MRCessna 340A · S/N 340A0557Built 1978 · Morey Airplane Co IncN23115Piper J3C-65 · S/N 2925Built 1939 · Scaletta Samuel LN238XADJI AGRAS T40 · S/N 1581F574B226M00101P5Auenson Aerial Drones LLCN242MLCirrus Design SR20 · S/N 10606Built 2025 · Sunset Ridge Aviation LLCN2437FCessna 180H · S/N 18051637Built 1965 · Kuersten Robert SN25850Piper J3F-65 · S/N 3796Built 1939 · Morey Airplane Co IncN264JGRaytheon A36 · S/N E3264Built 1999 · Sparkling Diamond LLCN3013ZPiper PA-28-161 · S/N 28-7916395Built 1979 · Zakos Dean RN3206ECessna 172N · S/N 17271467Built 1978 · Morey Airplane Company IncN344SRProgressive Aerodyne SEAREY LSA · S/N 1052Built 2016 · Soggy Dollar Flyers LLCN3477ECessna 172N · S/N 17271563Built 1978 · Morey Airplane Co IncN416CMCessna 510 · S/N 510-0016Built 2007 · Medex LLCN425GCCessna 425 · S/N 425-0027Built 1981 · Resiak LLCN432ABBeech F33A · S/N CE-1181Built 1987 · Wisco Flyers LLCN438ERCessna 172S · S/N 172S8934Built 2001 · Morey Airplane Company IncN439ERCessna 172S · S/N 172S8935Built 2001 · Morey Airplane Co IncN43LLAviat A-1C-200 · S/N 3313Built 2018 · Glasair III Investors LLCN4777HCessna 152 · S/N 15283978Built 1979 · Morey Airplane Co IncN4879DCessna 172N · S/N 17272384Built 1979 · Morey Airplane Company IncN49125Cessna 152 · S/N 15283426Built 1979 · Morey Airplane Co IncN5056LLake LA-4-200 · S/N 512Built 1972 · Lemon Richard AN525LLLenz James L GLASAIR III · S/N 3263Built 2005 · Glasair III Investors LLCN528DLCirrus Design SR22 · S/N 9004Built 2022 · Llt LLCN5303TCessna 172S · S/N 172S9255Built 2002 · Morey Airplane Co IncN535DLCessna 525B · S/N 525B0172Built 2007 · M2a LLCN603TGMercure Adam D MERCURE EAGLE · S/N 1001Built 2007 · Bucky LLCN6334WCessna 182T · S/N 18282108Built 2008 · Colwell KevinN70739Cessna 152 · S/N 15282595Built 1978 · Morey Airplane Co IncN70KEChariton Farms GLASAIR SPORTSMAN GS · S/N 7502Built 2022 · Schwartz David JN712ANCirrus Design SR22T · S/N 10986Built 2025 · Akn Air LLCN74LPPiper PA-28-140 · S/N 28-25196Built 1968 · Mendota Flyers LLCN756KCCessna U206G · S/N U20604143Built 1977 · Scaletta Enterprises LLCN75706Cessna 172N · S/N 17267888Built 1976 · Morey Airplane Company IncN765MAAviat A-1B · S/N 2221Built 2003 · Rudy LLCN7848CPiper PA-28-181 · S/N 28-7690085Built 1975 · Zeitler ChristopherN8897PPiper PA-24-260 · S/N 24-4351Built 1965 · Fey Ray DN9253NPiper PA-32R-301 · S/N 32R-8013065Jjd LLCN98394Piper J3C-65 · S/N 18579Built 1946 · Hopp Mark WN99UWCirrus Design SR22T · S/N 1551Built 2017 · Taz Aviation LLC
Back to Middleton, WI