OpenAirDocs.org
Sun Prairie, WI

Registered aircraft · 30

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 = 'SUN PRAIRIE'
  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.

N1062QAdams Balloon A55 · S/N 104Belgarde Sonja KN109Schempp-Hirth VENTUS-B · S/N 66Built 1981 · Mikelsen Carlos AN1321LCameron Balloons US O-84 · S/N 6409Built 2005 · Belgarde Sonja KN180LYStinson 108-3 · S/N 108-4486Built 1949 · Fischer Bruce MN197QBeech S35 · S/N D-7930Built 1965 · Urban Andrew WN2853ZPiper PA-28-236 · S/N 28-7911206Built 1979 · Ldp Aviation LLCN312JMMiller James D VANS RV-8 · S/N 81175Built 2004 · Miller James DN3323FCessna 182J · S/N 18257323Built 1966 · Fly The Dream LLCN3411BCirrus Design SR22T · S/N 10736Built 2025 · Redstone Ventures LLCN420BKKropelin Barry R RBIPE · S/N BK04Built 2011 · West Benjamin MN43208Piper PA-28-151 · S/N 28-7415445Built 1974 · Thornburgh Paul J TrusteeN4645RPiper PA-28-140 · S/N 28-21399Built 1966 · Kunz Consulting IncN486ERCessna 172R · S/N 17280672Built 1998 · Uw Flying Club IncN5047UBellanca 7ECA · S/N 1303-79Built 1979 · Rio Aero ClubN5197TCessna 172S · S/N 172S9131Built 2002 · Uw Flying Club IncN555VPCessna 182M · S/N 18259728Built 1969 · Clear Skies Flying Services LLCN6032SBeech B-60 · S/N P-332Built 1975 · Renk Brett JN60AUBeech E-55 · S/N TE-915Life'S A Beech LLCN64271Stinson VULTEE V-77 · S/N 77154Built 1943 · Fischer Bruce MN6448GCessna 150K · S/N 15071948Built 1970 · Bradley Gilbert KN65678Condor RAPTOR · S/N 001Built 2004 · Whitley Wesley BN71283Luscombe 8A · S/N 2710Built 1946 · Week James AN71575Luscombe 8A · S/N 3002Built 1946 · Pyle William VN7162PDieringer Nathan W BARD77 · S/N 031848Built 2023 · Belgarde SonjaN717RKCessna T240 · S/N T24002007Built 2013 · Koenig Raymond TN7216HHofweber Terrence A KIT FOX IV · S/N 1644Built 1997 · Vetter John RN7596MBRM Aero S R O BRISTELL LSA · S/N 558/2021Built 2021 · Mckenzie Donald LN78RCCirrus Design SR20 · S/N 1259Built 2002 · Aviaries LLCN8097XCessna 172B · S/N 17248597Built 1961 · Kublank Nathan SN9846BBellanca 14-19-2 · S/N 4098Built 1958 · Fischer Bruce M
Back to Sun Prairie, WI