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 2013-19-09HistoricalNavigationAD 2013-18-09HistoricalCommunicationsAD 2013-16-09HistoricalLanding gearAD 2013-13-04HistoricalLanding GearAD 2012-26-15HistoricalNavigationAD 2012-26-51HistoricalNavigationAD 2012-23-10HistoricalEquipment/FurnishingsAD 2012-20-07HistoricalPeriodic InspectionsAD 2012-18-12HistoricalEquipment/furnishingsAD 2012-09-07HistoricalWingsAD 2011-19-04HistoricalFlight controlsAD 2011-19-01HistoricalInstrumentsAD 2011-14-06HistoricalWingsAD 2011-13-11HistoricalLanding GearAD 2010-24-07HistoricalFuselageAD 2010-23-07HistoricalStabilizersAD 2009-21-10HistoricalOxygenAD 2007-15-06 R1HistoricalFuel tank systemAD 2009-20-05HistoricalFuselageAD 2009-17-04HistoricalFlight controlsAD 2008-23-01HistoricalFuel tank boost pumpsAD 2008-08-04HistoricalMain landing gear (MLG)AD 2007-20-05HistoricalWing/fuselage joint cruciform fittingsAD 2007-18-09HistoricalBraking and steering control units (BSCUs)AD 2007-13-08HistoricalAuxiliary power unit air intakeAD 2007-11-11HistoricalMLG sliding tubesAD 2007-06-18HistoricalDefective actuatorAD 2007-05-13HistoricalYZ-latches of the cargo loading systemAD 2006-11-04HistoricalMain landing gear (MLG)AD 2006-06-14HistoricalMagnetic fuel level indicators (MFLI)AD 2006-03-10HistoricalHorizontal hinge pinAD 2005-23-02HistoricalAdditional center tank (ACT)AD 2005-15-07HistoricalElectrical cables of the S routesAD 2005-13-39HistoricalAirplane flight manualAD 2005-02-09HistoricalAirworthiness Limitations Section (ALS)AD 2004-25-02HistoricalCracking in certain areas of the fuselageAD 2004-19-11HistoricalRear spar web of the wingAD 2004-14-09HistoricalWing center boxAD 2004-15-14HistoricalAirplane Flight Manual (AFM) - Electrical PowerAD 2004-11-13HistoricalMain landing gear (MLG)AD 2004-07-02HistoricalMain landing gear (MLG)AD 2004-03-06HistoricalWing/Fuselage Joint Cruciform FittingsAD 2004-03-07HistoricalFasteners Attaching Pressure Panel to Flexible Bracket at Frame 36AD 2004-03-19HistoricalPick-up angles of the center fuselage areaAD 2003-26-03HistoricalLitton air data inertial reference units (ADIRU)AD 2003-25-07HistoricalElevator and Aileron Computers (ELACs)AD 2003-18-06HistoricalEngine fan cowl door latchesAD 2002-10-06HistoricalFlight Warning Computers (FWCs)AD 2002-08-13HistoricalParking Brake Operated Valve (PBOV)AD 2000-10-15HistoricalAttachment Holes Main Landing Gear (MLG)
Back to TCDS A28NM