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 SWAA041212Door Frame · crackedDURING SCHEDULED D CHECK, FOUND L2 DOOR FRAME LOWER HINGE CUTOUT CRACKED. REPAIRED L2 DOOR CUTOUT PER ER.SDR AUS20040301Door Frame · corroded(AUS) SERVICE DOOR FRAME CONTAINED LEVEL 3 CORROSION LOCATED AT THE BOTTOM FORWARD CORNER.SDR SWAA041202Shear Tie · crackedDURING SCHEDULED SERVICE CHECK, FOUND SHEAR TIE AT BS 520, STRINGER 10R, CRACKED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA041200Shear Tie · crackedDURING SCHEDULED 1/2D CHECK, FOUND SHEAR TIE AT BS 520, STRINGER 11R, CRACKED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR GTIA040490Fitting · crackedMID PIT DOOR FORWARD DOOR UPLATCH BRACKET BENT, FITTING CRACKED AND GUIDE WORN. REMOVED FITTING. INSTALLED FITTING.SDR SWAA041195Door Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FRAME AT L1 DOOR CUTOUT, LOWER STOP FITTING CRACKED. REPAIRED FRAME PER EA.SDR SWAA041193Crease Beam · crackedDURING SCHEDULED D CHECK, FOUND CREASE BEAM AT BS 520, LBL 64, CRACKED. REMOVED AND REPLACED CREASE BEAM SECTION PER SRM.SDR USAA040127Beam · corrodedFOUND BEAM CORRODED TWO PLACES 1.5 INCH LONG BY 1 INCH WIDE BY .02 INCH DEEP, FRAME Y1292 AND CROSSBEAM C66-Z240. REMOVED AND REPLACED BEAM PER SRM 51-74-00, 53-00-14, 51-42-11. (M)SDR USAA040199Vertical Support · crackedSUPPORT (1.5 INCH CRACKED) CRACKED. VERTICAL SUPPORT AT LBL 5.7.SDR ASAA0410217Shear Tie · corrodedDURING C-CHECK, FOUND SHEAR TIE AT STATION 986, BETWEEN 17L AND 19L IS CORRODED. REMOVED DAMAGED SHEAR TIE AND INSTALLED REPLACEMENT SHEAR TIE IAW 51-20-1. (M)SDR ASAA0410215Crease Beam · corrodedDURING C-CHECK, FOUND CREASE BEAM AT STATION 980-1016, LBL 45 IS CORRODED. REMOVED CREASE BEAM AND INSTALLED NEW IAW SRM 51-30-2. (M)SDR ASAA0410214Crease Beam · corrodedDURING C-CHECK, FOUND CREASE BEAM DOUBLER AT STATION 1004-1012, RBL 45-46 IS CORRODED. REMOVED DOUBLER AND INSTALLED NEW IAW SRM 51-30-2. (M)SDR ABXA040167Door Frame · crackedAFT PRESSURE BULKHEAD DOOR JAMB LEFT UPPER STOP FITTING CRACKED ON HORIZONTAL LEG. REPLACED FITTING IAW DC-9 SRM 51-30-2.SDR SWAA041185Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE AT BS 1006, LBL 6, CORRODED. REPAIRED SHEAR TIE PER SRM.SDR SWAA041166Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE AT BS 907, BL 0, CORRODED. REPAIRED SHEAR TIE PER SRM.SDR SWAA041163Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND AFT CARGO COMPARTMENT SHEAR TIE AT BS 787, RBL 9, CORRODED. REPAIRED SHEAR TIE PER SRM.SDR SWAA041169Crease Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CREASE BEAM AT BS 294.5, RBL 45, CORRODED. REPAIRED CREASE BEAM PER SRM.SDR SWAA041154Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE AT BS 500D, LBL 17, CORRODED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR USAA040153Beam · corrodedFOUND BEAM CORRODED 1 INCH BY 1 INCH BY .023 INCHE DEEP, FRAME 66, -Y1292, -Z240. REMOVED AND REPLACED BEAM PE SRM 53-41-15, 51-74-00, 51-42-11. (M)SDR USAA040154Plate · corrodedBFM - FOUND PLATE ASSEMBLY CORRODED 1 INCH BY 1.4 INCH BY .025 INCH, FRAME 69, -Y1732, -Z240. REMOVED AND REPLACED PLATE ASSEMBLY PER SRM 53-02-00, 51-77-10, 51-11-00, 51-72-11. CORROSION LEVEL 2, TASK NR JA-260-53500.(M)SDR USAA040149Beam · corrodedBFM - FOUND BEAM CORRODED 1 INCH BY .20 INCH BY .27 INCH DEEP AREA, FRAME 67, Y1292, -Z240. REMOVED AND REPLACED BEAM PER SRM 51-74-00, 53-00-15 51-42-11, 53-00-14, 53-41-14. CORROSION LEVEL 2, TASK NR JA-260-53500. (M)SDR USAA040150Beam · corrodedBFM - FOUND BEAM ASSEMBLY CORRODED 1 INCH BY 1.2 INCH BY .035 INCH DEEP AREA, BETWEEN FRAME 64/65, Y1292, -Z240. REMOVED AND REPLACED BEAM PER SRM 51-74-00, 53-00-15, 51-42-11, 53-00-14. (M)SDR USAA040151Beam · corrodedBFM - FOUND BEAM CORRODED 1.2 INCH BY 1 INCH BY .047 INCH DEEP AREA, BETWEEN FRAME 68 AND 69, Y1292,-Z240. REMOVED AND REPLACED BEAM PER SRM 51-74-00, 53-00-15, 51-42-11, 53-00-14. (M)SDR USAA040152Beam · corrodedBFM - FOUND BEAM CORRODED 2 INCHES BY 1.6 INCHES BY .058 INCH DEEP AREA, FRAME 68, -Y1732, -Z240. REMOVED AND REPLACED BEAM PER SRM 51-74-00, 53-00-14, 51-42-11. (M)SDR ABXA040163Door Frame · crackedANGLE CRACKED ON FORWARD SIDE OF LEFT FORWARD OVERWING EXIT DOOR JAMB AT FS 617, LONGERON 15 LT. REPLACED ANGLE IAW DC-9 SRM 51-30-2.SDR SWAA041146Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE AT BS 927, STRINGER 26R, CORRODED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR 04FDEA01059Beam · corrodedCORROSION STA 760 DELTA BEAM LWR ANGLE HAS CORROSION. REMOVED CORROSION, FOUND TO BE OUT OF LIMITS BS 760 DELTA BEAM LWR ANGLE. REMOVED AND INSTALLED NEW BS 760 DELTA BEAM LWR ANGLE IAW SRM 51-30-2, 51-10-6 STEP 7, 51-10-1 FIG 1, 51-30-5.SDR 04FDEA01058Beam · corrodedCORROSION STA 780 DELTA BEAM LWR ANGLE HAS CORROSION. REMOVED CORROSION, FOUND TO BE OUT OF LIMITS BS 780 DELTA BEAM LWR ANGLE. ACCESS LWR WEB. REMOVED, INSTALLED NEW BS 780 DELTA BEAM LWR ANGLE AND INSTALLED LWR WEB SUPPORT BEACON PANEL IAW SRM 51-30-2, 51SDR SWAA041138Door Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND R1 DOOR FWD FRAME CUTOUT AT AFT STOP FITTINGS CRACKED. REPAIRED DOOR CUTOUT FRAME PER SRM.SDR 04FDEA001059Beam · corrodedCORROSION STA 760 DELTA BEAM LWR ANGLE HAS CORROSION. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS BS 760 DELTA BEAM LWR ANGLE. REMOVED AND INSTALLED NEW B S760 DELTA BEAM LWR ANGLE IAW SRM 51-30-2, 51-10-6 STEP 7, 51-10-1 FIG 1, 51-30-5.SDR 04FDEA001058Beam · corrodedCORROSION STA 780 DELTA BEAM LWR ANGLE HAS CORROSION. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS BS 780 DELTA BEAM LWR ANGLE. ACCESS LWR WEB. REMOVED, INSTALLED NEW BS 780 DELTA BEAM LWR ANGLE AND INSTALLED LWR WEB SUPPORT BEACON PANEL IAW SRM 51-30-2, 51SDR ASAA0480315Shear Tie · corrodedOKC - DURING HC CHECK, FOUND SHEAR TIE AT STATOIN 1193, BETWEEN 29R AND 28L IS CORRODED. REMOVED DAMAGE AND INSTALLED RPR DOUBLER PER SRM 51-10-2. (M)SDR USAA040145Beam · corrodedBFM - FOUND BEAM CORRODED 1 INCH BY .65 INCH BY .045 INCH DEEP AREA, FRAME 20, Y765, -Z240. REMOVED AND REPLACED BEAM PER SRM 51-74-00, 53-11-14, 51-23-11. CORROSION LEVEL 2. TASK NR JA-220-53500. (M)SDR MDR04050Support Beam · crackedIN THE COURSE OF A POST FLIGHT INSPECTION, THE FIELD MAINTENANCE CREW DISCOVERED A CRACK IN THE RT MGB SUPPORT BEAM APPROXIMATELY STA 333. SL 199 AND RBL 20. THIS IS ON THE FORWARD TOP SIDE OF THE BEAM. OVERALL CRACK LENGTH APPROXIMATELY 3 INCHES. PROBABLESDR C2XA04SH234Buttstrap · dentedSHV- DURING C-CHECK THE LEFT FLOORBEAM BUTTSTRAP WAS FOUND TO BE DENTED BETWEEN FRAMES 60 AND 61. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR USAA040144Crossbeam · corrodedBFM - FOUND CORSSBEAM CORRODED, 1 INCH BY .7 INCH BY .55 INCH DEEP, FRAME -Y254, CROSSBEAM C68 -Z240. REMOVED AND REPLACED BEAM PER SRM 51-74-00, 53-00-14, 51-42-11. (M)SDR ASAA0410201Shear Tie · corrodedDURING C-CHECK, FOUND SHEAR TIE AND FRAME AT STATION 986, BETWEEN STRINGER 18L AND 19L IS CORRODED. REMOVED DAMAGE AND INSTALLED REPLACEMENT SHEAR TIE AND NEW FRAME SPLICE IAW SRM 51-30-2. (M)SDR SWAA041123Door Frame · crackedDURING SCHEDULED C2 CHECK, FOUND AFT CARGO DOOR, FORWARD DOOR FRAME CRACKED. REMOVED AND REPLACED AFT CARGO DOOR PER MM.SDR CALA0400394Support · corrodedSUPPORT FRAME AT FWD PIT STA 500 IS CORRODED. INSTALLED NEW FRAME IAW SRM 51-40-02.SDR CALA0400391Stop Fitting · crackedR2 DOOR STOP FITTING CRACKED (1 INCH) FORWARD UPPER FITTING SECOND FROM TOP. REMOVED AND REPLACED FITTING PER SRM 51-40-02.SDR USAA040142Beam · corrodedBFM - FOUND BEAM CORRODED 1 INCH BY .75 INCH BY .024 INCH DEEP, FRAME 68, Y765, -Z240. REMOVED AND REPLACED BEAM PER SRM 51-74-00, 53-00-15, 53-00-14. CORRODED LEVEL 2, TASK NR JA-260-53500. (M)SDR USAA040143Crossbeam · corrodedBFM - FOUND CROSSBEAM CORRODED 1.3 INCHES BY 1.9 INCH BY .033 INCH AREA, C68, Y-765, AND -Z240. REMOVED AND REPLACED CROSSBEAM PER SRM 51-74-00, 53-00-15, 53-00-14. (M)SDR ABXA040159Shear Tie · crackedSHEAR TIE CRACKED FS 965 AT LONGERON 16 LEFT. REPLACED SHEAR TIE IAW DC-9 SRM 51-30-2 AND 51-30-5.SDR 04FDEA00966Shear Tie · corrodedCORROSION (C53-111-01, 3) ON SHEAR TIE BS 950E LBL 18 WL 141. CORROSION OUT OF LIMITS. REPAIRED SHEAR TIE BS 950E, LBL 18, WL 141 PER SRM 53-10-4 FIG 15 AND EA 7-5310-55285.SDR SWIA200413333Support · crackedCAPTAIN'S DV WINDOW AFT SUPPORT CRACKED. DISCOVERED DURING C-CHECK INSPECTION. REPLACED SUPPORT BRACKET IAW 120 SRM 51-10-02 PAR 3. P/N: 120-12545-001.SDR SWAA041062Crease Beam · corrodedDURING SCHEDULED D CHECK, FOUND CREASE BEAM WEB AT BS 291.5 TO BS 332, RBL 65, CORRODED. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR 04FDEA00958Trunnion · corrodedCORROSION ON RIGHT TRUNNION UPPER TEE CHORD FWD UNDERSIDE, STA 295 WL 169 RBL 15. CORROSON ON NLG RT TRUNNION UPPER TEE CHORD STA 295, WL 169, RBL 15 FOUND TO BE OUT OF LIMITS. REPLACED CORRODED TEE CHORD AND INSTALLED NEW TEE CHORD PER 727 SRM 53-10-1, 51-30SDR USAA040124Beam · corrodedBFM - FOUND BEAM TRACK ASSEMBLY CORRODED 1.5 INCHES IN DIAMETER BY .03 INCH DEEP AREA, FRAME 1292 AND CROSSBEAM C66 -Z240. REMOVED AND REPLACED TRACK BEAM ASSEMBLY PER SRM 51-74-00, 53-00-14, 51-42-11. (M)SDR USAA040129Crossbeam · corrodedBFM - FOUND BEAM CORRODED 2.5 INCHES LONG BY 1.5 INCHES WIDE BY .03 INCH DEEP AREA, FRAME Y1732 BETWEEN CROSSBEAM C68 AND C69 -Z240. REMOVED AND REPLACED BEAM PER SRM 51-74-00, 53-00-14, 51-42-11. (M0SDR USAA040126Beam · corrodedBFM - FOUND BEAM CORRODED 2 INCHES LONG BY 1.5 INCHES WIDE BY .040 INCHE DEEP AREA, FRAME -Y1292 BETWEEN CROSSBEAM C68 AND C69. REMOVED AND REPLACED BEAM PER SRM 51-74-00, 53-00-14, 51-42-11. CORROSION LEVEL 2, TASK NR JA-260-53500. (M)
Back to JASC 5310