Skip to content

Affected TCDS · 46

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:93-14-12' 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:93-14-12' 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:93-14-12' 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 A6WEThe Boeing CompanyNames 20 of 25 models: DC-9-12, DC-9-15F, MD-88 and 17 more TCDS A20WEThe Boeing CompanyNames 11 of 14 models: 747-100B Series, 747SP Series, 747-400D Series and 8 more TCDS A22WEThe Boeing CompanyNames all 11 models: DC-10-40, MD-11, MD-10-30F and 8 more TCDS A35EUAirbus SASNames 11 of 17 models: A310-203, A300 B4-622R, A300 B4-601 and 8 more TCDS A-669The Boeing CompanyNames all 10 models: DC3C-S4C4G, DC3C-R-1830-90C, DC3A-S1C3G and 7 more TCDS 6A5Lockheed Martin Aeronautics CompanyNames all 8 models: 1049G-82, 1049C-55, 1049E-55 and 5 more TCDS A-762The Boeing CompanyNames all 7 models: C54E-DC, C54G-DC, C54B-DC and 4 more TCDS A-763Lockheed Martin Aeronautics CompanyNames all 6 models: 149-46, 649-79, 749A-79 and 3 more TCDS A16WEThe Boeing CompanyNames 6 of 17 models: 737-500 Series, 737-100 Series, 737-200C Series and 3 more TCDS A3WEThe Boeing CompanyNames all 6 models: 727-100 Series, 727 Series, 727-200 Series and 3 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 A28NMAirbus SASNames 4 of 50 models: A320-111, A320-211, A320-212 and A320-231 TCDS LTC-10Lockheed Aircraft CorporationNames all 4 models: P-38J (F-5E), P-38L (F-5F and F-5G), P-38E (Army) and P-38M 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 A2NMThe Boeing CompanyNames 3 of 4 models: 757-200CB Series, 757-200PF Series and 757-200 Series TCDS ATC 683Lockheed Aircraft CorporationNames all 3 models: 14-N2, 14-N3 and 14-N 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 A1NMThe Boeing CompanyNames 2 of 5 models: 767-300 Series and 767-200 Series TCDS A43NMAirbus SASNames 2 of 8 models: A340-311 and A340-211 TCDS A5EUAirbus SASNames all 2 models: BAC 1-11 200 Series and BAC 1-11 400 Series TCDS ATC 657Lockheed Aircraft CorporationNames all 2 models: 14-H2 and 14-H TCDS ATC 93Lockheed Aircraft CorporationNames all 2 models: Vega 5 and Vega 5-A Executive 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 2A11Lockheed Martin Aeronautics CompanyNames 1 of 1 model: 402-2 TCDS 4A17Lockheed Martin Aeronautics CompanyNames 1 of 1 model: 1649A-98 TCDS A-723Lockheed Martin Aeronautics CompanyNames 1 of 1 model: 18 TCDS A-781The Boeing CompanyNames 1 of 1 model: DC-6 TCDS ATC 133The Boeing CompanyNames 1 of 1 model: 100 TCDS ATC 384Lockheed Aircraft CorporationNames 1 of 1 model: Vega 5-C (Army UC-101)TCDS ATC 49 LockheedLockheed Aircraft CorporationNames 1 of 1 model: Vega 1 TCDS ATC 52The Boeing CompanyNames 1 of 1 model: Super Universal 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 551Lockheed Aircraft CorporationNames 1 of 1 model: Electra 10-A (Army UC-36A; Navy R-20; and XR-20-1)TCDS TC 584Lockheed Aircraft CorporationNames 1 of 1 model: Electra 10-B (Navy R-30-1)TCDS TC 590Lockheed Martin Aeronautics CompanyNames 1 of 1 model: Electra 10-E TCDS TC 616Lockheed Aircraft CorporationNames 1 of 1 model: 12-A (Army UC-40; UC-40A; Navy JO-1; JO-2)TCDS TC 719The Boeing CompanyNames 1 of 1 model: S-307

Back to AD 93-14-12