# Cancelled registrations: Los Angelas, CA

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

Cancelled aircraft registrations in Los Angelas, CA.

- [N4530W](https://openairdocs.org/deregistered/N4530W-1979-01-24.md): Boeing 737-247 · S/N 20134 · Cancelled Jan 24, 1979 · Exported to Taiwan · Built 1969 · Western Aie Lines Inc
- [N75FC](https://openairdocs.org/deregistered/N75FC-1978-01-13.md): Piper PA-22-108 · S/N 22-8084 · Cancelled Jan 13, 1978 · Macmillan Harold I & Sokol Dennis J
- [N333WG](https://openairdocs.org/deregistered/N333WG-1975-09-19.md): Cessna P337 · S/N P3370068 · Cancelled Sep 19, 1975 · Garlandwilliam M
- [N9185X](https://openairdocs.org/deregistered/N9185X-1975-09-05.md): Dornier DO28 A-1 · S/N 3059 · Cancelled Sep 5, 1975 · Exported to Thailand · Continental Air Services Inc
- [N9184X](https://openairdocs.org/deregistered/N9184X-1975-05-08.md): Dornier DO28 A-1 · S/N 3058 · Cancelled May 8, 1975 · Exported to Laos · Continental Air Services Inc
- [N644LA](https://openairdocs.org/deregistered/N644LA-1970-06-29.md): Beech D18S · S/N A-282 · Cancelled Jun 29, 1970 · Capital Reserve Corp
- [N9181X](https://openairdocs.org/deregistered/N9181X-1969-12-12.md): Dornier DO28 B-1 · S/N 3084 · Cancelled Dec 12, 1969 · Exported to Philippines · Continental Air Services Inc
- [N7901C](https://openairdocs.org/deregistered/N7901C-1959-11-24.md): Boeing B-17G · S/N 77251 · Cancelled Nov 24, 1959 · Fairchild Aerial Surveys Inc
- [N5615B](https://openairdocs.org/deregistered/N5615B-1958-02-03.md): Cessna 182 · S/N 33615 · Cancelled Feb 3, 1958 · Exported to Spain · De Sonchen Georges
- [N93625](https://openairdocs.org/deregistered/N93625-1949-05-16.md): Ercoupe 415-C · S/N 948 · Cancelled May 16, 1949 · Built 1946 · Hertz David
- [N315W](https://openairdocs.org/deregistered/N315W-1933-06-17.md): Bowlus S-1000 · S/N 24 · Cancelled Jun 17, 1933 · Pacific Coast Gliders Limited
- [N154E](https://openairdocs.org/deregistered/N154E-1932-09-30.md): Waco ATO · S/N 1536 · Cancelled Sep 30, 1932 · Built 1929 · Aero Crop Dusting Co
- [N7486](https://openairdocs.org/deregistered/N7486-1930-03-17.md): Alexander EAGLEROCK A-2 · S/N 594 · Cancelled Mar 17, 1930 · Aero Corp Of California
- [N755E](https://openairdocs.org/deregistered/N755E-1929-11-25.md): Advance WACO 10 · S/N A115 · Cancelled Nov 25, 1929 · Exported to Mexico · Built 1929 · American Aircraft Co
- [N8021](https://openairdocs.org/deregistered/N8021-1929-06-05.md): Sikorsky S-38-A · S/N 14-5 · Cancelled Jun 5, 1929 · Western Air Express Inc
- [N7107](https://openairdocs.org/deregistered/N7107-undated.md): Cessna AW · S/N 140 · Cancellation date not recorded · Hart Douglas P

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

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