# Cancelled registrations: Gretna, LA

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

Cancelled aircraft registrations in Gretna, LA.

- [N352JB](https://openairdocs.org/deregistered/N352JB-2018-01-18.md): Brown Joseph B JR RV-6 · S/N 23804 · Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 2002 · Miller James F
- [N172SH](https://openairdocs.org/deregistered/N172SH-2018-01-11.md): Cessna 172C · S/N 17248944 · Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1961 · Stark Jeffrey P
- [N88526](https://openairdocs.org/deregistered/N88526-2017-11-21.md): Piper J3C-65S · S/N 16151 · Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · La Bruzza Luke
- [N74SD](https://openairdocs.org/deregistered/N74SD-2016-09-09.md): Cessna 340A · S/N 340A0372 · Cancelled Sep 9, 2016 · Registration expired, pending cancellation · Built 1977 · M & M Air Transportation LLC
- [N6766](https://openairdocs.org/deregistered/N6766-2013-10-23.md): Volmer-Mccurdy VOLMER SPORTSMAN · S/N 101 · Cancelled Oct 23, 2013 · Revoked, canceled · Built 1974 · Mccurdy James W
- [N62422](https://openairdocs.org/deregistered/N62422-2013-04-29.md): Piper J3F-65 · S/N G-126 · Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Ofarrell Michael L
- [N55583](https://openairdocs.org/deregistered/N55583-2013-04-22.md): Raven Industries RALLY RX7 · S/N RX7-148 · Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1979 · Winchester William E
- [N75246](https://openairdocs.org/deregistered/N75246-2013-02-26.md): Cessna T-50 · S/N 4797 · Cancelled Feb 26, 2013 · Revoked, canceled · Built 1943 · Smith Reuben R
- [N4498V](https://openairdocs.org/deregistered/N4498V-2012-11-29.md): Beech 35 · S/N D-1318 · Cancelled Nov 29, 2012 · Registration expired, pending cancellation · Built 1948 · Bell Terry A
- [N190BT](https://openairdocs.org/deregistered/N190BT-2012-08-14.md): Beech 65-90 · S/N LJ-59 · Cancelled Aug 14, 2012 · Registration expired, pending cancellation · Built 1965 · Tiger Pass Properties Inc
- [N4633R](https://openairdocs.org/deregistered/N4633R-2012-07-31.md): Piper PA-28-140 · S/N 28-21384 · Cancelled Jul 31, 2012 · Revoked, canceled · Built 1966 · Swope George O
- [N5641P](https://openairdocs.org/deregistered/N5641P-2007-05-19.md): Piper PA-24-250 · S/N 24-711 · Cancelled May 19, 2007 · Triennial form not returned · Built 1959 · Rivere Youman P
- [N72088](https://openairdocs.org/deregistered/N72088-2006-04-18.md): Marcussen Charley PIETENPOL AIRCAMPER · S/N 001 · Cancelled Apr 18, 2006 · Triennial form not returned · Harvey Planes LLC
- [N18525](https://openairdocs.org/deregistered/N18525-2006-03-28.md): Cessna 150L · S/N 15073914 · Cancelled Mar 28, 2006 · Triennial form not returned · Built 1972 · Maclachlan John R
- [N5202B](https://openairdocs.org/deregistered/N5202B-2004-09-29.md): Mooney M20 · S/N 1065 · Cancelled Sep 29, 2004 · Triennial form not returned · Built 1956 · Harvey Planes LLC
- [N5123Y](https://openairdocs.org/deregistered/N5123Y-2001-09-27.md): Piper PA-23-250 · S/N 27-2156 · Cancelled Sep 27, 2001 · Triennial form not returned · Rittiner Group LLC
- [N4571R](https://openairdocs.org/deregistered/N4571R-1994-07-26.md): Piper PA-28-140 · S/N 2821312 · Cancelled Jul 26, 1994 · Triennial form not returned · Rivere Paul
- [N8243](https://openairdocs.org/deregistered/N8243-1973-11-05.md): Bell 47G · S/N 1385 · Cancelled Nov 5, 1973 · Jefferson Parish Civil Defense

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

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