# Cancelled registrations: Sylmar, CA

A list on [Sylmar, CA](https://openairdocs.org/faa-place/CA/Sylmar.md).

Cancelled aircraft registrations in Sylmar, CA.

- [N8141E](https://openairdocs.org/deregistered/N8141E-2019-02-27.md): Mooney M20A · S/N 1412 · Cancelled Feb 27, 2019 · Registration expired, pending cancellation · Porter Richard P
- [N745EV](https://openairdocs.org/deregistered/N745EV-2018-01-29.md): Boeing 727 · S/N 19283 · Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 1967 · Tmw Corporation
- [N71791](https://openairdocs.org/deregistered/N71791-2017-02-04.md): Luscombe 8A · S/N 3218 · Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Haisten Miles S
- [N5012P](https://openairdocs.org/deregistered/N5012P-2015-03-31.md): Robinson Helicopter R44 II · S/N 10740 · Cancelled Mar 31, 2015 · Exported to Canada · Built 2005 · Airborne Leasing Inc
- [N142DZ](https://openairdocs.org/deregistered/N142DZ-2014-12-22.md): Zuck Daniel R PLANE-MOBILE · S/N 2 · Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Zuck Daniel R
- [N9807E](https://openairdocs.org/deregistered/N9807E-2014-12-01.md): Aeronca 11BC · S/N 11AC-1452 · Cancelled Dec 1, 2014 · Registration expired, pending cancellation · Built 1946 · Shelton Warren A
- [N304TS](https://openairdocs.org/deregistered/N304TS-2013-12-26.md): Gulfstream American G-1159A · S/N 304 · Cancelled Dec 26, 2013 · Built 1980 · Nomad Transportation LLC
- [N473WM](https://openairdocs.org/deregistered/N473WM-2012-12-11.md): Mojonnier-William BD-4 · S/N 473 · Cancelled Dec 11, 2012 · Registration expired, pending cancellation · Built 1979 · Mojonnier William Hurlbut
- [N956R](https://openairdocs.org/deregistered/N956R-2012-11-20.md): Douglas A-26B · S/N 28038 · Cancelled Nov 20, 2012 · Sale reported, pending cancellation · Built 1944
- [N1038L](https://openairdocs.org/deregistered/N1038L-2011-06-08.md): Hughes TH-55 · S/N 18045 · Cancelled Jun 8, 2011 · Sale reported, canceled · Built 1965
- [N100KG](https://openairdocs.org/deregistered/N100KG-2002-11-22.md): Gibson Howard M AX-5 · S/N G-1 · Cancelled Nov 22, 2002 · Second triennial mailing, no response · Built 1981 · Gibson Howard M Jr
- [N9317K](https://openairdocs.org/deregistered/N9317K-1996-02-26.md): Stinson 108-2 · S/N 1082317 · Cancelled Feb 26, 1996 · Exported to New Zealand · Rogers Norman M
- [N55BL](https://openairdocs.org/deregistered/N55BL-1992-07-20.md): Lefaivre STARDUSTER TOO · S/N 965 · Cancelled Jul 20, 1992 · Triennial form not returned · Lefaivre Antoine J
- [N1221Q](https://openairdocs.org/deregistered/N1221Q-1983-11-23.md): Cessna 150L · S/N 15072521 · Cancelled Nov 23, 1983 · Administratively canceled · Brown Gerald A
- [N73940](https://openairdocs.org/deregistered/N73940-1983-09-23.md): Bell 47G-3B-1 · S/N 2818 · Cancelled Sep 23, 1983 · Exported to Mexico · Broussard Allen J
- [N704ZK](https://openairdocs.org/deregistered/N704ZK-1980-09-23.md): Cessna 150M · S/N 15079001 · Cancelled Sep 23, 1980 · Higby Clifton M
- [N2766G](https://openairdocs.org/deregistered/N2766G-1978-04-25.md): Cessna 182B · S/N 52066 · Cancelled Apr 25, 1978 · Exported to Canada · Emmert Victor W
- [N21C](https://openairdocs.org/deregistered/N21C-1970-12-31.md): Levier & Associates COSMIC WIND · S/N 102 · Cancelled Dec 31, 1970 · Built 1947 · Blair M C
- [N22C](https://openairdocs.org/deregistered/N22C-1961-12-14.md): Levier & Associates COSMIC WIND · S/N 103 · Cancelled Dec 14, 1961 · Exported to United Kingdom · Built 1948 · Blair M C

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

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