# Cancelled registrations: Santa Ynez, CA

A list on [Santa Ynez, CA](https://openairdocs.org/faa-place/CA/Santa%20Ynez.md).

Cancelled aircraft registrations in Santa Ynez, CA.

- [N352RS](https://openairdocs.org/deregistered/N352RS-2021-04-03.md): Smith Roger A N3 PUP · S/N MDAF-6 · Cancelled Apr 3, 2021 · Registration expired, pending cancellation · Built 1999 · Smith Roger A
- [N31911](https://openairdocs.org/deregistered/N31911-2019-05-24.md): Ryan W Bailey & Allen Maris LOGO 800 · S/N 61613 · Cancelled May 24, 2019 · First renewal notice · Skypark Consulting Inc
- [N737QQ](https://openairdocs.org/deregistered/N737QQ-2018-08-10.md): Cessna 172N · S/N 17269595 · Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Built 1977 · Sunwest Aviation Inc
- [N90621](https://openairdocs.org/deregistered/N90621-2018-06-01.md): Let BLANIK L-13 · S/N 025617 · Cancelled Jun 1, 2018 · Sale reported, canceled · Built 1973
- [N28VS](https://openairdocs.org/deregistered/N28VS-2017-06-19.md): Snow Van E SNOW ROCKET F1 · S/N 001 · Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Built 2008 · Snow Van E
- [N735KV](https://openairdocs.org/deregistered/N735KV-2015-12-18.md): Cessna 182Q · S/N 18265493 · Cancelled Dec 18, 2015 · First renewal notice · Built 1977 · Krauch William Karl Trustee
- [N92SF](https://openairdocs.org/deregistered/N92SF-2015-05-07.md): Seward Joseph G ROTORWAY EXEC 90 · S/N 5066 · Cancelled May 7, 2015 · Registration expired, pending cancellation · Built 1992 · Seward Joseph G
- [N3823N](https://openairdocs.org/deregistered/N3823N-2013-08-13.md): Beech 35 · S/N D-1055 · Cancelled Aug 13, 2013 · Registration expired, pending cancellation · Built 1947 · Moore Edgar W
- [N9835B](https://openairdocs.org/deregistered/N9835B-2013-05-30.md): Bellanca 14-19 · S/N 4087 · Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1958 · Pool John S
- [N80529](https://openairdocs.org/deregistered/N80529-2013-02-27.md): Globe GC-1B · S/N 32 · Cancelled Feb 27, 2013 · Sale reported, canceled
- [N5203B](https://openairdocs.org/deregistered/N5203B-2012-12-11.md): Mooney M20 · S/N 1066 · Cancelled Dec 11, 2012 · Sale reported, canceled · Built 1956
- [N32901](https://openairdocs.org/deregistered/N32901-2012-05-24.md): Piper PA-28-140 · S/N 28-7525127 · Cancelled May 24, 2012 · Registration pending, canceled · Built 1974
- [N6931M](https://openairdocs.org/deregistered/N6931M-2010-09-15.md): Cessna 182P · S/N 18263893 · Cancelled Sep 15, 2010 · Exported to Canada · Built 1975 · Davidge Corporation
- [N4791C](https://openairdocs.org/deregistered/N4791C-2006-04-04.md): Cessna T210N · S/N 21063627 · Cancelled Apr 4, 2006 · Triennial form not returned · Built 1979 · Representations LLC
- [N5006R](https://openairdocs.org/deregistered/N5006R-2000-10-05.md): Bell 206B · S/N 2532 · Cancelled Oct 5, 2000 · Triennial form not returned · Asta Cy L
- [N8933Z](https://openairdocs.org/deregistered/N8933Z-1999-03-15.md): Cessna 310G · S/N 310G-0033 · Cancelled Mar 15, 1999 · Second triennial mailing, no response · Kunkle James K
- [N6BR](https://openairdocs.org/deregistered/N6BR-1999-03-12.md): Let BLANIK L-13 · S/N 175008 · Cancelled Mar 12, 1999 · Triennial form not returned · Gordon Gary
- [N111DW](https://openairdocs.org/deregistered/N111DW-1997-10-25.md): Ercoupe 415-C · S/N 1591 · Cancelled Oct 25, 1997 · Triennial form not returned · Kelsey Leonard
- [N3310H](https://openairdocs.org/deregistered/N3310H-1997-10-25.md): Engineering & Research 415-CD · S/N 3935 · Cancelled Oct 25, 1997 · Triennial form not returned · Kelsey Leonard C
- [N349CM](https://openairdocs.org/deregistered/N349CM-1994-11-22.md): Maler Carl J MALER-CHINOOK · S/N 10101 · Cancelled Nov 22, 1994 · Triennial form not returned · Maler Carl J
- [N28RK](https://openairdocs.org/deregistered/N28RK-1993-01-27.md): Cessna T210L · S/N 21060348 · Cancelled Jan 27, 1993 · Exported to Germany · Sst Commuter
- [N17HA](https://openairdocs.org/deregistered/N17HA-1978-03-29.md): Smith AEROSTAR 600 · S/N 60-0142-062 · Cancelled Mar 29, 1978 · Exported to Canada · Valley Aerostar Corp
- [N3026X](https://openairdocs.org/deregistered/N3026X-1975-10-06-15064426.md): Cessna 150F · S/N 15064426 · Cancelled Oct 6, 1975 · Lansing Donald E
- [N3026X](https://openairdocs.org/deregistered/N3026X-1975-10-06-15065526.md): Cessna 150F · S/N 15065526 · Cancelled Oct 6, 1975 · Lansing Donald E
- [N8442N](https://openairdocs.org/deregistered/N8442N-1974-11-06.md): Beech 95-B55 · S/N TC-1101 · Cancelled Nov 6, 1974 · Westerly Stud
- [N77074](https://openairdocs.org/deregistered/N77074-1974-04-24.md): Cessna 140 · S/N 11528 · Cancelled Apr 24, 1974 · Bruhn Robert W
- [N7953M](https://openairdocs.org/deregistered/N7953M-1973-06-25.md): Beech 35-C33A · S/N CE-83 · Cancelled Jun 25, 1973 · Westerly Stud
- [N3732M](https://openairdocs.org/deregistered/N3732M-1971-01-04.md): Piper PA-12 · S/N 12-2672 · Cancelled Jan 4, 1971 · Maler Carl J

## 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_state = 'CA' AND d.registrant_city = 'SANTA YNEZ'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-place/CA/Santa%20Ynez/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.
