# Cancelled registrations: Batavia, NY

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

Cancelled aircraft registrations in Batavia, NY.

- [N37918](https://openairdocs.org/deregistered/N37918-2020-01-31.md): Zuczuski FCW-4 · S/N 41004 · Cancelled Jan 31, 2020 · Registration expired, pending cancellation · Built 1978 · Zuczuski Raymond F
- [N648LP](https://openairdocs.org/deregistered/N648LP-2018-02-20.md): Six Chuter SKYE RYDER SR7 · S/N 98-1842-2 · Cancelled Feb 20, 2018 · Registration expired, pending cancellation · Built 1997 · Piacente Louis F
- [N69VZ](https://openairdocs.org/deregistered/N69VZ-2018-01-24.md): Vanzwoll Dean C VIKING · S/N 1 · Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1990 · Aubrey Leeann
- [N27851](https://openairdocs.org/deregistered/N27851-2017-10-28.md): Piper J4A · S/N 41072 · Cancelled Oct 28, 2017 · Revoked, pending cancellation · Built 1940 · Plummer Frank H
- [N3251M](https://openairdocs.org/deregistered/N3251M-2017-10-26.md): Aubrey Robert William AUBREY SPECIAL · S/N 44 · Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Aubrey Robert William
- [N525PZ](https://openairdocs.org/deregistered/N525PZ-2017-03-07.md): Textron 525C · S/N 525C0196 · Cancelled Mar 7, 2017 · Built 2015 · Zeliff Aviation LLC
- [N525D](https://openairdocs.org/deregistered/N525D-2015-05-19.md): Piper PA-23-250 · S/N 27-3355 · Cancelled May 19, 2015 · Registration expired, pending cancellation · Johnson Air Inc
- [N6878D](https://openairdocs.org/deregistered/N6878D-2014-09-10.md): Dehavilland VAMPIRE MK-3 · S/N 17072 · Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1947 · Wings Of Flight Inc
- [N683V](https://openairdocs.org/deregistered/N683V-2013-10-24.md): Curtiss Wright JR CW1 · S/N 1065 · Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1931 · Gooshaw Ralph
- [N9087U](https://openairdocs.org/deregistered/N9087U-2013-08-08.md): Marquette Darrell VARIEZE · S/N 492 · Cancelled Aug 8, 2013 · Sale reported, canceled · Built 1995
- [N25042](https://openairdocs.org/deregistered/N25042-2005-06-10.md): Cessna 152 · S/N 15280513 · Cancelled Jun 10, 2005 · Exported to Poland · Built 1977 · Great Lakes Aviation Inc
- [N912WD](https://openairdocs.org/deregistered/N912WD-2002-01-24.md): Dominiak William P KITFOX VIXEN · S/N ICV018 · Cancelled Jan 24, 2002 · Built 1997 · Upson Hollis D
- [N88222](https://openairdocs.org/deregistered/N88222-2000-06-30.md): Hartrick/Tarkington AMERICAN EAGLET · S/N 377 · Cancelled Jun 30, 2000 · Tarkington Dean
- [N2832](https://openairdocs.org/deregistered/N2832-1997-09-30.md): Strong Mitchell S Q 200 · S/N 2835 · Cancelled Sep 30, 1997 · Triennial form not returned · Strong Mitchell S
- [N3805](https://openairdocs.org/deregistered/N3805-1975-08-28.md): Allen BALLOON #1 · S/N A-128 · Cancelled Aug 28, 1975 · Built 1974 · Allen Edward B
- [N45758](https://openairdocs.org/deregistered/N45758-1970-06-24.md): Luscombe 8A · S/N 2285 · Cancelled Jun 24, 1970 · Gerald E Claflin
- [N7647H](https://openairdocs.org/deregistered/N7647H-1970-02-18.md): Piper PA-12 · S/N 12-526 · Cancelled Feb 18, 1970 · Exported to Canada · Taggert Elmer
- [N23250](https://openairdocs.org/deregistered/N23250-1960-12-13.md): Piper J4 · S/N 4-563 · Cancelled Dec 13, 1960 · Exported to Canada · Taggert Elmer
- [N2771M](https://openairdocs.org/deregistered/N2771M-1960-05-25.md): Piper PA-12 · S/N 12-1150 · Cancelled May 25, 1960 · Built 1947 · Taggert Elmer
- [N2259M](https://openairdocs.org/deregistered/N2259M-1960-05-21.md): Piper J3C-65 · S/N 21054 · Cancelled May 21, 1960 · Built 1946 · Batavia Aviation
- [N9273H](https://openairdocs.org/deregistered/N9273H-1960-05-21.md): Fairchild M-62A-3 · S/N FV-395 · Cancelled May 21, 1960 · Sands E
- [N60253](https://openairdocs.org/deregistered/N60253-1955-09-23.md): Boeing A75N1 · S/N 75-1644 · Cancelled Sep 23, 1955 · Exported to El Salvador · Harloff Leona M
- [N51669](https://openairdocs.org/deregistered/N51669-1955-01-06.md): Fairchild M-62A · S/N T41-1037 · Cancelled Jan 6, 1955 · Rase Jack F
- [N2379V](https://openairdocs.org/deregistered/N2379V-1952-06-13.md): Cessna 140 · S/N 14616 · Cancelled Jun 13, 1952 · Locke William Jr
- [N16308](https://openairdocs.org/deregistered/N16308-1948-04-28.md): Piper J-2 · S/N 541 · Cancelled Apr 28, 1948 · Taggert Elmer A Etal

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

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