# Cancelled registrations: Bellflower, CA

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

Cancelled aircraft registrations in Bellflower, CA.

- [N4474H](https://openairdocs.org/deregistered/N4474H-2022-02-05.md): Mooney M20J · S/N 24-0744 · Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Punt Henry
- [N88805](https://openairdocs.org/deregistered/N88805-2020-07-06.md): Russell TEENIE TWO · S/N 5-10477 · Cancelled Jul 6, 2020 · Revoked, pending cancellation · Russell Jerry D
- [N43942](https://openairdocs.org/deregistered/N43942-2018-12-10.md): Taylorcraft BF · S/N 7601 · Cancelled Dec 10, 2018 · Revoked, canceled · Built 1946 · Roberts David E
- [N53421](https://openairdocs.org/deregistered/N53421-2018-09-13.md): Boeing A75N1(PT17) · S/N 75-3218 · Cancelled Sep 13, 2018 · Revoked, canceled · Built 1942 · Most James L Avia
- [N32963](https://openairdocs.org/deregistered/N32963-2018-05-18.md): Piper J3C-85 · S/N 5747 · Cancelled May 18, 2018 · Revoked, canceled · Built 1940 · Mckisson Frank E
- [N9059V](https://openairdocs.org/deregistered/N9059V-2018-03-16.md): Mooney M20F · S/N 690007 · Cancelled Mar 16, 2018 · Revoked, canceled · Noar Raymond
- [N8765K](https://openairdocs.org/deregistered/N8765K-2017-11-21.md): Stinson 108-1 · S/N 108-1765 · Cancelled Nov 21, 2017 · Revoked, canceled · Built 1947 · Popma Norman J
- [N5130Z](https://openairdocs.org/deregistered/N5130Z-2017-11-18.md): Piper PA-22-108 · S/N 22-8771 · Cancelled Nov 18, 2017 · Revoked, canceled · Built 1961 · Bailey Jim N
- [N2161G](https://openairdocs.org/deregistered/N2161G-2017-02-22.md): Piper PA-28-181 · S/N 28-7990193 · Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1978 · Spoolstra Calvin G
- [N897](https://openairdocs.org/deregistered/N897-2017-02-04.md): Turpin JFT B-8M · S/N 12229 · Cancelled Feb 4, 2017 · Revoked, canceled · Built 1972 · Turpin James F
- [N5948J](https://openairdocs.org/deregistered/N5948J-2014-10-29.md): Cessna 182P · S/N 18263588 · Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1975 · Hill Rudy
- [N1757Z](https://openairdocs.org/deregistered/N1757Z-2014-09-10.md): Cessna 336 · S/N 336-0057 · Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1963 · Pennington Dave
- [N6170Q](https://openairdocs.org/deregistered/N6170Q-2013-08-05.md): Cessna 421A · S/N 421A0110 · Cancelled Aug 5, 2013 · Revoked, canceled · Built 1969 · West Coast Leasing Co
- [N3382H](https://openairdocs.org/deregistered/N3382H-2013-07-30.md): Ercoupe 415-CD · S/N 4007 · Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1947 · Anderson Mary G
- [N4224P](https://openairdocs.org/deregistered/N4224P-2013-06-07.md): Hill Robert L BARNETT J-3 · S/N 1 · Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1981 · Hill Robert L
- [N123JH](https://openairdocs.org/deregistered/N123JH-2013-04-09.md): Beech S35 · S/N D-7477 · Cancelled Apr 9, 2013 · Sale reported, canceled · Built 1964
- [N8510G](https://openairdocs.org/deregistered/N8510G-2012-09-18.md): Wright Deryl W KB-2 GYROPLANE · S/N KCT801040 · Cancelled Sep 18, 2012 · Registration expired, pending cancellation · Wright Deryl W
- [N4439](https://openairdocs.org/deregistered/N4439-2012-08-08.md): Maldewin MINIPLANE · S/N M-2 · Cancelled Aug 8, 2012 · Registration pending, canceled · Built 1970
- [N1078X](https://openairdocs.org/deregistered/N1078X-2010-07-30.md): Piper PA-28-235 · S/N 28-7510085 · Cancelled Jul 30, 2010 · Exported to South Africa · Built 1975 · Rogers Carrol E
- [N2172T](https://openairdocs.org/deregistered/N2172T-2009-07-13.md): Piper PA-28-180 · S/N 28-7105164 · Cancelled Jul 13, 2009 · Registration revoked · Built 1971 · Holmes Lorne R
- [N206TV](https://openairdocs.org/deregistered/N206TV-2005-07-29.md): Robinson Helicopter R22 BETA · S/N 2753 · Cancelled Jul 29, 2005 · Built 1997 · Tompkins Timothy W
- [N970SM](https://openairdocs.org/deregistered/N970SM-2004-05-20.md): Robinson Helicopter R22 BETA · S/N 1970 · Cancelled May 20, 2004 · Exported to Mexico · Built 1991 · Zdarsky Ivo
- [N4542S](https://openairdocs.org/deregistered/N4542S-1990-12-11.md): Beech 95-B55 (T42A) · S/N TC1892 · Cancelled Dec 11, 1990 · Exported to Canada · Peyton Earl DBA
- [N4694Q](https://openairdocs.org/deregistered/N4694Q-1977-10-31.md): Cessna T210L · S/N 21059594 · Cancelled Oct 31, 1977 · West Coast Leasing Company
- [N1846K](https://openairdocs.org/deregistered/N1846K-1971-07-15.md): Luscombe 8E · S/N 4573 · Cancelled Jul 15, 1971 · Built 1946 · Chapman Craig B
- [N34K](https://openairdocs.org/deregistered/N34K-1971-03-15.md): Kerns Glider KERNS · S/N 1-4 · Cancelled Mar 15, 1971 · Kerns Frank F
- [N18190](https://openairdocs.org/deregistered/N18190-1971-01-12.md): Monocoupe 90AF · S/N A-819 · Cancelled Jan 12, 1971 · Built 1941 · Sievers Raymond E
- [N9603S](https://openairdocs.org/deregistered/N9603S-1970-06-26.md): Champion 7GCAA · S/N 26 · Cancelled Jun 26, 1970 · 47 Flying Service Inc
- [N3525K](https://openairdocs.org/deregistered/N3525K-1956-06-12.md): Piper J3C-65 · S/N 22215 · Cancelled Jun 12, 1956 · Exported to Mexico · Mckisson Frank E
- [N4073N](https://openairdocs.org/deregistered/N4073N-1956-03-23.md): Cessna 120 · S/N 13531 · Cancelled Mar 23, 1956 · James L Most Aviation
- [N30032](https://openairdocs.org/deregistered/N30032-1956-02-23.md): Cessna T-50 · S/N 6079 · Cancelled Feb 23, 1956 · Built 1942 · Most James L DBA James L Most Aviation
- [N63135](https://openairdocs.org/deregistered/N63135-1956-02-16.md): Cessna T-50 · S/N 4318 · Cancelled Feb 16, 1956 · James L Most Aviation
- [N54660](https://openairdocs.org/deregistered/N54660-1955-10-21.md): Ryan Aeronautical ST3KR · S/N 1638 · Cancelled Oct 21, 1955 · Bodell Malcolm E
- [N1983V](https://openairdocs.org/deregistered/N1983V-1953-06-26.md): Cessna 140 · S/N 14194 · Cancelled Jun 26, 1953 · Exported to Chile · James L Most Aviation
- [N76224](https://openairdocs.org/deregistered/N76224-1952-01-02.md): Cessna 140 · S/N 10627 · Cancelled Jan 2, 1952 · James L Most Aviation
- [N97848](https://openairdocs.org/deregistered/N97848-1951-03-30.md): Stinson 108-1 · S/N 108-848 · Cancelled Mar 30, 1951 · Built 1946 · Bodell Malcolm E
- [N4653N](https://openairdocs.org/deregistered/N4653N-1949-09-09.md): Cessna T-50 · S/N 2833 · Cancelled Sep 9, 1949 · Bellflower Airport Inc
- [N14693](https://openairdocs.org/deregistered/N14693-1948-04-14.md): Aeronca C-3 · S/N A-564 · Cancelled Apr 14, 1948 · Swerdfeger R M
- [N56759](https://openairdocs.org/deregistered/N56759-undated.md): Boeing 75 · S/N 75-266 (40-1709) · Cancellation date not recorded · Coughan James E
- [N67222](https://openairdocs.org/deregistered/N67222-undated.md): Cessna UC-78B · S/N 6052 · Cancellation date not recorded · Roberts Gordon E

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

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