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 UPS02238317Intercostal · corrodedINSPECTION TYPE:C CORROAION ON INTERCOSTAL FROM BS 294.5 - BS 312 AT LBBL 40 APPROX INTERCOSTAL REPAIRED IAW SRM 51-40-3SDR GTIA020656Strap · corrodedFTW - FOUND AFT PIT STATION 1155-1212 L28R, REPAIR STRAP ON OUTBOARD AND INBOARD SIDE DOOR JAMB BEAM IS CORRODED, EVIDENCE OF CORROSION BETWEEN STRAP AND BEAM. REMOVED STRAPS STATION 1150 AND 1220. REMOVED JAMB BEAM. LOCATED AND DRILLED AND NEW JAMB BEAM. SDR GTIA020606Shear Tie · corrodedFTW - FOUND AFT PIT STATION 1174 L29R-L30, CORROSION ON FRAME TO SKIN SHEAR TIE AND ADJACENT SKIN. REMOVED DAMAGE SHEAR TIE. FABRICATED NEW PARTS. VERIFY NEW PART FOR FRAME. DRILLED AND LOCATED HOLES AT FRAME. INSTALLED SHEAR TIE REPAIR. VERIFY NEW PART SDR GTIA020667Door Frame · corrodedFTW - AFT PIT STATION 1155 L28R-26R FORWARD DOOR FRAME IS CORRODED ON FORWARD AND AFT SIDES, HI-LOCKS ON FORWARD SIDE LOWER ANGLE MISSING NUTS AND WASHERS. MATERIAL LOSS FOUND TO BE OUT OF LIMITS. FOUND DOOR FRAMES STRAP AT STATION 1155 L30-21R TO BE OUT OF SDR 2002F00672Shear Tie · corrodedAT C-CHECK, FOUND CORROSION ON SHEAR TIE AT STATION 1661, BETWEEN STRINGERS 51R AND 52R. (M)SDR 2002F00671Door Frame · corrodedAT C-CHECK, FOUND CORROSION AT FORWARD CARGO DOOR FUSELAGE CUTOUT, AFT LOWER CORNER, INNER RADIUS WEB, AND INNER SKIN, AT STATION 999. (M)SDR 2002F00669Shear Tie · corrodedAT C-CHECK, FOUND CORROSION ON SHEAR TIE IN LOWER BILGE AT STATION 1641, BETWEEN STRINGER 47R AND 48R. (M)SDR 2002F00668Shear Tie · corrodedAT C-CHECK, FOUND CORROSION IN BILGE ON THE SHEAR TIE AND THE FLASHER STROBE DOUBLER, BETWEEN STATION 1661 AND 1681, AND BETWEEN STRINGERS 51R AND 52R. (M)SDR 2002F00667Shear Tie · corrodedAT C-CHECK, FOUND CORROSION IN BILGE ON SHEAR TIE AT STATION 1681, BETWEEN STRINGERS 47R AND 48R. (M)SDR AALA20020672Shear Tie · gougedTUL - FOUND SHEAR TIE GOUGED STATION 579 BETWEEN LONGERON 25L AND 26L. INSTALLED NEW SHEAR TIE SRM 51-01. (M)SDR UPS02438457Door Frame · crackedINSPECTION TYPE:C M/D- RT BS 2231 FRAME REVEAL FOUND CRACK AT REVEAL CUTOUT BETWEEN S24R AND S25R. M/D- RT BS 2231 S24R & S25R FRAME REVEAL REPAIRED AS PER SRM 51-40-02 FIG 1.SDR UPS02438424Shear Tie · crackedINSPECTION TYPE:C AFT CARGO - BS 1660 BETWEEN STR 47R & STR 48R SHEAR TIE FOUND CRACKED. AFT CARGO - BS 1660 BETWEEN STR 47R & STR 48R SHEAR TIE REPAIRED AS PER SRM 53-10-04 FIG 3.SDR USAA020253Crease Beam · corrodedPIT - FOUND CREASE BEAM CORRODED, STATION 277-360. DEFECTIVE PART REPLACED WITH IDENT PART. (M)SDR SIMA200214911Beam · corrodedABI - THIS IS A LEVEL 2 FINDING ON CRIC NR 36129, RIGHT CENTER OMEGA BEAM HAS CORROSION FROM FRAME 23 TO 26. BLENDED CORROSION AND ACCEPTED AS IS IAW EMB GST-1552/02. (M)SDR SIMA200214910Beam · corrodedABI - THIS IS FROM A LEVEL 2 FINDING ON CRIC NR 36128, LEFT OMEGA BEAM HAS CORROSION FROM FRAME 23 TO 26. INSPECTED AND ACCEPTED AS IS IAW EMB GST-1552/02. RESTORED PROTECTIVE COAT IAW CPM 51-21-06. (M)SDR SIMA200214909Gusset · corrodedABI - THIS IS A LEVEL 2 FINDING ON CRIC NR 36127, GALLEY AFT DIAMOND GUSSET HAS CORROSION. INSTALLED NEW GUSSET IAW EMB145 SRM 51-20-03 AND 51-40-02. (M)SDR SIMA200214908Gusset · corrodedABI - THIS IS A LEVEL 2 FINDING ON CRIC NR 36126, GALLEY FORWARD DIAMOND GUSSET HAD CORROSION. INSTALLED NEW FORWARD DIAMOND GUSSET IAW EMB145 SRM 51-20-03, 51-40-02 AND 51-40-06. (M)SDR SIMA200214907Crossbeam · corrodedABI - THIS IS A LEVEL 2 FINDING ON CRIC NR 36125, GALLEY CROSSBEAM AND PROFILE CORRODED. INSTALLED NEW CROSSBEAM AND PROFILE IAW EMB145 SRM 51-40-02. (M)SDR ASAA0280166Shear Tie · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON SHEAR TIE AT LONGERON 30 IN MID CARGO BAY AT FS 787. REPLACED SHEAR TIE PER SRM'S 53-01 AND 51-30-02. (M)SDR 2002F00675Shear Tie · corrodedAT C-CHECK, FOUND CORROSION ON SHEAR TIES AT STATION 1561, STRINGERS 47R, 48R, 49R, 51R, AND 52R. (M)SDR AALA20020658Shear Tie · gougedTUL - FOUND GOUGE IN SHEAR TIE LONGERON 23 LEFT STATION 522. CUT OUT DAMAGE AND INSTALLED SHEAR TIE REPAIR PER SRM 53-03 FIGURE 6 SHEET 1. (M)SDR ASAA0210092Shear Tie · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND SHEAR TIE AT BODY STATION 867, RIGHT BUTTOCK LINE 7 CORRODED. REPAIRED PER SRM. (M)SDR 0201559861Intercostal · crackedDuring MCK in ATL, a crack was found on intercostal 991157-3 at sta. 148.5 to 160. approx. z 44. Repaired per EA 98-189671.SDR MWEA020318Door Frame · dentedFORWARD PIT, LOWER DOOR JAM WEB HAS SEVERAL SMALL DENTS AT STATION 418 AND 430. FABRICATED AND INSTALLED SECTION OF WEB AND DOUBLER.SDR SIMA200214906Sill · corrodedABI - THIS IS A LEVEL 2 FINDING ON CRIC NR 36122, GALLEY RIGHT FAT SILL HAS CORROSION. INSTALLED NEW SERVICEABLE SILL IAW EMB145 SRM 51-40-02. (M)SDR SIMA200214905Sill · corrodedABI - THIS IS A LEVEL 2 FINDING ON CRIC NR 36120, GALLEY FORWARD RIGHT SILL HAS CORROSION. INSTALLED NEW SERVICEABLE SILL IAW EMB145 SRM 51-40-02, 51-20-03. (M)SDR SIMA200214902Sill · corrodedABI - THIS IS A LEVEL 2 FINDING ON CRIC NR 36123, LEFT SILL IN GALLEY AREA HAS CORROSION. INSTALLED NEW SERVICEABLE SILL IAW EMB145 SRM 51-20-03, 51-40-06, AND 51-40-02. (M)SDR AALA20020688Window Frame · crackedWINDOW FRAME, WINDOW RING PAN CRACKED AT FASTENER. INSTALLED DOUBLER PER MM.SDR 200200246Door Frame · crackedREPAIRED CRACK IN UPPER FWD CORNER OF MAIN CARGO DOOR BY REMOVING TEMPORARY REPAIR, TRIMMING OUT THE CRACK, FABRICATING FILLER AND REINSTALLING EXISTING REPAIR DOUBLER.SDR UPS02438454Shear Tie · crackedINSPECTION TYPE:C FWD CARGO COMPT- BS 960 S46R AREA SHEAR TIE CRACKED. SHEAR TIE REPAIRED AS PER SRM 53-10-04 FIG 3.SDR UPS02438452Shear Tie · crackedINSPECTION TYPE:C FWD CARGO COMPT- BS 900 S43L AREA SHEAR TIE CRACK. SHEAR TIE REPAIRED AS PER SRM 53-10-04 FIG 3.SDR UPS02438449Shear Tie · crackedINSPECTION TYPE:C FWD CARGO COMPT - BS 900 S41L AREA SHEAR TIE CRACK. SHEAR TIE REPAIRED PER SRM 53-10-04 FIG 40.SDR UPS02438444Shear Tie · corrodedINSPECTION TYPE:C FWD CARGO COMPT- BS 900 S46R TO S47R SHEAR TIE CORRODED. CORROSION REMOVED IAW SRM 51-10-01. BLEND OUT NOT WITHIN SRM 53-10-01 FIG 1 LIMITS, FOR REPAIR REFER TO SRM FIG 53-10-04 FIG 3.SDR UPS02438427Shear Tie · crackedINSPECTION TYPE:C FWD CARGO COMPT- BS 960 41R AREA SHEAR TIE CRACK. SHEAR TIE REPAIRED AS PER SRM 53-10-04 FIG 40.SDR UPS02438395Shear Tie · crackedINSPECTION TYPE:C FWD CARGO COMPT-BS 920 S40R AREA SHEAR TIE CRACK. SHEAR TIE REPAIRED AS PER SRM 53-10-4 FIG 4.SDR 0201519921Frame · crackedDuring MCK in ATL, while inspecting the interior structure, the RH side of the 598 frame was found to have 3.0 inch long crack between longeron 18 an 19, on the outboard flange. The crack runs fron the first fastener hole below the pocket to the third hole. ReSDR ASAA0210088Shear Tie · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND SHEAR TIE AT BS 747, LEFT BUTTOCK LINE 8 CORRODED. REMOVED AND REPLACED SHEAR TIE PER SRM. (M)SDR AALA20020738Door Frame · corrodedTUL - FOUND CORROSION ON HORIZONTAL AND VERTICAL LEGS OF MID CARGO LOWER DOOR BEAM. FORWARD AND AFT STOP BOLT HOLES ARE OUT OF LIMITS AFTER CORROSION REMOVAL. INSTALLED TWO DOUBLERS AT DOOR BEAM STOP BOLT AREAS PER AARD 53-10-00-16. (M)SDR AALA20020689Shear Tie · crackedWINDOW FRAME - WINDOW SHEER TIE CRACKED AT 1079 UPPER AFT, MARKED RIGHT SIDE. CUT OUT DAMAGED AREA PER MM. INSTALLED DOUBLER.SDR QXEA0200751Stop Fitting · chafedPDX- FORWARD CARGO DOOR, LOWER STOP BRACKET IS CHAFED. REPAIRED IAW DHC-8 SRM 51-00-06.SDR UPS02438116Stringer · corrodedINSPECTION TYPE:N/A CORROSION STA 1148 STRINGER 25L TO 26L ***MRR FILED AS OPEN****SDR UPS02838374Door Frame · crackedINSPECTION TYPE:C13 B-PIT DOOR AREA FWD JAMB CRACKED. FABBED AND HEAT TREATED IAW DC8 SRM 51-1-8 DAC DWG 3712791, DRILLED AND INSTALLED ANGLE IAW DC8 SRM 51-1-8.SDR 0201529954Door Frame · crackedWhile in MSP during line operations a crack was found on the Non-ventral APB door jamb. The crack is located at the end of the LH side #2 radial.Repaired per EA 99-189338.SDR P2EA2002V0033Skin · dentedDURING C1+C2 INSPECTION:-PERFORM PERMANENT REPAIR @ BS Y237, LONGERON 16 L-H.-FUSELAGE SKIN SECTION REPAIRED FROM BS Y223 TO BS Y263, BETWEEN LONGERON 15 & 18 L-H DUE TO TEMPORARY REPAIR IAW COOPESA E.O. No. COO-9-53-275-02 DATED MAY 08,2002 & DOCUMENTED ON FASDR 2002UALA00804Crease Beam · corrodedCABIN CREASE BEAM WEB UPPER SURFACE CORRODED BODY STATION 982, LBL 71 WL 208. MAJOR REPAIR ACCOMPLISHED. REPLACED CREASE BEAM WEB.SDR QXEA0200755Stop Fitting · chafedPDX- TOP FORWARD BAGGAGE DOOR STOP INBOARD FLANGE IS CHAFED. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-26.SDR 0201549861Intercostal · crackedDuring MCK in ATL, At sta 180 a crack found on the 9923484 intercostal at X=20. Repaired per EA 98-189693.SDR 211001007Threshold · corrodedMID CARGO COMPARTMENT DOOR THRESHOLD IS CORRODED, CORROSION RUNNING UNDER DOOR STOPS. CORRECTIVE ACTION: REMOVED AND REPLACED MID CARGO COMPARTMENT DOOR THRESHOLD. (NR 23722)SDR ASAA0280150Shear Tie · corrodedPAE - DURING C-CHECK, FOUND SHEAR TIE CORRODED AT FS 769. INSTALLED SPLICE REPAIR PER SRM 53-03 AND 51-60. (M)SDR ASOA02270Strap · corrodedDURING C-CHECK INSPECTION IN BNA, THE LEFT BUTT STRAP BETWEEN FRAMES 35 AND STATION 13056 WAS FOUND CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE CORRODED LEFT BUTT STRAP IAW SRM'S 51-25-00, 51-40-05, AND 51-40-06. (M)
Back to JASC 5310