# Cancelled registrations: La Puente, CA

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

Cancelled aircraft registrations in La Puente, CA.

- [N420HQ](https://openairdocs.org/deregistered/N420HQ-2023-03-06.md): Honda HA-420 · S/N 42000186 · Cancelled Mar 6, 2023 · Exported to Thailand · Built 2020 · Triton Coast LLC
- [N507HJ](https://openairdocs.org/deregistered/N507HJ-2022-07-08.md): Honda HA-420 · S/N 42000209 · Cancelled Jul 8, 2022 · Exported to Thailand · Built 2021 · Triton Coast LLC
- [N8545C](https://openairdocs.org/deregistered/N8545C-2022-01-08.md): Cecilia Gallegos CGKR2 · S/N 001 · Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Gallegos Cecilia
- [N77990](https://openairdocs.org/deregistered/N77990-2019-05-04.md): Luscombe 8A · S/N 3717 · Cancelled May 4, 2019 · Revoked, canceled · Built 1946 · Lennen Donald E
- [N5469Q](https://openairdocs.org/deregistered/N5469Q-2017-07-12.md): Cessna 150L · S/N 15073369 · Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1972 · Banks Arthur S
- [N339XP](https://openairdocs.org/deregistered/N339XP-2017-07-03.md): Luther William W PULSAR XP · S/N 339 · Cancelled Jul 3, 2017 · Registration expired, pending cancellation · Luther William W
- [N9286G](https://openairdocs.org/deregistered/N9286G-2017-02-14.md): North American SNJ-5 · S/N 111990 · Cancelled Feb 14, 2017 · Revoked, canceled · Built 1958 · Dobson Emery F Jr
- [N6871K](https://openairdocs.org/deregistered/N6871K-2017-02-04.md): Piper PA-16 · S/N 16-709 · Cancelled Feb 4, 2017 · Revoked, canceled · Built 1949 · Barwick Don M
- [N7197A](https://openairdocs.org/deregistered/N7197A-2017-02-04.md): Cessna 172 · S/N 29297 · Cancelled Feb 4, 2017 · Revoked, canceled · Built 1956 · Ambrosecchia Dominick F
- [N89951](https://openairdocs.org/deregistered/N89951-2017-02-02.md): Cessna 140 · S/N 9003 · Cancelled Feb 2, 2017 · Revoked, pending cancellation · Built 1946 · Stogsdill Jack Lynn Ptnr
- [N39488](https://openairdocs.org/deregistered/N39488-2014-10-06.md): Stinson 10A · S/N 8188 · Cancelled Oct 6, 2014 · Registration expired, pending cancellation · Built 1941 · Dwyer Eldon L
- [N301TC](https://openairdocs.org/deregistered/N301TC-2014-09-29.md): Cessna T210K · S/N 21059465 · Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1971 · Lewis K Jay
- [N6514C](https://openairdocs.org/deregistered/N6514C-2013-08-06.md): North American T-28A · S/N 49-1545 · Cancelled Aug 6, 2013 · Revoked, canceled · Built 1958 · Fuguitt Harry V Sr
- [N111DP](https://openairdocs.org/deregistered/N111DP-2013-03-20.md): Phelps GYRO-COPTER · S/N 111 · Cancelled Mar 20, 2013 · Sale reported, pending cancellation · Built 1972
- [N5795P](https://openairdocs.org/deregistered/N5795P-1972-08-03.md): Piper PA-24-250 · S/N 24-875 · Cancelled Aug 3, 1972 · Patton Pat
- [N97471](https://openairdocs.org/deregistered/N97471-1971-07-15.md): Stinson 108 · S/N 108-471 · Cancelled Jul 15, 1971 · Prestin Robert C And Or Vester B Sansing
- [N62915](https://openairdocs.org/deregistered/N62915-1970-10-09.md): Convair BT-13A · S/N 2108 · Cancelled Oct 9, 1970 · Smith Aubrey O
- [N53509](https://openairdocs.org/deregistered/N53509-1955-10-25.md): Aeronca 0-58B · S/N 058B-8342 · Cancelled Oct 25, 1955 · Built 1943 · Hunter Joseph H /DBA Hunter Flying Service

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

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