OpenAirDocs.org
Madison, WI

Registered aircraft · 176

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

N100DBCessna T210N · S/N 21063970Built 1980 · State Of WisconsinN100HDPiper PA-46-310P · S/N 46-8608003Built 1985 · Long Trace LLCN1033QMooney M20R · S/N 29-0310Built 2003 · Kuhn Marcus JN1050VCessna 180H · S/N 18051966Built 1968 · State Of WisconsinN105KLCirrus Design SR22 · S/N 4461Built 2017 · Wing It LLCN1075HAeronca 15AC · S/N 15AC-94Built 1948 · Bartholomew Dana CN11172Cessna 177B · S/N 17702327Built 1975 · Skaaire SocietyN118JPDJI AGRAS T100 · S/N 1581F8ZLC25B50027924Jdp 3 LLCN1193RCessna 182T · S/N 18281882Built 2007 · State Of WisconsinN120DADJI AGRAS T50 · S/N 1581F6BUB249E001X368Jdp3 LLCN121HBSocata TBM 700 · S/N 1016Built 2014 · Hallick Air Services LLCN1251SCessna 182P · S/N 18264820Built 1976 · Pt Air LLCN127CECostruzioni Aeronautiche Tecna P2008 · S/N 095Built 2015 · Goodman WaltN1285HAeronca 15AC · S/N 15AC-301Sale reportedBuilt 1948N13UWGrant W Petty ZIGOLO · S/N 40Board Of Regents Of The University Of WisconsinN15299Piper PA-28-180 · S/N 28-7305051Built 1972 · Dogra GauravN157DFCessna 172L · S/N 17260646157df LLCN168SRCirrus Design SR20 · S/N 1747Built 2006 · Wisconsin Aviation-Four Lakes IncN16UWAeromarine Lsa ELECTROLITE/ZIGOLO · S/N 48Board Of Regents Of University Of Wisonsin SystemN170CDCirrus Design SR20 · S/N 1076Built 2000 · Strategic Leasing Investments And Consulting LLCN170RKCessna 170B · S/N 26053Built 1953 · Belphegor LLCN17FSCessna 550 · S/N 550-0895Built 1999 · Gore Creek Aviation LLCN182NRCessna 182Q · S/N 18267535Built 1980 · State Of WisconsinN182XPCessna 182P · S/N 18261793Built 1973 · Bd Flight LLCN2045DGlasflugel STD LIBELLE 201B · S/N 13Built 1968 · Von Tresckow PeterN204WRaytheon B300 · S/N FL-204Built 1998 · State Of WisconsinN20824Cessna 182P · S/N 18261236Built 1972 · Seven Hills Skydivers IncN2159QPiper PA-28-161 · S/N 28-7916282Built 1979 · Wisconsin Aviation-Four Lakes IncN215GNeidinger Todd S RV-9 · S/N 91179Built 2010 · Neidinger Todd SN2194LCessna 182T · S/N 18281672Built 2005 · State Of WisconsinN222VVCessna 525B · S/N 525B0233Built 2008 · Jbi Holding LLCN224SJCirrus Design SR22 · S/N 0705Built 2003 · Prestige Aircraft LLCN234SRCirrus Design SR20 · S/N 10748Built 2025 · Frings Airplane Company LLCN2390PPiper PA-22-150 · S/N 22-2781Built 1955 · Lubben Thomas HN23959Cessna 182T · S/N 18281748Built 2006 · State Of WisconsinN2397SCessna 337B · S/N 337-0697Built 1967 · State Of WisconsinN23BKCessna 525 · S/N 525-0198Built 1997 · Big Sky Leasing LLCN2461JCessna 150G · S/N 15065561Built 1966 · Weidemann Wendell SN247STPullen Curtis S RV-7A · S/N 71941Built 2005 · Gustaf Christopher AN24PJSchleicher ASW-24 · S/N 24189Built 1992 · Dunning Francis MN24VFoster Stan VIXEN SERIES 5 · S/N V9405-0010Built 2003 · Weidemann Wendell S TrusteeN261LZDJI AGRAS T40 · S/N 64TBK7H00100JPJdp3 LLCN264KGHylio AG-122 · S/N 010228Weaver ZacharyN271RGCessna R182 · S/N R18200528Built 1978 · Capitol City Flyers IncN2725NCessna 441 · S/N 441-0190Built 1980 · Wisconsin Aviation Four Lakes IncN27XTExtra Flugzeugbau EA 300/L · S/N 1235Built 2006 · Southwind Ventures IncN28289Grumman American Avn. AA-5B · S/N AA5B0529Built 1977 · Souza Edy KN294CSCessna 182T · S/N 18282294Built 2011 · State Of Wisconsin Department Of AdministrationN2953ECessna 172N · S/N 17271383Built 1978 · Jensen James AN2EDStoy James R STOLP ACRODUSTER TOO · S/N A/C-01Built 1991 · Stuckey Roger G
Back to Madison, WI