# Cancelled registrations: Tonawanda, NY

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

Cancelled aircraft registrations in Tonawanda, NY.

- [N4578H](https://openairdocs.org/deregistered/N4578H-2020-01-09.md): Piper PA-15 · S/N 15-352 · Cancelled Jan 9, 2020 · Revoked, pending cancellation · Built 1948 · Maunz Don L
- [N51924](https://openairdocs.org/deregistered/N51924-2019-08-02.md): Fairchild M-62A · S/N T423965 · Cancelled Aug 2, 2019 · Revoked, canceled · Built 1943 · Fry Wesley W Sr
- [N87480](https://openairdocs.org/deregistered/N87480-2017-02-04.md): Republic RC-3 · S/N 30 · Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Baker Ray
- [N50200](https://openairdocs.org/deregistered/N50200-2013-09-30.md): Cessna 150H · S/N 15069130 · Cancelled Sep 30, 2013 · Registration expired, pending cancellation · Built 1968 · Clark James K
- [N9783J](https://openairdocs.org/deregistered/N9783J-2013-07-29.md): Piper PA-28-180 · S/N 28-3984 · Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Built 1967 · Sagehorn David Ml
- [N3LD](https://openairdocs.org/deregistered/N3LD-2013-04-15.md): Dreyer STARDUSTER SA300 · S/N 1145 · Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1976 · Promise Recording Inc
- [N17BB](https://openairdocs.org/deregistered/N17BB-2012-07-24.md): Picotte HOME BUILT EXPERIMEN · S/N 1 · Cancelled Jul 24, 2012 · Sale reported, canceled · Built 1970
- [N3344A](https://openairdocs.org/deregistered/N3344A-2011-08-16.md): Beech N35 · S/N D-6733 · Cancelled Aug 16, 2011 · Triennial form not returned · Built 1961 · L & K Practical Solutions Inc
- [N3444V](https://openairdocs.org/deregistered/N3444V-2010-12-16.md): Cessna 190 · S/N 7134 · Cancelled Dec 16, 2010 · Revoked, pending cancellation · Built 1948 · Dudnelly Cecil
- [N2075](https://openairdocs.org/deregistered/N2075-2009-07-13.md): Semco Balloon TC-4 · S/N SEM18 · Cancelled Jul 13, 2009 · Registration revoked · Built 1968 · Hayes Peter C
- [N1274](https://openairdocs.org/deregistered/N1274-1996-09-19.md): Westland LYSANDERIIIA · S/N 1202 · Cancelled Sep 19, 1996 · Exported to Canada · Friends Of Canadian Warplane Heritag
- [N30155](https://openairdocs.org/deregistered/N30155-1991-05-07.md): Cessna 177 · S/N 17701084 · Cancelled May 7, 1991 · Triennial form not returned · Tota Conrad C
- [N7003D](https://openairdocs.org/deregistered/N7003D-1984-09-24.md): Piper PA-22-150 · S/N 224896 · Cancelled Sep 24, 1984 · Exported to Canada · Mccarriagher Donald J
- [N5394R](https://openairdocs.org/deregistered/N5394R-1977-07-08.md): Cessna 172F · S/N 17252931 · Cancelled Jul 8, 1977 · Wilson Francis L
- [N3239](https://openairdocs.org/deregistered/N3239-1973-11-07.md): Stoneberg GYG-20 · S/N GERKEN-125 · Cancelled Nov 7, 1973 · Stoneberg Kenneth C
- [N9169E](https://openairdocs.org/deregistered/N9169E-1970-09-09.md): Aeronca 11AC · S/N 11AC-804 · Cancelled Sep 9, 1970 · Bison Flying Association Inc
- [N8719C](https://openairdocs.org/deregistered/N8719C-1968-12-10.md): Piper PA-22-135 · S/N 22-1376 · Cancelled Dec 10, 1968 · Exported to Canada · Charles G Wilken
- [N6369K](https://openairdocs.org/deregistered/N6369K-1965-07-26.md): Republic Aviation Corp USA SEABEE RC-3 · S/N 598 · Cancelled Jul 26, 1965 · Schoultz Harold Theodore
- [N2981K](https://openairdocs.org/deregistered/N2981K-1960-05-24.md): Luscombe 8A · S/N 5708 · Cancelled May 24, 1960 · Kowalski John Peter
- [N79547](https://openairdocs.org/deregistered/N79547-1956-02-21.md): Cessna T-50 · S/N 2797 · Cancelled Feb 21, 1956 · Built 1943 · Weber Harry W
- [N22743](https://openairdocs.org/deregistered/N22743-1955-03-28.md): Piper J4A · S/N 4-443 · Cancelled Mar 28, 1955 · Built 1939 · Smith Lee N
- [N6736K](https://openairdocs.org/deregistered/N6736K-1947-11-17.md): Republic RC-3 · S/N 1024 · Cancelled Nov 17, 1947 · Tonawandas Distributing Corp
- [N49518](https://openairdocs.org/deregistered/N49518-1946-07-25.md): Aeronca 0-58B · S/N 058B-8403 · Cancelled Jul 25, 1946 · Mutal Aviation Inc
- [N49519](https://openairdocs.org/deregistered/N49519-1946-07-25.md): Aeronca 0-58B · S/N 8543 · Cancelled Jul 25, 1946 · Mutual Aviation Inc
- [N49520](https://openairdocs.org/deregistered/N49520-1946-07-25.md): Aeronca 0-58B · S/N 8242 · Cancelled Jul 25, 1946 · Mutual Aviation Inc
- [N33444](https://openairdocs.org/deregistered/N33444-1943-05-03.md): Piper J3F-65 · S/N 5952 · Cancelled May 3, 1943 · Niagara From The Air Inc
- [N452M](https://openairdocs.org/deregistered/N452M-1943-05-03.md): Verville AT · S/N 3 · Cancelled May 3, 1943 · Richard K Benson
- [N11149](https://openairdocs.org/deregistered/N11149-1936-05-09.md): Great Lakes 2T-1A · S/N 188 · Cancelled May 9, 1936 · Built 1931 · Miraglia Philip
- [N799V](https://openairdocs.org/deregistered/N799V-1932-07-01.md): Hugh G Nicholson JR KN-1 · S/N 1 · Cancelled Jul 1, 1932 · Hugh G Nicholson Jr
- [N80289](https://openairdocs.org/deregistered/N80289-undated.md): Culver V · S/N V-208 · Cancellation date not recorded · Franklin J Walker

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

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