Skip to content

Friday Harbor, WA

Cancelled registrations · 52

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 = 'FRIDAY HARBOR' 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 = 'FRIDAY HARBOR'
  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 = 'FRIDAY HARBOR'
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.

N653LGWillows Dennis SPORTSMAN GS-2 · S/N 7439Cancelled Jun 16, 2023 · Exported to Canada · Built 2016 · Willows Dennis N7281ECessna 182B · S/N 52281Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 1959 · Swirtz Denny D N4660QCessna T210L · S/N 21059560Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1972 · Warren Guy D N9168WFranklin Ken DRAGONFLY · S/N 06923Cancelled May 8, 2021 · Registration expired, pending cancellation · Franklin Kenneth P N820DFRobinson Helicopter R44 · S/N 1164Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Built 2002 · Stasys Aviation Leasing LLC N801LWNavion NAVION G · S/N NAV-4-2440Cancelled Jun 29, 2019 · First renewal notice · Built 1962 · International Program Development Inc N56039Mooney M20J · S/N 24-1358Cancelled Apr 24, 2019 · Built 1982 · King David N69TCCessna 421A · S/N 421A0059Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1969 · Leonard Gary L N5398ZPiper PA-22-108 · S/N 22-9168Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1961 · Hook Bert N4864BCessna 310 · S/N 35164Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Built 1955 · Rennhack Terry DBA N58145Bell 206B · S/N 1170Cancelled Jul 13, 2016 · Exported to Philippines · Built 1973 · First Lady Inc N2881KCessna 180K · S/N 18053117Cancelled May 22, 2015 · Exported to Canada · Built 1979 · Geyman John P N5102VMorrisey 2150 · S/N FP-2Cancelled Feb 23, 2015 · Third renewal notice · Built 1958 · Casey David B N8066DPiper PA-22-150 · S/N 22-5589Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1957 · Hook Bert W N522VWOsborne John T TEENIE TWO · S/N 15-2206Cancelled Oct 6, 2014 · Registration expired, pending cancellation · Osborne John T N91062Cessna 182P · S/N 18261950Cancelled Aug 11, 2014 · Exported to Canada · Built 1973 · Greene Jerry A N471SDHughes Helicopters 369E · S/N 0179ECancelled Feb 7, 2014 · Exported to New Zealand · Sea Shepherd Conservation Society N315HAPiper PA-31-350 · S/N 31-7652093Cancelled Nov 8, 2013 · Registration expired, pending cancellation · Built 1976 · Aeronautical Services Inc N51FHDehavilland DHC-2 MK.I · S/N 283Cancelled Nov 6, 2013 · Exported to Canada · Built 1951 · Jones Nancy D N252MMMoose Air MURPHY MOOSE · S/N SR-252Cancelled Jul 24, 2013 · Exported to Canada · Built 2009 · Moose Air LLC N6611Thompson Henry E AVID FLYER · S/N 209Cancelled Apr 2, 2013 · Sale reported, canceled · Built 1987 N774WNSchweizer 269C · S/N 1153Cancelled Mar 20, 2013 · Exported to New Zealand · Sea Shepherd Conservation Society N2056BScott John L BOBCAT · S/N 1Cancelled Jan 24, 2013 · Sale reported, pending cancellation N2MAAdams PITTS S1C · S/N 1PALTCancelled Oct 16, 2012 · Registration expired, pending cancellation · Built 1968 · Abs Specialties Inc N63088Cessna 150M · S/N 15077095Cancelled Sep 10, 2012 · Registration pending, canceled · Built 1975 N2040QCessna 177RG · S/N 177RG0440Cancelled Aug 2, 2012 · Exported to Canada · Built 1973 · Dunn James F N255AMCessna 172N · S/N 17270221Cancelled Jan 9, 2012 · Exported to Colombia · Built 1978 · Mazzarella Anthony N6540CDehavilland DHC-1 CHIPMUNK · S/N C1/0654Cancelled Jan 14, 2011 · Geyman John P N9306RCessna 180B · S/N 50543Cancelled May 19, 2009 · Exported to New Zealand · Built 1959 · Terry Peter N20582Cessna 172M · S/N 17261414Cancelled Feb 18, 2009 · Triennial form not returned · Built 1973 · Calvert Brian L N94LLBeech E-55 · S/N TE-1080Cancelled Apr 9, 2008 · Triennial form not returned · Built 1976 · Mulligan George G N5194UCessna 172RG · S/N 172RG0277Cancelled Nov 29, 2007 · Exported to Canada · Built 1980 · Higginson Carla J N355TLTurbine Legend 601 TURBINE LEGEND · S/N 128TCancelled May 31, 2006 · Built 2001 · Turbine Legend 601 Inc N757MUCessna TR182 · S/N R18201248Cancelled Dec 22, 2005 · Exported to Canada · Parfit Michael D N211SAFairchild SA227-DC · S/N DC-890BCancelled Nov 30, 2005 · Exported to Canada · Built 1996 · Alta Leasing Ltd N733SWCessna 172N · S/N 17268521Cancelled Nov 3, 2004 · Triennial form not returned · Built 1977 · Aeronautical Services Inc N9233NThorell Lennart G AVID AMPHIBIAN · S/N 103ACancelled Nov 3, 2003 · Exported to Sweden · Built 1996 · Thorell Lennart G N411FHBell 206B · S/N 371Cancelled Oct 6, 2003 · Exported to Canada · Built 1969 · First Lady Inc N2623JCessna 150G · S/N 15065623Cancelled Aug 2, 2001 · Hook Jerry L N357ASDehavilland DHC-3 · S/N 357Cancelled Apr 24, 2001 · Exported to Canada · Aeronautical Services Inc N81600Hook Jerry L BLUEBIRD · S/N BB1Cancelled Oct 30, 1998 · Hook Jerry L N444BGVan Horn Robert E VELOCITY · S/N DM053Cancelled Apr 9, 1997 · Triennial form not returned · Van Horn Robert E N98132Piper PA-28-140 · S/N 2826060Cancelled Apr 2, 1997 · Triennial form not returned · King Krisr N6664POsborne John T KB-2 · S/N OB2Cancelled Dec 30, 1994 · Triennial form not returned · Osborne John T N4174LCessna 172G · S/N 17254243Cancelled Nov 23, 1993 · Triennial form not returned · Penwell Frank M N885RBeech N35 · S/N D6618Cancelled Mar 31, 1993 · Krabbe F L Co-Trustee N4223PRyan Aeronautical ST3KR · S/N 1691Cancelled Sep 23, 1992 · Brewer Lee A N5559ZPiper PA-22-108 · S/N 229356Cancelled May 20, 1977 · Exported to Canada · King Gerald N98722Piper J-3 · S/N 18951Cancelled May 2, 1975 · Logan John R N2388APiper PA-22-135 · S/N 22-753Cancelled Dec 11, 1973 · Exported to Canada · Schultz Wilbur H

Back to Friday Harbor, WA