TCDS A28NM
Airworthiness directives · 663
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 = 'A28NM') 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 = 'A28NM') 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-18-09HistoricalEquipment/FurnishingsAD 2022-15-05HistoricalFuselageAD 2022-14-10HistoricalWingsAD 2022-09-16HistoricalTime Limits/Maintenance ChecksAD 2022-10-08HistoricalEquipment/FurnishingsAD 2022-08-08HistoricalFuselageAD 2022-07-08HistoricalTime Limits/Maintenance Checks, Flight ControlsAD 2022-07-15HistoricalLanding gearAD 2022-06-02HistoricalEquipment/furnishingsAD 2022-04-09HistoricalOxygen SystemAD 2022-04-03HistoricalTime Limits/Maintenance ChecksAD 2022-02-11HistoricalFuselageAD 2021-23-15HistoricalEquipment/FurnishingsAD 2021-25-14HistoricalWingsAD 2021-22-04HistoricalWingsAD 2021-20-08HistoricalElectrical PowerAD 2021-16-01HistoricalTime Limits/Maintenance ChecksAD 2021-18-08HistoricalHydraulic
PowerAD 2021-14-08HistoricalNavigationAD 2020-26-01HistoricalLanding gearAD 2020-25-03HistoricalEquipment/furnishingsAD 2020-22-16HistoricalTime Limits/Maintenance ChecksAD 2020-21-11HistoricalTime Limits/Maintenance ChecksAD 2020-20-05HistoricalTime Limits/Maintenance ChecksAD 2020-21-10HistoricalTime Limits/Maintenance ChecksAD 2020-16-01HistoricalFire protectionAD 2020-12-11HistoricalAuto FlightAD 2020-06-10HistoricalFuselageAD 2020-05-16HistoricalWingsAD 2020-06-18HistoricalFlight controlsAD 2019-26-11HistoricalEquipment/ furnishingsAD 2020-01-17HistoricalEquipment/ furnishingsAD 2019-24-13HistoricalFuselageAD 2019-23-01HistoricalTime Limits/ Maintenance ChecksAD 2019-21-10HistoricalWingsAD 2019-20-10HistoricalFuselageAD 2019-20-03HistoricalInformation systemsAD 2019-19-15HistoricalTime Limits/ Maintenance ChecksAD 2019-18-07HistoricalFuselageAD 2019-14-04HistoricalTime Limits/Maintenance ChecksAD 2019-12-07HistoricalLanding gearAD 2019-07-05HistoricalElectric and Electronic Common InstallationAD 2019-03-25HistoricalWingsAD 2019-03-18HistoricalLanding GearAD 2019-05-09HistoricalElectric and electronic common installationAD 2019-03-17HistoricalTime Limits/Maintenance ChecksAD 2018-25-02HistoricalTime Limits/Maintenance ChecksAD 2018-23-02HistoricalFlight controlsAD 2018-17-19HistoricalTime Limits/Maintenance ChecksAD 2018-16-04HistoricalTime Limits/Maintenance Checks
Back to TCDS A28NM