# Cancelled registrations: Bronx, NY

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

Cancelled aircraft registrations in Bronx, NY.

- [N3042Q](https://openairdocs.org/deregistered/N3042Q-2022-10-01.md): Yakovlev YAK-55M · S/N 920409 · Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Yana Brink
- [N22327](https://openairdocs.org/deregistered/N22327-2020-02-28.md): Aeronca 50-C · S/N C3299 · Cancelled Feb 28, 2020 · Revoked, canceled · Built 1939 · Roth Milton
- [N8798P](https://openairdocs.org/deregistered/N8798P-2019-09-06.md): Piper PA-24-260 · S/N 24-4251 · Cancelled Sep 6, 2019 · Revoked, canceled · Built 1965 · Eriksen Robert
- [N7154R](https://openairdocs.org/deregistered/N7154R-2019-05-04.md): Piper PA-28-140 · S/N 28-21861 · Cancelled May 4, 2019 · Registration expired, pending cancellation · Built 1966 · Johnson Janice K
- [N4392E](https://openairdocs.org/deregistered/N4392E-2019-04-17.md): Aeronca 7DC · S/N 7DC-47 · Cancelled Apr 17, 2019 · Registration expired, pending cancellation · Built 1948 · Johnson Janice K
- [N7060C](https://openairdocs.org/deregistered/N7060C-2018-03-16.md): Piper PA-34-200T · S/N 34-7670084 · Cancelled Mar 16, 2018 · Registration expired, pending cancellation · Built 1975 · Urena Daisy Nis
- [N664NZ](https://openairdocs.org/deregistered/N664NZ-2018-02-05.md): 3D Robotics SOLO · S/N S111A5501940 · Cancelled Feb 5, 2018 · Sale reported, pending cancellation
- [N47229](https://openairdocs.org/deregistered/N47229-2017-11-18.md): Fairchild M-62A · S/N T435507 · Cancelled Nov 18, 2017 · Revoked, canceled · Built 1943 · Gerardi Angela
- [N19010](https://openairdocs.org/deregistered/N19010-2017-10-28.md): Cessna 150L · S/N 15074089 · Cancelled Oct 28, 2017 · Revoked, canceled · Built 1972 · April Stephanie Pastor
- [N40868](https://openairdocs.org/deregistered/N40868-2014-07-09.md): Piper PA-28-140 · S/N 28-7425181 · Cancelled Jul 9, 2014 · Exported to Philippines · Built 1973 · Gorospe Glenn
- [N457TM](https://openairdocs.org/deregistered/N457TM-2013-11-08.md): Boeing 737-214 · S/N 20156 · Cancelled Nov 8, 2013 · Registration expired, pending cancellation · Built 1969 · Transamerican Inc
- [N78MF](https://openairdocs.org/deregistered/N78MF-2013-10-25.md): Martin Beresford HA-2M SPORTSTER · S/N BSF-73 · Cancelled Oct 25, 2013 · Registration expired, pending cancellation · Built 1980 · Martin Beresford G
- [N523AA](https://openairdocs.org/deregistered/N523AA-2013-09-19.md): Beech 60 · S/N P-31 · Cancelled Sep 19, 2013 · Sale reported, canceled · Built 1968
- [N6264K](https://openairdocs.org/deregistered/N6264K-2013-08-05.md): Republic RC-3 · S/N 474 · Cancelled Aug 5, 2013 · Revoked, canceled · Built 1947 · Mccormack Owen J Jr
- [N4709Q](https://openairdocs.org/deregistered/N4709Q-2013-07-30.md): Cessna 170A · S/N 20018 · Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1951 · Folchi Arthur
- [N11TN](https://openairdocs.org/deregistered/N11TN-2013-06-07.md): Beech B90 · S/N LJ-419 · Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1968 · M&C Aviation Inc
- [N4921T](https://openairdocs.org/deregistered/N4921T-2012-12-18.md): Cessna 411 · S/N 411-0121 · Cancelled Dec 18, 2012 · Registration expired, pending cancellation · Built 1965 · Vazquez Avan
- [N61381](https://openairdocs.org/deregistered/N61381-2012-08-30.md): Cessna T-50 · S/N 6159 · Cancelled Aug 30, 2012 · Revoked, canceled · Built 1943 · Christensen Maurice
- [N9932M](https://openairdocs.org/deregistered/N9932M-2011-05-03.md): Emroth-Emair MA-1B · S/N 032 · Cancelled May 3, 2011 · Registration pending, pending cancellation · Built 1977
- [N34473](https://openairdocs.org/deregistered/N34473-2010-12-16.md): Aeronca 65-CA · S/N CA15101 · Cancelled Dec 16, 2010 · Revoked, pending cancellation · Built 1941 · Luciano Alfred P
- [N5282Z](https://openairdocs.org/deregistered/N5282Z-2002-01-31.md): Cessna 182P · S/N 18262747 · Cancelled Jan 31, 2002 · Exported to Tanzania · 182 Flight Corp
- [N3221Q](https://openairdocs.org/deregistered/N3221Q-1997-12-10.md): Cessna 401 · S/N 4010021 · Cancelled Dec 10, 1997 · Exported to Dominican Republic · Milagros Felix
- [N2617A](https://openairdocs.org/deregistered/N2617A-1984-01-10.md): Beech V35A · S/N D-9053 · Cancelled Jan 10, 1984 · Administratively canceled · T C A Aviation Corp
- [N72180](https://openairdocs.org/deregistered/N72180-1982-03-03.md): Cessna 337G · S/N 33701536 · Cancelled Mar 3, 1982 · Exported to Gambia · Brown Louis Jr
- [N77958](https://openairdocs.org/deregistered/N77958-1974-04-08.md): Luscombe 8F · S/N 3685 · Cancelled Apr 8, 1974 · Aquaflights Inc
- [N55658](https://openairdocs.org/deregistered/N55658-1971-07-14.md): Piper J5A · S/N 5-1414 · Cancelled Jul 14, 1971 · Zeidler Donald W/ Casey George E
- [N9167H](https://openairdocs.org/deregistered/N9167H-1971-02-24.md): Fairchild M-62 · S/N FW921 · Cancelled Feb 24, 1971 · Hoyer George R
- [N30824](https://openairdocs.org/deregistered/N30824-1959-11-09.md): Piper J3C-65S · S/N 5128 · Cancelled Nov 9, 1959 · Exported to Canada · Built 1940 · Hueber Charles Schellhorn Edward
- [N4168H](https://openairdocs.org/deregistered/N4168H-1958-04-22.md): Piper PA-15 · S/N 15-50 · Cancelled Apr 22, 1958 · Exported to Germany · Giebelhaus Charles
- [N18815](https://openairdocs.org/deregistered/N18815-1956-02-20.md): Aeronca K · S/N K-82 · Cancelled Feb 20, 1956 · Built 1937 · Mack Louis
- [N36942](https://openairdocs.org/deregistered/N36942-1956-02-20.md): Aeronca 65-TAC · S/N C2491TA · Cancelled Feb 20, 1956 · Leitz Kenneth R
- [N87590](https://openairdocs.org/deregistered/N87590-1955-09-14.md): Republic RC-3 · S/N 159 · Cancelled Sep 14, 1955 · Exported to Canada · Starza Roland La
- [N1062K](https://openairdocs.org/deregistered/N1062K-1954-11-24.md): Luscombe 8A · S/N 3789 · Cancelled Nov 24, 1954 · Surburban Air Service Inc
- [N8806H](https://openairdocs.org/deregistered/N8806H-1950-12-14.md): North American NAVION · S/N NAV-4-806 · Cancelled Dec 14, 1950 · Tri Boro Elevator Co
- [N92019](https://openairdocs.org/deregistered/N92019-1949-10-27.md): Piper J3C-65 · S/N 16452 · Cancelled Oct 27, 1949 · Terminello Ernest V
- [N16280](https://openairdocs.org/deregistered/N16280-1941-09-28.md): Aeronca LB · S/N 2025 · Cancelled Sep 28, 1941 · Weiland Francis John
- [N564N](https://openairdocs.org/deregistered/N564N-1940-12-18.md): Curtiss Wright ROBIN 4C-1A · S/N 714 · Cancelled Dec 18, 1940 · Herfurtner John
- [N71K](https://openairdocs.org/deregistered/N71K-1933-02-09.md): Heath HEATH PARASOL · S/N A-1-B · Cancelled Feb 9, 1933 · Built 1930 · Pageau Charles Henry
- [N3112](https://openairdocs.org/deregistered/N3112-1928-05-19.md): Curtiss JN4C · S/N 3112 · Cancelled May 19, 1928 · Mark Brann
- [N745](https://openairdocs.org/deregistered/N745-undated.md): Curtiss JN4D · S/N M4017 · Cancellation date not recorded · Blossner Ben

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

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