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.

N3180XHispano Aviacion HA-200 SAETA · S/N 20/94Cancelled Jul 28, 2009 · Built 1968 · Hensley Bradley SN10003Texas Helicopter OH-13H/M74A · S/N 79-031Cancelled Nov 19, 2008 · Exported to Australia · Built 1979 · R & S Crop Dusters IncN3082PPiper PA-23 · S/N 23-1002Cancelled Aug 8, 2008 · Triennial form not returned · Built 1957 · Martin Wind Enterprises IncN805GChristensen Grant Eric CORBIN JUNIOR ACE · S/N 901Cancelled Apr 13, 2005 · Triennial form not returned · Christensen Grant EricN281FLockheed 188C · S/N 1079Cancelled Feb 7, 2005 · Second triennial mailing, no response · Built 1959 · Renown Aviation IncN444EJJoiner Ernest Lee JR RUTAN VARIEZE · S/N 127Cancelled Dec 17, 2002 · Built 1981 · Joiner ErnestN34168Cessna 177B · S/N 17701686Cancelled Feb 6, 2002 · Triennial form not returned · Built 1971 · Voris Stanley D TrusteeN60DFMendonca Jeremias DRAGONFLY MARK III · S/N H-5148Cancelled Dec 8, 1999 · Mendonca Jeremias DN115BBell 47G-2 · S/N 35Cancelled Jul 8, 1999 · Exported to Mexico · English Air Service IncN4149BBellanca 17-30A · S/N 7530778Cancelled Aug 25, 1995 · Triennial form not returned · Hawkins Roger VN423AFCrume Stephen/Joyce AVID FLYER · S/N 117Cancelled Oct 18, 1994 · Triennial form not returned · Crume Stephen EN6331MCessna 152 · S/N 15284675Cancelled Apr 25, 1994 · Triennial form not returned · Hill Troy LN77487Cessna 120 · S/N 11931Cancelled Mar 7, 1994 · Triennial form not returned · Trebon Paul SN348KCurtiss-Robertson ROBIN C-2 · S/N 475Cancelled Aug 30, 1991 · Exported to United Kingdom · Peck GlenndbaN73342Cessna 172M · S/N 17267388Cancelled Jul 17, 1984 · Renown Aviation IncN22226Cessna T210L · S/N 21059727Cancelled May 13, 1981 · Exported to Mexico · Built 1972 · Owen T Rice & Son Inc Et AlN31055Mareik B-8M · S/N 82042Cancelled Oct 31, 1980 · Mareik LotharN28676Piper PA-28-181 · S/N 28-7990423Cancelled Aug 20, 1980 · Exported to New Zealand · Piper Iarcraft CorpN8225JPiper AEROSTAR 600 · S/N 60-0627-7961199Cancelled Apr 27, 1979 · Exported to Australia · Built 1979 · Piper Aircraft CorporationN9820QPiper AEROSTAR 601 · S/N 61-0463-124Cancelled Mar 22, 1979 · Exported to Argentina · Ted Smith Aerostar Sales IncN8092JPiper AEROSTAR 601P · S/N 61P-0578-7963253Cancelled Mar 20, 1979 · Exported to Australia · Piper Aircraft CorpN8080JPiper AEROSTAR 600 · S/N 60-0567-7961185Cancelled Feb 23, 1979 · Exported to Australia · Piper Aircraft CorpN8097JPiper AEROSTAR 600 · S/N 60-0589-7961190Cancelled Jan 24, 1979 · Exported to Australia · Piper Aircraft CorpN8069JPiper AEROSTAR 601P · S/N 61P-0552-237Cancelled Nov 2, 1978 · Exported to Australia · Piper Aircraft CoN9817QSmith AEROSTAR 601 · S/N 61-0476-126Cancelled Apr 25, 1978 · Exported to Australia · Ted Smith Aerostar Sales IncN8020JSmith AEROSTAR 600 · S/N 60-0486-157Cancelled Apr 6, 1978 · Ted Smith Aerostar Sales IncN8003JSmith AEROSTAR 601P · S/N 61P-0489-199Cancelled Apr 2, 1978 · Exported to France · Ted Smith Aerostar Sales IncN8014JSmith AEROSTAR 601P · S/N 61P-0455-176Cancelled Jan 10, 1978 · Exported to Argentina · Ted Smith Aerostar Sales IncN9783QSmith AEROSTAR 601P · S/N 61P-0439-165Cancelled Dec 20, 1977 · Exported to Argentina · Ted Smith Aerostar Sales IncN9794QSmith AEROSTAR 600A · S/N 60-429-145Cancelled Dec 20, 1977 · Exported to Argentina · Ted Smith Aerostar Sales IncN9806QSmith AEROSTAR 601P · S/N 61P-0447-170Cancelled Dec 20, 1977 · Exported to Argentina · Ted Smith Aerostar Sales IncN9822QSmith AEROSTAR 601P · S/N 61P-0465-183Cancelled Dec 20, 1977 · Exported to Denmark · Built 1977 · Ted Smith Aerostar Sales IncN9811QSmith AEROSTAR 601P · S/N 61P-0452-174Cancelled Dec 8, 1977 · Exported to Australia · Ted Smith Aerostar Sales IncN9782QSmith AEROSTAR 601P · S/N 60-0410142Cancelled Oct 4, 1977 · Exported to Australia · Ted Smith Aerostar Sales IncN9778QSmith AEROSTAR 600 · S/N 60-0406141Cancelled Aug 19, 1977 · Exported to Guatemala · Ted Smith Aerostar Sales IncN9773QSmith AEROSTAR 600 · S/N 60-0423-144Cancelled Jul 11, 1977 · Exported to Argentina · Ted Smith Aerostar Sales IncN9758QSmith AEROSTAR 601P · S/N 61P-0378-123Cancelled Apr 8, 1977 · Exported to New Zealand · Built 1976 · Ted Smith Aerostar Sales IncN9766QSmith AEROSTAR 600 · S/N 60-0390-138Cancelled Apr 4, 1977 · Exported to Australia · Built 1977 · Ted Smith Aerostar Sales IncN9769QSmith AEROSTAR 600 · S/N 60-0396-139Cancelled Mar 11, 1977 · Exported to Argentina · Built 1977 · Ted Smith Aerostar Sales IncN9757QSmith AEROSTAR 600A · S/N 60-0375-133Cancelled Feb 8, 1977 · Exported to New Zealand · Built 1977 · Ted Smith Aerostar Sales IncN9511QSmith AEROSTAR 600 · S/N 60-0345-125Cancelled Oct 19, 1976 · Exported to Australia · Ted Smith Aerostar SalesN90431Smith AEROSTAR 601P · S/N 61P-0239-037Cancelled May 28, 1976 · Exported to New Zealand · Ted Smith Aerostar CorpN90495Smith AEROSTAR 600 · S/N 60-0284-107Cancelled Mar 25, 1976 · Exported to Australia · Ted Smith Aerostar CorpN90402Smith AEROSTAR 601 · S/N 61-0229-097Cancelled Aug 20, 1975 · Exported to Australia · Ted Smith Aerostar CorpN90346Smith AEROSTAR 600 · S/N 60-0210-092Cancelled May 21, 1975 · Exported to New Zealand · Ted Smith Aerostar CorpN7515SPiper AEROSTAR 600 · S/N 600184081Cancelled Nov 22, 1974 · Exported to New Zealand · Ted R Smith And Associates IncN6805ZPiper PA-25-235 · S/N 25-2530Cancelled Jun 27, 1973 · R & S Crop DustersN7108FCessna 150F · S/N 15063708Cancelled Feb 25, 1972 · Santa Maira Cloud NinersN63273Consolidated Vultee BT-13B (SNV-2) · S/N 79-459Cancelled Mar 29, 1971 · University Of Southern Californiacollege Of AeroN63279Consolidated Vultee BT-13B (SNV-2) · S/N 79-1179Cancelled Mar 29, 1971 · University Of Southern California
Back to Santa Maria, CA