# Affected TCDS: AD 97-18-02 R1

A list on [AD 97-18-02 R1](https://openairdocs.org/ad/97-18-02-R1.md).

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

- [TCDS P-878](https://openairdocs.org/tcds/P-878.md): Hartzell Propeller Inc. · Names all 17 models: HC-82XF-1, HC-82XL-6, HC-82XF-6 and 14 more
- [TCDS P-908](https://openairdocs.org/tcds/P-908.md): Hartzell Propeller Inc. · Names all 17 models: BHC-A2XF-1, HC-A2X20-5, HC-A2X20-4 and 14 more
- [TCDS P-845](https://openairdocs.org/tcds/P-845.md): Hartzell Propeller Inc. · Names all 9 models: HC-12X20-7, HC-12X20-5, HC-12X20-6 and 6 more
- [TCDS P-913](https://openairdocs.org/tcds/P-913.md): Hartzell Propeller Inc. · Names all 9 models: HC-A3XF-4, HC-A3X20-2, HC-A3X20-5 and 6 more
- [TCDS P-884](https://openairdocs.org/tcds/P-884.md): Hartzell Propeller Inc. · Names all 7 models: HC-83XK-2, HC-83XK-1, HC-83XF-1 and 4 more
- [TCDS P14EA](https://openairdocs.org/tcds/P14EA.md): TRW Hartzell Propeller · Names all 4 models: HC-83VF-2, HC-83V20-2, HC-83VF-3 and HC-83V20-1
- [TCDS P-888](https://openairdocs.org/tcds/P-888.md): Hartzell Propeller Inc. · Names all 3 models: HC-13X20-8, HC-13X20-6 and HC-13X20-5
- [TCDS P-917](https://openairdocs.org/tcds/P-917.md): TRW Hartzell Propeller · Names all 3 models: HC-D2X20-7, HC-D2X20-8 and HC-D2X20-3
- [TCDS P23EA](https://openairdocs.org/tcds/P23EA.md): TRW Hartzell Propeller · Names all 3 models: HC-82VF-2, HC-82VK-2 and HC-82VL-2
- [TCDS P46GL](https://openairdocs.org/tcds/P46GL.md): Hartzell Propeller Inc. · Names all 3 models: HC-12V20-8, HC-12V20-3 and HC-12V20-7
- [TCDS P48GL](https://openairdocs.org/tcds/P48GL.md): Hartzell Propeller Inc. · Names all 3 models: HC-D2V20-8, HC-D2V20-7 and HC-D2V20-3
- [TCDS P6EA](https://openairdocs.org/tcds/P6EA.md): Hartzell Propeller Inc. · Names 3 of 6 models: HC-A3V, PHC-A3V and EHC-A3VF
- [TCDS P24EA](https://openairdocs.org/tcds/P24EA.md): Hartzell Propeller Inc. · Names 2 of 4 models: HC-A2V and BHC-A2V
- [TCDS 3P1](https://openairdocs.org/tcds/3P1.md): Hartzell Propeller Inc. · Names 1 of 1 model: HC-42XF-2
- [TCDS 3P2](https://openairdocs.org/tcds/3P2.md): Hartzell Propeller Inc. · Names 1 of 1 model: HC-52X20-1
- [TCDS P1EA](https://openairdocs.org/tcds/P1EA.md): TRW Hartzell Propeller · Names 1 of 1 model: HC-D3X20-6
- [TCDS P51GL](https://openairdocs.org/tcds/P51GL.md): Hartzell Propeller Inc. · Names 1 of 1 model: HC-D3V20-6
- [TCDS P59GL](https://openairdocs.org/tcds/P59GL.md): Hartzell Propeller Inc. · Names 1 of 2 models: HA-A2V20-1

## 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-18-02-R1' 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-18-02-R1/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.