Skip to content

Affected TCDS · 38

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

Query with 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:2011-12-01' AND p.tcds_number IS NOT NULL GROUP BY p.tcds_number ORDER BY len(models) DESC, p.tcds_number

duckdb -csv -c "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:2011-12-01' AND p.tcds_number IS NOT NULL
  GROUP BY p.tcds_number
  ORDER BY len(models) DESC, p.tcds_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

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:2011-12-01' AND p.tcds_number IS NOT NULL
GROUP BY p.tcds_number
ORDER BY len(models) DESC, p.tcds_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

TCDS 4A25The Boeing CompanyNames all 27 models: DC-8-41, DC-8-52, DC-8-61 and 24 more TCDS A28NMAirbus SASNames 27 of 50 models: A318-111, A318-112, A318-121 and 24 more TCDS A6WEThe Boeing CompanyNames 22 of 25 models: DC-9-12, DC-9-15F, MD-88 and 19 more TCDS A35EUAirbus SASNames all 17 models: A310-203, A300 B4-622R, A300 F4-605R and 14 more TCDS A46NMAirbus SASNames 16 of 18 models: A330-201, A330-341, A330-342 and 13 more TCDS A16WEThe Boeing CompanyNames 12 of 17 models: 737-500 Series, 737-900 Series, 737-100 Series and 9 more TCDS A20WEThe Boeing CompanyNames 12 of 14 models: 747-100B Series, 747SP Series, 747-400D Series and 9 more TCDS A22WEThe Boeing CompanyNames all 11 models: DC-10-40, MD-11, MD-10-30F and 8 more TCDS A-669The Boeing CompanyNames all 10 models: DC3C-S4C4G, DC3C-R-1830-90C, DC3A-S1C3G and 7 more TCDS A-2-575The Boeing CompanyNames all 9 models: SNJ-7, AT-6F (SNJ-6), AT-6D (SNJ-5) and 6 more TCDS A-817Fokker Services B.V.Names all 8 models: F27 Mark 500, F27 Mark 100, F27 Mark 700 and 5 more TCDS A43NMAirbus SASNames all 8 models: A340-541, A340-311, A340-313 and 5 more TCDS A-762The Boeing CompanyNames all 7 models: C54E-DC, C54G-DC, C54B-DC and 4 more TCDS A20EUFokker Services B.V.Names all 6 models: F28 Mark 1000, F28 Mark 4000, F28 Mark 2000 and 3 more TCDS A3WEThe Boeing CompanyNames all 6 models: 727-100 Series, 727 Series, 727-200 Series and 3 more TCDS A1PCMitsubishi Heavy Industries Ltd.Names all 5 models: YS-11, YS-11A-300, YS-11A-500 and 2 more TCDS T00001SEThe Boeing CompanyNames all 5 models: 777-300ER Series, 777-200 Series, 777-200LR Series and 2 more TCDS 4A21The Boeing CompanyNames all 4 models: 707-100B Short Body, 707-200, 707-100 Long Body and 707-100B Long Body TCDS 4A26The Boeing CompanyNames all 4 models: 707-300B Series, 707-400 Series, 707-300 Series and 707-300C Series TCDS A-618The Boeing CompanyNames all 4 models: DC3-G202A, DC3-G102A, DC3-G103A and DC3-G102 TCDS A1NMThe Boeing CompanyNames 4 of 5 models: 767-300 Series, 767-200 Series, 767-400ER Series and 767-300F Series TCDS A2NMThe Boeing CompanyNames all 4 models: 757-200CB Series, 757-200PF Series, 757-300 Series and 757-200 Series TCDS 4A10The Boeing CompanyNames all 3 models: DC-7, DC-7C and DC-7B TCDS 6A2The Boeing CompanyNames all 3 models: R4D-8Z, R4D-8 and Super DC-3 TCDS 6A3The Boeing CompanyNames all 3 models: DC-6A, USAF C-118A and Navy R6D-1 TCDS A58NMAirbus SASNames all 3 models: A380-841, A380-842 and A380-861 TCDS 4A28The Boeing CompanyNames all 2 models: 720B Series and 720 Series TCDS 6A4The Boeing CompanyNames all 2 models: Navy R6D-1Z and DC-6B TCDS A-726The Boeing CompanyNames all 2 models: SA-307B-1 and SA-307B TCDS A5EUAirbus SASNames all 2 models: BAC 1-11 200 Series and BAC 1-11 400 Series TCDS TC 206The Boeing CompanyNames all 2 models: 80-A1 and 80-A TCDS TC 704The Boeing CompanyNames all 2 models: 314 and A-314 TCDS 1A18The Boeing CompanyNames 1 of 1 model: NA-260 TCDS A-781The Boeing CompanyNames 1 of 1 model: DC-6 TCDS ATC 133The Boeing CompanyNames 1 of 1 model: 100 TCDS ATC 558The Boeing CompanyNames 1 of 1 model: 247-D (Army C-73)TCDS TC 2-412The Boeing CompanyNames 1 of 1 model: 203-B TCDS TC 719The Boeing CompanyNames 1 of 1 model: S-307

Back to AD 2011-12-01