# Cancelled registrations: Ponchatoula, LA

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

Cancelled aircraft registrations in Ponchatoula, LA.

- [N43639](https://openairdocs.org/deregistered/N43639-2024-05-04.md): Meservey Ronald CHALLENGER II · S/N 1154 · Cancelled May 4, 2024 · Registration pending, canceled · Built 1998
- [N1198L](https://openairdocs.org/deregistered/N1198L-2020-02-28.md): Stelter Ronald F SONERAI II · S/N 1198L · Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Built 1987 · Windecker Walter H
- [N56252](https://openairdocs.org/deregistered/N56252-2018-05-30.md): Boeing A75N1(PT17) · S/N 75-1461 · Cancelled May 30, 2018 · Sale reported, canceled
- [N599DZ](https://openairdocs.org/deregistered/N599DZ-2018-02-16.md): Defelici Enrico ZENAIR CH 701 SP · S/N 7-9516 · Cancelled Feb 16, 2018 · Registration expired, pending cancellation · Built 2004 · Sheridan Rodney
- [N4417V](https://openairdocs.org/deregistered/N4417V-2018-01-19.md): Buckeye Powered Parachutes DREAM MACHINE · S/N 5041 · Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Hughes Robert J
- [N556RS](https://openairdocs.org/deregistered/N556RS-2017-11-30.md): Rodney Sheridan STOL CH 701 · S/N 7-10169 · Cancelled Nov 30, 2017 · Exported to Fiji · Built 2015 · Sheridan Rodney
- [N4750L](https://openairdocs.org/deregistered/N4750L-2017-05-23.md): Piper PA-28-180 · S/N 28-4079 · Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1967 · Speed Wade Warren
- [N4558Z](https://openairdocs.org/deregistered/N4558Z-2013-08-14.md): Piper PA-22-108 · S/N 22-8065 · Cancelled Aug 14, 2013 · Registration expired, pending cancellation · Built 1961 · Hopkins Donald R
- [N7338D](https://openairdocs.org/deregistered/N7338D-2012-10-16.md): Piper PA-22-150 · S/N 22-5127 · Cancelled Oct 16, 2012 · Sale reported, pending cancellation · Built 1957
- [N1454A](https://openairdocs.org/deregistered/N1454A-2011-03-14.md): Piper PA-22-135 · S/N 22-556 · Cancelled Mar 14, 2011 · Sale reported, pending cancellation · Built 1952
- [N617CD](https://openairdocs.org/deregistered/N617CD-2006-09-21.md): Davis Robert JR DAVIS I · S/N 001 · Cancelled Sep 21, 2006 · Windecker Walter H
- [N3727Z](https://openairdocs.org/deregistered/N3727Z-2001-05-01.md): Piper PA-22-160 · S/N 22-7603 · Cancelled May 1, 2001 · Triennial form not returned · Windecker Walter H Sr
- [N33074](https://openairdocs.org/deregistered/N33074-1993-07-29.md): Piper PA-28-140 · S/N 287525148 · Cancelled Jul 29, 1993 · Triennial form not returned · Harrison E Autry
- [N3AP](https://openairdocs.org/deregistered/N3AP-1989-01-20.md): Cessna 402B · S/N 402B0312 · Cancelled Jan 20, 1989 · Exported to Mexico · Ltd Air Inc
- [N2211E](https://openairdocs.org/deregistered/N2211E-1970-09-21.md): Aeronca 7AC · S/N 7AC-5785 · Cancelled Sep 21, 1970 · Stevens Irvin G
- [N97131](https://openairdocs.org/deregistered/N97131-1970-06-26.md): Universal Stinson 108 · S/N 108-131 · Cancelled Jun 26, 1970 · Dufreche Edward B

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

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