# Cancelled registrations: Huntington Park, CA

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

Cancelled aircraft registrations in Huntington Park, CA.

- [N4006B](https://openairdocs.org/deregistered/N4006B-2012-11-29.md): North American SNJ-4 · S/N 88-26609 · Cancelled Nov 29, 2012 · Revoked, canceled · Built 1953 · Halcyon Films
- [N39144](https://openairdocs.org/deregistered/N39144-2012-11-14.md): Taylorcraft BF12-65 · S/N 3360 · Cancelled Nov 14, 2012 · Registration expired, pending cancellation · Built 1942 · Allied Aluminum Company
- [N15692](https://openairdocs.org/deregistered/N15692-2009-10-09.md): Erco 415-C · S/N 1 · Cancelled Oct 9, 2009 · Registration revoked · Built 1939 · Whipperman Robert F
- [N911RN](https://openairdocs.org/deregistered/N911RN-2000-01-07.md): Bell OH-58A · S/N 70-15123 · Cancelled Jan 7, 2000 · City Of Huntington Park Police Department
- [N577GN](https://openairdocs.org/deregistered/N577GN-1970-11-27.md): Cessna 320E · S/N 320E0070 · Cancelled Nov 27, 1970 · Exported to Australia · Newton George
- [N2932F](https://openairdocs.org/deregistered/N2932F-1970-10-16.md): Cessna 182J · S/N 18257032 · Cancelled Oct 16, 1970 · Exported to Australia · Built 1966 · Newton George E
- [N4606V](https://openairdocs.org/deregistered/N4606V-1965-11-01.md): Schweizer TG3A · S/N 61 · Cancelled Nov 1, 1965 · Aeronaut Soaring Club
- [N1278H](https://openairdocs.org/deregistered/N1278H-1958-02-19.md): Aeronca 15AC · S/N 15AC-294 · Cancelled Feb 19, 1958 · Rogers Robert E
- [N59804](https://openairdocs.org/deregistered/N59804-1956-02-14.md): Fairchild M-62A · S/N T40-322 · Cancelled Feb 14, 1956 · Hollenbeck E C
- [N63162](https://openairdocs.org/deregistered/N63162-1955-10-24.md): Consolidated Vultee BT-13 · S/N 79-340 · Cancelled Oct 24, 1955 · Elofson Randall C
- [N2091V](https://openairdocs.org/deregistered/N2091V-1953-09-16.md): Cessna 120 · S/N 14319 · Cancelled Sep 16, 1953 · Thompson Clyde D And Thompson Marianne A
- [N3108K](https://openairdocs.org/deregistered/N3108K-1952-11-17.md): Culver V · S/N V-327 · Cancelled Nov 17, 1952 · Sweetnam John E
- [N215W](https://openairdocs.org/deregistered/N215W-1948-07-08.md): Stinson SM-8A · S/N 4024 · Cancelled Jul 8, 1948 · Built 1930 · Bradford Amazon
- [N87395](https://openairdocs.org/deregistered/N87395-1947-09-24.md): Ercoupe 415-C · S/N 568 · Cancelled Sep 24, 1947 · Whipperman F Robert
- [N14590](https://openairdocs.org/deregistered/N14590-1939-04-06.md): Stinson SR-5A · S/N 9328A · Cancelled Apr 6, 1939 · Built 1935 · Hoffman Marvin Daniel
- [N17014](https://openairdocs.org/deregistered/N17014-1938-07-17.md): Porterfield 35W · S/N 306 · Cancelled Jul 17, 1938 · Mcmichael Robert W
- [N161H](https://openairdocs.org/deregistered/N161H-1935-10-03.md): Aeromarine-Klemm L-26-A · S/N 2-19 · Cancelled Oct 3, 1935 · Built 1929 · Danenberg Lawrence W
- [N943Y](https://openairdocs.org/deregistered/N943Y-1932-02-01.md): Erhart Edwin/Wiemann Sherwood P T GLIDER · S/N 1 · Cancelled Feb 1, 1932 · Built 1930 · Erhart Edwin A/Wiemannsherwood D
- [N2225](https://openairdocs.org/deregistered/N2225-1930-05-03.md): Curtiss JN4D · S/N 34151 · Cancelled May 3, 1930 · Built 1918 · Whittelsey R A
- [N59176](https://openairdocs.org/deregistered/N59176-undated.md): Consolidated Vultee SNV-1 · S/N 5882 (05695) · Cancellation date not recorded · Built 1942 · Mccurdy Richard F
- [N68114](https://openairdocs.org/deregistered/N68114-undated.md): Cessna UC-78 · S/N 3874 · Cancellation date not recorded · Lorenzen W 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 = 'HUNTINGTON PARK'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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