OpenAirDocs.org
Belgrade, MT

Cancelled registrations · 51

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 = 'MT' AND d.registrant_city = 'BELGRADE'
  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.

N9417AAurora Flight Sciences SKIRON X · S/N 1001Cancelled Aug 10, 2024 · Registration pending, canceledN942EQAurora Flight Sciences SKIRON X · S/N 1002Cancelled Aug 10, 2024 · Registration pending, canceledN505TLBell Helicopter Textron Canada 505 · S/N 65035Cancelled Jul 31, 2024 · Exported to Ecuador · N505tl LLCN5501RMaule M-7-235C · S/N 25086CCancelled Apr 30, 2024 · Exported to Canada · Flying Dog LLCN840GGulfstream AM Corp Comm Div 690C · S/N 11683Cancelled Apr 11, 2023 · Exported to Canada · Built 1981 · Bridger Aviation Services LLCN151REL3 Latitude Engineering FVR-90 · S/N 017Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Bridger Aviation Services LLCN171REL3 Latitude Engineering FVR-90 · S/N 018Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Bridger Aviation Services LLCN49130Interstate S-1B1 · S/N 205Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Built 1943 · Soares Dorothy LN417FSNorth American F-100F · S/N 56-3842Cancelled Apr 3, 2021 · Registration expired, pending cancellation · Built 1957 · Big Sky Warbirds LLCN418FSNorth American F-100F · S/N 56-3996Cancelled Apr 3, 2021 · Registration expired, pending cancellation · Built 1956 · Big Sky Warbirds LLCN600WSRockwell International 690B · S/N 11435Cancelled Mar 5, 2020 · Bridger Aviation Services LLCN422DSDiamond Aircraft Ind DA 40 · S/N 40.1122Cancelled Dec 11, 2019 · Exported to New Zealand · Built 2011 · Summit Aviation IncN109TLCessna 172S · S/N 172S10056Cancelled Oct 29, 2019 · Exported to Canada · Combined Air Ventures LLCN25TLCessna 172S · S/N 172S10459Cancelled Oct 29, 2019 · Exported to Canada · Combined Air Ventures LLCN6328XAerostar International RAVEN S49A · S/N S49A-3020Cancelled Jan 16, 2019 · Built 1990 · Endeavor Aviation IncN5924Scheibe BERGFALKE II-55 · S/N 85Cancelled Mar 30, 2018 · Registration expired, pending cancellation · Built 1959 · Agricola PennatusN14719Bellanca 17-30A · S/N 75-30734Cancelled Mar 21, 2018 · Registration expired, pending cancellation · Built 1974 · Kormash MarkN42469Cessna 182L · S/N 18259029Cancelled Mar 16, 2018 · Sale reported, pending cancellation · Built 1968N90VNorth American NAVION · S/N NAV-4-1023Cancelled Nov 7, 2017 · Built 1947 · Olson Philip AN1776HBritish Aerospace BAE 125 SERIES 800A · S/N 258091Cancelled Nov 8, 2016 · Built 1987 · 320 LLCN6089GCessna 150K · S/N 15071589Cancelled Apr 27, 2015 · Exported to Costa Rica · Built 1969 · Lombard Dawn LN5583SSoares James E TURKEY RED · S/N 001Cancelled Dec 18, 2014 · Registration expired, pending cancellation · Built 1987 · Soares James EN28KGI.C.A.-Brasov IS-28B2 · S/N 156Cancelled Oct 7, 2014 · First renewal notice · Built 1979 · Agricola PennatusN2520MLancair LC41-550FG · S/N 41084Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 2005 · Oreo Air LLCN42FWDiamond Aircraft Ind DA42MNG · S/N 42.MN024Cancelled Aug 28, 2014 · Exported to Canada · Built 2013 · Combined Air Ventures LLCN42LRDiamond Aircraft Ind DA42MNG · S/N 42.MN027Cancelled Aug 28, 2014 · Exported to Canada · Built 2013 · Combined Air Ventures LLCN242SKMoravan Z242L · S/N 0663Cancelled Dec 4, 2013 · Exported to Canada · Built 1994 · Hoffmann Dennis E TrusteeN9428BCessna 175 · S/N 55228Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Built 1958 · Olson PhilipN421CSDiamond Aircraft Ind DA42MNG · S/N 42.MN023Cancelled Jul 23, 2013 · Exported to Canada · Built 2012 · Combined Air Ventures LLCN7044DPiper PA-22-150 · S/N 22-4941Cancelled Jul 23, 2013 · Registration expired, pending cancellation · Built 1957 · Baker L DN9705TPiper PA-38-112 · S/N 38-78A0161Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1978 · Aero Flight School LLCN6669QGrumman Acft ENG Cor-Schweizer G-164B · S/N 191BCancelled Mar 24, 2009 · Triennial form not returned · Built 1977 · Morgan Boyd JN9296TPiper PA-38-112 · S/N 38-78A0335Cancelled Mar 18, 2008 · Exported to Canada · Built 1978 · Aero Flight School LLCN166JDSchempp-Hirth VENTUS B/16.6 · S/N 209Cancelled Dec 19, 2006 · Exported to Germany · Built 1984 · Ard SteveN1159CCirrus Design SR22 · S/N 0490Cancelled Sep 20, 2005 · Built 2003 · Flightline Fractionals IncN4806UCessna 210-5A(205A) · S/N 205-0506Cancelled Jul 5, 2005 · Exported to Mexico · Built 1963 · Towhaul Corporation DBAN43481Piper PA-28-151 · S/N 28-7415505Cancelled Apr 28, 1999 · Triennial form not returned · Msu Flying Bobcats IncN9375TPiper PA-38-112 · S/N 3878A0078Cancelled Dec 12, 1990 · Sunbird Aviation IncN2834JCessna T188C · S/N T18803528TCancelled Mar 14, 1984 · Administratively canceled · Morgan Boyd JN5528BCessna 152 · S/N 15283895Cancelled Aug 26, 1982 · Nagorski Thomas JN2297ECessna 172N · S/N 17271226Cancelled Nov 19, 1980 · Exported to Canada · Built 1978 · Flight Line IncN84885Aeronca 7AC · S/N 7AC-3604Cancelled Nov 25, 1975 · Built 1946 · Flight Line IncN8401MCessna A150K · S/N A15000101Cancelled Jun 24, 1975 · Exported to Canada · Built 1969 · Flight Line IncN82542Aeronca 7AC · S/N 7AC-1179Cancelled Jun 30, 1970 · Flight Line IncorporatedN83103Aeronca 7AC · S/N 7AC-1760Cancelled Sep 21, 1960 · Flight Line IncorporatedN51476Cessna T-50 · S/N 5858Cancelled Dec 12, 1955 · Lynch Flying Service IncN9685ACessna 140A · S/N 15406Cancelled Nov 27, 1953 · Stuart Norma JeanN9994ACessna 170A · S/N 19429Cancelled Dec 14, 1950 · Lynch Flying Service IncN1130NCessna T-50 · S/N 2678Cancelled Aug 17, 1949 · Built 1943 · Lynch Flying ServiceN49450Taylorcraft L-2M · S/N L-5722Cancelled Feb 19, 1947 · Lynch Flying Service
Back to Belgrade, MT