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.

N2495BBell 47G-2 · S/N 1476Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1956 · Ballou Monte DBAN2739NCessna 140 · S/N 12997Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1947 · Padilla John AN1979CCessna 170B · S/N 26124Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1953 · Clhlc LLCN93EBEllen Steven CAPELLEN · S/N 101Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 1992 · Padilla John AN99472Lockheed T-33B · S/N 141549Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 1975 · Helena Vocational Technical CenterN106WCCarpenter Clifford W TERMITE · S/N 433Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Carpenter Clifford WN5958DPiper PA-22-150 · S/N 22-4622Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Keller Donald JN1895DBeech D35 · S/N D-3417Cancelled Oct 28, 2017 · Revoked, canceled · Built 1953 · Kutsko Michael JamesN280ADEnstrom 280FX · S/N 2013Cancelled Sep 26, 2017 · Registration expired, pending cancellation · Built 1987 · Po Leasing LLCN5811LCessna 320A · S/N 320A0031Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Built 1962 · Estes MaryN520XLLiberty Aerospace LIBERTY XL-2 · S/N 0015Cancelled May 31, 2017 · Registration expired, pending cancellation · Built 2006 · Laft LLCN16565Northrop F-89J · S/N 53-2453Cancelled May 15, 2017 · Registration expired, pending cancellation · Built 1953 · Helena Vocational Technical CenterN8195XCessna 172B · S/N 17248695Cancelled Apr 10, 2017 · Second renewal notice · Built 1961 · Roadstar LLCN352BCRaytheon B300 · S/N FL-463Cancelled Nov 15, 2016 · Exported to Italy · Built 2005 · L-3 Communications Advanced Aviation LLCN87551Beech 1900D · S/N UE-206Cancelled Aug 22, 2016 · Exported to Dominican Republic · Built 1996 · Ue-206 LLCN472WMSkykits SAVANNAH VGW · S/N 10-02-51-904Cancelled Jun 16, 2015 · Second renewal notice · Built 2011 · Maykuth Gerald SN7715TCessna 172A · S/N 47315Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1960 · Hruska Michael HN514DLOlson Darrell D KITFOX II · S/N 514Cancelled Mar 12, 2015 · Exported to Canada · Built 1994 · Hopler Harold WN550XLLiberty Aerospace LIBERTY XL-2 · S/N 0039Cancelled Mar 11, 2015 · Third renewal notice · Built 2006 · Laft Asset Management IncN41007Aeronca 7AC · S/N 7AC-5684Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Miller Steven EN9067MCessna 180H · S/N 18052167Cancelled Nov 25, 2014 · Registration expired, pending cancellation · Built 1970 · State Of MontanaN75732Sixchuter SR7 · S/N SR7X62601Cancelled Nov 21, 2014 · Dotter William AN2698YCessna 180F · S/N 18051198Cancelled Sep 5, 2014 · Registration expired, pending cancellation · Built 1962 · Mountain Flying LLCN700WWCessna T310R · S/N 310R0602Cancelled Jun 19, 2014 · First renewal notice · Built 1976 · Exec Air Montana IncN9259TStuart/Sims MTN EAGLE · S/N 2008Cancelled Nov 8, 2013 · Registration expired, pending cancellation · Sims James RN2176ZStuart J/Wagner R MOUNTAIN EAGLE · S/N 2000Cancelled Nov 4, 2013 · Registration expired, pending cancellation · Built 1994 · Stuart JimN13TGGleeson Troy Timothy SAMSARA · S/N 001Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Gleeson Troy TN3956FCessna 172 · S/N 36856Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1958 · Padilla John AN8970Convair F102A · S/N 56-11-16Cancelled Sep 30, 2013 · Registration expired, pending cancellation · Built 1956 · Helena Vocational Technical CenterN91VWTomash James AVID FLYER MODEL C · S/N 769Cancelled Sep 30, 2013 · Registration expired, pending cancellation · Montana Coyote AincN8255DBeech J35 · S/N D-5356Cancelled Sep 4, 2013 · Built 1957 · Vetter Brent EN555XSGulfstream American G-1159A · S/N 342Cancelled Aug 16, 2013 · Sale reported, canceledN64FPPiper PA-32-260 · S/N 32-535Cancelled Aug 13, 2013 · Registration expired, pending cancellation · Built 1966 · N64fp LLCN6428QMooney M20F · S/N 670507Cancelled Aug 6, 2013 · Revoked, canceled · Built 1967 · 3 J B Flying Club IncN692BMontana Coyote MONTANA COYOTE · S/N 1014Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Montana Coyote IncN692EMontana Coyote MONTANA COYOTE · S/N 1013Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1992 · Montana Coyote IncN9035YMorane-Saulnier MS760 · S/N 86Cancelled Jul 8, 2013 · Registration expired, pending cancellation · North Pacific Aircraft Devlpmt CoN8413FPiper PA-34-200T · S/N 34-7770083Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1976 · State Optical IncN7970BCessna 172 · S/N 29770Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1957 · Cobb Raymond PN5858DPiper PA-22-150 · S/N 22-4537Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1956 · Sasek Jack FN64BXMesserschmitt-Bolkow-Blohm GMB BO 105M · S/N 5064Cancelled Mar 28, 2013 · Exported to Guinea · Erickson MarkN3887TPiper PA-28R-180 · S/N 28R-30215Cancelled Jan 31, 2013 · Registration pending, canceled · Built 1967N728AFBeech 95-B55B (T42A) · S/N TF54Cancelled Jan 31, 2013 · Registration pending, canceledN502FRFouga CM 170 MAGISTER · S/N 502Cancelled Dec 18, 2012 · Registration expired, pending cancellation · Montana Capital Fund IncN135GZBell 407 · S/N 53072Cancelled Sep 7, 2012 · Grizzly Helo Leasing LLCN1500APiper PA-20 · S/N 20-684Cancelled Aug 14, 2012 · Registration pending, canceled · Built 1951N50632Cessna 150J · S/N 15069448Cancelled Aug 10, 2012 · Revoked, canceled · Built 1968 · Capital Aero IncN954EACessna 310R · S/N 310R0661Cancelled Aug 10, 2012 · First renewal notice · Built 1976 · Exec Air Montana IncN99471Bell H-13B · S/N 581497Cancelled Aug 6, 2012 · Registration pending, canceled · Built 1958N45126Cessna 150M · S/N 15076743Cancelled Jul 24, 2012 · Revoked, canceled · Built 1975 · Clavin Thomas L
Back to Helena, MT