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 USAA010443Crease Beam · corrodedCLT - FOUND CREASE BEAM WEB CORRODED .5 INCH AREA, STATION 639, STRINGER 17R. REMOVED AND REPLACED WEB, SRM 51-10-2. (M)SDR AWXA0001628Pressure Panel · crackedLEFT MLG W/W PRESSURE WEB CRACKED AT BS 663 APPROX BL 32. REMOVED UPPER ATTACH CHANNEL; TRIMMED OUT DAMAGED PORTION OF WEB; FABBED REPAIR -1 DOUBLER, -2 FILLER AND -3 STIFFENER; TREATED AND PRIMED REPAIR PARTS; INSTALLED REPAIR AND THE UPPER ATTACH CHANNEL IASDR MWEA010639Shear Tie · crackedRIGHT SIDE SHEAR TIE IS CRACKED AT STATION 945 BETWEEN LONGERON 15 - 16. REMOVED AND REPLACED SHEAR TIE.SDR MWEA010638Shear Tie · crackedLEFT SIDE SHEAR TIE IS CRACKED AT STATION 980 ABOVE LONGERON 15 ON FORWARD SIDE. REMOVED AND REPLACED SHEAR TIE.SDR RRXA11094Fitting · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO BATHTUBE FITTING AT STA.940-960 AND L24R. /////CORRECTIVE ACTION///// REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. NO MATERIAL LOSS NOTED AFTER CLEAN UP, FOUND TO BE WITHIN LIMITS IAW DC-8 SRM 53-2-0 FSDR RRXA11093Seat Track · wornDURING A MAINTENANCE VISIT FOUND WORN DAMAGE TO SEAT TRACK AT STA.525 AND BL=0, DAMAGE EXCEEDED LIMITATION 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 53-2-3 FIG8A, 51-3-0SDR RRXA11092Fitting · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO B-PIT DOOR FRAME FWD BANANNA FITTING AT STA.500 AND L33R, DAMAGE EXCEEDED LIMITATION IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED PART AND INSTALLED SDR 2001UALA00555Door Frame · crackedAFT CARGO DOOR INTERNAL FRAME CRACKED. STA 1410 AT HOLE FOR SWITCH. MAJOR REPAIR ACCOMPLISHED.INSTALLED DOUBLER PER SRM.SDR UPS01435677Door Frame · crackedINSPECTION TYPE:C3 M/D - R2 DOOR FWD CUTOUT REVEAL FOUND CRACKED. NR 2 RT DOOR LWR REVEAL AND FRAME INNER CHORD STRAP REPAIRED AS PER SRM 53-10-04 FIG 84.SDR AWXA0001633Pressure Panel · crackedLEFT WHEEL WELL PRESSURE WEB CRACKED AT FS 663 LBL 32. INSTALLED REPAIR CHANNEL IAW AWA ER 03-5716-0110-552.SDR RRXA11122Fitting · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO BATHTUB FITTING AT STA.520 AND L31L-L32L, DAMAGE EXCEEDED LIMITATION 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 53SDR RRXA11121Fitting · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE BATHTUB FITTING AT STA. 520 AND L30L-L29L, DAMAGE EXCEEDED LIMITATION 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 53-2SDR RRXA11120Fitting · corrodedDURING A MAINTENACE VISIT FOUND CORROSION DAMAGE TO BATHTUB FITTING AT STA.520 AND L34L-L33L, DAMAGE EXCEEDED LIMITATION 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 53-SDR RRXA11090Doubler · damagedDURING A MAINTENANCE VISIT FOUND DAMAGE TO MAIN CARGO DOOR CUT OUT AFT FRAME SEAL AT 18 INCHES FROM UPPER END, DAMAGE EXCEEDED LIMITATION IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED PART AND INSTALLED IAW DC-8 SRM 51-1-21, 53-2-0SDR UIEA01045Pressure Panel · crackedDURING INSPECTION OF PRESSURE DECK NUMEROUS AREAS WERE FOUND WITH SPOT CORROSION BETWEEN BS 1460/1480 AT RBL 6, RBL 26.5; LBL 6, LBL 20, LBL 39, LBL 47.5. MOST AREAS BLENDED TO SRM LIMITS, TREATED AND FINISHED PER STANDARD PRACTICES. THE FOLLOWING AREAS WERESDR 2001UALA00558Structure · damagedSTA 400 LBL 50 NUT CLIP HOLE IS ELONGATED. REMOVED DAMAGE AND INSTALLED AN ANGLE REPAIR. MAJOR REPAIR ACCOMPLISHED.SDR CALA0100405Shear Tie · crackedTAIL COMPARTMENT SHEAR TIE CRACKED AT STATION 1418 AND LONGERON 1. REMOVED SHEAR TIE, FABRICATED AND INSTALLED A SPLICE. TREATED AND PRIMED SHEAR TIE AND INSTALLED PER SRM 51-10-4, 53-03 FIG 3, 51-10-3, AND 51-30-5.SDR RRXA11086Fitting · crackedDURING A MAINTENANCE VISIT FOUND CRACK DAMAGE TO END FITTING AT STA.1540 AND L34R, DAMAGE EXCEEDED LIMITATION 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-20D AND DWSDR RRXA11085Fitting · crackedDURING A MAINTENANCE VISIT FOUND CRACKED DAMAGE TO END FITTING AT STA 1530-1540 AND L36, DAMAGE EXCEEDED LIMITATION 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-20D SDR 2001UALA00550Crease Beam · damagedCREASE BEAM DAMAGED INBOARD ANGLE RIGHT SIDE STA 1130-1133. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. REPAIRED DAMAGE SECTION OF CREASE BEAM USING SRM 51-70-12 TYPICAL EXTRUDED SECTION REPAIR.SDR 2001UALA00545Door Frame · crackedFORWARD CARGO DOOR LOWER AFT CORNER FRAME CRACKED. REPLACED CRACKED FRAME. MAJOR REPAIR ACCOMPLISHED.SDR RRXA11083Seat Track · wornDURING A MAINTENANCE VISIT FOUND WORN DAMAGE TO SEAT TRACK SCALLOPS AT STA. 1330 AND RBL26, DAMAGE EXCEEDED LIMITATION 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 53-7-3SDR RRXA11080Fitting · crackedDURING A MAINTENANCE VISIT FOUND CRACK DAMAGE TO LONGERON END FITTING AT STA 1530 AND L32L, DAMAGE EXCEEDED LIMITATION 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-2SDR RRXA11079FittingDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO BATHTUB FITTING AT STA.540 BETWEEN L33L-L34L, DAMAGE EXCEEDED LIMITATION IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED PART AND INSTALLED IAW DC-8 SRMSDR RRXA11078Web · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO WEB AT STA. 1310-1520 AND RBL46, DAMAGE EXCEEDED LIMITATION 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 53-4-1 AND 5SDR RRXA11007Fitting · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO BATHTUB FITTING AT STA 1160 AND L35L TO 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 SDR RRXA11006Fitting · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO FITTING AT A-PIT DOOR FRAME LWR #4 LATCH, 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 53-2SDR RRXA11004Seat Track · wornDURING A MAINTENANCE VISIT FOUND WORN DAMAGE TO SEAT TRACK AT STA 610-1000 AND RBL24, 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 53-21-03, 53-SDR RRXA11002Fitting · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO FITTING AT STA. 960 AND LBL60, 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 53-2-0FIG8, 51-SDR RRXA11001Frame · damagedDURING A MAINTENANCE VISIT FOUND BLEND OUT DAMAGE TO FRAME AT STA 1280 AND L34L, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED REPAIR AND INSTALLED IAW DC-8 SRM 53-2-0 FIG2, 51-1-20D.SDR RRXA10999Fitting · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO FITTING AT STA 940 AND LBL60, 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-1-20D, 53-1-0SDR AALA20010854Shear Tie · corrodedTUL - FOUND CORROSION AT SHEAR TIE BETWEEN STRINGER 28R AND 29R AT STATION 950E PLUS 5 INCHES. REMOVED CORROSION AND INSTALLED SHEAR TIE REPAIR AS PER 53-10-4 OF SRM. (M)SDR MWEA010626Shear Tie · crackedSHEAR TIE CRACKED AT STATION 965, BETWEEN LONGERON 13 AND 14 RIGHT. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR MWEA010625Shear Tie · crackedSHEAR TIE CRACKED AT STATION 980, BELOW LONGERON 14 RIGHT AND ABOVE 16 RIGHT. FABRICATED AND INSTALLED -45 DOUBLER, L-ANGLES, STRAPS, AND RADIUS FILLERS.SDR MWEA010624Shear Tie · crackedREPAIR DOUBLER CRACKED ON SHEAR TIE REPAIR AT STATION 980 AND BELOW LONGERON 14 LEFT. REMOVED AND REPLACED SHEAR TIE. FABRICATED AND INSTALLED LONGERON TO FRAME ATTACHMENT ANGLES, SHEAR TIE SPLICE STRAPS, AND RADIUS FILLERS.SDR MWEA010608Shear Tie · crackedSHEAR TIE CRACKED AT STATION 945 BELOW LONGERON 15 RIGHT. REMOVED DAMAGED SECTION, FABRICATED NEW SECTION AND REPAIR SPLICES. LOCATED, DRILLED, AND INSTALLED REPAIR.SDR ASAA0110220Door Frame · crackedPAE - DURING MAINTENANCE, FOUND FRAME AROUND MAIN CARGO DOOR CUTOUT AT BS 472.4, STRINGER 24R CRACKED. REPAIRED PER EA. (M)SDR RRXA11161Fitting · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO BATHTUB FITTING AT STA.500 AND L32L, DAMAGE EXCEEDED LIMITATION 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 53-2-0 SDR RRXA10996Frame · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO FRAME AT SAT 1120 AND L36, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED REPAIR AND INSTALLED IAW DHSK 602-260. (CORROSIONSDR HEEA072676Structure · delaminatedENGINE BAY STRUCTURE DELAMINATED.SDR 2001UALA00561Shear Tie · corrodedBS 1461 STRINGERS 39L TO 39R SHEAR TIE CORRODED. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHEDFABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DRAWING 140T2102.SDR 2001UALA00557Shear Tie · corrodedBS 1175 STRINGERS 39R TO 39L SHEAR TIE CORRODED. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED.FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DRAWING 140T2102 AND SRM 51-40-02.SDR COMA0110120Shear Tie · crackedDURING 2C-CHECK TASK 232-01Z, THE RIGHT FUSELAGE SKIN SUPPORT AT FRAME NR 13A AND STRINGER NR 14R, WAS FOUND TO BE CRACKED. THE SUPPORT WAS REPAIRED PER EMB-120 SRM STANDARD PRACTICES AND AERODESIGN REPORT 3653-2, REV IR, 11/7/00.SDR COMA0110119Shear Tie · crackedDURING 2C-CHECK TASK 221-01Z, THE LEFT FUSELAGE SKIN SUPPORT JUST BEHIND CAPTAIN''S DV WINDOW, BETWEEN FRAMES 12A AND 23, WAS FOUND TO BE CRACKED. THE SUPPORT WAS REPLACED PER EMB-120 SRM STANDARD PRACTICES.SDR COMA0110116Shear Tie · crackedDURING 2C-CHECK TASK 221-01Z, THE FUSLEAGE SKIN SUPPORT ON LEFT SIDE OF COCKPIT AT FRAME NR 9 WAS FOUND TO BE CRACKED. THE SKIN SUPPORT WAS REPLACED PER EMB-120 SRM STANDARD PRACTICES AND AERODESIGN REPORT 660-1, REV IR, 2/16/93.SDR COMA0110115Shear Tie · crackedDURING 2C-CHECK TASK 222-01Z, THE FUSELAGE SKIN SUPPORT ON RIGHT SIDE OF COCKPIT AT FRAME NR 9 WAS FOUND TO BE CRACKED. THE SKIN SUPPORT WAS REPLACED PER EMB-120 SRM STANDARD PRACTICES AND AERODESIGN REPORT 660-1, REV IR, 2/16/93.SDR AWXA0001615Plate · crackedLT CABIN FR 68 O/B SHEAR PLATE CRACKED. FABBED AND INSTALLED SHEAR PLATE IAW DWG 53480020.SDR RRXA11160Fitting · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO BATHTUB FITTING SPLICE ANGLE AT STA.560 AND L33R, DAMAGE EXCEEDED LIMITATION IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED PART AND INSTALLED IAW DC-SDR AALA20010944Window Frame · crackedTUL - FOUND WINDOW FRAME CRACKED AT TOP AFT CORNER. INSTALLED DOUBLER PER AARD 53-10-00-25. (M)SDR DHL2001705534Beam · crackedON C-CHECK, FWD SIDE BS 1183 VERTICAL BEAM LBL 26.83 WL 268 HAS A VISUAL CRACK TOP SIDE OF THE LIGHTENING HOLE (MARKED) REP MPRGAA1A53001 S/B 727-53AO173. AD 85-20-03. REMOVED FASTENERS ON VERTICAL BEAM STA 1183 BULKHEAD BL 2683, REMOVED STIFFENER TEES AT WL 2
Back to JASC 5310