OpenAirDocs.org
Waukesha, WI

Registered aircraft · 98

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

N101JLCessna 550 · S/N 550-1002Built 2001 · Lake Country Jet LLCN119SMRobinson Helicopter R44 · S/N 0918Built 2000 · Prestige Worldwide Helicopters LLCN11BFAlexander Schleicher ASH 31 MI · S/N 31225Built 2024 · Esselstyn ChrisN135ECEurocopter Deutschland EC 135 T2+ · S/N 0862Built 2009 · Fight For Life IncN137MACessna 172R · S/N 17280146Built 1997 · Civil Aviation IncN1518UCessna 207 · S/N 20700118N1518u LLCN15FRCessna R172K · S/N R1723280Built 1979 · Scl Enterprises LLCN1674KLuscombe 8F · S/N 4401Built 1946 · La Roche Joseph FN170MTLindstrand Balloons 120A · S/N 5364Built 2007 · Winddancer Balloon Promotions LLCN184WKEurocopter Deutschland MBB-BK 117 C-2 · S/N 9171Built 2008 · Flight For Life IncN1871XCessna 182H · S/N 18255971Built 1964 · Eveland Scott BN196YChris D Esselstyn HP-18J · S/N 004Built 2015 · Esselstyn Chris DN200LECessna 310 · S/N 310R1842Built 1979 · Aeromarine Holdings LLCN200LFCessna 208 · S/N 20800149Built 1989 · Aeromarine Holdings LLCN20200Spartan 7W · S/N 11Bbjs Investments LLCN2041KSilvaire LUSCOMBE 8E · S/N 4768Built 1947 · Laroche Gerald DN2123XDehavilland DHC-2 · S/N 1473Built 1961 · Kias LLCN236VAVans RV-12 · S/N 12010Built 2013 · Adventure Aviation LLCN242VAVans RV-12 · S/N 12017Built 2013 · Adventure Aviation LLCN25FSCessna 550 · S/N 550-0823Built 1997 · Bbjs Investments LLCN284RKAeroprakt Mfg SP Z O O A32 · S/N 350Built 2025 · Adventure Aviation LLCN2900ACessna 180 · S/N 30100Built 1953 · Tct Aerial LLCN2965FCessna 182J · S/N 18257065Built 1966 · Frank Paul RN323AMAeroprakt Manufacturing SP Zoo A22LS · S/N 372Built 2020 · Adventure Aviation LLCN32DFCirrus Design SR22T · S/N 1590Built 2017 · Millford Aviation LLCN3615QBeech A23-19 · S/N MB-237Plane Safe Aircraft Maintenance IncN361KABeech 200 · S/N BB-741Built 1980 · Behrens Investments Of Wisconsin LLCN3673KPiper J3C-65 · S/N 22364Built 1946 · Spring City Aviation IncN3676KPiper J3C-65 · S/N 22367Built 1947 · Crites Elizabeth AN368ADEpic E1000 · S/N K132Asd Aviation LLCN3695LBeech 95-B55 (T42A) · S/N TC-2353First renewal noticeBuilt 1980 · Bg Aviation LLCN40051Lindstrand Balloons 90A · S/N 5056Built 1998 · Schartner Kay MN4029WPiper PA-32-300 · S/N 32-40047Built 1966 · Badger 29w LLCN40JTBeech 3 TM · S/N CA-128Built 1952 · Tct Aerial LLCN41058Piper J4E · S/N 4-1621Built 1941 · Waukecub IncN414MACessna 414A · S/N 414A0248Built 1979 · Dlk Aviation CorpN4157UPiper PA-18-150 · S/N 1809078Built 1993 · Aeromarine Holdings LLCN419YBBlum Ralph C ZODIAC CH601XL · S/N 4566Built 2011 · Blum Bradley RN420MACessna 425 · S/N 425-0116Built 1981 · Kias LLCN448GLLearjet 60 · S/N 206Built 2000 · 16 Angels LLCN4665RPiper PA-28-140 · S/N 28-21421Built 1966 · Gaulden Dennis NN46TRCirrus Design SR22T · S/N 0043Built 2010 · Wingnerds LLCN477JMBeech 200 · S/N BB-538Built 1979 · Behrens Aircraft Leasing LLCN5098KShade Darryl H CHALLENGER II · S/N 0957Built 2006 · Oliver Theodore MN5111KRyan NAVION A · S/N NAV-4-2011Built 1950 · Gordon CalebN5146VCessna 172RG · S/N 172RG0455Built 1980 · Fischer John WN518KWArbc Inc DBA Lindstrand 90A · S/N 5422Walter Kenneth S JrN528ACCessna 560XL · S/N 560-5695Legend Air LLCN529MDAirbus Helicopters MBB-BK 117 C-2 · S/N 9870Built 2021 · Flight For Life IncN53549Boeing E75N1 · S/N 75-8196Stearman LLC
Back to Waukesha, WI