OpenAirDocs.org
Brainerd, MN

Cancelled registrations · 46

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

N206TCCessna U206G · S/N U20606893Cancelled May 26, 2026 · Exported to Canada · Built 1985 · Dv Aviation IncN790ECDJI PHANTOM 3 PROFESSION · S/N P77DCF27011049Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Central Lakes CollegeN20874Piper J-3 · S/N 2180Cancelled Nov 30, 2022 · Registration expired, pending cancellation · Built 1938 · Walton Richard DN80228Piper J3C-65 · S/N 17272Cancelled Nov 17, 2021 · Registration expired, pending cancellation · Cumming John JN177JPCessna 208 · S/N 20800146Cancelled Jun 8, 2020 · Exported to Canada · Built 1989 · Dv Aviation IncN792LPBeech 3N · S/N CA-24Cancelled May 14, 2020 · Exported to Canada · Built 1951 · Dv Aviation IncN919PCessna 182F · S/N 18254836Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Huff ErikN778YLDJI PHANTOM 2 · S/N PH645413257 V2.0Cancelled Dec 2, 2019 · Registration expired, pending cancellation · Central Lakes CollegeN7781LParrot BEBOP · S/N PS722000AB4L014444Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Central Lakes CollegeN76CBBeech 95-B55 (T42A) · S/N TC-2118Cancelled Nov 25, 2019 · Exported to South Korea · Built 1978 · Soaring Soul LLCN7635PDJI PHANTOM 3 PROFESSION · S/N P76DCG20016743Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Pfingsten Aviation LLCN26186Hiller-Nunes UH-12C · S/N AN-002Cancelled Jan 14, 2019 · Registration expired, pending cancellation · Built 1957 · Jackson Zachariah JN1KLQuest KODIAK 100 · S/N 100-0010Cancelled Jun 19, 2018 · Exported to Canada · Dv Aviation IncN2055WBeech V35 · S/N D-7992Cancelled Mar 12, 2018 · Registration expired, pending cancellation · Built 1965 · Brainerd Helicopter Service IncN79BHBell 206B · S/N 2788Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 1979 · Andrew Leland TN135NRBell OH-58C · S/N 68-16902Cancelled Oct 26, 2017 · First renewal notice · Minnesota Department Of Natural ResourcesN60JRCessna 172N · S/N 17272838Cancelled Feb 17, 2017 · Exported to Canada · Built 1979 · Dv Aviation IncN87KQQuest KODIAK 100 · S/N 100-0087Cancelled Jun 10, 2014 · Exported to Canada · Built 2013 · Dv Aviation IncN16WSSteichen DSA-1 · S/N 1Cancelled Aug 15, 2013 · Sale reported, canceled · Built 1970N8053ZKroll-Pietrick GYRACAR BG5 · S/N 1Cancelled May 13, 2013 · Registration expired, pending cancellation · Dennis Andrew KrollN429CMCessna 340A · S/N 340A1514Cancelled Apr 16, 2013 · Exported to Canada · Breaking Wind Aviation LLCN79299Boeing A75N1(PT17) · S/N 75-4313Cancelled Jan 31, 2013 · Sale reported, pending cancellationN829WJJohnson Willie VARIEZE · S/N 1326Cancelled Nov 9, 2012 · Sale reported, canceled · Built 1981N55237Callaway SCORPION HELICOPTER · S/N CGI001Cancelled Aug 23, 2012 · Revoked, canceled · Built 1971 · Deuel Lyle EN94225Cessna A185F · S/N 18503292Cancelled May 26, 2011 · Exported to Canada · Built 1977 · Northway Edward E IIN1468JAdair John W-8-W · S/N JA001Cancelled Oct 15, 2007 · Triennial form not returned · Built 2001 · Adair John FN505NRCessna 182R · S/N 18268085Cancelled Jun 27, 2007 · Triennial form not returned · Built 1981 · State Of MinnesotaN5099WPiper PA-28 · S/N 28-111Cancelled Jun 5, 2001 · Triennial form not returned · Brainerd Helicopter Service IncN2060VPerlick Larry J MURPHY REBEL · S/N 241RCancelled Apr 4, 2000 · Triennial form not returned · Perlick Lawrence JN6227QBell OH-58A · S/N 69-16221Cancelled Jul 12, 1999 · Triennial form not returned · Minnesota Dept Natural ResourcesN757EYCessna 152 · S/N 15279692Cancelled Jun 11, 1997 · Exported to Argentina · Airmotive Enterprises IncN50963Cessna U206F · S/N U20601963Cancelled Oct 7, 1993 · Barrett Ag Service IncN29315Hughes 369HS · S/N 1000265SCancelled Feb 10, 1993 · Exported to France · Brainerd Helicopter Service IncN2517APiper PA-18-135 · S/N 182142Cancelled Aug 21, 1991 · Exported to Canada · Haff Donald WN5404YPiper PA-18-150 · S/N 18-8152Cancelled Sep 8, 1980 · Exported to Canada · Liemandt P JeromeN69TTCessna 170A · S/N 19124Cancelled Nov 28, 1975 · Thomas F RodwellN4610XCessna 150G · S/N 15064660Cancelled May 19, 1972 · Exported to Canada · Built 1966 · Crow Wing Flying ClubN4560EAeronca 7CCM · S/N 7CCM-128Cancelled Dec 7, 1971 · Leonard Albert LN5807SBeech D95A · S/N TD-603Cancelled Mar 12, 1971 · Brainerd Aero Club IncN20885Piper J-3 · S/N 2183Cancelled May 22, 1965 · Teigen ArchieN1829EAeronca 7AC · S/N 7AC-5396Cancelled May 18, 1965 · Built 1946 · Hanft OscarN47401Fairchild M-62A · S/N T41-1229Cancelled Oct 10, 1955 · Wolleat James LN4703NConsolidated Vultee SNV-1 · S/N 8416Cancelled Oct 6, 1955 · Archie TeigenN6199KRepublic RC-3 · S/N 390Cancelled Oct 1, 1951 · Garrett Bert RN37315Interstate S-1A · S/N 158Cancelled May 8, 1951 · William K ToddN3052NCessna 140 · S/N 13310Cancelled Mar 9, 1950 · Garrett B R
Back to Brainerd, MN