OpenAirDocs.org
Superior, WI

Cancelled registrations · 37

Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
  WHERE d.registrant_state = 'WI' AND d.registrant_city = 'SUPERIOR'
  ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"

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.

N153RCRobert L Christian JR AVID MARK 4 · S/N 001Cancelled Feb 8, 2018 · Registration expired, pending cancellation · Built 2013 · Christian Robert L JrN70520Cessna 182L · S/N 18259286Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1968 · Androsky Chuck DBAN56120Mainair BLADE · S/N 123701007W1030Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Built 2007 · Buhr David AN1328GCessna 310R · S/N 310R0012Cancelled Jun 14, 2017 · Registration expired, pending cancellation · Built 1974 · Johnson Flying Service IncN691HEDJI PHANTOM 3 PROFESSION · S/N P76DCI05010603Cancelled Nov 29, 2016 · Insight Environmental IncN691REPrecisionhawk LANCASTER MK III · S/N PCN-048-201548-029-MSICancelled Nov 4, 2016 · Insight Enviromental IncN5862ECessna 150 · S/N 17362Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1959 · Weiland Timothy DeanN70049Cessna A185E · S/N 18501922Cancelled Dec 2, 2014 · Revoked, canceled · Built 1971 · Androsky Charles DBAN4646TVolmer Sportman VJ22 · S/N 319Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Built 1964 · Finn Douglas HN5367BCessna 152 · S/N 15283850Cancelled Sep 9, 2014 · Built 1979 · Superior Flying Services LLCN95684Taylorcraft BC12-D · S/N 7984Cancelled Nov 12, 2013 · Registration expired, pending cancellation · Built 1946 · Anderson Thomas MN87VELangley James H LANGLEY VARI-EZE · S/N 001Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Undis MikeN93787Engineering & Research ERCOUPE 415-C · S/N 1110Cancelled Mar 19, 2013 · Sale reported, canceled · Built 1946N4476TPiper PA-28-140 · S/N 28-7225151Cancelled Jul 9, 2012 · Revoked, canceled · Built 1972 · Northern Flying Club IncN4611BCessna 152 · S/N 15283551Cancelled Mar 8, 2012 · Second renewal notice · Built 1979 · Twin Ports Flying Service IncN60745Kapella Pat KC · S/N 002Cancelled Sep 19, 2006 · Triennial form undeliverable · Kapella Pat DN7700RBeech D55 · S/N TE-633Cancelled Jan 24, 2006 · Si Air Charters IncN5315DCessna 172N · S/N 17272512Cancelled Jun 7, 2005 · Triennial form not returned · Built 1979 · Twin Ports Flying Service Inc.N6293FCessna 172N · S/N 17273184Cancelled Aug 8, 2000 · Triennial form not returned · Twin Ports Flying Service IncN68268Cessna 152 · S/N 15282220Cancelled Feb 11, 2000 · Triennial form not returned · Twin Ports Flying Service IncN924TAAmerican Champion 8KCAB · S/N 73694Cancelled Dec 17, 1998 · Great Lakes Flying IncN301LSMortensen Dan LOMBARD-DILLEY-68 · S/N 1Cancelled Aug 1, 1994 · Triennial form not returned · Ams/Air CorpN24813Cessna 152 · S/N 15280393Cancelled Mar 1, 1982 · Built 1977 · Twin Ports Flying Service IncN758KYCessna R172K · S/N R1723168Cancelled Apr 29, 1981 · Exported to Canada · Bissell Robert CN9745ACessna 170A · S/N 19206Cancelled Oct 2, 1974 · Morgan Lawrence AN4096VCessna 170 · S/N 18428Cancelled Jul 29, 1971 · Exported to Canada · Wesolowski W RN96564Taylorcraft BC12-D · S/N 8864Cancelled Jul 17, 1969 · Exported to Canada · Built 1946 · Snell William JN96531Taylorcraft BC12-D · S/N 8831Cancelled Feb 12, 1969 · Built 1946 · Jacobson Kenneth D & Hicks Jerome EN1922EAeronca 7AC · S/N 7AC-5488Cancelled Jul 28, 1961 · Exported to Canada · Built 1946 · Carlson EarlN48163Taylorcraft DCO-65 · S/N 5934Cancelled Oct 25, 1955 · Built 1944 · Bartlett Leroy BN48214Taylorcraft L-2B · S/N L-4801Cancelled Oct 24, 1955 · Built 1944 · Clock Devere GN756CStinson 108-3 · S/N 108-3756Cancelled Jul 15, 1955 · Cronstrom HaroldN91779North American NAVION · S/N NAV-4-460Cancelled Nov 9, 1951 · Jensen Motors IncN1401EAeronca 7AC · S/N 7AC-4963Cancelled Aug 26, 1947 · Built 1946 · Willits Charles AN12088Vance SUPERIOR GLIDER · S/N TB-1Cancelled Aug 8, 1934 · Wheat ClubN1177Standard J-1 · S/N UNKNOWN1Cancelled Feb 28, 1930 · Hughes W JN1571Travel Air Mfg 2000 · S/N 224Cancelled Sep 4, 1928 · Built 1927 · Hoffman L A
Back to Superior, WI