Skip to content

Port Angeles, WA

Cancelled registrations · 90

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 = 'WA' AND d.registrant_city = 'PORT ANGELES' 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 = 'WA' AND d.registrant_city = 'PORT ANGELES'
  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 = 'WA' AND d.registrant_city = 'PORT ANGELES'
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.

N200PXEverett Randall L ROTORWAY EXEC 162F · S/N 6730Cancelled May 19, 2025 · Sale reported, canceled N510TLBeech 400A · S/N RK-13Cancelled Jun 21, 2024 · Exported to Brazil · Built 1991 · Berard Aviation Inc N907WCCanadair CL-600-2B16 · S/N 5048Cancelled Sep 11, 2023 · Exported to South Africa · Built 1989 · Berard Aviation Inc N228DACessna 208B · S/N 208B2052Cancelled Aug 9, 2023 · Exported to Canada · Built 2008 · Airpac Airlines Inc N77GTSheldrick John H RV-6 · S/N 20599-01Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Wright Jordan M N105RAirborne OUTBACK · S/N 582-937Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Built 2004 · Woodward Russell O N95FXDenney Aerocraft KITFOX 4B · S/N SP11794Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Hilderbrand Dale D N595KFPahls Herman KITFOX · S/N 190Cancelled Jan 23, 2021 · Built 1995 · Fitzgerald Scott C N666JDAlbert Hall OLD CROW 1 · S/N 001Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Built 2017 · Albert Hall Co Inc N297GGeorgi William F SHA-GLASAIR RG-1 · S/N 297Cancelled Jun 2, 2020 · Registration expired, pending cancellation · Built 1994 · Wahto Jerry P N734QQCessna 172N · S/N 17269034Cancelled Apr 1, 2019 · Built 1977 · Well Jeffrey L N4891YYounie Norman RV-6 · S/N 23090Cancelled Aug 30, 2018 · Exported to Canada · Halsey Derrick J N2741AKanters David J DK1 · S/N 1432Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 2001 · Kanters David J N116GTMeise Graham Q VELOCITY R G · S/N 184Cancelled Oct 18, 2017 · Built 1996 · Rudin Melvin N7308YPiper PA-30 · S/N 30-310Cancelled Feb 4, 2017 · Revoked, canceled · Built 1964 · Charest Robert D N26LLRans S6ES · S/N 11021468Cancelled Aug 5, 2016 · Exported to Canada · Built 2007 · Gilstad Claire J N4085NCessna 120 · S/N 13543Cancelled Mar 17, 2016 · Second renewal notice · Built 1947 · Herz Guenther N157MBBrown Michael William DESERT EAGLE II · S/N DE001Cancelled May 18, 2015 · Registration expired, pending cancellation · Brown Michael W N14PMMessinger Paul H PEGAZAIR-100 · S/N 2002Cancelled Sep 5, 2014 · Registration expired, pending cancellation · Messinger Paul H N13ANNunes SCORPION TOO · S/N 13Cancelled Sep 3, 2014 · Registration expired, pending cancellation · Built 1974 · Waugh John C N613VJBeech 95-B55 (T42A) · S/N TC-1851Cancelled May 5, 2014 · Exported to Canada · Built 1975 · Green Crow East Inc N76751Welch Richard J SR7 XL · S/N SR7XL-2623Cancelled Sep 11, 2013 · Registration expired, pending cancellation · Built 2000 · Welch Richard J N2565PPiper PA-38-112 · S/N 38-79A1040Cancelled Aug 8, 2013 · Registration expired, pending cancellation · Bertsch Wayne W N3576BPiper PA-28-181 · S/N 28-8090204Cancelled Oct 4, 2012 · Registration expired, pending cancellation · Built 1979 · Far West Aviation Inc N8746YPiper PA-30 · S/N 30-1901Cancelled Sep 10, 2012 · Registration expired, pending cancellation · Built 1969 · Charest Robert D N56730Piper PA-34-200 · S/N 34-7450027Cancelled Aug 28, 2012 · First renewal notice · Built 1973 · Well Jeffrey L N21913Cessna 150L · S/N 15074531Cancelled Aug 27, 2012 · Registration expired, pending cancellation · Built 1973 · Hay Larry M N54226Leech Jerry L SCORPION 133 · S/N 6-86Cancelled Aug 10, 2012 · Registration pending, canceled N5097TPiper PA-28-140 · S/N 28-7225345Cancelled Jun 12, 2012 · Registration pending, canceled · Built 1972 N214KKolb FIREFLY · S/N FF037Cancelled Jun 5, 2012 · Exported to Canada · Barnard Alan D N747CLLarson Carroll B RV8 · S/N 82431Cancelled May 9, 2012 · First renewal notice · Built 2008 · Larson Carroll B N6514Rohrstaff-Bowers FLY BABY · S/N 68-14Cancelled Nov 2, 2010 · Second triennial mailing, no response · Built 1968 · Port Angeles Flyers N3014YCessna 182E · S/N 18254014Cancelled Jul 11, 2008 · Exported to Canada · Built 1962 · Vadnais James C N79404Cessna 182P · S/N 18261815Cancelled Sep 28, 2006 · Triennial form not returned · Built 1973 · Well Jeffrey L N987MMRimov Eugene D CAPELLA XS 912 · S/N FW2C80TRO332291Cancelled Feb 17, 2006 · Triennial form not returned · Built 1995 · Rimov Eugene D N4061WPiper PA-32-300 · S/N 32-40091Cancelled Jul 20, 2000 · Exported to Canada · Admiral Marine Works Inc N89PRRose Patrick W VP-1 · S/N V2241Cancelled Oct 14, 1998 · Roberts Danny D N5FAAmerican AA-1A · S/N AA1A0365Cancelled Dec 28, 1992 · Triennial form not returned · Formidable Aviators Association N8181HBeech C-45H · S/N 52-10637Cancelled Dec 9, 1992 · Built 1963 · Rairchild William R N14CUHiller UH-12E · S/N 1329Cancelled Feb 19, 1991 · Exported to Hungary · Rogerson Hiller Corporation N3413ECessna 172N · S/N 17271536Cancelled Jul 25, 1985 · Administratively canceled · Pearson Aircraft Inc N1924JRockwell International 114 · S/N 14024Cancelled Jun 15, 1984 · Administratively canceled · Fairshter J J N1780DCessna 170A · S/N 20223Cancelled Jan 25, 1984 · Administratively canceled · Nixon Viola M N759EZCessna 182Q · S/N 18265947Cancelled Jan 6, 1983 · R Erdmann Trucking Inc N6712HCessna 172M · S/N 17265551Cancelled May 18, 1981 · Exported to Canada · Halvorsen James M N5065TPiper PA-28-180 · S/N 287205245Cancelled Dec 1, 1980 · Exported to Canada · Pearson Aircraft Inc N4100CStinson 108-3 · S/N 108-5100Cancelled Sep 22, 1980 · Built 1948 · Andre David E N5199NCessna 182Q · S/N 18267567Cancelled Aug 22, 1980 · Exported to Canada · Pearson Aircraft Inc N6263DCessna 172N · S/N 17272674Cancelled Jul 2, 1980 · Exported to Canada · Pearson Aircraft Inc N24259Cessna 152 · S/N 15280179Cancelled Mar 18, 1980 · Exported to Canada · Built 1977 · Pearson Aircraft Inc

Back to Port Angeles, WA