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.

N300KRPiper PA-28R-200 · S/N 28R-7635210Built 1976 · Wisconsin Aviation-Four Lakes IncN3016SCessna 150G · S/N 15066916Built 1967 · Bartholomew Dana CN308NRTextron 182T · S/N 18283262Built 2024 · State Of WisconsinN312TSAmerican Champion 7GCAA · S/N 408-98Built 1998 · Woodford John EN313MBBell 206B · S/N 3001Built 1980 · Sri Sky LLCN315HCCessna 525 · S/N 525-0373Built 2000 · Hooper Holdings LLCN316LRCirrus Design SR22 · S/N 0841Built 2004 · Lake WendellN3182RCessna 182L · S/N 18258582Built 1967 · Seven Hills Sky Divers IncN318EBEdwards Robert G VANS RV-8 · S/N 81878Built 2016 · Edwards Robert GN3217Lubben Thomas H PIETENPOL AIRCAMPER · S/N 217Lubben Thomas HN3238RRobinson Helicopter R44 II · S/N 11646Built 2007 · Sublime Aerials LLCN337SSCessna 337G · S/N 33701716Built 1976 · State Of Wisconsin/DoaN3403XMooney M20E · S/N 1108Built 1966 · Wenkman Michael JN34163Cessna 177B · S/N 17701681Built 1971 · Middleton Aviation Associates LLCN3515XMooney M20F · S/N 670053Built 1966 · Sayre MikkoN351TSBombardier BD-100-1A10 · S/N 20735Built 2018 · Cmfg Life Insurance CoN357CDCirrus Design SR20 · S/N 10793Built 2025 · No Fear Aviation LLCN3666ZPiper PA-22-150 · S/N 22-7564Built 1960 · Wedepohl RichardN37HUAviat A-1C-200 · S/N 3437Built 2024 · No Fear Aviation LLCN3813QBeech A36TC · S/N EA-187Built 1981 · Bemowski PaulN387WPilatus PC-12/45 · S/N 387Built 2001 · State Of WisconsinN389WPilatus PC-12/45 · S/N 389Built 2001 · State Of WisconsinN395WPilatus PC-12/45 · S/N 394Built 2001 · State Of WisconsinN3LWCirrus Design SR22 · S/N 0347Built 2002 · Kyllar LLCN40199Arbc Inc DBA Lindstrand 77A · S/N 5817Built 2024 · Buckley Michael SN40TADJI AGRAS T40 · S/N 64TBL2100201NDTech Ag Air LLCN4142QPiper PA-28-181 · S/N 2843207Built 1999 · Wisconsin Aviation Four Lakes IncN41789Piper PA-28-140 · S/N 28-7425287Flickinger Thomas FN4202XAero Commander 100-180 · S/N 5202Built 1971 · Izzy Air LLCN434SADiamond Aircraft Ind DA 40 NG · S/N 40.NC152Built 2021 · Mitchell Street Aviation IncN4433QCessna 172M · S/N 17261712Built 1973 · Two Dog Enterprises IncN4480HPiper PA-15 · S/N 15-269Built 1948 · Statz Matthias ScottN44ZTMooney M20J · S/N 24-3247Built 1992 · Jensen Erik NN4550XPiper PA-28-140 · S/N 28-7625053Built 1975 · Altitude LLCN4607DBeech G35 · S/N D-4800Built 1956 · Liposcak Curtis JN46254Cessna 172I · S/N 17257139Built 1968 · Schmidt Keven WN4727NCessna 182Q · S/N 18267316Built 1979 · State Of WisconsinN4793TSchleicher KA 6 CR · S/N 6141Built 1963 · Von Tresckow Peter MN480MMEnstrom Helicopter 480B · S/N 5040Built 2001 · Aviation LLCN484ERCessna 172S · S/N 172S8944Built 2001 · Wisconsin Aviation-Four Lakes IncN4868ACessna 310R · S/N 310R1393Built 1978 · Klokner James BN48KWCessna 182RG · S/N R18201190Hughes JamesN49439Cessna 152 · S/N 15281268Built 1978 · Wisconsin Aviation Four Lakes IncN5009ETompkins John C STAR-LITE · S/N 001Wongkit PamornN5044HCessna 172M · S/N 17265315Built 1975 · Coogan Dennis PN511CJHawker Beechcraft HAWKER 850XP · S/N 258836Built 2007 · Gerry Aviation LLCN5219JCessna 172N · S/N 17273737Built 1980 · Upham David EN522PFPeter Feneht XENOS · S/N X0022Built 2005 · Feneht PeterN52828Cessna 177RG · S/N 177RG1281Jacobson Marc AN5482MTaylorcraft BC12-D1 · S/N 10782Built 1946 · Brownell Josh
Back to Madison, WI