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 05FDEA01920Stringer Clip · crackedFUSELAGE UPPER LOBE, STRINGER CLIP IS CRACKED, BS 660, STR 8R. REMOVED FABRICATED AND INSTALLED STR. CLIP AT BS 660 STR 8R IAW SRM 51-20-1 & 51-30- 02.SDR UPS05845125Structure · elongatedINSPECTION TYPE: C1, D-PIT DOOR AFT WEB HAS SEVERAL ELONGATED HOLES AND LITE CORROSION AROUND FASTENER. REMOVED DAMAGED WEB IAW SRM 51-1-21, FABRICATED DOOR JAMB SKIN AND WEB IAW DWG 5616674 AND SRM 51-1-21 AND INSTALLED JAMB SKIN AND WEB IAW DWG 5616674 AND SDR UPS05845123Fitting · crackedINSPECTION TYPE:C1 60 COMPT L17L AT 1770 HAS 6 INCH CRACK AT END FITTING. REMOVED FITTING AND SUPPORT FROM STA 1770 L17L IAW SRM 51-1-20D, FABRICATED AND INSTALLED LONGERON END SPLICE FITTING AT STA 1170 1793 IAW DWG S-1616757 AND SRM 51-1-8.SDR UPS05845006Finger Doubler · corrodedFINGER DOUBLER BLOWN OUT IN COCKPIT SUBFLOOR AT STA -67 TO -81. REMOVED FINGER DOUBLER AT STA -67 TO -81. FABRICATED FINGER DOUBLER AND INSTALLED IAW SRM 53-3-1, AND 51-1-21, 51-1-20D.SDR UPS05844936Finger Doubler · corrodedINSPECTION TYPE:C1 HEAVY CORROSION BETWEEN COCKPIT SUBFLOOR SKIN AND 2ND FINGER DOUBLER, SEVERAL POPPED RIVIT HEADS,-52 TO -62 LH SIDE AT CUSP. REMOVED FINGER DOUBLERAND REMOVED CORROSION .004 FROM SUBFLOOR SKIN FOUND TOBE WITHIN LIMITS. FABRICATED AND REPSDR VTZA200500141Door Frame · crackedPAX DOOR FRAME TOP RADIUS CRACKED AT 1.0 IN LENGTH FORWARD OF DATUM 1 AT FS 338.90.SDR AWXA200500862Frame · crackedMCN - MAJOR REPAIR - DURING C16 CHECK DISCOVERED FRAME WEB CRACKED .950 INCHES IN LENGTH, AT BS 178, WL 230 AND BL 17.1R. MAINTENANCE REMOVED DAMAGED AREA FROM THE FRAME WEB AT BS 178, WL 230, BL 17.1R. FABRICATED FILLER AND WEB IAW BOEING 737-300 SRM 53-10-SDR SWAA052009Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE CREASE BEAM WEB CORRODED AT BS 500 TO BS 500D, LBL 68, WL 208. REPAIRED WEB PER SRM.SDR SWAA051999Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FUSELAGE CREASE BEAM WEB CORRODED AT BS 400 TO BS 420, RBL 68, WL 208. REPAIRED WEB PER SRM.SDR SWAA051966Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON CREASE BEAM WEB AT BS 312, RBL 60. REMOVED AND REPLACED CREASE BEAM WEB SECTION PER SRM.SDR 05FDEA01832Plate · gougedMAIN CARGO DOOR BS 460 TO 640 LBL 45 WL 295 DOOR CUTOUT INNER PLATE HAS NUMEROUS GOUGES. *S/D* BLENDED AND REPAIRED GOUGES IN MAIN CARGO DOOR INNER PLATE IAW EA 7-5330-89309.SDR 05FDEA01830Plate · gougedMAIN CARGO DOOR BS 460 TO 480 LBL 24 WL 287 DOOR CUTOUT INNER PLATE HAS NUMEROUS GOUGES. *S/D* BLENDED NUMEROUS GOUGES IN DOOR CUTOUT INNER PLATE IAW EA 7-5330-89309.SDR DHL2005746523Crossbeam · crackedE&E DOORS AFT CROSS MEMBER IN ENTRYWAY CRACKED INSIDE LIP 4.5 INCHES OFF CENTER RT SIDE (MARKED). REMOVED FASTENERS AND FRAME IAW B727 SRM 51-30-2. FABBED NEW FRAME 7075 T6 PO9001873 1050 24"X6" IAW B727 SRM 53-10-2 FIG 1. TREATED AND PRIMED PART IAW B727 SSDR SWAA051926Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE BEADED WEB CRACKED AT BS 664, LBL 33. REPAIRED WEB PER SRM.SDR UPS05844984Finger Doubler · corrodedINSPECTION TYPE: C1, COCKPIT SUBFLOOR AT STA -32 TO -52 RBL 60 FINGER DOUBLER CORRODED. REMOVED FINGER DOUBLER, CORROSION FOUND OUT OF LIMITS, FABRICATED, AND INSTALLED REPLACEMENT FINGER DOUBLER IAW DWG 5612298 AND DC-8 SRM 51- 1-20D AND 51-1-15.SDR UPS05844983Finger Doubler · corrodedINSPECTION TYPE: C1, COCKPIT SUBFLOOR STA -32 TO -12 RBL 48 FINGER DOUBLER HAS SEVERAL SHEA R HEAD FASTENERS AND POSSIBLE CORROSION. REMOVED FINGER DOUBLER, CORROSION ON FINGER DOUBLER FOUND OUT OF LIMIT S, FABRICATED, AND INSTALLED REPLACEMENT FINGER DOUBSDR 05FDEA01776Tee Fitting · corrodedTEE CHORD 760 -787 RBL 45 IS CORRODED. REMOVED AND REPLACED TEE CHORD IAW SRM 51-30- 2SDR 05FDEA01775Tee Fitting · corrodedTEE FITTING APPROX STA 760-787 RBL 45 IS CORRODED. REMOVED AND REPLACED TEE FITTING IAW SRM 51-30-2SDR 05FDEA01756Door Frame · corrodedNR 3 LT MAIN ENTRY DOOR AFT JAMB CUTOUT BETWEEN LONGERONS 24L AND 25L , LOWER INTERNAL DOUBLER (AEA7539) FOUND WITH CORROSION. REPAIRED PER SRM VOLUME I, FIGURE 17 (SHEET 3) PAGE 62. (OPEN)SDR SWAA051884Window Post · crackedDURING SCHEDULED 1/4D CHECK, FOUND L1 COCKPIT WINDOW POST CRACKED AT UPPER OUTBOARD CORNER. REPAIRED POST PER SRM.SDR MWEA050060Structure · vibrationDURING CRUISE PILOT REPORTED A LOUD HUMMING SOUND AND VIBRATION. VISUALLY INSPECTED ALL LANDING GEARS AND WHEEL WELLS, INSPECTED AIRCRAFT FUSELAGE, DOORS,WINGS AND PANELS. PERFORMED ENGINE VIBRATION TEST. NO DEFECTS FOUND.SDR ASAA0540314Failsafe · cutOKC - FOUND CORROSION ON FAIL/SAFE CHORD STATION 787 AT STRINGER 26R. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR PARTS IAW 737-400 SRM 51-70-11. (M)SDR ASAA0540299Beam · crackedOKC - THE STUB BEAM 69-37253-10 WAS FOUND TO BE CRACKED AT UPPER CORNER OUTBOARD SIDE DURING 685 FRAME REPLACEMENT. TRIMMED OUT DAMAGED AREA, FABRICATED REPAIR PARTS AND INSTALLED IAW BOEING FAILED REWORK RECORD DD2 UNDER BOEING REPAIR AGREEMENT NR 6-1171-RE-SDR ASAA0540326Shear Tie · corrodedYXX - FOUND BS 500E CORROSION ON SKIN TO FRAME ATTACHMENT AT STRINGER 27 AND 28 LEFT. BLEND AND CHECK LIMITS REPAIRED IAW 737-400 SRM 53-00-07 FIG 203. (M)SDR ASAA0540325Window Post · crackedYXX - F/O`S NR 1 WINDOW OUTBOARD POST UPPER CORNER CRACKED. REPAIRED IAW 737-400 SRM 53-10-01 FIGURE 202. (M)SDR SIMA200519308Structure · chafedDURING INSPECTION, FOUND STRINGER 19 LT CHAFED BETWEEN FRAMES 52, 53. REPLACED DAMAGED STRINGER IAW SRM. AIRCRAFT WAS RETURNED TO SERVICE. (K)SDR IXXA05SMN87SStructure · crackedDURING C CHECK INSPECT, MLG W/W L-24 CRACKED 2", STA 980.000. PERFORMED MAJOR REPAIR IAW DC-8 SRM 53-2-2 FIG 5 TR NR 53-123 DATE 05-15-01, EO SEMAN NR 2005831 DATE 06-16-05. REMOVED FASTENERS IAW DC-8 SRM 51-1-20D PAGE 21. PERFORMED SLOP HOLE ON CRACK END ISDR VTZA200500125Door Frame · crackedPASSENGER DOOR FRAME, TOP RADIUS CRACKED AT FORWARD OF DATUM 1 AT FS 338.90.SDR UPS05444808Structure · crackedINSPECTION TYPE:C. AFT CARGO - STA 1580 RBL 7 FRAME UPPER CHORD JUST UNDER ROLLER TRACK FOUND CRACKED. CRACK LENGTH 0.75. AFT CARGO BAY BS 1580 LBL 16 TO RBL 16 FLOORBEAM UPPER CHORD REPAIRED AS PER SRM 51-40-04 FIG 2.SDR USAA050779Tear Strap · debondedCLT - FOUND TEAR STRAP DISBOND 15 INCHES, BS 867-887, S17-19 RT. INSTALLED RIVETS THROUGH SKIN AND STRAPS AS REQUIRED IAW SRM 53-00-01 FIG 225. (M)SDR USAA050778Tear Strap · debondedCLT - FOUND TEAR STRAP DISBOND 8 INCHES, BS 857, S16R-S17R. INSTALLED RIVETS TO SECURE IAW SRM 53-00-01, FIG 225 DET 3. (M)SDR USAA050777Tear Strap · debondedCLT - FOUND DEBONDED TEAR STRAP 11 INCHES, BS 877, S16R-17R. ADDED RIVETS IAW SRM 53-00-01 FIG 225 DET 3. (M)SDR SWAA051803Crease Beam · crackedDURING SCHEDULED 1/2D CHECK, FOUND LT CREASE BEAM WEB CRACKED AT BS 616 TO BS 639, STR 17L. REPAIRED WEB PER SWA EA.SDR ABXA050164Door Frame · crackedLEFT AFT UPPER DOOR JAMB CRACKED, EMERGENCY EXIT, IN 2 PLACES. REPAIRED LEFT AFT UPPER DOOR JAMB IAW DC-9 SRM 53-05.SDR SWAA051772Shear Web · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SHEAR WEB CRACKED AT BS 304, STR 4L. REPAIRED WEB PER SRM.SDR SWAA051753Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE CREASE BEAM WEB CORRODED BETWEEN BS 767 TO BS 787, RBL 65. REMOVED AND REPLACED CREASE BEAM WEB SECTION PER SRM.SDR SWAA051752Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE CREASE BEAM WEB CORRODED BETWEEN BS 727B TO BS 727C & BETWEEN BS 807 TO BS 827, RBL 70. REMOVED AND REPLACED CREASE BEAM WEB SECTIONS PER SRM.SDR USAA050756Beam · corrodedPIT - S2 - BEAM; 2 INCH CORROSION; NO LEVEL OR TASK; -30 INCHES AT FRAMES 64-65. REMOVED AND REPLACED BEAM. (K)SDR ASA0510184Door Frame · crackedDOOR FRAME ON FUSELAGE IS CRACKED (AFT END FWD FRAME. REPLACED IAW SRM. (K)SDR ABXA050159Retainer · crackedSTA 756, LONGERON 15 RIGHT, HAD CRACK AT WINDOW RETAINER. REMOVED AND REPLACED DAMAGED CLIP. FABRICATED AND INSTALLED NEW CLIP IAW DACO DWG 3914137 AND DC-9 SRM 51-30-5.SDR ABXA050160Retainer · crackedSTA 598, LONGERON 10 RT, HAD CRACK AT WINDOW RETAINER. REPAIRED WINDOW RETAINER AT FS 598, LONGERON 10 RIGHT IAW DC-9 SSRM DWG K07226.SDR SWAA051737Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE CREASE BEAM WEB CORRODED AT BS 332 TO BS 344, RBL 63. REPAIRED WEB PER SRM.SDR VTZA200500110Door Frame · crackedPASSENGER DOOR FRAME TOP RADIUS CRACKED AT 1 INCH IN LENGTH FORWARD OF DATUM 1 AT FS 338.90.SDR ASAA0580325Beam · corrodedOKC - DURING HV CHECK, FOUND AFT CARGO BAY DOOR JAMB LOWER BEAM CORRODED. REPLACED BEAM. (M)SDR CA050614004Support · misinstalled(CAN) RUDDER CONTROL CABLE WAS RIDING ON CROSSMEMBER AND SEVERED CROSSMEMBER COMPLETELY IN HALF. IMPROPER INSTALLATION OF CROSSMEMBER POSITIONED WITH CABLE ABOVE MEMBER. CABLE SHOULD PASS BELOW MEMBER.SDR 0500919623Door Frame · crackedDURING L-CHECK, FOUND CRACK IN FORWARD UPPER CORNER OF FORWARD SERVICE DOOR FRAME. REPAIRED PER EA 96-203593.SDR SWAA051687Floor Support · corrodedDURING SCHEDULED D-CHECK, FOUND COCKPIT FLOOR ZEE FITTING CORRODED AT BS 270, RBL 11 TO LBL 11, WL 208. REPAIRED ZEE FITTING PER SRM.SDR 05FDEA01554Door Frame · damagedAT DOOR JAMB AFT CARGO DOOR STA 1959 LOWER EXISTING DENT/SCRATCH, BLEND OUT. REPAIRED AS PER SRM 53-00-00 VOL I FIG 16 (SHT 9). MAJOR REPAIR AS PER GMM 6-2-100.SDR CALA0500191Frame · corrodedINSPECTION FOUND R-1 DOOR FLOOR CUTOUT THRESHOLD FRAME CORRODED AT STA 290-300, RBL 48. THE THRESHOLD FRAME WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR GTIA050191Door Frame · corrodedAFT CARGO DOOR FUSELAGE JAMB, BEAM STATION 1155-1211, L25R CORRODED. REMOVED PANEL FOR ACCESS. REMOVED CORROSION, FOUND MATERIAL IS OUT OF LIMITS. FABRICATED DOUBLER. TREATED AND PRIMED. INSTALLED REPAIR DOUBLER. INSTALLED ACCESS PANELS. (M)
Back to JASC 5310