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 C2XA03SH478Buttstrap · corrodedDURING C-CHECK THE AFT DIGITAL BUTTSTRAP AT FRAME 18 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA03683Crossbeam · corrodedDURING A C-CHECK IN BNA, THE CROSSBEAM AT FS 36 BETWEEN THE LEFT AND RIGHT SIDE WALLS WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REPAIRED THE CROSSBEAM AT FS 36 BETWEEN THE LEFT AND RIGHT SIDE WALLS IAW SRM 51-24-00 AND 51-25-01. (M)SDR ASAA0380817Shear Tie · corrodedOAK - DURING 15K CHECK, FOUND SHEAR TIE CORRODED AT FS 1257. REPLACED SHEAR TIE PER SRM 51-30-2. (M)SDR ASOA03610Support Beam · crackedDURING A C-CHECK IN MCN, THE CENTER ENGINE SUPPORT BEAM UPPER AND LOWER WEB AT BL 0 WAS FOUND CRACKED BEYOND LIMITS. MAINTENANCE IS REPAIRING THE CENTER ENGINE SUPPORT BEAM UPPER AND LOWER WEB AT BL 0 IAW ASA EO 600-53-0072. (M)SDR SWAA032634Crease Beam · corrodedDURING SCHEDULED D CHECK, FOUND CREASE BEAM CORRODED AT BS 727C+8, LT SIDE, BS 727B+8, RT SIDE. REPAIRED CREASE BEAM SECTIONS PER SRM.SDR 2003UALA00922Shear Tie · crackedCABIN SHEAR TIE CRACKED STA 597, STR 8L & 11L. MAJOR REPAIR ACCOMPLISHED. REPLACED SHEAR TIES.SDR SWAA032626Window Post · crackedDURING SCHEDULED 1/4D CHECK, FOUND RT COCKPIT WINDOW POST CRACKED AT UPPER INBD CORNER. REPAIRED WINDOW POST PER SRM.SDR DLM88040702Beam · corrodedCORROSION ON C2 LOWER JAMB BEAM REPAIRED C2 LOWER DOOR JAMB BEAM PER SRM 53-05 FIG 63. TREATED AND PAINTED AREA PER DELTA SRM 51-10-30.SDR DHL2003742503Plate · corrodedDURING C-CHECK, N/R 60481 UPPER CABIN SHEAR PLATE BS 1175 RBL 45 OLD TOILET DUMP CAP AREA CORRODED. DAMAGE FOUND TO BE OUT OF LIMIT IAW B-727 SRM 53-10 FIG 1. CUT OUT DAMAGE AREA AND FABRICATED DOUBLER FROM 7075 T6 .071 PO 9912380 DIM 10.5 INCH X 9 INCH AND SDR 2003UALA00921Crease Beam · corrodedSTA 967-986.5 CREASE BEAM AT R2 DOOR HAS CORROSION. MAJOR REPAIR ACCOMPLISHED. REPLACED CREASE BEAM.SDR SWAA032620Window Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND RT NR 2 PAX WINDOW FRAME CRACKED. REMOVED AND REPLACED RT NR 2 PAX WINDOW FRAME PER SRM AND ERO.SDR DHL2003802544Door Frame · damagedFWD PASSENGER DOOR JAMB UPPER FWD CORNER INTERIM REPAIR, STA 25.000 L-9L TO L-10L (MAJOR REPAIR). PERFORMED MAJOR REPAIR, SERVICE REWORK DWG SRO 8530021, DWG 5750776. REMOVED INTERIM REPAIR. TRIMMED OUT AFFECTED AREA IAW SRM 53-2-0 FIG 15, SERVICE REWORK DWSDR AWXA200301548Beam · corrodedDURING C-04 CHECK INTERGRANULAR CORROSION WAS FOUND ON AFT CARGO COMPARTMENT DOOR THRESHOLD BEAM BS 787-847, STR 25 RT. MAINTENANCE REMOVED CORRODED AFT CARGO COMPARTMENT DOOR THRESHOLD BEAM BS 787-847, STR 25 RT; FABRICATED A NEW REPLACEMENT BEAM; INSTALLED SDR GTIA031021Support · crackedFRAME SUPPORT CRACKED STATION 218 STRINGER 18L-17L, HIDDEN DAMAGE. REMOVED CRACKED SHEAR CLIP. FABRICATED SHEAR CLIP. INSTALLED FRAME, SHEAR CLIP. (M)SDR DHL2003802540Door Frame · damagedAFT PASSENGER DOOR JAMB LWR FWD CORNER INTERIM REPAIR, STA 1620.000 L-21L (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW SRM 53-2-0 FIG 18, SERVICE REWORK DWG SR08530021, DWG 5750776. REMOVED INTERIM REPAIR IAW SRM 51-1-20D PG 21. FABRICATED DOUBLER AND TRIPLERSDR SWAA032609Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND 3 EA FUSELAGE SHEAR TIES CORRODED AT BS 747, LBL 7 TO LBL 14, WL 146. REPAIRED SHEAR TIES PER SRM.SDR C2XA03SH476Beam · corrodedDURING C-CHECK THE LOWER CARGO DOOR CUTOUT BEAM WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE LOWER CARGO DOOR CUTOUT BEAM IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA03SH475Buttstrap · corrodedDURING C-CHECK THE CENTER BUTTSTRAP WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR ABXA030468Shear Tie · crackedSHEAR TIE CRACKED AT FS 718 LONGERON 5 RIGHT. INSTALLED NEW SECTION OF SHEAR TIE IAW DC-9 SRM 53-03.SDR QXEA200301492Sill · corrodedCORROSION AROUND NUT PLATES ON BOTTOM OF MAIN CABIN DOOR SILL. REPAIRED IAW DHC-8 SRM 51-40-11.SDR 2003UALA00908Shear Tie · crackedAFT CARGO COMPT SHEAR TIE CRACKED BS 747 RBL 32. MAJOR REPAIR ACCOMPLISHED. REPLACED SHEAR TIE.SDR ABXA030465Shear Tie · crackedSHEAR TIE REPAIR CRACKED FS 1021, BETWEEN LONGERON 15 LEFT AND LONGERON 16 LEFT. REMOVED CRACKED SECTION, LOCATED AND DRILLED NEW FRAME FORMER IAW DC-9 SRM 51-1-4 AND 53-03, INSTALLED IAW DC-9 SRM 51-30-2.SDR ABXA030466Shear Tie · crackedSHEAR TIE REPAIR HAD CRACK INDICATION FS 1021, BETWEEN LONGERON 15 RT AND LONGERON 14 RT. REPAIRED AREA IAW DC-9 SRM 53-03.SDR UPS03841573Door Frame · crackedINSPECTION TYPE:N/A .2500 INCH CRACK IN PIT 31 DOOR FRAME AT STA NR 2A. C/W EO DC8-5330-19579 INSTALLED TEMP REPAIR, PERMANENT REPAIR TO BE IN STALLED AT NEXT C CHECK.SDR DHL2003742564Door Frame · corrodedDURING C-CHECK, MAIN E&E COMPARTMENT DOOR CUTOUT FWD FRAME CORRODED/EXFOLIATED 100 PERCENT MATERIAL LOSS BS 424, BL 0-RBL 5 WL 150. REMOVED FASTENERS FOR ACCESS AS REQUIRED, FABRICATED NEW FWD FRAME IAW B727 SRM 51-30-2, FABRICATED NEW FWD FRAME AT BS 424 BLSDR DHL200374264Door Frame · corrodedDURING C-CHECK, MAIN E&E COMPARTMENT DOOR CUTOUT FWD FRAME CORRODED/EXFOLIATED, 100 PERCENT MATERIAL LOSS BS 424, BL 0 - RBL 5 WL 150. REMOVED FASTENERS FOR ACCESS AS REQUIRED, FABRICATED NEW FWD FRAME IAW B727 SRM 51-30-2, FABRICATED NEW FWD FRAME AT BS 424 SDR DHL2003742555Structure · corrodedDURING C-CHECK, CORROSION ON LOWER SURFACE OF LEFT NOSE WHEEL WELL MID-CHORD BS 296, LBL 20, WL 165 AS VIEWED THROUGH FWD LEFT DOGHOUSE FLOOR PRESSURE PANEL. REMOVED AND REPLACED LT NOSE WHEEL WELL AND CHORD BS 296 USING P/N 65-19862-19 PO3348224 IAW B-727 SRSDR ASAA0380768Shear Tie · corrodedOKC - FOUND SHEAR TIE CORRODED AT FS 655. REMOVED DAMAGED SECTION. SPLICED IN NEW SECTION PER SRM 51-10-2, 04, AND 53-03. (M)SDR ASAA0380766Shear Tie · corrodedOKC - DURING 15K CHECK, FOUND SHEAR TIE CORRODED AT FS 693. REPLACED SHEAR TIE PER SRM 51-10-2, 3, 4, 5. (M)SDR LR7A03103Ring · corrodedDURING SCHEDULED C4 INSPECTION, FOUND LT CENTER FUSELAGE RING SEGMENT CORRODED AND CRACKED AT FS 762E, 767E AND 772E, LBL 60, WL 142-148. REPAIRED IAW SRM SMP 583 51-140-23. NR 2240.SDR LR7A03102Ring · deformedDURING SCHEDULED C4 INSPECTION, FOUND RT CENTER FUSELAGE RING SEGMENT DEFORMED AT FS 747E, 752E & 762E, RBL 60, WL 142-148. REPAIRED IAW SRM SMP 583 51-140-23. NR 2238.SDR LR7A03100Beam · corrodedDURING SCHEDULED C4 INSPECTION, FOUND LT MLG FS 517 VERTICAL BEAM CORRODED AT TRACK ATTACHMENT, LBL 60, WL 151 & 185. REPAIRED IAW LAC MEA 382-25-03-074 R1. NR 2225.SDR SWAA032576Crease Beam · corrodedDURING SCHEDULED D CHECK, FOUND LT CREASE BEAM CORRODED AT BS 877. REPAIRED CREASE BEAM PER SRM.SDR DHL2003742570Frame · damagedDURING C-CHECK, NR 1 CARGO DOOR FUSELAGE FRAME LOWER FWD, CORNER AREA WITH DENTS. DAMAGE FOUND TO BE OUT OF LIMITS IAW B727 SRM 51-10-1 FIG 1. CUT OUT DAMAGED UPPER CHORD AND FABBED NEW ONE FROM BAC 1503-100274 PO 3344880 DIM 42 INCHES & SPLICE ANGLE DIM 9 ISDR DHL200374270Door Frame · dentedDURING C-CHECK, NR 1 CARGO DOOR FUSELAGE FRAME LOWER FWD, CORNER AREA WITH DENTS. DAMAGE FOUND TO BE OUT OF LIMITS IAW B727 SRM 51-10-1 FIG 1. CUT OUT DAMAGED UPPER CHORD AND FABED NEW ONE FROM BAC 1503-100274 PO 3344880 DIM 42 INCHES & SPLICE ANGLE DIM 9 ISDR SWAA032572Crease Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CREASE BEAM CORRODED AT BS 947 TO BS 967 RT SIDE. REPAIRED CREASE BEAM PER SRM.SDR ASAA0380783Shear Tie · corrodedOKC - DURING 15K CHECK, FOUND SHEAR TIE CORRODED AT STATION 1212. REPAIR IAW SRM. (M)SDR ASAA0380796Beam · crackedOKC - DURING 15K CHECK, FOUND FORWARD PAX DOOR UPPER BEAM IS CRACKED AT FORWARD AND AFT CORNERS. REPLACED BEAM IAW SRM 51-30-2. (M)SDR SWAA032553Window Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND NR 1 AND NR 2 LT SIDE PAX WINDOW FRAMES CRACKED AT FASTENER HOLE. REMOVED AND REPLACED WINDOW FRAMES PER SRM.SDR ASAA0380752Beam · corrodedOKC - DURING 15K CHECK, FOUND CORROSION ON CARGO DOOR BEAM REPAIR DOUBLER. REMOVED OLD REPAIR AND INSTALLED NEW REPAIR DOUBLER AND TRIPLER PER EA 5310-02278. (M)SDR TSAA0253247Window Frame · crackedTRIMMED AREA AND VERIFIED CRACK REMOVED USING HFEC. FABRICATED 3 FILLERS AND REPAIR DOUBLER FROM 2024-T3 AS SHOWN IN PHOTO 1, MAINTAINING 2D EDGE MARGIN, MIN .5 INCH OUTSIDE CORNER RADIUS WITH 2.0 INCH INSIDE CORNER RADIUS AND 5D-6D SPACING AT NEW FASTENER LOSDR SWAA032544Crease Beam · crackedDURING SCHEDULED D CHECK, FOUND RT CREASE BEAM CRACKED AT BS 616. REPAIRED CREASE BEAM PER SRM.SDR SWAA032541Crease Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND LT CREASE BEAM CORRODED AT BS 947 AND BS 967. REPAIRED CREASE BEAM SECTION PER SRM.SDR QXEA200301445Door Frame · chafedPDX- BAGGAGE DOOR SURROUND STRUCTURE IS CHAFED AT BOTH TOP DOOR STOP FRAME AREAS. REPAIRED IAW DHC-8 RD 8-53-5461 AND SRM 51-00-06.SDR GTIA031072Receptacle · crackedFTW - FOUND RIGHT AFT EMERGENCY EXIT DOOR JAMB AFT LOWER LOCK PIN RECEPTACLE CRACKED. REMOVED CRACKED RECEPTABLE. INSTALLED RECEPTACLE. (M)SDR GTIA031013Strap · corrodedFOUND AFT CARGO DOOR JAMB BEAM AND REPAIR STRAP CORRODED. JAMB BEAM REPAIR STRAP IS FOUND TO BE OUT OF LIMITS. REMOVED JAMB BEAM REPAIR STRAP. FABRICATED NEW REPAIR STRAP. INSTALLED NEW JAMB BEAM REPAIR STRAP. (M)SDR SWAA032531Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND AFT CARGO COMPT SHEAR TIE CORRODED AT BS 927, LBL 4 TO RBL 4. REPAIRED SHEAR TIE PER SRM.SDR CA040105003Door Frame · cracked(CAN) DURING ROUTINE INSPECTION, A .1250 INCH CRACK WAS FOUND IN THE CABIN DOOR FRAME AT THE UPPER FORWARD DRAW BOLT. THROUGH CONTACT WITH MFG AND OTHER LOCAL VENDORS, IT WAS DETERMINED TO BE MORE COST EFFECTIVE TO REPLACE THE ENTIRE DOOR ASSEMBLY RATHER THAN SDR UPS03841592Shear Tie · crackedINSPECTION TYPE: C1, SHEAR TIE IS CRACKED AT STATION 1380 LONG. 29L TO 30L. REMOVED DAMAGED SHEAR TIE, FABRICATED AND INSTALLED SHEAR TIE REPAIR IAW SRM. 53-2-0 FIG. 2A.SDR DHL2003802546Door Frame · crackedEXTERNAL FUSELAGE FWD SVC DOOR JAMB LOWER AFT CORNER CRACKED .750 STA 190.000, L20 - L21R (MAJOR REPAIR). PERFORMED MAJOR REPAIR. REMOVED FASTENERS IAW SRM 51-1-21 PG 1. TRIMMED OUT DAMAGED AREA IAW SRM 53-2-0 FIG 14, SERVICE REWORK DWG SRO8530021, DWG 5750
Back to JASC 5310