# Cancelled registrations: La Canada, CA

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

Cancelled aircraft registrations in La Canada, CA.

- [N67291](https://openairdocs.org/deregistered/N67291-2017-02-04.md): Beech AT-11 · S/N 921 · Cancelled Feb 4, 2017 · Revoked, canceled · Varian Spencer B
- [N67885](https://openairdocs.org/deregistered/N67885-2014-11-13.md): Cessna 152 · S/N 15282076 · Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1978 · Hauptman Joseph A
- [N3236S](https://openairdocs.org/deregistered/N3236S-2014-09-29.md): Cessna 182G · S/N 18255736 · Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1964 · Gpl Industries Inc
- [N27GA](https://openairdocs.org/deregistered/N27GA-2013-07-08.md): Aero Commander 680-F · S/N 680F-1212-111 · Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1962 · Helizon Roger S
- [N5108A](https://openairdocs.org/deregistered/N5108A-2013-07-01.md): Cessna 172 · S/N 28108 · Cancelled Jul 1, 2013 · Exported to New Zealand · Built 1955 · Cowley Ann
- [N38SH](https://openairdocs.org/deregistered/N38SH-2013-06-06.md): Schempp-Hirth STANDARD AUSTRIA S · S/N 38 · Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Built 1963 · Byard George F
- [N4444G](https://openairdocs.org/deregistered/N4444G-2012-07-09.md): Gilland-Briegleb BG-12B · S/N 114 · Cancelled Jul 9, 2012 · Revoked, canceled · Built 1967 · De Vries Donald S Ptnr
- [N40032](https://openairdocs.org/deregistered/N40032-2012-05-24.md): Piaggio P.136-L1 · S/N 223 · Cancelled May 24, 2012 · Revoked, canceled · Johnson Jay
- [N239PC](https://openairdocs.org/deregistered/N239PC-2007-09-12.md): Clement P W/Clement C M ZENITH ZODC CH602HDS · S/N 6-4235 · Cancelled Sep 12, 2007 · Triennial form not returned · Built 2006 · Clement Paul W
- [N2216Z](https://openairdocs.org/deregistered/N2216Z-2007-03-21.md): Piper PA-28-181 · S/N 28-7990407 · Cancelled Mar 21, 2007 · Triennial form not returned · Built 1979 · Sherif Judith A
- [N8457J](https://openairdocs.org/deregistered/N8457J-1998-09-28.md): Robinson Helicopter R22 ALPHA · S/N 0377 · Cancelled Sep 28, 1998 · Efting Lynn A
- [N54616](https://openairdocs.org/deregistered/N54616-1992-10-15.md): Cessna 336 · S/N 3360020 · Cancelled Oct 15, 1992 · Exported to Fiji · Johnson Jay
- [N5479Y](https://openairdocs.org/deregistered/N5479Y-1985-04-18.md): Grumman American Avn. AA-5B · S/N AA5B0565 · Cancelled Apr 18, 1985 · Exported to Norway · Hadek Nadezda
- [N4677B](https://openairdocs.org/deregistered/N4677B-1984-07-12.md): Cessna 180 · S/N 31575 · Cancelled Jul 12, 1984 · Parker Gary L
- [N6988Q](https://openairdocs.org/deregistered/N6988Q-1972-08-14.md): Beech B23 · S/N M-1112 · Cancelled Aug 14, 1972 · Koselka William J
- [N4182K](https://openairdocs.org/deregistered/N4182K-1970-10-27.md): Ryan NAVION · S/N NAV-4-1182 · Cancelled Oct 27, 1970 · Elmar Air Inc
- [N3496P](https://openairdocs.org/deregistered/N3496P-1970-06-30.md): Piper PA-23-160 · S/N 23-1472 · Cancelled Jun 30, 1970 · Alta Associates

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

This list as a web page: https://openairdocs.org/faa-place/CA/La%20Canada/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, except the copies of manufacturers’ service documents, which belong to their rights holders.