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 ASAA0310682Shear Tie · damagedOKC - DURING SCHEDULED D-CHECK, FOUND DAMAGED SHEAR TIE AT FUSELAGE STATION 340, STRINGER 26R-27R. REPLACED SHEAR TIE PER SRM. (M)SDR ABXA040015Shear Tie · crackedSHEAR TIE FS 622 WAS CRACKED, LONGERON 25 LEFT. REPAIRED AREA IAW DC-9 SRM 53-01.SDR SWAA032801Crease Beam · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND CREASE BEAM CORRODED, BS 500 TO BS 500A, LT SIDE. REPAIRED CREASE BEAM PER SRM.SDR SWAA032796Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CORRODED AT BS 500, RBL 10, WL 148.5. REPAIRED SHEAR TIE PER SRM.SDR QXEA200301589Mount · chafedPDX- LOWER INNER TRUSS MOUNT TUBE HAS FIVE CHAFED SPOTS IN A FOUR INCH AREA NEAR THE FUEL FLOW TRANSMITTER. REPAIRED IAW DHC-8 RD 8-54-0361 AND 8-54-1869.SDR F3LA200300182Shear Tie · corrodedDURING C-7 CHECK, INSPECTION REPORTED SHEAR TIE IN FWD CARGO COMPARTMENT CORRODED AT STA 500B, BETWEEN STR 28L AND 28R. REPAIRED PER SRM 53-00-07.SDR F3LA200300181Shear Tie · corrodedDURING C-7 CHECK, INSPECTION REPORTED SHEARTIE IN FWD CARGO COMPARTMENT CORRODED AT STA 500B, BETWEEN STR 27R AND 28R. REPAIRED IAW SRM 53-00-07.SDR TSAA0253257Window Frame · crackedTRIMMED AREA AND VERIFIED CRACK REMOVED USING HFEC. FABRICATED THREE 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 INSIDE CORNER RADIUS. FINISH SDR TSAA0253258Window Frame · crackedTRIMMED AREA AND VERIFIED CRACK REMOVED USING HFEC. FABRICATED THREE 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 INCH INSIDE CORNER RADIUS. FINISDR TSAA0253260Window Frame · crackedTRIMMED AREA AND VERIFIED CRACK REMOVED USING HFEC. FABRICATED THREE 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. FISDR SWAA032769Crease Beam · corrodedDURING SCHEDULED D CHECK, FOUND AFT PAX CABIN CREASE BEAM WEB CORRODED. REPAIRED BEAM PER SRM.SDR SWAA032765Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CORRODED AT BS 847, LBL 17, WL 148. REPAIRED SHEAR TIE PER SRM.SDR 2003UALA00973Shear Tie · crackedSTA 400 STRINGER 16 R HAS CRACKED SHEAR TIE. ALSO STA 420 STR 9L IS CRACKED. MAJOR REPAIR ACCOMPLISHED. REPLACED SHEAR TIES.SDR 2003UALA00972Shear Tie · crackedSTA. 380 SRT 8L AND 9L HAS CRACKED SHEAR TIE. MAJOR REPAIR ACCOMPLISHED. REPLACED SHEAR TIE.SDR 2003UALA00970Shear Tie · crackedSTA 460 STRINGER 14R HAS A CRACKED SHEAR TIE. MAJOR REPAIR ACCOMPLISHED. REPLACED SHEAR TIE.SDR 2003UALA00969Shear Tie · crackedSTA 887 STRINGER 8L HAS A CRACKED SHEAR TIE. MAJOR REPAIR ACCOMPLISHED. REPLACED SHEAR TIE.SDR 03FDEA02205Shear Tie · damagedWHILE WORKING FOUND DAMAGED SHEAR TIE AT BS 720A LBL 12 WL 156. REPAIRED SHEAR TIE AT BS 720A, LBL 12, WL 156 PER SRM 53-10-4 FIG 15 AND FED EX EA 7-5310-55179.SDR ASAA0380827Shear Tie · corrodedOAK - DURING 15K CHECK, FOUND SHEAR TIE CORRODED AT FS 1287. REPLACED SHEAR TIE PER SRM 51-30-2. (M)SDR ASAA0380833Shear Tie · corrodedDURING C-CHECK SHEAR TIE FOUND CORRODED AT FS 1212. REMOVED DAMAGED AREA AND INSTALLED DOUBELR PER SRM'S 51-10-2, 51-10-4, 51-30-2, AND 51-30-5. (M)SDR ASOA03658Rib · crackedDURING A C-CHECK IN MCN, THE LEFT AND RIGHT WHEEL WELL BATT RIB ASSEMBLIES AT WS 53.60 WERE FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE IS REPAIRING THE LEFT AND RIGHT WHEEL WELL BATT RIB ASSEMBLIES AT WS 53.60 IAW ASA EO 600-57-0042. (M)SDR MALA030582Door Frame · crackedDURING C-CHECK INSPECTION IN LCQ, AFT CARGO DOOR TOP FRAME CRACKED ON THE LT & RT SIDE AT GUIDE PIN LOCATION. TIMCO REPLACED AFT CARGO DOOR TOP FRAME REPLACED AT GUIDE PIN LOCATION IAW ARVO SRM 52-32-11-201. REFER 409 NR 1196437 FOR ADDITIONAL INFO. A/C RELSDR MWEA030486Door Frame · corrodedMID CARGO DOOR JAMB HAS CORROSION AROUND SEVERAL FASTENERS FOR THE SCUFF PLATE. FABRICATED AND INSTALLED REPAIR NUT STRIPS.SDR ASOA03647Support Beam · crackedDURING A C-CHECK, THE CENTER ENGINE SUPPORT BEAM UPPER AND LOWER WEB AT BL 0 WAS FOUND CRACKED BEYOND LIMITS. MAINTENANCE IS REPAIRING THE CENTER ENGINE SUPPORT BEAM UPPER AND LOWER WEB AT BL 0 IAW ASA EO 600-53-0072. (M)SDR ABXA030487Fitting · crackedCARGO DOOR BEAM NR 2 AFT END FITTING CRACKED. REPLACED FITTING IAW DC-9 SRM 51-30-5.SDR SWAA032719Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CORRODED AT BS 727, BS 767, BS 787 AND LBL 9, LBL 18, LBL 4 THROUGH RBL 4. REPAIRED SHEAR TIE PER SRM.SDR SWAA032718Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CORRODED AT BS 847 LBL 3. REPAIRED SHEAR TIE PER SRM.SDR SWAA032707Beam · crackedDURING SCHEDULED C3 CHECK, FOUND NOSE WHEEL WELL CEILING BEAM CRACKED. REPAIRED BEAM PER SRM.SDR SWAA032686Shear Tie · crackedDURING SPECIAL VISIT FOUND SHEAR TIES CRACKED AT BS 807 STRINGER 14L, BS 767 STRINGER 14L, BS 360 STRINGER 14L. REPAIRED PER SRM. (M)SDR SWAA032685Window Frame · crackedCYXX - DURING SPECIAL VISIT CRACK INDICATION AT WINDOW 12 BS 530. REMOVED AND REPLACED WINDOW FRAME PER MM. (M)SDR SWAA032684Window Frame · crackedCYXX - DURING SPECIAL VISIT, FOUND CRACK INDICATION AT WINDOWS 28 AND 29, BS 777 AND BS 787. REPAIRED CRACK PER ERO. (M)SDR 03FDEA02154Stringer Clip · crackedBS 720B STR 9 RT STR CLIP IS CRACKED. REMOVED CRACKED STR CLIP AT BS 720B STR 9 RT PER SRM 51-30-2. LOCATED, DRILLED, AND INSTALLED NEW STRINGER PER SRM 51-30-5, 51-30-6 AND 51-30-2.SDR ASAA0340352Door Frame · crackedGYR - DURING SI CHECK, FOUND CRACK AT R1 DOOR FRAME AT STATION 291.5. REPAIRED IAW EA. (M)SDR AWXA200301587Crease Beam · corrodedMAJOR REPAIR - DURING C-18 CHECK CORROSION WAS FOUND ON UPPER AND LOWER SURFACE OF CREASE BEAM (INNER CHORD) BETWEEN BS 952 AND BS 985, LBL 53 AND LBL 56. MAINTENANCE REMOVED AND REPLACED INNER CHORD FROM BS 952 TO BS 985, LBL 53 TO LBL 56 IAW B737-300 SRM 51-SDR SWAA032667Beam · corrodedDURING SCHEDULED D CHECK, FOUND STUB BEAM INBOARD CHORD CORRODED AT BS 616, LBL 65. REPAIRED BEAM PER SRM AND BOEING SB.SDR 03FDEA02055Shear Tie · crackedCRACKED SHEAR TIE AT BS 336 WL 124 LBL 16 INSIDE TORQUE BOX. *S/D* REMOVED AND REPLACED SHEAR TIE AT BS 336, LBL 16, WL 124 PER SRM 51-20-1, 51-30-2, MM 51-20-021-7, 51-20-151-7.SDR AWXA200301575Shear Tie · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK A .5 INCH CRACK WAS FOUND ON L-1 DOOR (INTERIOR) FORWARD INTERCOSTAL CLIP (SHEAR TIE) AT BS 294.5, STR 11 LT. MAINTENANCE REMOVED CRACKED INTERCOSTAL SHEAR TIE AT L-1 DOOR BS 294.5, STR 11 LT; FABRICATED A NEW REPLACEMENSDR 03FDEA02050Frame · damagedWHILE WORKING FOUND UPPER FLANGE OF FRAME BS 1090 LBL 18 WL 150 TO BE TRIPLE HOLED. REMOVED DAMAGE ON UPPER FLANGE OF FRAME BS 1090, LBL 18, WL 150. INSTALLED NEW FABRICATED DOUBLER FOR FRAME AT BS 1090, WL 150, LBL 18 IAW SRM 51-40-3.SDR 03FDEA02047Frame · corrodedCORROSION ON FRAME BS 1148 BETWEEN STR 25-26 LT. BLENDED CORROSION FROM FRMAE BS 1148 BETWEEN STR 25-26 LT. REMOVED .040 FROM ORIGINAL THICKNESS OF .065. FOUND TO BE OUT OF LIMITS PER SRM 53-10-1. CUT OUT DAMAGE MATERIAL 1 X 2.5 INCH. FABRICATED AND INSTSDR SWAA032664Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE CORRODED BETWEEN STR R 26 AND R 27, BS 947. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA032663Shear Tie · crackedDURING SPECIAL VISIT FOUND SHEAR TIE CRACKED BETWEEN STR L 13 AND L 14, BS 787. REPAIRED DAMAGE PER SRM.SDR AWXA200301574Door Frame · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK A .375 INCH CRACK WAS FOUND ON AFT SIDE OF R-1 DOOR FRAME, 3RD STOP CUTOUT FROM THE BOTTOM AT INBOARD SIDE, BS 327, STR 12 RT. MAINTENANCE REMOVED DAMAGE AT AFT SIDE OF R-1 DOOR FRAME, 3RD STOP CUTOUT FROM THE BOTTOM BS SDR DHL2003742533Door Frame · corrodedDURING C-CHECK AT FLIGHTSTAR AIRCRAFT SERVICES IN JACKSONVILLE, FLORIDA DISCREPANCY AS FOLLOWS, N/R 60776 C-2 DOOR CUT OUT AFT FRAME STA 990, INNER CHORD LOWER SURFACE HAS HEAVY CORROSION BETWEEN STR 25R-26R. CORROSION ON AFT FRAME ON C2 DOOR CUT OUT FOUND OUSDR 03FDEA02037Crease Beam · corrodedCREASE BEAM WEB BS 740 TO BS 730F IS CORRODED. REMOVED CORROSION ON CREASE BEAMM WEB BS 740 TO 720F, LBL 65, WL 208. 1X2 INCH. MAXIMUM MATERIAL WAS .020. ORIGINAL THICKNESS .040. OUT OF LIMITS. CUT OUT DAMAGE. FABRICATED FILLER AND DOUBLER LOT 519SDR GTIA031019Shear Tie · corrodedFOUND MID PIT BILGE, SHEAR TIE CORRODED AT STATION 598. CUT OUT SHEAR TIE. FABRICATED NEW SHEAR TIE. SUB CHART FOR 2014-T6 IS 7075-T6. INSTALLED NEW SHEAR TIE. (M)SDR GTIA031020Shear Tie · corrodedFOUND MID PIT BILGE, SHEAR TIE CORRODED AT STATION 579. CUT OUT DAMAGED SHEAR TIE. SUB CHART FOR 2014-T6 IS 7075-T6. FABRICATED NEW SHEAR TIE AND DOUBLERS. INSTALLED SHEAR TIE AND TWO DOUBLERS. (M)SDR DHL2003802572Door Frame · wornWEAR DAMAGE TO THE RIGHT FUSELAGE FWD CTR SECTION LOWER CARGO COMPARTMENT DOOR JAMB AROUND STA 324.000, L-32R (MAJOR REPAIR). REMOVED FASTENERS. TRIMMED OUT THE DAMAGED SKIN. PERFORMED NDT INSPECTION IAW DC8 NDT SPM PART O6,10-01.001. CLEANED, TREATED AND SDR ABXA030470Door Frame · crackedCRACKS EMANATING FROM OPEN HOLE ON LEFT AFT EMERGENCY DOOR JAMB LOWER WEB AT FS 711 BETWEEN LONGERONS 16 AND 17 LEFT. INSTALLED DOUBLER REPAIR IAW DC-9 SRM 51-30-2 AND REPAIRED AREA IAW DC-9 53-01.SDR ABXA030471Shear Tie · crackedSHEAR TIE FS 1056 LONGERON 14 RT CRACKED. REMOVED AND REPLACED SHEAR TIE IAW DC-9 SRM 51-30-2 AND 51-30-5.SDR SWAA032647Shear Tie · crackedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CRACKED AT BS 807 LBL 1 WL 149. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA032646Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND 2 EACH SHEAR TIES CORRODED AT BS 747 AND 827, RBL 1 AND RBL 5, BOTH AT WL 147. REPAIRED SHEAR TIES PER SRM.
Back to JASC 5310