# Affected TCDS: AD 2006-24-07

A list on [AD 2006-24-07](https://openairdocs.org/ad/2006-24-07.md).

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

- [TCDS P57GL](https://openairdocs.org/tcds/P57GL.md): McCauley Propeller Systems · Names 10 of 22 models: 3AF32C512, 3AF34C503, 3AF32C522 and 7 more
- [TCDS P47GL](https://openairdocs.org/tcds/P47GL.md): McCauley Propeller Systems · Names 5 of 23 models: 3A32C406, D3A32C411, D3A32C409 and 2 more
- [TCDS P58GL](https://openairdocs.org/tcds/P58GL.md): McCauley Propeller Systems · Names 5 of 17 models: B3D36C424, B3D34C405, C3D36C415 and 2 more
- [TCDS P3EA](https://openairdocs.org/tcds/P3EA.md): McCauley Propeller Systems · Names 3 of 10 models: 2A34C, D2A34C and C2A34C
- [TCDS P7EA](https://openairdocs.org/tcds/P7EA.md): McCauley Propeller Systems · Names 3 of 4 models: 2D34C, B2D37C and B2D34C
- [TCDS P-920](https://openairdocs.org/tcds/P-920.md): Hartzell Propeller LLC · Names 2 of 4 models: HC-C2Y and BHC-C2Y
- [TCDS P21EA](https://openairdocs.org/tcds/P21EA.md): McCauley Propeller Systems · Names 2 of 5 models: D3A32C90 and D3A32C88
- [TCDS P22EA](https://openairdocs.org/tcds/P22EA.md): McCauley Propeller Systems · Names 2 of 10 models: 3AF32C93 and 3AF32C87
- [TCDS P25EA](https://openairdocs.org/tcds/P25EA.md): Hartzell Propeller LLC · Names 2 of 3 models: HC-C3Y and PHC-C3Y
- [TCDS P27EA](https://openairdocs.org/tcds/P27EA.md): Hartzell Propeller LLC · Names 2 of 5 models: HC-F2YL-2 and HC-F2YR-1
- [TCDS P33EA](https://openairdocs.org/tcds/P33EA.md): Hartzell Propeller LLC · Names 2 of 8 models: HC-E3YR-2 and HC-I3YR-1
- [TCDS P5EA](https://openairdocs.org/tcds/P5EA.md): McCauley Propeller Systems · Names 2 of 3 models: 2AF34C55 and D2AF34C
- [TCDS P6EA](https://openairdocs.org/tcds/P6EA.md): Hartzell Propeller Inc. · Names 2 of 6 models: HC-A3V and PHC-A3V
- [TCDS P-880](https://openairdocs.org/tcds/P-880.md): McCauley Propeller Systems · Names 1 of 11 models: 2A36C23
- [TCDS P10NE](https://openairdocs.org/tcds/P10NE.md): Hartzell Propeller LLC · Names 1 of 2 models: HC-E4
- [TCDS P14NE](https://openairdocs.org/tcds/P14NE.md): Hartzell Propeller Inc. · Names 1 of 1 model: HC-A6A-3
- [TCDS P15EA](https://openairdocs.org/tcds/P15EA.md): Hartzell Propeller LLC · Names 1 of 1 model: HC-B3T
- [TCDS P15NE](https://openairdocs.org/tcds/P15NE.md): McCauley Propeller Systems · Names 1 of 7 models: 5JFR36C1003
- [TCDS P24EA](https://openairdocs.org/tcds/P24EA.md): Hartzell Propeller Inc. · Names 1 of 4 models: HC-A2V
- [TCDS P3NE](https://openairdocs.org/tcds/P3NE.md): McCauley Propeller Systems · Names 1 of 4 models: 4HFR34C(7--)
- [TCDS P40EA](https://openairdocs.org/tcds/P40EA.md): Hartzell Propeller LLC · Names 1 of 3 models: HC-B4TN-5
- [TCDS P43GL](https://openairdocs.org/tcds/P43GL.md): Hartzell Propeller LLC · Names 1 of 2 models: HC-M2YR-2
- [TCDS P45GL](https://openairdocs.org/tcds/P45GL.md): McCauley Propeller Systems · Names 1 of 2 models: 3FF32C501
- [TCDS P56GL](https://openairdocs.org/tcds/P56GL.md): Hartzell Propeller LLC · Names 1 of 2 models: HC-B4MP-3
- [TCDS P60GL](https://openairdocs.org/tcds/P60GL.md): McCauley Propeller Systems · Names 1 of 4 models: 3GFR34C701
- [TCDS P9EA](https://openairdocs.org/tcds/P9EA.md): Hartzell Propeller LLC · Names 1 of 3 models: HC-E2Y

## 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:2006-24-07' 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/2006-24-07/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.
