Oceanside, CA

Cancelled registrations · 68

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

N65144Dudek SCORPION TOO · S/N 4072Cancelled Apr 26, 1991 · Triennial form not returned · Dudek JosephN280CBBlanco Corell ULTRALIGHT · S/N 3457745Cancelled Apr 8, 1991 · Triennial form not returned · Corell Blanco FN9698KStinson 108-2 · S/N 108-2698Cancelled Apr 1, 1980 · Yoakam Rex AN80012Aerotek PITTS S-2A · S/N 2022Cancelled Dec 18, 1978 · Exported to Australia · Philip O KraftN67TDDesalvo Timothy F B8M · S/N T.F.D.I-72Cancelled Apr 23, 1974 · Desalvo Timothy FrederickN4004KNorth American NAVION · S/N NAV-4-1004Cancelled May 21, 1973 · Exported to Canada · Willford Donald RN6381Bensen B-8M · S/N 319774Cancelled Mar 31, 1971 · Jankowski Casimir SN93830Ercoupe 415-C · S/N 1153Cancelled Jan 4, 1971 · Abercrombie Jerry GN2007LLake LA-4 · S/N 340Cancelled Sep 29, 1970 · Exported to Canada · Aero Pacific IncN2743KLuscombe 8E · S/N 5470Cancelled Sep 2, 1970 · Richeson Bud C Richard A Scheese And Charles CasteN7707DPiper PA-22 · S/N 22-5379Cancelled Feb 23, 1966 · Built 1957 · C B M Flight Service IncN96690Taylorcraft BC12-D · S/N 8990Cancelled Apr 27, 1961 · Cuyle Robert EN63148Douglas A-20G · S/N 21864Cancelled Feb 7, 1955 · Young Paul BN98215Piper J3C-65 · S/N 18378Cancelled May 7, 1951 · Oceanside Flying ServiceN54616Fairchild M-62A · S/N T-411168Cancelled Jul 10, 1950 · Stephens Richard EN96642Taylorcraft BC12-D · S/N 8942Cancelled Jun 2, 1949 · Nill Kenneth AN87602Stinson 108 · S/N 108-3Cancelled Apr 12, 1949 · Nill Kenneth AN12209Frank Chavez PRIMARY GLIDER · S/N 1Cancelled Mar 15, 1935 · Frank R Chavez
Back to Oceanside, CA