# Affected TCDS: AD 99-23-22 R2

A list on [AD 99-23-22 R2](https://openairdocs.org/ad/99-23-22-R2.md).

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

- [TCDS A20WE](https://openairdocs.org/tcds/A20WE.md): The Boeing Company · Names 12 of 14 models: 747-100B Series, 747SP Series, 747-400D Series and 9 more
- [TCDS A16WE](https://openairdocs.org/tcds/A16WE.md): The Boeing Company · Names 9 of 17 models: 737-500 Series, 737-100 Series, 737-200C Series and 6 more
- [TCDS A35EU](https://openairdocs.org/tcds/A35EU.md): Airbus SAS · Names 8 of 17 models: A310-203, A310-204, A310-221 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 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 A23WE](https://openairdocs.org/tcds/A23WE.md): Lockheed Martin Corporation · Names all 4 models: L-1011-385-1-14, L-1011-385-3, L-1011-385-1 and L-1011-385-1-15
- [TCDS A6WE](https://openairdocs.org/tcds/A6WE.md): The Boeing Company · Names 4 of 25 models: DC-9-81 (MD-81), DC-9-83 (MD-83), DC-9-87 (MD-87) and DC-9-82 (MD-82)
- [TCDS A49EU](https://openairdocs.org/tcds/A49EU.md): BAE Systems (Operations) Limited · Names 3 of 6 models: Avro 146-RJ85A, Avro 146-RJ70A and Avro 146-RJ100A
- [TCDS 4A22](https://openairdocs.org/tcds/4A22.md): Lockheed Martin Corporation · Names all 2 models: 188A and 188C
- [TCDS A12EA](https://openairdocs.org/tcds/A12EA.md): Gulfstream Aerospace Corporation · Names 2 of 7 models: G-1159A and G-1159
- [TCDS A46EU](https://openairdocs.org/tcds/A46EU.md): Dassault Aviation · Names 2 of 3 models: Mystere-Falcon 900 and Mystere-Falcon 50
- [TCDS A7EU](https://openairdocs.org/tcds/A7EU.md): Dassault Aviation · Names 2 of 11 models: Mystere-Falcon 200 and Fan Jet Falcon Series G
- [TCDS A21NM](https://openairdocs.org/tcds/A21NM.md): Airbus Defense and Space S.A. · Names 1 of 5 models: CN-235
- [TCDS A27NM](https://openairdocs.org/tcds/A27NM.md): BAE Systems (Operations) Limited · Names 1 of 1 model: ATP

## 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:99-23-22-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/99-23-22-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.
