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 COEA2010091432803Crease Beam · corrodedHEAVY CHECK / LEVEL 2 CORROSION RT CREASE BEAM WEB TOP SURFACE HAS AREAS OF CORROSION BETWEEN FRAMES 39 AND 40. CORRODED PARTS REPLACED.SDR COEA2010091426803Crease Beam · corrodedHEAVY CHECK / LEVEL 2 CORROSION / RT CREASE BEAM WEB TOP SURFACE HAS AREAS OF CORROSION BETWEEN FRAMES 39 AND 40"SDR FXGAN151Structure · corrodedFOUND CORROSION BETWEEN FUSELAGE STA 964.75 AND 1010.25 NEAR TAIL HEATER EXHAUST DOUBLER. REPAIRED IAW 8110-3 DATED 9/13/10, 1026.SDR SWAA105548Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 727E TO BS 747, RBL 65. REPAIRED WEB PER SRM.SDR FDEA201009143418Frame · damagedDAMAGE ON FRAME FREE FLANGE AT STA 730 STR 9L. REPAIRED AS PER E.A. F-5310-137671. REPAIR IS CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR DALA1022749868Strut · crackedDURING M-CHECK FOUND CRACK IN FWD CARGO LT SIDE STRUT AT BS 256. REPAIRED IAW SRM 51-70-5.SDR AALA20100913TUL09Window Frame · crackedLEFT WINDOW FRAME BETWEEN STATIONS 1022 AND 1003 AFT TOP CRACKED MARKED. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR DALA1022599208Door Frame · crackedOVERWING EXIT FRAME 962 RT WAS FOUND CRACKED AND R & R IAW EA 02-460094-12AD.SDR FDEA201009133362Door Frame · gougedAPU LT DOOR - DURING REPLACEMENT OF DOOR SKIN, FOUND GOUGE AT DOOR FWD FRAME BS 1886.33. GOUGED FRAME OF APU LT DOOR R & R IAW SRM 51-40-02 REV 100. REPAIR IS CLASSIFIED AS MINOR IAW GMM 6-2-100.SDR FDEA201009123353Crease Beam · corrodedCORROSION ON CREASE BEAM AT STA 900 - 920 LBL 64. CORRODED CREASE BEAM FROM STA 900 TO STA 920, LBL 64, R & R IAW SRM 51-40-02 REV 100. REPAIR IS CLASSIFIED AS MAJOR IAW GMM 6-2-100.SDR KCSA101125Stop Fitting · crackedR-3 MAIN ENTRY DOOR OPENING FORWARD DOOR STOP FITTING CRACKED, BS 1273, WL 233.SDR IXXA10SMN075SDoubler · misrepairedDURING ROUTINE C-CHECK INSP, FOUND IMPROPER REPAIR AT STATION FS 1560, LONGERON 20.5 RT. REMOVED FASTENERS AS NEEDED TO PERFORM REPAIR. REMOVED EXISTING REPAIR DOUBLER. FABRICATED NEW SKIN, INTERNAL AND EXTERNAL DOUBLERS AND FILLER. CLEANED, TREATED, PRIMED SDR DALA1022103102Door Frame · corrodedDURING M-CHECK FOUND CORROSION ON DOOR R1 DOOR FRAME 20 AT CABIN FLOOR LINE. REPAIRED IAW NTM 51-10-08, NTM 51-10-02. INDENTIFIED REPAIR AS ENGINEERING APPROVED TIME LIMITED REPAIR IAW ERA 484247-14 SECTION I. INSP TO BE ACCOMPLISHED EVERY 500 FLIGHT CYCLES SDR 2010FA0000998Structure · corrodedCORROSION ON CROSS SECTION AFT CARGO COMPARTMENT FR 63 LBL 23 TO RBL 23. NO CORROSION REMOVAL LIMITS AVAILABLE IN SRM. SECTION IS LISTED AS PRIMARY STRUCTURE. R & R PROFILE IAW SRM 51-42-11.SDR DALA1022093101Door Frame · corrodedDURING M-CHECK FOUND CORROSION ON DOOR R1 DOOR FRAME 20 AT CABIN FLOOR LINE. REPAIRED IAW NTM 51-10-08, NTM 51-10-02. INDENTIFIED REPAIR AS ENGINEERING APPROVED TIME LIMITED REPAIR IAW ERA 484247-14, SECTION I. INSP TO BE ACCOMPLISHED EVERY 500 FLIGHT CYCLESSDR FDEA201009093331Beam · crackedCRACK INDICATION FOUND ON 1ST LAYER BEAM FROM TOP DURING HFEC OPEN HOLE INSP ON 0.520" HOLE AT MAIN CARGO DOOR NR 3 LOWER JAMB FITTING AT HOLE A. REPAIRED AS PER EA 8-5310-143730. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100 REVISION 111.SDR FDEA201009093330Beam · crackedCRACK INDICATION FOUND ON 2ND LAYER BEAM FROM TOP DURING HFEC OPEN HOLE. INSPECTION ON 0.520" HOLE AT MAIN CARGO DOOR NR 3 LOWER JAMB FITTING AT HOLE A. REPAIRED AS PER EA 8-5310-143730. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100 REVISION 111.SDR USAA2010092092034Door Frame · crackedCLT - Q2 - MAJOR REPAIR - CRACK ON FORWARD SERVICE DOOR FRAME CUTOUT AT BS 312, S7R. REPLACED FORWARD SERVICE DOOR FRAME CUTOUT AT BS 312, S7R IAW B737 SRM 51-10-02.SDR FDEA201009093333Support Fitting · crackedCRACK INDICATION FOUND DURING HFEC OPEN HOLE INSP ON 0.460" HOLES AT MAIN CARGO DOOR LOWER JAMB NR 7 SUPPORT FITTING AT HOLES A, B, C AND D. SUPPORT FITTING REMOVED AND REPLACED AS PER SRM 51-31-01 VOLUME II REVISION 96 AND EXISTING REPAIR DOUBLER AND TRIPSDR SWIA201024946Window Post · crackedCAPTAIN'S WINDOW POST CRACKED. (SERVICE CHECK) REPLACED CAPTAINS WINDOW POST PER SRM.SDR C2XA10SH279Beam · crackedSHV - DURING C-CHECK CARGO DOOR CUTOUT LWR BEAM HAS CORROSION (LEVEL 2 LOCAL) FRM 65-68. MAINTENANCE PERFORMED REPAIR ON CARGO DOOR CUTOUT LWR BEAM FRM 65-68 AND RESTORED TO ORIG FINISH IAW EMB-145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICSDR A6WA201040694Crossbeam · crackedLT PACK CROSSBEAM CRACKED OTBD END BELOW ACM REPLACED NR 1 PACK CROSSBEAM ATTACHING FRAME.SDR UALA2010090803318Structure · corrodedCORROSION AT AFT PIT S42L, JUST AFT OF FRAME 51. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED NEW ANGLE IAW DWG 10D53471007 ON NR C4163K, C4307K BY NR 308152 AND INSPECTED BY LC61.SDR SWAA105315Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM WEB CRACKED BETWEEN BS 559 TO BS 578, STR 17R. REPAIRED WEB PER SRM.SDR SWAA105295Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM WEB CRACKED AT BS 639, RBL 69. REPAIRED WEB PER EA.SDR DALA1021639868Window Frame · crackedDURING M-CHECK FOUND CRACK IN UPPER FWD CORNER OF RT CABIN WINDOW FRAME AT BS 775-794. REPAIRED IAW SRM 51-10-4, SRM 53-01 & SRM 51-30-5.SDR DALA1021629868Window Frame · crackedDURING M-CHECK FOUND CRACK IN UPPER FWD CORNER OF LT CABIN WINDOW FRAME AT BS 794-813. REPAIRED IAW SRM 51-10-4, SRM 53-01 & SRM 51-30-5.SDR DALA1021619868Window Frame · crackedDURING M-CHECK FOUND CRACK IN LOWER AFT CORNER OF RT CABIN WINDOW FRAME AT BS 734-BS 753. REPAIRED IAW SRM 51-10-4, SRM 53-01 & 51-30-5.SDR DALA1021589868Window Frame · crackedDURING M-CHECK, FOUND CRACK IN UPPER FWD CORNER OF LT CABIN WINDOW FRAME AT BS 775-BS 794. REPAIRED IAW SRM 51-10-4, SRM 53-01 & 51-30-5.SDR IPXA10562871Crease Beam · damagedINSPECTION TYPE:C3, MECHANICAL DAMAGE INBD CHORD, OTBD SURFACE BS 629 LBL 65 WL 208. R & R CREASE BEAM INBD CHORD IAW SRM 51-40-02.SDR UHLA2010090600144Door Frame · corrodedLEVEL 2 CORROSION FWD CARGO DOOR CUTOUT FWD LOWER CORNER AT BOLT HEAD. REMOVED AND REPLACED FWD LOWER CARGO DOOR SEAL REST IAW EMB 170 SRM 51-40-02, 51-40-03 AND AMM 53-21-29.SDR UHLA2010090600143Door Frame · corrodedLEVEL 2 CORROSION FWD CARGO DOOR CUTOUT AFT LOWER CORNER AT BOLT HEAD. REMOVED AND REPLACED FWD CARGO DOOR LOWER AFT SEAL REST IAW EMB 170 SRM 51-40-02, 51-40-03 AND AMM 53-21-29.SDR FDEA201009053278Beam · damagedCABIN - L3 MED PLUG NR4 DOOR BEAM SUPPORT BRACKET FOUND DAMAGED. DAMAGED SUPPORT BRACKET AT CABIN L3 MED PLUG NR4 DOOR REMOVED IAW SRM 51-31-01 REV 96, VOLUME II. NEW SUPPORT BRACKET FABRICATED IAW DWG ADA3752, REV E AND INSTALLED IAW EA 8-5210-132476 TITLE :SDR ASOA201001289Buttstrap · corrodedBUTT STRAP AT FS 333, STR 25-27L HAS CORROSION. REMOVED FASTENERS COMMON TO CORRODED AREA. BLENDED DAMAGE FOUND TO BE OUT OF LIMITS IAW SRM 53-00-31, FIG 103. REMOVED REMAINING FASTENERS COMMONG TO CUT SPLICE STEP 23L-STR 23R IAW SRM 51-42-06. DRILLED UP NSDR ASOA201001283Post · crackedFOUND FS 409.0+128, RBL 18.0 INBD SIDE VERT POST HAS INDICATION NOTED APPROX .3" IN LENGTH 60 PERCENT FSH AT WL 69.0 AFT FLANGE RADIUS. FAILED NDT INSP. REMOVED INBD AND OTBD POSTS AT FS 409, RBL 18 IAW SRM 51-42-06. DRILLED SERVICEABLE INBD POST IAW SRM 51SDR IPXA10562902Failsafe · damagedINSPECTION TYPE:C3, DRILL STARTS IN FAILSAFE CHORD BS 345 S8R. REPAIRED IAW ER 10-4596.SDR ASOA201001278Support Beam · crackedFOUND CARGO DOOR SUPPORT BEAM AFT LOWER ANGLE IS CRACKED .3" IN LENGTH. REMOVED CARGO DOOR SUPPORT BEAM CRACKED AFT LOWER ANGLE. LOCATED FASTENER HOLES IN NEW ANGLE AND INSTALLED NEW ANGLE IAW SRM 51-40-11 AND 51-42-21.SDR DALA1024760617Structure · corrodedFWD CARGO CORROSION, COMPT STA 900, S26R CORROSION. REPAIRED IAW ERA 485735-14 ORIG.SDR DALA1021369868Window Frame · crackedDURING M-CHECK FOUND CRACK IN RT CABIN WINDOW FRAME UPPER FWD CORNER AT BS 794 TO BS 813. REPAIRED IAW SRM 51-10-4 & A-56-20-02-201-925A-A.SDR DALA1021359868Window Frame · crackedDURING M-CHECK FOUND CRACK IN RT CABIN WINDOW FRAME UPPER FWD CORNER AT BS 734 TO BS 753. REPAIRED IAW SRM 51-10-4 & A-5—20-02-201-925A-A.SDR COEA2010090207803Crease Beam · corrodedHEAVY CK / LEVEL 2 CORROSION: RT CREASE BEAM WEB TO SURFACE HAS AREAS OF CORROSION BETWEEN FRAMES 39 & 40. AWAITING REPAIR.SDR COEA2010090201803Crease Beam · corrodedWO: 97861 NR: 100030 DISCREPANCY: COE / HEAVY CK / LEVEL 2 CORROSION: RT OUTBOARD CREASE BEAM CHORD ANGLE BETWEEN FRAMES 39 & 40 HAS AREAS OF LEVEL 2 CORROSION. RT OUTBOARD CREASE BEAM CHORD AFT OF FRAME 39 HAS BEEN BLENDED PER SRM 51-21-42/..58. REMAINING TSDR QXEA2010090700521Doubler · chafedC CHECK - DURING INSP FOUND CHAFE MARK AND DAMAGED FASTENER ON DOUBLER FOR CONNECTOR ADJACENT TO AFT POTABLE WATER FILL PORT. REMOVED DAMAGED FASTENER IAW SRM 51-42-06-001-001-A01. BLENDED CHAFE MARK, BLEND IS WITHIN LIMITS IAW SRM 53-00-01-101-001-A01. ETCSDR QXEA2010090700516Structure · corrodedC-CHECK - DURING INSP, FOUND CORROSION ON 4 RIVETS NEXT TO STR 26L AND FRAME 349.00. REMOVED CORRODED RIVETS IAW SRM 51-42-06-001-001-A01. INSTALLED NEW FASTENERS IAW SRM 51-42-06-001-001-A01. TOPCOATED FASTENERS AND APPLIED CORROSION INHIBITING COMPOUND IAWSDR ASOA201001227Post · crackedFOUND FS 409+128, RBL 18.0, OTBD VERTICAL POST HAS INDICATION NOTED APPROX .2" IN LENGTH 60 PERCENT FSH. FAILED NDT INSP (WL 69.0 AFT FLANGE RADIUS). REMOVED VERTICAL POST ON FS 409+128 RBL 18.0 IAW SRM 51-42-06. LOCATED & DRILLED NEW OTBD VERTICAL POST STSDR ASOA201001226Post · crackedFOUND FS 409+128 BL 0.0 RT SIDE VERTICAL POST HAS INDICATION NOTED APPROX .2" IN LENGTH 50 PERCENT FSH. FAILED NDT INSP (WL 69.0 AFT FLANGE RADIUS). REMOVED POST FS 409+128 BL 0 IAW SRM 51-42-06, 51-42-21. LOCATED AND DRILLED UP NEW FS 409+128 BL 0 VERTICALSDR FDEA201009023250Beam · corrodedLONGITUDENAL BEAM Y953 BETWEEN FR 12A AND FR 14 HAS EXFOLIATION CORROSION IN THE MAIN DECK. REMOVED CORROSION IAW SRM 51-74-10, CHECKED, FOUND OUT OF LIMIT. FABRICATED NEW TEE CAP AND REPAIRED IAW SRM 53-12-15 AND DWG 12A536-10797.SDR EE4Y1009368Door Frame · crackedUPPER FUSELAGE PAX CABIN STA Y 441 BETWEEN LONGERON 18 AND 19 LT DOOR FRAME CRACKED.SDR ASOA201001251Post · crackedFS 409+128 VERTICAL BEAM AT LBL 18.0 IS CRACKED ON OTBD BOTTOM CORNER. REMOVED POST ASSY AT FS 409.+128 LBL 18 IAW SRM 51-42-06. R & R OTBD STIFFENER PN 601R32208-155 IAW SRM 51-42-06. C/W EC/TC REO 601R-53-41-889 AND MET ALL THE REQUIREMENTS OF REO 601R-53SDR FDEA201008313208Crease Beam · corrodedCABIN: CORROSION ON CREASE BEAM UPPER AND LOWER SURFACE AT STA 1320-1360, LBL 64. CORRODED CREASE BEAM BETWEEN STA 1320 AND STA 1360, LBL 64, REMOVED AND REPLACED IAW SRM 51-40-02. REPAIR IS CLASSIFIED AS MINOR IAW GMM 6-2-100.
Back to JASC 5310