Boeing SB 747-53-2309
Service difficulty reports 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 s.sdr_id, s.difficulty_date, s.aircraft_make, s.aircraft_model, s.part_name, 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_service_difficulty_report.parquet' s ON s.sdr_id = c.record_id
WHERE c.document_id = 'boeing/sb-747-53-2309' AND c.record_type = 'faa_service_difficulty_report'
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 s.sdr_id, s.difficulty_date, s.aircraft_make, s.aircraft_model, s.part_name, 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_service_difficulty_report.parquet' s ON s.sdr_id = c.record_id WHERE c.document_id = 'boeing/sb-747-53-2309' AND c.record_type = 'faa_service_difficulty_report' 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.
SDR EIA2006150Web · Boeing 747121AFT CARGO STA 1480 APU DUCT CUT-OUT FOUND CRACK AT LT SIDE, APPROX 2" CRACK AT 1 O'CLOCK. CRACKED WEB REPAIRED IAW SB 747-53-2309 REV 1.SDR UPS05443930Bulkhead · Boeing 747123INSPECTION TYPE: C, BS 1480 BULKHEAD APU DUCT CUTOUT FOUND 3 FASTENER HOLES CRACKED. BS 1480 BULKHEAD REPAIRED PER SB 747-53-2309 UPS EO B747-5310-3100-C & DWG 144U2602.SDR EIA2000066Bulkhead · Boeing 747212BFOUND AFT CARGO COMPT BS 1480 LEFT BULKHEAD WEB CRACKED AT APU BLEED DUCT CUTOUT 1 O-CLOCK POSITION. BS 1480 LEFT BULKHEAD WEB REPAIRED AT APU BLEED DUCT CUTOUT AREA PER BOEING DWG 144U2602 AND SB 747SDR EIA980360Bulkhead Web · Boeing 747212BHKG - DURING C5 CHECK, BS 1480 APU DUCT CUTOUT FASTENER HOLES CRACKED ON BULKHEAD WEB. REPAIRED PER SB 747-53-2309. (M)SDR EIAA980360Web · Boeing 747212BHKG - DURING C5 CHECK, BS 1480 APU DUCT CUTOUT FASTENER HOLES CRACKED ON BULKHEAD WEB. REPAIRED PER SB 747-53-2309. (M)SDR P5CA9600807Bulkhead Web · Boeing 747122CRACK AT APU DUCT CUTOUT AT LEFT WHEEL WELL BULKHEAD. REPAIRED WITH KIT 015M0425-1 PER BAC SERVICE BULLETIN 747-53-2309.
Back to Boeing SB 747-53-2309