# Affected TCDS: AD 97-08-06 R1

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

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

- [TCDS G33EU](https://openairdocs.org/tcds/G33EU.md): Fiberglas-Technik Rudolf Lindner GmbH & Co. KG · Names all 4 models: G102 Standard Astir III, G102 CLUB ASTIR III, G102 CLUB ASTIR IIIb and G102 ASTIR CS
- [TCDS G39EU](https://openairdocs.org/tcds/G39EU.md): Fiberglas-Technik Rudolf Lindner GmbH & Co. KG · Names all 4 models: G103 Twin Astir, G103C Twin III Acro, G103A Twin II Acro and G103 Twin II
- [TCDS G46EU](https://openairdocs.org/tcds/G46EU.md): Centrair · Names all 4 models: 101A, 101AP, 101 and 101P
- [TCDS G31EU](https://openairdocs.org/tcds/G31EU.md): Eiriavion Oy · Names all 3 models: PIK-20, PIK-20D and PIK-20B
- [TCDS G21EU](https://openairdocs.org/tcds/G21EU.md): Alexander Schleicher GmbH & Co. Segelflugzeugbau · Names all 2 models: AS 12 and ASW 12
- [TCDS G22EU](https://openairdocs.org/tcds/G22EU.md): Alexander Schleicher GmbH & Co. Segelflugzeugbau · Names all 2 models: ASW-15B and ASW-15
- [TCDS G26EU](https://openairdocs.org/tcds/G26EU.md): Schempp-Hirth Flugzeugbau GmbH · Names all 2 models: Nimbus-2B and Nimbus-2
- [TCDS G36EU](https://openairdocs.org/tcds/G36EU.md): Alexander Schleicher GmbH & Co. Segelflugzeugbau · Names all 2 models: ASW-19B and ASW-19
- [TCDS G43EU](https://openairdocs.org/tcds/G43EU.md): GROB Aircraft AG · Names all 2 models: GROB G 109B and GROB G 109
- [TCDS G04CE](https://openairdocs.org/tcds/G04CE.md): Schempp-Hirth Flugzeugbau GmbH · Names 1 of 2 models: Ventus-2a
- [TCDS G15EU](https://openairdocs.org/tcds/G15EU.md): Alexander Schleicher GmbH & Co. Segelflugzeugbau · Names 1 of 1 model: AS-K 13
- [TCDS G19EU](https://openairdocs.org/tcds/G19EU.md): Schempp-Hirth Flugzeugbau GmbH · Names 1 of 1 model: Cirrus
- [TCDS G23EU](https://openairdocs.org/tcds/G23EU.md): Schempp-Hirth Flugzeugbau GmbH · Names 1 of 1 model: Standard-Cirrus
- [TCDS G30EU](https://openairdocs.org/tcds/G30EU.md): Alexander Schleicher GmbH & Co. Segelflugzeugbau · Names 1 of 1 model: ASW 17
- [TCDS G32EU](https://openairdocs.org/tcds/G32EU.md): DG Aviation GmbH · Names 1 of 1 model: DG-100
- [TCDS G34EU](https://openairdocs.org/tcds/G34EU.md): Schempp-Hirth Flugzeugbau GmbH · Names 1 of 1 model: JANUS
- [TCDS G35EU](https://openairdocs.org/tcds/G35EU.md): DG Aviation GmbH · Names 1 of 1 model: LS1-f
- [TCDS G37EU](https://openairdocs.org/tcds/G37EU.md): DG Aviation GmbH · Names 1 of 2 models: LS 3-A
- [TCDS G40EU](https://openairdocs.org/tcds/G40EU.md): Aeroclubul Romaniei · Names 1 of 1 model: IS-28B2
- [TCDS G41EU](https://openairdocs.org/tcds/G41EU.md): Aeroclubul Romaniei · Names 1 of 1 model: IS-29D2
- [TCDS G47EU](https://openairdocs.org/tcds/G47EU.md): Alexander Schleicher GmbH & Co. Segelflugzeugbau · Names 1 of 3 models: ASK 21
- [TCDS G52EU](https://openairdocs.org/tcds/G52EU.md): DG Aviation GmbH · Names 1 of 1 model: DG-400
- [TCDS G53EU](https://openairdocs.org/tcds/G53EU.md): Schempp-Hirth Flugzeugbau GmbH · Names 1 of 2 models: Discus a
- [TCDS G54EU](https://openairdocs.org/tcds/G54EU.md): Centrair · Names 1 of 1 model: 201B
- [TCDS G59EU](https://openairdocs.org/tcds/G59EU.md): DG Aviation GmbH · Names 1 of 2 models: DG-500M

## 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-08-06-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-08-06-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.