OpenAirDocs.org
Watsonville, CA

Cancelled registrations · 49

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 = 'CA' AND d.registrant_city = 'WATSONVILLE'
  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.

N916WBBerry Scott W LANCAIR LEGACY · S/N L2K-231Cancelled Oct 28, 2023 · Sale reported, canceledN160MMFFT SC01 B-160 · S/N S-61Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1992 · Smith Travis TN700NJPiper AEROSTAR 601P · S/N 61P06187963279Cancelled Sep 22, 2020 · Registration expired, pending cancellation · Built 1979 · Wempe Henry JN7342NCessna TU206G · S/N U20603621Cancelled Aug 28, 2020 · Exported to Germany · Built 1976 · Skydive Surfcity IncN2924DCessna 170B · S/N 26867Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Built 1955 · Ross Joyce AN831CLLaws Christopher S-12 AIRAILE · S/N 0592221Cancelled Mar 16, 2018 · Registration expired, pending cancellation · Laws Christopher EN2045LBeech C23 · S/N M-1855Cancelled Feb 27, 2018 · Registration expired, pending cancellation · Built 1976 · Strobl Peter RN83025Aeronca 7AC · S/N 7AC-1682Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Boyman E CN342CBBeech P35 · S/N D-7111Cancelled May 7, 2015 · Registration expired, pending cancellation · Built 1963 · Manning GaryN3184GGriffin William Jeffrey COUGAR · S/N SNC0001JGCancelled May 6, 2015 · Registration expired, pending cancellation · Built 1992 · Griffin William JN71985Luscombe 8A · S/N 3412Cancelled Nov 12, 2013 · Registration expired, pending cancellation · Built 1946 · Collins Roger EN2593AClegg Marlin GOLDWING · S/N MZ82Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1982 · Clegg MarlinN420PKGyroflug SC 01 B 160 · S/N S 54Cancelled May 21, 2013 · Registration expired, pending cancellation · Smith Travis TN3617WPiper PA-32-260 · S/N 32-518Cancelled Apr 24, 2013 · Exported to Russia · Built 1966 · 3617w IncN1557QCessna 150L · S/N 15072857Cancelled Apr 11, 2013 · Registration expired, pending cancellation · Built 1971 · Hubbell Jennifer LN5050MTaylorcraft BC12-D · S/N 10350Cancelled Apr 2, 2013 · Sale reported, canceled · Built 1946N4521DRobinson Helicopter R22 BETA · S/N 4556Cancelled Mar 13, 2013 · Exported to Brazil · Built 2012 · Specialized Helicopters LLCN7036MRobinson Helicopter R44 II · S/N 13353Cancelled Mar 13, 2013 · Exported to Brazil · Built 2012 · Specialized Helicopters LLCN1411QCessna 150L · S/N 15072711Cancelled Jan 31, 2013 · Registration expired, pending cancellation · Built 1971 · Donesky Conroy FrederickN10ZMZaccaria & Miller VARIEZE · S/N 621Cancelled Oct 11, 2012 · Registration expired, pending cancellation · Built 1980 · Zaccaria Bert LN4479URobinson Helicopter R22 BETA · S/N 4555Cancelled Oct 4, 2012 · Exported to Brazil · Built 2012 · Specialized Helicopters LLCN16150Cessna 177B · S/N 17702488Cancelled Aug 9, 2012 · Registration expired, pending cancellation · Built 1976 · Layhee TimothyN5210YCessna T182T · S/N T18208157Cancelled Jun 14, 2011 · Exported to Brazil · Built 2002N3463QPiper PA-28R-201 · S/N 28R-7737055Cancelled May 14, 2011 · First renewal notice · Monterey Bay Aviation IncN89955Cessna 152 · S/N 15282926Cancelled Jul 28, 2010 · Exported to South Korea · Built 1978 · Monterey Bay Aviation IncN17111Stinson SR-8A · S/N 9783Cancelled Jul 1, 2009 · Registration revoked · Built 1936 · Northup Edwin VN3871SCessna 172E · S/N 17251071Cancelled Mar 6, 2004 · Triennial form not returned · Built 1963 · Strawberry Aviation IncN7515Nall SPEZIO DAL-1 SPORT · S/N 227Cancelled Apr 3, 2002 · Exported to New Zealand · Built 1967 · Johnston SabrinaN84TXBingelis Antoni FALCO F.8L · S/N 506Cancelled Jan 7, 2002 · Triennial form not returned · Graham Courtney PN7146ZDay Steven B MX SPORT II · S/N 111Cancelled Jun 25, 1992 · Della Maggiore Gary JN80274Cessna 172M · S/N 17266489Cancelled Mar 3, 1992 · Triennial form not returned · Cleverdon William T III DBAN1787RCessna R182 · S/N R18200560Cancelled Nov 27, 1991 · Triennial form not returned · Urgo Eugene EN2516EPiper PA-38-112 · S/N 3878A0478Cancelled Jul 18, 1991 · Santa Cruz Aviation IncN82DSkelton Dwight EMERAUDE · S/N 1456Cancelled Mar 27, 1991 · Triennial form not returned · Skelton Dwight DN82627Aeronca 7AC · S/N 7AC-1269Cancelled Mar 31, 1982 · Exported to Australia · Frank Roger CN6359GCessna 150K · S/N 15071859Cancelled Mar 27, 1975 · Peterson Douglas WN8736ABeech A35 · S/N D-2158Cancelled Oct 25, 1973 · Wiler George MN66712Stinson L-5 · S/N 76867Cancelled Mar 22, 1971 · Ruz Len FN8425TCessna 182B · S/N 52325Cancelled Feb 12, 1971 · Alibi Flying Club IncN8877SCessna 150F · S/N 15062177Cancelled Nov 29, 1965 · Watsonville Aircraft Sales & CharterN4227KRyan NAVION · S/N NAV-4-1227Cancelled Apr 30, 1956 · Los Pajaros Flying Club IncN66931Consolidated Vultee BT-13A · S/N 3435Cancelled Oct 25, 1955 · Mcconnell Harold LN57095Fairchild M-62A · S/N T43-5502Cancelled Oct 11, 1955 · Poppy Pickers Flying ClubN9090ACessna 170A · S/N 18849Cancelled Jul 15, 1952 · Lerek Nicholas GN8106HHiller UH-12 · S/N 106Cancelled Aug 30, 1950 · J L Hanna Jr DBA Pioneer HelicoptersN21974Porterfield CP-50 · S/N 560Cancelled Jun 29, 1950 · Built 1939 · Razor FreemanN1794KLuscombe 8E · S/N 4521Cancelled Oct 27, 1949 · Watsonville Flying Club IncN2768Heath SUPER PARASOL · S/N 2-DCancelled Feb 1, 1936 · Stierli MaxN6699Waco GXE · S/N 1606Cancelled Oct 21, 1935 · Built 1928 · Gunter Al
Back to Watsonville, CA