# Cancelled registrations: Syosset, NY

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

Cancelled aircraft registrations in Syosset, NY.

- [N600VP](https://openairdocs.org/deregistered/N600VP-2018-03-14.md): Beech 95-B55 · S/N TC-1805 · Cancelled Mar 14, 2018 · Registration expired, pending cancellation · Built 1974 · Ls Express LLC
- [N62288](https://openairdocs.org/deregistered/N62288-2012-02-21.md): Cessna 172S · S/N 172S10696 · Cancelled Feb 21, 2012 · Exported to South Korea · Built 2008 · Mjh Services LLC
- [N4218N](https://openairdocs.org/deregistered/N4218N-2012-02-09.md): Robinson Helicopter R66 · S/N 0036 · Cancelled Feb 9, 2012 · Exported to Brazil · Built 2011 · Trans America Group LLC
- [N6322C](https://openairdocs.org/deregistered/N6322C-2012-01-04.md): Piper PA-28R-201T · S/N 28R-7803218 · Cancelled Jan 4, 2012 · Exported to Brazil · Built 1978 · Trans America Group LLC
- [N4763V](https://openairdocs.org/deregistered/N4763V-2011-09-23.md): Boeing E75 · S/N 75-5445 · Cancelled Sep 23, 2011 · Exported to Brazil · Built 1942 · Trans America Group LLC
- [N56770](https://openairdocs.org/deregistered/N56770-2011-05-17.md): Piper PA-34-200 · S/N 34-7450030 · Cancelled May 17, 2011 · Second renewal notice · Stracar Miro
- [N17835](https://openairdocs.org/deregistered/N17835-2011-01-24.md): Beech V35B · S/N D-10016 · Cancelled Jan 24, 2011 · Exported to Brazil · Built 1977 · Trans America Group LLC
- [N214S](https://openairdocs.org/deregistered/N214S-2010-12-17.md): Raytheon 58 · S/N TH-1844 · Cancelled Dec 17, 2010 · Exported to Brazil · Built 1998 · Trans America Group LLC
- [N877JL](https://openairdocs.org/deregistered/N877JL-2010-11-01.md): Beech 58 · S/N TH-2054 · Cancelled Nov 1, 2010 · Exported to Brazil · Trans America Group LLC
- [N630P](https://openairdocs.org/deregistered/N630P-2010-10-27.md): Cessna 182T · S/N 18281406 · Cancelled Oct 27, 2010 · Exported to Brazil · Built 2004 · Trans America Group LLC
- [N5200J](https://openairdocs.org/deregistered/N5200J-2010-10-21.md): Cessna 402B · S/N 402B0887 · Cancelled Oct 21, 2010 · Exported to Brazil · Built 1975 · Trans America Group LLC
- [N777YY](https://openairdocs.org/deregistered/N777YY-2010-07-27.md): Beech F33A · S/N CE-1590 · Cancelled Jul 27, 2010 · Exported to Brazil · Built 1991 · Trans America Group LLC
- [N20984](https://openairdocs.org/deregistered/N20984-2010-07-26.md): Cessna 172S · S/N 172S10014 · Cancelled Jul 26, 2010 · Exported to Brazil · Built 2005 · Trans America Group LLC
- [N55TK](https://openairdocs.org/deregistered/N55TK-2010-07-20.md): Beech 95-B55 (T42A) · S/N TC-2336 · Cancelled Jul 20, 2010 · Exported to Brazil · Built 1980 · Trans America Group LLC
- [N618B](https://openairdocs.org/deregistered/N618B-2010-07-20.md): Cessna 310R · S/N 310R1232 · Cancelled Jul 20, 2010 · Exported to Brazil · Trans America Group LLC
- [N6833Y](https://openairdocs.org/deregistered/N6833Y-2010-07-20.md): Cessna 310R · S/N 310R2130 · Cancelled Jul 20, 2010 · Exported to Brazil · Built 1981 · Trans America Group LLC
- [N872JC](https://openairdocs.org/deregistered/N872JC-2010-07-20.md): Raytheon 58 · S/N TH-2043 · Cancelled Jul 20, 2010 · Exported to Brazil · Built 2002 · Trans America Group LLC
- [N876JK](https://openairdocs.org/deregistered/N876JK-2010-07-20.md): Beech 58 · S/N TH-2053 · Cancelled Jul 20, 2010 · Exported to Brazil · Trans America Group LLC
- [N86BF](https://openairdocs.org/deregistered/N86BF-2010-05-26.md): Raytheon A36 · S/N E-3315 · Cancelled May 26, 2010 · Exported to Brazil · Built 2000 · Trans America Group LLC
- [N50NL](https://openairdocs.org/deregistered/N50NL-2010-04-28.md): Raytheon 58 · S/N TH1885 · Cancelled Apr 28, 2010 · Exported to Brazil · Built 1999 · Trans America Group LLC
- [N78226](https://openairdocs.org/deregistered/N78226-1992-11-30.md): Universal GLOBE GC-1B · S/N 2226 · Cancelled Nov 30, 1992 · Triennial form not returned · Sharp William A
- [N7212](https://openairdocs.org/deregistered/N7212-1981-10-19.md): Ryan B1 · S/N 159 · Cancelled Oct 19, 1981 · Built 1928 · Friends Of Nassau County Museum
- [N86017](https://openairdocs.org/deregistered/N86017-1970-06-16.md): Aeronca 11AC · S/N 11AC432 · Cancelled Jun 16, 1970 · Orrin Dayton
- [N1119E](https://openairdocs.org/deregistered/N1119E-1969-07-24.md): Aeronca 7AC · S/N 7AC-4674 · Cancelled Jul 24, 1969 · Exported to Ireland · Built 1946 · Boyle Richard P
- [N1204M](https://openairdocs.org/deregistered/N1204M-1952-01-21.md): Howard DGA-15P · S/N 852 · Cancelled Jan 21, 1952 · Built 1943 · Specialities Inc
- [N34796](https://openairdocs.org/deregistered/N34796-1948-08-17.md): Culver LFA · S/N 255 · Cancelled Aug 17, 1948 · Stone Charles Lynn
- [N14044](https://openairdocs.org/deregistered/N14044-1938-04-02.md): Waco UMF · S/N 3942 · Cancelled Apr 2, 1938 · Built 1934 · Laws E Langdon

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

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