Helena, MT

Cancelled registrations · 154

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

N564XLLiberty Aerospace LIBERTY XL-2 · S/N 0050Cancelled Jul 7, 2011 · Registration expired, pending cancellation · Built 2006 · Laft Asset Management IncN9166YNorth American T-39A · S/N 61-0677Cancelled Dec 9, 2008 · Triennial form not returned · Helena Vocational Technical CenterN652CTEmbraer EMB-120ER · S/N 120.199Cancelled Jan 31, 2008 · Exported to Angola · Built 1990 · N652ct LLCN899THBoeing 747-200 · S/N 20929Cancelled May 19, 2007 · Richard Trudell IncN898THBoeing 747-300 SERIES · S/N 23639Cancelled Oct 5, 2006 · Exported to Thailand · Richard Trudell IncN50928WSK PZL Mielec M-18A · S/N 1Z023-06Cancelled May 17, 2006 · Exported to South Africa · Built 1992N388MBell UH-1B · S/N 62-4568Cancelled Sep 27, 2005 · Triennial form not returned · State Of Montana Department Of State LandsN11900Clarke Allan J DRAGON FLY · S/N 11796Cancelled May 20, 2005 · Exported to South Africa · Built 1997 · Clarke Allan JN152XGulfstream AM Corp Comm Div 690C · S/N 11692Cancelled Sep 28, 2004 · Exported to Canada · Built 1981 · Trans World Oil And Gas CorpN855JFCessna 210L · S/N 21059862Cancelled Feb 25, 2004 · Exported to Namibia · Built 1973 · Whale Robert HN94142Ercoupe 415-C · S/N 1465Cancelled Apr 22, 2003 · Triennial form not returned · Built 1946 · Wilhelm Clayton DN8091JPiper AEROSTAR 601P · S/N 61P05777963252Cancelled May 31, 2002 · Exported to Germany · Built 1978 · Conlink Finance CorporationN87338Cessna 310R · S/N 310R0518Cancelled Jul 6, 2000 · Triennial form not returned · Exec Air Montana IncN1103KHughes 269C · S/N 700945Cancelled Aug 5, 1999 · Exported to Mexico · Wolff Aviation LLCN7925GCessna 172L · S/N 17259625Cancelled Jan 13, 1998 · Triennial form not returned · Montana Air Service IncN664GMaule M-6-235 · S/N 7502CCancelled Jul 2, 1997 · Exported to Australia · Rust William PN2ALStarke RAND KR-2 · S/N 1023Cancelled Dec 28, 1995 · Triennial form not returned · Phillips Roger AN92GWWeiland Garold QB148-M · S/N 0092Cancelled Sep 27, 1994 · Triennial form not returned · Finley Jonathan DN100WXPiper PA-28-236 · S/N 287911062Cancelled Mar 25, 1991 · Triennial form not returned · Garden Spot Market IncN9410BCessna 175 · S/N 55210Cancelled Aug 20, 1984 · Administratively canceled · Bos Bernard DN30355Piper PA-28-161 · S/N 28-7816541Cancelled Aug 7, 1982 · Built 1978 · Capital Aero IncN93471Bell H-13E · S/N 51-13995Cancelled Oct 15, 1981 · Helena School District 1N93476Bell H-13E · S/N 51-14198Cancelled Oct 15, 1981 · Helena School District 1N93470Bell H-13E · S/N 51-13890Cancelled Sep 28, 1981 · Helena School District 1N24873Bell H-13E · S/N 13773Cancelled Dec 24, 1980 · Board Of Trustees School District #1N22195Cessna 210L · S/N 21059715Cancelled Jul 29, 1980 · B Y IncN9047North American F-86 · S/N 53-1396Cancelled May 14, 1979 · Board Of TrusteesN13106Cessna 172M · S/N 17262500Cancelled Oct 14, 1977 · Exported to Canada · Ken & Als Aircraft RentalsN20569Cessna 172M · S/N 17261402Cancelled Aug 3, 1976 · Exported to Canada · Morrison Flying Service IncN8383ZCessna 210-5(205) · S/N 205-0383Cancelled Jul 15, 1971 · C S S Flying ClubN9995XCessna 185 · S/N 1850195Cancelled Jun 26, 1970 · Montana Aeronautics CommissionN6447XCessna 180D · S/N 18050947Cancelled Jul 11, 1969 · Exported to Canada · Lindberg ArnoldN89878Cessna 140 · S/N 8923Cancelled Nov 8, 1960 · Exported to Canada · Lynam Gerald Joseph JrN8226ACessna 170B · S/N 25078Cancelled Mar 31, 1958 · Brandon A LN3565MPiper PA-12 · S/N 12-2413Cancelled Oct 11, 1957 · Exported to Canada · Alfred A RiseN2329EAeronca 7AC · S/N 7AC-5906Cancelled Jul 22, 1953 · Morrison Flying ServiceN2494EAeronca 7AC · S/N 7AC-6076Cancelled Nov 15, 1951 · Morrison Flying ServiceN48839Fairchild PT-19A · S/N T41-789Cancelled Mar 29, 1951 · Montana Skyways IncN48926Taylorcraft DCO-65 · S/N L-5429Cancelled Mar 29, 1951 · Helena School District 1 Dept Of AeronauticsN50178Fairchild M-62A · S/N T42-3524Cancelled Sep 13, 1950 · Charles R TiefenthalerN85737Aeronca 7AC · S/N 7AC-4484Cancelled Apr 27, 1950 · Morrison Flying ServiceN2055EAeronca 7AC · S/N 7AC-5625Cancelled Jan 11, 1950 · Morrison Flying ServiceN69545Cessna T-50 · S/N 1214Cancelled Aug 26, 1949 · Exported to Mexico · Montana Skyways IncN85736Aeronca 7AC · S/N 7AC-4483Cancelled Jul 15, 1949 · Morrison Flying ServiceN85734Aeronca 7AC · S/N 7AC-4481Cancelled Jul 14, 1949 · Morrison Flying ServiceN70904Piper J3C-65 · S/N 17921Cancelled Feb 9, 1949 · Montana Skyways IncN9481KStinson 108-2 · S/N 108-2481Cancelled Dec 3, 1948 · Morrison Flying ServiceN33822Aeronca 65-CA · S/N CA13681Cancelled Mar 28, 1946 · Built 1941 · Morrison Flying ServiceN10667Lay Brothers LT-1 · S/N 106Cancelled Apr 1, 1937 · Lay Jack DN330NFokker SUPER UNIVERSAL · S/N 867Cancelled Jan 5, 1937 · Morrison R E
Back to Helena, MT