Skip to content

Cancelled registrations · 67

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

N56284Six Chuter SR7 XL · S/N 99-2349Cancelled Feb 17, 2024 · Sale reported, canceled · Built 1999 N2119BLuscombe 8F · S/N 6546Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Doubleday Wendel W N1775Griesbeck Werner L-4 CUBY FLITFIRE · S/N 1993Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Hanson Mark G N1828QCessna 177RG · S/N 177RG0228Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Built 1971 · Smith John N4148ACameron Balloons US A-140 · S/N 5715Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Woodward Jay N5792LAmerican AA-1 · S/N AA1-0192Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Built 1970 · Blackman Kennis G N753XBFreefly Systems ALTA 6 · S/N 475250Cancelled Jan 17, 2020 · Sale reported, canceled N14722Fairchild 24 C8C · S/N 2644Cancelled Mar 23, 2019 · Registration expired, pending cancellation · Built 1934 · Avendeavor LLC N3832NBeech 35 · S/N D-1069Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Built 1947 · Rentko David W N1966KCessna 180H · S/N 180-51761Cancelled Apr 13, 2018 · Exported to Canada · Built 1966 · Sherod Neal N85336Aeronca 7AC · S/N 7AC-4075Cancelled Apr 9, 2018 · Revoked, canceled · Built 1946 · Hess Murray J N7432FHughes 269C · S/N 160458Cancelled Mar 28, 2018 · Registration expired, pending cancellation · Built 1976 · Snohomish Flying Service Inc N409SCBell UH-1H · S/N 68-15409Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Snohomish County Search And Rescue N9674LGrumman American Avn. AA-1B · S/N AA1B-0174Cancelled Jan 12, 2018 · Registration expired, pending cancellation · Built 1973 · A&B Aircraft DBA N3251Aeronca-Hess C2 · S/N X1Cancelled Oct 28, 2017 · Revoked, canceled · Built 1934 · Hess Murray J N788SDBell OH-58A · S/N 71-20788Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Snohomish County Volunteer Search And Rescue N494DHDarrell Hay AVID MK 4 STOL · S/N 94DHCancelled Jul 7, 2017 · Registration expired, pending cancellation · Hay Darrell N9975BCessna 182A · S/N 34375Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1957 · Verticle Ventures Inc N10986Bellanca 7ACA · S/N 43-72Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Built 1972 · Parker David A N40295Piper PA-23-250 · S/N 27-7305110Cancelled Nov 16, 2016 · Built 1973 · Behla Carl H N113TJHarding Tom TWO SEATER · S/N 0895Cancelled May 4, 2015 · Registration expired, pending cancellation · Harding Tom N4100UCessna 150D · S/N 15060100Cancelled Oct 6, 2014 · Registration expired, pending cancellation · Built 1963 · Sky Valley Aviators Inc N602PTCessna TP206D · S/N P2060562Cancelled Nov 27, 2013 · Exported to Canada · Built 1969 · Skydive Snohomish Inc N24RSYannotti A C/Kindig D A RENEGADE SPIRIT · S/N 424Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Built 1991 · Yannotti Anne C N71160Balloon Works FIREFLY 8-24 · S/N F8-123Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Built 1988 · Wicks Enterprises Inc N4518UGulfstream American AA-5B · S/N AA5B1046Cancelled Aug 22, 2013 · Sale reported, canceled N1947NCessna 120 · S/N 12187Cancelled Aug 7, 2013 · Registration expired, pending cancellation · Built 1947 · Day Patrick K N10LHHegsted H1 · S/N G-1Cancelled Aug 5, 2013 · Registration expired, pending cancellation · Built 1970 · Christensen Lynn W N644VZDavison JB VARI EZE · S/N 237-ACancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 2008 · Davison James B N1521EBalloon Works FIREFLY 7-B · S/N 11037Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1981 · Knaus Randi B N44362Taylorcraft BC12-D1 · S/N 10162Cancelled Nov 29, 2012 · Registration expired, pending cancellation · Built 1946 · Last Gordon R N4644XCessna 150G · S/N 15064694Cancelled Nov 27, 2012 · Sale reported, canceled · Built 1966 N36712Stinson 10A · S/N 8112Cancelled Sep 20, 2012 · Sale reported, canceled · Built 1941 N2HCCooper STARDUSTER "TOO" · S/N C1057Cancelled Jun 8, 2011 · Registration pending, canceled · Built 1973 N8831GCessna 150F · S/N 15062931Cancelled Jan 31, 2011 · Exported to Russia · Built 1966 · Nickel Galen L N228CStinson 108-2 · S/N 108-3228Cancelled Jul 30, 2010 · Triennial form not returned · Built 1947 · Caballeros Aircraft LLC N763CPVerbeek Phil EXEC 90 · S/N 5001Cancelled Feb 10, 2009 · Triennial form not returned · Built 1991 · Verbeek Phil R N82LJChristensen Lynn W BREEZY CB-1 · S/N 2001Cancelled Dec 14, 2005 · Triennial form not returned · Built 1984 · Christensen Lynn W N13RMSeattle Aerotech HELIPOWER 2500 · S/N 0101Cancelled Jun 20, 2005 · Triennial form undeliverable · Built 2002 · General Helicopter Inc N7218LLee Won Hak SA 100 · S/N 97001Cancelled Jun 15, 2005 · Triennial form undeliverable · Built 2000 · General Helicopter Inc N3433TCessna 177 · S/N 17700733Cancelled Oct 8, 2002 · Triennial form not returned · Built 1968 · Smith Ralph S N69260Cessna 152 · S/N 15282589Cancelled Jun 8, 2000 · Triennial form not returned · Harvey Richard N N80686Robinson Helicopter R22 BETA · S/N 1280Cancelled Sep 8, 1999 · Exported to Kenya · Hickman Tyrone A N102JTSchwarz Charles W THORP T-18 · S/N 1191Cancelled Aug 11, 1997 · Taylor Jeffrey L N2561EBalloon Works FIREFLY 9 · S/N F9058Cancelled Jun 2, 1997 · Exported to Canada · Wicks Enterprises Inc DBA N91AVCessna 150H · S/N 15069265Cancelled May 17, 1996 · Exported to Czech Republic · Taylor Jeffrey L N4932HCessna 152 · S/N 15284027Cancelled Aug 17, 1995 · Triennial form not returned · Harvey Airfield Inc N7179MCessna 175 · S/N 55479Cancelled Aug 14, 1995 · Exported to Canada · Thorson Eric K N49231Cessna 152 · S/N 15281206Cancelled Aug 3, 1994 · Triennial form not returned · Harvey Airfield Inc N3785SScott Solon S AIR SKIMMER · S/N 314Cancelled Jul 19, 1994 · Triennial form not returned · Scott Solon S

Back to Snohomish, WA