# Cancelled registrations: Lagrange, GA

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

Cancelled aircraft registrations in Lagrange, GA.

- [N840LM](https://openairdocs.org/deregistered/N840LM-2020-07-10.md): Mason Lion G JR PIETENPOL · S/N 001 · Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Built 2010 · Mason Lion G Jr
- [N5764E](https://openairdocs.org/deregistered/N5764E-2020-03-13.md): Mooney M20J · S/N 24-1476 · Cancelled Mar 13, 2020 · Registration pending, canceled · Built 1984
- [N72JK](https://openairdocs.org/deregistered/N72JK-2018-08-28.md): Beech F33A · S/N CE-1376 · Cancelled Aug 28, 2018 · Registration pending, canceled · Built 1989
- [N5250B](https://openairdocs.org/deregistered/N5250B-2016-11-28.md): Cessna 152 · S/N 15283816 · Cancelled Nov 28, 2016 · Built 1979 · West Georgia Airservices Inc
- [N14YA](https://openairdocs.org/deregistered/N14YA-2013-11-12.md): Let BLANIK L-13 · S/N 025318 · Cancelled Nov 12, 2013 · Built 1972 · Southern Eagles Soaring Inc
- [N44070](https://openairdocs.org/deregistered/N44070-2013-02-07.md): MC Lain James E TERATORN TIERRA II · S/N 33446 · Cancelled Feb 7, 2013 · Registration expired, pending cancellation · Built 1983 · Ware Phillip R
- [N180KH](https://openairdocs.org/deregistered/N180KH-2003-12-12.md): Piper PA-28-180 · S/N 28-3830 · Cancelled Dec 12, 2003 · Triennial form not returned · Built 1966 · Troup County Airport Authority
- [N2276J](https://openairdocs.org/deregistered/N2276J-2000-10-06.md): Cessna 150G · S/N 15065476 · Cancelled Oct 6, 2000 · Triennial form not returned · Cuitjens Jacob J
- [N9317L](https://openairdocs.org/deregistered/N9317L-1999-11-24.md): American AA-1A · S/N AA1A-0017 · Cancelled Nov 24, 1999 · Triennial form not returned · Newman Henry
- [N7181R](https://openairdocs.org/deregistered/N7181R-1998-08-17.md): Piper PA-28-140 · S/N 2821893 · Cancelled Aug 17, 1998 · Triennial form not returned · Richards Jack B
- [N7503J](https://openairdocs.org/deregistered/N7503J-1991-11-13.md): Piper PA-28R-180 · S/N 28R30867 · Cancelled Nov 13, 1991 · Triennial form not returned · Parmer Roger K DBA
- [N6680Y](https://openairdocs.org/deregistered/N6680Y-1982-01-29.md): Piper PA-23-250 · S/N 274000 · Cancelled Jan 29, 1982 · Exported to Canada · Mcdonald Oil Co Inc
- [N98955](https://openairdocs.org/deregistered/N98955-1971-07-20.md): Piper PA-12 · S/N 12-310 · Cancelled Jul 20, 1971 · Chastain Marie
- [N77355](https://openairdocs.org/deregistered/N77355-1955-10-31.md): Cessna 120 · S/N 11796 · Cancelled Oct 31, 1955 · Turner E B
- [N55794](https://openairdocs.org/deregistered/N55794-1952-01-16.md): North American SNJ-4 · S/N 88-9341 · Cancelled Jan 16, 1952 · Will E Morgan
- [N92135](https://openairdocs.org/deregistered/N92135-1949-06-01.md): Piper J3C-65 · S/N 16577 · Cancelled Jun 1, 1949 · Turner E B D/B/A Palmetto Air School

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

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