OpenAirDocs.org
Oxnard, CA

Cancelled registrations · 137

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

N16TNNewell Thomas J RV6A · S/N 22305Cancelled Sep 29, 2005 · Built 1998 · Crowe Richard EN404PCCantrell Donald T LANCAIR IV-P · S/N LIV-107Cancelled Apr 23, 2004 · Built 1997 · Cantrell Donald TN5736NBell Helicopter Textron 206L-1 · S/N 45418Cancelled Feb 25, 2004 · Exported to Canada · Built 1980 · Aspen Helicopters IncN89RHHernandez Rafael LANCAIR 320 · S/N TBDCancelled Feb 13, 2004 · Triennial form not returned · Hernandez RafaelN999AHBell 206L-3 · S/N 51046Cancelled Feb 13, 2004 · Exported to Canada · Built 1982 · Aspen Helicopters IncN91RTTrickel R A TR-4 · S/N 401Cancelled Sep 29, 2003 · Exported to China · Built 1994 · Trickel R AN5293NCessna 182Q · S/N 18267625Cancelled Aug 13, 2003 · Triennial form not returned · Built 1980 · Kenefake Frank LN90214Bell 206B · S/N 1662Cancelled Apr 2, 2001 · Triennial form not returned · Aspen Ag HelicoptersN52LTCessna 525 · S/N 525-0322Cancelled Mar 23, 2001 · Exported to Luxembourg · Blt EnterprisesN325GPPrice Gordon ULTIMATE 10-300S · S/N 300-001Cancelled Jul 15, 1999 · Triennial form not returned · Osterud JoannN1077NBell Helicopter Textron 206L-1 · S/N 45349Cancelled Mar 31, 1997 · Exported to Canada · Aspen Helicopters IncN3116CPartenavia C.A. AP68TP SERIES 300 · S/N 8007Cancelled Nov 19, 1996 · Triennial form not returned · Partenavia VN584MXVengroski George A MX SUPER · S/N 1028Cancelled Apr 2, 1996 · Triennial form not returned · Vengroski George AN470CHBell 47G-3B-2 · S/N 6781Cancelled Jul 8, 1994 · Exported to Canada · Northern Mountain Heli Calif CorpN9BKBellanca 17-30A · S/N 7330587Cancelled Apr 2, 1992 · Second triennial mailing, no response · Kelsey Robert RN7915SBell 47G-5 · S/N 7849Cancelled May 15, 1984 · Exported to Zimbabwe · Mid Continent Of California IncN1370XBell 47G-5 · S/N 7837Cancelled Feb 18, 1984 · Administratively canceled · Condor Helicopters & Aviation IncN10163S N I A S SA 318C ALOUETTE AST · S/N 2274Cancelled Nov 23, 1983 · Administratively canceled · Rotor Aids IncN8169MCessna 310I · S/N 310I0169Cancelled May 21, 1983 · Administratively canceled · Waltom InvestmentsN5067LBellanca 7GCBC · S/N 119080Cancelled May 9, 1983 · Tegland Ronald KN29SMBeech B23 · S/N M-1278Cancelled Apr 2, 1981 · Point Mugu Aero ClubN7232GCessna 172K · S/N 17258932Cancelled Sep 4, 1980 · Phillips John F / Bourassa James EN6231ACessna T210 · S/N 210-63513Cancelled Aug 13, 1980 · Exported to Mexico · Valenti AviationN5402VCessna 172RG · S/N 172RG0520Cancelled Aug 1, 1980 · Exported to Switzerland · Valenti AviationN3448Great Lakes HOMEBUILT · S/N 702M-307BCancelled Mar 25, 1980 · Sale reported · Built 1971N668DBeech C35 · S/N D-2939Cancelled Aug 27, 1979 · Sale reported · Built 1951N4980DCessna 172N · S/N 17272415Cancelled Aug 16, 1979 · Exported to Canada · Valenti AviationN6283GCessna 150K · S/N 15071783Cancelled Jan 30, 1979 · Aero Flite Of Oxnard IncN362TCBeech 35 · S/N D-1171Cancelled Jun 4, 1977 · Crow Border LN4885VConsolidated Vultee L-13A · S/N 103Cancelled May 6, 1977 · Exported to Mexico · Caywood John LN6890JPiper PA-28-140 · S/N 28-7625252Cancelled Aug 23, 1976 · Exported to Australia · Misevic Albert JN219GGallagher RUSSELL-VANCRAFT · S/N 1Cancelled May 17, 1976 · Built 1970 · Gallagher Warren LN35222Cessna 177B · S/N 17702274Cancelled Aug 19, 1975 · Exported to Switzerland · Built 1975 · Valenti AviationN8392MCessna A150K · S/N A15000092Cancelled May 21, 1974 · Built 1969 · Higgins William BN6246LAmerican AA-1B · S/N AA-1B-0046Cancelled Apr 23, 1974 · Echarren Alfonso AN9494MCessna 210K · S/N 21059394Cancelled Jul 5, 1973 · Exported to Australia · Murray AviationN9477LAmerican AA-1A · S/N AA1A-0277Cancelled Jun 28, 1973 · Cerino Livie Aviation Assoc Inc DBA Executive AirN6140NBeech 19A · S/N MB-328Cancelled Jan 2, 1972 · Aviation Services IncN2310FCessna 210D · S/N 21058510Cancelled Dec 14, 1971 · Los Pilotos/Petit David/Graves Jack/Thurman JackN9460TCessna 210 · S/N 57260Cancelled Aug 24, 1971 · Reardon James AN9799CTaylor CG11 · S/N 1Cancelled Dec 7, 1970 · Registration revoked · Built 1961 · Products Design IncN50527Cessna 150J · S/N 15069373Cancelled Jan 6, 1969 · Wright Samuel Bolling IIIN67343Boeing B75N1 · S/N 75-7292Cancelled Nov 16, 1967 · T F Mcloughlin Dusters IncN89764Cessna 140 · S/N 8813Cancelled May 22, 1965 · Oxnard Flying SchoolN45122Naval Aircraft Factory N3N-3 · S/N 4400Cancelled May 20, 1965 · Murray Philip JN62641Consolidated Vultee BT-13A · S/N 5051Cancelled May 20, 1965 · James E McleanN63454Boeing A75N1 · S/N 75-2965Cancelled May 20, 1965 · T F Mcloughlin Dusters IncN3327GNorth American SNJ-5 · S/N 90601Cancelled Sep 5, 1963 · Altair AviationN67432Cessna T-50 · S/N 5356Cancelled Dec 4, 1961 · Coleman FredN2402CCessna 180 · S/N 30702Cancelled Jul 31, 1961 · Exported to Canada · Mcgrath Thomas F
Back to Oxnard, CA