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 SWAA040176Shear Tie · crackedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE CRACKED AT BS 380 BETWEEN STRINGERS 27L AND 27R. REPAIRED SHEAR TIES PER SRM.SDR CALA0400038Shear Tie · corrodedINSPECTION FOUND SHEAR TIE CORRODED AT STA 927 BETWEEN S27L AND S27R IN AFT CARGO AREA. THE SHEAR TIE WAS REMOVED AND REPLACED IAW SRM 53-00-07, FIGURE 210.SDR C2XA04SH017Buttstrap · corrodedSHV- DURING C-CHECK THE RIGHT HAND BUTTSTRAP BETWEEN FRAMES 59 AND 61 WAS FOUND TO BE CORRODED. MAINTANANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH016Buttstrap · corrodedSHV- DURING C-CHECK THE CENTER BUTTSTRAP WAS FOUND TO HAVE CORROSION BETWEEN FRAMES 59 TO 61. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR 2005UALA00067Window Frame · crackedRT CABIN WINDOW FRAME NR 4 IS CRACKED DUE LIGHTNING STRIKE. INSTALLED NEW WINDOW FRAME.SDR 04FDEA00183Web · crackedUPPER DECK, CARGO DOOR UPPER BOX WEB FINGERS ARE CRACKED AT STA 490 AND 500 STR 2L. REMOVED DAMAGED WEB AND INSTALLED NEW WEB IAW SRM 51-30-2.SDR SWAA040152Door Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND AFT CARGO DOOR CUTOUT FRAME WEB CRACKED AT BS 787 + 6. REPAIRED PER SRM.SDR SWAA040150Crease Beam · corrodedDURING SCHEDULED D CHECK, FOUND CREASE BEAM CORRODED FROM BS 948 TO BS 990, LBL 55, WL 208. REPAIRED CREASE BEAM PER SRM.SDR CALA0400023Shear Tie · crackedINSPECTION FOUND A 1 INCH CRACK IN SHEAR TIE AT BS 560 BETWEEN L22L AND L23L. REPAIRED IAW SRM 53-03, FIGURE 7.SDR 2005UALA00058Door Frame · dentedEXTERNAL POWER RECEPTACLE PANEL DOOR FRAME IS DENTED. FABRICATED & INSTALLED INTERNAL DOUBLER PER EA. INSTALLED SHIMS & FILLERS AS REQUIREDSDR ARWA20040102Door Frame · crackedDURING AN A-CHECK INSPECTION, AFT LOWER CARGO COMPARTMENT AFT DOOR JAMB TOP FORWARD CORNER WITH CRACK STA 1440.000. TRIMMED OUT CRACK & FABRICATED FILLER, DOUBLER AND TRIPLER IAW DC8SRM 53-2-0, TR 53-188 AND SRM 51-1-21, 51-1-20D & 51-1-11.SDR SWAA040134Crease Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CREASE BEAMS CORRODED AT BS 300 TO BS 328 RT AND BS 400 TO BS 420 LT. REPAIRED CREASE BEAMS PER SRM.SDR DHL2004806537Shear Tie · crackedACCESSORY COMPT FORMER ATTACHING FRAME TO FUSELAGE 1.000 CRACK, STA 640.000 L-26R TO L-27R. REMOVED FASTENER IAW SRM 51-1-21 PG 1-2. CUT OUT FORMER DAMAGED AREA AND FABRICATED FORMER REPAIR ANGLE (7075 0.0.071) IAW SRM 53-2-0 PG 11 FIG 2A. HEAT TREATED IAW SDR SWAA040123Crease Beam · corrodedDURING SCHEDULED D CHECK, FOUND CREASE BEAM CORRODED AT BS 380 TO BS 400 LT, WL 208 AND BS 500 TO 500A LT, WL 208. REPAIRED CREASE BEAM PER SRM.SDR SWAA040119Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE CORRODED AT AFT CARGO DOOR FRAME BS 794, RBL 9. REPAIRED FRAME PER SRM.SDR 04FDEA00134Door Frame · corrodedCORROSION 1) NR 1 CARGO DOOR CUTOUT FWD FRAME BETWEEN WEB AND I/B CHORD STA 560 RBL 26 WL 166. CORROSION NR 1 CARGO DOOR CUT OUT FWD FRAME BETWEEN WEB AND I/B CHORD STA 560, RBL 26, WL 166, FOUND TO BE OUT OF LIMITS PER SRM 53-10-1. REPAIRED DAMAGE AREA PERSDR SWAA040116Crease Beam · corrodedDURING SCHEDULED D CHECK, FOUND CREASE BEAM CHORD CORRODED AT BS 363, WL 208, LBL 65. REPAIRED CREASE BEAM PER SRM.SDR SWAA040110Door Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND L2 DOOR FRAME UPPER AND LOWER HINGE CUTOUT CRACKED. REPAIRED L2 DOOR CUTOUT PER EA.SDR SWAA040106Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE CORRODED AT BS 500B, BL 0. REPAIRED SHEAR TIE PER SRM.SDR SWAA040105Shear Tie · crackedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE CRACKED AT BS 500A, RBL 15. REPAIRED SHEAR TIE PER SRM.SDR 04FDEA00090Shear Tie · corrodedCORROSION (C53-113-01(1) FWD CARGO BAY BS 720 SHEAR TIE CORRODED, BETWEEN STR 27R - 28R WL 149 AFT SIDE OF FRAME. REMOVED CORROSION FROM SHEAR TIE AT BS 720 BETWEEN STR 27R AND 28R WL 149 MATERIAL LOSS WAS .010 DEEP X 1 X 1.25 FROM AN ORIGINAL THICKNESS OSDR 04FDEA00089Shear Tie · corrodedCORROSION IN FWD CARGO BAY BS 640 SHEAR TIE CORRODED BETWEEN STR 27R - 26R WL 149 AFT SIDE OF FRAME. REMOVED CORROSION FROM SHEAR TIE AT BS 640 BETWEEN STR 27R AND 26R. MATERIAL LOSS WAS .017 DEEP X 1 X 4 INCHES FROM AN ORIGINAL THICKNESS OF .058 AND IS OUTSDR GTIA040076Door Frame · corrodedFTW - FOUND CORROSION ON JAMB BEAM BETWEEN FS 636-693 AROUND RIVETS AND DRILLED OFF SCREWS. FABRICATED 15 DOUBLER AND 9 SPACER. INSTALLED DOUBLER AND SPACER. (M)SDR UPS04841826Shear Tie · crackedINSPECTION TYPE: C1, UPPER CARGO BETWEEN STA 1000-1020 AT LONG 13L SHEAR TIE IS CRACKED. REMOVED FITTING IAW DC8 SRM 51-1-21 AND 51-1-20D. FABRICATED NEW SHEAR TIE IAW DC8 SRM 53-4-1 FIG 51 AND 51-1-24. HEAT TREAT TO 7075-T6 .080 IAW TPS 1003 REV A. ALODINSDR AWXA200400103Frame · corrodedMCN - MAJOR REPAIR - DURING C-18 CHECK EXFOLIATION CORROSION WAS FOUND ON UPPER AND LOWER SURFACE OF UPPER LEG ON UPPER FRAME AT L-1 DOOR WAY BS 315-340, LBL 59, WL 209. MAINTENANCE REMOVED CORRODED UPPER FRAME AT L-1 DOOR WAY FROM BS 315 TO BS 350, LBL 59, WSDR SWAA040068Crease Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CREASE BEAM CORRODED AT BS 947 TO BS 1000, RBL 62.50. REPAIRED CREASE BEAM PER SRM.SDR SWAA040065Crease Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND LT CREASE BEAM CHORD CORRODED AT BS 340 TO BS 357. REPAIRED CREASE BEAM CHORD PER SRM.SDR UPS04841825Door Frame · crackedINSPECTION TYPE: C1, R2 DOOR UPPER AFT DOOR JAMB CORNER HAS CRACKED INTERNAL DOUBLER AND L1 1R, FOUND BY RADIOGRAPHY. FAB DOUBLERS & FILLERS -19, -21, -23, & -25 IAW DC8 SRM 53-2-0. TRIMMED EXTERIOR SKIN AND INTERNAL DOUBLER IAW DC8 SRM 53-2-0 TR 130. REMOSDR 2004UALA00013Door Frame · damagedAFT PIT AFT DOOR FRAME DAMAGE. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER REPAIR.SDR 2004UALA00012Shear Tie · crackedCABIN SHEAR TIES CRACKED AT STA BS460 S16L, BS480 S16L AND BS500A S15L. MAJOR REPAIR ACCOMPLISHED. REPLACED SHEAR TIES.SDR 2004UALA00011Shear Tie · crackedCABIN SHEAR TIES CRACKED AT STA BS706 S11R BS440 S16R. MAJOR REPAIR ACCOMPLISHED. REPLACED SHEAR TIES.SDR UPS04841699Shear Tie · crackedINSPECTION TYPE: C3, SHEAR TIE CRACKED AT STA 1766 BETWEEN LONGERONS 9R AND 10R. STOP DRILLED CRACK AND INSPECTED PER NDT SPM 06-10-01. FABRICATED AND INSTALLED REPAIR PER DAC DWG 5772706, AND DC8 SRM 53-2-0 FIG 1B.SDR UPS04441772Shear Tie · corrodedINSPECTION TYPE: C, FWD CARGO COMPT BILGE SKIN SHEAR T/E FOUND CORRODED AT THE AREA BETWEEN STR 46 - 47 APPROX RBL 7 FRAME BS 540. SHEAR TIE REPLACED AS PER SRM 51-10-01. THE CORRODED AREA OF THE SHEAR TIE WAS DEPTH 0.050 INCH X LENGTH 3 INCH X WIDTH 2 INCH SDR SWAA040035Crease Beam · corrodedDURING SCHEDULED D CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 776, LBL 68, WL 208. REPAIRED WEB PER SRM.SDR C2XA04SH006Buttstrap · corrodedSHV- DURING C-CHECK THE FWD DIGITAL BUTTSTRAP WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 53-21-10. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH005Buttstrap · corrodedSHV- DURING C-CHECK THE CENTER BUTTSTRAP BETWEEN FRAMES 20 AND 23 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR DHL2004753507Beam · crackedDURING C-CHECK, BS 1183 VERTICAL BEAM RBL 36.9 WL 249 CRACK INDICATION. VERIFIED NDT AT VERTICAL BEAM 1183 MARQUED END OF CRACK IAW NDT MAN PART 6, 51-00-00 FIG 4. STOPDRILL AT END OF CRACK .250 INCH IAW B-727 S/B 53-0192. DRILL NEW PARTS PO 342172 P/N 65C3SDR UPS04841719Shear Tie · crackedINSPECTION TYPE: C3, EXTERIOR FUSELAGE, 4 DENTS IN SKIN OVER BELLFRAMES, AND GOUGES BETWEEN LONG 21L - 24L, FOUND SHEAR TIE CRACKED AT STA 100 BETWEEN LONG 23L AND 24L. CUT OUT DAMAGED SECTION OF SHEAR TIE, FABRICATED AND INSTALLED SHEAR TIE SECTION AND DOUBLSDR USAA030321Door Frame · crackedPIT - FOUND DOOR FRAME SKIN CRACKED .5 INCH LONG, FORWARD SERVICE DOOR FRAME CRACK AT DOOR STOP NR 4. DOUBLER INSTALLED AT DOOR STOP NR 4 PER TR 52-10-11. (M)SDR DHL2003747015Door Frame · crackedMAIN CARGO DOOR FRAME AFT ACT AREA HAS CRACK. REPAIRED IAW AERONAUTICAL SOLUTIONS REPORT 03-011 IR DTD 12/30/03. MATERIAL USED 2024-T3 .090 PO 21582, FASTENERS USED 1103-11 BOLTS, AND HL62-6-9. THIS REPAIR IS A MAJOR REPAIR.SDR C2XA03SH524Beam · corrodedSHV-DURING C-CHECK THE LOWER CARGO DOOR CUT OUT BEAM WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BEAM IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR USAA030320Door Frame · crackedPIT - FOUND DOOR FRAME CRACKED 1 INCH, LOWER AFT FORWARD SERVICE DOOR CORNERS. INSTALLED DOUBLER PER EA 77600. (M)SDR 2003UALA00984Torque Box · crackedFWD CARGO PIT AFT TORQUE BOX CRACKED AT CENTER LINE GUIDE STA. 860. INSTALLED WEB SECTION AND ACCOMPLISHED SPLICE REPAIR.SDR 03FDEA02322Shear Tie · corrodedCORROSION AT SHEAR TIE BS 950F LBL 9, COMMON TO STR 29 LT. REMOVED CORROSION FROM SHEAR TIE 1 X2 X.009 INCHES FROM ORIGINAL OF .071. OUT OF LIMITS PER SRM 53-10-1. CUT OF SHEAR TIE AT BS 950F, LBL 9, COMMON TO STR 29 LT. AND REPAIRED FRAME IAW SRM 53-10-4 SDR SWAA032823Beam · crackedDURING SCHEDULED D CHECK, FOUND LONGITUDINAL BEAM CRECKED AT BS 663, BL 0, WL 208. REPAIRED BEAM PER BFG ER.SDR MALA040104Door Frame · corrodedDURING 4K INSPECTION IN LCQ, FS 225 COCKPIT DOOR LOWER FRAME CORRODED. REMOVED CORRODED SECTION OF DOOR FRAME FABRICATED AND INSTALLED DOUBLER AND FILLER REPAIR IAW MESABA EO S53190. REFER TO NR 1195871 FOR ADDITIONAL INFO. A/C RELEASE DATE 01/06/04.SDR MALA040102Spar · chafedDURING 4K INSPECTION IN LCQ, LT MLG W/W FWD RT SPAR ANGLE AND RIVETS CHAFED. MX REMOVED CHAFED AREA, FABRICATED AND INSTALLED DOUBLER AND FILLER REPAIR IAW MESABA EO S54071. A/C RELEASE DATE 1/6/04. REFER TO NR 1195871 FOR ADDITIONAL INFO.SDR 364031Door Frame · wornWORN NOTCH IN CARGO DOOR FRAME LOWER EDGE MID SPAN, REMOVED DAMAGED AREA AND INSTALLED AN INSERTION REPAIR WITH SPLIT DOUBLER ON UNDERSIDE TO SUPPORT THE RIB IAW SRM SKIN DAMAGE ( NON PRESSURIZED AREA).SDR ABXA040020Shear Tie · crackedSHEAR TIE CRACKED AT FS 947 BETWEEN LONGERON 15 AND 16 RT. REMOVED AND REPLACED SHEARTIE IAW DC-9 SRM.SDR ABXA040019Shear Tie · crackedSHEARTIE CRACKED AT FS 947, BETWEEN LONGERON 15 LT AND 16 LT. REMOVED AND REPLACED SHEAR TIE IAW SRM.
Back to JASC 5310