# Cancelled registrations: Purchase, NY

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

Cancelled aircraft registrations in Purchase, NY.

- [N492CS](https://openairdocs.org/deregistered/N492CS-2019-11-29.md): Boeing 747-400SF · S/N 27173 · Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Atlas Air Inc
- [N323CM](https://openairdocs.org/deregistered/N323CM-2019-10-25.md): Raytheon 390 · S/N RB-22 · Cancelled Oct 25, 2019 · Sale reported, canceled · Built 2001
- [N38658](https://openairdocs.org/deregistered/N38658-2019-07-31.md): Piper PA-28R-201 · S/N 28R-7737106 · Cancelled Jul 31, 2019 · Westchester Flying Club Inc
- [N355MC](https://openairdocs.org/deregistered/N355MC-2018-03-22.md): Boeing 747-341 · S/N 23395 · Cancelled Mar 22, 2018 · Registration expired, pending cancellation · Built 1985 · Atlas Air Inc
- [N537MC](https://openairdocs.org/deregistered/N537MC-2017-07-18.md): Boeing 747-271C · S/N 22403 · Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Built 1981 · Atlas Air Inc
- [N526MC](https://openairdocs.org/deregistered/N526MC-2017-07-07.md): Boeing 747-2D7B · S/N 22337 · Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1980 · Atlas Air Inc
- [N472MC](https://openairdocs.org/deregistered/N472MC-2015-08-26.md): Boeing 747-430 · S/N 24288 · Cancelled Aug 26, 2015 · Atlas Air Inc
- [N4PC](https://openairdocs.org/deregistered/N4PC-2015-05-14.md): Arbc Inc DBA Lindstrand SPHERE-105 · S/N 5167 · Cancelled May 14, 2015 · Registration expired · Built 2003 · Pepsi Cola Co
- [N224PC](https://openairdocs.org/deregistered/N224PC-2013-11-14.md): Thunder & Colt Airborne Amer COLT 69A · S/N 2051USA · Cancelled Nov 14, 2013 · Built 1991 · Pepsi Cola Co
- [N242PC](https://openairdocs.org/deregistered/N242PC-2013-11-14.md): Arbc Inc DBA Lindstrand 77A · S/N 5166 · Cancelled Nov 14, 2013 · Built 2001 · Pepsi Cola Co
- [N698PC](https://openairdocs.org/deregistered/N698PC-2013-11-14.md): Lindstrand Balloons LBL DRINKS CAN · S/N 532 · Cancelled Nov 14, 2013 · Built 1998 · Pepsi-Cola Company
- [N32WE](https://openairdocs.org/deregistered/N32WE-2013-06-04.md): Israel Aircraft Industries 1123 · S/N 164 · Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Built 1974 · International Exec Acft Corp
- [N528MC](https://openairdocs.org/deregistered/N528MC-2013-04-30.md): Boeing 747-2D7B · S/N 22472 · Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1984 · Atlas Air Inc
- [N1924N](https://openairdocs.org/deregistered/N1924N-2013-04-16.md): Boeing 747-SR-81 · S/N 21924 · Cancelled Apr 16, 2013 · Registration expired, pending cancellation · Atlas Air Inc
- [N517MC](https://openairdocs.org/deregistered/N517MC-2013-03-12.md): Boeing 747-243B · S/N 23300 · Cancelled Mar 12, 2013 · Built 1985 · Atlas Air Inc
- [N8519M](https://openairdocs.org/deregistered/N8519M-2013-01-03.md): Beech 35-B33 · S/N CD-628 · Cancelled Jan 3, 2013 · Built 1963 · Westchester Flying Club
- [N540MC](https://openairdocs.org/deregistered/N540MC-2011-09-30.md): Boeing 747-243B · S/N 22508 · Cancelled Sep 30, 2011 · Triennial form not returned · Built 1980 · Atlas Air Inc
- [N512MC](https://openairdocs.org/deregistered/N512MC-2011-06-06.md): Boeing 747-230B · S/N 21220 · Cancelled Jun 6, 2011 · Built 1976 · Atlas Air Inc
- [N505MC](https://openairdocs.org/deregistered/N505MC-2010-11-29.md): Boeing 747-2D3B · S/N 21251 · Cancelled Nov 29, 2010 · Triennial form not returned · Built 1976 · Atlas Air Inc
- [N506MC](https://openairdocs.org/deregistered/N506MC-2010-11-29.md): Boeing 747-2D3B · S/N 21252 · Cancelled Nov 29, 2010 · Built 1976 · Atlas Air Inc
- [N809MC](https://openairdocs.org/deregistered/N809MC-2010-11-08.md): Boeing 747-228F · S/N 20887 · Cancelled Nov 8, 2010 · Triennial form not returned · Built 1974 · Atlas Air Inc
- [N527MC](https://openairdocs.org/deregistered/N527MC-2008-09-19.md): Boeing 747-2D7B · S/N 22471 · Cancelled Sep 19, 2008 · Built 1981 · Atlas Air Inc
- [N55003](https://openairdocs.org/deregistered/N55003-2007-06-20.md): Piper PA-28R-200 · S/N 28R-7335166 · Cancelled Jun 20, 2007 · Triennial form not returned · Built 1973 · Westchester Flying Club Inc
- [N3998Q](https://openairdocs.org/deregistered/N3998Q-1994-05-20.md): Cessna U206F · S/N U20603039 · Cancelled May 20, 1994 · Exported to Kenya · Banks David F
- [N26DW](https://openairdocs.org/deregistered/N26DW-1994-02-21.md): Piper PA-28R-200 · S/N 28R7535042 · Cancelled Feb 21, 1994 · Triennial form not returned · Westchester Flying Club
- [N56959](https://openairdocs.org/deregistered/N56959-1993-01-14.md): Piper PA-28-151 · S/N 287415028 · Cancelled Jan 14, 1993 · Triennial form not returned · Westchester Flying Club

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

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