TCDS T00008NY
Airworthiness directives · 82
ADs whose products are models on this data sheet, matched by model and maker. Those in force first, newest first.
Query with SQL
duckdb -csv -c "SELECT d.ad_number, d.status, d.subject, d.effective_date FROM 'https://openairdocs.org/data/latest/faa_directive.parquet' d WHERE d.ad_id IN (SELECT ad_id FROM 'https://openairdocs.org/data/latest/faa_directive_product.parquet' WHERE tcds_number = 'T00008NY') ORDER BY d.status = 'Historical', coalesce(d.effective_date, d.publication_date) DESC"
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 d.ad_number, d.status, d.subject, d.effective_date FROM 'https://openairdocs.org/data/latest/faa_directive.parquet' d WHERE d.ad_id IN (SELECT ad_id FROM 'https://openairdocs.org/data/latest/faa_directive_product.parquet' WHERE tcds_number = 'T00008NY') ORDER BY d.status = 'Historical', coalesce(d.effective_date, d.publication_date) DESC
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.
AD 2022-25-19Hardware, Engine ExhaustAD 2022-21-03FuelAD 2022-16-02DoorsAD 2022-16-08Turbine/turboprop engineAD 2022-11-21Equipment/furnishingsAD 2022-05-03Equipment/FurnishingsAD 2022-03-06Fire protectionAD 2022-02-07FuelAD 2021-26-27Equipment/FurnishingsAD 2021-16-19EnginesAD 2021-22-17FuselageAD 2021-20-07FuselageAD 2021-15-02Flight control systemAD 2021-17-07Aircraft fuel systemAD 2021-13-20FuselageAD 2021-14-09FuelAD 2021-05-10FuelAD 2020-26-20OxygenAD 2020-21-02Fire protectionAD 2020-09-10Cargo and accessory compartmentAD 2020-05-13Ice and rain protectionAD 2017-22-14NavigationAD 2025-06-01HistoricalTurbine/turboprop engineAD 2024-04-11HistoricalElectrical PowerAD 2024-04-06HistoricalFuelAD 2023-05-08HistoricalTime Limits/Maintenance ChecksAD 2022-25-51HistoricalAutoflightAD 2022-19-09HistoricalLanding GearAD 2021-09-03HistoricalEquipment/furnishingsAD 2021-04-05HistoricalTime Limits/Maintenance ChecksAD 2019-23-15HistoricalTime Limits/ Maintenance ChecksAD 2018-25-04HistoricalCargo and accessory compartment
Back to TCDS T00008NY