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 UPS03440761Shear Tie · crackedINSPECTION TYPE: C, M/D - BS 1020 FRAME SHEAR TIE FOUND CRACKED BETWEEN S-9R AND S-11R. M/D BS 1020 S9R-S11R FRAME SHEAR TIE (2EA) REPLACED AS PER SRM 51-10-01 PG 8.SDR SWAA031130Door Frame · crackedDURING SCHEDULED D-CHECK, FOUND FWD CARGO DOOR FRAME CRACKED AT CUTOUT FOR NR 5 STOP FITTING. REPAIRED FRAME PER SRM.SDR GTIA030478Door Frame · corrodedFOUND LT-RT MLG DOOR JAMB HINGE SUPPORT CORRODED. FABRICATED NEW LT FITTING. LOCATED AND DRILLED NEW LT AND RT HINGE SUPPORTS FOR DOOR JAMB. INSTALLED NEW LT AND RT HINGE SUPPORTS FOR DOOR JAMB. REMOVED LT HINGE SUPPORT. INSTALLED LT HINGE SUPPORT. (M)SDR C2XA03SH138Beam · corrodedSHV DURING C-CHECK THE LOWER BAGGAGE DOOR CUTOUT BEAM WAS FOUND TO HAVE CORROSION. MAINTENANCE REMOVED DAMAGE AND REPLACED AFFECTED BEAM IAW EMB 145 SRM 53-31-10. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR DHL2003604686Door Frame · crackedAFT LOWER CORNER OF AFT PASSENGER DOOR JAMB WITH 1.000 CRACK IN IT. PERFORMED MAJOR REPAIR IAW SRM 53-2-0 FIG 18 SHEET 1, TR 53-134, TR 53-135, DWG 5750776, DWG SR08530021. CUT OUT DAMAGED AREA AND FABRICATED FILLER (7075-T6 AL0.080) AND (2) DOUBLERS (7075-TSDR C2XA03TY070Beam · corrodedTYS, DURING A SCHEDULED INSPECTION THE LEFT FLOOR SUPPORT JUST AFT OF MAIN CABIN DOOR WAS FOUND CORRODED. MAINTENANCE REMOVED AND REPLACED THE FLOOR SUPPORT IAW EMB-135/145 SRM 51-40-02. THE REPAIR WAS SATISFACTORY AND THE AIRCRAFT WILL BE RELEASED UPON COMPSDR C2XA03TY052Beam · puncturedTYS, DURING A SCHEDULED INSPECTION THE CENTER BEAM IN IN GALLEY, TOP CAP HAS A PUNCTURE AT THE END. MAINTENANCE FABRICATED A DOUBLER AND INSTALLED IAW EC5320-01095. THE REPAIR WAS SATISFACTORY AND THE AIRCRAFT WILL BE RELEASED UPON COMPLETION OF INSPECTION.SDR GTIA030424Beam · corrodedFTW - FOUND MID CARGO COMP, JAMB BEAM CORRODED STATION 636 TO 693. REMOVED BEAM. LOCATED AND DRILLED NEW BEAM. INSTALLED NEW BEAM. (M)SDR UPS03440784Door Frame · crackedINSPECTION TYPE: C, M/D - R2 PAX DOOR FOUND AFT FRAME LOWER CORNER CRACKED AS MARKED. LOWER CORNER REPAIRED AS PER SRM 52-10-02 FIG 8.SDR UPS03240750Stop · crackedINSPECTION TYPE: C, AFT NR 1 DOOR STOP ON FWD DOOR HAS A SUSPECT CRACK. HFEC INSP CARRIED OUT ON AFT NR 1 DOOR STOP ON FWD DOOR IAW B727 NDTM PT 6 51-00-00 FIG 4. RESULT - CRACK CONFIRMED. AFT NR 1 DOOR STOP FITTING REPAIRED IAW EO B727-5230-0032-N APPX C SDR UPS03440717Shear Tie · crackedINSPECTION TYPE:C M/D - BS 1500, BET STR 20 - 22R FRAME ATT SHEAR TIE FOUND CRACK. SHEAR TIE REPLACED AS PER SRM 51-10-01 PAGE 8.SDR ASAA0310461Shear Tie · corrodedPAE - DURING C-CHECK, FOUND THE SHEAR TIE AT FUSELAGE STATION 987, STRINGER 25L-26L CORRODED. REPAIRED SHEAR TIE PER SRM. (M)SDR ASAA0310460Shear Tie · corrodedPAE - DURING C-CHECK, FOUND THE SHEAR TIE AT FUSELAGE STATION 987, STRINGER 24L-25L CORRODED. REPAIRED SHEAR TIE PER SRM. (M)SDR ASAA0310462Door Frame · gougedPAE - DURING C-CHECK, FOUND THE AFT CARGO DOOR FRAME AT FUSELAGE STATION 727B, STRINGER 20L GOUGED. REMOVED DAMAGED AREA AND REPAIRED DOOR FRAME PER SRM. (M)SDR ASAA0310463Shear Tie · corrodedPAE - DURING C-CHECK, FOUND THE SHEAR TIE AT FUSELAGE STATION 727A, RIGHT BUTTOCK LINE 8 CORRODED. REPLACED SHEAR TIE PER SRM. (M)SDR AWXA200300685Door Frame · crackedDURING C-15 CHECK A .25 INCH CRACK WAS FOUND ON FRAME OF R-1 DOOR AT UPPER HINGE CUTOUT. MAINTENANCE PERFORMED A HFEC INSPECTION TO VERIFY END OF CRACK; STOP DRILLED CRACK IAW B737-200 SRM 52-00-2 FIG 7 PG 32.SDR SWAA031097Crease Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CREASE BEAM CORRODED FROM BS 390 TO BS 500B, LT SIDE. REPAIRED CREASE BEAM PER SRM.SDR SWAA031096Crease Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CREASE BEAM CORRODED FROM BS 390 TO BS 500C + 17, RT SIDE. REPAIRED CREASE BEAM PER SRM.SDR GTIA030377Door Frame · crackedFOUND LT MLG FORWARD DOOR JAMB IS CRACKED AT T-CAP DOUBLER. REMOVED DOUBLER. FABRICATED REPAIR PARTS. INSTALLED REPAIR PARTS. (M)SDR SIMA200313904Shear Tie · corrodedABI - DURING AN IMBV INSPECTION, THE SHEAR TIE AT FRAME 68 AND THE CARGO DOOR CUTOUT WAS FOUND TO BE CORRODED BEYOND SRM LIMITS. REMOVED CORROSION BY PERFORMING AN CUT OUT OF THE LOWER PORTION OF THE SHEAR TIE. FABRICATED A REPLACEMENT SPLICE. REPAIR DONE ISDR GTIA030472Beam · corrodedAFT PIT DOOR BEAM CORRODED. FORMED NEW DOUBLER. INSTALLED NEW REPAIR. (M)SDR ABXA030177Beam · crackedMAIN ENTRY DOOR HORIZONTAL BEAM ABOVE UPPER HINGE ATTACH POINT WAS CRACKED. REPAIRED MAIN ENTRY DOOR BEAM PLANE NR 5 IAW DC-9 SRM 52-05.SDR 03FDEA00726Door Frame · crackedNR 200 RT PATIO DOOR NR 10 FRAME CRACKED AS MARKED. STOPPED DRILL CRACK IAW MD-10 SRM 53-30-00. FAB ANGLE REPAIR IAW MAE TRAVLER T2/333232. LOCATED AND DRILLED ANGLE IAW MD-10 SRM 53-30-00, INSTALLED ANGLE REPAIR IAW SRM 51-31-01, 51-33-01.SDR UPS03440698Beam · crackedINSPECTION TYPE: C, NLG WW TUNNEL - RT BS 280 VERTICAL BEAM WEB FOUND CRACK AT LOWER STANDOFF HOLE BETWEEN 1ST & 2ND STIFFENER CLIP (COUNT FROM TOP). DEFECT WEB REMOVED AND SERVICEABLE WEB REPLACED AS PER SRM 51-10-01 PG 8.SDR UPS03440697Beam · crackedINSPECTION TYPE: C, NLG WW TUNNEL - LT BS 280 VERTICAL BEAM WEB FOUND CRACK AT LOWER STANDOFF HOLE BETWEEN 1ST AND 2ND STIFFENER CLIP (COUNT FROM TOP). VERTICAL BEAM WEB REPLACED WITH SERVICEABLE NEW PART AS PER SRM 51-10-01 PG 8 AN AREA PAINT TOUCH UP PER MSDR SWAA031058Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CORRODED AT BS 727E, BETWEEN STR 26R & STR 27R. REPAIRED SHEAR TIE PER SRM.SDR GTIA030369Door Frame · bentFOUND L-1 DOOR JAMB HAS SKIN EDGES BENT OUT AND REQUIRES REPAIR. PERFORMED DYE PENETRANT INSPECTION, FOUND CRACK IN SKIN. REMOVED CRACK IN SKIN. FABRICATED 19 TRIP. FABRICATED 21 DOUBLER. INSTALLED NEW REPAIR. (M)SDR SWAA031073Shear Tie · crackedDURING SCHEDULED SPECIAL VISIT, FOUND 2 EA SHEAR TIES CRACKED AT BS 360, STRINGERS 14L & 14R. REPAIRED SHEAR TIES PER SRM.SDR GTIA030390Structure · corrodedFOUND AFT FUSELAGE LEFT SIDE STATION 1429 TO 1418 HAS CORROSION AT SUPPORT FORWARD VENTRAL STAIRWAY. REMOVED DAMAGED AREA. FABRICATED REPAIR DOUBLER. INSTALLED REPAIR DOUBLER. (M)SDR GTIA030361Door Frame · crackedFTW - FOUND FORWARD CARGO JAMB BEAM CRACKED AT AFT DOOR STOP. REMOVED FORWARD CARGO JAMB BEAM. LOCATE AND DRILL NEW JAMB BEA. INSTALLED NEW JAMB BEAM. (M)SDR SWAA031031Shear Tie · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SHEAR TIE CRACKED, BS 500C STRINGER 15R. REPAIRED SHEAR TIE PER SRM.SDR DHL2003604684Door Frame · crackedAFT UPPER CORNER OF RT AFT SERVICE DOOR JAMB WITH 2 CRACKS 1.000 APPROX IN IT. PERFORMED MAJOR REPAIR IAW SRM 53-2-0 FIG 16 SHEET 4, TR 53-131, DWG 5750776, DWG SR08530021. CUT OUT DAMAGED AREA AND FABRICATED, FILLER (7075-T6 AL0.032) (7075-T6 AL0.080) AND (SDR CA030514016Door Frame · cracked(CAN) DURING A CESSNA CONTINUED AIRWORTHINESS PROGRAM INSPECTION 53-10-02 A 2 INCH CRACK WAS NOTED IN THE DOOR POST AT THE BOTTOM LEFT OF THE WINDOW. A REPAIR HAD TO BE COMPLETED IN ACCORDANCE WITH CESSNA SEB 93-4 BY INSTALLING THE DOORPOST MODIFICATION KIT SKSDR ASAA0310398Shear Tie · corrodedOKC - DURING C-CHECK, FOUND WEB SHEAR TIE AT BS 277, STRINGER 27L CORRODED. REPLACED SHEAR TIE AND REPAIRED PER SRM. (M)SDR DHL2003604683Door Frame · crackedA 1.000 CRACK IN FWD UPPER CORNER OF FWD SERVICE DOOR JAMB. PERFORMED MAJOR REPAIR IAW SRM 53-2-0 FIG 14 SHEET 3, TR 53-127, DWG 5750776, DWG SR08530021. CUT OUT DAMAGED AREA; FABRICATED (2) FILLERS (7075-T6 AL0.050) (7075-T6 AL0.063) AND (2) DOUBLER (7075-TSDR GTIA030359Door Frame · corrodedFTW - FOUND MID CARGO LOWER DOOR JAMB BEAM CORRODED. REMOVED MID CARGO LOWER DOOR JAMB BEAM. LOCATE AND DRILLED NEW JAMB BEAM. INSTALLED NEW JAMB BEAM IN MID CARGO. (M)SDR TSAA0353140Shear Tie · damagedDISCOVERED A DAMAGED SHEAR TIE LOCATED AT BS 360, BETWEEN STRINGER 14 AND 15 RIGHT. CUTOUT DENTED PORTION. FABRICATED A NEW SHEAR TIE, DRILLED FASTENER HOLES, ALODINED, PRIMED, AND INSTALLED REPAIR PARTS WET WITH FASTENERS MAKING A FAYING SURFACE SEAL. REPASDR TSAA0353134Shear Tie · damagedDAMAGED SHEAR TIE DISCOVERED AT BD 908 BETWEEN STRINGERS 14 AND 15 LEFT. CUTOUT DAMAGED SECTION. FABRICATED NEW SHEAR TIE, DRILLED FASTENER HOLES, ALODINED, PRIMED, AND INSTALLED REPAIR PARTS WET WITH FASTENERS MAKING A FAYING SURFACE SEAL. REPAIR COMPLETEDSDR TSAA0353121Shear Tie · damagedDAMAGE DISCOVERED ON SHEER TIE BETWEEN STRINGER 14 AND 15L AT BS 360. CUTOUT DAMAGED SECTION OF SHEAR TIE. FABRICATED A REPAIR SHEAR TIE AND RADIUS FILLER. ALODINE, PRIMED, AND INSTALLED REPAIR PARTS WET WITH FASTENERS MAKING A FAYING SURFACE SEAL. REPAIR SDR 03FDEA00681Structure · corrodedDURING REMOVAL OF CARGO HANDLING TRAY CORROSION OBSERVED ON FLOOR STRUCTURE AT STA 1961 LBL 58 IN CABIN.SDR TSAA0353149Crease Beam · corrodedFOUND CORROSION ON RIGHT CREASE BEAM AROUND NUT PLATE HOLES BETWEEN BS 290 AND 358. REMOVED AND REPLACED ENTIRE SECTION BETWEEN BS 290 AND BS 358. ALODINE, PRIMED, AND INSTALLED REPAIR PARTS WET WITH FASTENERS MAKING A FAYING SURFACE SEAL. REPAIR COMPLETED SDR SWAA030992Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 727D + 19 & BS 794, LT SIDE. REPAIRED CREASE BEAM WEB PER SRM.SDR SWAA030991Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 722B + 9 & BS 752, RT SIDE. REPAIRED CREASE BEAM WEB PER SRM.SDR UPS03840736Door Frame · crackedINSPECTION TYPE: C-2, L2 LWR FWD DOOR JAMB CORNER, DOOR PAN AND DOOR SEAL CRACKED. REMOVED SEAL DEPRESSOR, DOOR PAN. FABBED REPAIR DOUBLER FOR DRAINPAN AND FABBED NEW SEAL DEPRESSOR. INSTALLED IAW DC8 SRM 51-1-21 AND 51-1-20D.SDR UPS03840735Door Frame · crackedINSPECTION TYPE: C-2, BS 50 - 54 S-21L CUSP FRAME CRACKED APPROX 4.5 INCH LONG. FABBED -31 FRAME IAW DAC DWG 5597646. ALODINED AND PRIMED IAW DC8 SRM 51-1-8. INSTALLED -31 FRAME IAW DC8 SRM 51-1-21 & 51-1-20D.SDR UPS03840731Door Frame · crackedINSPECTION TYPE: C-2, L1 DOOR FRAME UPPER FWD CORNER CRACKED 4 EA MARKED FOUND WITH NDT. REMOVED CRACKED AREAS IAW DC8 SRM 53-2-0 FIG 15 AND TR 53-128. FABBED DOUBLER, TRIPLER AND FILLER IAW D8 SRM 53-2-0 FIG 15. ALODINED AND PRIMED IAW DC8 SRM 51-1-8, INSSDR UPS03840723Door Frame · crackedINSPECTION TYPE: C-2, R1 DOOR JAMB UPPER AFT CORNER CRACKED 2 EACH, FOUND WITH NDT. REMOVED DAMAGE IAW DC8 SRM 53-2-0, FABBED FILLER, DOUBLER AND TRIPLER IAW DC8 SRM 53-2-0, TR 53-126 & ALODINED AND PRIMED IAW DC8 SRM 51-1-8. INSTALLED REPAIR IAW DC8 SRM 53SDR DL757030428Frame · crackedTHE INNER STRUCTURE AND WEB OF THE C1 DOOR CUTOUT FWD FRAME AT FS 560 WERE FOUND CRACKED BETWEEN STRINGERS 21R & 22R. THE CRACKS ARE TYPICAL OF AD 2002-24-02 AND BAC S/B 757-53A0080.THE OUTER CHORD WAS DAMAGED DURING THE REPAIR. ALL CRACKS AND DAMAGES WERESDR 2003F00565Door Frame · crackedDURING C-CHECK INSPECTION A 2.5 INCH CRACK WAS FOUND THROUGH TWO FASTENERS AT THE FORWARD AIRSTAIR DOOR UPPER STOP FRAME. THE REPAIRS WHERE ACCOMPLISHED ON NON ROUTINE 031245. (M)SDR DHL2003604526Gusset · crackedMAIN CARGO COMPT - GUSSET CRACKED 0.250 AT STA 1347.000, L-7R. REMOVED CRACKED GUSSET IAW SRM 51-1-21 PG 2. FABRICATED NEW GUSSET (7075-T6 AL0.071) IAW SRM 53-2-0 PG 2. CLEANED, TREATED AND PRIMED AREA AND NEW GUSSET IAW SRM 51-1-8B. INSTALLED NEW GUSSET I
Back to JASC 5310