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 AAL2002F00002Door Frame · corrodedWEB, AFT CARGO DOOR CUTOUT, LOWER FRAME, TOP. CORROSION ON TOP WEB OF AFT CARGO DOOR CUT OUT LOWER FRAME. REMOVED CORRODED TOP WEB. INSTALLED NEW WEB PER SRM. (2002-1149 /AMC 4)SDR SIMA200220511Shear Tie · corrodedFOUND FRAME 65 SHEAR TIE CORRODED. REMOVED CORROSION BY CUT OUT. FABRICATED A REPLACEMENT SPLICE. REPAIR DONE IAW SRM.SDR UPS02239020Doubler · crackedINSPECTION TYPE:C CRACK ON R/H WINDOW POST BETWEEN R1 & R2 WINDOWS AT UPPER CORNER REPAIR DOUBLER FABRICATED IAW SRM 53-30-3 REPAIR DOUBLER INSTALLED IAW SRM 53-30-3 FIG 8 REPAIR 2SDR UPS02239012Window Post · crackedINSPECTION TYPE:C CRACKS ON CENTER WINDOW POST ON LWR LHS & RHS COCKPIT CENTER WINDOW POST REPAIRED IAW UPS EO B727-5330-5128SDR QXEA0201074Door Frame · gougedPDX- LOWER CORNER OF BAGGAGE DOOR CUTOUT BETWEEN STATIONS 580.000 TO 597.000 HAS NUMEROUS NICKS, SMALL GOUGES, AND PAINT CHIPPING OFF. REPAIRED IAW DHC-8 SRM 51-20-11, 51-20-26 AND 51-20-51.SDR 2002UALA01195Door Frame · crackedFORWARD GALLEY DOOR CUTOUT FRAME IS CRACKED AT FORWARD TOP STOP PAD FITTING LOWER OUTBOARD CORNER. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW FRAME.SDR SWAA021616Crease Beam · crackedDURING SCHEDULED D CHECK, FOUND CREASE BEAM CRACKED AT BS 520, WL 280 AND LBL 65. REPAIRED CREASE BEAM PER SRM.SDR SIMA200220504Beam · corrodedFOUND CARGO DOOR CUTOUT LOWER SILL BEAM CORRODED. REMOVED CORRODED SILL (BEAM). INSTALLED NEW BEAM IAW SRM. (B8349)SDR 02FDEA00508Shear Tie · gougedSHEAR TIE GOUGED AT BS 540, JUST BELOW STR 14R. REPAIRED SHEAR TIE BS 540 BELOW STR 14R IAW SRM 53-10-4, 53-10-2.SDR 0203219867Bracket · crackedDuring Mck in ATL, 2 cracks were found on the left and right station 69 brackets X=+- 10". Repaired per EA 98-190582.SDR ABXA030225Door Frame · corrodedAFT CARGO, BS 1220, FUSELAGE FRAME CORRODED JUST INBOARD OF SLIDING DOOR, LOWER AFT CUTOUT. REPLACED DOOR FRAME ZEE FITTING, FABRICATED REPAIR SPLICE ANGLES AND FILLERS. INSTALLED IAW DC-8 SRM 53-2-0, 51-1-8, AND 51-3-0.SDR GTIA020923Beam · corrodedFTW - FOUND CARGO DOOR JAMB BEAM CORRODED FS 636 TO 693. REMOVED JAMB BEAM MID CARGO DOOR AND BRACKETS. FABRICATED BRACKETS AND CENTER BACK. LOCATED AND DRILLED NEW JAMB BEAM. INSTALLED JAMB BEAMS MID CARGO DOOR AND CORNER BRACKET. (M)SDR GTIA020921Beam · corrodedFTW - FOUND AFT PIT STATION 1155-1212 L28R, REPAIR STRAP ON DOOR JAMB BEAM IS CORRODED. REMOVED CORROSION AND INTERCOSTAL. FABRICATED INTERCOSTAL AND ANGLES. INSTALLED CLIPS BRACKETS, ANGLES AND NEW INTERCOSTAL. (M)SDR ABXA030224Shear Tie · corrodedAFT LOWER CARGO, SHEARTIE CORRODED AT STA. 1200, LONGERON 28 - 29 LEFT. REMOVED CORROSION, OUT OF LIMITS. REMOVED FITTING AND FABRICATED SPLICE, INSTALLED NEW FITTING IAW DC-8 SRM 51-1-8, 53-2-0, AND 51-1-20D.SDR 0203029975Angle · crackedDuring Hck in ATL Maintenance Base, the LH side of the verticle stabilizer attach angle (aft) was found cracked at station 1100. Repaired per EA 99-190557.SDR UPS02438837Shear Tie · crackedINSPECTION TYPE:SP STA 720 STR 44L SHEAR TIE IS CRACKED. REMOVED DAMAGED SECTION OF SHEAR TIE, NDT VERIFIED NO CRACKS. AFTER DAMAGE REMOVAL, FABRICATED AND INSTALLED SHEAR TIE IAW SRM 53-10-04.SDR SIMA200220512Beam · damagedFOUND UNDOCUMENTED BLENDED AREAS ON LEFT OMEGA BEAM (PREVIOUS REPAIR) AT FRAME 20. REMOVED PREVIOUS REPAIR AND FABRICATED A DOUBLER, FILLER, PLATE AND TWO SHIMS. REPAIR DONE IAW SRM. (B8349)SDR AUS20020877Structure · damaged(AUS) FORWARD BULKHEAD, NLG ATTACHMENT FITTINGS AND SURROUNDING LOWER FUSELAGE STRUCTURE DAMAGED WHEN THE NOSEWHEEL CONTACTED A ROCKDURING LANDING.SDR SIMA200220513Sill · damagedFOUND NUMEROUS UNDOCUMENTED BLENDED AREAS ON SERVICE DOOR CENTER SILL. FILLED BLENDED AREAS WITH EPOXY RESIN, SANDED AREA SMOOTH. FABRICATED REPAIR DOUBLER. REPAIR DONE IAW SRM.SDR UPS02439005Skin · crackedINSPECTION TYPE:C R/H OF BS 1480 BULKHEAD S34R STRINGER END FITTING COMMON TO SKIN AREA, 1 EA FASTENER HOLE FOUND CRACK AT INNER SKIN AT FWD AND AFT DIRECTION CRACK LENGTH UNDETERMINED DUE COVERED BY OVERLAPPING SKIN. RH BS 1480 B/H AT STR 34R AREA SKIN 1 SDR CA020711002Door Frame · worn(CAN) OUTBOARD DOOR SKIN HAS WORN THE DOOR FRAME LINTEL AT THE RADIUS INTO THE DOOR OPENING AS MUCH AS 50 PERCENT MATERIAL THICKNESS.SDR 2002FA0000848Bracket · crackedDURING INSPECTION TO DETERMINE WHY INDUCTION AIR FILTER WAS RUBBING AGAINST OPENING IN LOWER ENGINE COWL. IT WAS FOUND THAT THE LT UPPER FIREWALL WAS FILLED FORWARD APPROX .2500 INCH WHERE ENGINE MOUNT ATTACHED TO FIREWALL. AFTER REMOVEING INTERIOR PANEL FOSDR AALA20021045Door Frame · corrodedTUL - FOUND CORROSION ON AFT CARGO DOOR CUT OUT LOWER DOOR BEAM. REMOVED AND REPLACED AFT CARGO CUT OUT LOWER DOOR BEAM PER AARD 53-10-00-3. (M)SDR GTIA020802Door Frame · crackedFTW - FOUND L1 DOOR FRAME HAS CRACK STATION 195 Z67. STOP DRILLED CRACK. (M)SDR AWXA200200642Fitting · wornYVR - MAJOR REPAIR - DURING C-14 CHECK THE AFT GALLEY DOOR FORWARD FRAME, 2ND STOP FITTING FROM THE TOP WAS FOUND TO HAVE INSUFFICIANT EDGE MARGIN AT THE DOOR ASSIST HANDLE ATTACH BS 951. MAINTENANCE REMOVED DOOR STOP FITTING BS 951, FABRICATED A FRAME FILLER,SDR 0203019975Bulkhead · crackedDuring HCK in ATL, a crack was found on the LH portion of the APB Door cutout upper jamb. A repair of the upper jamb area was extended to incorporate the the cracked area. Repaired per EA 99-190542.SDR AALA20020980Door Frame · corrodedCORROSION ON AFT CARGO DOOR JAMB LOWER CHORD ANGLE FROM STA 1155 TO 1211. REMOVED CORROSION BEYOND LIMITS. REPLACED COMPLETE LOWER DOOR, CHORD ANGLE.SDR UPS02439004Skin · crackedINSPECTION TYPE:C CRACK FOUND AT BS 1480 LHS B/H ATTACHED SKIN AT 1 EA FASTENER HOLE OF S34L STRINGER ENG FTG LOWER HOLE. THE CRACK LOCATED AT 8 O'CLOCK POSITION AND WITH LENGTH 0.050" APPROX. LH BS 1480 B/H FX SKIN AT STR 34 AREA AT HOLE #9 CRACK FREE FINSDR UPS02438954Longeron · crackedINSPECTION TYPE:C FX LH OVERWING LONGERON AFT SPLICE END AT STA 1460 - 1470, FWD HOLE FOUND CRACKED 1/4" LONG & 1/4" DEPTH FROM TOP SURFACE WITH NDT AND MID & AFT HOLES BORE CORROSION IS REVEALED. BS 1350 - 1480 RH OVERWING LONGERON REPAIRED IAW RS R-53-43SDR UPS02438922Bracket · crackedINSPECTION TYPE:C M/D - BS 2231, S26R FRAME ATT BRACKET CRACKED. ( AT FLOOR LEVEL AREA ). M/D BS 2231 S26R FLOOR LEVEL AREA FRAME ATT BRACKET REPLACED AS PER SRM 51-10-01. P.8.SDR UPS02438989BulkheadINSPECTION TYPE:C CARRY OUT BS 1480 BULKHEAD AND SPLICE COMPONENT MODIFICATION AS PER SB 747-53A2390 R1 PLAN B. BS 1480 L/R B/H & SPLICE COMPONENT MOD C/OUT AS PER SB 747-53A2390 R.1 PLAN B AS PER FIG 2,3,4,6,7,8,14,17,19,20,23 & 28, APPENDIX 'A', 'C' & 'DSDR 2002UALA01130Crease Beam · crackedCABIN RIGHT FORWARD CREASE BEAM CORRODED AND CRACKED IN RADIUS AT STA 294.5, RBL 54, WL 208. MAJOR REPAIR ACCOMPLISHED. REPLACED CREASE BEAM INBOARD ANGLE.SDR UPS02438990Bulkhead · crackedINSPECTION TYPE:C CRACK FOUND AT UPPER BULKHEAD FORGING RADIUS AREA, CRACK RUNNING UPWARD 1.5" IN LENGHT APPROX. L/H BS 1480 B/H CHORD FWD RADIUS CRACKED AREA TRIMMED OFF & REPAIRED PER HX RS R-54-43-34841 ITEM '14' & '15'. REFER HX RS R-53-43-34841 & UPS SDR UPS02438942Strap · crackedINSPECTION TYPE:C R/H BS 2231 STR 24-26 AT REPAIR AREA FASTENER HOLES FOUND 1 EA FASTENER HOLE CRACK AT STRAP LAYER APPROX 3/16" INCH IN LENGTH AND CRACK END AS MARKED. FOR DETAIL PLS REFER ATTACHED SKETCH. REVEAL & STRAP REPAIRED AT BS 2231 RH FRAME BETWESDR SWIA200211087Door Frame · crackedFRAME 13 RIGHT SIDE CRACKED ON INSIDE AND OUTSIDE OF VERTICAL BRACE, AT COCKPIT DOOR OPENING. REMOVED AND REPLACED INSIDE L-BRACKET AND FABRICATED AND INSTALLED DOUBLER IAW SRM 51-70-05 AND 51-40-02.SDR UPS02438947Longeron · crackedINSPECTION TYPE:C LH BLG W/W - FS 1460 OVERWING LONGERON AFTER SPLICE FTG REMOVAL & CORROSION CLEAN UP, FOUND 3" LONG CRACK AT LONGERON. BS 1460 LH OVERWING LONGERON REPAIRED AS PER HX RS R-53-43-34843. (UPS EO# B747-5310-17206-A) REFER HAECO NRC# 6792 FORSDR UPS02438932Pressure Panel · corrodedINSPECTION TYPE: C, LEFT BLG W/W - CEILING PRESSURE DECK CORRODED AT LBL 55, FS 1350 - 1370. LEFT BLG W/W CEILING PRESSURE DECK WEB REPAIRED AT BS 1335 - 1375 LBL 55 - 80 REFER NRC 7975. CORROSION BLEND OUT 0.060 X 1 X 2 INCH EXCEED SRM LIMIT.SDR UPS02438915Seat Track · corrodedINSPECTION TYPE:C M/D - AFTER FLOOR PANEL REMOVED, BS 1940 RBL 11" SEAT TRACK FOUND HEAVY CORRODED. CORROSION BLEND OUT 0.044" X 1" X 1" EXCEED SRM LIMIT. SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 14.SDR UPS02438893Web · crackedINSPECTION TYPE:C LH BLG W/W - CEILING COR CRACK AT FS 1355, LBL 76. PRESSURE WEB REPAIRED AT BS 1335-1375 LBL 55 - LBL 80 AS PER SRM 53-10-07 FIG 2.SDR SWAA021477Shear Tie · crackedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CRACKED AT BS 360, BETWEEN STR 13L AND 14L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR 2002UALA01126Door Frame · groovedDOOR 1L CUTOUT FORWARD FRAME 8-10 INCHES FROM TOP CORNER, I/B FLANGE HAD DEEP GROOVE WORN INTO IT. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER OVER FRAME.SDR UPS02438948Pressure Panel · corrodedINSPECTION TYPE: C, RT WLG PX DECK AT O/B BS 1340 AREA HEAVY CORROSION FOUND AS MARKED. CORROSION BLEND OUT 0.060 INCH X 1 INCH X 1 INCH EXCEED SRM LIMIT, BS 1315 - 1380 RBL 94 - 128. PRESSURE DECK WEB REPAIRED AS PER SRM 53-10-07 FIG 2. UPS MPI 15830 RAISESDR UPS02438926Pressure Panel · corrodedINSPECTION TYPE: C, RIGHT WLG W/W PRESSURE DECK O/B AFT CORNER ABOVE BRAKE METERING V/V AREA CORRODED AS MARKED. CORROSION BLEND OUT 0.030 X 1 X 2 INCH EXCEED SRM LIMIT. BS 1315 TO 1380 RBL 98 TO RBL 128 PRESSURE DECK WEB REPAIRED AS PER 53-10-07 FIG 2 REFERSDR UPS02438921Pressure Panel · corrodedINSPECTION TYPE: C RT WLG W/W PRESSURE DECK LWR BONDED SKIN CORRODED AT BS 1375 O/B AREA AS MARKED. CORROSION BLEND OUT 0.050 X 1 X 2 INCH EXCEED SRM LIMIT. BS 1315 TO 1380 RBL 94 TO RBL 128 PRESSURE DECK WEB REPAIRED AS PER SRM 53-10-07 FIG 2.SDR 2002UALA01116Crease Beam · corrodedCABIN LEFT HAND CREASE BEAM WEB UPPER SURFACE CORRODED FROM STATION 867 TO STATION 882 AT LBL 68. MAJOR REPAIR ACCOMPLISHED. REPLACED CREASE BEAM WEB.SDR UIE2002F00004Web · crackedDURING ROUTINE INSPECTION AT CURRENT C CHECK, FOUND LOWER BULKHEAD WEB CRACKED 0.60 INCH LONG AT BS 2658, BETWEEN WL 260 AND 265 AND BETWEEN L/S LBL 25 AND LBL 30. CUT WAY CRACKED AREA. PERFORMED DYE CHECK INSPECTION OF CUT-OUT AREA PER SOPM 20-20-20. NO ADSDR ABXA020165Angle · corrodedBOTTOM OF SERVICE DOOR CUTOUT, INNER JAMB ANGLE EXFOLIATED, LONGERON 18 RIGHT. REPLACED JAM ANGLE AND REPAIRED AREA IAW DC-9 SRM 51-30-5 AND 51-10-3.SDR AALA20021052Door Frame · corrodedTUL - FOUND CORROSION ON LOWER DOOR JAMB. INSTALLED DOUBLER REPAIR PER ESO 8055907-02-02. (M)SDR UPS02438997Fitting · crackedINSPECTION TYPE:C L/H BS 1480 B/H AREA, HOLE #9 CRACKS FOUND AT EXTENSION FITTING RUNNING UPPER & FWD, CRACK THROUGH THICKNESS. LH BS 1480 B/H LONGERON EXTENSION FTG HOLE #9 CRACK FREE FINAL SIZE 0.8745" & PLAN B REPAIR BUSHING INSTALL PER SB 53A2390 R1 SDR UPS02438957Pressure Panel · corrodedINSPECTION TYPE: C, LT WLG W/W - FS 1241 CANTED BULKHEAD CORROSION FOUND AT LBL 21 - 23. CORROSION BLEND OUT 0.050 INCH X 1 INCH X 2 INCH EXCEED SRM LIMIT. BS 1241 - 1265 BL 0 TO LBL 45 CANTED BULKHEAD WEB REPAIRED IAW RS R-53-48-34842 (UPS RA ENGINEERING FI
Back to JASC 5310