OpenAirDocs.org
Superior, WI

Registered aircraft · 37

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

N109RVBaird P/Knox B/Noble D II RV-9 · S/N 90355Built 2002 · Luck Richard SN1557WBeech 58 · S/N TH-229Built 1972 · 557 Whiskey LLCN1841QCessna 177RG · S/N 177RG0241Built 1972 · Evolution Electronics LLCN2023FOstien Douglas B QUICKSILVER SPORT 2S · S/N 0026Built 2002 · Hughes Allen LN2674MPiper PA-12 · S/N 12-1107Built 1946 · Starr LLCN29684Taylorcraft BL-65 · S/N 2528Hawkins Brennan JN313TFCirrus Design SR22 · S/N 1237Built 2004 · 313tf Aviation LLCN325TTPiper PA-34-220T · S/N 348333006Built 1983 · Superior Flying Service LLCN327ADTextron T182T · S/N T18209164Built 2024 · Gundry AdamN3671JCessna 150G · S/N 15064971Androsky Charles S JrN393DWCessna TU206G · S/N U20605261Built 1979 · 3 Delta Whiskey LLCN449AFWhitlow Garyon Jack AVID FLYER · S/N 449Hughes Allen LN49993Cessna 152 · S/N 15281431Built 1978 · Starr LLCN50482Clark RAND KR-2 · S/N 1Built 1984 · Barrett Thomas MN51103Cessna 150J · S/N 15069767Built 1968 · Malachi Israel PN5490HCessna 172M · S/N 17265462Superior Flying Services LLCN616SKCessna 172N · S/N 17273381Built 1979 · Superior Flying Services LLCN6370FCessna 337A · S/N 337-0370Built 1966 · Barrett Thomas MN66075Cessna 150M · S/N 15075816Built 1974 · Malachi IsraelN670JHCessna U206G · S/N U20604489Built 1978 · Natural Resources Engineering Co PaN71AWWhite DYKE DELTA JD-2 · S/N 1123Built 2010 · White Alan RN737DVCessna 172N · S/N 17269346Built 1977 · Superior Flying Services LLCN738JXCessna 172N · S/N 17270024Built 1977 · Superior Flying Services LLCN738NCCessna 172N · S/N 17270099Built 1977 · Androsky Mark JN743CGCirrus Design SR22T · S/N 9751Built 2023 · Air Force Two LLCN758PVCessna R172K · S/N R1723260Luck Richard SN76942Cessna 140 · S/N 11384Hawkins Brennan JN784BGCessna 172R · S/N 17281222Built 2004 · Superior Flying Services LLCN7946WPiper PA-28-180 · S/N 28-1990Built 1964 · Cushman Jeffrey RN8033PStump John L SCORPION 133 · S/N SH-001Built 1982 · Stein Bernard EN8165BCessna 172 · S/N 29965Built 1957 · Evans David MN816JNelson James M GLASAIR SPORTSMAN GS · S/N 7146Built 2019 · Nelson James MN85464Aeronca 7AC · S/N 7AC-4204Built 1946 · Spirit Of Superior LLCN9016GCessna 182N · S/N 18260556Built 1971 · Skydive Duluth Superior LLCN929DRCirrus Design SR22 · S/N 4441Air Force Two LLCN968HLPiper PA-46-600TP · S/N 4698091Built 2018 · Redfin Leasing IncN99BSPiper PA-32R-300 · S/N 32R-7780432Built 1977 · Evans David M
Back to Superior, WI