# Cancelled registrations: La Habra, CA

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

Cancelled aircraft registrations in La Habra, CA.

- [N3821N](https://openairdocs.org/deregistered/N3821N-2019-04-12.md): Beech 35 · S/N D-1051 · Cancelled Apr 12, 2019 · Revoked, canceled · Built 1947 · Lane John L
- [N5129T](https://openairdocs.org/deregistered/N5129T-2017-06-19.md): Skygear COMET · S/N CMT-900601 0606 · Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Built 2007 · Park Helen
- [N8029A](https://openairdocs.org/deregistered/N8029A-2013-10-31.md): Skygear SKYGEAR · S/N SKG-9003010507 · Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Park Helen
- [N8029K](https://openairdocs.org/deregistered/N8029K-2013-09-24.md): Skygear COMET · S/N CMT-9006010507 · Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Park Helen
- [N8029X](https://openairdocs.org/deregistered/N8029X-2013-09-24.md): Skygear COMET · S/N CMT-9006020507 · Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Park Helen
- [N6180Q](https://openairdocs.org/deregistered/N6180Q-2013-09-20.md): Skygear COMET · S/N CMT-9006030507 · Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Park Helen
- [N692RF](https://openairdocs.org/deregistered/N692RF-2013-07-09.md): Cessna T210H · S/N T210-0363 · Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1968 · Cherry Aviation
- [N200W](https://openairdocs.org/deregistered/N200W-2013-06-14.md): Beech A35 · S/N D-2113 · Cancelled Jun 14, 2013 · Sale reported, canceled · Built 1949
- [N51291](https://openairdocs.org/deregistered/N51291-2013-05-30.md): Skygear SKYGEAR · S/N SKG-9003010606 · Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 2007 · Park Helen
- [N456S](https://openairdocs.org/deregistered/N456S-2012-12-07.md): Scott KS-1 · S/N KSA-1 · Cancelled Dec 7, 2012 · Registration expired, pending cancellation · Built 1962 · Scott R Kenneth
- [N4395T](https://openairdocs.org/deregistered/N4395T-2012-11-29.md): Piper PA-28-140 · S/N 28-7225180 · Cancelled Nov 29, 2012 · Registration expired, pending cancellation · Built 1972 · Heffron Russell Joseph
- [N3084R](https://openairdocs.org/deregistered/N3084R-2012-08-08.md): Piper PA-28R-200 · S/N 28R-35643 · Cancelled Aug 8, 2012 · Registration pending, canceled · Built 1969
- [N456J](https://openairdocs.org/deregistered/N456J-2012-07-24.md): Heffron KR-2 · S/N 1 · Cancelled Jul 24, 2012 · Revoked, canceled · Built 1978 · Heffron Russell J
- [N737EJ](https://openairdocs.org/deregistered/N737EJ-2008-11-05.md): Cessna 172N · S/N 17269358 · Cancelled Nov 5, 2008 · Triennial form not returned · Built 1978 · Reinke William A
- [N13403](https://openairdocs.org/deregistered/N13403-2007-12-14.md): Cessna 172M · S/N 17262732 · Cancelled Dec 14, 2007 · Triennial form not returned · Buchanan R Larry
- [N5240K](https://openairdocs.org/deregistered/N5240K-1999-09-29.md): Ryan NAVION · S/N NAV-4-2140B · Cancelled Sep 29, 1999 · Exported to Canada
- [N5248V](https://openairdocs.org/deregistered/N5248V-1991-12-19.md): Cessna 172RG · S/N 172RG0484 · Cancelled Dec 19, 1991 · Exported to Germany · Stegelvik Steven
- [N1109J](https://openairdocs.org/deregistered/N1109J-1982-07-27.md): Aero Commander 112 · S/N 109 · Cancelled Jul 27, 1982 · Administratively canceled · Ott Charles O
- [N5607H](https://openairdocs.org/deregistered/N5607H-1979-09-24.md): Piper PA-16 · S/N 16-214 · Cancelled Sep 24, 1979 · Exported to Canada · Miller Gregory A
- [N5590Y](https://openairdocs.org/deregistered/N5590Y-1977-03-21.md): Piper PA-23-250 · S/N 27-2697 · Cancelled Mar 21, 1977 · Mc Donnell Michael R
- [N6636Y](https://openairdocs.org/deregistered/N6636Y-1974-01-23.md): Piper PA-23-250 · S/N 27-3948 · Cancelled Jan 23, 1974 · Exported to Australia · Goodman Paul R
- [N9645C](https://openairdocs.org/deregistered/N9645C-1971-05-04.md): Navion L-17A · S/N NAV4-1049 · Cancelled May 4, 1971 · Built 1947 · Kurz Henry G
- [N56623](https://openairdocs.org/deregistered/N56623-1965-10-08.md): Consolidated Vultee BT-13 · S/N 5473 · Cancelled Oct 8, 1965 · Built 1945 · Ward Bennett Monroe

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

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