# Affected TCDS: AD 87-20-03 R2

A list on [AD 87-20-03 R2](https://openairdocs.org/ad/87-20-03-R2.md).

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

- [TCDS 3A21](https://openairdocs.org/tcds/3A21.md): Textron Aviation Inc. · Names all 28 models: 210J, P210N, 210D and 25 more
- [TCDS A4CE](https://openairdocs.org/tcds/A4CE.md): Textron Aviation Inc. · Names 27 of 29 models: TP206B, TP206C, TU206A and 24 more
- [TCDS 3A13](https://openairdocs.org/tcds/3A13.md): Textron Aviation Inc. · Names 20 of 23 models: 182D, 182A, 182J and 17 more
- [TCDS A6CE](https://openairdocs.org/tcds/A6CE.md): Textron Aviation Inc. · Names 18 of 19 models: 337, T337B, T337E and 15 more
- [TCDS 3A19](https://openairdocs.org/tcds/3A19.md): Textron Aviation Inc. · Names 17 of 18 models: 150L, 150B, 150D and 14 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 3A17](https://openairdocs.org/tcds/3A17.md): Textron Aviation Inc. · Names all 12 models: R172H, R172G, R172K and 9 more
- [TCDS A13EU](https://openairdocs.org/tcds/A13EU.md): Textron Aviation Inc. · Names 12 of 14 models: FRA150M, F150G, FA152 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 3A24](https://openairdocs.org/tcds/3A24.md): Textron Aviation Inc. · Names all 8 models: 185B, A185F, 185E and 5 more
- [TCDS A4EU](https://openairdocs.org/tcds/A4EU.md): Textron Aviation Inc. · Names 8 of 11 models: F172F, F172M, F172H 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 A-790](https://openairdocs.org/tcds/A-790.md): Textron Aviation Inc. · Names all 4 models: 195A, 190, 195B and 195
- [TCDS A16CE](https://openairdocs.org/tcds/A16CE.md): Textron Aviation Inc. · Names all 4 models: 207, T207, 207A and T207A
- [TCDS A23EU](https://openairdocs.org/tcds/A23EU.md): Textron Aviation Inc. · Names 4 of 8 models: F337G, F337E, F337F and F337H
- [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 A42EU](https://openairdocs.org/tcds/A42EU.md): Textron Aviation Inc. · Names all 3 models: FR182, F182P and F182Q
- [TCDS A20CE](https://openairdocs.org/tcds/A20CE.md): Textron Aviation Inc. · Names 1 of 1 model: 177RG
- [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

## 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:87-20-03-R2' 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/87-20-03-R2/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.