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 0200989866Longeron · corrodedDuring MCK in ATL longeron 29L and #) were found with corrosion between stations 466 and 484. Repaired per EA 98-188429.SDR MWEA020195Gusset · corrodedGUSSET AT STATION 580 IS CORRODED ON INTERCOSTAL. -- FABRICATED AND INSTALLED GUSSET.SDR MWEA020193Fitting · misdrilledFITTINGS MISDRILLED AT STATION 207 (INTERCOSTAL ATTACH CLIP). -- FABRICATED AND INSTALLED NEW FITTING. LOCATED AND PRIMED AND INSTALLED PARTS.SDR MWEA020192Fitting · damagedREMOVED FLOOR BEAM END FITTING AT CUSP, STATION 218 LEFT SIDE TO FACILITATE OTHER MAINTENANCE. -- FITTING DAMAGED UPON REMOVAL. INSTALLED NEW FITTING.SDR MWEA020190Intercostal · improperFORWARD PIT INTERCOASTAL LOCATED BETWEEN LONGERON 28 RIGHT AND 27 RIGHT AND FRAMES 560-579 HAS SEVERAL DIVETS IMPROPERLY BACKED. -- FABRICATED AND INSTALLED AFT FLANGE. FOUND CRACKS ON INTERCOSTAL LOWER ATTACH HOLES. FABRICATED AND INSTALLED INTERCOSTAL .SDR MWEA020204Longeron · chafedLONGERON 17 LEFT CHAFED AFT OF SHOVEL CLIP AT STATION 1338. -- REMOVED DAMAGED SECTION. FORMED REPAIR SPLICE AND FILLER SECTION. INSTALLED LONGERON REPAIR SPLICE.SDR UPS03240417Gusset · crackedINSPECTION TYPE: C, SUSPECT CRACK AT 1263 UPPER BEAM AT INNER RADIUS OF FLANGE ADJACENT TO THIRD FASTENER VERT, FROM I/B END, RT TORQUE BOX (GUSSET). HFEC C/W CRACK CONFIRMED AND ENDS MARKED. GUSSET AND ANCILLARY STRUT URE DISPLACED IAW SRM 5130-02. NEW GUSDR UPS02438002Stringer · crackedINSPECTION TYPE:C M/D - BS 856 S25R STRINGER END FOUND CRACKED. STRINGER REPAIRED AS PER SRM 53-10-03 FIG.1.SDR UPS02437999Web · crackedINSPECTION TYPE:C M/D - R5 DOOR FWD CUTOUT UPP SPLICE WEB FOUND CRACKED. REPAIR DOUBLER INSTALLED AS PER SRM 53-10-04 FIG.91.SDR UPS02437989Web · crackedINSPECTION TYPE:C M/D - L2 DOOR FWD CUTOUT REVEAL FOUND CRACKED. M/D L2 DOOR FWD CUTOUT REVEAL REPAIRED AS PER RS #R-53-20-34755.SDR UPS02437988Web · crackedINSPECTION TYPE:C M/D - R2 DOOR FWD CUTOUT REVEAL FOUND CRACKED. M/D R2 DOOR FWD CUTOUT REVEAL REPAIRED AS PER HX RS #R-53-20-34755.SDR AWXA200200316Web · crackedMCN - MAJOR REPAIR - DURING C-12 CHECK A 1 1/2" CRACK WAS FOUND PRESSURE WEB AT BS 664, LBL 34. MAINTENANCE TRIMMED OUT DAMAGED AREA AND REMOVED 2 EACH ATTACH ANGLES, PERFORMED HFEC INSPECTION VERIFYING CRACK WAS CONTAINED, FABRICATED A -6 STIFFNER, -8 DOUBLERSDR ASA2002F00000Shear Tie · corrodedPAE- DURING SCHEDULED C-CHECK FOUND SHEAR TIE AT BODY STATION 727A, STRINGER 21L-22L CORRODED. REPAIRED PER SRM.SDR ASAA0210069Shear Tie · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND SHEAR TIE AT BS 727A, STRINGER 24L-25L CORRODED. REPAIRED PER SRM. (M)SDR ASAA0210067Shear Tie · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND SHEAR TIE AT BODY STATION 847, RBL 10 CORRODED. REPAIRED PER SRM. (M)SDR AWXA200200285Door Frame · dentedMCN - MAJOR REPAIR - DURING C-12 CHECK TWO DENTS WERE FOUND ON THE AFT CARGO COMPARTMENT DOOR CUTOUT FORWARD JAMB LOWER WEB DOUBLER. MAINTENANCE REMOVED THE DAMAGED WEB ON THE AFT CARGO COMPARTMENT DOOR CUTOUT FORWARD JAMB LOWER WEB DOUBLER IAW B737-300 SRM 5SDR AWXA200200284Door Frame · corrodedMCN - MAJOR REPAIR - DURING C-12 CHECK CORROSION WAS FOUND AROUND FASTENERS OF THE AFT CARGO COMPARTMENT DOOR CUTOUT FORWARD JAMB WEB DOUBLER JUST FORWARD OF THE LOWER STOP FITTING. MAINTENANCE REMOVED THE DAMAGED WEB DOUBLER ON AFT CARGO COMPARTMENT DOOR CUTSDR ASAA0210066Shear Tie · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND SHEAR TIE AT BS 807, STRINGER 26R-27R CORRODED. REPAIRED PER SRM. (M)SDR AALA20020356Beam · corrodedTUL - FOUND CORROSION ON AFT CARGO DOOR BEAM STATION 1155-1212. REMOVED AND REPLACED AFT CARGO DOOR BEAM FROM STATION 1117 TO 1250 PER AARD 53-10-00-3. (M)SDR MWEA020187Splice · crackedLONGERON 28 LEFT SPLICE AT STATION 560 IS CRACKED OUT AFT HOLE. -- REMOVED LONGERON SPLICE FITTING. MATCH DRILLED FITTING. FABRICATED AND INSTALLED SHIMS TO SPLICE AND INSTALLED SPLICE TO LONGERONS.SDR HEEA078348Support · wornHOLES FOR BUSHING AND PIN WORN.SDR HEEA078337Bracket · crackedSLAT BRACKET CRACKED.SDR AALA20020401Door Frame · damagedTUL - FOUND FORWARD SERVICE DOOR FRAME DAMAGED AT LOWER FORWARD CORNER, HOLE GOUGED IN LOWER DOOR PAN. REPLACED ENTIRE DOOR PAN ON E58'S NR 4208140, 9142105, 9109005 SRM REF 53-05-00/53-10-3/51-20, 51-30 AND 51-60. (M)SDR 0200979875Frame · corrodedDuring Mck in ATL the left side of the upper cusp sta 200 was found to be damaged by corrosion. Repaired per EA 98-188435.SDR UPS02237948Web · crackedINSPECTION TYPE:C LH PRESSURE WEB CRACKED IN NWW @ BS 267 REPAIRED IAW SRM 51-40-02 FIG 1SDR UPS02237936Window Post · crackedINSPECTION TYPE:C SUSPECT CRACKS ON COCKPIT LT F/N WINDOW POST AT POINT F (2 OFF). F/N WINDOW POST REPAIRED IAW EO B727-5310-0012 & SMRO EO 2002-009-00 1.SDR MWEA020183Longeron · crackedFORWARD PIT LONGERON 28 LEFT IS CRACKED UNDER SPLICE AT STATION 552 THROUGH 560. -- REMOVED LONGERON, POSITIONED AND DRILLED, REINSTALLED LONGERON.SDR MWEA020182Clip · corrodedAFT CARGO COMPARTMENT UNDERSIDE OF SHOVEL CLIP CORRODED AT STATION 945 LONGERON 26 RIGHT. -- REMOVED AND REPLACED SHOVEL CLIP.SDR MWEA020175Fitting · corrodedSTATION 945 BETWEEN LONGERONS 28 LEFT AND 27 LEFT HAS A CORRODED SUPPORT FITTING. -- REMOVED AND REPLACED SUPPORT FITTING.SDR MWEA020174Support · crackedSTATION 980 BY LONGERON 27 RIGHT HAS A CRACKED SUPPORT. -- REMOVED AND REPLACED FLOOR SUPPORT.SDR AUS20020399Door Frame · corroded(AUS) CORROSION FOUND IN EMERGENCY DOOR EXIT (AFT OVERWING) AREA AT LOWER RH CORNER OF WEB ON HATCH ASSEMBLY FRAME ZONE 49 STN 825.95 TO STN 848.95. CPCP - LEVEL 2 CORROSION.SDR GTIA020379Door Frame · crackedFTW - FOUND RIGHT FWD MLG DOOR JAMB CRACKED AT INBOARD SUPPORT PREVIOUS DOUBLER REPAIR -X 6.25. REMOVED DOUBLER REPAIR AND TEE ANGLE. AFTER FURTHER EVALUATION ADDITIONAL CRACK WAS FOUND, LOCATED AND DRILLED NEW PARTS. FABRICATED 2 CHANNELS TO BE USED AS SPLSDR AALA20020332Door Frame · corrodedTUL - FOUND CORROSION AROUND FASTENER HOLE ON AFT SIDE OF FRAME 20778 AT CARGO DOOR OPENING. INSTALLED DOUBLER PER ESO51000 DATED 3-5-02. (M)SDR AALA20020331Door Frame · corrodedTUL - FOUND CORROSION AROUND FASTENER HOLES ON FORWARD SIDE OF FRAME 22236 AT CARGO DOOR OPENING. INSTALLED DOUBLER PER ESO 51000 DATED 3/5/02. (M)SDR DL75A020334Door Frame · corrodedC1 DOOR OPENING LOWER CHORD CORRODED, THE FS 620 OPENING FRAME OUTER CHORD AND WEB WERE CUT AND THE LOWER SECTIONS REMOVED TO ALLOW ACCESS TO THE CHORD. AFTER REPLACEMENT OF THE CHORD, THE LOWER SECTION OF FRAME CHORD AND WEB WERE REINSTALLED AND SPLICE WITH SDR ABXA010784Fitting · crackedSPLICE FITTING CRACKED AT LONGERON 27 RIGHT, STATION 450, FORWARD LOWER CARGO. REMOVED AND REPLACED FITTING IAW DC8 SRM 51-1-20D AND 51-1-21.SDR UPS02537894Beam · corrodedINSPECTION TYPE:MOD UPON REMOVAL OF FLOOR PANELS FOUND CORROSION ON UPPER FLANGE OF FLOOR BEAM AT BS 1200 LBL 47 TO LBL 62 WL 208 CORROSION TO BE OUT OF LIMITS FABRICATE REPAIR ANGLE AND ACCOMPLISH ERO 02-0295SDR MWEA020167Longeron · crackedLONGERON 2 RIGHT AT FUSELAGE STATION 1076 CRACKED AT END. -- REMOVED AND REPLACED WITH REPAIR, NEW LONGERON SPLICE.SDR NACA20020036Attach FittingDURING "C" CHECK INSPECTION FOUND 2 EA STARTED DRILL HOLES IN THE ATTACH FITTING AT B.S. 1183, WL 278, AND RBL 27. CORRECTED BY INSTALLING 2 PIECE FREEZE PLUG, AND DOUBLER PER BOEING PROVIDED REPAIR PLAN NAC-ANC-02-00003H AND REIVISION NAC-ANC-02-00004H.SDR ASOA02170Shear Tie · corrodedDURING C-CHECK INSPECTION IN BNA, A SHEAR TIE WAS FOUND CORRODED AT FRAME 21 BETWEEN STRINGERS 19 AND 20 RIGHT AND ALSO BETWEEN STRINGERS 20 AND 21 RIGHT. MAINTENANCE REMOVED AND REPLACED THE CORRODED SHEAR TIE IAW SRM'S 51-25-00, 51-40-02, AND 51-40-05. (M)SDR AALA20020350Shear Tie · crackedTUL - FUOND TWO SHEAR TIES CRACKED ON AFT SIDE OF FRAME 1433 JUST INBOARD OF STRINGER 3R AND STRINGER 3L. REMOVED AND REPLACED WITH NEW SHEAR TIE PER SRM 53-01. (M)SDR SIMA200207805Sill · corrodedABI - THIS IS LEVEL 2 FINDING ON A CRIC NR 35573. LEFT SILL IS CORRODED BETWEEN FRAMES 19 AND 23. MAINTENANCE REMOVED LEFT SILL AND INSTALLED NEW SILL IAW EMB 145 SRM 51-40-02. (M)SDR AALA20020349Shear Tie · crackedTUL - FUOND FRAME 1429 SHEAR TIE CRACKED LEFT AFT SIDE JUST OUTBOARD OF TAIL TIE FITTING. INSTALLED NEW SHEAR TIE PER SRM 53-01. (M)SDR SIMA200207301Structure · corrodedMBV - DURING INSPECTION OF AIRCRAFT, FOUND CORROSION ON FORWARD DIGITAL. REMOVED CORROSION BY BLENDING OUT. FABRICATED A REPAIR DOUBLER 2 INCH BY 2.75 INCH, .040 INCH THICK IAW EMB GST-0800/02, ITEM 1, AND STANDARD SRM PRACTICES. (M)SDR SIMA200207303Beam · corrodedABI - DURING INSPECTION OF AIRCRAFT, FOUND CORROSION ON LEFT OMEGA BEAM AT FRAME 20. REMOVED CORROSION BY CUT OUT. FABRICATED A DOUBLER ANGLE 18.5 INCH BY 3 INCH, AND FILLER 14 INCH BY 2.75 INCH, 050 INCH THICK, A PLATE 6.5 INCH BY 1 INCH .125 INCH THICK, ANSDR 2002UALA00415Door Frame · damagedAFT CARGO DOOR CUTOUT AFT EDGE DAMAGED. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER REPAIR.SDR 2002UALA00437Crease Beam · corrodedCABIN FLOOR INNER CREASE BEAM CHORD AT STATION 760 RBL 65 STRINGER 17R HAD EXCESSIVE MATERIAL REMOVED DURING CORROSION CLEAN UP. MAJOR REPAIR ACCOMPLISHED. INSTALLED REPAIR ANGLES AND STRAP.SDR HNAA0200027Skin · corrodedDuring 40K inspection corrosion was found on the interior of the A/C in the center of a bay between frames 202 and 222 and between stringers 32 left and right. The corroded area was cut out and a doubler installed per EO8-53-02-0228.SDR 0200969871Frame · crackedDuring "M" Check at ATL base a .5" crack was found on the station 389 L17R frame at the longeron to frame location. Repaired per EA 98-188420.SDR 0200959870Skin · crackedDuring Accomplishment of a Hck in ATL, a crack was found on the Aft Pressure Bulkhead skin on hte left side of the aircraft just above the ventral door cutout. Repaired per EA 98-188225.
Back to JASC 5310