# Earlier aircraft under this name: Aircraft Consultants Inc DBA

A list on [Aircraft Consultants Inc DBA](https://openairdocs.org/faa-owner/AIRCRAFT%20CONSULTANTS%20INC%20DBA.md).

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

- [N245SY](https://openairdocs.org/deregistered/N245SY-2015-03-02.md): Boeing 737-476 · S/N 24445 · Cancelled Mar 2, 2015 · Exported to Spain · San Antonio, TX
- [N156GA](https://openairdocs.org/deregistered/N156GA-2014-06-09.md): Boeing 737-4Q8 · S/N 26298 · Cancelled Jun 9, 2014 · Exported to Spain · San Antonio, TX
- [N227LD](https://openairdocs.org/deregistered/N227LD-2011-11-17.md): Fairchild SA227-AC · S/N AC-696B · Cancelled Nov 17, 2011 · Exported to Canada · San Antonio, TX
- [N783ML](https://openairdocs.org/deregistered/N783ML-2009-02-02.md): Fairchild SA227BC · S/N BC-783B · Cancelled Feb 2, 2009 · Exported to Bolivia · Built 1991 · San Antonio, TX
- [N768ML](https://openairdocs.org/deregistered/N768ML-2009-01-22.md): Fairchild SA227BC · S/N BC-768B · Cancelled Jan 22, 2009 · Exported to Bolivia · Built 1991 · San Antonio, TX
- [N316CE](https://openairdocs.org/deregistered/N316CE-2006-08-23.md): Saab-Scania SAAB 340B · S/N 340B-348 · Cancelled Aug 23, 2006 · Exported to Australia · San Antonio, TX
- [N1119K](https://openairdocs.org/deregistered/N1119K-2006-04-25.md): Fairchild SA227-DC · S/N DC830B · Cancelled Apr 25, 2006 · Exported to Bolivia · Built 1993 · San Antonio, TX
- [N6ER](https://openairdocs.org/deregistered/N6ER-2006-04-11.md): Fairchild SA227-DC · S/N DC879B · Cancelled Apr 11, 2006 · Exported to Venezuela · Built 1996 · San Antonio, TX
- [N6BN](https://openairdocs.org/deregistered/N6BN-2005-05-31.md): Fairchild SA227-DC · S/N DC881B · Cancelled May 31, 2005 · Exported to Australia · San Antonio, TX
- [N6UB](https://openairdocs.org/deregistered/N6UB-2004-11-12.md): Fairchild SA227-AC · S/N AC-679B · Cancelled Nov 12, 2004 · Exported to Spain · San Antonio, TX
- [N2724S](https://openairdocs.org/deregistered/N2724S-2001-08-02.md): Fairchild SA227-AC · S/N AC-720B · Cancelled Aug 2, 2001 · Exported to Spain · San Antonio, TX
- [N25LD](https://openairdocs.org/deregistered/N25LD-2001-06-19.md): Fairchild SA227-AC · S/N AC461B · Cancelled Jun 19, 2001 · Exported to Spain · San Antonio, TX
- [N246CA](https://openairdocs.org/deregistered/N246CA-2001-03-30.md): Embraer EMB-120RT · S/N 120.223 · Cancelled Mar 30, 2001 · Exported to Moldova · San Antonio, TX
- [N168CA](https://openairdocs.org/deregistered/N168CA-2001-03-01.md): Embraer EMB-120RT · S/N 120168 · Cancelled Mar 1, 2001 · Exported to Spain · San Antonio, TX
- [N703CA](https://openairdocs.org/deregistered/N703CA-2000-10-04.md): Fairchild SA227-AC · S/N AC-703 · Cancelled Oct 4, 2000 · Exported to Mexico · San Antonio, TX
- [N7215U](https://openairdocs.org/deregistered/N7215U-1999-10-07.md): Embraer EMB-120RT · S/N 120.063 · Cancelled Oct 7, 1999 · Exported to Spain · San Antonio, TX
- [N2692P](https://openairdocs.org/deregistered/N2692P-1999-05-11.md): Fairchild SA227-AC · S/N AC-658B · Cancelled May 11, 1999 · Exported to Spain · San Antonio, TX
- [N211AS](https://openairdocs.org/deregistered/N211AS-1999-04-27.md): Embraer EMB-120RT · S/N 120.007 · Cancelled Apr 27, 1999 · Exported to Spain · San Antonio, TX
- [N212AS](https://openairdocs.org/deregistered/N212AS-1999-02-17.md): Embraer EMB-120RT · S/N 120.008 · Cancelled Feb 17, 1999 · Exported to Spain · San Antonio, TX
- [N702AM](https://openairdocs.org/deregistered/N702AM-1996-07-10.md): Fairchild SA227BC · S/N BC772B · Cancelled Jul 10, 1996 · Exported to Spain · Poth, TX
- [N97HG](https://openairdocs.org/deregistered/N97HG-1994-03-04.md): Fairchild SA227-AC · S/N AC651 · Cancelled Mar 4, 1994 · Exported to Spain · Poth, TX

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

This list as a web page: https://openairdocs.org/faa-owner/AIRCRAFT%20CONSULTANTS%20INC%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.
