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 ASAA0480537Door Frame · corrodedOKC - C-CHECK, AFT CARGO DOOR JAMB LOWER WEB IS CORRODED AT STA 1212 TO STA 1231. REMOVED DAMAGED SECTION OF WEB, ORDERED AND INSTALLED NEW WEB, FABRICATED AND INSTALLED REPAIR DOUBLER IAW SRM 51-70-04 AND 51-30-5.SDR USAA040759Crease Beam · corrodedCLT, C-4, CREASE BEAM, .5 INCH AREA, LEVEL 2 CORROSION , STA 324, RBL 62. REPLACED WITH IDENTICAL PART IAW SRM.SDR QXEA200400729Beam · crackedPDX - NUT PLATE CHANNEL CRACKED AT BOTH LEFT HAND AND RIGHT HAND SIDE ON BEAM 280. REPAIRED IAW SRM 51-40-11, 51-21-00, 51-25-01.SDR SWAA043040Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND 2 EACH SHEAR TIES AT BS 500, RBL 12 AND LBL 19, CORRODED. REPAIRED SHEAR TIES PER SRM.SDR SWAA043038Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB AT BS 500 + 15, LBL 65, CORRODED. REMOVED AND REPLACED CREASE BEAM WEB SECTION PER SRM.SDR 04FDEA02953Yoke · damagedMAIN CARGO DECK STA 535 LT 9G NET YOKE ASSY HAS DAMAGE, TRANSVERSE FRAME. MAIN CARGO DECK STA 535 LT 9G NET YOKE ASSY ATTACHED TRANSVERSE FRAME, FLANGE DAMAGED AREAS AT 02 LOCATIONS, TRIMMED AND REPAIR CARRIED OUT AS PER DWG SRZ-53-503.SDR 04FDEA02948Shear Tie · corrodedCORROSION ON SHEAR TIE BS 950F BETWEEN STRS 29R AND 28R. REPAIRED SHEAR TIE BS 950F BETWEEN STRS 29R AND 28R PER SRM 53-10-4 FIG 15.SDR SWAA043026Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB FROM BS 747 TO BS 867, LBL 65, CORRODED. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR ASA0440186Shear Tie · corrodedPAE - CORROSION AFT CARGO BAY ON SHEAR TIE. REMOVED CORRODED SHEAR-TIE, FABRICATED REPAIR PARTS AND INSTALLED.SDR ASA0440185Shear Tie · corrodedPAE - CORROSION AFT CARGO BAY ON SHEAR TIE. REMOVED CORRODED SHEAR-TIE, FABRICATED REPAIR PARTS AND INSTALLED.SDR ASA0440184Crease Beam · corrodedPAE - CORROSION ON CREASE BEAM WEB AT NUT-PLATE HOLES. REMOVED FABRICATED AND INSTALLED NEW WEB.SDR ASA0440183Shear Tie · corrodedPAE - CORROSION AFT CARGO BAY ON FRAME SHEAR TIE. REPAIRED SHEAR TIE.SDR ASA0440182Shear Tie · crackedPAE - CRACK IN FRAME SHEAR TIE. REMOVED AND REPLACED SHEAR TIE.SDR USAA040756Beam · crackedPIT, FPBH, VERTICAL CHORD, .750 INCH LONG, IB RADIUS OF VERTICAL CHORD LBL 5.7, WL 184. REPAIRED VERTICAL BEAM WITH REPAIR KIT IAW EO 5300V155 WITH EA 79303.SDR USAA040741Door Frame · crackedPIT, Q4, EDGE FRAME SERVICE DOOR, .5 INCH CRACK, EDGE FRAME CRACKED, FWD SERVICE DOOR AFT EDGE FRAME, MID STOP AREA. INSTALLED DOUBLER IAW TYPE REP 52-10-11.SDR ASOA04803Support Beam · crackedDURING A C-CHECK, THE LT AND RT SIDE ENGINE SUPPORT BEAMS AT BL36.20 WERE FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE IS REPAIRING THE LT AND RT SIDE ENGINE SUPPORT BEAMS AT BL36.20 IAW EO600-53-0070.SDR USAA040774Beam · crackedPIT, FPBH INSP, VERTICAL CORD-.750 INCH LONG CRACK. IB RADIUS OB VERTICAL CORD LBL 5.7, WL 184. REPAIRED VERTICAL BEAM WITH REPAIR KIT IAW EO 5300V155 WITH EA79303.SDR USAA040753Structure · corrodedCHORD, .750 INCH AREA, CORROSION, STATION 1360 TO 1450 RBL 22. REPLACED CHORD SECTION IAW EA 95871.SDR AWXA200401168Shear Tie · corrodedDURING C-18 CHECK EXFOLIATION CORROSION WAS FOUND ON FORWARD SIDE OF FRAME FOOT AT BS 480, BETWEEN STRINGERS 25 AND 26 LT. MAINTENANCE REMOVED SHEAR TIE, SUPPORT CLIP, AND DAMAGED SECTION OF FRAME AT BS 480, BETWEEN STRINGERS 25 AND 26 LT; FABRICATED A SHEAR TSDR QXEA200400719Beam · corrodedPDX - BEAM FS 280 TOP FLANGE HAS NUMEROUS SPOTS OF CORROSION ON EITHER SIDE OF COCKPIT ENTRANCE. REPAIRED IAW SRM 51-12-00.SDR AWXA200401142Shear Tie · crackedDURING C-18 CHECK, FOUND A 3/8 INCH CRACK IN SHEAR TIE AT BS 348, BETWEEN STR 20 RT AND STR 21 RT. MAINTENANCE REMOVED CRACKED SHEAR TIE AT BS 348, STR 20 - 21 RT; FABRICATED A NEW REPLACEMENT SHEAR TIE PER DWG 65-45812; INSTALLED REPAIR PART IAW B737-300 SRMSDR USAA040852Door Frame · crackedPIT - Q4 - DOOR EDGE FRAME, .5 INCH CRACK, FWD SERVICE DOOR AFT END FRAME AT MIDSTOP FITTING. ROUTED OUT CRACK, INSTALLED DOUBLER IAW TYP REP 52-10-11.SDR QXEA200400720Structure · corrodedPDX - THE COCKPIT BACK WALL AFT SIDE RIGHT HAS NUMEROUS SPOTS OF CORROSION AT FLOOR LEVEL AT BEAM FS 280. REPAIRED IAW HORIZON AIR EA R-53-211 AND REO 670-53-11-051.SDR ASAA0410425Shear Tie · corrodedCORROSION ON SHEAR TIE. REMOVED SHEAR TIE FABRICATED NEW SHEAR TIE AND INSTALLED.SDR USAA040755Window Frame · crackedPIT, C5, WINDOW FRAME, .2500 INCH CRACK, CAPTAINS WINDOW POST BETWEEN NR 1 AND NR 2 WINDOWS TOP, FWD CORNER. INSTALLED DOUBLER IAW SRM, FIG 103.SDR C7WA200400055Shear Tie · crackedSHEAR TIE CRACKED AT FRAME STA 930 BETWEEN STRINGER 13 RT AND STRINGER 14 RT. INSTALLED INTERNAL REPAIR ON SHEAR TIE AT BS 930 BETWEEN STRINGER 13 RT AND 14 RT. DAMAGED SHEAR TIE REMOVED. REPAIR PART FABRICATED FROM 7075-T6, X .063. REPAIR PARTS AND BARE ESDR USAA040731Shear Tie · corrodedSHEAR TIE, 1.5 INCHES SQUARE, CORROSION, STA 1300, STRINGER 27, 28L. FABRICATED NEW SHEAR TIE AND REMOVED LIGHT SURFACE CORROSION FROM ASSOCIATED PARTS IAW SRM 51-10-00.SDR SWIA200413905Window Post · crackedLT PILOTS TO DV WINDSHIELD POST CRACKED LOWER FORWARD CORNER AT FS 3010. (ITEM FOUND AT C-CHECK INSPECTION.) COMPLIED WITH SB 120-53-0072 REV 0 21 FEB 00. REPAIR WORK PERFORMED IAW SRM 51-40-00.SDR ABXA040350Door Frame · crackedCRACKED AT SHEAR PIN RECEPTICLE ON P-DOME, 11:00 POSITION. REPAIRED IAW REA D953-50852MR AND SRD 5934886-510.SDR SWAA042944Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE AT BS 767, RBL 8, CORRODED. REPAIRED SHEAR TIE PER SRM.SDR SWAA042943Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE AT BS 747, LBL 10, CORRODED. REPAIRED SHEAR TIE PER SRM.SDR SWAA042942Door Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND R1 DOOR AFT SIDE FRAME AT THIRD STOP FITTING CRACKED. REPAIRED FRAME SECTION PER SRM.SDR WLDA200495Structure · damagedIMMEDIATELY UPON BRAKE RELEASE DURING TAKEOFF, NOSE RAPIDLY BEGAN TO RISE, RESULTING IN TAIL STRIKE. REPAIRED THE DAMAGE PER DELTA ERA 094364-14 AND 094561-14. PERFORMED AIRCRAFT WEIGHT, ALL CHECKED NORMAL.SDR IXXA0500212SDoubler · corrodedDURING ROUTINE C-CHECK FOUND CENTER FUEL TANK LOWER DOUBLER SKIN BETWEEN FRONT SPAR STATION 683.055 AND STRINGER 65 CORRODED. REMOVED CORROSION, FABRICATED REPAIR PARTS, LOCATED, DRILLED, TREATED, PRIMED, INSTALLED REPAIR PARTS, AND FASTENERS. IAW COOPESA EO SDR USAA040730Shear Tie · corrodedSHEAR TIE, 2 INCH SQUARE, CORROSION, STA 1280 BETWEEN STRINGERS 29R, 28R. FABRICATED AND REPLACED PARTS IAW MFG DRWG 146N2006.SDR SWAA042920Crease Beam · corrodedDURING SCHEDULED D CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 460 TO BS 500+10, RT SIDE. REPAIRED CREASE BEAM WEB PER SRM.SDR 04FDEA02888Structure · corrodedAFT CARGO COMPARTMENT ON RT SIDE MID, FR 54 DOWN TO FR 58, 10 AREAS OF CORROSION NOTED TOP TO UNDERNEATH CLIP NUTS. REMOVED CORROSION AND CHECKED LIMITS IAW A310 SRM 53-10-15. FOUND TO BE WITHIN LIMITS AND REPROTECTED AREAS IAW A310 SRM 53-10-15 AND 51-75-10SDR ASAA0410424Shear Tie · damagedPAE - FOUND 8 EACH, BACC HOLE IN SHEAR TIE. REMOVED AND REPLACED SHEAR TIE IAW SRM.SDR SWIA200413967Beam · crackedFS 409 + 128 RIGHT VERTICAL BEAM AT RBL 27 LOWER INBOARD FLANGE IS CRACKED. ITEM FOUND AT C-CHECK INSPECTION. REPAIRED BEAM IAW CRJ REO 601R-53-41-056 "NC" .SDR SWIA200413966Beam · crackedFS 409 + 128 LEFT VERTICAL BEAM AT LBL 27 LOWER INBOARD FLANGE IS CRACKED. ITEM FOUND AT C-CHECK INSPECTION. REPAIRED BEAM IAW CRJ REO 601R-53-41-056.SDR SWIA200413965Beam · crackedFS 409 + 128 RIGHT VERTICAL BEAM AT RBL 18 LOWER OUTBOARD FLANGE IS CRACKED. ITEM FOUND AT C-CHECK INSPECTION. INSTALL REPAIR PIECES IAW CRJ ERO 601R-53-41-248 REV "NC" AND 601R-53-41-056 REV "NC".SDR MHIA097614Support Bracket · crackedDURING 100 HOUR INSPECTION, A HAIR LINE CRACK WAS NOTED ON THE LEFT HAND SIDE OF THE NR 2 TRDS BEARING SUPPORT (FROM FWD). ON REMOVAL THE CRACK WENT THROUGH THE SUPPORT ARM. CRACK LOCATED 32MM ABOVE THE CENTERLINE OF ATTACHMENT BOLT HOLE. THE SUPPORT IS STASDR SWAA042886Window Post · crackedDURING SCHEDULED D-CHECK, FOUND L1 COCKPIT WINDOW POST UPPER RT CORNER CRACKED. REPAIRED WINDOW POST PER SRM.SDR SWAA042877Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE AT BS 847, STRINGER 25R, CORRODED. REPAIRED SHEAR TIE PER EA.SDR 04FDEA02875Fitting · crackedMOD TYPE H MOD NR C-CHECK REV NO, PS ACCOMPLISH MAINTENANCE C-CHECK NR 004. DURING C-CHECK WHILE ACCOMPLISHING EO 6-5710-7-3322 FOUND CRACK AT FWD FITTING FRAME 47, HOLE NR 41. ITEM WAS REPAIRED ON N00606 PER FEDEX EA 6-5710-77088.SDR UPS04243396Fitting · crackedINSPECTION TYPE:C, TO GAIN ACCESS FOR NDT PLEASE REMOVE FASTENERS BETWEEN STR 23 & 24 BS 740 FITTING RIGHT. REMOVED FASTENERS IAW SRM 51-30-02. HFEC CARRIED OUT ON ABOVE AREA IAW B727 NDTM 51-00-00 PT6 FIG 4, CRACK CONFIRMED, ENDS MARKED. REF UPS EO B727-53SDR AWXA200401127Shear Tie · crackedDURING C-18 CHECK, A 3/8 INCH CRACK WAS FOUND IN SHEAR TIE (CLIP) AT BS 294, STR 11 LT. MAINTENANCE REMOVED CRACKED CLIP AT BS 294, STR 11 LT; FABRICATED A NEW REPLACEMENT CLIP PER DWG 66-14210; INSTALLED REPAIR PART IAW B737-300 SRM 51-40-02, FIG 8 & 12.SDR AWXA200401171Shear Tie · corrodedDURING C-18 CHECK INTERGRANULAR CORROSION WAS FOUND ON SHEAR TIE AT BS 987, BETWEEN STR 26 RT AND STR 27 RT IN THE AFT CARGO COMPARTMENT. MAINTENANCE REMOVED CORRODED SHEAR TIE AT BS 987, BETWEEN STR 26 RT AND STR 27 RT; FABRICATED A NEW REPLACEMENT SHEAR TIESDR LR7A04107Beam · crackedDURING SCHEDULED C6 INSPECTION PER JOB CARD HC5323 FOUND LT MLG FS 497 UPPER BOW BEAM CRACKED AT WL 200, LBL 63. REPAIRED IAW SRM SMP 583 53-40-14.SDR AWXA200401148Shear Tie · corrodedDURING C-18 CHECK EXFOLIATION CORROSION WAS FOUND ON SHEAR TIE AT BS 947, BETWEEN STR 26 AND 27 LT. MAINTENANCE REMOVED CORRODED SHEAR TIE AT BS 947, STR 26 AND 27; FABRICATED A NEW REPLACEMENT SHEAR TIE IAW DWG 65-46560; INSTALLED REPAIR PART IAW SRM 51-40-0
Back to JASC 5310