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 SWAA011896Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIP CRACKED AT BS 807, STR 4L. R&R STR CLIP PER SRM.SDR SWAA011895Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIPS CRACKED AT BS 767, STR 4L & STR 4R. R&R STR CLIPS PER SRM.SDR SWAA011894Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIPS CRACKED AT BS 727C, STR 4R, STR 2R, STR 4L & STR 3L. R&R STR CLIPS PER SRM.SDR SWAA011893Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 3R & STR 4R. R&R STR CLIPS PER SRM.SDR SWAA011892Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 3R. R&R STR CLIP PER SRM.SDR DL72E011105Beam · crackedINSPECTION OF THE RT TORQUE BOX OF THE VENTRAL STAIRWAY OPENING PER AD 94-07-08 AND BAC SB 727-53-0129 REVEALED A .5 INCH LONG CRACK IN THE UPPER HORIZONTAL BEAM AT FS 1263. THE DAMAGED PART WAS REMOVED AND A NEW PART INSTALLED PER THE REQUIREMENTS OF THE SB SDR RRXA11401Fitting · crackedDURING A MAINTENANCE VISIT FOUND C-PIT AFT SIDE OF STA 1140 L35L FITTING CRACKED. *** CORRECTIVE ACTION *** REMOVED CRACKED FITTING PER SRM 51-1-20 AND INSTALLED NEW FITTING PER SRM 51-1-20 AT AFT SIDE OF STA 1140 L35LSDR CA010813009Door Frame · cracked(CAN) DOOR FRAME FORWARD 50-430043-867 CRACKED ON LOWER BAYONNET HOLE TO SCREW HOLE AND 1/2" BEYOND. OTHER SCREW HOLE TO BAYONNET HOLE. DOOR FRAME AFT 50-430043-865 CRACKED ON UPPER BAYONNET HOLE TO SCREW HOLE ONE ONLY.SDR RRXA11383Fitting · crackedDURING A MAINTENANCE VISIT FOUND R/H LWR CUSP TO FLOOR BEAM SUPPORT FITTING CRACKED AT STA 1220. *** CORRECTIVE ACTION *** REMOVED AND REPLACED FITTING IAW SRM 51-1-21 AND 51-1-21DSDR COMA0160418Angle · corrodedTHE FWD "J" ANGLE @ F.S. 280 BETWEEN LBL 9.0 AND RBL 9.0 IS CORRODED.REMOVED AND REPLACED "J" ANGLE I/A/W WVAC E.O. #601R-53-2540 REF MAN LOG PAGE 405333. WORK PERFORMED UNDER COMAIR W/O #169657.SDR 2001UALA01265Crease Beam · corrodedCORROSION ON RT CREASE BEAM, INBOARD CHORD, AT BS 324, RBL 60. REMOVED AND REPLACED CREASE BEAM DOUBLER. MAJOR REPAIR ACCOMPLISHED.SDR 2001UALA01264Crease Beam · corrodedCABIN LT CREASE BEAM CORRODED. EXCESSIVE MATERIAL LOSS DURING CORROSION REMOVAL AT BS 757. REMOVED DAMAGE. INSTALLED NEW ANGLE WITH 2 SUPPORT STRAPS. MAJOR REPAIR ACCOMPLISHED.SDR RRXA11386Splice · crackedDURING A MAINTENANCE VISIT FOUND D PIT L36 SPLICE FITTING CRACKED STA 1340. *** CORRECTIVE ACTION *** REMOVED AND REPLACED CRACKED FITTING IAW SRM 51-1-20D AND 51-1-11.SDR RRXA11381Fitting · corrodedDURING A MAINTENANCE VISIT FOUND CORRODED BATH TUB FITTING AT STA 1220 L33R - L34R. *** CORRECTIVE ACTION *** REMOVED AND REPLACED CORRODED BATH TUB FITTING AT STA 1220 L33R - L34R IAW SRM 51-1-20SDR RRXA11380Fitting · crackedDURING A MAINTENANCE VISIT FOUND FITTING CRACKED IN CPIT FWD TORQUE BOX STA 1172 L33R. *** CORRECTIVE ACTION *** REMOVED AND REPLACED PER SRM 51-1-20DSDR RRXA11324Longeron · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO LONGERON AT STA.320 AND L29L, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED PART AND INSTALLED IAW DC-8 SRM 53-2-2 FIG10 ASDR SWAA011877Stringer Clip · crackedDURING SCHEDULED 1/4D CHECK, FOUND STRINGER CLIP CRACKED AT BS 1138, STR 15L. R&R STR CLIP PER SRM.SDR 2001UALA01291Shear Tie · corrodedBULK PIT FRAME AT BS 1417, SHEAR TIE BETWEEN STR 38L AND 39L IS CORRODED.SDR 2001UALA01289Shear Tie · corrodedFWD CARGO PIT, BS 434 BETWEEN STR 32L AND 33L, SHEAR TIE IS CORRODED.SDR 2001UALA01284Shear Tie · corrodedAFT PIT SHEAR TIE CORRODED AT BS 1197 BETWEEN STR 39L AND 39R.SDR 2001UALA01282Shear Tie · corrodedAFT PIT SHEAR TIE CORRODED BS 1153, BL0.SDR 2001UALA01277Shear Tie · corrodedSTA 698, SHEAR TIE CORRODED BETWEEN STR 37L AND 36L. REPLACED SHEAR TIE PER BAC DWG 140T2102 AND INSTALLED PER SRM 51-40-2. MAJOR REPAIR.SDR 2001UALA01263Crease Beam · corrodedCABIN CREASE BEAM CORRODED. HEAVY MATERIAL LOSS DURING CORROSION REMOVAL AT BS 720-BS 760, RBL 60. REMOVED CORROSION. REPLACED CREASE BEAM ANGLE. MAJOR REPAIR ACCOMPLISHED.SDR 01FDEA00511Stiffener · worn01-215 STIFFENER BS 1330, THAT HYDRAULIC LINE CLAMPS TO IS WORN COMPLETELY THROUGH HALF OF ITS SPAN BY HYD LINE. R&R PER B727 STRUCTURAL REPAIR MANUAL 51-40-4.SDR AWXA0002053Skin · crackedD: R2 door fuselage skin upper hinge cut out is cracked BS 947C: repaired R2 door fuselage skin upper hinge cut out IAW B737 SRM 53-30-3 Pg 78 & 78BSDR AWXA0002052Skin · crackedD: L2 Door upper hinge fuselage cut out cracked BS 979C: Repaired R2 Door fuselage skin upper hinge cut out IAW B737 SDRM 53-30-3SDR SWAA011884Splice · crackedDURING SCHEDULED D CHECK, FOUND STRINGER SPLICE'S CRACKED AT BS 908, STR 4L & 4R. R&R STRINGER SPLICE'S PER SRMSDR UPS01236257Frame · crackedINSPECTION TYPE:C CRACK INDICATION AT FRAME, FUSELAGE BS913.5 RIGHT SIDE. CRACK CONFIRMED BY NDT INSP. PART 6 51-00-00 STOP DRILL CRACK AT FRAME AT BS 913.5 B727-51-10-01 INSTALLED KIT REPAIR AS PER EO B727- 5310-1896-B APPENDIX C AT FRAM FUSELAGE BS 913SDR MWEA011006Fitting · crackedFRAME ATTACH FITTING FORWARD SPAR CENTER TANK STATION XCW 40 LEFT IS CRACKED. -- LOCATED AND INSTALLED NEW FITTING.SDR MWEA011005Angle · crackedRIGHT WING TO FUSELAGE FITTING AT STATION 604 LONGERON 22 RIGHT IS CRACKED. -- REMOVED FITTING, LOCATED AND INSTALLED NEW FITTING.SDR RRXA11378Fitting · crackedDURING A MAINTENANCE VISIT FOUND CPIT L31L SPLICE FITTING CRACKED. *** CORRECTIVE ACTION *** REMOVED AND REPLACED FITTING IAW SRM 51-1-20DSDR RRXA11377Frame · crackedDURING A MAINTENANCE VISIT FOUND FRAME STA 55 L24L CRACKED. *** CORRECTIVE ACTION *** REMOVED DAMAGED AREA IAW SRM 53-3-3, FABRICATED AND INSTALLED REPLACEMENT PARTS IAW SRM 53-3-3 FIG 3, 51-1-21 AND 51-1-20D.SDR USAA010808Frame · crackedPIT - FOUND FRAME CRACKED 2 INCHES, CANTED STATION 1485 AT LONGERON 3L. STOP DRILLED CRACK, INSTALLED DOUBLER PER SRM 53-01 FIG 2. (M)SDR MWEA011004Shear Tie · crackedSHEAR TIE CRACKED AT STATION 859 AT LONGERON 18 LEFT. -- CUT AND REMOVED CRACKED SECTION OF FORMER, FABRICATED AND INSTALLED NEW SECTION OF FORMER, REPAIR SPLICE AND ANGLE.SDR UPS01236186Frame · crackedINSPECTION TYPE:C CRACK IN BS 910 FRAME L/H BELOW FLOOR LEVEL REPAIRED IAW DWG 65C27194SDR 01FDEA01120Shear Tie · corrodedCORROSION (C53-113-01(2)) ON SHEAR TIE BS 970, LBL 10, WL 138.5. *S/D* REMOVED AND REPLACED SHEAR TIE PER SRM 53-10-4 FIG 15.SDR 2001UALA01208Shear Tie · corrodedBS 1307 STR 39L-39R SHEAR TIE CORRODED. FABRICATED AND INSTALLED SHEAR TIE REPAIR. THIS WAS A MAJOR REPAIR.SDR AALA20011314Web · crackedTUL - FOUND CRACK, AFT FACE OF FS 1183 PRESSURE BULKHEAD IN TAIL SKID WELL. STOP DRILLED CRACK AND INSTALLED DOUBLER PER SRM 53-10-2. (M)SDR UIEA01071Intercostal · crackedDURING INSPECTION, FOUND MAIN DECK FLOOR LINE INTERCOSTALS FROM STATION 340-380 LEFT CRACKED AT NUMEROUS FASTENER HOLES. TRIMMED OFF SHEAR TIES CONTAINING CRACKED FASTENER HOLES. PERFORMED HFEC INSPECTION AT CUT LINE TO ENSURE NO CRACKS. NO CRACKS FOUND. FSDR UIEA01068Frame · crackedDURING INSPECTION, FOUND FRAME AND DOUBLER STATION 520 CRACKED AT STRINGER 10A (L) AND 11L COMMON TO THE STRINGER CUT-OUT AT 10A(L) AND 11L. FABRICATED DOUBLERS AND INSTALLED PER STANDARD PRACTICES IAW SRM 53-10-04. CLIP REPLACED. REINSPECT AREA PER SB 747-SDR UIEA01067Frame · crackedDURING INSPECTION, FOUND FRAME DOUBLER AND CLIP COMMON TO STATION 500 CRACKED AT STRINGER 10A (L) AND 11L. FABRICATED DOUBLERS AND INSTALLED PER STANDARD PRACTICES IAW SRM 53-10-04. CLIP REPLACED. REINSPECT AREA PER SB 747-53A2265 AT 3000 CYCLE INTERVALS. SDR UIEA01066Frame · crackedDURING INSPECTION, FOUND FRAME WEB DOUBLER STATION 420 CRACKED AT STRINGER 16L COMMON TO THE STRINGER CUT-OUT. CRACK NOT STOP DRILLED DUE TO CRACK PROXIMITY TO EDGE OF THE PART. FABRICATED DOUBLER AND INSTALLED PER STANDARD PRACTICES IAW SRM 53-10-04. REINSSDR UIEA01063Frame · crackedDURING INSPECTION FOUND FRAME STATION 480 CRACKED AT STRINGER 14R COMMON TO THE CUTOUT. STOP DRILLED CRACK. FABRICATED REPAIR DOUBLER AND INSTALLED PER STANDARD PRACTICES IAW SRM 53-10-04. REINSPECTION TO BE ACCOMPLISHED AT 3000 CYCLES AND REPETITIVE AT 300SDR 2001UALA01220Shear Tie · corrodedBS 566 36L-37L SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED SHEAR TIE REPAIR IN ACCORDANCE WITH BAC DWG 143T2102 AND 143T1206 N-R. MAJOR REPAIR.SDR 2001UALA01217Shear Tie · corrodedBS 1307 STR 37L-38L SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED SHEAR TIE REPAIR IN ACCORDANCE WITH BAC DWG 140T2102-490 AND 146T1211 N-R. MAJOR REPAIR.SDR 2001UALA01216Shear Tie · corrodedBS 1263 STR 36L-37L SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED SHEAR TIE REPAIR IN ACCORDANCE WITH BAC DWG 140T2102-557 AND 146T1209 N-R. MAJOR REPAIR.SDR 2001UALA01215Shear Tie · damagedFABRICATED AND INSTALLED SHEAR TIE REPAIR IN ACCORDANCE WITH BAC DWG 140T2102-506 AND 146T1213 N-R. *S/D* FABRICATED AND INSTALLED SHEAR TIE REPAIR IN ACCORDANCE WITH BAC DWG.SDR 2001UALA01214Shear Tie · corrodedBS 347 STR 39R-39L SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DWG 141T1221 N-R. MAJOR REPAIR.SDR 2001UALA01211Shear Tie · damagedFABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DWG 140T2102 AND 143T1205 N-R F6280N. FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DWG 140T2102 AND 143T1205 N-R. MAJOR REPAIR.SDR 2001UALA01210Shear Tie · corrodedBS 676 STR 36L-37L SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED SHEAR TIE REPAIR IN ACCORDANCE WITH BAC DWG 140T2102 AND 143T1211 N-R. MAJOR REPAIR.
Back to JASC 5310