# Cancelled registrations: Covington, LA

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

Cancelled aircraft registrations in Covington, LA.

- [N90059](https://openairdocs.org/deregistered/N90059-2023-08-21.md): Cessna 140 · S/N 9120 · Cancelled Aug 21, 2023 · Sale reported, pending cancellation · Built 1946
- [N71SN](https://openairdocs.org/deregistered/N71SN-2023-05-21.md): World WA-3 · S/N 3061421101 · Cancelled May 21, 2023 · Thomas Frederic D
- [N405W](https://openairdocs.org/deregistered/N405W-2023-02-04.md): Warner Richard M KINGFISHER · S/N 82 · Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 1988 · Warner Richard M
- [N778SB](https://openairdocs.org/deregistered/N778SB-2022-11-28.md): Swellpro SPLASH DRONE · S/N K001 · Cancelled Nov 28, 2022 · Registration expired, pending cancellation · Hornbeck Offshore Operators LLC
- [N103ZX](https://openairdocs.org/deregistered/N103ZX-2020-01-03.md): Quicksilver SPRINT II · S/N 348 · Cancelled Jan 3, 2020 · Registration expired, pending cancellation · Built 1992 · Price John V
- [N778LH](https://openairdocs.org/deregistered/N778LH-2019-06-21.md): DJI PHANTOM 2 · S/N PH646021759 · Cancelled Jun 21, 2019 · Second renewal notice · Hornbeck Offshore Operators LLC
- [N778MB](https://openairdocs.org/deregistered/N778MB-2019-06-21.md): DJI PHANTOM 2 · S/N PH645381089 · Cancelled Jun 21, 2019 · Second renewal notice · Hornbeck Offshore Operators LLC
- [N778NH](https://openairdocs.org/deregistered/N778NH-2019-06-21.md): DJI PHANTOM 2 · S/N PH646022013 · Cancelled Jun 21, 2019 · Second renewal notice · Hornbeck Offshore Operators LLC
- [N37911](https://openairdocs.org/deregistered/N37911-2019-05-04.md): Osborne SMITH DSA-1 · S/N 110 · Cancelled May 4, 2019 · Registration expired, pending cancellation · Built 1979 · Lawshe Fred E
- [N5190P](https://openairdocs.org/deregistered/N5190P-2019-04-24.md): Piper PA-24 · S/N 24-186 · Cancelled Apr 24, 2019 · Registration expired, pending cancellation · Built 1958 · Lawshe Fred E
- [N15131](https://openairdocs.org/deregistered/N15131-2018-12-12.md): Beech F33A · S/N CE-1293 · Cancelled Dec 12, 2018 · Exported to Germany · Built 1988 · Warren Robert E
- [N213BE](https://openairdocs.org/deregistered/N213BE-2018-09-13.md): Edwards J G CH601HDS · S/N 6-1837 · Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Lawshe Fredrick E
- [N2010E](https://openairdocs.org/deregistered/N2010E-2017-05-23.md): Cessna 310J · S/N 310J0115 · Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1965 · 2010 Management LLC
- [N49KB](https://openairdocs.org/deregistered/N49KB-2017-03-21.md): Beech A35 · S/N D-2028 · Cancelled Mar 21, 2017 · Registration expired, pending cancellation · Built 1949 · Gilson Stephen E
- [N7900X](https://openairdocs.org/deregistered/N7900X-2017-02-04.md): Cessna 172B · S/N 17248400 · Cancelled Feb 4, 2017 · Revoked, canceled · Built 1961 · Vincent H Farley
- [N2740F](https://openairdocs.org/deregistered/N2740F-2016-02-19.md): Cessna 182J · S/N 18256840 · Cancelled Feb 19, 2016 · Second renewal notice · Built 1965 · Gremillion And Associates Inc
- [N91801](https://openairdocs.org/deregistered/N91801-2015-05-05.md): Schweizer SGU-1-19 · S/N 9 · Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1946 · Frost John J
- [N3239S](https://openairdocs.org/deregistered/N3239S-2013-11-12.md): Cessna 182G · S/N 18255739 · Cancelled Nov 12, 2013 · Registration expired, pending cancellation · Built 1964 · Pittman Marcus L
- [N70850](https://openairdocs.org/deregistered/N70850-2013-08-16.md): Helio HST-550 · S/N 2 · Cancelled Aug 16, 2013 · Sale reported, canceled
- [N6148](https://openairdocs.org/deregistered/N6148-2013-08-05.md): Beech 3NM · S/N CA-257 · Cancelled Aug 5, 2013 · Revoked, canceled · Built 1952 · Southern Parachute Center Inc
- [N67803](https://openairdocs.org/deregistered/N67803-2013-07-08.md): Cessna 152 · S/N 15282028 · Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1978 · Calvanelli Thomas J
- [N2753R](https://openairdocs.org/deregistered/N2753R-2013-02-21.md): Schweizer SGS 1-26B · S/N 224 · Cancelled Feb 21, 2013 · Registration expired, pending cancellation · Built 1963 · Frost John J
- [N1665A](https://openairdocs.org/deregistered/N1665A-2012-08-10.md): Piper PA-22 · S/N 22-422 · Cancelled Aug 10, 2012 · Registration expired, pending cancellation · Built 1952 · Lejeune O Eugene
- [N30FN](https://openairdocs.org/deregistered/N30FN-2011-07-15.md): Rossouw G J VANS RV-6 · S/N GR 3 · Cancelled Jul 15, 2011 · Exported to Brazil · Built 1994 · Norris Floyd V
- [N58DJ](https://openairdocs.org/deregistered/N58DJ-2005-12-23.md): Temco GC-1B · S/N 3654 · Cancelled Dec 23, 2005 · Exported to Chile · Built 1948 · Johnson David W
- [N4JF](https://openairdocs.org/deregistered/N4JF-2004-11-12.md): Boeing A75N1(PT17) · S/N 75-2173 · Cancelled Nov 12, 2004 · Exported to South Africa · Built 1941 · Cairns Adrian B
- [N5682G](https://openairdocs.org/deregistered/N5682G-1994-11-04.md): Cessna 150K · S/N 15071182 · Cancelled Nov 4, 1994 · Second triennial mailing, no response · Calvanelli Thomas J
- [N6463F](https://openairdocs.org/deregistered/N6463F-1994-05-04.md): Cessna 150F · S/N 15063063 · Cancelled May 4, 1994 · Triennial form not returned · Debellevue Vallee A
- [N7415T](https://openairdocs.org/deregistered/N7415T-1985-02-01.md): Cessna 172A · S/N 47015 · Cancelled Feb 1, 1985 · C F C Corp
- [N1450F](https://openairdocs.org/deregistered/N1450F-1978-01-06.md): Cessna 172H · S/N 17254945 · Cancelled Jan 6, 1978 · Warner Richard M
- [N84363](https://openairdocs.org/deregistered/N84363-1971-02-11.md): Aeronca 7AC · S/N 7AC-3056 · Cancelled Feb 11, 1971 · Warner Richard 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 = 'LA' AND d.registrant_city = 'COVINGTON'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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