# Cancelled registrations: Rome, NY

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

Cancelled aircraft registrations in Rome, NY.

- [N824UD](https://openairdocs.org/deregistered/N824UD-2023-06-19.md): DJI MATRICE 100 · S/N M02DCG22020022 · Cancelled Jun 19, 2023 · County Of Oneida
- [N5140D](https://openairdocs.org/deregistered/N5140D-2022-11-09.md): Cessna 172N · S/N 17272433 · Cancelled Nov 9, 2022 · Exported to Canada · Built 1979 · Landcare Aviation Inc
- [N370JA](https://openairdocs.org/deregistered/N370JA-2022-08-01.md): Cessna 172S · S/N 172S8651 · Cancelled Aug 1, 2022 · Exported to Canada · Built 2000 · Landcare Aviation Inc
- [N51577](https://openairdocs.org/deregistered/N51577-2022-08-01.md): Cessna 172P · S/N 17274322 · Cancelled Aug 1, 2022 · Exported to Canada · Built 1980 · Landcare Aviation Inc
- [N725SP](https://openairdocs.org/deregistered/N725SP-2022-08-01.md): Cessna 172S · S/N 172S8662 · Cancelled Aug 1, 2022 · Exported to Canada · Built 2000 · Landcare Aviation Inc
- [N6521Y](https://openairdocs.org/deregistered/N6521Y-2021-03-11.md): Piper PA-23-250 · S/N 27-3812 · Cancelled Mar 11, 2021 · Registration expired, pending cancellation · Built 1967 · Landcare Aviation Inc
- [N30NC](https://openairdocs.org/deregistered/N30NC-2021-03-06.md): Lockheed Martin INDAGO 2 · S/N 3674 · Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Built 2016 · County Of Oneida
- [N821JG](https://openairdocs.org/deregistered/N821JG-2020-10-31.md): Precision Hawk LANCASTER MKIII REV5 · S/N PCN-OV6-201630-011-MSI-00 · Cancelled Oct 31, 2020 · Registration expired, pending cancellation · County Of Oneida
- [N824TB](https://openairdocs.org/deregistered/N824TB-2020-10-31.md): Birdseyeview Aerobotics FIREFLY 6 PRO · S/N 6-PRO-1336 · Cancelled Oct 31, 2020 · Registration expired, pending cancellation · County Of Oneida (Griffins International Airport)
- [N17367](https://openairdocs.org/deregistered/N17367-2018-03-23.md): Ryan Aeronautical ST-A · S/N 172 · Cancelled Mar 23, 2018 · Revoked, canceled · Tork George B
- [N834AC](https://openairdocs.org/deregistered/N834AC-2018-03-13.md): Boeing 747-400 · S/N 26556 · Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1996 · Midair Spares Inc
- [N125RD](https://openairdocs.org/deregistered/N125RD-2018-02-28.md): Boeing 767-383ER · S/N 24849 · Cancelled Feb 28, 2018 · Registration expired, pending cancellation · Midair Spares Inc
- [N21559](https://openairdocs.org/deregistered/N21559-2018-02-12.md): Piper J3C-65 · S/N 2407 · Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Built 1938 · Leskovar Richard
- [N6515D](https://openairdocs.org/deregistered/N6515D-2013-08-06.md): D Agostino ORBIT · S/N 1 · Cancelled Aug 6, 2013 · Revoked, canceled · Built 1961 · D Agostino William Carl
- [N6144P](https://openairdocs.org/deregistered/N6144P-2013-06-11.md): Groetz William O MERLIN · S/N A0015 · Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Palmer John F
- [N60283](https://openairdocs.org/deregistered/N60283-2013-02-26.md): Fairchild M-62A · S/N FV463 · Cancelled Feb 26, 2013 · Revoked, canceled · Built 1943 · Felice Anthony R
- [N2448J](https://openairdocs.org/deregistered/N2448J-2012-08-14.md): Cessna 150G · S/N 15065548 · Cancelled Aug 14, 2012 · Sale reported, canceled · Built 1966
- [N156D](https://openairdocs.org/deregistered/N156D-2012-08-08.md): Don B. Davidson DD MODEL B · S/N 3 · Cancelled Aug 8, 2012 · Registration expired, pending cancellation · Built 1962 · Davison Don B Jr
- [N16D](https://openairdocs.org/deregistered/N16D-2012-08-08.md): Don B. Davidson DD MODEL C · S/N 4 · Cancelled Aug 8, 2012 · Registration expired, pending cancellation · Built 1962 · Davidson Don B Jr
- [N747ZZ](https://openairdocs.org/deregistered/N747ZZ-2010-09-01.md): Boeing 747-338 · S/N 23222 · Cancelled Sep 1, 2010 · Triennial form not returned · Midair USA Inc
- [N6209Y](https://openairdocs.org/deregistered/N6209Y-2008-05-08.md): Piper PA-23-250 · S/N 27-3436 · Cancelled May 8, 2008 · Built 1966 · Landcare Aviation Inc
- [N17590](https://openairdocs.org/deregistered/N17590-1982-04-15.md): Beech F33A · S/N CE-694 · Cancelled Apr 15, 1982 · Administratively canceled · Felice Trucking Service Inc
- [N6514D](https://openairdocs.org/deregistered/N6514D-1977-01-21.md): Don B. Davidson DD MODEL A · S/N 1 · Cancelled Jan 21, 1977 · Davidson Don B Jr
- [N10409](https://openairdocs.org/deregistered/N10409-1975-03-19.md): Ryan NAVION · S/N NAV41712 · Cancelled Mar 19, 1975 · Griffins Afb Aero Club
- [N2784E](https://openairdocs.org/deregistered/N2784E-1971-08-31.md): Aeronca 7AC · S/N 7AC-6367 · Cancelled Aug 31, 1971 · Griffiss Afb Aero Club
- [N92491](https://openairdocs.org/deregistered/N92491-1971-01-06.md): Piper J3C-65S · S/N 16968 · Cancelled Jan 6, 1971 · Pisaneschi Bruno
- [N42327](https://openairdocs.org/deregistered/N42327-1965-05-20.md): Piper J3C-65 · S/N 14577 · Cancelled May 20, 1965 · Bandrosky Amo
- [N1800](https://openairdocs.org/deregistered/N1800-1929-05-17.md): Curtiss JN4H · S/N 363 · Cancelled May 17, 1929 · Arthur A Weber

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

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