OpenAirDocs.org
West Bend, WI

Cancelled registrations · 84

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 = 'WEST BEND'
  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.

N129GWCessna 172G · S/N 17254182Cancelled Oct 17, 2024 · Built 1966 · Ramair LLCN126PRDJI INSPIRE 1 · S/N W13DCC23021057Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Pre Pro MediaN72714Cessna 140 · S/N 9893Cancelled May 1, 2020 · Registration expired, pending cancellation · Built 1946 · Zellner Bruce MN8150RBeech B-60 · S/N P-300Cancelled Oct 10, 2018 · Exported to Canada · Built 1974 · Claybaugh Julie MN9058CAbco SPECIAL · S/N 116Cancelled Mar 16, 2018 · Revoked, canceled · Built 1955 · Aerial Blight Control IncN9059CAbco SPECIAL · S/N 117Cancelled Mar 16, 2018 · Revoked, canceled · Built 1955 · Aerial Blight Control IncN9061CAbco SPECIAL · S/N 119Cancelled Mar 16, 2018 · Revoked, canceled · Built 1955 · Aerial Blight Control IncN9062CAbco SPECIAL · S/N 120Cancelled Mar 16, 2018 · Revoked, canceled · Built 1955 · Aerial Blight Control IncN75012Boeing B75N1 · S/N 75-6743Cancelled Feb 4, 2017 · Revoked, canceled · Hahn LesterN3563BAerostar International RX-7 · S/N RX7-3183Cancelled Oct 25, 2013 · Registration expired, pending cancellation · Built 1988 · Bier Thomas LN154BBeech G35 · S/N D-4450Cancelled Aug 23, 2013 · Sale reported, canceled · Built 1956N40771Piper J3F-65 · S/N 7485Cancelled Aug 19, 2013 · Sale reported, canceledN63695Boeing A75N1(PT17) · S/N 75-3415Cancelled Aug 6, 2013 · Revoked, canceled · Built 1942 · Aerial Blight Control IncN2063TNorth American T-28B · S/N 53-138181Cancelled Jul 10, 2013 · Sale reported, canceledN70041Fairchild M-62C(PT-23A) · S/N 3282AECancelled Oct 15, 2012 · Sale reported, pending cancellation · Built 1943N1508MBalloon Works FIREFLY 7 · S/N 708Cancelled Jun 22, 2012 · Exported to Canada · Built 1976 · Tds Aviation LtdN3069ZPiper PA-22-160 · S/N 22-7025Cancelled Feb 21, 2012 · Sale reported, pending cancellation · Built 1959N60231Hightower Marc KITFOX CLASSIC IV · S/N C96010135Cancelled Sep 25, 2009 · Triennial form not returned · Built 2002 · Kopecky Leroy PN86CGGood Christopher John RV-6A · S/N 60135Cancelled Apr 23, 2009 · Triennial form not returned · Built 2000 · Good Christopher JN2899YCessna 182E · S/N 18253899Cancelled Mar 12, 2009 · Built 1962 · Buettner William M DBAN840DHHoffman David AVID SPEEDWING · S/N 840Cancelled Dec 20, 2007 · Triennial form not returned · Built 1995 · Kopecky Leroy PN1696HPiper PA-28-140 · S/N 28-7725156Cancelled Nov 15, 2007 · Triennial form not returned · Streese Roger LN301DFRetzlaff James DRAGONFLY · S/N 301Cancelled Jun 19, 2006 · Second triennial mailing, no response · Built 1989 · Retzlaff JamesN69265Cessna 152 · S/N 15282590Cancelled Jun 27, 2005 · Exported to United Kingdom · Built 1978 · Buettner William M DBAN50124Cessna 150H · S/N 15069076Cancelled Sep 28, 2000 · Triennial form not returned · Ewig Michael JN42JJohannes-Robert ACROSPORT RJ-2 · S/N 2Cancelled Oct 13, 1999 · Second triennial mailing, no response · Polsen MichaelN507UNorth American NA-265-60 · S/N 306-93Cancelled May 20, 1999 · Exported to Mexico · Russ Darrow Leasing Co IncN622LOxley Lonnie TIERRA II · S/N 622070Cancelled Aug 26, 1996 · Second triennial mailing, no response · Oxley Lonnie RN7089QCessna 172L · S/N 17260389Cancelled Mar 17, 1994 · Triennial form not returned · Hawkinson Alton DN6741FCessna 150F · S/N 15063341Cancelled Oct 6, 1993 · Triennial form not returned · Buettner William M DBAN3219YCessna 182E · S/N 18254219Cancelled Mar 17, 1993N12121Cessna 210N · S/N 21064360Cancelled Jan 18, 1991 · Exported to Brazil · Marth William JN8913GCessna 172N · S/N 17273622Cancelled Aug 7, 1982 · Administratively canceledN9057CAbco SPECIAL · S/N 115Cancelled Jul 19, 1977 · Aerial Blight Control IncN9060CAbco SPECIAL · S/N 118Cancelled Jul 19, 1977 · Aerial Blight Control IncN8533SCessna 182H · S/N 18256633Cancelled Oct 29, 1975 · Mueller James RN8071LCessna 172H · S/N 17256271Cancelled Feb 29, 1972 · West Bend Hangers IncN6886DDehavilland VAMPIRE MK-3 · S/N 17055Cancelled Feb 12, 1971 · Fliteways IncN6861DDehavilland VAMPIRE MK-3 · S/N 17030Cancelled Jun 23, 1969 · Fliteways IncN6862DDehavilland MARK 34A · S/N 17065Cancelled Jun 23, 1969 · Fliteways IncN6865DDehavilland VAMPIRE MK-3 · S/N 17002Cancelled Jun 23, 1969 · Fliteways IncN6866DDehavilland VAMPIRE MK-3 · S/N 17044Cancelled Jun 23, 1969 · Fliteways IncN6867DDehavilland VAMPIRE MK-3 · S/N 17078Cancelled Jun 23, 1969 · Fliteways IncN6868DDehavilland VAMPIRE MK-3 · S/N 17085Cancelled Jun 23, 1969 · Fliteways IncN6870DDehavilland VAMPIRE MK-3 · S/N 17016Cancelled Jun 23, 1969 · Fliteways IncN6872DDehavilland VAMPIRE MK-3 · S/N 17047Cancelled Jun 23, 1969 · Fliteways IncN6874DDehavilland VAMPIRE MK-3 · S/N 17019Cancelled Jun 23, 1969 · Fliteways IncN6879DDehavilland VAMPIRE MK-3 · S/N 17067Cancelled Jun 23, 1969 · Fliteways IncN6880DDehavilland VAMPIRE MK-3 · S/N 17007Cancelled Jun 23, 1969 · Fliteways IncN6882DDehavilland VAMPIRE MK-3 · S/N EEP 42304Cancelled Jun 23, 1969 · Fliteways Inc
Back to West Bend, WI