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 ASAA0280402Shear Tie · corrodedOKC - FOUND DURING 30K CHECK, AFT CARGO BAY UPPER SHEAR TIE CORRODED AT FS 1155, LONGERON 30 TO 29R. REPLACED UPPER SHEAR TIE PER SRM 51-30-2 AND 51-10-2. (M)SDR ASAA0280432Shear Tie · corrodedOKC - FOUND DURING 30K CHECK, AFT CARGO BAY SHEAR TIE CORRODED AT FS 1212, LONGERON 28L-28R. REPLACED SHEAR TIE AND PREVIOUS SPLICES PER SRM 53-14-3, FIG 3, 51-10-2, 51-10-4, AND 51-30-5. (M)SDR DHL2002803536Fitting · crackedITEM REF N/R: 0470 MAIN CARGO COMPT. - SPLICE FITTING CRACKED .500 @ STA. 759.000 RBL 23 ( MAJOR REPAIR)CORR:PERFORMED MAJOR REPAIR IAW ATM# po111892 , drawing 5750549.REMOVED SPLICE FITTING CRACKED IAW SRM 51-1-20D PG. 21. CLEANED , TREATED , AND PRIMED AREA SDR QXEA0201739Door Frame · damagedPDX - RT UNDER WING EMERGENCY EXIT EXTERIOR HAS NICK OR GOUGE AT FORWARD EDGE OF WINDOW. REPAIRED IAW DHC-8 SRM 51-20-16, SRM 51-20-16 AND MM 56-20-11-400-801.SDR 2002UALA01603Door Frame · corrodedAFT CARGO COMPARTMENT DOOR CUTOUT FRAME AT BODY STATION 794 S23R TO S24R AFT SIDE HAS EXCESSIVE MATERIAL REMOVED TO CLEAN CORROSION. MAJOR REPAIR ACCOMPLISHED. FABRICATED REPAIR DOUBLER.SDR ASAA0280379Shear Tie · corrodedOKC - FOUND DURING 30K CHECK, RIGHT FRAME TO SKIN BRACKET CORRODED AT FS 1212, LONGERON 29R. REPLACED BRACKET PER SRM 51-10-2 AND -4, AND DAC DWG 5936064. (M)SDR ASAA0280380Shear Tie · corrodedOKC - DURING 30K-CHECK, RIGHT FRAME TO SKIN OUTBOARD BRACKET CORRODED AT FS 1220, LONGERON 29R. REPLACED BRACKET PER SRM 51-10-2 AND -4, AND DAC DWG 5936064. (M)SDR ASAA0280381Shear Tie · corrodedOKC - FOUND DURING 30K-CHECK, RIGHT FRAME TO SKIN INBOARD BRACKET CORRODED AT FS 1220, LONGERON 29R. REPLACED BRACKET PER SRM 51-10-2 ND -4, AND DAC DWG 5936064. (M)SDR ASAA0280389Door Frame · corrodedOAK - FOUND C-CHECK, AFT CARGO BAY DOOR JAMB BEAM IS CORRODED IN SEVERAL PLACES. REMOVED CORRODED AREA, ADDED FILLER, AND INSTALLED DOUBLER PER EA 5310-02122. (M)SDR C2XA02SH100Butt Strap · corrodedDURING C CHECK, BUTT STRAP RT OF CENTER FLOORBEAM AT FRAME 18 WAS FOUND TO HAVE CORROSION ANROUND NUTPLATE HOLES. MAINTENANCE REMOVED DAMAGE AND PERFORMED A DOUBLER REPAIR IAW CONTINENTAL EXPRESS EC 5320-0179. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR DLM88021221Beam · corrodedDURING HMV-2, CORROSION DAMAGE WAS FOUND ON THE C2 & C3 JAMB BEAMS. THE JAMB BEAM DOOR STOP HOLES WERE OUT OF TOLERANCE AFTER CLEAN UP. CORROSION WAS REPAIRED PER MD80 SRM 53-05 FIGURE 63 BY BLENDING AND USE OF A REPAIR DOUBLER.SDR QXEA0201723Bracket · gougedPDX - ANGLE BRACKET AT THE LOWER AFT CORNER OF BAGGAGE DOOR APERTURE GOUGED. REPAIRED IAW DHC-8 SRM 51-40-00, PAGE 4, TABLE 4 AND SRM 51-40-11, PAGE 1, PARAGRAPH 1A.SDR ASAA0210245Shear Tie · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND SHEAR TIE AT BS 727A, STRINGER 27R CORRODED. REMOVED CORRODED, FABRICATED AND INSTALLED REPAIR PER SRM. (M)SDR TSAA0253217Shear Tie · crackedFUSELAGE SHEAR TIE CRACK AT BS 460, S-17L. PERFORMED TRIMOUT TO DAMAGED AREA. HFEC INSPECTION COMPLETED NO DEFECTS NOTED, FABRICATED AND INSTALLED NEW T-CHORD IAW ECO. AIRCRAFT RETURNED TO SERVICE.SDR AWXA200201031Door Frame · corrodedDURING C-20 CHECK CORROSION WAS FOUND AT THE L-1 DOOR SILL INNER CHORD UNDER DRAIN TROUGH BS 333, LBL 50. MAINTENANCE REMOVED 2 EACH ANGLES AT BS 312 AND 344, A WEB AT BS 277 - 306, A FRAME BS 300, AND AN ANGLE BS 277 - 284 FOR ACCESS, REMOVED DAMAGED DOOR SILSDR HXSA0000403Structure · buckledFUSELAGE BOX STRUCTURE CROSS BRACES BUCKLED. SENT FOR JIG SET AND REPAIR.SDR 2002UALA01587Tee Fitting · corrodedAFT PIT DOOR OPENING FORWARD FRAME TEE FITTING FOR BOTTOM STOP PAD FITTING IS CORRODED BEYOND LIMITS. MAJOR REPAIR ACCOMPLISHED. REPLACED SUPPORT TEE FITTING.SDR F3LA200200347Shear Tie · corrodedCORROSION FOUND ON FRAME AND SHEAR TIE FORWARD AND AFT SIDES AT BS 500D, LBL 9 TO 22SDR MWEA020617Door Frame · corrodedFORWARD CARGO DOOR JAMB PAN AT LONGERON 28 HAS LIGHT CORROSION ALONG ENTIRE LENGTH. REMOVED CORROSION, REMOVED LOWER DOOR JAMB PAN, LOCATED AND DRILLED NEW JAMB PAN, INSTALLED LOWER STOP FITTINGS AND SCUFF PLATE.SDR MWEA020614Door Frame · corrodedAFT CARGO DOOR JAMB WEB HAS SURFACE CORROSION AT SEVERAL LOCATIONS. BLENDED CORROSION, LOCATED FASTENER HOLES IN NEW WEB AND INSTALLED NEW WEB.SDR MWEA020615Door Frame · corrodedCORROSION ON LOWER END OF DOOR JAMB BETWEEN STATION 987-935 IN AFT CARGO BAY. BLENDED CORROSION, REMOVED FASTENERS IN LOWER JAMB SECTION, REMOVED DAMAGED SECTION OF JAMB PAN, TRIMMED LOCATED AND DRILLED UP NEW SECTION. INSTALLED NEW PAN SECTION AND NEW WEB.SDR GTIA021191Doubler · corrodedFTW - FOUND FORWARD ENTRANCE, AFT LOWER DOUBLER JAMB CORRODED AND MISSING 3 FASTENERS SUPPORT FORMER, STATION 207. REMOVED DOOR JAMB DOUBLER. INSTALLED FORWARD ENTRANCE AFT LOWER DOOR JAMB DOUBLER. (M)SDR 2002UALA01577Door Frame · crackedFORWARD GALLEY DOOR CUTOUT FORWARD FRAME AT STOP PAD FITTING IS CRACKED (UPPER FITTING). MAJOR REPAIR ACCOMPLISHED. INSTALLED REPAIR ANGLE. INSTALLED FRAME.SDR SWIA200211343Door Frame · damagedFRAME 13A DAMAGED AT DOOR ACTUATOR MOUNT. EXTENSIVE DAMAGE TO SHEAR CLIP 120-29047-001 AND SEVERAL OTHER TIPPED AND DAMAGED RIVETS OUTBOARD OF SHEAR CLIP. AT FRAME 13A, REMOVED AND REPLACED THE DAMAGED SHEAR CLIPS AND DAMAGED RIVETS IAW EMB SRM 51-00-00, 51-SDR QXEA0201685Structure · dentedPDX - DURING INSPECTION, MAINTENANCE INSPECTORS LOCATED SEVERAL SMALL DENTS BETWEEN FUSELAGE STATIONS X281.00 AND X321.0. DENTS AND DAMAGE WERE REPAIRED IAW EA 6-53-48, AND EA 6-53-48-B. AN HFEC INSPECTION WAS ALSO PERFORMED WITH NO CRACKS NOTED.SDR SWIA200211384Butt Strap · corrodedFORWARD CENTER BUTT STRAP IS CORRODED IN CABIN (IN FRONT OF GALLEY). FOUND DURING C CHECK INSPECTION. REPLACED BUTT STRAP IAW 120 SRM 51-10-02.SDR ASAA0240149Shear Tie · corrodedDURING C-CHECK FOUND CORROSION ON SHEAR TIE AT BS 727G BETWEEN STR 27 LT AND 26 LT. REMOVED AND REPLACED IAW SRM.SDR ASAA0280363Door Frame · crackedOAK - DURING C-CHECK, FOUND LEFT MLG WHEEL WELL DOOR JAMB CRACKED AT FORWARD OUTBOARD SIDE. REPLACED DOOR JAMB PER SRM 51-30-2, PAGE 4-12. (M)SDR AALA20021556Strap · crackedTUL - FOUND FORWARD PASSENGER AFT FRAME STRAP CRACKED STATION 207 LONGERON 15 LEFT. INSTALLED DOUBLER TO REPAIR CRACKED FRAME. STRAP ON FORWARD PASS DOOR CUT OUT STATION 207, LONGERON 15 PER AARD REF 53-10-00-11. (M)SDR 2002UALA01562Crease Beam · corrodedLEFT HAND CREASE BEAM WEB AT STATION 970-976 EXCESSIVE MATERIAL REMOVED TO ELIMINATE CORROSION. MAJOR REPAIR ACCOMPLISHED. REPLACED CREASE BEAM WEB.SDR MWEA020611Door Frame · corrodedAFT CARGO DOOR JAMB BEAM FROM STATION 897-935 AT LONGERON 29 RIGHT HAS CORROSION AT NUTPLATE HOLES. BLENDED CORROSION, REMOVED, FABRICATED AND INSTALLED INTERCOSTAL, REMOVED AND FABRICATED BEAM, LOCATED FASTENER HOLES.SDR AALA20021469Door Frame · corrodedTUL - FOUND AFT CARGO DOOR BEAM HAS CORROSION FROM STATION 1160-1207. INSTALLED BEAM PER AARD 53-10-00. (M)SDR MDR02029Striker · dentedDURING BRIDGING INSPECTION FOUND PAX DOOR SEAL STRIKER AT FS 349, WL 86 IS DENTED APPROXIMATELY .025 INCH DEEP BY .5 INCH LONG.SDR 0203679947Door Frame · crackedWHILE IN FOR A L CHECK. A CRACK WAS FOUND IN THE LOWER FORWARD CORNER OF THE R1 SERVICE DOOR JAMB. REPAIRED PER EA.SDR ABXA020265Door Frame · crackedCRACKED IN BEND RADIUS AT LEFT UPPER VENTRAL DOOR CORNER. CRACK LENGTH APPROXIMATELY 1.25 INCH IN LENGTH. REPAIRED CRACK IAW DC-9 SRM 51-10-02.SDR QXEA0201699Stop · chafedPDX - CARGO DOOR LOWER AFT STOP FITTING IS CHAFED. REPAIRED IAW DHC-8 200 AMM 52-30-00, PAGES 507-508, PARAGRAPH 3C.SDR AALA20021437Shear Tie · crackedTUL - FOUND SHEAR TIE CRACKED AFT SIDE OF FS 1451 FRAME AFT OF LONGERON 2R. REMOVED AND REPLACED CRACKED SHEAR TIE AT 2R AND 1451 PER SRM 53-01. (M)SDR ABXA020294Shear Tie · corrodedFORWARD CARGO LOWER LOBE, STATION 742, BETWEEN STRINGERS 37 - 39 RIGHT, AND STRINGER 38 LEFT, CORRODED SHEAR TIES. REPLACED SHEAR TIES IAW SRM 51-40-02.SDR ASAA0240142Shear Tie · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON SHEAR TIE AT BS 747 BETWEEN STRINGER 26 LEFT AND 27 LEFT. REMOVED AND REPLACED IAW SRM. (M)SDR ASAA0240141Shear Tie · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON SHEAR TIE AT BS 768 BETWEEN STRINGER 26 RT AND 27 RT. REMOVED AND REPLACED SHEAR TIE PER SRM. (M)SDR ASAA0240140Shear Tie · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON SHEAR TIE AT BS 787 RBL 17 BETWEEN STRINGER 25 RT AND 26 RT. REMOVED AND REPLACED IAW SRM. (M)SDR F3LA200200375Sill · corrodedDURING C 4 CHECK, REAR GALLEY L 2 MOP SILL WAS FOUND TO HAVE CORROSION. NEW MOP SILL WAS INSTALLED IAW SRM 51-40-02.SDR F3LA200200374Door Frame · corrodedDURING C 4 CHECK, CORROSION WAS FOUND AT THE AFT ENTRY DOOR FRAME AND CUT OUT AREA. CORROSION WAS WITHIN LIMITS AND THE AREAS WERE TREATED, PRIMED AND PAINTED FOLLOWING BLENDING IAW SRM 53-60-15, DETAIL VIII, AND SOPM 20-41-02.SDR AAL2003F00005Window Frame · crackedWINDOW FRAME CRACKED LOWER FORWARD CORNER, STA 984 LEFT SIDE E58 NR4426956. CRACK LENGTH .5000 INCH AT CABIN/FUSELAGE. INSTALLED DOUBLER FOR WINDOW FRAME REPAIR ON LOWER FORWARD CORNER STA. 984 LT SIDE IAW AARD.SDR AALA20021528Door Frame · corrodedTUL - FOUND INTERIM REPAIR ACCOMPLISHED ON AFT CARGO BEAM CORROSION, STATION 1174. REPLACED AFT CARGO DOOR CUT OUT, LOWER BEAM PER SRM 53-01-00. (M)SDR AALA20021493Door Frame · corrodedTUL - FOUND CORROSION AROUND FASTENERS ON DOOR BEAM AND AROUND 2 BOTTOM DOOR STOPS ON BEAM, FS 1155-1212. REMOVED CORROSION TREATED AND PRIMED, INSTALLED DOUBLER PER SRM 53-10-00-3. (M)SDR AWXA200201056Crease Beam · crackedDURING C-20 CHECK A 1/2 INCH CRACK WAS FOUND ON CREASE BEAM STRINGER 17 LT, BS 360 - BS 380. MAINTENANCE REMOVED WEBS BETWEEN BS 360 TO BS 400 AND BS 400 TO BS 420; CUT STRINGER 17 AT BS 396; FABRICATED A REPAIR ANGLE; INSTALLED STRINGER REPAIR AND WEBS IAW B7SDR 2002UALA01546Crease Beam · corrodedLEFT HAND CREASE BEAM WEB CORRODED BETWEEN BODY STATION 639 AND BODY STATION 663. MAJOR REPAIR ACCOMPLISHED. REPLACED WEB.SDR QXEA0201663Threshold · gougedPDX - GOUGE AT CARGO DOOR THRESHOLD FLOOR SUPPORT ANGLE, X5540., Y38L, Z98.5. REPARIED IAW DHC-8 200 SRM 51-20-11.SDR 2002UALA01539Crease Beam · corrodedRIGHT HAND CREASE BEAM WEB CORRODED BETWEEN BODY STATION 616 AND 639. MAJOR REPAIR ACCOMPLISHED. NEW WEB INSTALLED.
Back to JASC 5310