# Earlier aircraft under this name: Hawthorne Flying Service

A list on [Hawthorne Flying Service](https://openairdocs.org/faa-owner/HAWTHORNE%20FLYING%20SERVICE.md).

Cancelled registrations that named this owner when they ended, newest first.

- [N35329](https://openairdocs.org/deregistered/N35329-1971-01-15.md): Piper J3C-65 · S/N 6296 · Cancelled Jan 15, 1971 · Charleston, SC
- [N2219M](https://openairdocs.org/deregistered/N2219M-1970-12-04.md): Piper J3C-65 · S/N 21011 · Cancelled Dec 4, 1970 · Jacksonville, FL
- [N5293N](https://openairdocs.org/deregistered/N5293N-1959-11-10.md): Republic F-47 · S/N 39955640 · Cancelled Nov 10, 1959 · Charleston, SC
- [N73024](https://openairdocs.org/deregistered/N73024-1956-03-16.md): Cessna 140 · S/N 10229 · Cancelled Mar 16, 1956 · Charleston, SC
- [N60793](https://openairdocs.org/deregistered/N60793-1954-09-20.md): North American SNJ-2 · S/N 2033 · Cancelled Sep 20, 1954 · Exported to Peru · Charleston, SC
- [N99D](https://openairdocs.org/deregistered/N99D-1954-09-17.md): North American SNJ-2 · S/N 2012 · Cancelled Sep 17, 1954 · Charleston, SC
- [N55272](https://openairdocs.org/deregistered/N55272-1954-07-19.md): North American BC1A · S/N 55-1604 · Cancelled Jul 19, 1954 · Exported to Peru · Charleston, SC
- [N75140](https://openairdocs.org/deregistered/N75140-1954-07-19.md): North American BC1A · S/N 79-3998 · Cancelled Jul 19, 1954 · Exported to Peru · Charleston, SC
- [N5290N](https://openairdocs.org/deregistered/N5290N-1953-05-07.md): Republic F-47 · S/N 31953829 · Cancelled May 7, 1953 · Charleston, SC
- [N5291N](https://openairdocs.org/deregistered/N5291N-1953-05-07.md): Republic F-47 · S/N 23965819 · Cancelled May 7, 1953 · Charleston, SC
- [N52031](https://openairdocs.org/deregistered/N52031-1952-04-25.md): North American SNJ-4 · S/N 88-12036 · Cancelled Apr 25, 1952 · Charleston, SC
- [N52612](https://openairdocs.org/deregistered/N52612-1952-01-25.md): Cessna T-50 · S/N 4443 · Cancelled Jan 25, 1952 · Columbia, SC
- [N4E](https://openairdocs.org/deregistered/N4E-1951-08-09.md): North American P-51D-20-NA · S/N 12238872 · Cancelled Aug 9, 1951 · Built 1933 · Charleston, SC
- [N48940](https://openairdocs.org/deregistered/N48940-1951-07-12.md): Fairchild 24W-41A · S/N W41A-208 · Cancelled Jul 12, 1951 · Hawthorne, CA
- [N3919B](https://openairdocs.org/deregistered/N3919B-1950-01-04.md): North American F-51D · S/N 122-31570 · Cancelled Jan 4, 1950 · Charleston, SC
- [N3915B](https://openairdocs.org/deregistered/N3915B-1949-12-22.md): North American F-51D · S/N 12231548 · Cancelled Dec 22, 1949 · Charleston, SC
- [N3916B](https://openairdocs.org/deregistered/N3916B-1949-12-22.md): North American F-51D · S/N 122-31550 · Cancelled Dec 22, 1949 · Charleston, SC
- [N3917B](https://openairdocs.org/deregistered/N3917B-1949-12-22.md): North American F-51D · S/N 122-31555 · Cancelled Dec 22, 1949 · Charleston, SC
- [N3918B](https://openairdocs.org/deregistered/N3918B-1949-12-22.md): North American F-51D · S/N 12231579 · Cancelled Dec 22, 1949 · Charleston, SC
- [N92523](https://openairdocs.org/deregistered/N92523-1949-07-15.md): Piper PA-12 · S/N 12-46 · Cancelled Jul 15, 1949 · Orangeburg, SC
- [N4239H](https://openairdocs.org/deregistered/N4239H-1949-05-25.md): Piper PA-14 · S/N 14-43 · Cancelled May 25, 1949 · Charlston, SC
- [N39404](https://openairdocs.org/deregistered/N39404-1948-10-08.md): Stinson 10A · S/N 8204 · Cancelled Oct 8, 1948 · Built 1942 · Orangeburg, SC
- [N11428](https://openairdocs.org/deregistered/N11428-1943-04-06.md): Waco QDC · S/N 3498 · Cancelled Apr 6, 1943 · Built 1931 · Charleston, SC
- [N5570](https://openairdocs.org/deregistered/N5570-1939-12-09.md): American Eagle A-1 · S/N 193 · Cancelled Dec 9, 1939 · Built 1928 · Charleston, SC

## 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_name = 'HAWTHORNE FLYING SERVICE' OR list_contains(d.other_registrant_names, 'HAWTHORNE FLYING SERVICE')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-owner/HAWTHORNE%20FLYING%20SERVICE/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.
