OpenAirDocs.org
Franksville, WI

Registered aircraft · 39

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

N12457Waco UEC · S/N 3623Built 1932 · Niemyjski Justin SN127MLBeech D18S · S/N A-212Built 1946 · Niemyjski JustinN127VFNorth American AT-6C · S/N 88-12827Built 1943 · Woelbing Aviation LLCN129GHHall George D BUSHBY MUSTANG 1 · S/N M-1-1775Built 1994 · Woelbing Aviation LLCN13KDCessna 501 · S/N 501-0119Built 1979 · Woelbing Aviation LLCN15265Piper PA-28-235 · S/N 28-7310028Built 1972 · M & P Aviation LLCN15429Monocoupe 90A · S/N A730Built 1936 · Niemyjski Justin SN160Beech D17S · S/N 4836Built 1943 · Niemyjski Justin SN2701KLuscombe 8E · S/N 5428Built 1947 · Woelbing Aviation LLCN3285KGlobe GC-1B · S/N 1278Built 1946 · Woelbing Aviation LLCN333WDCessna 310L · S/N 310L-0002Built 1966 · Woelbing Aviation LLCN35013Cessna 177B · S/N 17702157Built 1974 · Vitek David CarlN350HTNorth American AT-6D · S/N 43756Built 1942 · Woelbing Aviation LLCN3611Keip Frederick J ULTRA PUP · S/N FK003Built 2022 · Keip Frederick JN383BCRobinson Helicopter R66 · S/N 1171Built 2022 · Pro Electric IncN3887EAeronca 7AC · S/N 7AC-7109Built 1947 · Schorsch Cary JN42VZRobert E Van Zant TVAP-4 · S/N 1080Built 2017 · Cox Thomas AN4434PHawker MK 11 SEA FURY · S/N WH 589Built 1951 · Woelbing Aviation LLCN444DYAgnew Michael T AEROCOMP/COMPAIR-6 · S/N 016269Built 2007 · Cox Thomas AN526AEDiamond Aircraft Ind DA 62 · S/N 62.042Built 2016 · Avolare LLCN5496NPiper J3C-85 · S/N 44-80782Built 1944 · Woelbing Aviation LLCN5780PPiper PA-24-250 · S/N 24-859Built 1959 · Wall ScottN6097KDowner REPUBLIC RC-3 · S/N 280Built 1947 · Guntly David AN6249WPiper PA-28-140 · S/N 28-20295Built 1964 · Wall Scott RN64434Boeing B75N1 · S/N 75-7979Built 1943 · Niemyjski Justin SN656NWaco CSO · S/N 3136Built 1930 · Niemyjski JustinN65984Cessna 150L · S/N 15075758Built 1974 · Woelbing Aviation LLCN7212HHiller UH-12B · S/N 212Built 1956 · Carriveau Vincent AN7447KPiper PA-20 · S/N 20-358Built 1950 · Niemyjski Justin SN7664CNorth American AT-6G · S/N 168-312Niemyjski JustinN79JKKorstian BUSHBY MM-1 · S/N 275Woelbing Aviation LLCN80771Rosenau Bret QUICKIE Q2 · S/N BR16500Built 1983 · Cox Thomas AN826DWAmerican Legend AL3 · S/N AL-1105Built 2007 · Woelbing Aviation LLCN878MHawker MK 11 SEA FURY · S/N 41-H/636294Built 1952 · Woelbing Aviation LLCN89EWWoelbing Eric CHALLENGER II · S/N CH212890497Built 1990 · Woelbing Aviation LLCN9005BChampion 7EC · S/N 7EC-630Built 1957 · Schorsch Cary JN9365ACessna 190 · S/N 7444Guntly David AN97734Stinson 108 · S/N 108-734Guntly David AN99611Keip Frederick J WAG-A-BOND · S/N FK002Built 2019 · Keip Frederick J
Back to Franksville, WI