# Earlier aircraft under this name: United California Bank

A list on [United California Bank](https://openairdocs.org/faa-owner/UNITED%20CALIFORNIA%20BANK.md).

Cancelled registrations that named this owner when they ended, newest first.

- [N82195](https://openairdocs.org/deregistered/N82195-1985-02-14.md): Piper PA-28RT-201T · S/N 28R-8031109 · Cancelled Feb 14, 1985 · Administratively canceled · Wes-Tex Aircraft Inc, Lubbock, TX
- [N9964G](https://openairdocs.org/deregistered/N9964G-1985-02-14.md): Cessna A188A · S/N 18800764 · Cancelled Feb 14, 1985 · Administratively canceled · Thedford Aero Inc, Greenville, MS
- [N9973K](https://openairdocs.org/deregistered/N9973K-1985-02-14.md): Bell 206L · S/N 45037 · Cancelled Feb 14, 1985 · Administratively canceled · Petroleum Helicopters Inc, Lafayette, LA
- [N83006](https://openairdocs.org/deregistered/N83006-1984-07-11.md): Piper PA-28-161 · S/N 28-8116086 · Cancelled Jul 11, 1984 · Administratively canceled · Nix Belton Toney, Dequincy, LA
- [N8330B](https://openairdocs.org/deregistered/N8330B-1984-07-11.md): Piper PA-28-161 · S/N 28-8116138 · Cancelled Jul 11, 1984 · Administratively canceled · Venice Flying Service Inc, Venice, FL
- [N99785](https://openairdocs.org/deregistered/N99785-1984-07-11.md): Ercoupe 415-C · S/N 2408 · Cancelled Jul 11, 1984 · Administratively canceled · Mullis Leonard L, Porterville, CA
- [N8318T](https://openairdocs.org/deregistered/N8318T-1984-06-15.md): Piper PA-28-181 · S/N 28-8190132 · Cancelled Jun 15, 1984 · Administratively canceled · Carcot Edward A, Los Altos, CA
- [N82717](https://openairdocs.org/deregistered/N82717-1983-12-14.md): Piper PA-28-181 · S/N 28-8190286 · Cancelled Dec 14, 1983 · Administratively canceled · Newman Tom J, Albert Lea, MN
- [N9998P](https://openairdocs.org/deregistered/N9998P-1983-08-16.md): Piper PA-40 · S/N 40-7400002 · Cancelled Aug 16, 1983 · Administratively canceled · Piper Aircraft Corporation, Lock Haven, PA
- [N9953P](https://openairdocs.org/deregistered/N9953P-1983-06-22.md): Piper PA-36-285 · S/N 36-7560064 · Cancelled Jun 22, 1983 · Administratively canceled · Heinze Fuller Farm Inc, Midland, OH
- [N99710](https://openairdocs.org/deregistered/N99710-1983-06-22.md): Engineering & Research ERCOUPE 415-D · S/N 2333 · Cancelled Jun 22, 1983 · Administratively canceled · Todd Joseph E, Connersville, IN
- [N99663](https://openairdocs.org/deregistered/N99663-1983-05-14.md): Douglas DC3 · S/N 33467 · Cancelled May 14, 1983 · Administratively canceled · Martin Kenneth B, Fairbanks, AK
- [N140SF](https://openairdocs.org/deregistered/N140SF-1983-04-23.md): Mcmurtrie Donald E JURCA 3/4 SPITFIRE · S/N OK-1 · Cancelled Apr 23, 1983 · Administratively canceled · Mc Murtrie Donald E, Bartlesville, OK
- [N99475](https://openairdocs.org/deregistered/N99475-1982-04-17.md): Engineering & Research ERCOUPE 415-C · S/N 2098 · Cancelled Apr 17, 1982 · Administratively canceled · Cooper Leland R, Boone, NC
- [N9951A](https://openairdocs.org/deregistered/N9951A-1982-04-15.md): Cessna 170A · S/N 19311 · Cancelled Apr 15, 1982 · Administratively canceled · Garris Berle, Clearwater, FL
- [N9956P](https://openairdocs.org/deregistered/N9956P-1982-04-15.md): Piper PA-36-320 · S/N 36-7560067 · Cancelled Apr 15, 1982 · Administratively canceled · Rose A H, Pierre, SD
- [N9978L](https://openairdocs.org/deregistered/N9978L-1982-04-15.md): Grumman American Avn. AA-1B · S/N AA1B-0278 · Cancelled Apr 15, 1982 · Administratively canceled · Aircraft Sales Corp, Waukegan, IL
- [N99824](https://openairdocs.org/deregistered/N99824-1982-04-15.md): Savage DELTA · S/N PP1 · Cancelled Apr 15, 1982 · Administratively canceled · Savage James M, Hartshorne, OK
- [N9942E](https://openairdocs.org/deregistered/N9942E-1982-01-21.md): Cessna 182P · S/N 18264002 · Cancelled Jan 21, 1982 · Administratively canceled · Stringer C John, Ontario, OR
- [N9946J](https://openairdocs.org/deregistered/N9946J-1982-01-21.md): Schweizer SGS 1-26C · S/N 324 · Cancelled Jan 21, 1982 · Administratively canceled · Stroub Clyde E, Tehachapi, CA
- [N99755](https://openairdocs.org/deregistered/N99755-1982-01-21.md): Ercoupe 415-C · S/N 2378 · Cancelled Jan 21, 1982 · Administratively canceled · Baker Robert J, Downey, CA
- [N9955B](https://openairdocs.org/deregistered/N9955B-1982-01-14.md): Cessna 182A · S/N 34355 · Cancelled Jan 14, 1982 · Administratively canceled · Verner Dave, Sparta, IL
- [N9968Z](https://openairdocs.org/deregistered/N9968Z-1982-01-14.md): Beech TC-45H · S/N 51-11537 · Cancelled Jan 14, 1982 · Administratively canceled · Holmes J J, Tampa, FL
- [N9978P](https://openairdocs.org/deregistered/N9978P-1982-01-14.md): Piper PA-36-285 · S/N 36-7560091 · Cancelled Jan 14, 1982 · Administratively canceled · Watonga Aero Sprayers Inc, Watonga, OK
- [N9983G](https://openairdocs.org/deregistered/N9983G-1982-01-14.md): Cessna A188A · S/N 18800783 · Cancelled Jan 14, 1982 · Administratively canceled · Jonesboro Flying Service Inc, Jonesboro, AR
- [N99986](https://openairdocs.org/deregistered/N99986-1982-01-14.md): Pilatus B-4 · S/N 113 · Cancelled Jan 14, 1982 · Administratively canceled · Brandt Dick W, Yuba City, CA
- [N9968D](https://openairdocs.org/deregistered/N9968D-1982-01-01.md): Piper PA-22-150 · S/N 22-6759 · Cancelled Jan 1, 1982 · Administratively canceled · Murphy James E, Madison, KS
- [N99569](https://openairdocs.org/deregistered/N99569-1981-10-15.md): Tatman SPIZ SYNDICATE BA-2B · S/N 1 · Cancelled Oct 15, 1981 · Administratively canceled · Tatman Steven D, Sheldon, IA
- [N4116V](https://openairdocs.org/deregistered/N4116V-1980-03-29.md): Cessna 170 · S/N 18448 · Cancelled Mar 29, 1980 · Administratively canceled · Sal Reported, Ketchikan, AK
- [N55876](https://openairdocs.org/deregistered/N55876-1977-11-21.md): Piper PA-34-200 · S/N 34-7350254 · Cancelled Nov 21, 1977 · San Francisco, CA

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```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_name = 'UNITED CALIFORNIA BANK' OR list_contains(d.other_registrant_names, 'UNITED CALIFORNIA BANK')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-owner/UNITED%20CALIFORNIA%20BANK/earlier

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.