OpenAirDocs.org
Butte, MT

Cancelled registrations · 67

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

N87395Cessna 310R · S/N 310R0543Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 1975 · Angle Of Attack Aeronautics LLCN6802WSensefly EBEE RTK · S/N ER-01-26521Cancelled Sep 4, 2019 · Registration expired, pending cancellation · Water And Environmental TechnologiesN235LPeris Jim JN-1 · S/N 101Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Smith TrudaN4GYCessna 210B · S/N 21057977Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Built 1962 · Blue Range Engineering Co IncN67966Cessna 152 · S/N 15282119Cancelled Jul 25, 2013 · Exported to Kenya · Built 1978 · Butte Aviation IncN8431DPiper PA-22-160 · S/N 22-5686Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1957 · Brewer Larry GN2396ECessna 172N · S/N 17271265Cancelled Oct 16, 2012 · Registration expired, pending cancellation · Built 1978 · Toppen David LN2381APiper PA22-20-135 · S/N 22-745Cancelled Sep 26, 2012 · Exported to Canada · Built 1952 · Fligel Charles FN21694Piper J3C-65 · S/N 2592Cancelled Aug 24, 2012 · Registration expired, pending cancellation · Built 1938 · Bragg Larry RN2069HEngineering & Research ERCOUPE 415-C · S/N 2692Cancelled Aug 23, 2012 · Registration expired, pending cancellation · Built 1946 · Smith Walter JN101MQCessna 411 · S/N 411-0032Cancelled May 11, 2012 · Registration expired, pending cancellation · Built 1965 · C&M Aviation IncN2584NPiper PA-38-112 · S/N 38-79A0931Cancelled Apr 16, 2012 · First renewal notice · Built 1979 · Jj Aviation LLCN4914ACessna T310R · S/N 310R1400Cancelled Oct 4, 2011 · Built 1978 · Daedalus Holdings LLCN3481LCessna U206B · S/N U206-0781Cancelled Oct 4, 2007 · Exported to Mexico · Built 1967N913SMCessna 185 · S/N 185-0091Cancelled Jul 6, 2006 · Triennial form not returned · Built 1961 · Osprey Air LLCN48733Cessna 152 · S/N 15280942Cancelled Feb 13, 2004 · Triennial form not returned · Built 1977 · Butte Aviation IncN78895Mooney M20C · S/N 2910Cancelled Sep 26, 2003 · Exported to Canada · Built 1964 · Mcgee Donald C DBAN4244LCessna 172G · S/N 17254313Cancelled Apr 21, 1993 · Triennial form not returned · HughesN3246HEngineering & Research ERCOUPE 415-C · S/N 3871Cancelled Mar 19, 1991 · Triennial form not returned · Smith Walter JN49816Cessna 152 · S/N 15281336Cancelled Jan 17, 1983 · Built 1978 · Marathon Aviation CorpN36941Cessna 441 · S/N 4410018Cancelled Sep 30, 1982 · Built 1977 · Montana Power CoN759ZZCessna 182Q · S/N 18266401Cancelled Aug 17, 1982 · Northwestern Resources CoN1554VCessna 172M · S/N 17263657Cancelled Feb 26, 1976 · Exported to Canada · Built 1974 · Northwestern Resources CoN40MPRockwell International 690A · S/N 11116Cancelled May 9, 1975 · Built 1973 · Montana Power CoN86355Cessna 182 · S/N 182-61929Cancelled Mar 26, 1974 · Exported to Canada · Built 1973 · Northwestern Resources CoN3079NCessna 140 · S/N 13337Cancelled Apr 10, 1972 · Whitcher Roy WN5896DPiper PA-18A 150 · S/N 18-5405Cancelled Mar 2, 1972 · Exported to Canada · William K ColmanN123CBLearjet 24D · S/N 232Cancelled Aug 3, 1971 · F & S Contracting CoN1995BLuscombe 8F · S/N 6422Cancelled Mar 23, 1971 · Francis John JN8798KStinson 108-1 · S/N 108-1798Cancelled Sep 9, 1970 · Built 1947 · Boese Earl LN8981ABeech C35 · S/N D-2733Cancelled Jul 27, 1970 · F & S Contracting CompanyN7104DPiper PA-22-150 · S/N 22-4961Cancelled May 8, 1969 · Exported to Canada · Built 1959 · Mcknight William SN7686DPiper PA-18-150 · S/N 18-5909Cancelled Jan 25, 1968 · Colman Aerial SprayersN1267XMooney M20E · S/N 140Cancelled Sep 24, 1965 · Jack ElderkinN1462CPiper PA-18A · S/N 18-2662Cancelled Aug 13, 1965 · John W Fox DBA Fox Flying ServiceN47770Fairchild M-62A · S/N T42-3215Cancelled May 21, 1965 · Toivo L KoivistoN93472Forney 415-C · S/N 795Cancelled May 21, 1965 · John O ThomasN2566ZCessna 185B · S/N 185-0566Cancelled Dec 15, 1964 · Naranche & Kondra Construction CoN2344CCessna 180 · S/N 30644Cancelled Sep 28, 1964 · Exported to Canada · Butte Aero Sales & Service IncN1041PPiper PA-23 · S/N 23-43Cancelled Feb 26, 1958 · H L CasebeerN26357Aeronca 65-LA · S/N L-8200Cancelled Nov 21, 1955 · Built 1940 · Highland Flying ClubN2207BLuscombe T-8F · S/N 6634Cancelled Nov 17, 1955 · Built 1949 · Fox John WN7367BBeech E35 · S/N D-3830Cancelled Jul 15, 1955 · Exported to Canada · Butte Aero Sales & Service IncN61318Boeing A75N1(PT17) · S/N 75-2952Cancelled Apr 1, 1955 · Jordan Paul WN2047EAeronca 7AC · S/N 7AC-5617Cancelled Dec 12, 1952 · Exported to Canada · Built 1946 · Butte Aero Sales And Service IncN642APiper PA-22 · S/N 22-45Cancelled Sep 18, 1952 · Exported to Canada · Built 1951 · Butte Aero Sales And Service IncN3341VBeech 35 · S/N D-804Cancelled Mar 10, 1952 · Exported to Canada · Casebeer Eye Ear Nose & Throat Hospital IncN73487Consolidated Vultee BT-13A · S/N 11225Cancelled Aug 7, 1951 · Butte Flyers IncN49469Fairchild M-62A-3 · S/N FT671Cancelled Apr 25, 1951 · Fox John WN88319Piper J3C-65 · S/N 15937Cancelled Jul 25, 1950 · Fox John W DBA Fox Flying Service
Back to Butte, MT