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 QXEA0001660Structure · corrodedPDX- CORROSION ON COCKPIT FLOOR WHERE PILOTS LEFT HAND SEAT RAIL MOUNTS. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4B, SRM 53-11-05, PAGE 6, FIGURE 2, AND SRM 53-01-01, PAGE 6 PARAGRAPH 4B.SDR QXEA0001511Clip · crackedPDX- CRACKED CLIP AT FRAME 15205 AND STRINGER 25. REPAIRED IAW FOKKER SRM 53-02-13 PAGE 4 FIGURE 62.SDR QXEA0001500Clip · crackedPDX- CRACKED CLIP AT FRAME 15205 AND STRINGER 50. REPAIRED IAW FOKKER SRM 53-02-13 PAGE 4 FIGURE 2.SDR QXEA0001499Clip · crackedPDX- CRACKED CLIP AT FRAME 15205 AND STRINGER 56. REPAIRED IAW FOKKER SRM 53-02-13 PAGE 4 FIGURE 2.SDR QXEA0001498Clip · crackedPDX- CRACKED CLIP AT FRAME 15205 AND STRINGER 18. REPAIRED IAW FOKKER SRM 53-02-13 PAGE 4 FIGURE 2.SDR QXEA0001497Clip · crackedPDX- CRACKED CLIP AT FRAME 15025 AND STRINGER 21. REPAIRED IAW FOKKER SRM 53-02-13 PAGE 4 FIGURE 2.SDR DL73E001112Door Frame · tool damageTOOLING DAMAGE FOUND ON THE R1 DOOR AFT OPENING FRAME AT WL 214. DAMAGE FOUND IN THE FRAME RADIUS AS WELL AS EDGE OF FLANGE. NEW SECTION OF FRAME SPLICED AS PERMANENT REPAIR. ER/A 334431-14 REV A.SDR QXEA0001449Clip · crackedPDX- CABIN CLIP CRACKED AT STRINGER 33, FRAME 10790. REPAIRED IAW FOKKER SRM 53-02-13, PAGE 4, FIGURE 2.SDR SWAA001008Window Post · crackedDURING SCHEDULED D-CHECK, FOUND COCKPIT WINDOW POST CRACKED BETWEEN NR 1 AND NR 2 WINDOWS. REPAIRED WINDOW POST PER SRM.SDR AALA20000989Frame · crackedTUL - FOUND AFT UPPER CORNER OF WINDOW FRAME CRACKED LEFT STATION 1041-1060. INSTALLED FABRICATED DOUBLER PER AARD 53-10-0025. (M)SDR SIMA1532Angle · corrodedSAW - DURING MBV-1 INSPECTION, FOUND RIGHT AFT CARGO ZEE MEMBER CORRODED BEYOND LIMITS. REMOVED AND REPLACED CORRODED ZEE MEMBER IAW SRM 51-25-03. (X)SDR TWAA0009007Structure · corrodedDURING CHECK-C MAINT, FOUND CORROSION UNDER WATER LINE PLATE AT STA 160, RBL 50 AT O/B AFT CORNER. REPLACED MEMBRANE WITH NEW PART PER SPM 6-70-01, AND INSTALLED PER SRM 51-30-02. TREATED PER SRM 51-10-3.SDR COMA011008Crossbeam · corrodedUPON COMPLIANCE OF 2C INSPECTION TASK 5310-121/122-011 THE FRAME 12 CROSS BEAM WAS FOUND TO BE CORRODED. THE DAMAGED PART WAS REPLACED IAW EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES.SDR USAA000761Door Frame · crackedCLT - FOUND DOOR FRAME CRACKED .25 INCH, STATION 294.5 INBOARD SIDE OF R-1 DOOR FRAME. INSTALLED DOUBLER PER SRM 51-70-11. (M)SDR USAA000762Frame · crackedCLT - FOUND FORWARD SERVICE DOOR FRAME CRACKED .75 INCH, STATION 294.5, WL 207.5. INSTALLED REPAIR ANGLE PER SRM 53-10-02. (M)SDR COMA0010154Shear Tie · crackedUPON COMPLIANCE OF 2C INSPECTION TASK 5310-221/222-15I, THE FRAME 9 LEFT AND RIGHT SKIN SUPPORTS WAS FOUND TO BE CRACKED. THE DAMAGED PART WAS REPLACED IAW EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES AND AERODESIGN REPORT 660-1.SDR COMA0010134Shear Tie · crackedUPON COMPLIANCE OF 2C INSPECTION TASK 5310-121/122-O1I, THE FRAME 12 SKIN SUPPORT WAS FOUND TO BE CRACKED. THE DAMAGED PART WAS REPLACED IAW EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES AND AERODESIGN REPORT 3653-1.SDR COMA0010133Channel · corrodedUPON COMPLICANCE OF 2C INSPECTION TASK 5310-121/122-01I, THE FRAME 12 Z SECTION WAS FOUND TO BE CORRODED. THE DAMAGED PART WAS REPLACED IAW EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES.SDR COMA0010132Shear Tie · crackedUPON COMPLIANCE OF 2C INSPECTION TASK 261/262-01Z, THE FRAME 40 SKIN SUPPORT WAS FOUND TO BE CRACKED. THE DAMAGED PART WAS REPLACED IAW EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES.SDR AALA20001020Structure · lightning strikeTUL - LIGHTNING STRIKE BLENDOUT EXCEEDS 20 PERCENT. INSTALLED DOUBLER PER SERM 53-04 FIG 38. (M)SDR AWXA0000352Beam · crackedC-CHECK, 2 INCH CRACK IN CREASE BEAM SHEAR WEB BETWEEN STA 578 TO 559 RT. REMOVED CREASE BEAM IAW 737 SRM 51-40-22, FABRICATED REPLACEMENT WEB IAW EO 53-10-02 FROM 7075 T6 X .040. TREATED AND PRIMED IAW 737 SRM 51-20-01, INSTALLED WEB IAW 737 SRM 51-40-02.SDR EIA2000188Shear Tie · crackedC-2 CHECK, FOUND BS 390 STRINGER 1L FRAME ATTACH SHEAR TIE CRACKED. SHEAR TIE CLIP REPLACED PER SRM 51-10-01, SRM 51-30-02, AND SRWS 917181. (M)SDR EIA2000187Tie Clip · crackedC2-CHECK, FOUND COCKPIT BS 360 STRINGER 0 TO STRINGER 1L TIE CLIP CRACKED. SHEAR TIE CLIP REPLACED PER SRM 51-10-01. (M)SDR EIA2000180Tie Clip · crackedC-2 CHECK, FOUND BS 400 STRINGER 8L FRAME ATTACH SHEAR TIE CLIP CRACKED. SHEAR TIE CLIP REPLACED PER SRM 51-10-01, SRM 51-30-02, AND SRWS 917268. (M)SDR EIA2000179Tie Clip · crackedC2-CHECK, FOUND BS 380 STRINGERS 6L TO 9L FRAME ATTACH SHEAR TIE CLIPS CRACKED. SHEAR TIE CLIPS REPLACED PER SRM 51-10-01, SRM 51-30-02, AND SRWS 917265. (M)SDR EIA2000178Tie Clip · crackedC2-CHECK, BS 360 STRINGER 7L FRAME ATTACH SHEAR TIE CLIP CRACKED. SHEAR TIE CLIP REPLACED PER SRM 51-10-01 AND 51-30-02. (M)SDR EIA2000177Tie Clip · crackedC2-CHECK, BS 440 STRINGER 12L SHEAR TIE CLIP CRACKED. SHEAR TIE CLIP REPLACED PER SRM 51-10-01 PAGE 18 AND SRWS 917177. (M)SDR EIA2000165Door Frame · crackedFOUND L1 DOOR AFT CUTOUT BS 488 FRAME INNER CHORD FASTENER HOLE CRACKED AT NR 1 STOP FITTING. TRIMMED OFF INNER CHORD AND NDT INSPECTED. STRAP REPAIRED PER BOEING MSG EVR-HKG-00-00086H/-00074F AND RS R53-12-34364. INNER CHORD TO BE REPLACED IAW SB747-53-227SDR AALA20001023Structure · lightning strikeTUL - FOUND LIGHTNING STRIKE BLEND OUT AT STATION 807 LONGERON 10L IS 700 DEEP (BEYOND LIMITS). INSTALLED DOUBLER PER SRM 53-04 FIG 38. (M)SDR AALA20001022Structure · lightning strikeTUL - LIGHTNING STRIKE BLENDOUT IS TOO DEEP AT STATION 841 ABOVE LONGERON 10L, BEYOND LIMITS. INSTALLED DOUBLER PER SRM 53-04 FIG 38. (M)SDR AALA20001019Structure · lightning strikeTUL - FOUND LIGHTNING STRIKE BLEND OTU EXCEEDS 20 PERCENT. INSTALLED DOUBLER PER SRM 53-04 FIG 38. (M)SDR SWAA000976Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CORRODED, BS 947 BETWEEN STRINGERS 26L-27L. REMOVED AND REPLACED SHEAR TIE SECTION PER SRM.SDR RRXA003163Strap · tornDURING A MAINTENANCE VISIT FOUND A TEAR TO THE STRAP BETWEEN STRINGERS AT STA 902 STRINGER 9-10 LT, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. RECEIVED PART AND INSTALLED IAW PD 08-53-049.SDR UIEA00029Structure · crackedLT LA7143 - MIA/ASU-ATB, AFTER TAKEOFF, CREW ADVISED THAT THEY WERE UNABLE TO PRESSURIZE THE AIRCRAFT. AFTER ABNORMAL CHECKLIST ACCOMPLISHED, CHECK OF MAIN DECK REVEALED NO ABNORMALITIES. DUMPED 80 KGS OF FUEL AND RETURNED TO MAI WAS UNEVENTFUL. MAINTENANCESDR UPS00832823Fitting · corrodedINSPECTION TYPE:C123, STA 390 LONG 35R SPLICE FITTING IS CORRODED BEYOND LIMITS. REMOVED AND REPLACED FITTING IAW DWG 3754026 AND SRM 51-1-20D.SDR AWXA0000346Beam · crackedC-CHECK, CREASE BEAM SHEAR WEB HAS 2 INCH CRACK AT BS 570 RT SIDE FLOOR. REMOVED AND REPLACED CREASE BEAM SHEAR WEB (NEW PART).SDR AWXA0000345Beam · crackedC-CHECK, CREASE BEAM CHORD CRACKED AT FWD FASTENER HOLE RIGHT SIDE BS 178 STR 17 RT. REMOVED DAMAGED SECTION IAW 737 SRM 51-70-12 FIG 1, FABRICATED PARTS IAW 737 SRM 51-70-13, INSTALLED IAW 737 SRM 51-70-12, MATERIAL: DOUBLER AND PLATE 2024T3 X .071 QQA250/SDR AALA2000884Door Frame · corrodedTUL - FOUND AFT CARGO DOOR CUTOUT, LOWER JAMB LOWER CHORD, CORROSION ON LOWER CHORD, STATION 950F PLUS 13 TO STATION 950F PLUS 19. INSTALLED REPAIR PER AARD 51-40-00-1 REPAIR 1. (M)SDR GAIA00291Beam · corrodedDURING LIGHT C-CHECK AT TIMCO/OSC THE FOLLOWING DISCREPANCY WAS FOUND, FASTENER HOLES FOR RIGHT WALKING BEAM PANEL HAS CORROSION ON LANDING GEAR BEAM. REPAIRED BEAM IAW TIMCO REO SOO170. THIS AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA00294Beam · corrodedDURING LIGHT C-CHECK AT TIMCO/OSC, THE FOLLOWING DISCREPANCY WAS FOUND, LEFT WALKING BEAM PANEL ATTACH HOLES ON BEAM HAS CORROSION. REPAIRED BEAM IAW TIMCO REO SOO170. A/C RETURNED TO SERVICE. (M)SDR QXEA0001612Structure · crackedYYC- APU FORWARD ENCLOSURE, RIGHT HAND TOP CORNER AREA IS CRACKED. REPAIRED IAW FOKKER SRM 49-00-01, 51-31-01 AND HORIZON AIR EA 4-49-79.SDR 0002026625Shear Tie · crackedDURING M-CHECK, FOUND CRACK ON FRAME SHEAR TIE, LOCATED AT BS 520, STRINGER 11R. REPAIRED PER EA 66-176687 REV A.SDR RRXA003455Shear Tie · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO THE AFT PIT INTERCOSTAL STR 31L O/B FACE BETWEEN STA'S 1340-1360 , DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. CORROSION DAMAGE WITHIN LIMITS.SDR TWAA0008802Doubler · corrodedDURING CHECK-C MAINT, FOUND DOUBLER AT AFT CARGO DOOR STA 1300 TO 1231, LONGERON 29 TO 26R, WAS CORRODED. REMOVED CORROSION PER SPM 6-80-01, PAGE 1 ITEM 3, A, B PAGE 2 AND 3.SDR AALA20000904Casting · crackedTUL - FOUND TOP AFT DOOR STOP CASTING CRACKED. REMOVED AND REPLACED CASTING SRM 51-10-1. (M)SDR UPS00832794Shear Tie · crackedINSPECTION TYPE:C123, STA 702.85 SHEAR TIE FITTING IS CRACKED BETWEEN LONG 35L AND 36. REMOVED AND REPLACED FITTING IAW DWG 3753757 AND SRM 51-1-20D.SDR DL72S001005Frame · crackedFOUND ON A1 LETTER CHECK, 1 INCH CRACK R-1 DOOR AFT FRAME AT LOWER STOP CASTING. REPAIRED PER MM 52-12-0.SDR CALA0000734Doubler · corrodedINSPECTION FOUND SPLICE DOUBLER CORRODED IN AFT CARGO AREA AT LT CARGO TRACK BETWEEN STA 1212 AND 1231. THE CORRODED SPLICE WAS REMOVED AND A NEW SPLICE WAS INSTALLED IAW SRM 51-30-5, 53-05, FIGURE 4G, AND 51-10-3.SDR UPS00832829Shear Tie · corrodedINSPECTION TYPE:C123, STA 660 SHEAR TIE BETWEEN LONG 34L-34R IS CORRODED BEYOND LIMITS. REMOVED, FABRICATED AND REPLACED IAW DWG 5616509 AND SRM 51-1-21.SDR CALA0000730Door Frame · corrodedINSPECTION FOUND MID CARGO DOOR JAMB CORRODED. THE REPAIR SPACER AND DOUBLER WERE REMOVED AND REPLACED IAW SRM 53-05, FIGURE 63.
Back to JASC 5310