# Affected TCDS: AD 2004-19-01

A list on [AD 2004-19-01](https://openairdocs.org/ad/2004-19-01.md).

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

- [TCDS A4CE](https://openairdocs.org/tcds/A4CE.md): Textron Aviation Inc. · Names 21 of 29 models: TP206B, TP206C, TU206A and 18 more
- [TCDS 3A21](https://openairdocs.org/tcds/3A21.md): Textron Aviation Inc. · Names 18 of 28 models: 210J, 210D, 210 and 15 more
- [TCDS 3A13](https://openairdocs.org/tcds/3A13.md): Textron Aviation Inc. · Names 14 of 23 models: 182D, 182A, 182J and 11 more
- [TCDS 3A12](https://openairdocs.org/tcds/3A12.md): Textron Aviation Inc. · Names 11 of 18 models: 172F (USAF T-41A), 172K, 172G and 8 more
- [TCDS 3A19](https://openairdocs.org/tcds/3A19.md): Textron Aviation Inc. · Names 11 of 18 models: 150B, 150D, 150E and 8 more
- [TCDS A6CE](https://openairdocs.org/tcds/A6CE.md): Textron Aviation Inc. · Names 10 of 19 models: 337, T337B, T337E and 7 more
- [TCDS 5A6](https://openairdocs.org/tcds/5A6.md): Textron Aviation Inc. · Names 9 of 11 models: 180E, 180F, 180H and 6 more
- [TCDS 3A24](https://openairdocs.org/tcds/3A24.md): Textron Aviation Inc. · Names 7 of 8 models: 185B, 185E, 185C and 4 more
- [TCDS 3A17](https://openairdocs.org/tcds/3A17.md): Textron Aviation Inc. · Names 5 of 12 models: 175, 175B, P172D and 2 more
- [TCDS A4EU](https://openairdocs.org/tcds/A4EU.md): Textron Aviation Inc. · Names 5 of 11 models: F172F, F172H, F172E and 2 more
- [TCDS A13EU](https://openairdocs.org/tcds/A13EU.md): Textron Aviation Inc. · Names 4 of 14 models: F150G, F150H, F150K and F150J
- [TCDS A-799](https://openairdocs.org/tcds/A-799.md): Textron Aviation Inc. · Names all 3 models: 170, 170A and 170B
- [TCDS A13CE](https://openairdocs.org/tcds/A13CE.md): Textron Aviation Inc. · Names all 3 models: 177, 177A and 177B
- [TCDS A18EU](https://openairdocs.org/tcds/A18EU.md): Textron Aviation Inc. · Names 3 of 6 models: FR172G, FR172E and FR172F
- [TCDS A-768](https://openairdocs.org/tcds/A-768.md): Textron Aviation Inc. · Names all 2 models: 140 and 120
- [TCDS A-790](https://openairdocs.org/tcds/A-790.md): Textron Aviation Inc. · Names 2 of 4 models: 190 and 195
- [TCDS A16CE](https://openairdocs.org/tcds/A16CE.md): Textron Aviation Inc. · Names 2 of 4 models: 207 and T207
- [TCDS 5A2](https://openairdocs.org/tcds/5A2.md): Textron Aviation Inc. · Names 1 of 1 model: 140A
- [TCDS A2CE](https://openairdocs.org/tcds/A2CE.md): Textron Aviation Inc. · Names 1 of 1 model: 336

## 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:2004-19-01' 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/2004-19-01/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.