Airworthiness directives that cite it · 6

Newest first, with the revision each cites, as OpenAirDocs read it from the records’ text. OpenAirDocs read these citations from the records’ text, so one can be misread: check it against the record. A newer revision may exist that no record cites.

Query with SQL

SELECT d.ad_number, d.status, d.subject, d.effective_date, string_agg(DISTINCT c.revision, ', ' ORDER BY c.revision) AS revisions, bool_or(c.incorporated_by_reference) AS incorporated_by_reference, bool_or(c.in_regulatory_text) AS in_regulatory_text FROM 'https://openairdocs.org/data/latest/service_document_citation.parquet' c JOIN 'https://openairdocs.org/data/latest/faa_directive.parquet' d ON d.ad_id = c.record_id WHERE c.document_id = 'boeing/747-53a2427' AND c.record_type = 'faa_directive' GROUP BY ALL ORDER BY max(c.record_date) DESC

duckdb -csv -c "SELECT d.ad_number, d.status, d.subject, d.effective_date, string_agg(DISTINCT c.revision, ', ' ORDER BY c.revision) AS revisions,
    bool_or(c.incorporated_by_reference) AS incorporated_by_reference, bool_or(c.in_regulatory_text) AS in_regulatory_text
  FROM 'https://openairdocs.org/data/latest/service_document_citation.parquet' c JOIN 'https://openairdocs.org/data/latest/faa_directive.parquet' d ON d.ad_id = c.record_id
  WHERE c.document_id = 'boeing/747-53a2427' AND c.record_type = 'faa_directive'
  GROUP BY ALL
  ORDER BY max(c.record_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, string_agg(DISTINCT c.revision, ', ' ORDER BY c.revision) AS revisions,
  bool_or(c.incorporated_by_reference) AS incorporated_by_reference, bool_or(c.in_regulatory_text) AS in_regulatory_text
FROM 'https://openairdocs.org/data/latest/service_document_citation.parquet' c JOIN 'https://openairdocs.org/data/latest/faa_directive.parquet' d ON d.ad_id = c.record_id
WHERE c.document_id = 'boeing/747-53a2427' AND c.record_type = 'faa_directive'
GROUP BY ALL
ORDER BY max(c.record_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 2014-14-03Fuselage · Boeing 747-100 Series, 747-100B Series, 747-100B SUD Series and 9 moreEffective Jul 15, 2014 · Supersedes AD 2014-07-01 · Revisions 6 and 7 · incorporated by reference AD 2014-07-01Fuselage · Boeing 747-100 Series, 747-100B Series, 747-100B SUD Series and 9 moreEffective Jun 3, 2014 · Replaced by AD 2014-14-03 · Revisions 6 and 7 · incorporated by reference AD 2010-14-07Air Transport Association (ATA) of America Code 53: Fuselage. · Boeing 747-100 Series, 747-100B Series, 747-100B SUD Series and 9 moreEffective Aug 5, 2010 · Supersedes AD 2006-05-06 · Revisions 1, 2, 4 and 5 · incorporated by reference AD 2006-05-06Body station (BS) 2598 bulkhead · Boeing 747-100 Series, 747-100B Series, 747-100B SUD Series and 9 moreEffective Apr 13, 2006 · Replaced by AD 2010-14-07 · Revisions 2 and 3 · incorporated by reference AD 2001-15-03Forward Inner Chord of the Upper Corner of Station 2598 Bulkhead · Boeing 747-100 Series, 747-100B Series, 747-100B SUD Series and 9 moreEffective Aug 28, 2001 · Replaced by AD 2006-05-06 · Revisions 1 and 2 · incorporated by reference AD 2000-08-21Forward and Aft Inner Chords · Boeing 747 Series (all)Effective Jun 5, 2000 · Replaced by AD 2001-15-03 · Revision 1 · incorporated by reference

Back to Boeing ASB 747-53A2427