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 SWAA114344Window Frame · crackedDURING SCHEDULED SPV CHECK, FOUND RT WINDOW FRAME CRACKED AT BS 420+10. REPAIRED FRAME PER TC.SDR SWAA114345Window Frame · crackedDURING SCHEDULED SPV CHECK, FOUND RT WINDOW FRAME CRACKED AT BS 400+10. REPAIRED FRAME PER TC.SDR SWAA114351Crease Beam · corrodedDURING SCHEDULED 22Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 482A, STR 17L. REMOVED AND REPLACED WEB IAW BAC DWG.SDR GLBA20110613HDoor Frame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUTINE INSPECTION, MX FOUND A CRACK IN THE A/S DOOR FUSELAGE FRAME ANGLE AT FS 150.60 & STRINGER 9AL AT THE AS DOOR LWR MOUNTS, UPPER AFT ATTACH POINT, 2 CRACKS 1" IN LENGTH. REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUISDR A6WA201140494Track · gougedCARGO DOOR AFT TRACK GOUGED. BLENDED GOUGED AREA OF THE CARGO DOOR AFT TRACK. REMOVING .055" LEAVING .215" MATERIAL IAW REO 601R-53-62-024 WITHIN LIMITS.SDR ZZDA2011552Door Frame · corrodedFORWARD CARGO CUTOUT LOWER DOOR JAMB, CORROSION. ACCOMPLISHED JAMB SPLICE REPAIR PER B717 SRM 51-10-04 AND 53-20-15.SDR FDEA201106122209Structure · corrodedUPON REMOVAL OF LT WINDSHIELD, CUTOUT AREA FOUND CORRODED. CARRIED OUT REPAIR IAW EA 1-5310-147652, REPAIR CLASSIFIED AS MINOR IAW GMM6-2-100, REV 112.SDR AALA20110611TUL05Pan · crackedLEFT WINDOW PAN CRACKED AT UPPER CORNER STATION 1230. REMOVED DAMAGE AND INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20110611TUL04Pan · crackedLEFT WINDOW PAN CRACKED AT UPPER CORNER STATION 1078. REMOVED DAMAGE AND INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20110611TUL03Pan · crackedRIGHT WINDOW PAN CRACKED AT UPPER CORNER STATION 1192. REMOVED DAMAGE AND INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR JR2R2011061100261Door Frame · corrodedSERVICE DOOR LOWER FRAME HAS CORROSION BETWEEN FRAMES 319 AND 333.SDR FDEA201106102192Crease Beam · corrodedCABIN, CREASE BEAM AT STA 761 LT HAS CORROSION. REPAIR CARRIED OUT AS PER E.A. F-5310-150709 PART 1. REPAIR IS CLASSIFIED AS MAJOR.SDR FDEA201106102191Crease Beam · corrodedCREASE BEAM STA 755 - 990, RBL 60, HAS CORROSION APPROX 1" CIRCULAR AT STA 755 AND APPROX. 1" CIRCULAR AT STA 790. REPAIR CARRIED OUT ON CREASE BEAM AS PER E.A. F-5310-150708 PART 1. REPAIR IS CLASSIFIED AS MAJOR.SDR IPXA1667400Failsafe · corrodedINSPECTION TYPE:8C, FUSELAGE RT BS 955 BULKHEAD SIDE FITTING - A SLIGHT CORROSION FOUND AFTER FAIL SAFE STRAP TRINNED OFF AT THE INTERNAL SURFACE OF THE SKIN IN THE AREA OF THE SKIN IN THE AREA WHERE THE "T"FITTING TO THE FAIL SAFE STRAP. RT BS 955 BULKHEAD SSDR IPXA1667394Failsafe · corrodedINSPECTION TYPE:8C, FUSELAGE LT BS 955 BULKHEAD SIDE FITTING - CORROSION FOUND AFTER FAIL SAFE STRAP TRIMMED OFF AT THE INTERNAL SURFACE OF THE SKIN IN THE AREA WHERE THE "T" FITTING TO THE FAIL SAFE STRAP. FUSELAGE LT BS955 BULKHEAD SIDE FITTING - SLIGHT CSDR UALA2011061302868Crease Beam · corrodedCORROSION AROUND FASTENER ON CREASE BEAM AT RT STA 1050. COMPLETED REPAIR IAW EA PD 57-53-129.SDR SWAA114232Crease Beam · crackedDURING SCHEDULED SPV CHECK FOUND, CREASE BEAM WEB CRACKED AT BS 616, RBL 65.5. REMOVED AND REPLACED WEB PER SRM.SDR FDEA201106092170Web · crackedAFT AIRSTAIRS LT LOWER TORQUE BOX UPPER WEB IS PUNCTURED AND CRACKED AT BS 1225, (BELOW BAZOOKA VALVE STAND-OFF) CUTOUT DAMAGE ON LT LWR TORQUE BOX UPPER WEB IAW SRM REV 103, 51-40-2 FIG 1 AND 51-10-1. FABRICATED REPAIR DOUBLER IAW SRM 53-10-2 FIG 6 AND 51SDR AALA20110609TUL12Pan · crackedUPPER AFT CORNER OF WINDOW RINGPAN IS CRACKED LEFT STATION 1022. CUT OUT CRACKED AREA OF WINDOW RINGPAN. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20110609TUL11Pan · crackedUPPER AFT CORNER OF WINDOW RINGPAN IS CRACKED LEFT STATION 1041. CUT OUT CRACKED AREA OF WINDOW RINGPAN. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20110609TUL08Beam · corrodedAFT CARGO DOOR BEAM HAS CORROSION ON WEB STATIONS 1155 TO 1212. REPLACED WEB PER AARD 51-10-00-5.SDR FDEA201106092168Crease Beam · gougedRT CREASE BEAM INBD CHORD, STA 1180-1400 GOUGED AT AND AROUND NUMEROUS FASTENER HOLES EVALUATED DAMAGES ON CREASEBEAM FOUND TO BE OUT OF LIMITS IAW SRM 53-40-13, FIG 101, SH 3, DETAIL 2 ( L= .5 W=.1 D=.015) ORIG .080 DAMAGED AREA .065 REMOVED CREASEBEAM RT SDR IPXA1667397Failsafe · crackedINSPECTION TYPE:8C, FUSELAGE LT BS 955 REAR SPAR BULKHEAD FITTING AREA, 2 EA CRACKS FOUND AT FAIL-SAFE STRAP AT 3 O'CLOCK POSITION APPROX .1250" AND 7 O'CLOCK POSITION APPROX .1250". FUSELAGE LT SIDE BS 955 REAR SPAR BULKHEAD FITTING FAIL SAFE STRAP REPAIRED SDR IPXA1667392Failsafe · crackedINSPECTION TYPE:8C, FUSELAGE RT BS 955 REAR SPAR BULKHEAD FITTING AREA CRACK FOUND AT FAIL SAFE STRAP AT 8 O'CLOCK POSITION. THROUGH THICKNESS FUSELAGE BS955 RT SIDE REAR SPAR BULKHEAD FITTING FAIL SAFE STRAP REPAIRED IAW EO B767-5350-17922-H, APPENDIX "D". SDR UALA2011060802818Crease Beam · corrodedCORROSION AROUND FASTENERS ON CREASE BEAM AT RT FS 1166. MAJOR REPAIR ACCOMPLISHED: AFTER CORROSION REMOVAL FOUND OUT OF LIMITS PER SRM. FABRICATED REPAIR PER INSTRUCTIONS ON EA PD 57-53-131 WITHOUT DEVIATION. THIS IS A PERMANENT REPAIR WITH FAA 8100-9 DATESDR ASOA201101143Post · crackedFOUND FS 409.0+128 LBL 18.0 OTBD VERTICAL POST HAS INDICATION NOTED APPROX .2" IN LENGTH, 50 PERCENT FSH AT WL 69.0 AFT FLANGE RADIUS. FAILED NDT INSPECTION. REPAIRED IAW AMM 51-23-00-390-804.SDR ASOA201101142Post · crackedFOUND VERTICAL POST FS 409.0+128, BL 0.0 LT AND RT SIDES HAVE INDICATIONS NOTED APPROX .2" IN LENGTH 80 PERCENT FSH AT WL 69.0 AFT FLANGE RADIUS. BOTH FAILED NDT INSPECTION. REMOVED POST IAW SRM 51-42-06 AND 51-42-21. INSTALLED POST ASSY IAW REO 601R-53-4SDR ASOA201101140Post · crackedFOUND FS 409.0+128, RBL 18.0 OTBD VERTICAL POST HAS INDICATION NOTED APPROX .2" IN LENGTH 50 PERCENT FSHF AT WL 69.0 AFT FLANGE RADIUS. FAILED NDT INSP. REMOVED POST IAW SRM 51-42-06. INSTALLED NEW POST ASSY IAW REO 601R-53-41-889 AND SRM 51-42-06.SDR SWAA114168Crease Beam · crackedDURING SCHEDULED 26Y CHECK, FOUND CREASE BEAM WEB CRACKED BETWEEN BS 616 TO BS 639, BETWEEN LBL 63 TO LBL 70. REMOVED AND REPLACED WEB PER SRM.SDR SWAA114162Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND LT CREASE BEAM WEB CORRODED BETWEEN BS 887 TO BS 907, RBL 65. REMOVED AND REPLACED WEB PER SRM.SDR SWAA114161Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND LT CREASE BEAM WEB CORRODED BETWEEN BS 887 TO BS 907, LBL 65. REMOVED AND REPLACED WEB PER SRM.SDR SWAA114160Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND LT CREASE BEAM WEB CORRODED BETWEEN BS 847 TO BS 867, LBL 65. REMOVED AND REPLACED WEB PER SRM.SDR UALA2011060802809Crease Beam · corrodedCORROSION ON CREASE BEAM WEB INNER CHORD FROM RT FS 1020-1040 MAIN CABIN. MAJOR REPAIR ACCOMPLISHED: INSTALLED REPAIR CHORD, SPLICE CHANNEL AND STRAP BTW STA 1011 - 1040, RBL 58 PER EA 57- 53-130 ON NR 2647N00406.SDR UALA2011060802803Crease Beam · corrodedCORROSION ON CREASE BEAM WEB INNER CHORD FROM RT FS 1020-1040 MAIN CABIN. MAJOR REPAIR ACCOMPLISHED, INSTALLED REPAIR CHORD, SPLICE CHANNEL AND STRAP PER EA 57- 53-130.SDR REXA201100363Window Frame · damagedCABIN WINDOW FRAME SCREW COUNTERSINK JUST AFT OF FS 409+48 LIGHTNING DAMAGE. REPAIRED IAW BOMBARDIER REO 601R-53-00-419 REPAIR 11.SDR DALA13027803725Door Frame · damagedDURING INSPECTION FOUND FUSELAGE L1 DOOR SURROUND STRUCTURE AT FS 360 DAMAGED. MX C/W PERMANENT REPAIR IAW ERA 493220-14, REV D.SDR IPXA11567614Crease Beam · corrodedINSPECTION TYPE:C1, CREASE BEAM BETWEEN STA 882 TO STA 890, RBL 65 THERE ARE 2 AREAS OF CORROSION. REPAIRED IAW EO B757-5310-43322-A.SDR IPXA1667396Failsafe · crackedINSPECTION TYPE:8C, FUSELAGE LT BS 955 REAR SPAR BULKHEAD FITTING SUSPECT CRACK FOUND AT FAIL-SAFE STRAP AREA. REMOVE FASTENER FOR NDT CONFIRMATION FUSELAGE LT BS955 REAR SPAR BULKHEAD FAIL SAFE STRAP ATT MOST LOWER BOLT REMOVED AND REINSTALLED IAW EO B76SDR IPXA1667393Failsafe · crackedINSPECTION TYPE:8C, FUSELAGE RT BS 955 REAR SPAR BULKHEAD FITTING SUSPECT CRACK FOUND AT FAILSAFE STRAP AREA. REMOVE FASTENER FOR NDT CONFIRMATION FUSELAGE RT BS955 REAR SPAR BULKHEAD FAIL SAFE STRAP ATTACH MOST LOWER BOLT. REMOVED AND REINSTALLED IAW EO B7SDR DALA1138890915Door Frame · crackedCRACK UPPER FOWARD CARGO DOOR JAMB CORNER. REMOVED AND REPLACED TRIPLER.SDR IXXA11SMN075SStructure · misrepairedDURING ROUTINE C-CHECK INSP, FOUND IMPROPER REPAIR AT SMALL DRAIN DOUBLER FWD LOWER CENTER FUSELAGE FORWARD OF CENTER EQUIP DOOR AT STA FS 615 LONGERON 36. REMOVED FASTENERS AS NEEDED TO PERFORM REPAIR. REMOVED REPAIR EXISTING REPAIR. FABRICATED REPAIR DOUBSDR UIEA2011060300315Tension Tie · damagedDAMAGE WAS DISCOVERED DURING INSPECTION IAW EO 4753B328 - SB 747-53A2502 (ASSOCIATED WITH AD 2006-01-07) AT THE C4 CHECK. IN ADDITION TO THE SHORT EDGE MARGIN ON THE TENSION TIE, THE FRAME AND FRAME DOUBLER FASTENER HOLES HAVE BEEN PREVIOUSLY OVERSIZED IAW SB SDR IPXA11567598Frame · dentedINSPECTION TYPE:C1 BULK CARGO BAY, B.S 1500 FRAME HAS A DENT ON UPPER SURFACE INBETWEEN STR 23R AND 24R. REPAIRED IAW SRM 53-00-07-2R-5.SDR IPXA11567524Crease Beam · corrodedINSPECTION TYPE:C1, CREASEBEAM HAS CORROSION ON UPPER SURFACE, BS 1587, RBL 63, WL 208. REPAIRED IAW ER 11-03070.SDR ASAA1149746Structure · crackedUPON REMOVAL OF THE FORWARD CARGO COMPARTMENT LT TRANSITION PANEL FOUND A CRACKED BAFFLE BETWEEN BS 500D AND 500E AT STR 26L. REMOVED AND REPLACED BAFFLE IAW SRM 51-40-02 AND 51-40-05.SDR AALA20110602TUL08Pan · crackedFORWARD SIDE OF RIGHT FRAME STATION 946, UPPER AFT WINDOW PAN TAB IS CRACKED. INSTALLED WINDOW PAN TAB AND STRAP PER EA MD80-53-017187 AND AARD 53-10-00-25.SDR AALA20110602TUL07Door Frame · corrodedAFT CARGO DOOR FRAME HAS CORROSION, STATIONS 1212 TO 1205, STRINGERS 28 TO 29 RIGHT. REMOVED AND REPLACED WEB PER AARD 51-10-00-5.SDR AALA20110602TUL06Door Frame · corrodedAFT CARGO DOOR FRAME HORIZONTAL DOUBLER SEAM HAS CORROSION AT STATION 1180. INSTALLED LOWER AFT DOOR STOP PAD FILLER AND DOOR BEAM DOUBLER PER AARD 53-10-00-3 AND EA MD80-53-0177225.SDR IPXA11667216Failsafe · crackedINSPECTION TYPE:8C, FUSELAGE RT BS 955 REAR SPAR BULKHEAD SIDE FITTING FAIL SAFE STRAP CRACK FOUND RUNNING FWD AND AFT. FX BS 955 RHS REAR SPAR BULKHEAD SIDE FITTING FAIL SAFE STRAP REPAIR IAW EO B767-5350-17922-H, APP D, ORG MATERIAL IS 2024T351-0.750" MACHISDR IPXA11667215Failsafe · damagedINSPECTION TYPE:8C, DURING ACCOMPLISH EO B767-5350-17922-H, BS 955 REAR SPAR BULKHEAD SIDE FITTING FAIL SAFE STRAP INSPECTION, A FASTENER HOLE WAS FOUND WHICH LARGER THAN EO CALL OUT AT LT SIDE. FX BS955 LT SIDE NEAR STR-23L REAR SPAR BULKHEAD SIDE FITTING FA
Back to JASC 5310