OpenAirDocs.org
East Troy, 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 = 'EAST TROY'
  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.

N107CKKeyes Charles R HELISQUITO · S/N 5-21Built 2021 · Keyes Charles RN12352Curtiss Wright TRAVEL AIR 16-E · S/N 3508Built 1932 · Dawson Steven LN1316Stits Playboy SA3A · S/N P-665Built 1967 · Mildebrandt Donald EN13ETCirrus Design SR22T · S/N 1633Built 2017 · Rp Aviation LLCN160VDonald R Voland 2 · S/N 2Voland Donald RN167RAAmerican Champion 7EC · S/N 1020-2007Built 2008 · Wojnar Ronald TN1863JPiper PA-28-140 · S/N 28-24302Built 1968 · Gross Peter JN2151VCessna 140 · S/N 14380Built 1948 · Merschdorf AlbertN222PACessna 150M · S/N 15078669Built 1976 · Frank Eric AN2348UCessna 172D · S/N 17249948Built 1962 · Wojnar Ronald TN285RGRobinson Helicopter R44 II · S/N 11323Built 2006 · Mf Helicopters LLCN29286Cessna 172M · S/N 17264114Built 1974 · Wawro ChristopherN3177YCessna 182E · S/N 18254177First renewal noticeBuilt 1962 · Skyknights Sport Parachute Club IncN33HLCessna 340 · S/N 340-0315Built 1973 · Knudsen Russell GN3419FCessna 182J · S/N 18257419Built 1966 · Schreib John DN365CBBucci Charles EXEC 162F · S/N 7028Built 2011 · Bucci CharlesN37385Interstate S-1A · S/N 228First renewal noticeBuilt 1941 · Dawson Steven LN39436Merschdorf Albert BOWERS FLYBABY 1A · S/N 68-39Merschdorf AlbertN42220Piper J3C-65 · S/N 14470Built 1945 · Taber Sam JN444VHRobinson Helicopter R44 · S/N 0571Built 1999 · Mf Helicopters LLCN46DNNicoson David H SIX CHUTER SKYRIDER · S/N 2419Built 2000 · Nicoson David HN4802HPiper PA-17 · S/N 17-100Built 1948 · Dawson Steven LN52048Cessna 172P · S/N 17274399Built 1980 · Time Flyers LLCN5289QCessna 150L · S/N 15073189Built 1972 · Nielson Douglas WN5610ACessna 172 · S/N 28210Built 1956 · Nielson Douglas WN570WHRobinson Helicopter R44 · S/N 0538Built 1998 · Mf Helicopters LLCN5739NPiper J3C-65 · S/N 13066Built 1944 · Sam TaberN5746CCessna 170A · S/N 19700Built 1950 · Hince AmbroseN5782HPiper PA-16 · S/N 16-397Built 1949 · Tomas Douglas JN5891HPiper PA-16 · S/N 16-512Built 1949 · Felske Michael JN601FJason Feyen ZENITH ZODIAC 601XLB · S/N 6-5985Feyen JasonN60487Cessna 150J · S/N 15070347Built 1969 · Mac Mor LtdN608RBBeech V35A · S/N D-8818Built 1968 · Knudsen Russell GN61544Cessna 172M · S/N 17264628Built 1974 · Knudsen Russell GN615RSBoeing A75N1 · S/N 75-3321Built 1942 · Wojnar Ronald TN6249QCessna 401A · S/N 401A0049Built 1969 · Knudsen Russell GN6422XCessna 180D · S/N 18050922Built 1960 · Hawley Lorna MN64669Stinson L-5 · S/N 76560Taber Sam JN6695JPiper PA-28-140 · S/N 28-24388Morgan JonathanN6706RCessna T210F · S/N T210-0106Built 1965 · Szopa Ireneusz WN67110Bell 206B · S/N 5109Built 1993 · Mf Helicopters LLCN67130Bell 206B · S/N 5113Built 1993 · Mf Helicopters LLCN67301Bell 206B · S/N 5135Built 1994 · Mf Helicopters LLCN67978Bell 206B · S/N 5237Built 1995 · Mf Helicopters LLCN7085QCessna 182P · S/N 18262025Built 1973 · Just Plane Fun Et LLCN72DDMildebrandt Donald E TAILWIND W-8 · S/N 375Built 2006 · Mildebrandt Donald EN8129TFlaglor Kenneth PIEL EMRAUDE · S/N 1293Built 1989 · Mildebrandt Donald EN8282DBeech J35 · S/N D-5400Henry Craig AN85GHCessna A185F · S/N 18502655Built 1975 · 185f LLCN89SLPiper PA-23 · S/N 23-602Built 1956 · Mclain Scott S
Back to East Troy, WI