# Cancelled registrations: Hartsville, SC

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

Cancelled aircraft registrations in Hartsville, SC.

- [N9415](https://openairdocs.org/deregistered/N9415-2017-02-13.md): Beech G18S · S/N BA-507 · Cancelled Feb 13, 2017 · Revoked, canceled · Built 1960 · Gilley Airways Corporation
- [N91GA](https://openairdocs.org/deregistered/N91GA-2017-02-04.md): Douglas C-50C · S/N 12945 · Cancelled Feb 4, 2017 · Exported to Canada · Gilley Airways Corp
- [N66058](https://openairdocs.org/deregistered/N66058-2013-04-30.md): Cessna 150M · S/N 15075806 · Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1974 · Payne Johnny P
- [N99JH](https://openairdocs.org/deregistered/N99JH-2013-04-02.md): Harel Joshua PIETENPOL-AIRCAMPER · S/N 1 · Cancelled Apr 2, 2013 · Exported to Canada · Harel Joshua
- [N39583](https://openairdocs.org/deregistered/N39583-2012-12-11.md): Ham Jimmy L WIZARD T-38BR503 · S/N 66001 · Cancelled Dec 11, 2012 · Sale reported, pending cancellation · Built 1983
- [N208Z](https://openairdocs.org/deregistered/N208Z-2009-07-13.md): Beech D18S · S/N A-76 · Cancelled Jul 13, 2009 · Registration revoked · Built 1946 · Gilley Airways Corporation
- [N1434Q](https://openairdocs.org/deregistered/N1434Q-1983-11-23.md): Cessna 150L · S/N 15072734 · Cancelled Nov 23, 1983 · Administratively canceled · Flowers T Earl
- [N2951D](https://openairdocs.org/deregistered/N2951D-1983-04-15.md): Piper PA-28-161 · S/N 28-7916578 · Cancelled Apr 15, 1983 · Built 1979 · Broach Andrew W
- [N6657F](https://openairdocs.org/deregistered/N6657F-1983-04-07.md): Cessna 150F · S/N 15063257 · Cancelled Apr 7, 1983 · Flowers Thomas E
- [N92GA](https://openairdocs.org/deregistered/N92GA-1978-05-05.md): Douglas C-50C · S/N 12952 · Cancelled May 5, 1978 · Exported to Canada · Gilley Airways Corp
- [N4716S](https://openairdocs.org/deregistered/N4716S-1975-06-04.md): Skyraider BM8 · S/N 1 · Cancelled Jun 4, 1975 · Curry B W
- [N417R](https://openairdocs.org/deregistered/N417R-1972-06-09.md): Beech E18S · S/N BA-264 · Cancelled Jun 9, 1972 · Gilley Airways
- [N4502A](https://openairdocs.org/deregistered/N4502A-1970-10-22.md): Piper PA-22-150 · S/N 22-3805 · Cancelled Oct 22, 1970 · Litton H J Jr
- [N88317](https://openairdocs.org/deregistered/N88317-1970-05-20.md): Piper J3C-65 · S/N 15935 · Cancelled May 20, 1970 · Miller Raymond
- [N96065](https://openairdocs.org/deregistered/N96065-1965-05-22.md): Taylorcraft BC12-D · S/N 8365 · Cancelled May 22, 1965 · Eugene Curtis Rutherford
- [N8611D](https://openairdocs.org/deregistered/N8611D-1964-10-06.md): Piper PA-22-160 · S/N 22-5809 · Cancelled Oct 6, 1964 · Pendergrass S D Jr M D
- [N49532](https://openairdocs.org/deregistered/N49532-1952-05-01.md): Fairchild M-62A · S/N T42-3576 · Cancelled May 1, 1952 · W F Little
- [N1304E](https://openairdocs.org/deregistered/N1304E-1947-12-01.md): Aeronca 7AC · S/N 7AC-4865 · Cancelled Dec 1, 1947 · Southernaire Co
- [N222V](https://openairdocs.org/deregistered/N222V-1941-08-01.md): Moth 60-GM · S/N 148 · Cancelled Aug 1, 1941 · Built 1930 · Bruce Clarence Emond

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

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