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 DU4R20111018014Crease Beam · corrodedDURING SCHEDULED INSPECTION, FOUND SEVERAL AREAS OF CORROSION BS 967-1006 CREASE BEAM.SDR QXEA2011101901083Window Frame · corrodedREPLACED ALL HARDWARE ON RT WINDSHIELD DUE TO BEING CORRODED. DRILLED OF RT WINDSHIELD NUT PLATE STRIPS IAW SRM 51-40-07-02-01. LOCATED AND DRILLED NEW NUT PLATE STRIPS IAW SRM 51-40-07-02-01. INSTALLED STRIPS IAW SRM 51-42-05-02-01.SDR QXEA2011101901082Window Frame · corrodedREPLACED ALL HARDWARE ON LT WINDSHIELD DUE TO BEING CORRODED. DRILLED OF LT WINDSHIELD NUT PLATE STRIPS IAW SRM 51-40-07-02-01. LOCATED AND DRILLED NEW NUT PLATE STRIPS IAW SRM 51-40-07-02-01. INSTALLED STRIPS IAW SRM 51-42-05-02-01.SDR TRBA201131904Beam · corrodedAFT CARGO AREA BEAM 36 HAS CORROSION. TREATED AREA AROUND 3 SCREW HOLES INNER SIDE OF CARGO DOOR IAW SRM 51-21-17. PRIMED PAINTED AREA AROUND 3 SCREW HOLES INNER SIDE OF CARGO DOOR IAW SRM 51-21-27.SDR DALA1158460920Door Frame · corrodedDURING HMV CORROSION WAS FOUND ON LOWER SECTION OF AFT VENTRAL DOORJAMB STA Y=1350 BTW X=18 TO X=-18 AT. CORRODED AREA WAS CUT OUT AND FILLER AND DOUBLER WERE INSTALLED IAW ERA 496443-14.SDR AALA20111017TUL06Pan · crackedSTATION 1041, LEFT SIDE OF FUSELAGE, UPPER AFT EAR IS CRACKED ON WINDOW PAN. REMOVED DAMAGED AREA AND INSTALLED WINDOW PAN PER AARD 53-10-00-25.SDR AALA20111017TUL05Pan · crackedSTATION 1079, LEFT SIDE OF FUSELAGE, UPPER AFT EAR IS CRACKED ON WINDOW PAN. REMOVED DAMAGED AREA AND INSTALLED PAN PER AARD 53-10-00-25.SDR SWAA117128Door Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FWD GALLEY DOOR AFT FRAME CRACKED AT I/B EDGE OF CUTOUT. REPAIRED FRAME PER SRM.SDR ZZDA2011876Door Frame · corrodedFWD CARGO LWR DOOR FRAME CORRODED. ACCOMPLISHED LWR DOOR JAMB SPLICE PER SRM 53-20-15 REPAIR 6, FIG 201.SDR AALA20111016TUL01Crease Beam · corrodedCORROSION ON CREASE BEAM WEB ASSEMBLY. REPLACED WEB PER SRM 51-10-02-0G.SDR N6WA20111016022Beam · corrodedFS 280 BEAM HAS CORROSION BETWEEN BULKHEADS ON FWD TOP RADIUS. REMOVED AND REINSTALLED FS 280 BEAM IAW SRM 51-42-06.SDR SWIA201130609Door Frame · corrodedPASSENGER DOOR SURROUND STRUCTURE UNDER FLOORBOARD 231BLF IS CORRODED. (C-CHECK) REPAIRED PER CRJ700 SRM.SDR DALA1158060920Pan · corrodedDURING HMV A BULGING PREVIOUS REPAIR WAS FOUND ON "Z" DOUBLER AT FWD CARGO COMPARTMENT LWR DOOR JAMB PAN BETWEEN STA 368-376 AND 405-412 C1 REPAIRED IAW SRM 53-05 FIG 44.SDR DALA1158180920Beam · corrodedDURING HMV, CORROSION WAS FOUND ON MID CARGO COMPARTMENT DOORJAMB LOWER BEAM BS 636-693 AND ON LOWER BEAM PREVIOUS REPAIR STRAP BETWEEN STA Y=640-650 REF MD88 SRM 53-05D FIG 123 FOR REPAIR.SDR FDEA201110144499Crease Beam · damagedRT CREASEBEAM HAS A DOUBLE DRILLED HOLE AT BS 470. REMVOVED AND REPLACED CREASE BEAM. IAW SRM 51-40-02. MAJOR REPAIR.SDR U2RA20111014068Beam · crackedMAIN PASSENGER CABIN PRESSURE RESISTANT BEAM CRACKED AT FASTENER HOLE AT STA BS 1681 BL 0.SDR IPXA11669993Failsafe · unknownINSPECTION TYPE:8C INSTALLED A PROTECTIVE SHIM BETWEEN THE SKIN AND THE FAILSAFE STRAP ON RT SIDE IAW EO B767-5350-17922-J APPENDIX 'D' FIG 6, REPAIR IS CLASSIFIED AS A MAJOR.SDR SWAA117089Door Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND R1 DOOR CUTOUT FRAME CRACKED AT BS 295.5, STR 17R. REPAIRED FRAME PER SRM.SDR COEA2011101310919Crease Beam · corrodedHEAVY CK COE / LEVEL 2 CORROSION: LT CREASE BEAM WEB FR 12-13 CORRODED. (LENGTH .75", WIDTH .25", DEPTH .016"). REMOVED AND REPLACED CREASE BEAM WEB.SDR FDEA201110134480Crease Beam · corrodedCREASEBEAM BS 1300-1320 LBL 58.22 CORRODED. REMOVED CORROSION, FOUND OUT OF LIMITS IAW SRM 53-60-13, FIG 101, DETAIL 8, P 105. R & R CREASEBEAM IAW SRM 51-40-02, AND DWG 146N8322. MAJOR REPAIR.SDR IPXA11669994Tee Fitting · corrodedINSPECTION TYPE:8C, FRETTING FOUND AT TEE FITTING FWD LOWER HOLE MATING SURFACE AREA, TEE FITTING REPLACED IAW EO B767-5350-17922-J, APPENDIX 'D' FIG 6. REPAIR IS CLASSIFIED AS A MAJOR.SDR FDEA201110124455Door Frame · dentedFWD CARGO DOOR CUT-OUT FWD EDGE INTERIOR SIDE HAS A DENT APPROX 6.0L X .40W. REMOVED AND REPLACED PARTIAL FRAME BETWEEN S34 AND 45R IAW EA 6-5310-156035.SDR ASOA201101959Support Beam · crackedCARGO DOOR SUPPORT BEAM AFT LOWER ANGLE IS CRACKED APPROX .3" IN LENGTH. LOCATED, DRILLED, DEBURRED & INSTALLED NEW LOWER ANGLE IAW SRM 51-40-11 & 51-42-21.SDR QXEA2011101701015Flange · corrodedINTERIOR BELLY FRAME X258.500 FLANGE HAS CORROSION BETWEEN STRINGERS 31P AND 32P. BLENDED CORROSION IAW RD 8/4-53-2344. REMAINING THICKNESS 0.41" NO CRACKS. ALODINED PRIMED AND PAINTED AREA.SDR ZZDA2011870Channel · corrodedMAIN CABIN GALLEY INBD LOWER SIDEWALL, CORROSION. ACCOMPLISHED GALLEY INBD LOWER SIDEWALL DOUBLER REPAIR PER EA 17-53-035391 IR SECTION 1. REPLACED DOOR FRAME CHANNEL PER B717 SRM 51-41-01 & SRM 51-41-02. SEE NR 725593.SDR HALA2011101100468Window Frame · damagedFUSELAGE EXTERNAL WINDOW FRAME LT 1, HAS EVIDENCE OF LIGHTNING STRIKE. REWORK AFFECTED AREA IAW SRM 56-20-02-1A-1, REV 87.SDR FDEA201110104411Skin · misrepairedSKIN AT BS 1540-1580, S2-3L MISREPAIRED. REPAIRED IAW EA F-5330-147745.SDR IPXA11669991Tee Fitting · crackedINSPECTION TYPE:8C, FUSELAGE BS 955 LT REAR SPAR BULKHEAD FITTING AREA WAS FOUND 1 EA FASTENER HOLE CRACKED ON 6 O/C POSITION AT TEE FITTING APPROX .1250" IN LENGTH. TEE FITTING REPLACED IAW EO NR B767-5350-17922-J APPENDIX 'C', FIG 6, CRACK APPROX .1250" IN SDR IPXA11669989Failsafe · crackedINSPECTION TYPE:8C, FUSELAGE LT BS 955 REAR SPAR BULKHEAD SIDE FITTING WAS FOUND 1EA FASTENER HOLE CRACKED AT FAILSAFE STRAP ON 2 O/C AND 4 O/C POSITION THROUGH THICKNESS AND .1250" IN LENGTH. REPAIRED IAW EO B767-5350-17922-J APPENDIX 'C', REPAIR IS CLASSISDR IPXA11669992Failsafe · crackedINSPECTION TYPE:8C, FUSELAGE RT BS 955 FAILSAFE STRAP FOUND CRACKED. REPAIRED IAW EO B767-5350-17922-J APPENDIX 'D'. REPAIR IS CLASSIFIED AS A MAJOR.SDR A6WA201141040Door Frame · crackedPAX DOOR FRAME 338.00 CRACKED. LOCATED NEAR UPPER TORQUE TUBE 601R-52-11-402, REV H. REPAIRED PAX DOOR FRAME AT 338.00 IAW B/A REO 601R-52-11-402, REV H.SDR IPXA11669990Failsafe · crackedINSPECTION TYPE:8C, FUSELAGE RT BS 955 REAR SPAR BULKHEAD FITTING FAILSAFE STRAP AREA CRACK FOUND, REMOVE FASTENER FOR NDT CONFIRMATION. R & R IAW EO B767-5350-17922-J APPENDIX 'D' FIG 6. REPAIR IS CLASSIFIED AS A MAJOR.SDR IPXA11669988Failsafe · crackedINSPECTION TYPE:8C, FUSELAGE LT BS 955 REAR SPAR BULKHEAD FITTING FAILSAFE STRAP AREA, CRACK FOUND, REMOVE FASTENER FOR NDT CONFIRMATION. REMOVED AND REINSTALLED IAW EO NR B767-5350-17922-J APPENDIX 'C' FIG 6. REPAIR IS CLASSIFIED AS A MAJOR.SDR UIEA2011102100618Structure · crackedSTRUCTURE CRACKED AT BS 1081 WHERE HYDRAULIC LINE PASSES THROUGH OTBD OF LT OVERWING SLIDE CYLINDER FWD END. CUTOUT DAMAGED AREA AND INSTALLED REPAIR DOUBLER.SDR GLBA20111007FDoor Frame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUTINE INSP, FOUND A CRACK ON THE DOOR LOWER FRAME AT FS 172-174, 2.5" IN LENGTH. REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS IAW EO 11-1900-53-058. MATERIALS UTILIZED ARE INCLUDED IN THE EO.SDR P5CA2011100700472Reveal · crackedPANEL REVEAL OF L1 ENTRY DOOR SURROUND STRUCTURE AT STATION 440 WL 213 HAS A .35 INCH CRACK. ACCOMPLISHED REPAIR AS PER EIT2011A53B-1931.SDR FDEA201110064344Crease Beam · corrodedRT SIDE CABIN INNER CREASEBEAM FROM STA 900-1040 HAS CORROSION. BLENDED CORRODED AREA IAW SRM 51-10-02. ORIGINAL THICKNESS OF CHORD IS 0.75" IAW SRM 53-40-13 FIG 1 ( SHEET 2 ). AFTER REMOVED CORROSION ON 3 SPOTS MATERIAL REMAINING IS .035" ALL AREAS FOUND OUSDR FDEA201110064320Door Frame · corrodedAFT LWR CARGO, FWD LWR CORNER OF DOOR CUTOUT AT STA 1381.5 HAS CORROSION ON LOCK FASTENER COLLAR 1 EA AND CORROSION ON SURFACE AREA SURROUNDING THE DISCREPANT FASTENER. REPAIR CARRIED OUT IAW EA F-5310-152578. REPAIR CLASSIFIED AS MAJOR.SDR FDEA201110064319Door Frame · corrodedAFT LWR CARGO NR 2 DOOR CUTOUT LWR CHORD HAS CORROSION ON OTBD SIDE JUST AFT OF FWD SUPPORT FITTING AT STA 1386.5. REPAIR CARRIED OUT IAW EA F-5310-152578. REPAIR CLASSIFIED AS MAJOR.SDR IPXA11M69773Torque Box · crackedINSPECTION TYPE:4C, R3 FWD DOOR JAMB LOWER TORQUE BOX WEB IS CRACKED. REPAIRED R3 FWD DOOR JAMB LOWER TORQUE BOX WEB REF SRM 53-40-15 REPAIR 3, FIG 201.SDR IPXA11M69772Torque Box · crackedINSPECTION TYPE:4C, L3 AFT DOOR JAMB LOWER TORQUE BOX WEB IS CRACKED. REPAIRED L3 AFT DOOR JAMB LOWER TORQUE BOX REF SRM 53-40-15, REPAIR 3, FIG 201.SDR SWAA116883Crease Beam · corrodedDURING SCHEDULED 28Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 302, RBL 52. REPAIRED BEAM PER BAC DWG AND SRM.SDR FDEA201110044285Crease Beam · corrodedUPPER CABIN RT SIDE INNER CREASEBEAM FROM STA 1180R TO 1040R HAS CORROSION. REPAIR CONSIDERED MINOR.SDR UALA2011100305339Crease Beam · corrodedCORROSION FOUND ON CREASE BEAM AT BS 996 AT STRINGER S-17R. REMOVED CORROSION & FOUND BLEND OUT OF SRM LIMITS. ACCOMPLISH NDT INSPECTION OF BLENDED OUT AREA IN ADDITION TO NDT OF OPEN HOLES COMMON TO REPAIR AREA. NO DEFECTS FOUND. FABRICATED AND INSTALLEDSDR DALA1156406310Doubler · crackedCRACK WAS FOUND ON DOOR FRAME REVEAL DOUBLER OF LT MAIN ENTRY DOOR FWD CUTOUT STA 2231 S-21L-S-22L L:3". PERFORMED THE DOOR REVEAL DOUBLER REPAIR PER B747-400 SRM 53-60-15 REPAIR 3 FIG 201.SDR DALA1156426310Doubler · crackedCRACK WAS FOUND ON DOOR FRAME REVEAL DOUBLER OF R/H5 MAIN ENTRY DOOR FWD CUTOUT STA 2231. S-21R-S-22R L:3". PERFORMED THE DOOR REVEAL DOUBLER REPAIR PER B747-400 SRM 53-60-15 REPAIR 3 FIG 201.SDR FDEA201109294214Torque Box · damagedAFT AIRSTAIR AREA, RT TORQUE BOX INBD VERTICAL WEB HAS SMALL GOUGED AREA AT BS 1270. VERTICAL WEB ON RH TORQUE BOX RBL 20.5 STA 1253 TO 1283 REMOVED, FABRICATED NEW, AND INSTALLED.SDR UALA2011092905274Crease Beam · corrodedRT CREASE BEAM CORRODED BETWEEN STA 333.45 AND STA 350 ON INTERIOR SIDE. MAJOR REPAIR ACCOMPLISHED. REMOVED CORROSION IAW B757 SRM ON DOOR 1R CREASE BEAM WEB AND FOUND TO BE OUT OF LIMITS IAW SRM. FABRICATED NEW WEB FROM .040" 7075 T6 IAW AMM, PRIMED AND TOSDR N6WA20110930Crossbeam · corrodedFRAME STATION 280, CROSSBEAM HAS CORROSION. ACCOMPLISHED CROSSBEAM 280 REPLACEMENT-SPLICE REPAIR IAW REO 670-53-470.SDR FDEA201109284185Crossbeam · corrodedAFT CARGO CROSSBEAM AT FR63 FOUND CORRODED AFT CARGO CROSSBEAM AT FR 63. REPLACED IAW SRM 51-40-21 & DWG A53974554.
Back to JASC 5310