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 2018-16-02HistoricalPowerplantAD 2018-14-09HistoricalFuselageAD 2018-13-08HistoricalWingsAD 2018-09-09HistoricalWingsAD 2018-03-12HistoricalFuselageAD 2018-02-18HistoricalNavigationAD 2017-25-04HistoricalTime Limits/Maintenance ChecksAD 2017-22-07HistoricalDoorsAD 2017-22-03HistoricalPeriodic InspectionsAD 2017-19-24HistoricalTime Limits/Maintenance ChecksAD 2017-14-14HistoricalFuselageAD 2017-13-12HistoricalLanding GearAD 2017-12-13HistoricalFuselageAD 2017-05-12HistoricalFuselageAD 2017-01-11HistoricalLanding gearAD 2017-01-06HistoricalDoorsAD 2016-20-12HistoricalPeriodic inspectionsAD 2016-19-14HistoricalEquipment/FurnishingsAD 2016-18-09HistoricalFuselageAD 2016-17-12HistoricalFlight ControlsAD 2016-14-03HistoricalFuselageAD 2016-09-07HistoricalNavigationAD 2016-07-23HistoricalDoorsAD 2016-07-14HistoricalFuselageAD 2016-07-12HistoricalNacelles/pylonsAD 2016-02-01HistoricalWingsAD 2016-01-11HistoricalWingsAD 2015-23-13HistoricalAuto Flight; InstrumentsAD 2015-22-08HistoricalLanding GearAD 2015-22-06HistoricalFlight ControlsAD 2015-17-14HistoricalFuselageAD 2015-15-13HistoricalFuselageAD 2015-15-10HistoricalFlight ControlsAD 2015-12-08HistoricalOxygenAD 2015-02-14HistoricalFuselageAD 2015-05-02HistoricalPeriodic InspectionsAD 2014-23-15HistoricalPeriodic InspectionsAD 2014-26-10HistoricalTime Limits/Maintenance ChecksAD 2015-03-02HistoricalWingsAD 2014-25-51HistoricalNavigationAD 2014-26-53HistoricalWingsAD 2014-24-07HistoricalFuselageAD 2014-22-08HistoricalTime Limits and Maintenance ChecksAD 2014-20-04HistoricalFuselageAD 2014-13-12HistoricalOxygenAD 2014-14-06HistoricalPowerplantAD 2014-08-01HistoricalFlight controlsAD 2014-03-08HistoricalFlight controlsAD 2013-25-11HistoricalEquipment/Furnishings and FuselageAD 2013-20-11HistoricalOxygen
Back to TCDS A28NM