# Earlier aircraft under this name: Castro Juan DBA

A list on [Castro Juan DBA](https://openairdocs.org/faa-owner/CASTRO%20JUAN%20DBA.md).

Cancelled registrations that named this owner when they ended, newest first.

- [N2216M](https://openairdocs.org/deregistered/N2216M-2016-01-12.md): Piper PA-28R-201T · S/N 28R-7803112 · Cancelled Jan 12, 2016 · Exported to Paraguay · Built 1977 · Lees Summit, MO
- [N904M](https://openairdocs.org/deregistered/N904M-2016-01-12.md): Cessna R172K · S/N R1722904 · Cancelled Jan 12, 2016 · Exported to Paraguay · Lees Summit, MO
- [N43FB](https://openairdocs.org/deregistered/N43FB-2015-09-14.md): Cessna 172RG · S/N 172RG0221 · Cancelled Sep 14, 2015 · Exported to Brazil · Built 1980 · Independence, MO
- [N6527Z](https://openairdocs.org/deregistered/N6527Z-2015-05-14.md): Piper PA-25-235 · S/N 25-2060 · Cancelled May 14, 2015 · Exported to Argentina · Built 1962 · Lees Summit, MO
- [N498YQ](https://openairdocs.org/deregistered/N498YQ-2015-02-09.md): Cessna 421B · S/N 421B0207 · Cancelled Feb 9, 2015 · Exported to Mexico · Built 1972 · Lees Summit, MO
- [N457TG](https://openairdocs.org/deregistered/N457TG-2014-03-28.md): Piper PA-31T · S/N 31T8020059 · Cancelled Mar 28, 2014 · Exported to Mexico · Built 1980 · Lees Summit, MO
- [N210MG](https://openairdocs.org/deregistered/N210MG-2014-03-24.md): Cessna T210L · S/N 21060838 · Cancelled Mar 24, 2014 · Exported to Mexico · Built 1975 · Lees Summit, MO
- [N761FW](https://openairdocs.org/deregistered/N761FW-2014-03-24.md): Cessna T210M · S/N 21062231 · Cancelled Mar 24, 2014 · Exported to Brazil · Built 1977 · Lees Summit, MO
- [N8611Z](https://openairdocs.org/deregistered/N8611Z-2013-11-06.md): Cessna TP206B · S/N P206-0411 · Cancelled Nov 6, 2013 · Exported to Bolivia · Built 1967 · Lees Summit, MO
- [N5078L](https://openairdocs.org/deregistered/N5078L-2013-05-30.md): Beech 65 · S/N LF-69 · Cancelled May 30, 2013 · Exported to Mexico · Built 1962 · Lees Summit, MO
- [N975GT](https://openairdocs.org/deregistered/N975GT-2013-03-20.md): Cessna 172RG · S/N 172RG1013 · Cancelled Mar 20, 2013 · Exported to Brazil · Built 1981 · Independence, MO
- [N12TL](https://openairdocs.org/deregistered/N12TL-2013-01-29.md): Cessna TU206G · S/N U20606464 · Cancelled Jan 29, 2013 · Exported to Mexico · Built 1981 · Lees Summit, MO
- [N735JY](https://openairdocs.org/deregistered/N735JY-2012-02-17.md): Cessna TU206G · S/N U20604932 · Cancelled Feb 17, 2012 · Exported to Mexico · Built 1979 · Lees Summit, MO
- [N713RC](https://openairdocs.org/deregistered/N713RC-2012-02-16.md): Cessna T210L · S/N 21061463 · Cancelled Feb 16, 2012 · Exported to Mexico · Built 1976 · Lees Summit, MO
- [N9880Z](https://openairdocs.org/deregistered/N9880Z-2012-02-16.md): Cessna U206G · S/N U20606725 · Cancelled Feb 16, 2012 · Exported to Mexico · Built 1983 · Lees Summit, MO
- [N27803](https://openairdocs.org/deregistered/N27803-2012-01-30.md): Piper PA-31-350 · S/N 31-7852158 · Cancelled Jan 30, 2012 · Exported to Paraguay · Built 1978 · Lees Summit, MO
- [N731EZ](https://openairdocs.org/deregistered/N731EZ-2011-10-21.md): Cessna P210N · S/N P21000449 · Cancelled Oct 21, 2011 · Exported to Paraguay · Built 1979 · Lees Summit, MO

## 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_name = 'CASTRO JUAN DBA' OR list_contains(d.other_registrant_names, 'CASTRO JUAN DBA')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-owner/CASTRO%20JUAN%20DBA/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, except the copies of manufacturers’ service documents, which belong to their rights holders.