Boeing SB 767-53-0078
Service difficulty reports that cite it · 17
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-767-53-0078' 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-767-53-0078' 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 DL76S030132Frame · Boeing 767332INSPECTION OF THE FS 1809.5 BULKHEAD OUTER FRAMES PER BAC S/B 767-53-0078 AND AD 2001-09-13 REVEALED A CRACK IN THE FWD FRAME AND THE AFT FRAME ON THE RT SIDE NEAR STRINGER 12. THE FWD FRAME WAS REPLASDR DL767021028Frame · Boeing 767232THE FWD, OUTER CHORD OF THE FS 1809.5 WAS FOUND WITH A 5 INCH CRACK ALONG THE RADIUS NEAR STRINGER 7R. THE CRACK IS OUTSIDE THE AREA ADDRESSED BY BAC S/B 767-53-0078 AND AD 2001-09-13. THE CRACKED SECSDR DL76S020406Skin · Boeing 767332WHILE ACCOMPLISHING THE FS 1809.5 BULKHEAD OUTER CHORD MOD PER BAC S/B 767-53-0078 AND AD 2001-09-13, A CRACK WAS FOUND IN THE SKIN COMMON TO A FASTENER HOLE FOR THE OUTER CHORD ON THE LT SIDE. THE HOSDR DL767011519Bulkhead · Boeing 767232FUSELAGE / BULKHEAD / FS 1809.5 / RH / OUTER FWD CHORD : CRACK REPAIR INSPECTION OF THE FS 1809.5 BULKHEAD PER AD 2001-09-13 REVEALED A CRACK IN THE RH FWD OUTER CHORD TYPICAL OF THE AD AND BAC S/B 76SDR DL767011305Frame · Boeing 767232INSPECTION OF THE FS 1809.5 OUTER CHORDS PER AD 2001-09-13 AND BAC S/B 767-53-0078 REVEALED CRACKS EMANATING FROM TWO FASTENER HOLES IN THE RT FWD CHORD AND ONE HOLE IN THE RT AFT CHORD. THE AFT CHORDSDR DL767011215Frame · Boeing 767232DURING INSPECTION OF THE 1809 BULKHEAD PER S/B 767-53-0078 R.2, CRACKS WERE FOUND IN THE LT AND RT CHORDS REQUIRING PERMANENT MODIFICATION (SPLICING IN NEW SECTION OF CHORD PER THE SERVICE BULLETIN). SDR ABXA010363Frame · Boeing 767281DURING EDDY CURRENT INSPECTION OF THE RIGHT OUTER CHORD FLANGE, STA 1809.5, FOUND A CRACK AT WL 25.3. CRACK STARTED AT THE FORWARD END OF FLANGE, RAN THROUGH THE FIRST AND SECOND FASTENER HOLES TO THESDR ABXA010364Frame · Boeing 767281DURING EDDY CURRENT INSPECTION OF THE LEFT OUTER CHORD FLANGE, STA 1809.5, FOUND A CRACK AT WL 25.3. CRACK STARTED AT THE FORWARD EDGE OF FLANGE AND RAN TO THE FIRST FASTENER HOLE. REF BOEING NDT MANUSDR DL767011077Bulkhead · Boeing 767232DURING ACCOMPLISHMENT INSPECTIONS PER BAC S/B 767-53-0078, CRACKS WERE FOUND IN THE TENSION FITTING, FWD OUTER CHORD, AND SKIN. THE S/B ONLY COVERS CRACKS IN THE OUTER CHORD. CORRECTIVE ACTION: REPAIRSDR DL76S011039Frame · Boeing 767332BOLT HOLE HFEC INSPECTION OF FASTENERS COMMON TO THE RT FWD OUTER CHORD OF THE FS 1809.5 BULKHEAD INDICATED SMALL CRACKS IN 3 FASTENER HOLES. THE HOLES ARE COMMON TO THE INSPECTION AREA OF BAC S/B 767SDR DL76S011040Frame · Boeing 767332BOLT HOLE HFEC INSPECTION OF THE LT FWD OUTER CHORD OF THE FS 1809.5 BULKHEAD REVEALED A SMALL CRACK IN A FASTENER HOLE. THE FASTENER LOCATION IS COMMON TO THE INSPECTION AREA OF BAC S/B 767-53-0078 ASDR DL76G010971Frame · Boeing 7673P6INSPECTION OF THE FS 1809 BULKHEAD PER BAC SB 767-53-0078 AND AD 2001-09-13 REVEALED A CRACK IN THE LT OUTER CHORD. THE CRACKED SECTION OF CHORD WAS CUT OFF AND A NEW SECTION SPLICE IN PER THE REQUIRESDR DL767010926Frame · Boeing 767232ACCOMPLISHMENT OF PERMANENT REPAIR FOR CRACKED CHORD PER SB 767-53-0078.SDR DL767010883Frame · Boeing 767232INSPECTION OF THE FS 1809.5 BULKHEAD CHORDS PER BAC S/B 767-53-0078 AND AD 2001-09-13 REVEALED A CRACK IN THE AFT CHORD, 2 FASTENER HOLE CRACKS IN THE FWD CHORD, AND A FASTENER HOLE CRACK IN THE MID CSDR DL767992213Bulkhead Chord · Boeing 767232FUSELAGE BULKHEAD FS 1809.5, LBL 45 OUTER CHORD, CRACK REPAIR. THE FS 1809.5 BULKHEAD OUTER CAP WAS FOUND WITH A TYPICAL CRACK AT LBL 45. THE CRACK IS TYPICAL OF BAC S/B 767-53-0078. THE CRACKED SECTISDR DL76S992156Bulkhead Chord · Boeing 767332THE FS 1809.5 BULKHEAD OUTER CAP WAS FOUND WITH A CRACK TYPICAL OF BAC S/B 767-53-0078. THE CRACKED UPPER END OF THE CHORD WAS CUT AND REMOVED. A NEW SECTION WAS SPLICED IN PER THE PROCEDURES OUTLINEDSDR DL76S992135Bulkhead Cap · Boeing 767332THE OUTER CHORD OF THE FS 1809.5 BULKHEAD WAS FOUND WITH A CRACK AT RBL 45 & WL 250. THE CRACK IS TYPICAL OF THAT DOCUMENTED IN BAC S/B 767-53-0078. THE CRACK WAS REPAIRED PER THE PROCEDURES OF THE S/
Back to Boeing SB 767-53-0078