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 SWAA050075Door Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD SERVICE DOOR FRAME NR 3 AFT DOOR STOP CASTING CUTOUT CRACKED. REPAIRED DOOR FRAME PER TR T1-152-003.SDR SWAA050071Structure · crackedDURING SCHEDULED C4 CHECK, FOUND FWD ENTRY DOOR CUTOUT LOWER HINGE BOX, CRACKED. REMOVED AND REPLACED FWD ENTRY DOOR HINGE BOX PER SRM.SDR 0500065523Support Beam · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK SUPPORT BEAM AT BS 365 RBL 23 TO RBL 27. REPAIRED PER EA 55-202244.SDR 05FDEA00069Shear Tie · corrodedBS 720A, RBL 25, WL 153 SHEAR TIE CORROSION. REPAIRED PER SRM 53-10-4.SDR 05FDEA00070Shear Tie · corrodedBS 720C, STR 28L - STR 27L CORROSION ON SHEAR TIE. *S/D* REPAIRED SHEAR TIE PER SRM 53-10-4.SDR AWXA200500055Beam · corrodedDURING C-4 CHECK EXFOLIATION CORROSION WAS FOUND ON R-2 DOOR LOWER SILL BEAM AT FS 68 - 4 INCHES. MAINTENANCE REPAIRED R-2 DOOR LOWER SILL BEAM AT FS 68 - 4" IAW A320 SRM 53-41-14, FIG 201.SDR 05FDEA00073Crease Beam · corrodedCORROSION ON CREASE BEAM BS 450, RBL 60, WL 208. *S/D* REPAIRED IAW SRM 53-10-1.SDR CALA0500006Door Frame · crackedINSPECTION FOUND A 2 INCH CRACK IN EXTERNAL POWER ACCESS DOOR AFT FRAME FLANGE AT STA 243.7-251.6, RBL 20 - RBL 21. REPAIRED IAW ECRA 5330-03402.SDR UPS05843789Web · crackedINSPECTION TYPE:C1, R1 DOOR JAMB TORQUE WEB CRACKED ABOVE UPPER DOOR HINGE ARM STA 150- 155, NEXT TO L14R. CUT OUT DAMAGE, NDT VERIFIED REF NDT/SPM06-10-01.001. FAB DOUBLER FROM SHT2024T3-.050, TREAT, PRIME & INSTALLED SAME REF SRM 53-2-0 FIG 1F, 51-1-8, 51-SDR 20030784Window Frame · crackedDURING ROUTINE STRUCTURAL INSPECTION, ALL THREE EMERGENCY EXIT WINDOW PANS WERE FOUND TO HAVE CRACKS AROUND THE RADIUS. WINDOW PANS WERE REPLACED, AIRCRAFT RETURNED TO SERVICE.SDR 2005UALA00048Shear Web · crackedLEFT SHEAR WEB AT STA 194 IS CRACKED AT WL 207. REPLACED SHEAR WEB.SDR UPS05843834Fitting · crackedLWR CARGO PIT STA 1140 L34R UPPER FWD FITTING CRACKED ON THE FRAME. REMOVED AND REPLACED FITTING IAW SRM 51-1-20D.SDR UPS05843788Web · crackedINSPECTION TYPE:C1, L1 DOOR FWD TORQUE WEB CRACKED BELOW SWITCH PANEL, NEAR L16L STA 25. STOP DRILLED CRACK AND NDT VERIFIED PER 53-2-0, NDT/SPM06-10-01.001. FAB REPAIR ANGLE FROM SHT7075T6-.063, TREAT, PRIME AND INSTALL SAME REF SRM 53-2-0, 51-1-8, 51-1-21,SDR A6WA200540012Plug · damagedMWC - 170 PANEL 131AL HAS DAMAGED FREEZE PLUG AT NR 2 IN CLOCKWISE POSITION, EXCEEDS DIAMETER OF .343 INCH PER BOMBARDIER REO 601R-53-11-162. (M)SDR UPS05443691Shear Tie · crackedINSPECTION TYPE: C, FWD CARGO COMPT SUPPORT FRAME SHEAR TIE FOUND CRACKED AT STA 780 STR 33 TO STR 34. SHEAR TIE REPAIRED PER SRM 53-10-04 FIG 4.SDR 05FDEA00047Shear Tie · damagedREPAIR SHEAR TIE AT BS 380 BETWEEN STR 14 & 15 LT TO ACCOMPLISH 9G MOD. REPAIRED PER SRM 53-10-4.SDR 05FDEA00048Shear Tie · damagedREPAIR SHEAR TIE AT BS 380 BETWEEN STR 15 & 16 LT TO ACCOMPLISH 9G BARRIER MOD.SDR SWIA200514465Beam · crackedMAIN FUSELAGE FS 280 AT RBL 9.0 LOWER FLANGE CRACKED ON TRANSVERSE BEAM AND OUTBOARD CLIP CRACKED. ITEM FOUND AT C-CHECK INSPECTION. REPAIRED IAW CRJ REO 601R-53-11-171 REV A.SDR UPS05443693Shear Tie · crackedINSPECTION TYPE:C M/D - FRAME BS 1438 SHEAR TIE CRACKED BTN S-23L/S-24L. M/D BS 1438 BETWEEN STR 23L/STR 24L FRAME SHEAR TIE REPAIR CARRIED OUT IAW SRM 53-10-04 FIG 4.SDR SWAA050042Shear Tie · damagedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE AT BS 747, RBL 6 TO LBL 6, DAMAGED. REMOVED AND REPLACED SHEAR TIE SECTION PER SRM.SDR 05FDEA00024Shear Tie · corrodedBS 1148 CORROSION ON SHEAR TIE AND SKIN BS 1148 BETWEEN STRINGERS 28R & 29R. REMOVED CORROSION SHEAR TIE FOUND TO BE OUT OF LIMITS PER SRM 53-10-1 REPAIRED PER SRM 53-10-04.SDR CA050209002Crossbeam · corroded(CAN) DURING ONGOING C-CHECK OF A/C 5 CRACKS AND SLIGHT CORROSION WERE FOUND ON FS 280.0 CROSSBEAM P/N CC670-34175-7 AND ANGLE P/N CC670-33292-9 AT LBL 9.0 AND RBL 9.0. NOTE: REPAIR TO BE PERFORMED WITH ACOMBINATION OF GEN REOS 670-53-11-045, -046, -047, -05SDR UPS05843743Beam · crackedINSPECTION TYPE:C3 AFT PRESSURE BULKHEAD HORIZONTAL -J- BEAM CRACKED, AFT SIDE, NEAR L13R. STOP DRILLED CRACK, VERIFIED REF SPM06-10-01.001. FABRICATED REPAIR PARTS FROM SHT 7075-0-.100. HEAT TREATED TO T6. INSTALLED REPAIR REF EO DC8-5310-6598-C.SDR DHL2004809514Crossbeam · corrodedAFT ACCY COMPT CROSS BEAM CORRODED STA 1680.000 RBL 12 (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW SRM 51-2-1 FIG 1 (SHEET 7, 12), TR 51-130. REMOVED CORROSION IAW SRM 51-1-8 PG 17-18. FOUND OUT OF LIMITS IAW SRM 53-2-0 PG 2P. CUT OUT DAMAGED SECTION IAW SRSDR USAA050074Crease Beam · crackedPIT - FOUND CREASE BEAM CRACKED 2.5 INCHES, AFT OF FRAME 616 RT SIDE CREASE BEAM. MODIFIED PART INSTALLED PER TYPICAL REPAIR 53-10-02 REV A. (M)SDR USAA050059Door Frame · corrodedPIT - FOUND FRAME CORRODED 1 INCH IN DIAMETER, STATION 492.4, FORWARD CARGO DOOR FRAME AFT LOWER STOP FITTING. CUT OUT DAMAGE, TRIMMED ANGLE TO SIZE AND SHAPE, FABRICATED FILLER, TREATED, PRIMED PER SRM 51-70-11. (M)SDR LJJ2005F00000Strap · corrodedCORROSION FOUND AT HOLE B, LWS 90.35, DURING INSPECTION OF LT S AND K SPAR STRAP. DER WAS CONSULTED FOR REPAIR. RECOMMEND CLOSE INSPECTION OF HOLES DURING REPETITIVE INSPECTIONS. ALSO RECOMMEND THE USE OF AN ANTI-CORROSION LUBRICANT DURING BOLT INSTALLATIONSDR SWAA043728Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CORRODED AT BS 787, RBL 9, WL 148. REPAIRED SHEAR TIE PER SRM.SDR 2004UALA01264Crease Beam · corrodedCREASE BEAM WEB CORRODED UPPER SURFACE STA 1385 TO 1397, RBL 68-71.SDR 2004UALA01261Crease Beam · corrodedCREASE BEAM WEB UPPER SURFACE CORRODED FROM STA 1422 TO 1434, RBL 69-71.SDR 04FDEA03502Structure · delaminatedCENTER LANDING GEAR WORK PLATFORM AFT CENTER JOINT PIECE (UPPER) FOUND DELAMINATED. REPAIRED AS PER SRM 51-43-01 VOL II AND PAINTED AS PER SRM 51-21-02 VOL II. INSTALLED AS PER AMM 32-17-06.SDR 04FDEA03493Frame · damagedMAIN DECK, LT TRANSVERSE FRAME AT STA 535 FOUND DAMAGED IN TWO PLACES. MAIN DECK, LT TRANSVERSE FRAME AT STA 535 DAMAGE REPAIRED AS PER SRZ-53-503.SDR SWAA043725Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND AFT CARGO COMPT FRAME SHEAR TIE CORRODED AT BS 747, RBL 7 TO RBL 13. REPAIRED SHEAR TIE PER SRM.SDR SWAA043724Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND AFT CARGO COMPT FRAME SHEAR TIE CORRODED AT BS 807, LBL 5 TO RBL 5. REPAIRED SHEAR TIE PER SRM.SDR 2004UALA01255Crease Beam · corrodedCREASE BEAM WEB CORRODED STA 1406-1411, RBL 69-70 UPPER SURFACE.SDR 04FDEA03498Support Beam · corrodedFR 87 LT TO RT SIDE UPPER SUPPORT BEAM HAS 70 SQ INCH OF CORROSION IN THS BAY. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW SRM 53-10-00. REMOVED AND REPLACED BEAM IAW SRM 51-40-21 AND 51-74-10.SDR ASAA0480625Door Frame · crackedOKC - HV-CHECK, FORWARD ENTRY DOOR JAMB WEB CRACKED. REMOVED DAMAGED AREA AND INSTALLED DOUBLER. (M)SDR AWXA200500105Shear Tie · corrodedMCN - MAJOR REPAIR - DURING C-17 CHECK, EXFOLIATION CORROSION WAS FOUND ON SHEAR TIE AT BS 1006, BETWEEN STR 27 LT AND STR 27 RT. MAINTENANCE REMOVED CORRODED SHEAR TIE AT BS 1006, FROM STR 27 LT TO STR 27 RT; FABRICATED A NEW REPLACEMENT SHEAR TIE PER DWG 65SDR DHL2004809504Doubler · brokenLT ACCESS DOOR JAMB NR 91B UPPER INTERNAL DOUBLER BROKEN 0.500 (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW SRM 53-1-0 PG 1, SRM 53-3-1 FIG 1. REMOVED BROKEN INTERNAL DOUBLER IAW SRM 51-1-21 PG 1. FABRICATED NEW INTERNAL DOUBLER (AL2024-T3 0.063) IAW SRM 53-3SDR DHL2004809503Doubler · brokenRIGHT ACCESS DOOR JAMB NR 91D AFT INTERNAL DOUBLER BROKEN 0.500 (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW SRM 53-1-0 PG 1, SRM 53-3-1 FIG 1. REMOVED INTERNAL DOUBLER IAW SRM 51-1-21 PG 1. FABRICATED NEW INTERNAL DOUBLER (AL2024-T3 0.063) IAW SRM 53-3-1 FIGSDR SWAA043722Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND AFT CARGO COMPT SHEAR TIE CORRODED AT BS 787, RBL 8. REPAIRED SHEAR TIE PER SRM.SDR SWAA043717Door Frame · crackedDURING SCHEDULED D-CHECK, FOUND FWD CARGO DOOR CUTOUT FUSELAGE FRAME CRACKED AT BS 440, NR 5 DOOR STOP FITTING. REPAIRED FRAME PER ER.SDR 249TR0053Shear Tie · corrodedSHEAR TIE CORRODED IN AFT CARGO AT BS 986 AT STR 24RT. REPLACED SHEAR TIE PER SRM 51-10-1 AND SRM 51-30-2.SDR 249TR0038Shear Tie · corrodedSHEAR TIE AT STRINGER 22RT AT BS 1016 CORRODED. REPLACED SHEAR TIE PER SRM 51-10-1.SDR 04FDEA03460Door Frame · corrodedAFT CARGO DOOR AFT JAMB CORRODED AROUND FASTENERS 5 PLACES. AFT CARGO DOOR AFT JAMB CORRODED AREA REPAIR CARRIED OUT AS PER SRM 53-00-01 VOL I.SDR SWAA043694Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE AT BS 360, STRINGER 14R, CRACKED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA043692Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE AT BS 460, STRINGER 13L, CRACKED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR AWXA200500071Door Frame · crackedMCN - MAJOR REPAIR - DURING C-17 CHECK A .25 INCH CRACK WAS FOUND IN R-1 DOOR FRAME ON AFT SIDE AT 3RD DOOR STOP CUTOUT FROM BOTTOM BS 328, STR 14 RT. MAINTENANCE TRIMMED OUT CRACK IN R-1 DOOR FRAME AT 3RD DOOR STOP CUTOUT FROM BOTTOM BS 328, STR 14 RT; PERFOSDR 2004UALA01229Crease Beam · corrodedCABIN FLOOR, RT CREASE BEAM I/B CHORD ANGLE CORRODED AT BS 680 TO BS 740 BL 66R. *S/D* MAJOR REPAIR ACCOMPLISHED. REMOVED CORROSION FOUND OUT OF LIMITS. REMOVED CREASE BEAM I/B CHORD ANGLE AND REINSTALLED WITH NEW PART.SDR SWAA043676Beam · crackedDURING SCHEDULED D-CHECK, FOUND STUB BEAM AT BS 616, RBL 64, CRACKED. REPAIRED STUB BEAM PER ER.
Back to JASC 5310