Boeing SB 727-53-0179
Service difficulty reports that cite it · 22
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-53-0179' 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-53-0179' 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 C8GA20080067Stringer · Boeing 727223WHILE IN HEAVY MX PERFORMING INSP IT WAS NOTED THAT STRINGER 29R WAS CORRODED UNDER BS 950E FRAME EXTENDING TO BS 1000. CORROSION AT STR. 29R WAS OUT OF LIMITS. CUT OUT DAMAGED STR 29R AT BS 950 TO 10SDR C8GA20080070Stringer · Boeing 727223WHILE IN HEAVY MX PERFORMING INSP, IT WAS NOTED THAT STRINGER 29L STA 950C - 1000 IS CORRODED. REMOVED AND REPLACED STRINGER 29L P/N 65-56441-7. INSTALLED STRINGER IAW SB 727-53-0179. NO OTHER DEFECTSSDR DHL2008749012Stringer · Boeing 7272J0AFT PIT STRINGER 29L CRACKED AT SPLICE AFT OF BS 950. REMOVED AFT PIT STRINGER 29L, LOCATED AND DRILLED NEW STRINGER. INSTALLED NEW STRINGER IAW SB 727-53-0179.SDR DHL2008749013Stringer · Boeing 727223AFT PIT STRINGER 29R CRACKED AT SPLICE AFT OF BS 950. REMOVED AFT PIT STRINGER 29R, LOCATED AND DRILLED NEW STRINGER 29L P/N 65-52441-8 PO NR 7370104. INSTALLED NEW STRINGER 29L FROM BS 950 TO BS 1010SDR DHL2007741558Stringer · Boeing 7272Q9AFT PIT, STRINGER 29L CORRODED BETWEEN BS 950F AND 990. CORROSION EXCEEDED ALLOWABLE LIMITS. REMOVED DAMAGED STR 29L SECTION, LOCATED, DRILLED, TREATED, PRIMED, AND INSTALLED NEW STR 29L SECTION P/N 6SDR DHL2007740549Stringer · Boeing 7272Q9AFT PIT BETWEEN BS 950A AND 950C, CORROSION ON STR 29L. CORROSION BEYOND ACCEPTABLE LIMITS, REF SB 727-53-0179. GAINED ACCESS BY REMOVING ALL CARGO FLOOR SUPPORTS FROM BS 950A TO BS 990, RBL 16 TO LBLSDR 06FDEA2081None · Boeing 727233FOUND PREVIOUSLY REPAIR INSTALLED FROM STA 970-990, STR 29R WAS DETERMINED TO BE ACCOMPLISHED PER BOEING SB 727-53-0179, BASED ON AN EXTERNAL VISUAL EVALUATION, CONSISTS OF LOCATION, SIZE, SHAPE, MATESDR DHL2006754512Stringer · Boeing 727223AFT CARGO COMPT STR 29L IS CORRODED WITH EXFOLIATION BETWEEN STA 950E & 950F. REMOVED AND REPLACED STR 29 LEFT FROM BS 950 TO 1010 P/N 65-56441-7 PO 626034 IAW SB 727-53-0179 FIG 12.SDR 06FDEA1466Repair · Boeing 727227FOUND PREVIOUSLY REPAIR INSTALLED AT STA 988 STR 29L WAS ACCOMPLISHED IAW SB 727-53-0179 BASED ON AN EXTERNAL VISUAL EVALUATION CONSISTS OF LOCATION, SHAPE, SIZE, FASTENER SPACING AND NUMBERS, MATERIASDR 06FDEA1470Repair · Boeing 727200FOUND PREVIOUSLY REPAIR INSTALLED AT STA 970 STR 29R WAS ACCOMPLISHED IAW S/B 727-53-0179 BASED ON AN EXTERNAL VISUAL EVALUATION CONSISTS OF LOCATION, SIZE, SHAPE, FASTENER SPACING AND NUMBERS, MATERISDR 05FDEA03904Stringer · Boeing 727233AFT CARGO COMPARTMENT BILGE AREA, STR 29L HAS CORROSION STA 1010. REMOVED DAMAGED SEGMENT OF KEEL STA 980-1007 STR 29L. REMOVED PRODUCTION SPLICE CHANNEL. REMOVED SECTION OF SHEAR TIE, FRAME 990 STR 2SDR CALA9801910Stringer · Boeing 727243INSPECTION FOUND STRINGER 29R CORRODED AT STA 1000. THE CORRODED AREA WAS CUT OUT AND REPAIR PARTS WERE INSTALLED IAW SRM 51-40-3, 51-10-2, AND SB 727-53-0179.SDR B4MR98009Stringer · Boeing 727243DURING ACCOMPLISHMENT OF AD 92-12-03, FOUND STR 28L AT FS 950A HAS CORROSION FWD OF BEAM. REMOVED CORROSION IAW B727 SRM 51-10-1. ULTRASONIC THICKNESS CHECK, INTERGRANULAR CORROSION DETECTED REINSPECTSDR 97FDEA00806Keel Beam · Boeing 72722NR 0388 016 CORROSION ON THE L/H KEEL BEAM BETWEEN SKIN BS 1065. *** S/D *** REMOVED CORROSION, FOUND OUT OF LIMITS. REMOVED DAMAGED PORTION BS 1057 TO 1087. REMOVED DAMAGED SKIN BS 1065. REMOVED DAMASDR AALA971721Keel Beam · Boeing 727223TUL - OUTBOARD STRINGER 29L AT STATION 950A PLUS 3 CORRODED. INSTALLED REPAIR IAW BOEING SB 727-53-0179 DATED JULY 13, 1989 NOTE PAGE 45. (M)SDR AALA971228Stringer · Boeing 727233TUL - STR 29L CORRODED AT BS 950 - BS 1007. CLEANED STRINGER, INSTALLED REPAIR STRAP PER ESO 11697 DATED 6-13-97 AT STA 950E TO STA 980, AND REPAIRED STRINGER PER SB 727-53-0179 FROM STA 980 TO STA 10SDR 97FDEA00284Keel Beam · Boeing 72725NR 0116 014, CORROSION ON RT KEEL BEAM AT BS 973, RBL 7, WL 138. *S/D* REMOVED AND REPLACED RT KEEL BEAM AT BS 960, RBL 17, WL 138 IAW SB 727-53-0179.SDR 96FDEA01356Keel Beam · Boeing 72722NR0647 AND 010, CORROSION (C53-100-3) BETWEEN SKIN AND KEEL BEAM BS 1062 STR 29R. *S/D* REMOVED AND REPLACED RT KEEL BEAM STR 29R FROM BS 960 TO BS 1090 PER SB 727-53-0179.SDR 96FDEA01323Keel Beam · Boeing 72722NR0201 AND 002, BS 1050 STR 29L LBL 6 THERE IS A BULGE IN SKIN. *S/D* REMOVED AND REPLACED LT KEEL BEAM STR 296 FROM BS 960 TO BS 1090 PER SB 727-53-0179.SDR SCNA96148Stringer · Boeing 727225DURING HEAVY MAINTENANCE VISIT, CORROSION WAS FOUND ON STRINGER 29R AT BS 993. FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH SB 727-53-0179, LMAC EO 3775, B727 SRM 53-10-2 FIGURE 5, SHEET 22, ITESDR AALA960664Stringer · Boeing 727223TUL - FOUND STRINGER 29R CORRODED AT BELL FRAMES FROM STATION 950 TO 970. REPLACED STRINGER 29R, INSTALLED SKIN DOUBLER PER SB 727-53-0179. STRINGER REPLACED FROM 950 TO 1005. (M)SDR 95ZZZX3067Beam · Boeing 727227BFM - RT AND LT KEEL BEAMS, STA 950 - STA 1010, HAS CORROSION AROUND FASTENERS HOLES, ENTIRE LENGTH (AFT CARGO BAY). REMOVED AND REPLACED LT/RT KEEL BEAM CHORDS PER SB 727-53-0179.
Back to Boeing SB 727-53-0179