OpenAirDocs.org
Brodhead, WI

Registered aircraft · 52

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

N1000HAeronca 15AC · S/N 15AC-2Built 1948 · Mumm Scott AN10547Piper E-2 · S/N 283Built 1935 · Alfred And Lois Kelch Aviation Museum IncN10736Pietenpol B4AF · S/N 11Davis Trenten EN12619Karner Aero KARNER KOUPE · S/N 7Karner JosephN12942Lovley PIETENPOL SCOUT · S/N SL1Built 1972 · Davis Trenten EN13139Franklin 90 · S/N 105Built 1932 · Alfred And Lois Kelch Aviation Museum IncN13691Pietenpol Russert AIRCAMPER · S/N 1Built 1933 · Rudolf Pietenpol Flying Club LLCN15697Leverentz Earl T WENDT W-2 · S/N LW-103Davis Trenton EN161TPDJI AGRAS T40 · S/N 64TBKBL0020019Stateline Aerial LLCN16262Aeronca LB · S/N 2016Built 1936 · Kelch Aviation MuseumN1648LEbneter Carl J ZENAIR CRICKET MC-12 · S/N 12-0031Brownell Joshua MN18224Pietenpol LS · S/N 20Built 1937 · Alfred & Lois Kelch Aviation Museum IncN18336Taylorcraft A · S/N 69Built 1937 · Davis Trenten EN20723Rearwin 8500 DELUXE · S/N 618DBuilt 1938 · Alfred & Lois Kelch Aviation Museum IncN23146Piper J3C-65 · S/N 2927Davis Trenten EN2449SDJI AGRAS T40 · S/N 64TBKBL002003UStateline Aerial LLCN2709Curtiss Wright TRAVEL AIR 4000 · S/N 475Built 1942 · Alfred And Lois Kelch Aviation Museum IncN27836Piper J4A · S/N 4-1055Built 1940 · Zigmont David EN28729Luscombe 8A · S/N 1490Built 1940 · Davis Ted EN30188Waco UPF-7 · S/N 5619Built 1941 · Bruns Scott AN31382Aeronca 65-TL · S/N L8060TBuilt 1940 · Davis Ted EN3883SCessna 172E · S/N 17251083Built 1964 · Bruns Scott AN412WKelch Alfred H KELCH TA-12 · S/N 2013-1990Built 1990 · Alfred And Lois Kelch Aviation Museum IncN4306SSteenstry Larry E ROSE PARRAKEET · S/N LS101Built 1996 · Alfred & Lois Kelch Aviation Museum IncN431BPBrodhead Pietenpol Association PIETENPOL AIR CAMPER · S/N BPA001Brodhead Pietenpol AssociationN439WCurtiss Wright TRAVEL AIR 12-Q · S/N 2005Built 1931 · Alfred And Lois Kelch Aviation Museum IncN46480Aeronca 0-58B · S/N 058B-8793Alfred & Lois Kelch Aviation MuseumN475VAmerican Eaglecraft-Kelch EAGLET 230K · S/N SR3-210-1034Built 1979 · Alfred And Lois Kelch Aviation Museum IncN487VAmerican Eaglecraft EAGLET 231 · S/N 1044Built 1930 · Alfred And Lois Kelch Aviation Museum IncN4895Fred Davis-Storms FLYING FLIVVER · S/N 3Davis Trenten EN518EPDaniels TY AIRCAMPER · S/N 001Built 2002 · Daniels Ty LN5215HPiper PA-16 · S/N 16-17Built 1949 · Davis Ted EN5232HStrouse Joseph J CLIPPER 160 · S/N 16-36Weber William AN5835ECessna 150 · S/N 17335Built 1959 · Law Brian WN594CBBrubaker Calvin M BEARHAWK · S/N 015-23/24-594Built 2007 · Zigmont David EN618LCCrowell Sam R KITFOX 4 SPEEDSTER · S/N FBS-015Built 2004 · Zigmont David EN6294HPiper J3C-65 · S/N 19473Davis Ted EN6871Stinson SM-2 · S/N 1007Built 1928 · Davis Trenten EN7432PChampion 7GCB · S/N 25Weber William AN788VFleet 7 · S/N 369Alfred & Lois Kelch Aviation Museum IncN800HBUniversal Moulded Products MONOCOUPE 70 · S/N 31Alfred & Lois Kelch Aviation Museum IncN808BWChampion 7GCB · S/N 7GCB-147Built 1962 · Weber William AN8377VChampion 7ECA · S/N 280Built 1966 · Weber William AN838WHeath SUPER PARASOL · S/N ICR-1Alfred & Lois Kelch Aviation Museum IncN83WKKnight William S PIETENPOL · S/N 1983WKBuilt 1983 · Davis Trenten EN840WPietenpol AIR CAMPER · S/N C840Davis Trenten EN8811Stearman C3-B · S/N 221Built 1929 · Alfred And Lois Kelch Aviation Museum IncN88354Piper J3C-65 · S/N 15972Built 1946 · Alfred & Lois Aviation Museum IncN89105Cessna 140 · S/N 8109Registration pendingBuilt 1946N96818Taylorcraft BC12-D · S/N 9118Built 1946 · Bruns Scott A
Back to Brodhead, WI