# Affected TCDS: AD 2018-23-12

A list on [AD 2018-23-12](https://openairdocs.org/ad/2018-23-12.md).

The type certificate data sheets for the models this AD names, matched by model and maker.

- [TCDS A28NM](https://openairdocs.org/tcds/A28NM.md): Airbus SAS · Names 41 of 50 models: A318-111, A318-112, A318-121 and 38 more
- [TCDS A35EU](https://openairdocs.org/tcds/A35EU.md): Airbus SAS · Names all 17 models: A310-203, A300 B4-622R, A300 F4-605R and 14 more
- [TCDS A46NM](https://openairdocs.org/tcds/A46NM.md): Airbus SAS · Names 16 of 18 models: A330-201, A330-341, A330-342 and 13 more
- [TCDS A16WE](https://openairdocs.org/tcds/A16WE.md): The Boeing Company · Names 14 of 17 models: 737-500 Series, 737-900 Series, 737-100 Series and 11 more
- [TCDS A20WE](https://openairdocs.org/tcds/A20WE.md): The Boeing Company · Names all 14 models: 747-100B Series, 747-8 Series, 747SP Series and 11 more
- [TCDS A-817](https://openairdocs.org/tcds/A-817.md): Fokker Services B.V. · Names all 8 models: F27 Mark 500, F27 Mark 100, F27 Mark 700 and 5 more
- [TCDS A43NM](https://openairdocs.org/tcds/A43NM.md): Airbus SAS · Names all 8 models: A340-541, A340-311, A340-313 and 5 more
- [TCDS A20EU](https://openairdocs.org/tcds/A20EU.md): Fokker Services B.V. · Names all 6 models: F28 Mark 1000, F28 Mark 4000, F28 Mark 2000 and 3 more
- [TCDS A3WE](https://openairdocs.org/tcds/A3WE.md): The Boeing Company · Names all 6 models: 727-100 Series, 727 Series, 727-200 Series and 3 more
- [TCDS A49EU](https://openairdocs.org/tcds/A49EU.md): BAE Systems (Operations) Limited · Names all 6 models: Avro 146-RJ85A, BAe 146-300A, BAe 146-100A and 3 more
- [TCDS A1NM](https://openairdocs.org/tcds/A1NM.md): The Boeing Company · Names all 5 models: 767-300 Series, 767-200 Series, 767-400ER Series and 2 more
- [TCDS T00001SE](https://openairdocs.org/tcds/T00001SE.md): The Boeing Company · Names all 5 models: 777-300ER Series, 777-200 Series, 777-200LR Series and 2 more
- [TCDS 4A21](https://openairdocs.org/tcds/4A21.md): The Boeing Company · Names all 4 models: 707-100B Short Body, 707-200, 707-100 Long Body and 707-100B Long Body
- [TCDS 4A26](https://openairdocs.org/tcds/4A26.md): The Boeing Company · Names all 4 models: 707-300B Series, 707-400 Series, 707-300 Series and 707-300C Series
- [TCDS A2NM](https://openairdocs.org/tcds/A2NM.md): The Boeing Company · Names all 4 models: 757-200CB Series, 757-200PF Series, 757-300 Series and 757-200 Series
- [TCDS A58NM](https://openairdocs.org/tcds/A58NM.md): Airbus SAS · Names all 3 models: A380-841, A380-842 and A380-861
- [TCDS T00021SE](https://openairdocs.org/tcds/T00021SE.md): The Boeing Company · Names all 3 models: 787-10, 787-8 and 787-9
- [TCDS 4A28](https://openairdocs.org/tcds/4A28.md): The Boeing Company · Names all 2 models: 720B Series and 720 Series
- [TCDS A24EU](https://openairdocs.org/tcds/A24EU.md): BAE Systems (Operations) Limited · Names all 2 models: HS 748 Series 2B and HS 748 Series 2A
- [TCDS A5EU](https://openairdocs.org/tcds/A5EU.md): Airbus SAS · Names all 2 models: BAC 1-11 200 Series and BAC 1-11 400 Series
- [TCDS T00063IB](https://openairdocs.org/tcds/T00063IB.md): Airbus SAS · Names all 2 models: A350-941 and A350-1041
- [TCDS A27NM](https://openairdocs.org/tcds/A27NM.md): BAE Systems (Operations) Limited · Names 1 of 1 model: ATP
- [TCDS A41NM](https://openairdocs.org/tcds/A41NM.md): BAE Systems (Operations) Limited · Names 1 of 1 model: Jetstream Model 4101
- [TCDS A6WE](https://openairdocs.org/tcds/A6WE.md): The Boeing Company · Names 1 of 25 models: 717-200

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
SELECT p.tcds_number, any_value(t.holder) AS holder, any_value(t.status) AS status, list(DISTINCT coalesce(p.tcds_model, p.model)) AS models
FROM 'https://openairdocs.org/data/latest/faa_directive_product.parquet' p LEFT JOIN 'https://openairdocs.org/data/latest/faa_type_certificate.parquet' t USING (tcds_number)
WHERE p.ad_id = 'FAA:2018-23-12' AND p.tcds_number IS NOT NULL
GROUP BY p.tcds_number
ORDER BY len(models) DESC, p.tcds_number
```

This list as a web page: https://openairdocs.org/ad/2018-23-12/tcds

---
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.