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 99-26-22HistoricalEscape SlidesAD 99-01-19HistoricalFuselage Cracking InspectionAD 98-22-05HistoricalLower Surface Panel Of Wing Center BoxAD 98-18-24HistoricalInner Flange Door Cracking InspectionAD 98-18-26HistoricalFront Spar Vertical Stringers on the WingsAD 98-13-14HistoricalFatigue Cracking InspectionAD 97-22-13HistoricalAFM ChangeAD 97-07-14HistoricalRib Flange Of Front SparAD 96-25-04HistoricalWing and horizontal stabilizer wire bundlesAD 96-18-06HistoricalPressurized Floor FittingAD 74-08-09 R2HistoricalWaste ReceptaclesAD 94-12-03HistoricalBelly Fairing StructureAD 92-02-14HistoricalEmergency Escape Slides
Back to TCDS A28NM