Bozeman, MT

Cancelled registrations · 127

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

N5803JAerospatiale SA315B · S/N 2646Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1982 · Central Copters IncN586DKKamp Danny J MAXAIR DR 503 · S/N DR-0049Cancelled Apr 27, 2015 · Registration expired, pending cancellation · Kamp Danny JN8105GCessna T210K · S/N 21059405Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1970 · Meyer Wayne GN66255Cessna 150M · S/N 15075958Cancelled Nov 5, 2014 · Built 1974 · Cowdog Flyers LLCN4246NStuart John QUICKSILVER MXL II · S/N 1269Cancelled Sep 30, 2013 · Registration expired, pending cancellation · Built 1987 · Anderson Erik AN887DSDiamond Aircraft Ind DA 40 · S/N 40.747Cancelled Sep 23, 2013 · Exported to Australia · Built 2006 · Peak Aviation LLCN27717Stinson 10 · S/N 7657Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1940N8984ZCessna 310G · S/N 310G0084Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1962 · Berg Grabows PartnersN32TBGeneral Balloon AX-6 · S/N 437Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Built 1978 · Dirty Old Man LeasingN7948CPiper PA-28-181 · S/N 28-7690092Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1975N8502PPiper PA-24-400 · S/N 26-82Cancelled Jun 27, 2013 · Registration expired, pending cancellation · Built 1964 · Fowler Duane TrusteeN31093Kistler TEENIE TWO · S/N 5-10910Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1976 · Gier James CN6130LAmerican AA-1 · S/N AA1-0330Cancelled Apr 26, 2013 · Registration expired, pending cancellation · Built 1970 · Mccumber Mike RN154REDaniel Jay ROTEC RALLY 3 · S/N 25267Cancelled Apr 1, 2013 · Sale reported, canceled · Built 1983N22BWBeech F33A · S/N CE-476Cancelled Feb 7, 2013 · Registration expired, pending cancellation · Built 1973 · Leeth Scott GN4437APiper PA-22-150 · S/N 22-3766Cancelled Nov 30, 2012 · Registration expired, pending cancellation · Built 1956 · Price PaulN39742Piper PA-32RT-300T · S/N 32R-7887156Cancelled Sep 24, 2012 · Sale reported, canceled · Built 1978N135CCPiper PA 46-350P · S/N 4636192Cancelled Aug 30, 2012 · Registration expired, pending cancellation · Built 1999 · Deems Holdings LLCN12752Helmerichs Henry HELMERICHS 32 · S/N 1Cancelled Jan 18, 2012 · First renewal notice · Built 1932 · Museum Of The RockiesN671Central Copters LANCAIR IV-P · S/N LIV423Cancelled May 17, 2011 · Triennial form not returned · Built 2005 · Duffy MarkN433KCBell 407 · S/N 53433Cancelled Jun 2, 2010 · Exported to Canada · Built 2000 · Pintail Lodge IncN534CACessna 172N · S/N 17269379Cancelled Mar 26, 2010 · Exported to Philippines · Built 1977 · Plane Exchange CoN8377DBeech J35 · S/N D-5476Cancelled Sep 15, 2009 · Registration revoked · Built 1958 · Hawkins BobN54181Cessna 172P · S/N 17274909Cancelled Aug 3, 2009 · Exported to Indonesia · Built 1981 · Plane Exchange CoN1125NBozeman Soaring Society BOZEMAN · S/N PH1Cancelled Jun 25, 2009 · Registration revoked · Built 1954 · Bozeman Soaring Society IncN5350HCessna 152 · S/N 15284088Cancelled Apr 6, 2009 · Exported to Philippines · Built 1979 · Plane Exchange CoN5552LCessna 152 · S/N 15284354Cancelled Mar 13, 2009 · Exported to India · Built 1980 · Plane Exchange CoN757CUCessna 152 · S/N 15279640Cancelled Mar 13, 2009 · Exported to India · Built 1977 · Plane Exchange CoN94704Cessna 152 · S/N 15285769Cancelled Mar 13, 2009 · Exported to India · Built 1983 · Plane Exchange CoN49730Cessna 152 · S/N 15283499Cancelled Feb 12, 2009 · Exported to Poland · Built 1979 · Plane Exchange CoN4731HCessna 152 · S/N 15283973Cancelled Oct 24, 2008 · Exported to Romania · Built 1979 · Plane Exchange CoN714YTCessna 152 · S/N 15279544Cancelled Oct 24, 2008 · Exported to Romania · Built 1977 · Plane Exchange CoN757NVCessna 152 · S/N 15279881Cancelled Oct 23, 2008 · Exported to Philippines · Built 1977 · Plane Exchange CoN5174RCessna 172M · S/N 17263391Cancelled Sep 19, 2008 · Exported to United Kingdom · Built 1974N8484MCessna 182P · S/N 18264622Cancelled Aug 7, 2008 · Exported to Canada · Built 1976 · Lovitt RuthmaryN309DWCessna 152 · S/N 15285245Cancelled Aug 5, 2008 · Exported to Poland · Built 1981N6279BCessna T210M · S/N 21062732Cancelled Aug 4, 2008 · Exported to Mexico · Built 1978 · Baker Joe BN12856Cessna 172M · S/N 17262315Cancelled Jul 21, 2008 · Exported to Philippines · Built 1973 · Plane Exchange CoN5803XAerospatiale SA315B · S/N 2649Cancelled Apr 18, 2008 · Exported to Canada · Central Copters IncN51154Cessna 172M · S/N 17264225Cancelled Apr 16, 2008 · Exported to Philippines · Built 1974 · Plane Exchange CoN24912Cessna 152 · S/N 15280446Cancelled Mar 31, 2008 · Exported to Philippines · Built 1977N5514HCessna 152 · S/N 15284107Cancelled Mar 31, 2008 · Exported to Philippines · Built 1979N46546Cessna 152 · S/N 15283070Cancelled Mar 26, 2008 · Exported to Canada · Built 1978 · Plane Exchange CoN838DSCessna 150M · S/N 15076963Cancelled Mar 12, 2008 · Exported to Canada · Built 1975 · Tribair LLCN95914Cessna 182Q · S/N 18266677Cancelled Mar 5, 2008 · Exported to Canada · Built 1978 · Stanley Benjamin AN10FDDiebold Frank E UFO · S/N FED1Cancelled Oct 23, 2007 · Triennial form not returned · Diebold Frank EN8431EPiper PA-28RT-201T · S/N 28R-8131194Cancelled Jun 27, 2007 · Exported to Canada · Ward Family CorporationN532ADPartlow David A AIR COMMAND · S/N DP001Cancelled Jun 26, 2007 · Diebold Frank EN363KRaytheon C90A · S/N LJ-1617Cancelled Jun 22, 2004 · Exported to Argentina · Pintail Lodge IncN2277TBell 206B · S/N 3631Cancelled Aug 19, 2002 · Triennial form not returned · Built 1982 · Carisch Helicopters Inc
Back to Bozeman, MT