JASC 5310
Service difficulty reports · 38,573
Reports filed under 5310 · Fuselage Main, Structure, newest first.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE jasc_code = '5310' ORDER BY difficulty_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 sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE jasc_code = '5310' ORDER BY difficulty_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 FDEA201112135253Fitting · damagedFOUND EXTERNAL COUPLING DAMAGED. CARRIED OUT REPAIR IAW EA 6-5310-155852, REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV 113.SDR AALA20111213TUL08Window Frame · crackedWINDOW FRAME, FORWARD BOTTOM TAB HAS CRACK AT STATION 1098 ON RIGHT SIDE. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR SWAA20111213378Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 847 TO BS 867, STR 17L. R&R WEB IAW SRM AND DWG.SDR SWAA20111213343Crease Beam · crackedDURING SCHEDULED 16Y CHECK, FOUND R2 DOOR CREASE BEAM WEB CRACKED AT BS 1004, BETWEEN RBL 45 TO RBL 50. R&R WEB IAW SRM AND DWG.SDR SWAA118340Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND R2 DOOR CREASE BEAM WEB CORRODED BETWEEN BS 500+2 TO BS 500+10, LBL 73. REPAIRED WEB IAW SRM AND DWG.SDR SWAA20111213339Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND R2 DOOR CREASE BEAM CORRODED BETWEEN BS 927 TO BS 947. REPAIRED BEAM IAW SRM AND DWG.SDR DALA1169605533Crease Beam · damagedCREASE BEAM REPAIR. CURRENT ER/A REVISION IS 'A'. SECTION II INSP REQUIREMENT HAS BEEN ADDED. ACCOMPLISH SECTION II NO LATER THAN 36200 TOTAL A/C FLIGHT CYCLES. THE SECTION II INSPECTION IS PENDING A STAGE III DAMAGE TOLERANCE ANALYSIS. CONTACT ENGINEERISDR QXEA2011121901400Door Frame · corrodedAFT PAX DOOR CUTOUT FORWARD FRAME STA X669.300 POSSIBLE CORROSION ON FORWARD SURFACE OF FRAME BETWEEN STR 13L - 14L. REMOVED CORROSION IAW 51-21-00-00-02. MINIMUM REMAINING THICKNESS .066", CONFIRMED CRACK FREE IN BLEND AREAS REF NTM 51-00-02-250-801 AND 51-SDR QXEA2011121901398Door Frame · damagedFWD PAX DOOR SURROUND TOP AFT DOOR STOP FITTING LOAD BEARING SURFACE IS WORN. SMOOTHED DAMAGE ON TOP AFT DOOR STOP FITTING IAW SRM 51-14-00-02-04. MATERIAL LOSS FOUND TO BE WITHIN LIMITS IAW RD 8/4-53-4174. CONFIRMED CRACK FREE CONDITION REF NTM 51-00-06-91SDR QXEA2011121901397Door Frame · damagedFWD PAX DOOR SURROUND - SURROUND FROM TOP AFT DOOR STOP SITTING LOAD BEARING SURFACE IS WORN. SMOOTHED DAMAGE ON TOP AFT DOOR STOP FITTING SECOND FROM TOP IAW SRM 51-14-00-02-04. MATERIAL LOSS FOUND TO BE WITHIN LIMITS IAW RD 8/4-53-4174. CONFIRMED BLENDED SDR AALA20111211TUL01Door Frame · crackedDOOR JAMB WEB HAS A CRACKED TAB STATION 207 AT LONGERON 15 LEFT. REPAIRED WEB PER AARD 53-10-00-11.SDR SWAA20111211470Crease Beam · corrodedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 480 TO BS 500, STR 17L. REPAIRED BEAM IAW EA.SDR ASOA2011121000011Beam · corrodedDURING C-CHECK, REMOVED CARGO DOOR LOWER BEAM BETWEEN FRAMES 65-68 TO FOM. MX R & R CARGO DOOR LOWER BEAM BETWEEN FRAMES 65-68 IAW SRM 51-40-02 AND CPM 51-21-06. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR USAA2011122900010Door Frame · corrodedC2 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FORWARD CARGO DOOR SILL FRAME BETWEEN FR24 TO FR26, S26R. REPLACED FORWARD CARGO DOOR SILL FRAME BETWEEN FR24 TO FR26, S26R IAW ERJ-190 SRM 53-21-11.SDR USAA2011122900007Door Frame · corrodedC2 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FORWARD CARGO DOOR SILL FRAME BETWEEN FR24 TO FR26, S26R. REPLACED FORWARD CARGO DOOR SILL FRAME BETWEEN FR24 TO FR26, S26R IAW ERJ-190 SRM 53-21-11.SDR SWAA20111208465Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 993, STR 20R. REPAIRED WEB IAW SRM AND DWG.SDR SWAA118464Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 807 TO BS 827, STR 17L. REPAIRED WEB IAW SRM AND DWG.SDR DALA1508530906Door Frame · unknownR & R LT FWD MLG DOOR JAMB FRAME AS REQUIRED IAW ER/A 50527-14, ORIGINAL DWG 5930584 AND SRM 51-10-3, ALODINE AND PRIME OF BARE METAL, SRM 51-10-4, FASTENER HOLE DRILLING, SRM 51-30-1, 51-30 AND 51-30-5 FASTENER INSTALLATION.SDR DALA1168519232Door Frame · corrodedDURING HMV IN MIA FOUND MID LOWER CARGO COMPARTMENT DOOR JAMB HAS SURFACE CORROSION AT SEVERAL PLACES. REMOVED CORROSION AND FOUND OUT OF LIMITS, ACCOMPLISHED REPAIR AT MID CARGO DOOR JAMB AND REPLACED FLOOR SUPPORT BETWEEN STA 674 AND 769 L29R IAW MD90 SRM 5SDR FDEA201112075204Crease Beam · gougedMAIN CABIN AREA RT SIDE AT BS 1280 CREASE BEAM GOUGED.SDR FDEA201112065178Crease Beam · corrodedRIGHT MAIN DECK CREASEBEAM CORRODED, BS 776. BLENDED AREA IAW SRM 51-10-02. ORIGINAL MATERIAL .090 AFTER BLENDING MATERIAL .040 MATERIAL LOSS .050. OUT OF LIMITS IAW SRM 53-30-13, DETAIL III, FIG 101. REMOVED CREASE BEAM IAW SRM 51-40-02. FABED INBD CHORD FSDR AALA20111206TUL04Door Frame · crackedFORWARD CABIN ENTRY DOOR JAMB AFT SIDE TANG CRACKED AT FRAME STATION 208 LONGERON 15 LEFT. REMOVED CRACK BY CUTTING OFF TAB AND INSTALLED DOUBLER PER AARD 53-10-00-11.SDR SWAA20111206390Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND L2 DOOR CREASE BEAM CORRODED AT BS 957. REPAIRED BEAM IAW SRM AND DWG.SDR DALA1503839235Frame · unknownBS 883-BS962 OVERWING FRAMES REPAIRED IAW AA 5310-01375.SDR SWAA118722Crease Beam · corrodedDURING SCHEDULED 24Y CHECK, FOUND O/B CREASE BEAM CORROSION BS 889 TO 892 AND 896 TO 899, STR 17L, WL 208. REPAIRED PER SRM.SDR ZZDA2011989Door Frame · crackedFWD CABIN L1 DOOR CUTOUT - AFT JAMB INNER SKIN, STA 200, LONG S15L, CRACKED. ACCOMPLISHED L1 DOOR CUTOUT - AFT JAMB INNER SKIN DOUBLER & FILLER REPAIR PER B717 SRM 51-70-10 .SDR AALA20111202TUL10Door Frame · crackedDOOR JAMB WEB HAS CRACKED TAB STATION 207 AT LONGERON 15 LEFT. INSTALLED DOUBLER PER AARD 53-10-00-11.SDR ASOA2011120202302Crossbeam · corroded280 CROSSBEAM CORRODED ON LT SIDE TOP AND CENTER SECTION. (OPEN)SDR C77A201112020004Beam · corrodedFWD CARGO BEAM CORRODED.SDR FDEA201112025120Beam · corrodedBS 1862 AFT SIDE, THERE IS CORROSION AT LOWER BULKHEAD AT S26L OTBD BEAM APPROX 12" ABOVE THE SKIN. REPAIR CARRIED OUT IAW EA F-5310-157123, PART 1. REPAIR IS CLASSIFIED AS MAJOR.SDR FDEA201112025119Beam · corrodedEMPENNAGE - BS 1862 AFT SIDE - THERE IS CORROSION AT LOWER BULKHEAD AT S28L INBD BEAM APPROX 12" ABOVE THE SKIN. REPAIR CARRIED OUT IAW EA F-5310-157122, PART 1. REPAIR IS CLASSIFIED AS MAJOR.SDR FDEA201112015131Crease Beam · corrodedMAIN DECK RT CREASEBEAM CORRODED BS 660 - 664. BLENDED IAW SRM 51-10-02. ORIGINAL MATERIAL .090 AFTER BLENDING MATERIAL .050 MATERIAL LOSS .040 MATERIAL OUT OF LIMITS IAW SRM 53-30-13, DETAIL III, FIG 101. REMOVED CREASE BEAM IAW SRM 51-40-02. FABRICATED NSDR QXEA2011120101268Structure · corrodedDURING C-CHECK, CORROSION FOUND ON STR 27, STBD BETWEEN STA 34.1 THROUGH STA 18.25. REMOVED CORROSION IAW 51-21-00. PERFORMED ECI ON BLENDED AREAS, NO CRACKS FOUND AT THIS TIME IAW PSM 1-84-7A 51-00-01. TREATED, PRIMED AND PAINTED AREA IAW AMM 51-25-16-390-8SDR SWAA118689Window Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FIRST OFFICERS WINDOW FRAME POST CRACKED. REMOVED AND REPLACED WINDOW POST FRAME PER BAC DWG AND SRM.SDR AALA20111129TUL08Pan · crackedCRACK AT LEFT WINDOW PAN LOWER FORWARD CORNER, STATION 1022. ACCOMPLISHED NESTED ANGLE REPAIR PER AARD 53-10-00-25.SDR UALA2011113006572Crease Beam · corrodedCORROSION ON INNER CREASE BEAM TOP AND BOTTOM AT DOOR 2 RIGHT STATION R 1495 -1540. MAJOR REPAIR ACCOMPLISHED. CORROSION ON INNER CREASE BEAM AT DOOR 2 RT AT 1495 -1540 IAW EA PD67-53-035 BY BLENDING AND WITH BOEING APPROVAL.SDR UALA2011113006571Crease Beam · corrodedCORROSION ON INNER CREASE BEAM AT DOOR 2 LEFT STATION L1502-1520. MAJOR REPAIR ACCOMPLISHED. CORROSION ON INNER CREASE BEAM AT DOOR 2 LEFT REPAIRED BY BLENDING WITH BOEING APPROVAL EA PD67-53-036.SDR AALA20111128TUL02Door Frame · gougedEMERGENCY EQUIPMENT DOOR JAMB, LEFT WEB GOUGED. REPLACED DAMAGED WEB PER AARD 51-00-05-1.SDR ASOA201102273Beam · corrodedFS 280 TRANSVERSE BEAM BETWEEN LBL 18 AND RBL 18 HAS SEVERAL AREAS OF CORROSION. REMOVED MINOR CORROSION ON FS 280 TRANSBEAM AFT J ANGLE IAW SRM 51-21-06. MATERIAL REMOVED .002 WITHIN LIMITS IAW SRM 53-00-00, FIG 102, SHEET 2. FWD J ANGLE BETWEEN LBL AND RBSDR ASOA201102272Beam · corrodedFS 349, TRANSVERSE BEAM HAS CORROSION AT SERVICE DOOR AND FLOOR EDGE MEMBER HAS CORROSION FROM FS 349 TO 364.00. REMOVED CORRODED ANGLE AND INSTALLED NEW ANGLE PN 38783-13 IAW SRM 51-42-06 AND 51-42-21. REMOVED MINOR CORROSION IAW SRM 51-21-06. MAT REMOVED .SDR ASOA201102271Beam · corrodedFS 349 TRANSVERSE BEAM OTBD END AT PAX DOOR HAS CORROSION. REMOVED CAP ON FS 349 BEAM AT PAX DOOR ENTRANCE TO ACCESS CORROSION REMOVAL IAW SRM 51-42-13. REINSTALLED BEAM CAP IAW SRM 51-42-13, 51-42-15 AND 51-25-01.SDR FDEA201111285094Track · wornCOCKPIT, RT SIDE, NR 2 WINDOW AFT LOWER CORNER HAS WEAR MARK AT TRACK. REMOVED DAMAGED TRACK IAW-SRM-51-40-02, INSTALLED NEW TRACK IAW-SRM-51-40-02, NO DAMAGE ALLOWED IAW DWG 141N-5102. "MAJOR REPAIR"SDR SWAA118195Crease Beam · crackedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM CRACKED AT BS 616, STR 17L. REPAIRED BEAM IAW EA.SDR UALA2011112706459Beam · crackedBS 1120 LBL 5, CANTED BEAM WEB CRACKED BELOW FLOORLINE. MAJOR REPAIR ACCOMPLISHED. REPLACED SHEAR WEB.SDR FDEA201111255023Crease Beam · corrodedCABIN, AFTER REMOVAL OF CREASE BEAM AT 1720 TO 1640R, FOUND CREASE BEAM CORRODED TO 1720 BULKHEAD. R & R IAW SRM 51-40-02. REPAIR IS CLASSIFIED AS MAJOR.SDR FDEA201111245016Crease Beam · corrodedRT CREASE BEAM CORRODED AROUND ANCHOR NUT HOLES APPROX BS 1020-1040. CORROSION FOUND TO BE OUT OF LIMITS. REPLACEMENT FABRICATED IAW DWG 144N5140 AND INSTALLED IAW SRM 51-40-02.SDR DALA1164676903Door Frame · crackedDUE OPN 5032 AD NR 1 CARGO DOOR OPENING FWD FRAME STA 560 WEB CRACKED BETWEEN 24R-26R. REF NR 148. INSTALLED PERMANENT REPAIR PER SRM 53-00-07 FIG 201 REPAIR NR 2. REQUIRES REPETITIVE INSPECTION PER SRM 53-00-07 FIG 201 TABLE 3. HFEC AND LFEC REF NDT PART SDR FDEA201111245015Crease Beam · corrodedLEFT CREASE BEAM INBD CHORD CORROSION FOUND AROUND ANCHOR NUT HOLES APPROX BS 1020-1040, CORROSION FOUND TO BE OUT OF LIMITS. REPLACEMENT CHORD FABRICATED IAW DWG 144N5140 AND INSTALLED IAW SRM 51-40-02.SDR DALA1169810604Door Frame · damagedFASTENER HOLES ELONGATED IN FWD AND AFT FRAME OF CARGO DOOR CUTOUT.SDR ASOA201102256Beam · corrodedTRANSVERSE BEAM HAS CORROSION BEYOND ALLOWABLE LIMITS AT OTBD END RBL 42, WL 73, MEASURES APPROX 2" LONG X 1" WIDE AND .012 DEEP WITH MATERIAL LOSS AT FWD OTBD CORNER OF UPPER LIP. REO 601R-53-21-2231, REV A HAS BEEN ACCOMPLISHED AND ALL STEPS HAVE BEEN DOC
Back to JASC 5310