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.

N548SADiamond Aircraft Ind DA 62 · S/N 62.208Built 2022 · Mitchell Street Aviation IncN567HCHam Howard S SOPWITH PUP · S/N 001Twin Oaks Aviation LLCN569DSDiamond Aircraft Ind DA 40 · S/N 40.648Built 2006 · Capitol City Flyers IncN571MEVans Acft RV-9 · S/N 92260Built 2023 · 314lit LLCN577PJJeffrey J Plantz JP 1 · S/N 001Built 2012 · Plantz Jeffrey JN587SADiamond Aircraft Ind DA 40 NG · S/N 40.NC278Built 2023 · Eagle 5 LLCN601TPCanadair CL-600-2B16 · S/N 5156Built 1994 · Pyle Group LLCN60273Cessna 150J · S/N 15070188Built 1969 · Selover Terry DN60AZEnstrom Helicopter 480B · S/N 5106Built 2007 · Goldleaf Leasing LLCN61266Cessna 180K · S/N 18052779Osborn DouglasN6146QCessna 152 · S/N 15285169Built 1981 · Wisconsin Aviation-Four Lakes IncN618DADarkaero DARKAERO 1 · S/N 0Darkaero IncN6205JPiper PA-28-181 · S/N 28-7690371Built 1976 · Wisconsin Aviation-Four Lakes IncN6303TCessna R182 · S/N R18201965Built 1983 · Pink Pilot LLCN6359WCessna P210N · S/N P21000757Built 1981 · Scarlett Cameron ON6526JPiper PA-28-180 · S/N 28-4964Built 1968 · Mcfeeters MilenaN663NWaco ATO · S/N D-3128Built 1930 · Gypsy Air Tours LLCN669CDCirrus Design SR22 · S/N 8921Built 2022 · No Fear Services LLCN68576Bellanca 7GCBC · S/N 398-72Built 1972 · Robinson Neil AN686SLJennings Paul D VANS RV-6 · S/N 60134Built 2003 · Ratzburg MarkN6886JPiper PA-28-181 · S/N 28-7690421Built 1976 · Flanders David JN689RVBarros Guilherme F RV-9A · S/N 90523Built 2018 · Barros Guilherme FN68FJBellanca 17-30A · S/N 73-30578Built 1973 · Burns James AN6949HPiper J3C-65 · S/N 20185Built 1946 · Balch Samuel PN7039SCessna 182P · S/N 18265051Built 1976 · Hotel Sierra LLCN7084FCessna 180J · S/N 18052721Built 1976 · State Of WisconsinN7151JCessna 172N · S/N 17273903Built 1980 · Lenticularis LLCN71836Luscombe 8A · S/N 3263Built 1946 · Taildragger Adventures Of Madison LLCN738CUCessna TR182 · S/N R18200912Built 1979 · Miller Barton PN752JJabiru USA Sport J230-SP · S/N 804Built 2012 · Read William CharlesN75708Piper J3C-65 · S/N 13296Snamiske John GN75845Cessna 172N · S/N 17267999Built 1976 · Stark Russell AllenN7676AAviat A-1C-200 · S/N 3424Built 2023 · No Fear Aviation LLCN7714CPiper PA-28-181 · S/N 28-7690078Built 1975 · Luebow JensN776RSRaytheon HAWKER 850XP · S/N 258776Built 2006 · Legacy20 Enterprises LLCN77RFEmbraer Executive EMB-505 · S/N 50500864Built 2025 · Goldleaf Leasing LLCN788ABAmerican Champion 8GCBC · S/N 597-2019Built 2019 · Southwind Ventures IncN79358Mooney M20E · S/N 568Built 1965 · Henderson Steven RN80461Champion 7EC · S/N 7EC743Bremer Wilfred PN8113BPiper PA-28-181 · S/N 28-8090128Capitol City Flyers IncN8209DBeech H35 · S/N D-5298Built 1957 · Zukowski HawkinN8214NPiper PA-28-140 · S/N 28-25418Built 1969 · Kuenzi Scott AN8262SPiper PA-28-181 · S/N 28-8190035Built 1980 · Wisconsin Aviation - Four Lakes IncN8276VPiper PA-28-181 · S/N 28-8190056Built 1980 · Northrop John BN82821Piper PA-28RT-201 · S/N 28R-8118014Built 1980 · Wisconsin Aviation - Four Lakes IncN831MACessna 172S · S/N 172S9003Built 2001 · State Of WisconsinN832MACessna 172S · S/N 172S9004Built 2001 · State Of WisconsinN833MACessna 172S · S/N 172S9006Built 2001 · State Of WisconsinN84614Aeronca 7AC · S/N 7AC-3325Built 1946 · Lokken Myron LN8483CSpencer Joe B WAG-A-BOND TRAVELER · S/N 27Built 1981 · Five Lakes Aeromarine LLC
Back to Madison, WI