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 AWXA0001500Door Frame · crackedCABIN R1 DOOR FWD DOOR FRAME FS 303 STR 17R CREASE BEAM FRAME CRACKED. REMOVED AND REINSTALLED R1 DOOR SURROUND PARTS, CASTING AND ANGLE IAW SRM 51-40-02. REMOVED DAMAGE, NDT - NO CRACKS IAW NTM PT 6 51-00-00. FABED REPAIR PARTS AND INSTALLED IAW SRM 51-40-SDR RRXA11043Fitting · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO ALL 6 T-BOLT FITTINGS AT STA 1160-1220 AND L33R, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. RECEIVED PART AND INSTALLED IAW DC-8 SSDR RRXA11044Fitting · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO C-PIT DOOR LWR #6 LATCH BACK UP FITTING AT STA Y=1210, X=24R, Z=-30, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. RECEIVED PART AND SDR AALA20010547Structure · damagedTUL - FOUND 2ND FASTENER HOLE ABOVE CREASE ANGLE STATION 760.95 ELONGATED ESO REQUIRED. REPAIRED HOLE AT STATION 760.95 PER ESO 11697, DATED 3-14-2001. (M)SDR TWAA0104914Beam · corrodedDURING OP 16 MAINT CHECK IN MID CARGO COMPT, THE LOWER DOOR BEAM HAD CORROSION REMOVAL GROUND BELOW 25 PERCENT AT STA 646. REPAIRED BEAM.SDR RRXA11050Latch · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO A-PIT DOOR FRAME LWR NR 1 LATCH AT STA Y=285, X=24R, Z=-30, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. RECEIVED PART AND INSTALLED IAW DC-8 SRM 51-1-20D,SDR RRXA11049Fitting · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO A-PIT DOOR FITTING AT STA Y=350, X=24R, Z=-30, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. RECEIVED PART AND INSTALLED IAW DC-8 SRMSDR RRXA11048Fitting · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO BATHTUB FITTING AT STA 300 AND L33R-L34R, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. RECEIVED PART AND INSTALLED IAW DC-8 SRM 51-1SDR RRXA11034Doubler · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO FINGER DOUBLER AT STA 180-200 AND L31R, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED PART AND INSTALLED IAW DC-8 SRM 53-2-0 1F, 51-1-21, 51-1-20D.SDR 01FDEA00190Shear Tie · corrodedCORROSION (SPEC C53-111-01,3) ON FRAME SHEAR TIE BS AT BS 950D BETWEEN STR 29L AND STR 28L. *S/D* REMOVED AND REPLACED PER FEDEX SRM 53-10-1 FIG 1, 53-10-4 FIG 15.SDR SWAA010770Window Post · crackedDURING SCHEDULED 1/4D CHECK, FOUND WINDOW POST CRACKED AT LT SIDE, BETWEEN CAPT''S NR 1 & NR 2 WINDOWS. REPAIRED WINDOW POST PER SRM.SDR CALA0100225Beam · corrodedINSPECTION FOUND MID CARGO DOOR JAMB BEAM CORRODED. A DOUBLER, SPACER, AND FASTENERS WERE INSTALLED.SDR EIA2001168Door Frame · crackedHKG-HAECO - FOUND MED L2 DOOR FORWARD CUTOUT LOWER REVEAL CRACKED. STOP DRILLED, NDT INSPECTED, REPAIRED REVEAL PER SRM 51-40-03 FIG 1. (M)SDR 20010501AP002Shear Tie · corrodedHKG-HAECO - FOUND FASTENER HOLE CRACK ON MED R5 BS 2231 STRINGER 24R-25R, ONE CRACK ON AFT INNER CHORD AFT ANGLE, ONE CRACK ON INNER CHORD FORWARD ANGLE, AND TWO CRACKS ON DOOR REVEAL. OVERSIZED CRACKED FASTENER HOLE, TRIMMED OFF CRACKED CHORD AND REVEAL, NDTSDR EIA2001180Door Frame · crackedHKG-HAECO - FOUND MED BS 1670 R4 DOOR FORWARD CUTOUT LOWER REVEAL CRACKED. STOP DRILLED, NDT INSPECTED, REPAIRED M/D R4 DOOR FORWARD CUTOUT LOWER REVEAL AT BS 1670 BETWEEN STRINGER 22R TO 25R PER SRM 53-10-04 FIG 84. (M)SDR EIA2001187Shear Tie · crackedHKG-HAECO - FOUND BS 1000 LBL 78 CENTER TANK UPPER SHEAR TIE CRACKED. REPLACED CENTER TANK UPPER SHEAR TIE AT LBL 78 PER SRM 51-10-01. (M)SDR EIA2001194Structure · damagedHKG-HAECO - FOUND BS 2360 B/H MOD, FOUND 2 EXISTING REPAIR DOUBLER INSTALLED ON FORWARD AND AFT SIDE OF B/H APU CUTOUT. REMOVED EXISTING WEB REPAIR PARTS AND REPLACED WITH MODIFIED PARTS. (M)SDR 2001UALA00236Shear Tie · corrodedAFT PIT BS 1285 STRI8NGERS 39L - 39R SHEAR TIE CORRODED. REPLACED SHEAR TIE PER SRM 51-40-02.SDR 2001UALA00235Shear Tie · corrodedAFT PIT BS 1285 STRINGERS 36L - 37L SHEAR TIE CORRODED. REPLACED SHEAR TIE PER SRM 51-40-02.SDR 2001UALA00234Shear Tie · corrodedAFT PIT BS 1307 STRINGERS 37L - 38L SHEAR TIE CORRODED. REPLACED SHEAR TIE PER SRM 51-40-02.SDR 2001UALA00233Shear Tie · corrodedAFT PIT BS 1285 STRINGERS 37L - 38L SHEAR TIE CORRODED. REPLACED SHEAR TIE PER SRM 51-40-02.SDR COMA0110073Support · crackedDURING 2C CHECK TASK 5310-221-05I, THE FUSELAGE LT SKIN SUPPORT BEHIND THE CAPTAIN''S DV WINDOW, BETWEEN FRAMES 12A AND 13, WAS FOUND CRCKED. THE PART WAS REPLACED IN ACCORDANCE WITH EMB-120 SRM STANDARD PRACTICES.SDR COMA0110072Support · crackedDURING 2C CHECK TASK 5310-221-05I, THE FUSELAGE LT SKIN SUPPORT BEHIND AND ABOVE THE CAPTAIN''S DV WINDOW, BETWEEN FRAMES 12A AND 13, WAS FOUND CRACKED. THE PART WAS REPLACED IN ACCORDANCE WITH EMB-120 SRM STANDARD PRACTICES.SDR COMA0110061Shear Tie · crackedDURING 2C CHECK TASK 5310-222-05I, THE RT FUSELAGE SKIN SUPPORT AT FRAME 9, WAS FOUND CRACKED. THE PART WAS REPLACED IN ACCORDANCE WITH EMB-120 SRM STANDARD PRACTICES AND AERODESIGN REPORT 660-1, REV IR, 2-16-93.SDR RRXA11023Door Frame · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO RT WW DOOR FRAME AT STA 883, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED PART AND INSTALLED IAW DC-8 SRM 53-2-0 FIG2B, DWG 5616306, DC-8 SRM 53-1-01SDR UPS01435451Shear Tie · corrodedINSPECTION TYPE:C6 FWD CARGO COMPT STA 820 STR 45L AND 46L SHEAR TIE CORRODED. DOME NUT PLATE REPLACED AS PER SRM 51-10-01 P.8.SDR UPS01435396Door Frame · crackedINSPECTION TYPE:C6 M/D - R2 DOOR FWD EDGE MOST UPPER STOP CUTOUT AREA FOUND CRACKED. DOOR CUTOUT EDGE REPAIRED AS PER SRM 52-10-02 FIG 8.SDR RRXA11031Longeron · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO LONGERON AT STA 35-55 AND L26R, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED PART AND INSTALLED IAW DC-8 SRM 51-1-21, 51-SDR CA010402005Door Frame · cracked(CAN) LOWER AFT DOOR POSTS INSPECTED PER SEB 97-1 AND FOUND LT CRACKED. INSTALLED SERVICE KITS SK172-149-1 AND -2 TO CORRECT.SDR UPS01435452Shear Tie · crackedINSPECTION TYPE:C6 M/D - BS 1220, STR 10R - 11R, FRAME ATTACH SHEAR TIE FOUND CRACK. SHEAR TIE ANGLE REPLACED AS PER ARM 51-10-01 P.8 AND 51-30-02.SDR UPS01435394Shear Tie · corrodedINSPECTION TYPE:C6 AFT CARGO COMPT - FRAME SHEAR TIE AFT FACE FOUND CORRODED AT STA 1680, BETWEEN STR 51 LT TO STR 51 RT. AFT CARGO COMPT SHEAR TIE CORROSION REMOVED & REPAIRED PER SRM 53-10-04 FIG 3A. BLEND OUT CORROSION DEPTH 0.030 INCH, WIDTH 1 INCH, LENGSDR QXEA0100301Pressure Panel · dentedYYC-NOSE LANDING GEAR BAY RIGHT HAND SIDEWALL HAS DENTS IN SKIN AT UPPER FORWARD AND AFT ACM ATTACH AREAS. REPAIRED IAW FOKKER SRM 53-02-18, PAGE 29 AND HORIZON AIR EA 4-53-1452.SDR AALA20010419Door Frame · crackedTUL - FOUND FORWARD CARGO DOOR CRACKED AFT FRAME STATION 620 AT SERVICE LIGHT SWITCH CUTOUT. REPAIRED CRACK IN FRAME WEB STATION 620 FORWARD DOOR CUTOUT PER SRM 51-40-2 FIG 1. (M)SDR UPS01435425Door Frame · crackedINSPECTION TYPE:C6 M/D - R3 DR LOWER FWD CORNER REVEAL FOUND CRACKED. CORNER REVEAL REPLACED AS PER SRM 51-10-01.SDR SWAA010725Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND VERTICAL STRAP CRACKED AT BS 1138, ABOVE STR 12R. REMOVED AND REPLACED VERTICAL STAP PER SRM.SDR SWAA010708Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM LOWER WEB SURFACE CORRODED AT NUT PLATE HOLES, BS 464 TO BS 474, RBL 65. REPAIRED CREASE BEAM WEB PER SRM.SDR UPS01435391Door Frame · crackedINSPECTION TYPE:C6 MAIN DECK - L3 DOOR LOWER FWD CORNER REVEAL FOUND CRACKED. CORNER REVEAL REPLACED AS PER SRM 51-10-01.SDR UPS01435389Door Frame · crackedINSPECTION TYPE:C6 CABIN - R4 DOOR AFT LOWER FRAME CORNER CRACKED. DOOR LOWER CORNER REPAIRED AS PER SRM 52-10-02 FIG 10.SDR DHL2001806525Rib · crackedC-CHECK - TAIL CONE LOWER INTERNAL PART RIB CRACKED 2 INCHES AT STA 1910.000. REMOVED RIVETS IAW SRM 51-1-21 PAGE 1. PERFORMED STOP HOLE IAW SRM 53-3-0 FIG 1B. FABRICATED DOUBLER IAW SRM 53-2-0 FIG 1B. TREATED AND PRIMED IAW SRM 51-1-8B. INSTALLED DOUBLERSDR MWEA010290Shear Tie · corrodedSHEAR TIE AT FRAME STATION 703 BETWEEN LONGERONS 29 LEFT - 29 RIGHT IS CORRODED. REMOVED SHEAR TIE FRAME AND CORROSION. DRILLED, LOCATED AND INSTALLED NEW FRAME.SDR SWAA010696Shear Tie · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 178 BULKHEAD SHEAR TIE CRACKED AT FWD FASTENER HOLE, LT SIDE, WL 208. REPAIRED SHEAR TIE ANGLE PER SWA RA.SDR MWEA010282Door Frame · corrodedFORWARD CARGO DOOR JAMB STATION 370 LONGERON 25 RIGHT TO 29 RIGHT, 8 NUT PLATES HAVE CORROSION BETWEEN NUT PLATES AND FRAME. REMOVED CORROSION, INTERCOSTAL AND CLIP. FABRICATED, DRILLED AND INSTALLED ANGLE REPAIR. LOCATED, DRILLED AND INSTALLED INTERCOSTAL.SDR AALA20010423Doubler · corrodedTUL - FOUND DOUBLER CORRODED STATION 294 RIGHT SIDE OF DOGHOUSE UPPER CHORD. REMOVED AND REPLACED DOUBLER (RADIUS FILLER BLOCK) ON UNDER SIDE OF PREVIOUSLY INSTALLED REPAIR ANGLE 7075-T6 .250 .75 INCH WIDE BY 6 INCHES LONG. RE-INSTALLED EXISTING FASTENERS PESDR AALA20010437Shear Tie · dentedTUL - FOUND DENT ACROSS SHEAR TIE STATION 302 BETWEEN 13L AND 18L, ADL NR 5130036. COLD WORKED DENT TO WITHIN LIMITS AND INSTALLED TWO ROW DOUBLER PER SRM 53-04 FIG 38. DYE CHECK SHOWS NO CRACKS PERMANENT REPAIR. (M)SDR UPS01235459Shear Tie · corrodedINSPECTION TYPE:C. DISCOVERED SHEAR TIE AT BS 1148 LBL 10 WL 150 TO BE CORRODED SHEAR TIE FOUND TO BE CORRODED OUT OF LIMITS PER SRM 53-10-1 REMOVED OLD SHEAR TIE AND INSTALLED NEW SHEAR TIE PER SRM 51-30-2 AND 51-10-2SDR QXEA0100300Pressure Panel · misalignedYYC-NOSE LANDING GEAR BAY LEFT HAND SIDEWALL STATION 2650 LOWER CONNECTION ATTACH IS SITTING HIGH ON LOWER AFT CORNER AND HI-LOK HOLES. REPAIRED IAW FOKKER SRM 53-11-00 AND SRM 51-31-01, PAGE 13 & 14.SDR MWEA010266Shear Tie · bentSHEAR TIE BENT AT STATION 351 LONGERON 29-30 RIGHT. REMOVED FRAME REPAIR AND SHEAR TIE, FABRICATED SHEAR TIE, INSTALLED SHEAR TIE AND FRAME REPAIR.SDR MWEA010258Shear Tie · crackedSHEAR TIE CRACKED, STATION 786, BELOW LONGERON 14 RIGHT. REMOVED DAMAGED SHEAR TIE, POSITIONED, DRILLED AND INSTALLED NEW ANGLE AND SHEAR TIE.SDR MWEA010234Shear Tie · tool damageTOOL DAMAGE IN RADIUS OF SHEAR TIE STATION 758, LONGERON 14 RIGHT. FABRICATED AND INSTALLED T-FORMER.SDR MWEA010229Shear Tie · damagedSHEAR TIE AT STATION 256 LONGERON 8 LEFT WAS CUT TO ACCOMADATE LONGERON AND FRAME REPAIRS. REMOVED SHEAR TIE, FABRICATED AND INSTALLED REPAIR SPLICE.
Back to JASC 5310