# Cancelled registrations: Johns Island, SC

A list on [Johns Island, SC](https://openairdocs.org/faa-place/SC/Johns%20Island.md).

Cancelled aircraft registrations in Johns Island, SC.

- [N55AR](https://openairdocs.org/deregistered/N55AR-2024-09-27.md): Gates Learjet 55 · S/N 105 · Cancelled Sep 27, 2024 · Exported to Mexico · Built 1984 · Jli Holdings Group Inc
- [N3402C](https://openairdocs.org/deregistered/N3402C-2019-07-18.md): Carkeet Gregory Scott BUCCANEER II · S/N B2B-K034 · Cancelled Jul 18, 2019 · Registration expired, pending cancellation · Built 1994 · Airworks LLC
- [N3181L](https://openairdocs.org/deregistered/N3181L-2015-05-19.md): Ratcliffe John A KOLB MARK3X · S/N M3X6-1-00078 · Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 2009 · Ratcliffe John A
- [N40MS](https://openairdocs.org/deregistered/N40MS-2014-12-02.md): Glaser-Dirks DG-400 · S/N 4-50 · Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Stevenson Malcolm D
- [N86TC](https://openairdocs.org/deregistered/N86TC-2014-05-29.md): Cessna 182Q · S/N 18267381 · Cancelled May 29, 2014 · Exported to Paraguay · Built 1980 · Hanger Aviation Inc
- [N739XR](https://openairdocs.org/deregistered/N739XR-2013-12-24.md): Cessna 172N · S/N 17270893 · Cancelled Dec 24, 2013 · Exported to Brazil · Built 1978 · Hanger Aviation Inc
- [N6431F](https://openairdocs.org/deregistered/N6431F-2013-10-28.md): Cessna 172N · S/N 17273223 · Cancelled Oct 28, 2013 · Exported to Russia · Built 1980 · Hanger Aviation Inc
- [N63139](https://openairdocs.org/deregistered/N63139-2013-02-11.md): Cessna 172P · S/N 17275395 · Cancelled Feb 11, 2013 · Exported to Brazil · Built 1981 · Hanger Aviation Inc
- [N6648H](https://openairdocs.org/deregistered/N6648H-2012-09-11.md): Beech V35B · S/N D-10249 · Cancelled Sep 11, 2012 · Exported to Chile · Built 1979 · Hanger Aviation Inc
- [N739XQ](https://openairdocs.org/deregistered/N739XQ-2012-08-10.md): Cessna 172N · S/N 17270892 · Cancelled Aug 10, 2012 · Exported to Russia · Built 1978
- [N9870J](https://openairdocs.org/deregistered/N9870J-2012-06-13.md): Cessna 172N · S/N 17273943 · Cancelled Jun 13, 2012 · Exported to Canada · Built 1980 · Hanger Aviation Inc
- [N1FT](https://openairdocs.org/deregistered/N1FT-2009-07-15.md): Robinson Helicopter R44 · S/N 0658 · Cancelled Jul 15, 2009 · Exported to Mexico · Built 1999
- [N789SA](https://openairdocs.org/deregistered/N789SA-2005-09-27.md): Raytheon A36 · S/N E-3173 · Cancelled Sep 27, 2005 · Triennial form not returned · Built 1998 · King David W
- [N6739F](https://openairdocs.org/deregistered/N6739F-2000-07-03.md): Piper PA-28-140 · S/N 28-7725078 · Cancelled Jul 3, 2000 · Triennial form not returned · Aeroflight Inc
- [N3724D](https://openairdocs.org/deregistered/N3724D-1995-04-26.md): Cessna 182A · S/N 34424 · Cancelled Apr 26, 1995 · Jolly Mon Inc
- [N4046X](https://openairdocs.org/deregistered/N4046X-1977-03-09.md): Aero Commander 100-180 · S/N 5146 · Cancelled Mar 9, 1977 · Hart Robert M

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

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