Boeing SB 727-57-0112
Service difficulty reports that cite it · 42
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-727-57-0112' 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-727-57-0112' 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 2007FA0001109Bracket · Boeing 727233RT PREVENTATIVE MODIFICATION FWD IB ANGLE CRACKED AT BS 760.95. REPAIRED CRACK AT RT BL 70.5, BS 760.95, UPPER AND LOWER MOST FORWARD HOLES. OVERSIZED CRACKED HOLE IAW 57-112. NDT PERFORMED TO CONFIRMSDR 07FDEA02503Rib · Boeing 727227COMPLY WITH EA 7-5710-110753, RT SIDE ONLY, WINGS- (AD 90-06-09 AND AD 94-07-08) MAIN FRAME, RIB UPPER CHORD REPAIR EO 7-5710-7-2308 PART 2. COMPLIED WITH EA 7-5710-110753 RT SIDE IAW SB 727-57-0112.SDR GAIA020129STRib · Boeing 727251DURING A LTC INSPECTION, IT WAS DISCOVERED THAT THE RIB CHORD AT FUSELAGE BS 760.95 LEFT WAS CRACKED AT THE FIRST TWO FORWARD HOLES. ACCOMPLISHED REPAIR IAW BOEING 727 SERVICE BULLETIN 727-57-0112, RESDR DL72S011952Rib · Boeing 727225AINSPECTIONS OF THE UPPER RIB CHORD ON THE RT WING AT RBL 70.5 PER BAC S/B 727-57-0112 AND AD 94-07-08 REVEALED A CRACK IN A FASTENER HOLE AT FS 760.95. THE HOLE WAS OVERSIZED TO REMOVE THE CRACK AND TSDR DL72S011702Rib · Boeing 727225AINSPECTION OF THE RBL 70.5 UPPER RIB CHORD AT FS 760.95 ON THE RT WING PER BAC S/B 727-57-0112 AND AD 94-07-08 REVEALED CRACK INDICATIONS IN TWO FASTENER HOLES. THE HOLES WERE OVERSIZED AND BUSHED TO SDR AALA20011666Rib · Boeing 727223TUL - FOUND STATION 760 RIB CHORD CRACKED BEHIND 760 RIGHT FRAME. STOP DRILLED CRACK. INSTALLED REPAIR DOUBLERS 760 RBL 70.5 IAW SB 727-57-0112 AS EPR CARD 4258 PAGE 2 ITEM 9. (M)SDR AALA20010988Rib · Boeing 727223TUL - FOUND DURING SCHEDULED C-CHECK INSPECTION, A CRACK WAS FOUND IN THE LBL 70.5 UPPER RIB CHORD AT BS 760. INSTALLED THE PREVENTATIVE MODIFICATION 65C33202-99 PER BOEING 727 SB 727-57-0112 WITH DEVSDR AALA20011029Rib · Boeing 727227TUL - FOUND CRACK IN RADIUS AT LEFT STATION 760 RIB CHORD. ROUTED OUT DAMAGE. INSTALLED REPAIR PER S/B 727-57-0112 AND ESO 11697 DATED 5/9/01. (M)SDR 2001F00630Rib · Boeing 727223TUL - FOUND BS 760.95 RIGHT RIB CHORD HFEC INDICATED CRACK ON VERTICAL LEG STOPPING AT TOP OF RADIUS. ACCOMPLISHED RIB CHORD REPAIR PER ESO 11697 (DATED 2-14-01), SB 727-57-0112 PART IV, LARGE REPAIR,SDR DL72W001862Rib · Boeing 727247THE BL 70.5 RIB CHORDS ON THE LT & RT WINGS WERE FOUND WITH TYPICAL FASTENER HOLE CRACKS IN THE VERTICAL FLANGE OF THE CHORDS AT FS 760.95. THE CRACKS ARE THE FWD FASTENER HOLE OF EACH CHORD AND ARE TSDR DL72S001439Rib · Boeing 727232THE RBL 70.5 WING RIB WAS FOUND WITH A CRACK AT FS 760.96. THE CRACK IS TYPICAL OF BAC S/B 727-57-0112 AND PROGRESSED BETWEEN TWO FASTENER HOLES. THE HOLES WERE OVERSIZED TO ENSURE CRACK CONTAINMENT ASDR GAIA00380Angle · Boeing 727214DURING ROUTINE C-CHECK, FOUND A CRACK IN THE FORWARD UPPER HOLE IN THE UPPER VERTICAL FLANGE OF THE WING TO BODY RIB FITTING UPPER CHORD AT RIGHT BS 760.95. COMPLIED WITH BOEING 727 SB 727-57-0112 REVSDR 2000UALA00017Rib · Boeing 727222DURING INSPECTION PER SB 727-57-0112 AS MANDATED BY AD94-07-08 ON THE LBL 70.5 RIB CHORD AT STATION 760.95, TWO CRACKED FASTENER HOLES WERE FOUND. CAUSE WAS FATIGUE. BOTH HOLES WERE OVERSIZED UNTIL THSDR AALA991846Angle · Boeing 727223TUL - RIGHT 760 CHORD ANGLE HFEC INDICATES CRACK BELOW RPR DOUBLER. INSTALLED REPAIR DOUBLER AT STATION 760 RIB CHORD ANGLE IAW SERVICE BULLETIN 727-57-0112, REV 5 AFTER CRACK STOP DRILLED. (M)SDR AALA991600Rib · Boeing 727227TUL - LEFT RIB CHORD CRACKED IN RADIUS UNDER DOUBLER STATION 760L. REMOVED DAMAGE, FABRICATED REPAIR PARTS AND INSTALLED IAW SB 727-57-0112 DWG 65C3302 ESO 11697 DATED 10-20-99. (M)SDR AALA991603Rib · Boeing 727227TUL - HFEC INDICATES CRACK IN RIB CHORD RADIUS INBOARD SIDE AT STATION 760R AT EDGE OF REPAIR DOUBLER. REMOVED DAMAGE, FABRICATED REPAIR PARTS AND INSTALLED IAW SB 727-57-0112, DWG 65C33202 AND ESO 11SDR 99UAL900396Rib · Boeing 727222TWO CRACKS WERE DISCOVERED EMANATING FROM TWO FASTENER HOLES OF THE STATION 750.95 RBL 70.5 RIB CHORD UPPER VERTICAL FLANGE. THE AFFECTED UPPER VERTICAL FLANGE WAS TRIMMED OUT AND A REPAIR WAS INSTALLSDR AALA991001Rib · Boeing 727227TUL - LEFT BS 760 RIB CHORD, HFEC SHOWS CRACK INDICATION APPROX .75 INCH AFT OF FLOORBEAM WEB AT LOWER EDGE OF REPAIR DOUBLER. REPAIRED PER SB 727-57-0112 FIG 12 SRM 57-10-5 PAGE 1, E589069177. (M)SDR 99UAL900385Structure · Boeing 727222EL0NGATED HOLES WERE FOUND AT APPROXIMATELY LBBL 70,5,WL 208 TO 214, BS 780.95 FUSELAGE SKIN, FRAME (P/N 85-16325-81) AND FRAME STRAP (P/N 65-16325-103). THE ELONGATED HOLES WERE OVERSIZED TO A CLEAN SDR 99UAL900386Rib · Boeing 727222TWO CRACKED FASTENER HOLES AT BS 760, WL 200 AT WING LBBL 70.5 RIB UPPER CHORD VERTICAL FLANGE WERE FOUND. ONE FASTENER HOLE WAS TRIMMED OUT AND REPAIRED WITH A FILLER, WHILE THE OTHER HOLE WAS REPAIRSDR AALA990397Casting · Boeing 727223TUL - FOUND CRACK IN RADIUS AND VERTICAL AREA OF LEFT 760 CASTING (BEHIND RIB). REPAIRED LEFT 760 CASTING PER BOEING SERVICE BULLETIN 727-57-0112 REV 5 LARGE REPAIR. (M)SDR 98FDEA00754Rib · Boeing 72725CBS 760 AT RBL 70.5 RIB UPPER CHORD IS CRACKED. FOUND AT COOL CHECK BY VISUAL INSP. LARGE REPAIR INSTALL IAW SB 727-57-0112.SDR RAAA98B1005Rib · Boeing 72722CDURING SCHEDULED AD 94-07-08 INSPECTION PER S/B 727-57-112, FOUND HFEC CRACK INDICATION FWD 2 EA VERTICAL FASTENER HOLES OF RT WING BL 70.5 UPPER RIB CHORD. REPAIRED PER S/B 727-57-0112, REV 4 M-54 NRSDR RAAA98B1006Rib · Boeing 72722CDURING SCHEDULED AD 94-07-08 INSPECTION PER S/B 727-57-112, FOUND HFEC CRACK INDICATION FWD 2 EA VERTICAL FASTENER HOLES OF LT WING BL 70.5 UPPER RIB CHORD. REPAIRED PER S/B 727-57-0112, REV 5 M-54 NRSDR 97FDEA00697Chord · Boeing 72721CNR 0706 036 STA-PAE - CORROSION (C53-224-05) CRACK IN RT 70.85 PLUS CHORD IS CRACKED ON UPPER VERTICAL FLANGE IN RADIUS FROM BS 760 TO 770, WL 201, RBL 70.5 LONG CRACK REPAIR REQUIRED PER S/B 727-57-0SDR TWAA9803813Stringer · Boeing 727231MCI - DURING OP 17 MAINTENANCE CHECK, THERE WAS A CRACK INDICATION AT THE TWO FORWARD HOLES STATION 760 STRINGER 18, BOTH 6 AND 12 O'CLOCK POSITION. REPAIRED PER ARA 11406 AND SB 727-57-0112. (M)SDR SCNA97109Frame · Boeing 727225DURING HEAVY MAINTENANCE VISIT, CRACKS WERE NOTED ON RIGHT PORTION OF FRAME 760 AROUND 2 FORWARD HOLES AND AFT UPPER HOLE. COMPLIED WITH FRAME REPAIR IAW BOEING SERVICE BULLETIN 727-57-0112 AND DRAWINSDR SCNA97110Frame · Boeing 727225DURING HEAVY MAINTENANCE VISIT, CRACKS WERE NOTED ON LEFT SIDE OF FRAME 760 AROUND 2 FORWARD HOLES. COMPLIED WITH FRAME REPAIR IAW SERVICE BULLETIN 727-57-0112 AND DRAWING 65C33202, 65C37221, AND 65C2SDR SCNA97095Frame · Boeing 727225DURING HEAVY MAINTENANCE VISIT, THREE HOLES WERE FOUND CRACKED IN THE LEFT AND RIGHT 760 FRAME, BL 70.5. INSTALLED 70.5 UPPER CHORD PREVENTATIVE MAINTENANCE MODIFICATION IAW EO 57-5127-1 AND SERVICE BSDR RAAA97B2025Rib · Boeing 72722CDURING AD 94-07-08 INSPECTION, FOUND LBL 70.5 WING RIB UPPER CHORD CRACKED VERTICALLY BETWEEN FORWARD HOLES (REF S/B 727-57-0112) AT BS 760.95. REPAIRED PER S/B 727-57-0112, REV 4, SECTION III, PART VSDR RAAA97B2026Rib · Boeing 72722CDURING AD 94-07-08 INSPECTION, FOUND RBL 70.5 WING RIB UPPER CHORD CRACKED VERTICALLY BETWEEN FORWARD HOLES (REF S/B 727-57-0112) AT BS 760.95. REPAIRED PER S/B 727-57-0112, REV 4 SECTION III, PART V.SDR TWAA9804001Rib · Boeing 727231MCI - DURING C-CHECK MAINTENANCE, THE LEFT WING EDDY CURRENT SHOWED CRACK INDICATION AT 6 AND 12 O'CLOCK POSITION IN RIB CHORD TOP FORWARD HOLE. LEFT BOTTOM FWD HOLE HAD 2 CRACKS IN VERTICAL LEG 2 ANDSDR EISA96261Chord · Boeing 72725RIGHT PLUS CHORD CRACKED AT FS 760.95 RBL 70.5. STOP DRILLED CRACK AND INSTALLED REPAIR PER SB 727-57-0112. (M)SDR EISA96262Rib · Boeing 72725FOUND 2 CRACKS FROM FASTENER HOLES IN RIGHT WING RIB CHORD UPPER VERTICAL FLANGE WS 70.5 RT SIDE. INSTALLED REPAIR PER SB 727-57-0112. (M)SDR AALA960724Wing Chord · Boeing 727223ATL - DURING CONTRACT MAINTENANCE AT DALA FOR HEAVY C-CHECK, CRACKS WERE DISCOVERED IN THE VERTICAL FLANGE OF THE LBL AND RBL 70.5 WING CHORD AT FS 760.95. REPAIRS WERE ACCOMPLISHED PER SB 727-57-0112SDR EISA96031Chord · Boeing 727223CRACK FOUND AT STATION 760 LBL 70.5 WING UPPER CHORD. INSTALLED PREVENTATIVE MODIFICATION KIT PER SB 727-57-0112 AND DRAWING 65C 33202. (M)SDR 95FDEA01840Chord · Boeing 7272S2FNOTED CRACK INDICATIONS LT 70.5 BS 760 WHILE PERFORMING INSPECTION CARD NR 7-5710-7-2308H PT1, CRACK LOCATIONS ARE THE FWD UPPER HOLE AT 11 AND 5 O'CLOCK POSITION L/B LOOKING I/B. CRACK INDICATION ARESDR EISA95475Frame · Boeing 72731HFEC INSPECTION INDICATES CRACKS IN FWD 2 FASTENER HOLES, FS 760 RIGHT FRAME CHORD UPPER VERTICAL FLANGE. FABRICATED REPAIR ANGLE REF, BAC DRAWING 65-68492. INSTALLED ALL REPAIR PARTS AND FASTENERS PESDR EISA95476Frame · Boeing 72731HFEC INSPECTION INDICATES CRACKS IN FORWARD 2 FASTENER HOLES FS 760 LT FRAME CHORD UPPER VERTICAL FLANGE. FABRICATED REPAIR ANGLE REF, BAC DRAWING 65-68492. INSTALLED ALL REPAIR PARTS AND FASTENERS PESDR 95FDEA01639Rib Chord · Boeing 72725NOTED CRACK INDICATION IN FORWARD UPPER AND LOWER FASTENER HOLES AT BS 760, LBL 70.5 RIB UPPER CHORD, CRACKED IN 6 AND 12 O'CLOCK POSITIONS IN CHORD, BOTH HOLES. REPAIRED DAMAGED AREA AT BS 760, LBL 7SDR EISA95326Rib Chord · Boeing 72782UPON A SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, THE BS 760R RIB CHORD UPPER VERTICAL FLANGE FORWARD OF FRAME IS CRACKED ACROSS HOLES AND FROM THE LOWER HOLE DIAGONALLY AFT .375 INCH. REMOVESDR EISA95318Gusset · Boeing 72782UPON A SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, CORROSION WAS FOUND ON THE GUSSET ON FORWARD SIDE OF FUSELAGE FRAME BS 760.95 RT, BY OUTER FLANGE BELOW CREASE AREA IN CABIN. REMOVED GUSSET,
Back to Boeing SB 727-57-0112