Skip to content

United California Bank

Earlier aircraft under this name · 30

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

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_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

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_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"

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_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

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.

N82195Piper PA-28RT-201T · S/N 28R-8031109Cancelled Feb 14, 1985 · Administratively canceled · Wes-Tex Aircraft Inc, Lubbock, TX N9964GCessna A188A · S/N 18800764Cancelled Feb 14, 1985 · Administratively canceled · Thedford Aero Inc, Greenville, MS N9973KBell 206L · S/N 45037Cancelled Feb 14, 1985 · Administratively canceled · Petroleum Helicopters Inc, Lafayette, LA N83006Piper PA-28-161 · S/N 28-8116086Cancelled Jul 11, 1984 · Administratively canceled · Nix Belton Toney, Dequincy, LA N8330BPiper PA-28-161 · S/N 28-8116138Cancelled Jul 11, 1984 · Administratively canceled · Venice Flying Service Inc, Venice, FL N99785Ercoupe 415-C · S/N 2408Cancelled Jul 11, 1984 · Administratively canceled · Mullis Leonard L, Porterville, CA N8318TPiper PA-28-181 · S/N 28-8190132Cancelled Jun 15, 1984 · Administratively canceled · Carcot Edward A, Los Altos, CA N82717Piper PA-28-181 · S/N 28-8190286Cancelled Dec 14, 1983 · Administratively canceled · Newman Tom J, Albert Lea, MN N9998PPiper PA-40 · S/N 40-7400002Cancelled Aug 16, 1983 · Administratively canceled · Piper Aircraft Corporation, Lock Haven, PA N9953PPiper PA-36-285 · S/N 36-7560064Cancelled Jun 22, 1983 · Administratively canceled · Heinze Fuller Farm Inc, Midland, OH N99710Engineering & Research ERCOUPE 415-D · S/N 2333Cancelled Jun 22, 1983 · Administratively canceled · Todd Joseph E, Connersville, IN N99663Douglas DC3 · S/N 33467Cancelled May 14, 1983 · Administratively canceled · Martin Kenneth B, Fairbanks, AK N140SFMcmurtrie Donald E JURCA 3/4 SPITFIRE · S/N OK-1Cancelled Apr 23, 1983 · Administratively canceled · Mc Murtrie Donald E, Bartlesville, OK N99475Engineering & Research ERCOUPE 415-C · S/N 2098Cancelled Apr 17, 1982 · Administratively canceled · Cooper Leland R, Boone, NC N9951ACessna 170A · S/N 19311Cancelled Apr 15, 1982 · Administratively canceled · Garris Berle, Clearwater, FL N9956PPiper PA-36-320 · S/N 36-7560067Cancelled Apr 15, 1982 · Administratively canceled · Rose A H, Pierre, SD N9978LGrumman American Avn. AA-1B · S/N AA1B-0278Cancelled Apr 15, 1982 · Administratively canceled · Aircraft Sales Corp, Waukegan, IL N99824Savage DELTA · S/N PP1Cancelled Apr 15, 1982 · Administratively canceled · Savage James M, Hartshorne, OK N9942ECessna 182P · S/N 18264002Cancelled Jan 21, 1982 · Administratively canceled · Stringer C John, Ontario, OR N9946JSchweizer SGS 1-26C · S/N 324Cancelled Jan 21, 1982 · Administratively canceled · Stroub Clyde E, Tehachapi, CA N99755Ercoupe 415-C · S/N 2378Cancelled Jan 21, 1982 · Administratively canceled · Baker Robert J, Downey, CA N9955BCessna 182A · S/N 34355Cancelled Jan 14, 1982 · Administratively canceled · Verner Dave, Sparta, IL N9968ZBeech TC-45H · S/N 51-11537Cancelled Jan 14, 1982 · Administratively canceled · Holmes J J, Tampa, FL N9978PPiper PA-36-285 · S/N 36-7560091Cancelled Jan 14, 1982 · Administratively canceled · Watonga Aero Sprayers Inc, Watonga, OK N9983GCessna A188A · S/N 18800783Cancelled Jan 14, 1982 · Administratively canceled · Jonesboro Flying Service Inc, Jonesboro, AR N99986Pilatus B-4 · S/N 113Cancelled Jan 14, 1982 · Administratively canceled · Brandt Dick W, Yuba City, CA N9968DPiper PA-22-150 · S/N 22-6759Cancelled Jan 1, 1982 · Administratively canceled · Murphy James E, Madison, KS N99569Tatman SPIZ SYNDICATE BA-2B · S/N 1Cancelled Oct 15, 1981 · Administratively canceled · Tatman Steven D, Sheldon, IA N4116VCessna 170 · S/N 18448Cancelled Mar 29, 1980 · Administratively canceled · Sal Reported, Ketchikan, AK N55876Piper PA-34-200 · S/N 34-7350254Cancelled Nov 21, 1977 · San Francisco, CA

Back to United California Bank