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 UPS03240122Frame · crackedINSPECTION TYPE:C&SI CRACK FOUND ON BS 930 FRAME R/H W/W REPAIR CARRIED OUT IAW SRM 51-30-02, 51-40-04 FIG 1, 53-10-3 FIG 1, DRAWING 65C15732, 65-16336 AND SRM 51-30-05SDR UPS03440060Fitting · crackedINSPECTION TYPE:C LH BS 1480 B/H NO.24 HOLE CRACK AT OUTER CHORD SPLICE FITTING RUNNING O/B APPROX 5/32". REFER ATTACH SKETCH FOR DETAILS. DEFECTIVE HOLE REWORKED AS PER RS-53-43-34957 ISSUE 'B' AND EO B747-5310-18127-ASDR UPS03440059Fitting · crackedINSPECTION TYPE:C RH BS 1480 B/H NO.17 HOLE CRACK AT OUTER CHORD SPLICE FITTING RUNNING O/B AND I/B APPROX 3/16" AND 0.040" RESPECTIVELY. REFER G ATTACH SKETCH FOR DETAILS. DEFECTIVE HOLE REWORKED AS PER RS 53-43-34957 ISSUE B AND EO B747-5310-18127-A.SDR UPS03440044Fitting · crackedINSPECTION TYPE:N/A LH BS 1480 B/H NO.7 HOLE CRACK AT EXTENSION FTG RUNNING AFT UPWARD DIRECTION APPROX 1/16" LONG. REFER ATT SKETCH FOR DETAILS. HOLE REWORKED AS PER RS-53-43-34957 DUE EXCEEDED SB 747-53A2390 REPAIR LIMIT. (REF EO B747-5310-18127-A FOR DESDR UPS03440043Skin · crackedINSPECTION TYPE:C B/H BS 1480 BULKHEAD NO.11 HOLE CRACK AT FX SKIN RUNNING FWD AND AFT THROUGH THICKNESS. REFER ATTACH SKETCH FOR DETAILS. HOLE REWORKED AS PER RS-53-43-43957 DUE EXCEEDED SB 747-53A2390 REPAIR LIMIT. (REF EO B747-5310-18127-A FOR DETAIL INSDR UPS03440042Fitting · crackedINSPECTION TYPE:C LH BS 1480 B/H NO.24 HOLE AT OUTER CHORD SPLICE FITTING RUNNING O/B APPROX 5/32" REFER ATTACH SKETCH FOR DETAILS. CRACKED FASTENER HOLE REAMED TO 0.530" AND BUSHING INSTALLED AS PER SB 747-53A2390 AND EO 747-5310-10732-H WITHIH PLAN 'A' LSDR UPS03440070Bulkhead · corrodedINSPECTION TYPE:C LH WLG W/W FWD BULKHEAD WEB UPPER AREA BS 1241 LBL 60-100 CORROSION REVEALED. CORROSION REMOVED AND C/OUT REPAIR AS PER RS R57-12-34959. DEPTH 0.038, WIDTH 1", LENGTH 2".SDR UPS03440041Web · corrodedINSPECTION TYPE:C L/H WLG W/W FWD BULKHEAD WEB UPPER AREA BS 1241 LBL 60-100 CORROSION REVEALED. CORROSION REMOVED IAW SRM51-10-01, CORROSION DEPTH 0.038", WIDTH 1", LENGTH 2".SDR SIMA200302105Gusset · corrodedFOUND DUIRNG A IMBV INSPECTION, DIAMOND GUSSET ON RIGHT BEAM AT FRAME 22 CORRODED. REMOVED AND INSTALLED SERVICEABLE DIAMOND GUSSET IAW EMB 145/135 SRM 51-40-02. (M)SDR SIMA200302106Beam · corrodedABI - FOUND DUIRNG AN IMBV INSPECTION, EXTENSION AT CENTER BEAM BETWEEN FRAME 22 AND 23 CORRODED. REMOVED AND INSTALLED SERVICEABLE EXTENSION IAW EMB 135 SRM 51-40-02. (M)SDR SIMA200302104Gusset · corrodedFOUND DURING AN IMBV INSPECTION, CORROSION ON GUSSET AT CENTER BEAM SECTION BETWEEN FRAME 18 AND 22 ABOVE STRINGER 21L. REMOVED AND INSTALLED SERVICEABLE CENTER BEAM GUSSET IAW EMB 135 SRM 51-40-02. (M)SDR OZI2003F00002Sill · corrodedBAGGAGE COMPARTMENT DOOR SILL, AT THE FLOORBOARD ATTACH HOLES CORRODED.SDR OZIA200343002Sill · corrodedBAGGAGE COMPARTMENT DOOR SILL, AT THE FLOORBOARD, ATTACH HOLES CORRODED.SDR GTIA021395Door Frame · crackedFTW - FOUND L1 DOOR 2ND FRAME LOWER FRAME AFT RADIUS CRACKED. STOP DRILLED END OF BEAM. (M)SDR GTIA021391Door Frame · crackedFTW - FOUND L-1 DOOR UPPER FRAME CRACKED IN FORWARD AND AFT RADIUS. STOP, DRILLED AFT AND FORWARD SIDE AT L-1 DOOR UPPER FRAME. INSTALLED FITTINGS AND DOUBLER. (M)SDR UPS03840077Angle · corrodedINSPECTION TYPE: C-2, AFT FUSELAGE SECTION STA 1690 PRODUCTION RING IS CORRODED BETWEEN L2 6L-L28L. REMOVED AND REPLACED SPLICES AND RING ANGLE SECTION AT L26R, L26L, L34L, & L28R DUE TO CRACKED AND CORRODED IAW DC8 SRM 53-2-5 FIG 8C-1 SHT 1, 51-1-20D, & DACSDR SIMA200300813Support · corrodedABI - THIS IS A LEVEL 2 FINDING, FOUND DURING A IMBV INSPECTION GALLEY AREA RAMP SUPPORT HAS CORROSION. REMOVED AND INSTALLED SERVICEABLE SUPPORT IAW EMB 135 SRM 51-40-02. (M)SDR QXEA0202291Door Frame · chafedPDX - BAGGAGE DOOR APERTURE FRAME HAS LIGHT CHAFING IN FORMER BLEND AREA AT TOP STATION 588.5. REPAIRED IAW RD 8-53-5461.SDR QXEA0202290Door Frame · chafedPDX - BAGGAGE DOOR APERTURE TOP FRAME HAS LIGHT CHAFING IN PREVIOUS BLEND AREA. REPAIRED IAW RD 8-53-5461.SDR GTIA021389Frame · bulgedFTW - FOUND AFT PRESSURE BULKHEAD VAULT DOOR JAMB LOWER FRAME HAS CORROSION BULGE RBL 9 INCHES AT FLOOR LINE. FORMED NEW REPAIR AT LOWER JAMB. INSTALLED NEW REPAIR, FILLER AND DOUBLER. (M)SDR GTIA021333Shear Tie · crackedFTW - FOUND AFT PRESSURE BULKHEAD FORWARD SIDE FRAME SHEAR TIE BENT AND CRACKED LBL 31 INCHES WL 84 INCHES STRINGER 5L. REMOVED/CUTOUT DAMAGED SHEAR TIE. FABRICATED REPAIR SECTION, COMPLETED REPAIR INSTALLATION. (M)SDR UPS03840076Door Frame · crackedINSPECTION TYPE: C-2, R1 LOWER AFT DOOR JAMB CORNER HAS A CRACK FOUND WITH NDT. REMOVED DAMAGE IAW DC8 SRM 53-2-0. FABBED FILLER, DOUBLER, TRIPLER IAW DC8 SRM 53-2-0. ALODINED AND PRIMED IAW DC8 SRM 51-1-8. INSTALLED IAW DC8 SRM 53-2-0.SDR ASOA02639Window Post · crackedDURING A HANGAR INSPECTION IN TXK, THE FIRST OFFICERS WINDOW POST SKIN WAS FOUND TO BE CRACKED. MAINTENANCE REPAIRED THE CRACKED SKIN IAW ASA EO 120-53-1119A. (M)SDR GTIA021370Door Frame · dentedFTW - FOUND R1 DOOR CUTOUT FRAME DENTED MIDWAY DOWN AFT AREA. REMOVED DOOR JAMB PAN. LOCATED AND DRILLED NEW PANEL. INSTALLED DOOR PAN. (M)SDR GTIA021362Door Frame · crackedFTW - FOUND LEFT MLG FORWARD DOOR JAMB CUTOUT DOUBLER REPAIR CRACKED. REMOVED DAMAGE AREA. FABRICATED CHANNEL. FABRICATED SPLICE TWO EACH. INSTALLED REPAIR PARTS. (M)SDR QXEA0202311Stop Fitting · gougedPDX-GOUGED AND WORN 2 EACH DOOR STOPS FOR CARGO DOOR TOP BRACKETS ATTACHED TO APERTURE. REPAIRED IAW DHC-8 SRM 53-40-00 AND SRM 52-30-00.SDR GTIA021371Door Frame · crackedFTW - FOUND RIGHT WHEEL WELL FORWARD INBOARD DOOR FRAME IS CRACKED. REMOVED DAMAGE. LOCATED AND DRILLED U-CHANNEL AND SPLICES. INSTALLED U-CHANNEL AND SPLICES. (M)SDR GTIA021359Beam · corrodedFTW - FOUND MID PIT CORROSION AT 2 ANGLE FORWARD RIGHT SIDE STATION 636 TO STATION 598. MID PIT LOWER DOOR CUTOUT OUTBOARD BEAM CORRODED STATION 693 TO STATION 636. REMOVED JAMB BEAM. LOCATED AND DRILLED BEAM. INSTALLED MID PIT LOWER DOOR JAMB BEAM. (M)SDR GTIA021353Door Frame · corrodedFTW - AFT CARGO DOOR JAMB LOWER, HAS CORROSION UNDER SET SCREW PLATES AND THROUGH PUT LENGTH OF DOOR JAMB. REMOVED AFT CARGO DOOR JAMB BEAM. LOCATED AND DRILLED NEW JAMB BEAM. INSTALLED JAMB BEAM. (M)SDR MWEA020748Bracket · looseUPON REMOVAL OF PROXIMITY SWITCH BRACKET, FASTENER HOLE PLUG WAS LOOSE/REMOVED. LOCATED AT STATION 42 CEILING AREA. -- INSTALLED FLANGE BUSHING.SDR GTIA021372Door Frame · damagedFTW - FOUND L1 DOOR AFT LOWER INSIDE LIGHTING HOLE HAS 1 INCH CRACK AND METAL DAMAGE. REMOVED AFT LOWER WEB. DRILLED/LOCATED NEW WEB. INSTALLED AFT LOWER WEB. (M)SDR GTIA021365Door Frame · crackedFTW - FOUND AFT OVERWING EXIT RIGHT FORWARD INSIDE EDGE OF FRAME IS CRACKED. FABRICATED DOUBLERS REPAIR. INSTALLED DOUBLERS REPAIR ON INNER SKIN AND DOOR PANEL. (M)SDR GTIA021352Door Frame · corrodedFTW - FOUND FORWARD CARGO LOWER DOOR JAMB HAS CORROSION UNDER DOOR STOP SET SCREW PLATES, UNDER SEALANT AND ENTIRE LENGTH OF DOOR AREA. REMOVED LOWER DOOR PAN SECTION. INSTALLED LOWER DOOR PANEL SECTION. (M)SDR AALA20030019Beam · corrodedTUL - FOUND CORROSION ON VERTICAL AND HORIZONTAL LEGS, AREA HAD PREVIOUS DOUBLER INSTALLED. REMOVED AND REPLACED WITH NEW BEAM AND REINSTALLED ATTACHING PARTS IAW AARD 53-10-00-3 AND SRM 51-30-5 SHT 2 AND 51-30-2 FIG PAR 3. (M)SDR SIMA200236303Beam · corrodedABI - DURING A MBV INSPECTION, THE LEFT OMEGA BEAM AT FRAME 20 WAS FOUND TO BE CORRODED BEYOND SRM LIMITS. REMOVED CORROSION BY PERFORMING A CUTOUT OF THE DAMAGED AREA. FABRICATED A DOUBLER FILLER AND TWO SHIMS. REPAIR DONE IAW EMB 145 SRM (145/1142 REV 20) SDR SIMA200236302Beam · corrodedABI - DURING AN IMBV INSPECTION, THE GALLEY CENTER BEAM WAS FOUND TO BE CORRODED BEYOND SRM LIMITS. PERFORMED TWO CUT OT OF DAMAGED AREAS. BOTH CUTOUT AREAS FALL WITHIN THE TOTAL LENGTH OF CUTOUT ALLOWED. FABRICATED A U-SHAPE EXTERNAL DOUBLER. REPAIR DONE SDR MWEA020743Bracket · corrodedCORROSION ON FORWARD ACCESSORY DOOR APPROXIMATELY SWITCH SUPPORT BRACKET AT STATION 42 CEILING AREA. -- FABRICATED AND INSTALLED SUPPORT BRACKET.SDR SWAA022967Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND BEADED PRESS WEB CRACKED .5 INCH LONG, BS 664, LBL 31. REPAIRED WEB PER SRM.SDR AWXA200201256Structure · corrodedDURING C-16 CHECK CORROSION WAS FOUND ON RT INNER STRUCTURE BS 330 TO BS 335. MAINTENANCE BLENDED OUT CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED RT 1 DOOR DRAIN TRAY, AFT SUPPORT ANGLE, FORWARD SUPPORT ANGLE, REINFORCEMENT STRAP, AFT SPLICESDR C2XA02TY181Beam · corrodedDURING A SCHEDULED INSPECTION THE LEFT OMEGA BEAM AT FRAME 20 HAS CORROSION AT CROSS BEAM. MAINTENANCE REPAIRED THE CORRODED AREA, PRIMED AND PAINTED. I/A/W-EMB-145-SRM-53-21-10. THE REPAIR WAS SATISFACTORY AND THE AIRCRAFT WAS RELEASED TO SERVICE.SDR TSAA0253259Window Frame · crackedTRIMMED AREA AND VERIFIED CRACK REMOVED USING HFEC. FABRICATED 3 EACH FILLERS AND A REPAIR DOUBLER FROM 2024-T3 AS SHOWN IN FIGURE 1, MAINTAINING 2D EDGE MARGIN. MAINTAINED A MINIMUM .5 INCH OUTSIDE CORNER RADIUS AND MINIMUM 2.0 INCH INSIDE CORNER RADIUS. FSDR SIMA200300816Beam · corrodedABI - THIS IS A LEVEL 2 FINDING, FOUND DURING A IMBV INSPECTION, LEFT OMEGA BEAM DOUBLER BETWEEN FRAME 65 AND 68 CORRODED. REMOVED AND INSTALLED SERVICEABLE BEAM IAW EMB 135 SRM 51-40-02. (M)SDR ASAA0240248Door Frame · damagedDURING C-CHECK, FOUND FORWARD CARGO BAY FORWARD DOOR FRAME CLOSURE WEB DAMAGED. REPAIRED IAW SRM. (M)SDR C2XA02SH147Beam · gougedDURING C CHECK CENTER OMEGA BEAM WAS FOUND GOUGED AT FRAME 23. MAINTENANCE REMOVED AND REPLACED OMEGA BEAM IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR C2XA02SH143Beam · corrodedDURING C CHECK, CENTER OMEGA BEAM WAS FOUND TO HAVE CORROSION BETWEEN FRAMES 20 AND 22. MAINTENANCE REMOVED DAMAGE SECTION AND REPLACED AFFECTED OMEGA BEAM IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR AALA20021835Door Frame · crackedTUL - FOUND RIGHT FORWARD OVER WING EXIT JAMB CRACKED TOP CENTER. STOP DRILLED CRACKS AND INSTALLED REPAIR DOUBLER PER SRM 53-05-00 FIG 32. (M)SDR AALA20021834Door Frame · crackedTUL - FOUND RIGHT AFT OVER WING EXIT JAMB CRACKED AT TOP CENTER, FS 916. STOP DRILLED CRACKS AND INSTALLED REPAIR DOUBLER PER 53-05-00 FIG 32. (M)SDR AALA20021833Door Frame · crackedTUL - TWO CRACKS IN LEFT AFT EMERGENCY EXIT DOOR CUTOUT FRAME AT TOP, FS 916. INSTALLED REPAIR PER SRM 53-05-00 FIG 32. (M)SDR AALA20021832Door Frame · crackedTUL - TWO CRACKS IN LEFT FORWARD EMERGENCY EXIT DOOR CUTOUT FRAME AT TOP. INSTALLED REPAIR PER SRM 53-05-00 FIG 32. (M)SDR AALA20021856Window Frame · crackedTUL - FOUND WINDOW ATTACH FRAME CRACKED AT RIVET LEFT SIDE STATION 1022 UPPER LEFT CORNER. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25. (M)
Back to JASC 5310