# Cancelled registrations: Tujunga, CA

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

Cancelled aircraft registrations in Tujunga, CA.

- [N63168](https://openairdocs.org/deregistered/N63168-2017-11-21.md): Consolidated Vultee BT-13A · S/N 7610 · Cancelled Nov 21, 2017 · Revoked, canceled · Built 1942 · Finan Joe W
- [N1596V](https://openairdocs.org/deregistered/N1596V-2017-06-21.md): Cessna 172M · S/N 17263688 · Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Built 1974 · Fawver Douglas J
- [N3558R](https://openairdocs.org/deregistered/N3558R-2015-08-14.md): Beech A23 · S/N M-727 · Cancelled Aug 14, 2015 · Third renewal notice · Built 1965 · Stanfill Larry Wiley
- [N26848](https://openairdocs.org/deregistered/N26848-2015-05-19.md): Gulfstream American AA-5A · S/N AA5A0763 · Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1978 · Fawver Douglas J
- [N5258](https://openairdocs.org/deregistered/N5258-2013-04-02.md): Grumman G-164A · S/N 542 · Cancelled Apr 2, 2013 · Registration expired, pending cancellation · Built 1968 · Wonderling Gerald L
- [N2733D](https://openairdocs.org/deregistered/N2733D-2012-09-21.md): Cessna 170B · S/N 25275 · Cancelled Sep 21, 2012 · Registration expired, pending cancellation · Built 1952 · Lantz David H
- [N4591D](https://openairdocs.org/deregistered/N4591D-2012-07-24.md): Beech G35 · S/N D-4744 · Cancelled Jul 24, 2012 · Revoked, canceled · Built 1956 · Alexander Robert N
- [N4518](https://openairdocs.org/deregistered/N4518-2012-07-19.md): Caswell ADG-1 · S/N 1 · Cancelled Jul 19, 2012 · Revoked, canceled · Caswell Raymond A
- [N94594](https://openairdocs.org/deregistered/N94594-2008-08-04.md): Robinson Helicopter R22 BETA · S/N 3023 · Cancelled Aug 4, 2008 · Exported to Austria · Built 1999 · Light Helicopter Depot LLC
- [N5138H](https://openairdocs.org/deregistered/N5138H-2003-05-14.md): Cessna 152 · S/N 15284065 · Cancelled May 14, 2003 · Exported to Spain · Built 1979 · Powell Dwayne K
- [N4367B](https://openairdocs.org/deregistered/N4367B-2000-01-12.md): Cessna 170B · S/N 26711 · Cancelled Jan 12, 2000 · Triennial form not returned · Bryant David L
- [N47JP](https://openairdocs.org/deregistered/N47JP-1998-08-10.md): Pullis John P-47 · S/N 001 · Cancelled Aug 10, 1998 · Triennial form not returned · Pullis John W
- [N67308](https://openairdocs.org/deregistered/N67308-1982-02-26.md): Cessna 152 · S/N 15281740 · Cancelled Feb 26, 1982 · Bailey Robert G
- [N60259](https://openairdocs.org/deregistered/N60259-1974-10-10.md): Cessna 150J · S/N 15070178 · Cancelled Oct 10, 1974 · Smith Jerry D
- [N3792R](https://openairdocs.org/deregistered/N3792R-1974-08-21.md): Cessna 172H · S/N 17255592 · Cancelled Aug 21, 1974 · Exported to Canada · Built 1966 · Wirly Sales Co
- [N2692V](https://openairdocs.org/deregistered/N2692V-1970-10-16.md): Cessna 170 · S/N 18202 · Cancelled Oct 16, 1970 · Built 1948 · Stark C N
- [N57468](https://openairdocs.org/deregistered/N57468-undated.md): North American AT-6A · S/N 78-6350 · Cancellation date not recorded · Eddy Custer
- [N8489](https://openairdocs.org/deregistered/N8489-undated.md): Phaneuf B8 MOD GYRO · S/N PAP-1004 · Cancellation date not recorded · Phaneuf Peter A

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

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