# Earlier aircraft under this name: Ctc Aviation Leasing (US) Inc

A list on [Ctc Aviation Leasing (US) Inc](https://openairdocs.org/faa-owner/CTC%20AVIATION%20LEASING%20(US)%20INC.md).

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

- [N154BY](https://openairdocs.org/deregistered/N154BY-2018-12-21.md): Diamond Aircraft Ind DA 40 NG · S/N 40.N302 · Cancelled Dec 21, 2018 · Exported to United Kingdom · Goodyear, AZ
- [N910XD](https://openairdocs.org/deregistered/N910XD-2018-12-21.md): Diamond Aircraft Ind DA 40 NG · S/N 40.N303 · Cancelled Dec 21, 2018 · Exported to United Kingdom · Goodyear, AZ
- [N386AP](https://openairdocs.org/deregistered/N386AP-2018-07-10.md): Diamond Aircraft Ind DA 40 NG · S/N 40.N225 · Cancelled Jul 10, 2018 · Exported to United Kingdom · Built 2014 · Goodyear, AZ
- [N528MH](https://openairdocs.org/deregistered/N528MH-2018-07-10.md): Diamond Aircraft Ind DA 40 NG · S/N 40.N224 · Cancelled Jul 10, 2018 · Exported to United Kingdom · Built 2014 · Goodyear, AZ
- [N539TS](https://openairdocs.org/deregistered/N539TS-2018-06-25.md): Diamond Aircraft Ind DA 40 NG · S/N 40.N188 · Cancelled Jun 25, 2018 · Exported to United Kingdom · Built 2014 · Goodyear, AZ
- [N637RC](https://openairdocs.org/deregistered/N637RC-2018-06-25.md): Diamond Aircraft Ind DA 40 NG · S/N 40.N170 · Cancelled Jun 25, 2018 · Exported to United Kingdom · Built 2014 · Goodyear, AZ
- [N697CT](https://openairdocs.org/deregistered/N697CT-2018-06-25.md): Diamond Aircraft Ind DA 40 NG · S/N 40.N181 · Cancelled Jun 25, 2018 · Exported to United Kingdom · Built 2014 · Goodyear, AZ
- [N273EV](https://openairdocs.org/deregistered/N273EV-2018-06-04.md): Diamond Aircraft Ind DA 40 NG · S/N 40.N304 · Cancelled Jun 4, 2018 · Exported to United Kingdom · Goodyear, AZ
- [N713HX](https://openairdocs.org/deregistered/N713HX-2018-05-18.md): Diamond Aircraft Ind DA 40 NG · S/N 40.N309 · Cancelled May 18, 2018 · Exported to United Kingdom · Built 2016 · Goodyear, AZ
- [N960KN](https://openairdocs.org/deregistered/N960KN-2018-05-18.md): Diamond Aircraft Ind DA 40 NG · S/N 40.N311 · Cancelled May 18, 2018 · Exported to United Kingdom · Built 2016 · Goodyear, AZ
- [N605SJ](https://openairdocs.org/deregistered/N605SJ-2018-04-30.md): Diamond Aircraft Ind DA 40 NG · S/N 40.N284 · Cancelled Apr 30, 2018 · Exported to United Kingdom · Built 2015 · Goodyear, AZ
- [N874FB](https://openairdocs.org/deregistered/N874FB-2018-04-30.md): Diamond Aircraft Ind DA 40 NG · S/N 40.N310 · Cancelled Apr 30, 2018 · Exported to United Kingdom · Built 2016 · Goodyear, AZ
- [N109QG](https://openairdocs.org/deregistered/N109QG-2018-04-02.md): Diamond Aircraft Ind DA 40 NG · S/N 40.N312 · Cancelled Apr 2, 2018 · Exported to United Kingdom · Goodyear, AZ
- [N265PS](https://openairdocs.org/deregistered/N265PS-2018-04-02.md): Diamond Aircraft Ind DA 40 NG · S/N 40.N283 · Cancelled Apr 2, 2018 · Exported to United Kingdom · Built 2015 · Goodyear, AZ
- [N391UQ](https://openairdocs.org/deregistered/N391UQ-2018-04-02.md): Diamond Aircraft Ind DA 40 NG · S/N 40.N307 · Cancelled Apr 2, 2018 · Exported to United Kingdom · Built 2016 · Goodyear, AZ
- [N468ZF](https://openairdocs.org/deregistered/N468ZF-2018-04-02.md): Diamond Aircraft Ind DA 40 NG · S/N 40.N308 · Cancelled Apr 2, 2018 · Exported to United Kingdom · Built 2016 · Goodyear, AZ

## 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 = 'CTC AVIATION LEASING (US) INC' OR list_contains(d.other_registrant_names, 'CTC AVIATION LEASING (US) INC')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-owner/CTC%20AVIATION%20LEASING%20(US)%20INC/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.