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 SWAA041605Door Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND R1 DOOR CUTOUT AFT FRAME DOOR, CRACKED. REPAIRED DOOR FRAME PER SRM.SDR GTIA040617Door Frame · corrodedFTW - FOUND AFT AIRSTAIR DOOR JAMBS AFT WEB CORRODED. CUT OUT PORTION OF CRACKED WEB. FABRICATED WEB. INSTALLED WEB. (M)WEBSDR ASAA0480467Beam · corrodedOKC - FOUND DURNG C-CHECK, AFT CARGO BAY DOOR JAMB FORWARD BEAM IS CORRODED ON THE INBOARD SLIDE AROUND NUMEROUS RIVETS AT FS 1155 TO 1211. REMOVED DAMAGE AND SPOT FACED AROUND FIVE FASTENERS PER EA 5310-02379. (M)SDR SWAA041584Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE IN AFT CARGO COMPARTMENT BS 807, LBL 7, CORRODED. REPAIRED SHEAR TIE PER SRM.SDR SWAA041581Crease Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CREASE BEAM AT R2 DOOR, CORRODED. REMOVED AND REPLACED CREASE BEAM SECTION PER SRM.SDR SWAA041571Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND AFT CARGO COMPARTMENT SHEAR TIE AT BS 807, LBL 7, CORRODED. REPAIRED SHEAR TIE PER SRM.SDR 2004UALA00542Crease Beam · corrodedCABIN FLOOR CREASE BEAM WEB CORRODED ON UPPER SURFACE FROM STA 968.5 TO 969.5, RBL 70 - RBL 71. MAJOR REPAIR ACCOMPLISHED. REPAIRED WEB WITH DOUBLER.SDR 2004UALA00538Shear Tie · damagedSHEAR TIES WERE FOUND DAMAGED OR HAD EXCESSIVE GAP BETWEEN SKIN AND SHEAR TIE AT STA 727 S24L-S25L, 727D S24L-S25L, 727C S25R-S26R, 727D S25R-S26R, 727E S24L-S25L AND 767 S24L-S25L. *S/D* MAJOR REPAIR ACCOMPLISHED. REPAIRED SHEAR TIES.SDR 2004UALA00533Beam · corrodedAFT PIT SILL BEAM HAD CORROSION. REPLACED LOWER SILL BEAM WEB.SDR SWAA041556Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB AT BS 380 + 16, STRINGER 17L, CORRODED. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR SWAA041552Door Frame · crackedDURING SCHEDULED D-CHECK, FOUND AFT CARGO DOOR AFT FRAME CUTOUT AT NR 5 DOOR STOP, CRACKED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR 2004UALA00523Doubler · cutSTRAP DOUBLERS ARE CUT AT STR 26R, BETWEEN STA 727C AND 727D. REPLACED STRAP DOUBLERS.SDR 2004UALA00521Shear Tie · misrepairedSTATION 787 SHEAR TIE BETWEEN STR 2L AND 27R HAS NO EDGE DISTANCE ON PREVIOUS REPAIR. REPAIRED SHEAR TIE.SDR 2004UALA00519Shear Tie · damagedSTATION 727A INBOARD OF STRINGER 27L SHEAR TIE HAD EXCESSIVE MATERIAL LOSS. REPLACED SHEAR TIE.SDR SWAA041543Stop Fitting · crackedDURING SCHEDULED D-CHECK, FOUND BS 303.9 DOOR CUTOUT FRAME FWD STOP FITTING, CRACKED. REPAIRED DOOR CUTOUT FRAME FWD STOP FITTING PER SB.SDR DL757040502Door Frame · corrodedFUSELAGE C2 DOOR OPENING FRAME AND SILL FS 1440, SILL CHORD REPLACEMENT AND FRAME SPLICE REPAIR. THE OUTER CHORD OF THE LOWER SILL BEAM OF THE C2 DOOR OPENING WAS FOUND WITH SEVERAL AREAS OF CORROSION AND REQUIRED REPLACEMENT. TO FACILITATE REPLACEMENT, THE SDR SWAA041541Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB AT BS 847 TO BS 867, LBL 65 TO LBL 70, CORRODED. REMOVED AND REPLACED CREASE BEAM WEB SECTION PER SRM.SDR USAA040265Beam · corrodedBFM - FOUND BEAM CORRODED 2 INCHES BY 1 INCH BY .068 INCH AREA, FLOOR SUPPORT, FRAME 64-66, Y1292, -Z240. REMOVED AND REPLACED BEAM PER SRM 53-00-15. (M)SDR ASAA0480462Door Frame · crackedOKC - DURING C-CHECK, FOUND NLG CUTOUT LONGITUDINAL FRAME IS CRACKED ON RIGHT SIDE AT TOP FASTENER HOLE. STOP DRILLED AND INSTALLED REPAIR ANGLE AND SHIM PER SRM 53-05. (M)SDR ASAA0480461Door Frame · crackedOKC - DURING C-CHECK, FOUND NLG CUTOUT LONGITUDINAL FRAME IS CRACKED ON LEFT SIDE AT TOP FASTENER HOLE. STOP DRILLED AND INSTALLED REPAIR ANGLE AND SHIM PER SRM 53-05. (M)SDR 04FDEA01532Door Frame · corrodedFORWARD CARGO DOOR CUTOUT, FORWARD LOWER CORNER WEB IS CORRODED FS 895, RBL 52. REMOVED DAMAGED FRAME AREA IAW DC10 SRM 53-50-00 VOL 1. FABRICATED SPLICE PLATE AND INSTALLED REPAIR DOUBLERS AND SPLICE PLATE IAW DC10 SRM 53-50-00 VOL 2.SDR UPS04842477Window Frame · corrodedINSPECTION TYPE:N/A SEVERAL AREAS OF CORROSION ON CTR WINDSHIELD LOWER FRAME. CHECKED CORROSION PITTING WITH DIAL DEPTH GAUGE, DEEPEST FITTING IS .020 REMOVED ALL PITTING IAW SRM 51-1-4-8. ULTRASOUND AREAS. FOUND .077 REMAINING. BLEND CORROSION IAW SRM 53-02-SDR USAA040262Beam · corrodedBFM - FOUND BEAM CORRODED 4.8 INCH LONG BY 1.8 INCH WIDE BY .051 INCH DEEP, Z240 BETWEEN FS 13 AND FS 18 BL +Y503.2. INSTALLED NEW BEAM PER SRM 53-11-14, FIG 103. (M)SDR SWIA200413379Beam · crackedFUSELAGE VERTICAL BEAM LWR I/B AND O/B FLANGE CRACKED AT FS 559 LBL 9. DISCOVERED DURING C-CHECK INSPECTION. REPAIRED BEAM IAW CRJ REO 601R-53-41-057 REV. NC.SDR SWIA200413378Beam · crackedFUSELAGE FS 280 RBL 9 LWR FLANGE CRACKED ON TRANSVERSE. DISCOVERED DURING C-CHECK INSPECTION. REPAIR BEAM IAW CRJ REO 601R-53-11-171 REV. NC.SDR ASAA0410273Shear Tie · corrodedPAE - FOUND CORROSION ON SHEAR TIE. REMOVED CORROSION AND REPAIRED WEB. (M)SDR ASAA0410272Beam · corrodedPAE - FOUND CORROSION ON LONGITUDINAL BEAM. REMOVED CORROSION AND REPAIRED LONGITUDINAL BEAM. (M)SDR SWAA041508Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB AT BS 946, STRINGER 17R, CORRODED. REMOVED AND REPLACED CREASE BEAM WEB SECTION PER SRM.SDR IXXA0400087SDoor Frame · crackedDURING A ROUTINE C CHECK INSPECTION, FOUND FWD ACCY COMPT FRAME CRACKED 1" AT STA 55.000, 1-24R. REPAIRS WERE ACCOMPLISHED BY PERFORMING MAJOR REPAIRS IAW DC8 SRM 53-2-0 FIG 2. REMOVED FASTENERS IAW DC8 SRM 51-1-21 PAGES 1, 2. REMOVED DAMAGED FRAME IAW DC8 SDR C2XA04SH318Beam · corrodedSHV - DURING C-CHECK THE CARGO DOOR LOWER CUTOUT BEAM WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BEAM IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR MWEA040081Door Frame · corrodedAFT BAG PIT DOOR JAMB WEB AT STATION 1160 BETWEEN LONGERON 28 RIGHT AND 29 RIGHT HAS AREAS OF CORROSION AROUND ACCESS HOLE. FABRICATED AND INSTALLED WEB.SDR SWAA041474Crease Beam · crackedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM CHORDS AT BS 360 TO BS 380, LBL 65, BS 375 TO BS 380, LBL 70, CRACKED. REMOVED AND REPLACED CREASE BEAM CHORDS PER SRM.SDR UPS04842480Longeron · corrodedINSPECTION TYPE: C-2, FWD BAG PIT, L28L CORROSION BETWEEN FS 320 & 340. REMOVED CORR FROM L28L SIDE OF VERTICAL LEG AT FS 325, 330 & 335. ORIG THICKNESS VERTICAL LEG .063 IAW DAC DWG 9754913 MAT'L REMOVED .015, AMT REMAINING .048. OUT OF LIMITS. FAB -31 REPSDR 04FDEA01411Door Frame · corrodedFORWARD CARGO PIT AT DOOR CUTOUT STATION 1002 CHORD FOUND CORRODED INSIDE TORQUE BOX. REMOVED CORROSION IAW DC10 SRM 53-00-01 VOL 2, FOUND TO BE OUT OF LIMITS, FABRICATED ANGLE IAW DC10 SRM 51-21-01 VOL 1 AND 53-50-00 VOL 2. INSTALLED TWO STRAPS AND INTERCOSSDR 04FDEA01398Door Frame · corrodedFORWARD CARGO DOOR CUTOUT, AFT LOWER CORNER, WEB CORRODED, APPROX FS 1002, RBL 52. REMOVED CORROSION IAW DC10 SRM 51-21-01 VOL 2, OUT OF LIMITS IAW DC10 SRM 53-00-01 VOL 1. INSTALLED NEW FRAME SECTION AND REPAIR DOUBLERS AND ANGLE SPLICES IAW DC10 SRM 53-13-SDR 04FDEA01382Shear Tie · corrodedCORROSION (C53-111-01, 2) FWD CARGO BAY SHEAR TIE ON FRAME 720 STR 26 LT IS CORRODED. REMOVED CORROSION ON SHEAR TIE ON FRAME STA 720, STR 26 LT, FWD CARGO BAY. REMOVED .017 3 X 1 INCH FROM .050, OUT OF LIMITS. REMOVED DAMAGED SHEAR TIE, LOCATED, DRILLED, ISDR 04FDEA01378Shear Tie · corrodedAFT CARGO COMPT HAS A CORRODED SHEAR TIE AT FS 970 STR 28L - 29L. FABRICATED SHEAR TIE ON TRAVELER T4/432278 & FABRICATED FLOOR SUPPORT ON TRAVELER T4/430988. REPAIRED & INSTALLED SHEAR TIE AT FS 970 STR 28L - 29L IAW SRM B727 SRM 53-10-4 PAGE 46.SDR SWIA200413466Angle · crackedFS 700 AFT EQUIPMENT COMPARTMENT DOOR CUTOUT RIGHT ANGLE CRACKED. REPAIRED ANGLE IAW CRJ SRM 51-31-00 PAGE 3 TO PAGE 5, 51-40-11, 51-42-06, 51-23-00.SDR AWXA200400647Shear Tie · crackedLCQ - MAJOR REPAIR - DURING C-19 CHECK A .875 INCH CRACK WAS FOUND IN STRINGER SHEAR TIE BS 500A, STR 16 RT. MAINTENANCE REMOVED DAMAGED STRINGER SHEAR TIE CLIP AT BS 500A, STR 16 RT; FABRICATED A NEW REPLACEMENT SHEAR TIE PER DWG 69-35350; INSTALLED REPAIR PSDR C1HA200492008Shear Tie · corrodedSTA 1148 STR 27L SHEAR TIE CORROSION.SDR DLM88040701Beam · corrodedCORROSION ON C2 CARGO DOOR JAMB BEAM. REMOVED CORROSION FROM C2 CARGO BIN LOWER DOOR JAMB BEAM AND WAS FOUND OUT OF LIMITS IAW SRM 53-05D FIG 63 SHEET 2. REPAIRED DAMAGED AREA PER SRM 53-05D FIG 63.SDR DLM88040700Beam · corrodedCORROSION ON C3 CARGO BIN LOWER DOOR JAMB BEAM. REMOVED CORROSION FROM C3 CARGO DOOR JAMB BEAM AND WAS FOUND TO BE OUT OF LIMITS IAW SRM 53-05D FIG 63 SHEET 2. DOOR JAMB BEAM WAS REPAIRED IAW SRM 53-05D FIG 63.SDR 2004UALA00482Shear Web · crackedSTA 194 SHEAR WEB AT STR 17 RT IS CRACKED. MAJOR REPAIR ACCOMPLISHED. REPLACED SHEAR WEB.SDR 2004UALA00481Shear Web · crackedSTA 194 SHEAR WEB AT STR 17 LT IS CRACKED. MAJOR REPAIR ACCOMPLISHED. REPLACED SHEAR WEB.SDR SWAA041421Shear Tie · crackedDURING SPV, FOUND SHEAR TIE AT BS 500C, STRINGER 16R, CRACKED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA041417Shear Tie · crackedDURING SPV, FOUND SHEAR TIES AT BS 360, BELOW AND ABOVE STRINGER 14L, CRACKED. REMOVED AND REPLACED SHEAR TIES PER SRM.SDR C2XA04SH296Beam · corrodedSHV - DURING C-CHECK THE CARGO DOOR CUTOUT LOWER SILL WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SILL IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH293Buttstrap · corrodedSHV - DURING C-CHECK THE LEFT OMEGA BEAM BUTTSTRAP WAS FOUND TO BE CORRODED BETWEEN FRAMES 20 AND 21. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASAA0410268Shear Tie · damagedFOUND DAMAGED FASTENER HOLES ON SHEAR TIE. REPAIRED SHEAR TIE. (M)SDR ASAA0480423Shear Tie · corrodedDURING HV CHECK, FOUND SHEAR TIE IN AFT PIT AT STATION 1287, LONGERON 29L TO 29R IS CORRODED. REMOVED DAMAGE AND INSTALLED FRAME REPAIR SPLICE IAW 53-03. (M)
Back to JASC 5310