Skip to content

Cancelled registrations · 55

Query with SQL

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 = 'CANBY' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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

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 = 'CANBY'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N244BAAnderson Brent W VANS RV-4 · S/N 2224Cancelled Sep 5, 2026 · Sale reported · Built 2000 N112PRPudding River Bearhawk BEARHAWK LSA · S/N L-026Cancelled Dec 21, 2024 · Built 2019 · Pudding River Bearhawk LLC N2821LCessna 172H · S/N 17256021Cancelled Aug 5, 2024 · Sale reported, canceled · Built 1967 N6099MStinson 108-3 · S/N 108-4099Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 1947 · Pacific Timber Products LLC N217RSSell Raymond B EXEC · S/N E-3187Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Built 1990 · Sell Raymond B N160HBBeckham Steve RV-4 · S/N 554Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 1988 · Beckham Stephen L N238ABMaas Douglas W SIX CHUTER 2 · S/N 1003Cancelled Feb 11, 2021 · Built 2007 · Robertson Perry N429WCAgusta A119 · S/N 14511Cancelled Jan 19, 2021 · Exported to Canada · Built 2006 · Wilson Construction Co N819XF3D Robotics SOLO · S/N S111A5705470Cancelled Dec 5, 2020 · Registration expired, pending cancellation · Freitas Devin A N3792Hartung SPECIAL · S/N D-2Cancelled Jan 31, 2020 · Registration expired, pending cancellation · Built 1970 · Compton Willard K N207KSScott RV-6 · S/N 1Cancelled May 9, 2019 · Built 1993 · Scott Kenneth N89WTTerry William E DRAGONFLY DF-1-MK II · S/N 744Cancelled Jan 7, 2019 · Registration expired, pending cancellation · Built 1990 · Edwards Anthony J N57211Boeing D75N1 · S/N 753819Cancelled Jun 26, 2018 · Registration pending, canceled · Built 1942 N1941DBeech C35 · S/N D-3218Cancelled Mar 21, 2018 · Registration expired, pending cancellation · Built 1952 · Raser Susan M N93433Smith Arthor D CHALLENGER II · S/N BR CH 2001Cancelled Feb 26, 2018 · Registration expired, pending cancellation · Built 2007 · Smith Arthor D N427WCHughes Helicopters 369E · S/N 188ECancelled Feb 14, 2018 · Registration expired, pending cancellation · Wilson Construction Co N4000UPiper PA-30 · S/N 30-981Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Built 1966 · Farrant David A N69XPKeesler Patrick E PULSAR XP · S/N 347Cancelled Mar 9, 2017 · Exported to New Zealand · Built 2003 · Johnson Perry A N6VRGreen Thomas Jefferson RV-6 · S/N 20270Cancelled Sep 21, 2016 · First renewal notice · Built 1991 · Green Thomas J N500YYRaser Ralph W MINI 500 · S/N 298Cancelled Aug 16, 2016 · Third renewal notice · Built 1997 · Raser Ralph W N86150Aeronca 11AC · S/N 11AC-580Cancelled May 4, 2015 · Registration pending, pending cancellation · Built 1946 N4353UPiper PA-28RT-201T · S/N 28R-8431022Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Built 1984 · D M Aviation Enterprises Inc N90512Fletcher MR AMERICA · S/N 16Cancelled Nov 25, 2014 · Registration expired, pending cancellation · Built 1979 · Fletcher E H N2935YCessna 182E · S/N 18253935Cancelled Oct 18, 2013 · Registration expired, pending cancellation · Built 1962 · Martin Henry Stephen N2514QPiper PA-46-310P · S/N 46-8508098Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Built 1985 · Schwarz J N8845WPiper PA-28-235 · S/N 28-10396Cancelled May 23, 2013 · Registration expired, pending cancellation · Woody Jerry R Jr N53082Cessna 177RG · S/N 177RG1342Cancelled Apr 8, 2013 · Registration expired, pending cancellation · Built 1978 · Alpine Aviation Services Inc N1801HCessna 310C · S/N 35901Cancelled Jan 31, 2013 · Registration expired, pending cancellation · Built 1959 · Westby Dorthy C N233CECessna T182T · S/N T18208678Cancelled Dec 5, 2012 · Exported to Austria · Built 2007 · Canby Air Group LLC N4261DBeech G35 · S/N D-4480Cancelled Nov 21, 2012 · Registration expired, pending cancellation · Built 1956 · Wilmes Gary A N4112JPiper PA-28-140 · S/N 28-22428Cancelled Sep 18, 2012 · Revoked, canceled · Built 1966 · Blundell Marshall J N6297PPiper PA-24-250 · S/N 24-1408Cancelled Mar 13, 2012 · Built 1959 · Mehrers Stearman Nw Inc N100GDNorth American SNJ-5 · S/N 90866Cancelled Jan 4, 2011 · Sale reported, pending cancellation N107MJAeromot AMT-200(SUPR XIMNGO) · S/N 200.051Cancelled Apr 7, 2010 · Exported to Australia · Built 1995 · Stenbock Roger M N418WCSchweizer 269D · S/N 0009Cancelled Apr 27, 2009 · Exported to Japan · Built 1994 · Wilson Construction Co N605SGMaule M-7-235C · S/N 25105CCancelled Jul 17, 2008 · Exported to Canada · Built 2005 · Read-Bentz Inc N2638FCessna 182J · S/N 18256738Cancelled Jan 8, 2008 · Exported to Canada · Built 1966 · Harper Appraisal Service Inc N660KBeech 95-C55 · S/N TE-43Cancelled Oct 22, 2007 · Triennial form not returned · Built 1965 · Park William G N9499PPiper PA-24-260 · S/N 24-4960Cancelled Dec 10, 2004 · Exported to Australia · Built 1970 · Corporate Planning Research Group Inc N8245SPiper PA-28RT-201T · S/N 28R-8031151Cancelled Apr 15, 2002 · Exported to Germany · Built 1980 · West Coast Aviation Svcs Inc Trustee N2646APiper PA-22 · S/N 22-916Cancelled Aug 1, 2000 · Triennial form not returned · Bush Richard F N731DPCessna P210N · S/N P21000445Cancelled Jan 21, 1999 · Exported to Austria · Northern Wings Aviation Inc N24425Semco Balloon T · S/N SEM110Cancelled Apr 29, 1996 · Triennial form not returned · Stout John N3828LBeech B-60 · S/N P565Cancelled Apr 16, 1996 · Exported to Germany · Pacific Sky Service Inc Trustee N9148VPiper PA 46-350P · S/N 4622005Cancelled Aug 25, 1994 · Exported to Germany · Eastern Sky Aviation Inc Trustee N4801ACessna P210N · S/N P21000823Cancelled Aug 15, 1994 · Exported to Germany · Two Ten Inc Trustee N8344MPiper PA-34-220T · S/N 348133023Cancelled Sep 2, 1993 · Exported to Germany · Aero Bauer Inc N6443WCessna P210N · S/N P21000780Cancelled Sep 8, 1992 · Exported to Germany · Southern Sky Aviation Inc N9FVCessna P210N · S/N P21000225Cancelled Aug 12, 1992 · Exported to Switzerland · Timberline Aviation Inc N39728Piper PA-32RT-300T · S/N 32R7887155Cancelled Dec 27, 1991 · Exported to Germany · Western Acft Lsg Inc

Back to Canby, OR