OpenAirDocs.org
Whitefish, MT

Cancelled registrations · 45

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

N48LWMooney M20K · S/N 25-2021Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 1998 · Lpangel LLCN54TRRobinson Helicopter R22 BETA · S/N 3412Cancelled Jun 1, 2022 · Exported to Australia · Built 2003 · Sunshine Aviation LLCN1411ECessna 337 · S/N 337-0218Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Embassy Films LLCN5279VCessna T182T · S/N T18208177Cancelled Aug 12, 2020 · Exported to Canada · Built 2002 · Rimrock Properties LLCN166BWAviat A-1C-180 · S/N 3046Cancelled Jan 31, 2020 · Registration expired, pending cancellation · Built 2009 · Thi Montana IncN29FSEurocopter EC120B · S/N 1423Cancelled May 7, 2019 · Exported to Canada · Silverleaf Aviation LLCN524BFCessna 182A · S/N 34331Cancelled Mar 9, 2019 · Registration expired, pending cancellation · Built 1957 · Thinking Cap Aviation LLCN33179Brock Randall L CHALLENGER 1 · S/N RLB-001Cancelled Nov 17, 2018 · Sale reported, canceled · Built 1997N989GSJeffrey Scholl CINESTAR 8 · S/N C8Z5EWUAFX48Cancelled Sep 15, 2018 · Registration expired, pending cancellation · Gravity Shots.Com IncN987GSDJI INSPIRE 1 · S/N W13DCA13020883Cancelled Sep 14, 2018 · Registration expired, pending cancellation · Gravityshots.Com IncN988GSJeffrey Scholl CINESTAR 6 · S/N C6LECZ53D2CDCancelled Sep 14, 2018 · Registration expired, pending cancellation · Gravityshots.Com IncN18FMCessna 500 · S/N 500-0014Cancelled Mar 21, 2018 · Registration expired, pending cancellation · Built 1971 · Plaisir En Vol IncN199EKPiper PA46-500TP · S/N 4697305Cancelled Mar 8, 2018 · Exported to France · Built 2007 · E & L Holdings LLCN224HAAero Commander 560-E · S/N 567Cancelled Mar 1, 2018 · Registration expired, pending cancellation · Built 1957 · Flying E Ranch LLCN4371MPiper PA-12 · S/N 12-3307Cancelled Feb 14, 2018 · Registration expired, pending cancellation · Built 1947 · High Wing LLCN2007UMaule M-4-220C · S/N 2008CCancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1967 · Rogers Hugh AN7054CHughes 269A · S/N 480831Cancelled Oct 31, 2017 · Registration expired, pending cancellation · Built 1967 · Sandelin Jay CN106PMCessna T210N · S/N 21062965Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1979 · Papa Mike Aviation LLCN513XFolland GNAT T 1 · S/N XP513Cancelled Jul 5, 2016 · Exported to United Kingdom · Built 1964 · Theodore R Wright Enterprises IncN19616Cessna 172L · S/N 17260612Cancelled Apr 11, 2016 · Exported to Mexico · Built 1972 · Wright Carroll WN58672Nichols David L RTRY AF 2000 GTX SE · S/N H2-95-6-179Cancelled May 15, 2015 · Registration expired, pending cancellation · Nichols David LN478ELuscombe 8E · S/N 5405Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1947 · Bravo AviationN9019ZBalloon Works FIREFLY 8-24 · S/N F8-139Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1989 · Davis Steven MN75402Conat U.F.M. EASYRISER · S/N 519Cancelled Oct 10, 2014 · Revoked, pending cancellation · Conat Robert WN67060Dyck ROYAL RENAGADE (RR) · S/N 101Cancelled Sep 26, 2013 · Revoked, canceled · Built 1975 · Dyck Les RN4029QRobinson Helicopter R22 BETA · S/N 1529Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Built 1990 · Plexis Management IncN4024HWsk-Pzl Warzawa-Okecie PZL-104 WILGA 80 · S/N CF 21910931Cancelled Jun 17, 2013 · Exported to Canada · Built 1991 · Lee Gary PN26HRRussell Harry L SPEZIO SPORT DAL-1 · S/N 285Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1980 · Smith George TN331XHarris Jack C ROTORWAY EXEC · S/N 3095Cancelled Apr 2, 2013 · Sale reported, canceledN6013QMooney M20E · S/N 865Cancelled Mar 26, 2013 · Revoked, canceled · Built 1965 · Potter David E C ON7880FCessna 150F · S/N 15063980Cancelled Mar 13, 2013 · Third renewal notice · Built 1966 · Westfall James HN27203Northwestern PORTERFIELD LP-65 · S/N 700Cancelled Aug 27, 2012 · Sale reported, canceled · Built 1940N172PPCessna 172RG · S/N 172RG0742Cancelled Jun 7, 2011 · Exported to Canada · Built 1980 · Economy ScottN54657Beech D17S · S/N 4906Cancelled Jan 31, 2011 · Exported to Canada · Built 1943 · Holman RobertN487JCCarkhuff James L CUBY · S/N C-1Cancelled Oct 13, 2010 · Exported to Canada · Built 1991 · Mcmahon Thomas JN43253Piper PA-28-161 · S/N 28-8416018Cancelled Apr 14, 2010 · Triennial form not returned · Built 1983 · Betters Douglas LN85RFCirrus Design SR22 · S/N 2535Cancelled Sep 24, 2009 · Exported to Czech Republic · Built 2007 · Granite Ventures IncN5XKKeller Fred H PROSPECTOR · S/N 002Cancelled Nov 1, 2005 · Triennial form not returned · Built 1996 · Kuffel Betty JN7975DBeech H35 · S/N D-5265Cancelled Apr 1, 2002 · Triennial form not returned · Built 1957 · Wells Paul LN70504Cessna 182L · S/N 18259278Cancelled Mar 16, 1984 · Exported to Canada · Coverdale Richard CN75WBBeech C-45H · S/N 51-11665Cancelled May 4, 1983 · Exported to United Kingdom · Worth Bruce J & Deluca Rande D DBA Big Sky FilmsN5839JCessna A185E · S/N 18501808Cancelled Mar 30, 1983 · Exported to Canada · Cooney Stephen J DBA Sapphire AviationN3882DCessna 182A · S/N 34582Cancelled Feb 12, 1982 · Exported to Canada · Cooney Stephen JN5342BCessna 182 · S/N 18233342Cancelled Jun 5, 1979 · Exported to Australia · Dahlman Floyd FN12702Heath V · S/N 1Cancelled Dec 12, 1932 · Built 1932 · Cheever William
Back to Whitefish, MT