B/E Aerospace SB 174080-35-01
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
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 = 'be-aerospace/sb-174080-35-01' 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 = 'be-aerospace/sb-174080-35-01' 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 2010-14-06Air Transport Association (ATA) of America Code 35: Oxygen. · Boeing 737-200 Series, 737-300 Series, 737-400 Series and 1 moreAD 2008-13-21Oxygen masks · Boeing 767-200 Series, 767-300 Series and 767-400ER SeriesAD 2008-12-05Oxygen masks · Boeing 777-200 Series, 777-200LR Series, 777-300 Series and 1 moreAD 2008-08-08Oxygen masks in the passenger service units · Boeing 757-200 Series, 757-200CB Series, 757-200PF Series and 1 moreAD 2008-06-24Oxygen masks · Boeing 737-300 Series, 737-400 Series and 737-500 SeriesAD 2007-26-06Prevent the in-line flow indicators of the passenger oxygen masks from fracturing and separating · Boeing 747-200B Series, 747-300 Series and 747-400 Series
Back to B/E Aerospace SB 174080-35-01