# Cancelled registrations: Canyon Country, CA

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

Cancelled aircraft registrations in Canyon Country, CA.

- [N591N](https://openairdocs.org/deregistered/N591N-2018-01-25.md): Pdps Pzl-Bielsko SZD-59 · S/N B-2157 · Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1994 · Hanson Paul C
- [N532A](https://openairdocs.org/deregistered/N532A-2018-01-17.md): Bellanca 14-19 · S/N 2085 · Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1951 · Bray W Randall DBA
- [N33AJ](https://openairdocs.org/deregistered/N33AJ-2015-05-19.md): Aleshire T Stewart STEEN SKYBOLT · S/N 999 · Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1982 · Joy William
- [N6984W](https://openairdocs.org/deregistered/N6984W-2015-05-04.md): Piper PA-28-140 · S/N 28-21182 · Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1965 · Garrett Tracy III
- [N1202Y](https://openairdocs.org/deregistered/N1202Y-2013-07-31.md): Cessna 150B · S/N 15059602 · Cancelled Jul 31, 2013 · Registration expired, pending cancellation · Built 1962 · Cappiello Robert M
- [N118PC](https://openairdocs.org/deregistered/N118PC-2013-06-12.md): Cherry Paul J HP-16 · S/N 11 · Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Built 1986 · Cherry Paul J
- [N9084D](https://openairdocs.org/deregistered/N9084D-2013-04-18.md): Balloon Works FIREFLY 8 · S/N F8-376 · Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Davey Dean DBA
- [N5090P](https://openairdocs.org/deregistered/N5090P-2012-12-10.md): Piper PA-24-180 · S/N 24-98 · Cancelled Dec 10, 2012 · Sale reported, canceled · Built 1958
- [N33043](https://openairdocs.org/deregistered/N33043-2012-10-02.md): Piper PA-28-140 · S/N 28-7525143 · Cancelled Oct 2, 2012 · Registration expired, pending cancellation · Built 1975 · Roth Stanley H
- [N66081](https://openairdocs.org/deregistered/N66081-2012-04-25.md): Cessna 150M · S/N 15075821 · Cancelled Apr 25, 2012 · Exported to Brazil · Built 1974 · Lima Roberval B
- [N5560V](https://openairdocs.org/deregistered/N5560V-2011-07-20.md): Cessna 310B · S/N 35674 · Cancelled Jul 20, 2011 · Expired dealer · Built 1958 · Morgan Fred H DBA
- [N539CH](https://openairdocs.org/deregistered/N539CH-2010-11-16.md): Cirrus Design SR22 · S/N 1494 · Cancelled Nov 16, 2010 · Exported to Canada · Built 2005 · Hull Charles W
- [N15192](https://openairdocs.org/deregistered/N15192-2004-02-10.md): Piper PA-28R-200 · S/N 28R-7335034 · Cancelled Feb 10, 2004 · Built 1972 · Ramsey Charles L Jr
- [N222EX](https://openairdocs.org/deregistered/N222EX-2000-07-22.md): Hilyard Roger C DRAGONFLY · S/N 098 · Cancelled Jul 22, 2000 · Triennial form not returned · Hilyard Rodger C
- [N320TM](https://openairdocs.org/deregistered/N320TM-1995-08-23.md): Cessna 320E · S/N 320E0063 · Cancelled Aug 23, 1995 · Triennial form not returned · Smith William F
- [N9462Y](https://openairdocs.org/deregistered/N9462Y-1991-04-02.md): Beech B95A · S/N TD456 · Cancelled Apr 2, 1991 · Triennial form not returned · Starr Charles M

## 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 = 'CANYON COUNTRY'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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