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 SWAA052405Crease Beam · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE CREASE BEAM WEB CORRODED BETWEEN BS 500A AND BS 500B, RBL 60. REPAIRED WEB PER SRM.SDR 05FDEA02397Beam · damagedFWD CARGO COMPT LT SIDE ON BEAM AT STA 1099 FOUND SPLICE REPAIR WITH NEW SECTION FROM INB'D TO OUT'B AT X=46 Z=-100. REPAIR IAW EA 8-5310-87665.SDR 05FDEA02394Door Frame · damagedAFT CARGO COMPT LOWER SIDE DOOR JAMB STA 1821 FOUND DOUBLER REPAIR ON WEB. REPLACED REPAIR BY NEW DOUBLER IAW SRM 53-50-00 FIG 12 VOL 1 AND EA 8-5310-87666.SDR ASOA05717Door Frame · crackedDURING A C-CHECK IN HOT, THE PASSENGER DOOR FRAME AND INNER SKIN AT FS 338.90, DOOR DATUM 1 WERE FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE REPAIRED THE PASSENGER DOOR FRAME AND INNER SKIN AT FS 338.90, DOOR DATUM 1 IAW ASA EO 600-52-0130. (M)SDR SWAA052392Vertical Beam · crackedDURING SCHEDULED 1/4D CHECK, FOUND VERTICAL BEAM WEB CRACKED AT BS 181, RBL 17.1, WL 181. REPAIRED WEB PER SRM.SDR 05FDEA02364Beam · damagedFWD CARGO COMPT RIGHT SIDE STA 1099 FOUND EXISTING SPLICE REPAIR WITH NEW SECTION OF BEAM X=-46 Z=-100. REPAIR PER SRM 53-60-01 FIG 3 VOL 1.SDR 05FDEA02354Structure · corrodedLWR FUSELAGE LT SIDE AIR CONDITION COMPT ON INLET EXHAUST VALVE SYS NR 2 DOUBLER WITH CORROSION AT Y=515 LONGERON 46. REMOVED CORROSION PER SRM 51-21-001 VOL 2 PAR 34 AND REPAIRED PER SRM 53-20-00 FIG 2 VOL 1.SDR 05FDEA02342Beam · damagedCTR CARGO COMPT ON BEAM AT STA 1701 RT SIDE FOUND OLD REPAIR AT X=-38 BROKEN. REPLACED BEAM PER DWG AFA0043-3 AND SRM 51-33-01 PG 34/47 AND SRM 51-35-01 PG 1/13.SDR 05FDEA02340Frame · corrodedCTR CARGO COMPT STA 1710 X=-65 JAMB DOOR FWD, AFTER REMOVED RAIL FOUND SEVERE CORROSION WITH EXFOLIATION. REMOVED CORROSION PER SRM 53-00-01 VOL 1 FIG 1B AND REPLACED FRAME PER SRM 51-32-01 PG 59/68, SRM 51-35-01 PG 1/13, SRM 51-33-01 PG 34/47 VOL 2 AND DWG ASDR ABXA050196Window Frame · crackedTOP FORWARD CORNER OF WINDOW FRAME ON AFT SIDE OF STA 737 LEFT WAS CRACKED. REPAIRED AREA IAW DC-9 SSRM K07226.SDR ABXA050197Window Frame · crackedTOP FORWARD CORNER OF WINDOW FRAME ON AFT SIDE OF STA 737 RIGHT HAD A SMALL CRACK. REPAIRED AREA IAW DC-9 SSRM K07226.SDR 05FDEA02301Seat Track · corrodedMAIN DECK SEAT TRACK X = 8.5 FROM STA 5-73 TO STA 1681 FOUND METAL CLIP NUTS AND SURROUNDING STRUCTURE CORRODED. CARRIED OUT REPAIR AS PER SRM 53-70-00.SDR USAA050984Beam · crackedCLT - Q6 - BEAM, 3 INCH CRACK, STRINGER 8R, STA 500. ACCOMPLISHED SPLICE REPAIR. (K)SDR 05FDEA02282Beam · crackedFWD CARGO COMPT FOUND CRACK 1 INCH LONG ON BEAM AT STA 6-70 STRINGER 42 RT SIDE. CUTTED DAMAGE AND INSTALL NEW SPLICE REPAIR IAW SRM 53-00-01 FIG 7 VOL I.SDR 05FDEA02277Structure · crackedCTR CARGO COMPT CRACK 2 INCHES ON LONG 50 LT BETWEEN STA 1521 AND STA 5-11. REPAIR IAW SRM 51-33-01 PAR 6-10, REPAIR IAW SRM 53-10-00 FIG 1-2.SDR ASAA0540373Crease Beam · corrodedCORROSION ON CREASE BEAM WEB BSTA 336-344, RBL 62, WL 208. REPAIRED CREASE BEAM WEB IAW SRM. (K)SDR USAA050972Crease Beam · crackedCLT - FOUND CREASE BEAM CRACKED .75 INCH, BS 576, S17R. REPLACED WITH FACTORY NEW PART IAW SRM 51-10-02. (M)SDR SWAA052302Vertical Beam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND VERTICAL BEAM WEB CORRODED BETWEEN BS 767 TO BS 787, STR 25R TO STR 26R. REMOVED AND REPLACED WEB SECTION PER SRM.SDR P5CA0501403Beam · crackedFWD CARGO, FOUND CRACKS PROPAGATED FROM BLANKET HOLE AT STA 300 AND 320 AND LT NOSE WHEEL WELL VERTICAL BEAM WEB AT WL 160. REPAIR CARRIED OUT IAW LO-BY714-072 INTERIM WEB REPAIR. CONTINUE INSPECTION PER SB 747-53A2293.SDR UPS05845192Seal · corrodedINSPECTION TYPE:C1 HEAVY CORROSION AROUND EXTERNAL POWER CABLE PRESSURE SEAL BELOW EPC RA CK STA 20 RBL 60. REMOVED, FABRICATED, AND INSTALLED PRESSURE SEAL DOUBLER IAW DWG 56122 78 AND DC-8 SRM 51-1-20D.SDR UPS05845161Stiffener · corrodedHEAVY CORROSION ON BASE OF DIAGONAL STIFFENER IN COCKPIT SUB FLOOR BELOW PILOTS LT RUDDER PEDAL. REMOVED, FABRICATED, AND INSTALLED REPLACEMENT GUSSET IAW DWG 5597992 AND SRM 51-1-20D.SDR AWXA200500970Beam · corrodedMCN - MAJOR REPAIR - DURING C16 CHECK DISCOVERED CORROSION ON TRANSVERSE BEAM LOCATED AT BS 967, BL 28R, AND WL 208. MAINTENANCE REMOVED CORROSION FROM BEAM AT BS 967, BL 28R, WL 208 AND FOUND TO BE OUT OF LIMITS IAW BOEING 737-300 SRM 53-60-51-1 FIG 101. FASDR 2005UALA00742Failsafe · damagedSTATION 1395 FAIL/SAFE CHORD LOWER FLANGE IS DAMAGED BETWEEN STRINGERS 37L AND 38L AND ALSO BETWEEN STRINGERS 38R AND 39R. LOWER AFT FUSELAGE STRUCTURE DAMAGED BY MOVING BAGGAGE CART. DAMAGED STRUCTURE INCLUDED SKIN, STRINGERS, FRAME, TEAR STRAP. COMBINATIOSDR USAA050936Beam · corrodedPIT - FOUND BEAM CORRODED 1 INCH BY 1 INCH, .5 INCH BY .5 INCH, .5 INCH BY .5 INCH , .5 INCH BY .5 INCH, BETWEEN FRAME 68 AND 66, APPROX Y48. REMOVED AND REPLACED BEAM PER SRM 51-72-11. (M)SDR USAA050938Beam · corrodedPIT - FOUND BEAM CORRODED .5 INCH BY .5 INCH AND .5 INCH BY .5 INCH, ON FLOORBEAM BETWEEN FRAME 66/68 -Y450 INCH. REPLACED BEAM PER SRM 53-41-00. CORROSION LEVEL 1, TASK JA-260-53500. (M)SDR UPS05845158Finger Doubler · corrodedCENTER WING BOX AT STA 879 TO 902 LBL 65 FINGER DOUBLER HAS SEVERAL SHEARED FASTENER HEADS AND HEAVY CORROSION UNDER THE FINGER DOUBLER. REMOVED FINGER DOUBLER AND FOUND OUT OF LIMITS IAW DC-8 SRM 53-2-0 FIG 1F. AREA UNDER FINGER DOUBLER FOUND IN LIMITS IAW SDR SWAA052236Crease Beam · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE CREASE BEAM CORRODED AT BS 727E AND BS 864, STR 17L. REPAIRED BEAM SECTIONS PER SRM.SDR 05FDEA02125Support · corrodedCORROSION ON 740, LBL 8, WL 148, UNDER ACCESS PANEL 3348L. SKIN SUPPORT WAS FOUND TO BE OUT OF LIMITS. REMOVED AND REPLACED SKIN SUPPORT BS 740, LBL 8, WL 148 PER SRM 51-30-2 AND SRM 53-10-1SDR DU4R0507166Crease Beam · corrodedCORROSION ON CREASE BEAM AT 364 - 371 RBL 65.SDR UPS05445178Door Frame · crackedBULK CARGO DOOR CUTOUT AFT FRAME AT BS 2034 STR 35-37 FOUND 7EA HOLE CRACK AT FRAME OUTER CHORD, CRACK LENGTH 0.020"/0.030". BULK CARGO DOOR CUTOUT AFT AREA BS 2034 BETWEEN STR 34/35R TO STR 37/38R AREA REPAIRED AS PER HX RS R-53-61-35359 AND C/OUT CONTINUE ISDR UPS05445177Door Frame · crackedBULK CARGO DOOR CUTOUT AFT FRAME AREA AT BS 2034 STR 35-37 FOUND 2EA HOLE CRACK, CRACK LENGTH 0.020" AND 0.030". BULK CARGO DOOR CUTOUT AFT AREA BS 2034 BETWEEN STR 34/35R TO STR 37/38R AREA REPAIRED AS PER HX RS R-53-61-35359. REF NRC 6801 FOR DETAIL AND C/SDR UPS05445034Pressure Panel · crackedLT WLG WW SIDEWALL PANEL FOUND CRACK AT BTN BS 260 AND 280 WL 170 APPROX 1 INCH. LT NLG WW SIDEWALL PANEL REPAIRED AT BS 260 TO BS 280 WL 170 AREA AS PER SRM 53-10-04 FIG 116.SDR SIMA200521612Beam · corrodedTHE GALLEY CENTER BEAM WAS FOUND TO BE CORRODED UNDER THE FLOOR RAMP. REMOVED THE CORROSION BY MAKING A CUT OUT. FABRICATED EXTERNAL DOUBLER. REPAIR DONE IAW EMB SRM, SRM EMB145/1142 REV 29, CHAPTER 53-21-10 FIG 202 SHEET 2. (M)SDR UPS05445142Doubler · corrodedINSPECTION TYPE:C M/D BS 1980-2000 S20-22L WINDOW FORGING MATTING SURFACE SKIN FOUND CORROSION DUE FORGING REMOVED. CORROSION BLEND OUT 0.022" X 1.5" X 3" EXCEED SRM 53-30-01 FIG 1 LIMITS. M/D BS 1983 LT WINDOW CUTOUT DOUBLER CORROSION REPAIRED AS PER HX RSSDR UPS05445008Stringer Clip · crackedBS 1780 S-12R STRINGER TIE CLIP FOUND CRACKED, CRACK LENGTH .750. TIE CLIP REPLACED AS PER SRM 51-10-01 PG 9.SDR 05FDEA02021Door Frame · gougedFWD ENTRY DOOR, UPPER FRAME UPPER SURFACE IS GOUGED WHERE 3 BRACKETS WERE IMPROPERLY REMOVED AND REMAINS OF BRACKETS ARE STILL UNDER HILOCK HEADS. REMOVED AND REPLACED UPPER FRAME PER SRM 51-30-2.SDR CALA0500235Beam · corrodedINSPECTION FOUND BEAM (E&E DOOR CUTOUT SUPPORT STRUCTURE) CORRODED AT STA 986.5, LBL 10 TO LBL 46. REPAIRED IAW ECRA 5310-01233.SDR SWAA052140Crease Beam · crackedDURING SCHEDULED D-CHECK, FOUND LEFT CREASE BEAM CORRODED AT BS 847 TO BS 867. REPAIRED CREASE BEAM SECTION PER SRM.SDR SWIA200515380Structure · crackedCRACK EMITTING FROM RIVET HOLE AT FS 605 FRAME AND STRINGER 9 INTERSECTION BOTTOM SIDE OF STRINGER, ITEM FOUND AT C-CHECK INSPECTION. FRAME REPAIRED IAW REO 601R-53-61-1469.SDR SWIA200515379Structure · crackedCRACK EMITTING FROM RIVET HOLE AT FS 605 FRAME AND STRINGER 9 INTERSECTION TOP SIDE OF STRINGER, ITEM FOUND AT C-CHECK INSPECTION. FRAME REPAIRED IAW 601R-53-61-1469SDR ASAA0570036Door Frame · dentedPAE - DURING C-CHECK, FOUND E-BAY DOOR CUTOUT FRAME WEB DENTED ABOVE LATCH FITTING. REPAIRED IAW SRM 51-40-02. (M)SDR USAA050891Beam · corrodedFOUND BEAM CORRODED 1 INCH BY 1 INCH BY .100 INCH DEEP, FORWARD CABIN TOP OF BEAM AT CENTER LINE A C16. CORROSION LEVEL 1, TASK JA-220-53500. REMOVED AND REPLACED BEAM, REPLACED WITH IDENTICAL PART NR. (M)SDR 05FDEA01989Door Frame · corrodedE-BAY BODY DOOR FRAME AT BS 449 LBL 2-RBL 2 CORRODED. REPLACED E-BAY BODY DOOR FRAME AT BS 449, PER SRM 51-30-2 AND 51-10-3 AND 51-30-5SDR 05FDEA01987Structure · gougedBS 1352 IS GOUGED AT 3 O'CLOCK, WORN FROM 5-6 O'CLOCK AND MISSING RUBSTRIP FROM 1-6 O'CLOCK. (OPEN)SDR 05FDEA01985Door Frame · corrodedCORROSION ON E-BAY DOOR FRAME BS 423 BL 0. BLENDED CORROSION FROM E-BAY FRAME BS 423 BL 0 FOUND TO BE WITHIN LIMITS PER SRM 53-10-1SDR DHL2005802545Door Frame · crackedCARGO DOOR AFT LWR JAMB CORNER 0.500 CRACKED STA 1440.000 L-32R TO L-33R (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8100-9 BOEING MESSAGE 1-106666113-2, 1-106666113-3 DATED 07-01-03. REMOVED FASTENERS IAW SRM 51-1-21 PG. 1, SRM 51-1-20D PG. 21. CUT OUSDR 05FDEA01961Seat Track · crackedMAIN DECK CARGO COMPARTMENT, FLOOR SEAT TRACK AT STA 635, X= -27 FOUND WITH CRACKED APPROXIMATELY 3 INCHES LONG. REPAIRED AS PER SRM 53-70-00 VOLUME I, FIGURE 1. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR CA050719007Post · crackedCENTERLINE POST CRACKED, EMANATING FROM RIVET OUTWARDS. CENTERLINE POST IS LOCATED IN THE BAGGAGE COMPARTMENT. IT IS A KNOWN AREA FOR CRACKING AND IS ON A SCHEDULED 300 HOUR INSPECTION.SDR USAA050868Beam · corrodedFOUND BEAM CORRODED 8 INCHES BY 2 INCHES, BETWEEN FRAME 14 AND 16 Y 503.2. REPLACED BEAM BEAM PER SRM 51-72-11. (M)SDR A6WA200540239Intercostal · crackedRT SIDE FS 484 INTERCOSTAL IS CRACKED AT RBL 36. CRACK IS APPROX 0.4 INCH LONG. REPAIRED RT SIDE FS 484 INTERCOSTAL IAW MFG REO. (K)
Back to JASC 5310