OpenAirDocs.org
Troutdale, OR

Cancelled registrations · 117

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 = 'OR' AND d.registrant_city = 'TROUTDALE'
  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.

N1KSCessna 150F · S/N 15061836Cancelled Jul 27, 2024 · Registration pending, canceledN7380VBellanca 17-30 · S/N 30208Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Rhule Connor LN4983ACessna 180 · S/N 32380Cancelled Dec 30, 2019 · Revoked, canceled · Built 1956 · Carlson Gordon EN6158BCessna 182T · S/N 18282069Cancelled Aug 8, 2018 · Exported to Canada · Built 2008 · Tas Aircraft Sales LLCN7212LAero Vodochody L-29RS · S/N 294675Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1972 · Avtech Performance IncN7237MCessna 175 · S/N 55537Cancelled Nov 21, 2017 · Revoked, canceled · Built 1958 · Richards L VN56MQCorcoran Philip E KITFOX IV · S/N 1441Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Built 1994 · Kreps Frank DN9003UMalone Scott EXEC · S/N 002Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 2000 · Malone Scott MN111FLRockwell International 690A · S/N 11163Cancelled Dec 19, 2014 · Registration expired, pending cancellation · Built 1974 · Legal Air Flight Services IncN4258UFairchild Hiller FH-1100 · S/N 58Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Conquest Helicopters IncN8011ACessna 170B · S/N 20863Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1952 · Deusner Theodore E JrN78284Cessna 172K · S/N 17257553Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1968 · Treetop Aviation IncN345SSCessna TU206G · S/N U20604904Cancelled Oct 3, 2012 · Registration expired, pending cancellation · Built 1979 · Sunrise Systems IncN79059Cessna T-50 · S/N 4833Cancelled Sep 10, 2012 · Revoked, canceled · Built 1943 · Troutdale AirmotiveN66259Cessna T-50 · S/N 3830Cancelled Sep 5, 2012 · Revoked, canceled · Troutdale AirmotiveN726SRCirrus Design SR22 · S/N 2533Cancelled Oct 27, 2011 · Exported to South Africa · Built 2007 · Tas Aircraft Sales LLCN69526Cessna T-50 · S/N 1435Cancelled Jun 14, 2011 · Revoked, pending cancellation · Built 1941 · Robinson Elbert AN1324NCessna UC-78 · S/N 2750Cancelled May 27, 2011 · Revoked, canceled · Robinson E AN133CFCirrus Design SR22 · S/N 3104Cancelled Oct 21, 2010 · Exported to Brazil · Tas Aircraft Sales LLCN128TLCirrus Design SR22 · S/N 2280Cancelled Aug 23, 2010 · Exported to Australia · Built 2006 · Wallin LanceN686SGEmbraer EMB-135BJ · S/N 145686Cancelled Oct 29, 2004 · Exported to Aruba · Built 2003 · Interstate Equipment Leasing IncN5385MSalzmann Werner RV 4 · S/N 326Cancelled Oct 1, 2003 · Triennial form not returned · Built 1988 · Salzmann Werner KarlN5198JCessna 402B · S/N 402B0885Cancelled May 1, 2003 · Second triennial mailing, no response · Built 1975 · Sports Air Travel IncN6855WPiper PA-28-140 · S/N 28-21011Cancelled Oct 21, 2002 · Triennial form not returned · Built 1965 · Desjardins Norman WN8997UCessna 150M · S/N 15078047Cancelled Jun 29, 2001 · Exported to Lithuania · Troutdale Aircraft Leasing CompanyN161SGPiper PA-28-161 · S/N 28-7916425Cancelled Jul 6, 2000 · Exported to Malaysia · Troutdale Aircraft Leasing CompanyN43263Piper PA-28-161 · S/N 28-8416032Cancelled Jul 6, 2000 · Exported to Malaysia · Troutdale Aircraft Leasing CompanyN8149WPiper PA-28-161 · S/N 28-8016256Cancelled Jul 6, 2000 · Exported to Malaysia · Troutdale Aircraft Leasing CompanyN6569BMooney M20A · S/N 1239Cancelled Jan 6, 1994 · Triennial form not returned · Premier Aircraft Engines IncN50GPCessna 402B · S/N 402B1088Cancelled Sep 16, 1992 · Triennial form not returned · Sports Air Travel IncN737RBCessna 172N · S/N 17269606Cancelled Jun 17, 1991 · Triennial form not returned · Scenic Air Service IncN4430CCessna 195 · S/N 49-1959Cancelled May 20, 1985 · Built 1953 · Troutdale AirmotiveN52277Cessna 172P · S/N 17274477Cancelled Sep 2, 1983 · Exported to Japan · Aar Western Skyways IncN6188DCessna 172N · S/N 172-72622Cancelled Mar 16, 1981 · Exported to Canada · Aar Western Skyways IncN64084Cessna 172M · S/N 17265007Cancelled Aug 1, 1980 · Blue Skies Flying Club IncN19426Cessna 150L · S/N 15074414Cancelled Jul 28, 1980 · Built 1973 · Blue Skies Flying Club IncN67574Cessna 152 · S/N 15281922Cancelled Mar 5, 1980 · Exported to Canada · Western Skyways IncN52874Cessna 177RG · S/N 177RG1295Cancelled Nov 27, 1979 · Exported to Netherlands · Western Skyways IncN4593ECessna A185F · S/N 18503804Cancelled Oct 12, 1979 · Exported to France · Built 1979 · Western Skyways IncN95978Cessna 182Q · S/N 18266695Cancelled Jun 4, 1979 · Exported to Canada · Aar Northwest IncN37132Cessna 404 · S/N 404-0115Cancelled Mar 15, 1979 · Exported to Japan · Western Skyways IncN756ZRCessna TU206G · S/N U20604491Cancelled Dec 18, 1978 · Exported to Japan · Western Skyways IncN4917UCessna 210E · S/N 21058617Cancelled May 1, 1978 · Exported to Canada · Western Skyways IncN45611Cessna 150M · S/N 15076987Cancelled Dec 1, 1977 · Built 1975 · Western Skyways IncN60SCessna T337G · S/N P3370157Cancelled Jun 20, 1977 · Exported to Chile · Western Skyways IncN85SCessna T337G · S/N P337-0182Cancelled May 20, 1977 · Exported to Canada · Western Skyways IncN85866Cessna T337D · S/N 337-1003Cancelled Apr 26, 1977 · Exported to Canada · Western Skyways IncN9430ZBeech C-45H · S/N 51-11516Cancelled Oct 4, 1976 · Sanborn George AN86406Cessna T337D · S/N 337-1178Cancelled Aug 11, 1976 · Exported to United Kingdom · Clavell JamesN72478Cessna 337G · S/N 33701599Cancelled Apr 27, 1976 · Exported to Canada · Western Skyways Inc
Back to Troutdale, OR