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 04FDEA02168Structure · crackedFORWARD TAIL CONE RIGHT HAND DOOR CUTOUT JAMB CRACKED. FORWARD TAILCONE RIGHT HAND DOOR CUT OUT CRACKED FRAMES AND DOUBLER REMOVED AS PER SRM 51-31-01 VOL II, AND NEW FRAMES AND DOUBLER INSTALLED AS PER SRM 51-35-01 VOL II.SDR C2XA04SH467Beam · corrodedDURING C CHECK THE CARGO DOOR CUTOUT LOWER BEAM WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BEAM IAW EMB 135 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA042109Shear Tie · crackedDURING SPV, FOUND SHEAR TIE AT BS 360, STRINGER 14R, CRACKED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWIA200413891Window Frame · crackedF/O'S SIDE FORWARD OF DV WINDOW FRAME 9 IS CRACKED. ITEM FOUND AT C-CHECK. COMPLIED WITH SB 120-53-0073 ON F/O'S SIDE FORWARD OF DV WINDOW AT FRAME 9 AS REQUIRED.SDR SWIA200413890Window Frame · crackedCAPTAIN'S SIDE FORWARD OF DV WINDOW FRAME 9 IS CRACKED. ITEM FOUND AT C-CHECK. COMPLIED WITH SB 120-53-0073 ON CAPTAIN'S SIDE FORWARD OF DV WINDOW AT FRAME 9 AS REQUIRED.SDR AWXA200400835Beam · corrodedMCN - MAJOR REPAIR - DURING B-04 CHECK EXFOLIATION CORROSION WAS FOUND ON BEAM Y1292 RIGHT FROM FR 67 TO FORWARD SIDE OF FR 68. MAINTENANCE REMOVED CORRODED SECTION OF BEAM Y1292 RT FROM FR 67 TO FR 68; FABRICATED A NEW REPLACEMENT SECTION OF BEAM PER DWG D53SDR AWXA200400834Beam · corrodedMCN - MAJOR REPAIR - DURING B-04 CHECK EXFOLIATION CORROSION WAS FOUND ON BEAM Y1292 RIGHT AT FR 68. MAINTENANCE REMOVED CORRODED SECTION OF BEAM Y1292 RIGHT AT FR 68; FABRICATED A NEW REPLACEMENT SECTION OF BEAM; INSTALLED REPAIR PART IAW A319 SRM 51-42-11 FSDR AWXA200400832Beam · corrodedMCN - MAJOR REPAIR - DURING B-04 CHECK EXFOLIATION CORROSION WAS FOUND ON BEAM Y1292 LEFT AT FR 68. MAINTENANCE REMOVED CORRODED SECTION OF BEAM Y1292 LEFT AT FR 68; FABRICATED A NEW REPLACEMENT SECTION OF BEAM; INSTALLED REPAIR PART IAW A319 SRM 51-42-11 FIGSDR AWXA200400831Beam · corrodedMCN - MAJOR REPAIR - DURING B-04 CHECK EXFOLIATION CORROSION WAS FOUND ON BEAM Y765 RIGHT AT FR 66. MAINTENANCE REMOVED CORRODED SECTION OF BEAM Y765 RIGHT FROM FR 64 TO FR 66; FABRICATED A NEW REPLACEMENT SECTION OF BEAM; INSTALLED REPAIR PART IAW A319 SRM 5SDR SWAA042092Crease Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND RT CREASE BEAM AT BS 727B +2 TO BS 727B + 12, CORRODED. REPAIRED CREASE BEAM PER SRM.SDR DXTA200400344Mount · failedAFTER TAKEOFF DOOR SEAL & CABIN DOOR ANNUNCIATOR ILLUMINATED, LOUD WIND NOISE FROM AROUND DOOR. ACCOMPLISHED AIR TURNBACK AND UPON LANDING THE MAIN ENTRANCE DOOR FELL OPEN. REPLACED AFT DOOR STRUT MOUNTING FRAMES IAW CESSNA 560XL B/P 6611267, BOTH DOOR CABLESDR SWAA042083Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM CORRODED AT BS 727A TO BS 727B, RT SIDE. REPAIRED CREASE BEAM PER SRM.SDR 04FDEA02159Crossbeam · crackedZONE 232 FRAME IS CRACKED UNDER CLS ADAPTER PLATE AT FR 23 BETWEEN SEAT TRACKS 1R & 2R. REPAIRED CRACKED FRAME 23 IAW A310-200 SRM 53-10-15 WITH REPAIR ANGLES AND FILLERS. WORK DOCUMENTED ON NRC N00411.SDR 2004UALA00677Shear Tie · crackedSHEAR TIE BETWEEN STR 27L AND 28L AT BS 1400 IS CRACKED AND CORRODED. REPLACED SHEAR TIE.SDR SWAA042064Structure · crackedDURING SCHEDULED D CHECK, FOUND STRUCTURE AT BS 400 TO BS 440, STRINGER 8L, CRACKED. REMOVED AND REPLACED STRUCTURE SECTION PER SRM.SDR SWAA042050Door Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME WEB AT FWD ENTRY DOOR CUTOUT BS 303.9, STRINGER 16L, CRACKED. REMOVED AND REPLACED FRAME WEB SECTION PER SB AND SRM.SDR 2004UALA00672Beam · corrodedR4 DOOR LWR SILL BEAMS CORRODED FROM STA 1640 TO 1681. MAJOR REPAIRS ACCOMPLISHED. INSTALLED NEW SILL BEAMS.SDR SWAA042031Door Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD SERVICE DOOR FRAME, LOWER AFT CORNER CRACKED. REPAIRED FRAME SECTION PER SRM.SDR LR7A04067Window Frame · crackedDURING SCHEDULED C-5 INSPECTION, IAW JOB CARD HC5321, FOUND WINDSHIELD FRAME CRACKED AT FS 130, LBL 60, WL 251. REPAIRED IAW SRM SMP 583 FIG 53-30-25. DRC 2013.SDR SWIA200413619Beam · crackedFUSELAGE VERTICAL BEAM LOWER FLANGE CRACKED FS 559 LBL 9 O/B. ITEM FOUND AT C-CHECK. REPAIRED IAW CRJ REO 601R-53-41-057 REV. NC.SDR 04FDEA02087Crease Beam · corrodedCORROSION ON CREASE BEAM BS 1080 LBL 65 WL 208. CORROSION ON CREASE BEAM BS 1080, LBL 65, WL 208 FOUND TO BE OUT OF LIMITS PER SRM 53-10-1. REMOVED DAMAGED CREASE BEAM. INSTALLED NEW CREASE BEAM IAW 51-30-2, 51- 20-4.SDR 04FDEA02085Crease Beam · corrodedCORROSION ON CREASE BEAM BS 1010 - 1050 LBL 65 WL 208. CORROSION ON CREASE BEAM BS 1010 TO BS 1050, LBL 65, WL 208 FOUND TO BE OUT OF LIMITS PER SRM 53-10-1. REMOVE DAMAGED CREASE BEAM, INSTALLED NEW CREASE BEAM IAW SRM 51-30- 2, 51-20-4.SDR ASOA04549Stanchion · bentDURING A C-CHECK IN YUL, THE RIGHT STANCHION UNDER THE FLOORBEAM AT FRAME 36 WAS FOUND TO BE BENT BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE RIGHT STANCHION UNDER THE FLOORBEAM AT FRAME 36 IAW SRM 51-25-00. (M)SDR 2004UALA00668Crease Beam · corrodedMAIN CABIN STA 760-770, CREASE BEAM AT LBL60 CORRODED. MAJOR REPAIR ACCOMPLISHED. INSTALLED AN EXTRUDED SECTION REPAIR.SDR 04FDEA02073Crossbeam · deformedAFTER REMOVAL OF CLS ADAPTER AT FR65 BETWEEN LT SEAT TRACK 3 & 4. DEFORMATION OF CROSS BEAM FLANGE WAS FOUND TO BE AT .250 INCH, REF A300/600 SRM 53-10-15 FIG 205, MAX DEFORMATION IS .197 INCH, REF SNRM N00405. REPAIRED IAW FED EX EA 6-5310-80084.SDR UPS04442815Door Frame · crackedINSPECTION TYPE: C, L1 DOOR AFT LOWER CORNER FRAME FOUND CRACKED. LWR CORNER FRAME REPAIRED IAW SRM 52-10-02SDR UPS04442784Shear Tie · crackedINSPECTION TYPE:C, AFT CARGO COMPT - BS 1480 LT PRESSURE BULKHEAD LOWER CHORD ATTACH SHEAR TIE FOUND CRACKED AT STR 35L TO STR 36L. AFT CARGO COMPT BS 1480 LT BULKHEAD LOWER CHORD ATTACH SHEAR TIE AT S35L TO S36L AREA REPLACED AS PER SRM 51-10-01.SDR UPS04442773Shear Tie · crackedINSPECTION TYPE:C, COCKPIT - BS 340 LT FRAME TIE CLIP FOUND CRACKED AT STR 8. COCKPIT BS 340 LT FRAME STR 8 TIE CLIP REPLACED AS PER SRM 51-10-01 PG 8.SDR UPS04442772Shear Tie · crackedINSPECTION TYPE: C, BS 420 LT FRAME TIE CLIP FOUND CRACKED AT STR 7. BS 420 LT FRAME STR 7 TIE CLIP REPLACED AS PER SRM 51-10-01 PG 8.SDR QXEA200400522Door Frame · crackedCRACKED BRACKET AT MAIN CABIN DOOR APERTURE FLOOR LEVEL STATION 240.500. REPAIRED IAW DHC-8-200 SRM 51-40-11.SDR SWAA041980Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE AT BS 947, LBL 8, CORRODED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA041979Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB AT RIGHT BS 460 TO RIGHT BS 480, CORRODED. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR AWXA200400820Beam · corrodedMCN - MAJOR REPAIR - DURING B-04 CHECK EXFOLIATION CORROSION WAS FOUND ON BEAM Y1292 RT AT FR 66. MAINTENANCE REMOVED CORRODED BEAM Y1292 RT FROM FR 65 TO FR 67; FABRICATED A NEW REPLACEMENT SECTION OF BEAM; INSTALLED REPAIR PART IAW A320 SRM 51-42-11 PG 6-7.SDR AWXA200400784Beam · corrodedMCN - MAJOR REPAIR - DURING B-04 CHECK EXFOLIATION CORROSION WAS FOUND ON BEAM Y1292 RIGHT BETWEEN FR 68 AND FR 69. MAINTENANCE REMOVED CORRODED BEAM Y1292 RIGHT FROM FR 68 TO FR 69, FABRICATED A NEW REPLACEMENT BEAM; INSTALLED REPAIR PART IAW A319 SRM 51-42-SDR AWXA200400783Beam · corrodedMCN - MAJOR REPAIR - DURING B-04 CHECK EXFOLIATION CORROSION WAS FOUND ON BEAM Y1292 RT BETWEEN FR 66 AND FR 68. MAINTENANCE REMOVED CORRODED BEAM Y1292 RT FROM FR 66 TO FR 68, FABRICATED A NEW REPLACEMENT BEAM; INSTALLED REPAIR PART IAW A319 SRM 51-42-11 PG SDR AWXA200400782Beam · corrodedMCN - MAJOR REPAIR - DURING B-04 CHECK EXFOLIATION CORROSION WAS FOUND ON BEAM Y1292 LEFT AT FR 66. MAINTENANCE REMOVED CORRODED SECTION OF BEAM Y1292 LEFT AT FR 66; FABRICATED A NEW REPLACEMENT BEAM; INSTALLED REPAIR PART IAW A319 SRM 51-42-11 PG 6-7.SDR 04FDEA02054Crossbeam · corrodedZONE 152, AFT CARGO FLOOR CROSS MEMBER BEAM, RT CENTER AT FR 58 CORRODED. REMOVED CORRODED BAD SECTION IAW A310-200 SRM 53-10-15 FIG 207. FABBED REPAIR ANGLE AND FILLER IAW A310-200 SRM 53-10-15. LOCATED, DRILLED, DEBURRED, AND COUNTERSUNK IAW A310-200 SRM SDR ASAA0410324Shear Tie · corrodedPAE - FOUND AFT CARGO SHEAR TIE IS CORRODED. REMOVED AND REPLACED SHEAR TIE. (M)SDR AWXA200400781Beam · corrodedMCN - MAJOR REPAIR - DURING B-04 CHECK EXFOLIATION CORROSION WAS FOUND ON BEAM Y1292 RIGHT BETWEEN FR 66 AND FR 67. MAINTENANCE REMOVED CORRODED BEAM Y1292 RIGHT FROM FR 66 TO FR 67, FABRICATED A NEW REPLACEMENT BEAM PER DWG D534-72172; INSTALLED REPAIR PART SDR AWXA200400780Beam · corrodedMCN - MAJOR REPAIR - DURING B-04 CHECK EXFOLIATION CORROSION WAS FOUND ON BEAM Y1292 RIGHT AT FR 68. MAINTENANCE REMOVED CORRODED BEAM Y1292 RIGHT AT FR 68, INSTALLED NEW REPLACEMENT BEAM IAW A319 SRM 51-42-11 FIG 12 & 18.SDR AWXA200400779Beam · corrodedMCN - MAJOR REPAIR - DURING B-04 CHECK EXFOLIATION CORROSION WAS FOUND ON BEAM Y1292 RIGHT AT FR 66. MAINTENANCE REMOVED CORRODED BEAM Y1292 RT AT FR 66; FABRICATED A NEW REPLACEMENT BEAM; INSTALLED REPAIR PART IAW A319 SRM 51-42-11 PG 1-2.SDR SWAA041950Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE AT BS 794, RBL 7 TO RBL 11, CORRODED. REPAIRED SHEAR TIE PER EA.SDR C2XA04SH456Crossbeam · corrodedSHV - DURING C-CHECK THE CROSSBEAM AT FRAME 23 FROM THE SERVICE DOOR AFT SILL TO THE RIGHT HAND OMEGA BEAM WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED CROSSBEAM IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERSDR ASAA0410329Shear Tie · crackedPAE - FOUND CRACK ON FRAME SHEAR TIE REPAIR. REPLACED SHEAR TIE. (M)SDR ASAA0410321Shear Tie · damagedPAE - FOUND DAMAGED SHEAR TIE. REMOVED DAMAGE, FABRICATED AND INSTALLED SHEAR TIE REPAIR. (M)SDR ASAA0410328Shear Tie · corrodedPAE - FOUND CORROSION ON FRAME SHEAR TIE REPAIR. REMOVED AND REPLACED FRAME SECTION. (M)SDR SWAA041942Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE AT BS 927, STRINGER 27L, CORRODED. REPAIRED SHEAR TIE PER SRM.SDR ASAA0410316Shear Tie · corrodedPAE - FOUND CORROSON ON FRAME SHEAR TIE REPAIR. REMOVED CORRODED SHEAR TIE, FABRICATED REPLACEMENT PARTS AND INSTALLED. (M)SDR 2004UALA00648Shear Web · corrodedFLOOR SHEAR WEB FROM BS 1680 TO 1720 AFT OF DOOR 4 RIGHT IS CORRODED. MAJOR REPAIR ACCOMPLISHED. REPAIR DOUBLER INSTALLED.SDR 2004UALA00647Crease Beam · corrodedCREASE BEAM BETWEEN BS 960 AND 984 AND RBL 64R TO 70R CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED A REPAIR DOUBLER.
Back to JASC 5310