Santa Maria, CA

Cancelled registrations · 125

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 = 'SANTA MARIA'
  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.

N2418KLuscombe 8E · S/N 5145Cancelled Dec 4, 1970 · Bruce W CN30314Piper J5A · S/N 5-171Cancelled Aug 13, 1970 · Built 1940 · R & S Crop DustersN4665MPiper PA-11 · S/N 11-174Cancelled Aug 13, 1970 · R & S Crop DustersN1631APiper PA-18A · S/N 18-1274Cancelled Jul 27, 1970 · R & S Crop DustersN6061ZPiper PA-25 · S/N 25-70Cancelled Jul 9, 1970 · Wayne E WarnerN6864CBeech AT-11 · S/N 41-9478Cancelled Jul 9, 1970 · Warner Wayne EN5097ZPiper PA-22-108 · S/N 22-8733Cancelled Mar 22, 1965 · Wayne E WarnerN77497Cessna 120 · S/N 11941Cancelled Mar 16, 1956 · Built 1946 · Santa Maria Fly AssociationN80767Globe GC-1A · S/N 170Cancelled Oct 25, 1955 · Built 1946 · Wilkie Melville DN1550NPiper J3C-65 · S/N 23082Cancelled Feb 23, 1955 · Exported to Mexico · Warner Wayne EN53056Fairchild M-62A · S/N T42-3799Cancelled May 17, 1954 · University Of Southern California College Of AstroN14314Fairchild 24 C8C · S/N 2619Cancelled Mar 5, 1952 · Built 1934 · Ringaman H LN48567Boeing D75N1 · S/N 75-1611Cancelled Nov 6, 1951 · Exported to Peru · University Of Southern California College Of AeronN48571Boeing D75N1 · S/N 75-3848Cancelled Nov 6, 1951 · Exported to Peru · University Of Southern California College Of AeronN48798Boeing A75N1 · S/N 75-4857Cancelled Nov 6, 1951 · Exported to Peru · University Of Southern CaliforniaN48902Fairchild M-62A · S/N 8043-AECancelled Apr 17, 1951 · The University Of Southern California CollegeN48578Boeing D75N1 · S/N 75-3831Cancelled Oct 4, 1950 · Exported to Venezuela · University Of Southern California College Of AeronN53042Boeing A75N1 · S/N 75-2796Cancelled Oct 4, 1950 · Exported to Venezuela · Built 1945 · University Of Southern CaliforniaN53088Boeing D75N1 · S/N 75-3889Cancelled Feb 7, 1947 · Built 1945 · Hancock College Of AeronauticsN33422Piper J5A · S/N 5-511Cancelled Jan 2, 1942 · Condor ClubN703EWaco GXE · S/N 1945Cancelled Apr 18, 1935 · Wayne L LawerenceN995YKreutzer K-5 · S/N 114Cancelled Sep 13, 1933 · Santa Maria Airlines IncN12280Fletcher-Sartain AERO SPORT · S/N S-1Cancelled Feb 3, 1933 · Fletcher Sartain CoN12233Hancock FDN Of College Aero HANCOCK CADET · S/N 2Cancelled Jan 10, 1933 · Hancock Foundation College Of AeronautiesN839HGreat Lakes 2T-1A · S/N CL-18Cancelled Feb 15, 1932 · Hancock Foundation College Of Aeronautics
Back to Santa Maria, CA