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 MWEA010164Belt · corrodedNR 20 LEFT WINDOW FRAME CORRODED IN BOTH LOWER, INNER CORNERS. REMOVED AND REPLACED WINDOW BELT.SDR F3LA200100023Crease Beam · corrodedDURING C-4 CHECK, INSPECTION REPORTED CORROSION AT AFT ENTRY DOOR THRESHOLD, STA 986. MAINTENANCE REMOVED CREASE BEAM, CLEANED UPPER AND LOWER SURFACE BELOW CREASE BEAM, BURNISHED LIGHT SURFACE CORROSION AND FOUND TO BE WITHIN LIMITS. REMOVED DAMAGED DOUBLERSDR USAA010203Crease Beam · corrodedPIT - FOUND WEB CORRODED 2 INCHES BY 3 INCHES, LEFT SIDE STRINGER 17, CREASE BEAM STATION 747-767. CORROSION LEVEL 2, TASK NR C53-107-01. REPLACED CREASE BEAM WEB PER SRM 51-40-02, 51-40-03 AND DWG 65C26402. (M)SDR SWAA010485Pressure Panel · crackedDURING SCHEDULED 1/2D CHECK, FOUND BEADED PRESSURE WEB CRACKED AT BS 665, LBL 32. REPAIRED BEADED WEB PER TR T1-353-046.SDR AWXA0001342Support Fitting · crackedDOOR STOP FITTING SUPPORT IS CRACKED AT STA 294 STR 12L LT FITTING SUPPORT IS CRACKED 0.5 INCH. SUPPORT WEB REPLACED IAW SRM 51-40-02.SDR USAA010252Shear Tie · crackedCLT - FOUND SHEAR TIE CRACKED .5 INCH, BS 967 AT STRINGER 7L. FABRICATED AND INSTALLED NEW SHEAR TIE PER SRM 53-10-4 FIG 8. (M)SDR 0101221146Doubler · corrodedDURING M-CHECK, FOUND CORROSION ON FORWARD CARGO DOOR JAMB DOUBLER AT BS 910 ABOVE L43R. REPAIRED PER EA 11-180797.SDR 2001UALA00124Shear Tie · corrodedAFT CARGO PIT BS 1197 BETWEEN STR 37L AND 38L SHEAR TIE CORRODED. REPLACED SHEAR TIE BY OSV TIMCO, REFERENCE SRM 51-40-02 FOR FASTENER INSTALLATION PROCEDURES.SDR UPS01235102Web · crackedINSPECTION TYPE:C+SI, CRACK IN AFT CARGO HOLD CLOSURE WEB FWD OF DOOR CUTOUT. WEB REPAIRED IAW SRM 51-40-02 PRIMER APPLIED TO WEB IAW SRM 51-20-15.SDR 2001UALA00186Shear Tie · corrodedAFT PIT SHEAR TIE CORRODED BS 1480. REPLACED SHEAR TIE REF: BAC 140T2102 AND SRM 51-40-02.SDR 2001UALA00183Shear Tie · corrodedAFT PIT SHEAR TIE BETWEEN STR 39L AND 39R CORRODED. INSTALLED NEW SHEAR TIE PER BAC DRAWING 146T1206 AND SRM 51-40-2.SDR USAA010156Crease Beam · crackedCLT - FOUND CREASEBEAM WEB CRACKED 1 INCH, AFT OUTBOARD CORNER AT STATION 638. SPLICED IN NEW SECTION PER SRM 51-10-1 AND 51-40-4. (M)SDR 01FDEA00117Crossbeam · corrodedDURING ROUTINE INSP, UPPER CTR SECTION LWR CARGO COMPT LWR CHORD OF CTR CROSSBEAM BL 0 FROM BS 500 - 640 FOUND CORRODED. *S/D* REPLACED, REMOVED & FAB PER IAW BAC DRW SR 27-53-009, 727 SRM 51-30-2.SDR SWAA010464Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CRACKED AT BS 520, BETWEEN STR 15L & 16L. REPAIRED SHEAR TIE PER SRM.SDR SWAA010462Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CRACKED AT BS 1040, BETWEEN STR 2L & 3L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR UPS01235265Pressure Panel · crackedINSPECTION TYPE:C+SI, CRACK IN LT MLG WHEEL WELL PRESSURE FLOOR AT 930 AFT REINFORCING BEAM AT LBL 54. REPAIRED IAW B727-5310-0460 APPENDIX C.SDR UPS01235242Pressure Panel · crackedINSPECTION TYPE:C+SI, CRACK IN RT MLG WHEEL WELL PRESSURE WEB AT BS 930 FWD REINFORCING BEAM AT RBL 44. CRACK STOP DRILLED IAW SRM 51-10-1 AND EO APPENDIX C, REPAIRED IAW EO B727-5310-0460.SDR UPS01235231Pressure Panel · crackedINSPECTION TYPE:C+SI, CRACK IN LT WHEEL WELL PRESSURE FLOOR AT BS 940 AFT REINFORCING BEAM AT LBL 30. REPAIRED IAW EOB727-5310-0460 APPENDIX C.SDR USAA010152Torque Box · crackedCLT - FOUND TORQUE BOX WEB CRACKED .5 INCH, BS 947 JUST BELOW STRINGER 11L. REMOVED AND REPLACED DOUBLER AND FILLER PER TR 53-30-07 REV A. (M)SDR UPS01235097Beam · crackedINSPECTION TYPE:C+SI, APB 1183 VERT BEAM AT LBL 26.83 HAS A CRACK RUNNING FROM FLANGE LIGHTENING HOLE AT WL 258. REPAIRED PER APPENDIX D OF EO B727-5311-0651 & BOEING DRWG 65C34406.SDR 01FDEA00114Shear Tie · crackedDURING ROUTINE INSP, FUSELAGE SHEAR TIE AT BS 1070, STR 6L FOUND CRACKED. *S/D* REMOVED, REPLACED AND FAB CLIP PER IAW BAC 727 SRM 51-20-1, 51-10-2, 51-30-2.SDR DHL2001707002Fastener · looseDURING A/C RECEIVING INSPECTION FOUND LOOSE BLIND FASTENERS ON EXTERNAL SKIN REPAIR BS 218, STRINGER 25R. REMOVED EXTERNAL SKIN REPAIR AND BLIND FASTENERS. INSTALLED EXTERNAL REPAIR WITH SOLID FASTENERS AT BS 218, STRINGER 25R IAW B727 SRM 53-30-3.SDR TWAA0102806Shear Tie · crackedDURING CHECK-C MAINT FOUND FORMER FOOT CRACKED AT STA 1309, BETWEEN LONGERON 13 AND 14. REPLACED CRACKED FORMER FOOT. SPLICED PER SRM 53-03 FIG 3. INSTALLED PER SRM 51-30-02/05. PRIMED AND TREATED PER SRM 51-10-03.SDR UPS01235207Pressure Panel · crackedINSPECTION TYPE:C-CK, NOSE W/W LT SIDEWALL CRACK INDICATION ALONG ROW OF RIVETS HEADS. CUT OUT DAMAGE AREA AND INSTALLED DOUBLER.SDR UPS01235206Pressure Panel · crackedINSPECTION TYPE:C-CK, NOSE W/W LT SIDEWALL, CRACK INDICATION ALONG VERTICAL ROW OF RIVETS HEADS. CUT OUT DAMAGE AREA AND INSTALLED DOUBLER.SDR ASAA0140023Shear Tie · corrodedPAE - DURING MAINTENANCE INSPECTION FOUND CORROSION ON SHEAR TIE AT STATION 767 WATERLINE 149 AND BUTTLINE 10 RIGHT AND LEFT SIDES. REPAIRED IAW SRM. (M)SDR 01FDEA00108Shear Tie · crackedDURING ROUTINE INSP THE FUSELAGE SHEAR TIE AT BS 1050, STR 5R & 6R FOUND CRACKED. *S/D* REMOVED, REPLACED, FAB, TREATED AND PRIMED PER IAW 727 SRM 51-20-1, 51-10-2, 51-30-2.SDR 01FDEA00105Shear Tie · crackedDURING ROUTINE INSP FUSELAGE SHEAR TIE AT BS 1070, STR 5R FOUND CRACKED. *S/D* REMOVED, REPLACED AND FAB PER IAW BAC 727 SRM 51-20-1, 51-10-2, 51-30-2.SDR 01FDEA00109Shear Tie · crackedDURING ROUTINE INSP FUSELAGE SHEAR TIE AT BS 1030, STR 5R & 6R FOUND CRACKED. *S/D* REMOVED, REPLACED, FAB, TREATED AND PRIMED PER IAW BAC 727 SRM 51-20-1, 51-10-2, 51-30-2.SDR 2570481Structure · crackedCRACK IN LEFT HAND WHEEL WELL TUB EXTENDING BEYOND PREVIOUS STOP DRILL REPAIR.SDR ASAA0110074Shear Tie · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND SHEAR TIE AT BS 907, STRINGER 27L-27R CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110085Door Frame · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND DOOR FRAME ANGLE AT BODY STATION 947-990, LEFT BUTTOCK LINE 51 CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110080Door Frame · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND DOOR FRAME AT BODY STATION 790, STRINGER 20R-26R CORRODED. REPAIRED PER SRM. (M)SDR AALA20010306Shear Tie · crackedTUL - FOUND HORIZONTAL SCRATCH 4 INCHES IN LENGTH 2 FEET AFT OF POSS ENTRY DOOR EVEN WITH BUTTON OF DOOR AND SHEAR TIE CRACKED. DAMAGED AREA CUTOUT AND SHEAR TIE REMOVED DOUBLER AND NEW SHEAR TIE INSTALLED PER SRM 53-04 FIG 12B AND 51-01. (M)SDR AALA20010305Structure · crackedTUL - FOUND CRACKED AT STATION 486 AND 570. REMOVED DAMAGED AT STATION 486 AND 570 AND INSTALLED DOUBLER PER AARD 53-00-00-02 FIG 1. (M)SDR 2001UALA00107Shear Tie · corrodedAFT CARGO PIT AT BS 1307 BETWEEN STRINGERS 36L AND 36R SHEAR TIE IS CORRODED. *S/D* SHEAR TIE WAS REPLACED BY OSV TIMCO, REFERENCE SRM 51-40-02 FOR FASTENER INSTALLATION PROCEDURES.SDR AT0100088Door Frame · gougedFOUND FORWARD GALLEY DOOR JAMB GOUGED BEYOND LIMITS. REMOVED GOUGED SECTION AND INSTALLED REPAIR IAW DC9 SRM 53-05 FIG 55, 51-10-02, 51-10-03, 51-10-04, 51-30-01, 51-30-02, 51-30-05, AND 53-01 FIG 1.SDR SWAA010404Door Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD ENTRY DOOR FRAME UPPER HINGE CUTOUT CRACKED AT FWD CORNER. REPAIRED FRAME PER SWA RA.SDR AT0100103Door Frame · crackedFOUND AFT CARGO DOOR FRAME CRACKED. STOP DRILLED CRACK AND FABRICATED AND INSTALLED DOUBLER IAW DC9 SRM 51-10-02, 51-10-03, 51-10-04, 51-30-02, 51-30-01, AND 52-03.SDR AWXA0001286Shear Tie · crackedAFT CARGO COMPARTMENTS STA 1300 LEFT SIDE BETWEEN STR 20L AND 21L SHEAR TIE ANGLE CRACKED. REMOVED CRACKED ANGLE; FABED ANGLE; INSTALLED ANGLE IAW SRM 51-40-02, 51-30-02, AND 51-30-01.SDR AT0100087Door Frame · corrodedFOUND AFT CARGO DOOR JAMB CORRODED BEYOND LIMITS. INSTALLED NEW DOOR JAMB IAW DC9 SRM 53-05 FIG 44, 51-30-01, 51-30-02, 51-30-04, 51-10-03, 51-30-05, AND RES 01-220.SDR AT0100086Web · crackedFOUND R-1 DOOR JAMB LOWER CORNER SKIN CRACKED. CUT OUT CRACK AND INSTALLED REPAIR IAW EO 09-5310-29-E1472.SDR 01FDEA00091Fitting · crackedDURING ROUTINE INSP, FWD LWR CARGO COMPT DOOR CUTOUT, UPPER FWD DOOR STOP FITTING FOUND CRACKED. *S/D* REMOVED PAINT. HFEC IND NO CRACKS PER IAW BAC 727 NDT MANUAL PART 6. TREATED AND PRIMED PER IAW BAC 727 SRM 51-10-2.SDR SWAA010388Shear Tie · corrodedDURING SCHEDULED 1/2D CHECK, FOUND SHEAR TIE CORRODED AT BS 360. REPAIRED SHEAR TIE PER SRM.SDR TWAA0102802Shear Tie · crackedDURING CHECK-C MAINT FOUND CRACK AT FORMER FOOT (SHEAR TIE) STA 1429, BETWEEN LONGERON 1 AND 2R. REPLACED FORMER FOOR PER DRAWING 9911840-112. INSTALLED PER 51-30-02/05.SDR AWXA0001280Door Frame · crackedAFT CARGO DOOR FRAME CRACKED AT FWD LOWER CORNER. REPLACED FRAME IAW DWG 65C25180.SDR ASAA0110045Shear Tie · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND CENTER SHEAR TIE AT BS 927, STRINGER 27L-27R CORRODED. REPAIRED PER SRM. (M)SDR AALA20010257Beam · corrodedTUL - FOUND STATION 1155-1212 CARGO DOOR CUTOUT LOWER CHORD SUPPORT ANGLE CORRODED MULTIPLE AREA. REMOVED AND REPLACED LOWER DOOR CUTOUT BEAM STATION 1117-1250 PER SRM 51-01. (M)SDR SWAA010381Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIES CORRODED BETWEEN STR 26R & STR 27R, BS 727C, RBL 10, BS 727D, RBL 8 & BS 747 RBL 12. REPAIRED SHEAR TIES PER SRM.SDR SWAA010373Crease Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CREASE BEAM INBOARD CHORD CORRODED AT BS 915 TO BS 1006, RBL 44 TO RBL 60. REPAIRED CREASE BEAM PER SRM.
Back to JASC 5310