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 03FDEA00117Door Frame · chafedFORWARD ENTRY DOOR FRAME CHAFED JUST BELOW LOWER HINGE. BLENDED AND TREATED FORWARD ENTRY DOOR FRAME IAW E.A. 7-5210-68181SDR C2XA03TY027Sill · corrodedDURING A SCHEDULED 2-C INSPECTION THE CARGO DOOR SILL WAS FOUND CORROCDED. MAINTENANCE REMOVED DOOR, REMOVED THE COVER SILL, LOCATED, DRILL NEW DOOR SILL, INSTALLED DOOR PROTECTIVE STRIPS AND INSTALLED DOOR. PRESSURE CHECK WAS GOOD IAW 135/145 SRM 53-40-02. SDR C2XA03TY024Beam · corrodedDURING A SCHEDULED 2-C INSPECTION THE LT OMEGA BEAM AND RAMP ANGLE WERE CORRODED. MAINTENANCE REMOVED THE DAMAGED AREA; FAB FILLER, SHIM, EXTERNAL LT RAMP ANGLE IAW EMB 135/145 SRM 53-21-10. ALODINED AND PRIMED IAW EMB 135/145 CPM51-21-04;05. ALL WORK WAS ASDR C2XA03TY022Beam · corrodedDURING A SCHEDULED 2-C INSPECTION THE FWD-CENTER OMEGA BEAM TOP CAP WAS CORRODED. MAINTENANCE REMOVED AND REPLACED THE CENTER OMEGA BEAM IAW EMB 135/145 SRM 51-40-02. ALL WORK WAS ACCOMPLISHED AND WILL BE RELEASED UPON COMPLETION OF ALL WORK.SDR C2XA03TY021Beam · corrodedDURING A SCHEDULED 2-C INSPECTION THE CENTER OMEGA BEAM WAS CORRODED. MAINTENANCE CUT OUT THE DAMAGED AREA AND FAB NEW FILLER REPAIR. INSTALLED NEW PIECE IAW EMB 135/145 SRM 53-21-10; 51-40-02. ALODINED, PRIMED IAW EMB 135/145 CPM 51-21-04;05. ALL WORK WASSDR GTIA030089Shear Tie · corrodedFTW - FOUND SHEAR TIE ASSEMBLY HAS CORROSION AN GOUGE. FOUND SHEAR TIE TO BE OUT OF LIMITS. FORMED SHEAR TIE. (M)SDR ABXA030066Threshold · bentMAIN CABIN DOOR THRESHOLD LIP WAS RAISED PREVENTING DOOR FROM OPENING. REPAIRED RAISED LIP ON THRESHOLD OF MAIN CABIN DOOR AS REQUIRED IAW DC-8 MM.SDR 03FDEA00110Support Angle · corrodedCORROSION A/C BAY, STA 740, LBL 12, WL 140 AT LOWER FRAME OF BULKHEAD. REMOVED AND REPLACED LOWER SUPPORT ANGLE BS 740 LBL 12 WL 140 IAW SRM 51-30-2 AND 51-20-4.SDR AALA20030142Shear Tie · crackedTUL - FOUND SHEAR TIE CRACKED ABOVE LONGERON 16L STATION 1309. REPLACED SHEAR TIE WITH NEW PART SRM 51-20-00. (M)SDR C2XA02SH189Beam · corrodedDURING C-CHECK LT OMEGA BEAM AT FRAME 20 WAS FOUND TO HAVE CORROSION. MAINTENANCE REMOVED DAMAGE AND PERFORMED AN ANGLE REPAIR IAW EMB 145 SRM 53-21-10. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR AALA20030197Shear Tie · crackedTUL - FOUND BOTH LEFT AND RIGHT SHEAR TIE DOUBLERS ON AFT SIDE OF FRAME 1451 CRACKED BELOW VERTICAL STAB ATTACH ANGLES. REPLACED SHEAR TIE DOUBLERS WITH NEW PARTS. REMOVED AND REPLACED PER SRM 53-01-00. (M)SDR UPS03840184Splice · crackedINSPECTION TYPE: C1, STATION 300 TO 320 LONG 13L SPLICE FITTING IS CRACKED. REMOVED, FABRICATED AND REPLACED FITTING IAW SAA SK 811-747 AND SRM 51-1-20D.SDR 03FDEA00100Shear Tie · corrodedCORROSION ON SHEAR TIE AT BS 1166, RBL 3, WL 152, AFT CARGO BAY.SDR 03FDEA00099Shear Tie · corrodedCORROSION ON SHEAR TIE AT BS 1166, LBL 2, WL 152, AFT CARGO BAY.SDR AWXA200300130Frame · crackedMAJOR REPAIR - DURING C-09 CHECK A 2 INCH CRACK WAS FOUND ON THE L-4 DOOR AREA CUSP INNER FRAME AT BS 1720, WL 208, LBL 70. MAINTENANCE WELDED CRACK AT THE INNER FRAME BS 1720 IAW AWA E.R. 19-5361-03035-SS2 . CAD PLATING WAS PERFORMED IAW E.O. 19-5361-03035-SDR C2XA02SH187Butt Strap · corrodedDURING C-CHECK FOWARD CENTER DIGITAL BUTT STRAP WAS FOUND TO HAVE CORROSION BETWEEN FRAMES 15 AND 16. MAINTENANCE REMOVED DAMAGE SECTION AND PERFORMED A SPLICED REPAIR IAW EMB 135 SRM 53-21-10.SDR C2XA02SH183Beam · corrodedDURING C-CHECK LT OMEGA BEAM WAS FOUND TO HAVE CORROSION. MAINTENANCE REMOVED DAMAGE AND PERFORMED A SPLICED REPAIR IAW EMB 135 SRM 53-21-10. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR C2XA02SH182Butt Strap · corrodedDURING C-CHECK CENTER BUTTSTRAP BETWEEN FRAMES 18 AND 23 WAS FOUND TO HAVE CORROSION AND GOUGING. MAINTENANCE REMOVED AND REPLACED AFFECTED BUTTSTRAP IAW EMB 135 SRM 53-21-10. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR CA030603009Angle · cracked(CAN) CRACK IS IN ANGLE ONLY, NOT FITTING.SDR AALA20030130Window Frame · crackedTUL - FOUND CRACK IN WINDOW FRAME AT STATION 1041 UPPER CORNER RIGHT SIDE. INSTALLED DOUBLER PER 53-10-00. (M)SDR AALA20030129Window Frame · crackedTUL - FOUND STATION 1098 LEFT SIDE WINDOW FRAME CRACKED. REPAIRED PER AARD 53-10-00-25. (M)SDR AALA20030127Window Frame · crackedTUL - FOUND CRACK IN WINDOW FRAME AT STATION 1041 UPPER CORNER RIGHT SIDE. INSTALLED DOUBLER PER 53-10-00. (M)SDR UPS03840151Clip · crackedINSPECTION TYPE: C1, STA 200 FRAME FORMER IS CRACKED ON I/B END BETWEEN LONG 32L AND 33L. REMOVED CRACKED FORMER CLIP, FABRICATED AND INSTALLED FORMER REPAIR CLIP IAW SRM 53-2-0 FIG 2A.SDR AWXA200300109Crease Beam · corrodedYVR - MAJOR REPAIR - DURING C-14 CHECK CORROSION WAS FOUND ON CREASE BEAM WEB ON CABIN FLOOR BS 500A-500B, STR 17 L/H. MAINTENANCE REMOVED CORRODED CREASE BEAM WEB BS 500A-500B, STR 17 L/H; FABRICATED A NEW REPLACEMENT CREASE BEAM WEB; INSTALLED REPAIR PART IASDR P5CA03000808Structure · crackedUPPER LOBE DECK CRACK ON F/S RIGHT BETWEEN STR 8 TO STR 10A. DAMAGED AREA TRIMMED OUT REINFORCED AREA WITH SEGMENT, SPLICE AND STRAP PER SRM 53-10-04 FIG -10.SDR P5CA0300800Structure · crackedUPPER LOBE DECK CRACK ON F/S 520 RT BETWEEN STR 7 TO 10A. DAMAGED AREA TRIMMED OUT, REINFORCED AREA WITH SEGMENT AND SPLICE STRAP.SDR GTIA030091Beam · corrodedFTW - FOUND AFT CARGO PIT CORROSION, BARE METAL AND CRACKED SEALANT ALL ALONG INBOARD FRAME AT DOOR JAMB BEAM. REMOVED DOOR JAMB BEAM. LOCATED AND DRILLED NEW AFT CARGO DOOR BEAM. INSTALLED AFT CARGO DOOR JAMB BEAM. (M)SDR GTIA030158Beam · corrodedMID CARGO DOOR FRAME CORROSION, BARE METAL, CRACKED SEALANT ALL ALONG DOOR JAM BEAM. REMOVED DOOR JAMB BEAM L28R STA 598 TO 731 RT. HOLES LOCATED AND DRILLED NEW JAMB BEAM. INSTALLED DOOR JAMB BEAM STA 598 TO 731.SDR GTIA030076Door Frame · corrodedFTW - FOUND FORWARD CARGO PIT CORROSION, BARE METAL AND CRACKED DAMAGED SEALANT ALL ALONG INBOARD FRAME AT DOOR JAMB PANEL FROM 3 O'CLOCK TO 9 O'CLOCK POSITION. FOUND CORROSION OUT OF LIMITS. CUT OUT FORWARD CARGO DOOR JAMB PANEL FROM 5 O'CLOCK TO 7 O'CLOCK SDR AWXA200300140Beam · crackedMAJOR REPAIR - DURING C-14 CHECK A 2 INCH CRACK AND CORROSION WAS FOUND ON SHEAR BEAM WEB BS 480 TO BS 500. MAINTENANCE REMOVED DAMAGED SHEAR BEAM WEB BS 480 TO BS 500; FABRICATED A NEW REPLACEMENT WEB IAW DWG 65-46956; INSTALLED REPAIR PART IAW B737-300 SRM 5SDR 2003FA0000100Beam · elongatedNUMEROUS RIVETS WERE FOUND WORKING LOOSE IN THE BOX BEAM DURING A 100/300/ANNUAL INSPECTION. REQUIRED REPLACEMENT OF 20 EACH CHERRY MAXI-BOLTS, 16 EACH CHERRY MAX RIVETS. DIGITAL PICTURES WERE TAKEN TO FURTHER DESCRIBE.SDR UPS03240156Fitting · crackedINSPECTION TYPE:C R/H LWR. TERMINAL FITTING IN TAIL SKID BAY CRACKED. REMOVED FITTING IAW SRM 51-30-02. FABRICATED NEW FITTING IAW DRAWING NO.65-85208 INSTALLED FABRICATED FITTING IAW DRAWING NO.65-25992SDR 2003UALA00111Crease Beam · corrodedCABIN FLOOR RT CREASE BEAM INNER Z-ANGLE CORRODED FROM STA 270-360. MAJOR REPAIR ACCOMPLISHED. REPLACED Z-ANGLE.SDR UPS03240159Rib · crackedINSPECTION TYPE:C DURING EDDY CURRENT INSP.OF R/H BS870 FORGING 2 CRACKS WERE FOUND ON FWD INTEGRAL RIB AT S11. REF EO.B727-5310-3057 APPDX.D FOR PARTIAL REPLACEMENT OF TERMINAL F ITTING S9 TO S12 AND APPDX.C STEP 1.SDR 2003UALA00092Crease Beam · corrodedCREASE BEAM WEB AT STATION 827-847 STRINGER 17L HAS CORROSION. ACCOMPLISHED MAJOR REPAIR. REPLACED WEB.SDR DL757030094Door Frame · corrodedTHE OUTBOARD STRUCTURE OF THE LOWER SILL BEAM OF THE C1 DOOR OPENING WAS FOUND CORRODED. TO REMOVE THE CORROSION, THE OUTER STRUCTURE AND WEB OF THE FS 620 FRAME WERE CUT BETWEEN STRINGERS 25R & 26R AND THE LOWER SECTIONS REMOVED. THE SILL STRUCTURE WAS REPLSDR QXEA0300192Stop Fitting · chafedPDX - TWO DOOR STOPS CHAFED AT LOWER APERTURE OF CARGO DOOR SILL. REPAIRED IAW RD 8-53-104 PAGE 3.SDR IXXA060496SDoubler · damagedDURING ROUTINE C CHECK, FOUND FORWARD LOWER AIR CONDITIONER ACCESS DOOR INTERNAL DOUBLER REQUIRES REPLACEMENT DUE TO MANY PREVIOUS REPAIRS. REMOVED EXISTING DOUBLER. FABRICATED REPAIR PARTS, LOCATED, DRILLED, TRIMMED, TREATED, PRIMED AND INSTALLED REPAIR PARSDR SWAA030172Frame · crackedDURING SCHEDULED D CHECK, FOUND BS 188 FRAME CRACKED AT STR 17L. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR 03FDEA00071Shear Tie · dentedDENT IN SKIN AT FRAME BS 460 BETWEEN STR 20R - 21R. FOUND SKIN TO BE WITHIN LIMITS. SHEAR TIE AT BS 460 STR 20R-21R OUT OF LIMITS. REPAIRED SHEAR TIE IAW SRM 51-40-3 FIG 1 AND EA 7-5310-54395.SDR 2003UALA00073Angle · corrodedRT CREASE BEAM INBOARD ANGLE CORRODED AT BODY STATION 957. MAJOR REPAIR ACCOMPLISHED. REPLACED RT CREASE BEAM INBOARD ANGLE.SDR SROM200300017Shroud · crackedDURING C CHECK INSPECTION FOUND LOWER APU SHROUD CRACKED 3.5 INCHES AFT OF PREVIOUS REPAIRED AREA. REMOVED DAMAGED AREA, FABRICATED REPAIR DOUBLER & FILLER AND INSTALLED ON SHROUD PER EA 4910-01089 & 4910-01077. MONOR REPAIRSDR QXEA0300107Structure · bird strikeSMF - FLIGHT 2493 - CREW RETURNED TO FIELD WHEN AFTER TAKEOFF A BIRD STRUCK THE AIRCRAFT. MAINTENANCE INSPECTED THE AIRCRAFT AND FOUND NO EVIDENCE OF DAMAGE. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR ASAA0380090Spacer · corrodedOKC - FOUND DURING C-CHECK, AFT CARGO BAY DOOR LOWER BEAM SPACER IS CORRODED. REPLACED EXISTING DOUBLER PER SRM 51-30-5 AND 53-05. (M)SDR OZI2003F00004Sill · corrodedBAGGAGE COMPARTMENT DOOR SILL CORRODED.SDR OZIA200341002Door Frame · corrodedBAGGAGE COMPARTMENT DOOR SILL CORRODED.SDR ZW0A0301105Door Frame · crackedDURING CHECK-C CRACK AT LEFT HAND MAIN GEAR DOOR CUTOUT FORWARD 11B CORNER FORWARD OF DOOR ACTUATOR ASSEMBLY RUNNING OUTBOARD FROM CORNER TURNING UPWARD. ROUTED OUT DAMAGED AREA AND INSTALLED DOUBLER IAW SRM 51-20-5.SDR QXEA0300225Bulkhead · dentedPDX- FORWARD PRESSURE BULKHEAD DENTED AT RT STRINGER 16. REPAIRED IAW HORIZON AIR EA 6-53-181.SDR AWXA200300080Sill · crackedDURING C-14 CHECK A 1/2 INCH CRACK WAS FOUND CABIN FLOORBOARD SILL ANGLE BS 639, LBL 56. MAINTENANCE FABRICATED REPAIR PLATES FOR CRACKED CABIN FLOORBOARD SILL ANGLE BS 639, LBL 56; INSTALLED REPAIR PARTS IAW B737-300 SRM 51-70-12, PG. 1-3, 6-7, FIG. 1.SDR 2003UALA00066Crease Beam · corrodedBS 935-990, RBL 54, WL 208, RIGHT CREASE BEAM INBOARD CHORD UPPER SURFACE HAS SEVERAL AREAS OF CORROSION. MAJOR REPAIR ACCOMPLISHED. DAMAGED SECTION OF CREASE BEAM CHORD REMOVED. REPLACEMENT PART PREPPED AND INSTALLED. DRAIN SCUPPER INSTALLED.
Back to JASC 5310