OpenAirDocs.org
Ventura, CA

Cancelled registrations · 115

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

N8989PPiper PA-24-260 · S/N 24-4450Cancelled Jun 1, 2026 · Registration pending, canceled · Built 1966N4229ABell 47D1 · S/N 001Cancelled Feb 2, 2026 · Built 1961 · Aamold Basil LN279LTLoren Thompson WOLF PITTS · S/N 1Cancelled Nov 15, 2023 · Exported to Australia · Mershon Brooks GN16LGGriffith Layton D LDG HAWK · S/N 10LDGCancelled Jun 10, 2023 · Built 1997 · Griffith Layton DN451VCVentura County Sheriffs Office AEROVIRONMENT-QUBE · S/N 30109Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Ventura County Sheriffs OfficeN169JBPiper PA-30 · S/N 30-1169Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 1966 · Synergy Development Services IncN187VCVentura County Sheriffs Office AEROVIRONMENT-QUBE · S/N 30010Cancelled Jun 5, 2021 · Registration expired, pending cancellation · Ventura County Sheriffs OfficeN86929Bellanca 14-13 · S/N 1291Cancelled Dec 5, 2020 · Registration expired, pending cancellation · Built 1946 · Sanbarcollbuscom IncN7167LGrumman American Avn. AA-5 · S/N AA5-0467Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Built 1973 · Mayer Steven JN2077DJI PHANTOM 3 PROFESSION · S/N P76DCE15012077Cancelled May 4, 2019 · Registration expired, pending cancellation · Huscher Peter EN2086NSchweizer 269D · S/N 0008Cancelled May 17, 2018 · Built 1994 · Native Range IncN6722ACessna 172 · S/N 28822Cancelled Apr 20, 2018 · Registration pending, pending cancellation · Built 1956N144MWWills Michael L VANS RV-4 · S/N 4083Cancelled Apr 19, 2018 · Registration expired, pending cancellation · Lamar William PN569Cooke B-8M · S/N RC-1Cancelled Mar 5, 2018 · Registration expired, pending cancellation · Built 1975 · Cooke Gerald SN53005Ryan Aeronautical PT-22 · S/N 2010Cancelled Nov 20, 2017 · Revoked, canceled · Built 1942 · Swenson Carlos RN3915SCessna 172E · S/N 17251115Cancelled Jun 8, 2017 · Registration expired, pending cancellation · Built 1964 · Thomas Henry AN6079QMooney M20C · S/N 3255Cancelled Sep 12, 2016 · Built 1965 · Jackson Lawrence E JrN912MBNauman Robert L RV-9A · S/N 90112Cancelled Jan 20, 2016 · Built 2004 · Nauman Robert LN6466SCessna 150H · S/N 15067266Cancelled May 20, 2015 · Registration pending, canceled · Built 1967N92165Piper J-3C · S/N 16607Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1946 · Winter PhyllisN142BPMorrison Joseph Q2 · S/N 2609Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1995 · Van Vleet Richard AN23FFFay Fergus C VARIEZE · S/N 327Cancelled Jan 16, 2015 · Built 1979 · Fay Fergus Cruse IVN9646ZLeffler/Macfarlane LM-1 · S/N 1Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1963 · Meyer William CN619AMMakul Anthony C KING COBRA · S/N ABCO KC #002Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Brad RodN4687S N I A S SA 318C ALOUETTE AST · S/N 2234Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1971 · Rotor Aids IncN24KRBeech C-50 · S/N CH-145Cancelled Sep 22, 2014 · Registration expired, pending cancellation · Built 1955 · Mc Afee Lloyd LN657GProgressive Aerodyne SEAREY LSA · S/N 1004Cancelled Aug 6, 2014 · Built 2014 · Coastal Alliance IncN300LRSmith Ronald A MINK · S/N 1Cancelled Nov 7, 2013 · Registration expired, pending cancellation · Built 1983 · Smith Ronald AN3076PHuscher Peter E AIR COMMAND 532 · S/N A/C 532 1-90Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Huscher Peter EN626JDPiper PA-32R-300 · S/N 32R-7680084Cancelled Oct 28, 2013 · Registration expired, pending cancellation · Built 1975 · Strobel Heidi LN68123Coker BENSEN B-8M · S/N C-2Cancelled Oct 23, 2013 · Revoked, canceled · Built 1976 · Coker Gary WN1860QCessna 177RG · S/N 177RG0260Cancelled Sep 27, 2013 · Registration expired, pending cancellation · Built 1972 · West Coast Aircraft Sales IncN2037CAbbott Don SPRINT II · S/N 109Cancelled Sep 25, 2013 · Registration expired, pending cancellation · Built 1989 · Abbott DonN2223EIlli URS THUNDER GULL · S/N 912-1.5Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Built 1990 · Illi UrsN9124SBeech 95-B55 (T42A) · S/N TC-1940Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Built 1976 · Aus Ex IncN71066Piper J3C-65 · S/N 18089Cancelled Sep 17, 2013 · Revoked, pending cancellation · Built 1946 · Williams AlvisN97CLSheen Howard AVINU · S/N 001Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Sheen HowardN304FPCarse Patrick D FP-303 · S/N 3034Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Carse Patrick DN6481PPiper PA-24-250 · S/N 24-1599Cancelled Aug 6, 2013 · Revoked, canceled · Built 1959 · Jeffers Frank FN1344Ryan Aeronautical ST3KR · S/N 2086Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1943 · Flying Heritage IncN73921Bell 47J-2 · S/N 2621Cancelled Jul 23, 2013 · Registration expired, pending cancellation · Built 1963 · Rotor Aids Offshore IncN2686ZBellanca 7ECA · S/N 1229-78Cancelled Jul 18, 2013 · Registration expired, pending cancellation · Luboff Jeff AN299SEMarsh Stephen G GOLDWING · S/N 299Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1983 · Marsh Stephen GN130RMMccarty Robert D AVID FLYER · S/N 130Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Built 1993 · Mccarty Robert DN43467Taylorcraft BC12-D · S/N 7126Cancelled Jun 5, 2013 · Sale reported, canceledN333AUBeech A36TC · S/N EA-198Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Built 1981 · Aurich IncN8628Sud SA 318C ALOUETTE AST · S/N 2175Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1970 · Rotor Aids IncN8269S N I A S SA 318C ALOUETTE AST · S/N 2173Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1970 · Rotor Aids IncN64488S N I A S SA 318C ALOUETTE AST · S/N 2293Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1972 · Rotor Aids IncN64489S N I A S SA 318C ALOUETTE AST · S/N 2306Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1972 · Rotor Aids Inc
Back to Ventura, CA