OpenAirDocs.org
Rochester, MN

Cancelled registrations · 58

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 = 'MN' AND d.registrant_city = 'ROCHESTER'
  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.

N3808JJerald Scrabeck KOLB TWINSTAR · S/N 001Cancelled Jul 18, 2023 · Sale reported, canceled · Built 1989N838TCThunder & Colt Airborne Amer AX8-90 S 2 · S/N 3671USACancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 1995 · Nienow Michael KN6245VBeech V35 · S/N D-8581Cancelled Apr 3, 2021 · Registration expired, pending cancellation · Built 1967 · Van Herle Luc EN55336Jackson Robert W JR MARATHON · S/N HD 02086MCancelled Nov 14, 2020 · First renewal notice · Built 2003 · Eickman KyleN73344Fairchild M-62A · S/N FX184Cancelled Mar 25, 2020 · Revoked, canceled · Whynaucht HerbertN829DTTrimberger Donald J RIDGE RUNNER III · S/N 042005112Cancelled Oct 17, 2018 · Built 2007 · Wutschke Barrie DN1134BLuscombe 8A · S/N 5761Cancelled May 30, 2018 · Sale reported, canceled · Built 1947N75534Quicksilver Mfg GT500 · S/N 0021Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1991 · Ellef IncN139WKQuicksilver GT 500 · S/N GT 500 0136Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1995 · Ellef IncN2019QCessna 177RG · S/N 177RG0419Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1973 · Johnson CarltonN2604CCessna 310 · S/N 35004Cancelled Nov 22, 2017 · Revoked, canceled · Built 1954 · Armit E J Constr And Realty CoN57284Raven S55A · S/N S55A-793Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1981 · Ibach Michael George DBAN40816Raven S55A · S/N S55A-998Cancelled Dec 3, 2014 · Registration expired, pending cancellation · Built 1983 · Northwest Executives IncN9853QCessna 172M · S/N 17265797Cancelled Mar 12, 2014 · Second renewal notice · Built 1975 · Southeastern Minnesota Flying Club IncN186DBBehrens Eldean E KOLB TWINSTAR · S/N 1-3605546Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1986 · Vacura Rodman RN62JEEvans James H WITTMAN TAILWIND W10 · S/N 448Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Jerviss Stanley LN61032Lasecri Robert R CRI-CRI · S/N 12-0277Cancelled Jun 14, 2013 · Sale reported, canceledN4368EAeronca 11CC · S/N 11CC-194Cancelled Nov 9, 2012 · Sale reported, canceled · Built 1948N3564JCessna 150E · S/N 15061264Cancelled Oct 4, 2012 · Registration expired, pending cancellation · Built 1965 · Poulson Gary LN76723Cessna 140 · S/N 11155Cancelled Sep 19, 2011 · Exported to Canada · Built 1946 · Schermerhorn Everett LeonardN1039RRaven Industries RX6 · S/N RX6-199Cancelled Jun 7, 2011 · Sale reported, canceled · Built 1976N8118LRobinson Helicopter R22 BETA · S/N 2409Cancelled Jan 25, 2008 · Triennial form not returned · Built 1994 · Blue Skies IncN1930WBeech B19 · S/N MB-595Cancelled Mar 6, 2002 · Triennial form not returned · Built 1973 · Birdseye Aviation IncN3075EHouey Eugene A RANS S-12 · S/N 0591076Cancelled Jul 6, 2000 · Sale reportedN110VJSash Victor G TEENIE-TWO · S/N 15-2266Cancelled Sep 8, 1999 · Triennial form not returned · Sash Victor GN303CBeech 35-B33 · S/N CD647Cancelled Aug 6, 1998 · Triennial form not returned · Jennings Dwight LN86WHHaas William J TERATORN TIERRA II · S/N 32930Cancelled Apr 8, 1997 · Haas William JN11KKKusch Kim G SONERAI II L · S/N 00592Cancelled Oct 1, 1996 · Exported to Italy · Sash Victor GN434MGPiper PA-31-310 · S/N 31130Cancelled Jan 30, 1996 · Exported to Panama · Lavell Michael JN1716MCessna 337E · S/N 33701316Cancelled Dec 7, 1994 · Exported to Panama · Lavell Michael JN6961HCessna 172M · S/N 17265665Cancelled Feb 25, 1993 · Exported to Panama · Lavell Beatriz IN4025LCessna 421A · S/N 421A0125Cancelled Aug 21, 1991 · Triennial form not returned · Hiawatha Aviation Of Rochester IncN9606LGrumman American Avn. AA-1B · S/N AA1B0106Cancelled Dec 27, 1990 · Exported to Denmark · Halloran Walter TN24669Beech B19 · S/N MB-566Cancelled Apr 19, 1989 · Built 1973 · Neuman Air Charter IncN80480Beech D18S · S/N A-312Cancelled Jan 6, 1983 · Sizer Airways IncN94460Beech UC-45J · S/N 23783Cancelled Oct 15, 1981 · Sizer Airways IncN80378Beech D18S · S/N A-278Cancelled Sep 8, 1981 · Luthi Aviation IncN3641QBeech A23-19 · S/N MB-254Cancelled Feb 18, 1975 · Exported to Canada · Gopher Aviation Supply IncN4213JPiper PA-28-140 · S/N 28-22560Cancelled Jun 23, 1972 · Exported to Canada · Ryles CanbyN98243Piper J3C-65 · S/N 18411Cancelled Nov 19, 1970 · Registration revoked · Built 1946 · Whynaught EverettN3707NBeech 35 · S/N D-913Cancelled Oct 7, 1970 · Arnold E TeskeN9889YChampion 7GCB · S/N 7GCB-87Cancelled Jun 13, 1969 · Exported to Canada · Loge Gary LN39527Aeronca 65-TAC · S/N C-4962TACancelled Jul 11, 1968 · Hanft ArthurN2321JBeech 23 · S/N M-271Cancelled Dec 19, 1967 · Exported to Canada · Gopher Aviation IncN8308UCessna 172F · S/N 17252208Cancelled Dec 19, 1967 · Exported to Canada · Gopher Aviation IncN649QBeech H35 · S/N D-5326Cancelled Dec 5, 1967 · Exported to Canada · Built 1957 · Gopher Aviation IncN4366DBeech E50 · S/N EH9Cancelled Aug 16, 1966 · Exported to Canada · Built 1957 · Gopher Aviation IncN8652EBensen B-8MC · S/N GW-373Cancelled Oct 13, 1965 · Westphal Gordon WilburN2905BBeech D35 · S/N D3550Cancelled May 22, 1965 · Gopher Aviation IncN2210KLuscombe 8A · S/N 4937Cancelled May 19, 1965 · David Hancq
Back to Rochester, MN