TCDS T00005NY
Airworthiness directives · 60
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 = 'T00005NY') 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 = 'T00005NY') 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 2012-06-03StabilizersAD 2011-01-09OxygenAD 2010-07-06Landing gearAD 2006-10-10Arced or damaged electrical connectionAD 2023-11-01HistoricalElectrical PowerAD 2020-07-13HistoricalAuto flightAD 2013-11-12HistoricalHydraulic PowerAD 2011-07-10HistoricalAir conditioningAD 2010-10-18HistoricalAir conditioning and Equipment/FurnishingsAD 2009-25-13HistoricalEquipment/Furnishings
Back to TCDS T00005NY