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 UPS02438635Web · crackedINSPECTION TYPE:C M/D - BS 1220 RBL 110 FLR BEAM WEB CRK. FLOOR BEAM WEB REPAIR CARRIED OUT AS PER SRM 51-40-02 FIG.1SDR UPS02238550Beam · crackedINSPECTION TYPE:C CRACK INDICATION AT BS 1183 BEAM RBL 26.83 WL 250 APPROX. REPAIR CARRIED OUT IAW EO B727-5311-0631 APPENDIX DSDR UPS02438680Web · corrodedINSPECTION TYPE:C L/H WING CENTER SECTION STA 1241 BULKHEAD FITTING REAR SPAR WEB AFT SURFACE FOUND CORROSION ADJACENT TO BOLTS #14, 15, 25 AND 26. LH WING CENTER SECTION STA 1241 BULKHEAD FTG REAR SPAR WEB AFT SURFACE AT BOLT #14, 15, 25 & 26 BOLTS AREA CSDR UPS02438667Web · corrodedINSPECTION TYPE:C R/H WING CENTER SECTION STA 1241 BULKHEAD FITTING REAR SPAR WEB AFT SURFACE FOUND CORROSION ADJACENT TO BOLTS #13, 14, 15, 24, 25 & 26. CORROSION IS REMOVED AS PER EO B747-5710-11129 PG 9, OPENED BOLT HOLES ARE REAMED TO 0.375", NDT C/OUTSDR UPS02438638Door Frame · crackedINSPECTION TYPE:C M/D - RT NR 2 DOOR FWD LWR CORNER REVEAL CRACKED AT S-24R. CORNER REVEAL REPAIR CARRIED OUT AS PER SRM 53-10-04 FIG 84.SDR UPS02438612Frame · crackedINSPECTION TYPE:C M/D SIDEWALL FRAME O/B FLANGE CRACKED AT BS 440 S16R. BS 440 FRAME AT S16R REPAIRED AS PER SRM 51-40-03 FIG.1SDR UPS02238548Beam · crackedINSPECTION TYPE:C CRACK INDICATING AT BS 1183 BEAM LBL 26.83 WL AT 250 APPROX REPAIR CARRIED OUT IAW EO B727-5311-0631 APPENDIX DSDR HEEA079591Structure · separatedENGINE DECK STRUCTURE SEPARATED BEYOND REPAIR.SDR UPS02438683Web · crackedINSPECTION TYPE:C LH NOSE W/W BS 320 INNER CHORD FRAME WEB FOUND 3EA FASTENER HOLES CRKD, REF ATTACHED SKETCH FOR DETAILS. LH NOSE W/W BS 320 INNER CHORD FRAME WEB REPAIRED AS PER HX RS R53-12-34829.SDR UPS02438637Web · crackedINSPECTION TYPE:C CRACK FOUND AT RH NOSE W/W FRAME WEB AT BS 320 VERT BEAM ATTACHED AREA, SEE ATTACHED SKETCH FOR DETAILS. NOSE W/W FRAME AT RH BS 320 AREA REPAIRED AS PER SRM 53-10-04.SDR UPS02438611Web · crackedINSPECTION TYPE:C LH BS 320 NOSE W/W VERT BEAM WEB CRACK FOUND AT #2 AND 3 STANDOFF HOLES, COUNT FROM THE TOP, AS MARKED. NOSE W/W LH BS 320 VERTICAL BEAM WEB REPLACED AS PER SRM 51-10-01 PG.8SDR UPS02438610Web · crackedINSPECTION TYPE:C CRACK FOUND AT RH NOSE W/W VERT BEAM WEB AT BS 320 BETWEEN FIRST AND SECOND STIFFENERS AT LWR STANDOFF HOLE APPROX 1 INCH LONG AS MARKED. BEAM WEB REPLACED AT BS 320 RH AS PER SRM 51-10-01 PG.8SDR UPS02438608Web · crackedINSPECTION TYPE:C CRACK FOUND AT RH NOSE W/W VERT BEAM WEB AT BS 300 I/B CHORD ATTACHED AREA BETWEEN 1ST AND 2ND STIFFENERS APPROX 1/2 INCH LONG AS MARKED. NOSE W/W R/H BS 300 VERT WEB REPLACED AS PER SRM 51-10-01 P.8SDR UPS02438607Web · crackedINSPECTION TYPE:C CRACK FOUND AT RH NOSE W/W VERT BEAM WEB AT BS 280 LWR STANDOFF HOLE BETWEEN FIRST AND SECOND STIFFENERS APPROX 1/4 INCH LONG AS MARKED. NOSE W/W BS 280 R/H VERT BEAM WEB WAS REPLACED AS PER SRM 51-10-01 PG. 8SDR 2002UALA00928Crease Beam · corrodedCREASE BEAM WEB CORRODED AT STATION 1020, RBL 80, WL208, FWD END OF WEB. MAJOR REPAIR ACCOMPLISHED. REPLACED WEB.SDR HEEA079431Structure · separatedSERVICE DECK STRUCTURE HAS SEPARATED.SDR ASAA0210133Beam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND CREASE BEAM WEB AT BS 332-344, RIGHT BUTTOCK LINE 61-64 CORRODED. REPAIRED CREASE BEAM WEB PER SRM. (M)SDR C1HA200292025Shear Tie · corrodedSHEAR TIE AT STA 950B IS CORRODED ON FWD SIDE BETWEEN INTERCOSTAL AND STR 29 LT.SDR UPS02838619Door Frame · crackedINSPECTION TYPE:C1 L2 DOOR LWR FWD CORNER CRACKED, FOUND BY X-RAY INSPECTION. REPAIRED AREA IAW DC8 SRM 53-2-0 FIG 18.SDR DL757020604Door Frame · corrodedTHE OUTER CHORD OF THE C2 DOOR OPENING LOWER SILL WAS FOUND CORRODED AND REQUIRED REPLACEMENT. THE LOWER SECTION OF CHORD AND WEB WERE REMOVED. A NEW SILL CHORD WAS INSTALLED AND THE FRAME CHORD AND WEB SPLICED WITH ALUMINUM REPAIR ANGLES AND DOUBLERS PER ERSDR SIMA200214901Sill · corrodedABI - DURING AN IMBV INSPECTION MAINTENANCE, FOUND THE CARGO DOOR CUT OUT LOWER SILL CORRODED. REMOVED CORRODED SILL BEAM. INSTALLED NEW BEAM IAW EMB 145 SRM 145/1142, CHAPTER 51, REV 17 51-40-02 AND STANDARD SRM PRACTICES. (M)SDR ASAA0280189Door Frame · corrodedOAK - DURING C-CHECK, AFT CARGO BAY DOOR JAMB BEAM WAS FOUND TO BE CORRODED ON HORIZONTAL AND VERTICAL LEGS FROM FS 1155-1212. REPLACED DOOR JAMB BEAM PER SRM'S 51-10-3, 51-30-2, AND 51-30-5. (M)SDR ASAA0280190Door Frame · corrodedPAE - DURING C-CHECK, FOUND MID CARGO BAY LOWER DOOR BEAM TO BE CORRODED ON VERTICAL FACE AND LOWER HORIZONTAL LUG. REPAIRED PER EA 5310-02090. (M)SDR GTIA020610Structure · corrodedFTW - FOUND E/E COMPARTMENT CORROSION EXISTS ON LONGERONS, FRAMES, AND WEBS STATION 200 FROM LONGERON 18L TO 21L. MATERIAL ON LONGERON 18L END CAP FITTING OUT OF LIMITS. FORMED NEW END CAP FITTING. INSTALLED END CAP FITTING. (M)SDR HEEA079151Beam · corrodedFUSELAGE BEAM HAS CORROSION UNDER BUSHING AND BEARING CAP.SDR AALA20020814Threshold · corrodedTUL - FOUND CORROSION ON FORWARD CARGO DOOR FRAME, LOWER THRESHOLD AT STATION 405. REMOVED AND REPLACED SECTION OF PAN (THRESHOLD) PER SRM 53-05 FIG 44. (M)SDR GTIA020601Shear Tie · damagedFTW - FOUND FORWARD CARGO COMPARTMENT SHEAR TIE HAS HIGH STRESS EVIDENCE STATION 237 LEFT BETWEEN L20 AND L19 NEXT TO LAV DRAIN. REMOVED DAMAGED SHEAR TIE. FABRICATED NEW SHEAR TIE. INSTALLED SHEAR TIE. (M)SDR SIMA200215106Window Frame · corrodedDURING AN IMBV INSPECTION FOUND CORROSION IN SCREW HOLES/NUTPLATES OF WINDSHIELD CUTOUT LOWER EDGE. REAMED BEAM/BELT PILOTS SIDE LEFT LOWER CORNER (4) HOLES UP TO .313 TO REMOVE CORROSION. INSTALLED BUSHING, REAMED HOLES IN BUSHING TO .190 INCHES INSTALLED NSDR HEEA079128Structure · separatedENGINE DECK SEPARATION.SDR USAA020216Doubler · corrodedPIT - FOUND ANTENNA DOUBLER CORRODED SIX .25 INCH BY .25 INCH AREAS, ANTENNA MOUNT NUTPLATE BRACKETS BETWEEN STATION 727D. REMOVED CORROSION AND REPLACED CHANNEL PER SRM 53-30-53, 51-40-05. CORROSION LEVEL 1, TASK NR C53-208-01. (M)SDR C1HA200292028Shear Tie · corrodedSHEAR TIE AT STA 970 BL 30-LBL 29 IS CORRODEDSDR 0201969862Longeron · corrodedDuring MCK in ATL, Corrosion was found around fastener holes in four places in the base flange of longeron 30 between frame 377 and 389. Repaired per EA 98-189737.SDR 2002UALA00908Crease Beam · corrodedRIGHT HAND CABIN CREASE BEAM WEB UPPER SURFACE CORRODED BETWEEN STATION 1000 & 1020 WL 208. MAJOR REPAIR ACCOMPLISHED. REPLACED WEB.SDR MWEA020369Longeron · crackedLONGERON 17 RIGHT IS CRACKED UNDER FRAME 484. -- FABRICATED AND INSTALLED LONGERON SECTION AND REPAIR SPLICE.SDR MWEA020357Shear Tie · corrodedAFT ACCESSORY FRAME 1401 SHEAR TIE HAS CORROSION LOCATED JUST BELOW LONGERON 24 RIGHT. FABRICATED AND INSTALLED SHEAR TIE.SDR MWEA020351Door Frame · chafedFORWARD LEFT EMERGENCY EXIT DOOR JAMB IS CHAFED AND NICKED AT UPPER DOOR LATCH AREA. BLENDED AREA AND BLENDOUTS ARE WITHIN LIMITS PER BOEING TELEX MWX-ORD-02-00271H DATED 5/10/02.SDR ABXA020067Longeron · crackedFORWARD CARGO STATION 520, LONGERON 35 RIGHT, INBOARD FLANGE WAS CRACKED. REPAIRED AREA IAW REA D853-43899-MR.SDR ABXA020063Strap · corrodedFORWARD CARGO STATION 485, LONGERON 34 RIGHT, DOUBLER ON BACKSIDE OF LONGERON WAS CORRODED. REPLACED STRAP IAW DC-8 SRM 51-1-24 AND 51-1-20D.SDR ABXA010899Shear Tie · crackedSHEAR TIE CRACKED AT FS 1171, VERTICAL STABILIZER TO FUSELAGE ATTACH ANGLE. REPLACED SHEAR TIE IAW DC-9 SRM.SDR UPS02438423Shear Tie · crackedINSPECTION TYPE:C AFT CARGO COMPT- BS 1900 BETWEEN STR 51L TO 51R SHEAR TIE FOUND CRACKED. AFT CARGO COMPT- BS 1900 BETWEEN STR 51L TO 51R SHEAR TIE REPAIRED AS PER SRM 53-10-04 FIG 3A.SDR HEEA079099Structure · separatedNEWLY INSTALLED WORK DECK FOUND TO BE SEPARATED ON BOTTOM. THE SEPARATED AREA WAS 5 INCHES IN DIAMETER NEAR FWD CENTER OF DECK ASSY.SDR SIMA200214117Crease Beam · corrodedSAW - DURING CPCP4 INSPECTION, FOUND RIGHT CREASE BEAM INBOARD CHORD CORRODED, TOP AND BOTTOM. REPAIRED RIGHT CHORD FROM FRAME 13-18 IAW ATR 42 SRM NR 53-31-50. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200214113Crease Beam · corrodedSAW - DURING CPCP-4 INSPECTION, FOUND LEFT CREASE BEAM WEB WAS FOUND CORRODED BETWEEN FRAMES 39 AND 40. REMOVED AND REPLACED LEFT CREASE BEAM WEB FS 39-40 IAW SRM 51-25-03. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200214202Beam · corrodedABI - DURING AN IMBV MAINTENANCE, FOUND FOUR CORRODED NUTPLATES AT PILOTS WINDSHIELD LOWER OUTBOARD CORNER. REMOVED CORRODED NUTPLATES. REAMED BEAM BOLTS HOLES TO .313 INCH TO REMOVE CORROSION. REPAIR DONE IAW EMB GST-1578/02-B, EMB 145 (SRM 145/1142, CHAPTSDR UPS02838542Shear Tie · crackedINSPECTION TYPE:C1 INSIDE DOOR 60-VERT STAB CENTER SPAR CANTED BULKHEAD SHEAR TIE IS CRACKED BETWEEN L9L & L10L. FABRICATED AND INSTALLED REPAIR IAW DC8 SRM 53-2-0 & 51-1-20D.SDR AALA20020789Beam · corrodedTUL - FOUND HEAVY CORROSION ON BEAM FACE AND LOWER LEG FROM STATION 1155 AFT TO STATION 1212. INSTALLED FULL LENGTH BEAM DOUBLER PER AARD 53-10-00-3 FIG 1 SHEETS 1-13. (M)SDR AALA20020809Shear Tie · crackedTUL - FOUND SHEAR TIE CRACKED AFT SIDE OF 1437 FRAME BETWEEN L1 AND L2R. INSTALLED NEW SHEAR TIE SRM 51-01. (M)SDR 0201959861Bulkhead · crackedDuring Mck in ATL, a .65" crack was found in the upper bend radius of the APB channel.Repaired per EA 98-189685.SDR UPS02838385Door Frame · crackedINSPECTION TYPE:C13 R2 UPPER AFT DOOR JAMB CORNER CRACKED 2ND OR 3RD LAYER AND INNER LAYER CRACKED. REPAIRED IAW EO DC8 5330-12075G.SDR 2002UALA00893Crease Beam · corrodedSTATION 927 TO 1006 RIGHT HAND INBOARD CREASE BEAM ANGLE CORRODED. MAJOR REPAIR ACCOMPLISHED. CREASE BEAM AND ANGLE REPLACED.
Back to JASC 5310