# Affected TCDS: AD 97-01-13

A list on [AD 97-01-13](https://openairdocs.org/ad/97-01-13.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 26 of 29 models: TP206B, TP206C, TU206A and 23 more
- [TCDS 3A13](https://openairdocs.org/tcds/3A13.md): Textron Aviation Inc. · Names 20 of 23 models: 182D, 182A, 182J and 17 more
- [TCDS 3A21](https://openairdocs.org/tcds/3A21.md): Textron Aviation Inc. · Names 20 of 28 models: 210J, P210N, 210D and 17 more
- [TCDS A6CE](https://openairdocs.org/tcds/A6CE.md): Textron Aviation Inc. · Names all 19 models: 337, T337B, T337E and 16 more
- [TCDS 3A19](https://openairdocs.org/tcds/3A19.md): Textron Aviation Inc. · Names all 18 models: 150L, 150B, 150D and 15 more
- [TCDS 3A12](https://openairdocs.org/tcds/3A12.md): Textron Aviation Inc. · Names 16 of 18 models: 172F (USAF T-41A), 172M, 172Q and 13 more
- [TCDS A7CE](https://openairdocs.org/tcds/A7CE.md): Textron Aviation Inc. · Names all 16 models: 421C, 425, 402C and 13 more
- [TCDS A13EU](https://openairdocs.org/tcds/A13EU.md): Textron Aviation Inc. · Names 13 of 14 models: FRA150M, F150G, FA152 and 10 more
- [TCDS 3A17](https://openairdocs.org/tcds/3A17.md): Textron Aviation Inc. · Names all 12 models: R172H, R172G, R172K and 9 more
- [TCDS 5A6](https://openairdocs.org/tcds/5A6.md): Textron Aviation Inc. · Names all 11 models: 180E, 180J, 180F and 8 more
- [TCDS A4EU](https://openairdocs.org/tcds/A4EU.md): Textron Aviation Inc. · Names 10 of 11 models: F172F, F172M, F172H and 7 more
- [TCDS 3A24](https://openairdocs.org/tcds/3A24.md): Textron Aviation Inc. · Names all 8 models: 185B, A185F, 185E and 5 more
- [TCDS A23EU](https://openairdocs.org/tcds/A23EU.md): Textron Aviation Inc. · Names all 8 models: F337G, FT337GP, F337E and 5 more
- [TCDS A9CE](https://openairdocs.org/tcds/A9CE.md): Textron Aviation Inc. · Names all 7 models: A188A, A188B, 188A and 4 more
- [TCDS A18EU](https://openairdocs.org/tcds/A18EU.md): Textron Aviation Inc. · Names all 6 models: FR172G, FR172J, FR172K and 3 more
- [TCDS 3A10](https://openairdocs.org/tcds/3A10.md): Textron Aviation Inc. · Names 4 of 23 models: 310P, T310P, 310R and 310Q
- [TCDS A16CE](https://openairdocs.org/tcds/A16CE.md): Textron Aviation Inc. · Names all 4 models: 207, T207, 207A and T207A
- [TCDS 3A25](https://openairdocs.org/tcds/3A25.md): Textron Aviation Inc. · Names 3 of 11 models: 335, 340A and 340
- [TCDS A13CE](https://openairdocs.org/tcds/A13CE.md): Textron Aviation Inc. · Names all 3 models: 177, 177A and 177B
- [TCDS A42EU](https://openairdocs.org/tcds/A42EU.md): Textron Aviation Inc. · Names all 3 models: FR182, F182P and F182Q
- [TCDS A37CE](https://openairdocs.org/tcds/A37CE.md): Textron Aviation Inc. · Names all 2 models: 208B and 208
- [TCDS A20CE](https://openairdocs.org/tcds/A20CE.md): Textron Aviation Inc. · Names 1 of 1 model: 177RG
- [TCDS A25CE](https://openairdocs.org/tcds/A25CE.md): Textron Aviation Inc. · Names 1 of 2 models: 404
- [TCDS A26EU](https://openairdocs.org/tcds/A26EU.md): Textron Aviation Inc. · Names 1 of 1 model: F177RG
- [TCDS A2CE](https://openairdocs.org/tcds/A2CE.md): Textron Aviation Inc. · Names 1 of 1 model: 336
- [TCDS A34CE](https://openairdocs.org/tcds/A34CE.md): Textron Aviation Inc. · Names 1 of 1 model: T303
- [TCDS A54EU](https://openairdocs.org/tcds/A54EU.md): ASI Aviation · Names 1 of 1 model: F406

## 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:97-01-13' 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/97-01-13/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.
