OpenAirDocs.org
Kenosha, WI

Registered aircraft · 78

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

N10QBoeing A75N1(PT17) · S/N 75-301Built 1940 · Hammerle Tye FN110MXCirrus Design SR22T · S/N 0096Built 2011 · Shoreline Flyer CorpN1716CCessna 180 · S/N 30416Built 1953 · Reidenbach John SN17440Dehavilland TIGER MOTH DH 82A · S/N T208Built 1951 · Harris David MN175DPiper PA-46-701TP · S/N 46020089Built 2025 · Skyways Aviation IncN188LRGrueter John T KITFOX S7 · S/N KA12317246Built 2021 · Grueter John TN196YXStearns Tim L WAIEX · S/N W0052Built 2009 · Stearns Tim LN199AABeech K35 · S/N D-5781Built 1958 · Heide Charles HN1WBEmbraer-Empresa Brasileira De EMB-500 · S/N 50000137Built 2010 · Weber Aviation Group LLCN21234Cessna 340A · S/N 340A1207Built 1982 · Positive Rate LLCN2152BLuscombe T-8F · S/N 6579Bolog Keith FN2180VCessna 140 · S/N 14409Built 1948 · Hammerle Tye FN221SPAerosport IKARUS C42 FB100 · S/N 0512-6776Built 2005 · Jacobsen James AN22319Aeronca 65-C · S/N C-3209Built 1939 · Riser Bruce LN235JWWeisbrod Joseph C LANCAIR 235 · S/N 059Built 2008 · Max Power Aircraft LLCN2368KLuscombe 8E · S/N 5095Bolog KeithN251JSRobinson Helicopter R44 II · S/N 11301Built 2006 · Safe Space Aviation LLCN2902RPiper PA-28-181 · S/N 28-7990539N2902r LLCN2990CCessna 180 · S/N 30890Built 1954 · Lyng Stephen GN31136Robinson Helicopter R44 II · S/N 14504Built 2021 · Midwestern Helicopter LLCN322EGSchleicher ASW-28 · S/N 28050Built 2002 · Spitz Robert WN32435Piper PA-28-140 · S/N 28-7525066Nickos Ryan LN3274ZPiper PA-22-150 · S/N 22-7226Built 1960 · Heide Jeffrey JN33459Piper PA-28-151 · S/N 28-7515340Built 1975 · A-Z Leasing LLCN347PGEmbraer EMB-500 · S/N 50000347Built 2014 · Land Air Sea Systems IncN34947Cessna 177RG · S/N 177RG1028Built 1976 · Nelson Kirk MN34GSTextron 172S · S/N 172S11662Built 2016 · Ghavi Enterprises IncN390MVVans RV-12 · S/N 120190Built 2009 · Max Power Aircraft LLCN39EJAndersen John TEAM ROCKET F-1 · S/N 39Built 2006 · Andersen JohnN405FACessna 172S · S/N 172S9405Built 2003 · Westosha Flying Club IncN431WGDehavilland DHC-1 SERIES 22 · S/N C1-0505Built 1951 · Harris David MN4398NCessna 195 · S/N 7007Built 1947 · Hammerle Tye FN4400UCessna 150D · S/N 15060400Built 1964 · Max Power Aircraft LLCN444WLMooney Dan W WHITE LIGHTNING · S/N 7Built 1994 · X-Perimental Aircraft LLCN4660TEaa Biplane BV-1 · S/N BV-1Andersen John NN479BWCirrus Design SR22T · S/N 10317Built 2024 · Kingsman Aviation LLCN4971KRyan NAVION A · S/N NAV-4-1971Built 1949 · Fandrei Scott AN5043ZBellanca 8KCAB · S/N 504-79Hsrdla LLCN50DFForton Donald E FORTON SKYBOLT · S/N 122550Built 1981 · Cargille Joshua CN52629Cessna 182P · S/N 18262726Built 1973 · Mbr Air LLCN532TTTalos Drones T60X · S/N 2104F7EZW255P0013L7WSkyhawk Ag LLCN5349HCessna T182T · S/N T18208198Built 2003 · Aviation Advisor IncN559MMCirrus Design SR22 · S/N 0349Built 2002 · Science Brew LLCN5613KHeldeberg Design MARATHON · S/N HD04123MBorths Jamie CN5830FCessna 210G · S/N 21058830Built 1966 · Suchy KarelN58712Boeing A75N1(PT17) · S/N 75-341Built 1941 · Hammerle Tye FN5895HPiper PA-16 · S/N 16-517Built 1949 · Thompson Timothy GN62853Cessna 150L · S/N 15075715Built 1974 · Willkomm John CN632SPCessna 172S · S/N 172S8627Built 2000 · Westosha Flying Club IncN6414WPiper PA-28-140 · S/N 28-20483Built 1964 · Ottos Aviation LLC
Back to Kenosha, WI