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 SWAA013199Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND VERTICAL WEBSCRACKED (2 EA) AT BS 180, WL 231, LBL 17.1 AND RBL 17.1. REMOVED AND REPLACED WEBS PER SRM.SDR SWAA013197Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND WEB CRACKED .125 INCH LONG AT BS 178, WL 234 AND LBL 14. REPAIRED WEB PER SRM.SDR AALA20012121Pan · crackedTUL - FOUND WINDOW RING PAN CRACK AT UPPER RIGHT CORNER AT STATION 947 LEFT. INSTALLED DOUBLER AT STATION 947 UPPER RIGHT CORNER LEFT SIDE PER AARD 53-10-00-25. (M)SDR AALA20012126Shear Tie · crackedTUL - FOUND SHEAR TIE CRACKED IN AFT ACCESSORY STATION 1437 INBOARD OF LONGERON 3R AFT FACE OF FRAME. REMOVED AND REPLACED SHEAR TIE PER SRM 51-01. (M)SDR SWAA013198Stiffener · crackedDURING SCHEDULED 1/4D CHECK,(SI11051-53) FOUND VERTICAL STIFFENER CRACKED AT BS 663, LBL 6.15. REMOVED AND REPLACED VERTICAL STIFFENER PER SRM.SDR MWEA011447Frame · misdrilledFRAME (FORMER) AT FUSELAGE STATION 377.5 AND BETWEEN LONGERON 30 AND LONGERON 28 RIGHT MISDRILLED -- REMOVED INTERCOSTAL. FABRICATED AND INSTALLED STACKED ANGLE REPAIR DOUBLERS.SDR MWEA011458Intercostal · elongatedINTERCOSTAL FROM STATION 370-377.5, LONGERON 29 RIGHT HAS DOUBLE-DRILLED HOLE AT STATION 377.5 -- REMOVED, FABRICATED AND INSTALLED "T" FITTING AND INTERCOSTAL.SDR MWEA011457Skin · corrodedSKIN CORRODED AT SHEAR TIE BETWEEN LONGERON 30 AND LONGERON 29 RIGHT AT FUSELAGE STATION 370 -- FABRICATED AND INSTALLED REPAIR DOUBLERS: INTERNAL FINGER DOUBLER, INTERNAL STRAP DOUBLER, FILLER PLUG, EXTERNAL DOUBLER AND SHIM.SDR SWAA013179Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CORRODED AT BS 767, RBL 7 TO RBL 10, WL 146. REPAIRED SHEAR TIE PER SRM.SDR SWAA013178Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CORRODED AT BS 767, LBL 3 TO LBL 5, WL 146 AND WL 147. REPAIRED SHEAR TIE PER SRM.SDR SWAA013175Crease Beam · corrodedDURING SCHEDULED D CHECK, FOUND LT CREASE BEAM CORRODED AT BS 780 AND BS 873 AND CRACKED AT BS 641. REPAIRED CREASE BEAM PER SRM.SDR SWAA013167Stiffener · crackedDURING SCHEDULED D CHECK, FOUND LT VERTICAL STIFFENER CRACKED AT BS 663.75, WL 165. REMOVED AND REPLACED VERTICAL STIFFENER PER SRM.SDR SWAA013166Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CORRODED AT BS 747, RBL 9. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA013170Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND VERTICAL BEAM WEB CRACKED AT BS 178, RBL 17.1 AND WL 182. REPAIRED WEB PER SWA RA.SDR SWAA013168Shear Tie · crackedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE CRACKED AT BS 727A, STR 25L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR USAA011356Door Frame · crackedCLT - FOUND FRAME CRACKED 1 INCH, STATION 1350 L3 DOOR FRAME AT UPPER AFT STOP FITTINGS. INSTALLED DOUBLER AND FILLER PER EA 85594. (M)SDR P5CA0100617Web · crackedNOSE WHEEL WELL VERTICAL BEAM INSPECTION IAW MA A5310-33:01 REVEALED A CRACK 1-3/8" LONG AT WEB TO CHORD FASTENER LOCATION AT VERTICAL BEAM STN 320 R/H SIDE, WEB 2. REPAIRED IAW SRM 51-40-02, PAGE 5, DETAIL 111.SDR P5CA0100616Web · crackedNOSE WHEEL WELL VERTICAL BEAM INSPECTION IAW MA A5310-33:01 REVEALED A CRACK AT STANDOFF HOLE 2-3/8" LONG AT VERTICAL BEAM STN 320 R/H SIDE, WEB 2. CRACK REPAIRED IAW SRM 51-40-02, PAGE5, DETAIL 111.SDR QXEA0102005Shear Tie · corrodedPDX - AFT CARGO BAY FRAME 15205 CASTELLATION TIE IN TO BELLY SKIN BETWEEN STRINGER 1 AND 2 HAS CORROSION ON TOP SURFACE WITH POSSIBLE CRACK AT VERTICAL FLANGE. REPAIRED IAW FOKKER SRM 53-01-01, PAGE 6 AND SRM 51-10-04, PARAGRAPH 4 B AND C, PAGE 9.SDR QXEA0101974Shear Tie · corrodedPDX - ANGLED FRAME 15810 TIE IN CLIP TO FUSELAGE BELLY SKIN HAS CORROSION ON TOP SURFACE BETWEEN STRINGERS 73 AND 74. REPAIRED IAW FOKKER SRM 51-31-01.SDR QXEA0101976Shear Tie · corrodedPDX - FUSELAGE FRAME 15635 TIE IN CLIP TO BELLY SKIN HAS CORROSION ON TOP SURFACE AROUND RIVETS BETWEEN STRINGER 73 AND 74. REPAIRED IAW FOKKER SRM 51-31-01.SDR QXEA0101971Shear Tie · corrodedPDX - FUSELAGE FRAME 16060 TIE IN CLIP TO BELLY SKIN HAS CORROSION ON TOP SURFACE AROUND (3) RIVETS BETWEEN STRINGERS 2 AND 3. REPAIRED IAW FOKKER SRM 51-10-04, PARAGRAPH 4B, C, PAGE 9.SDR QXEA0101970Shear Tie · corrodedPDX - FUSELAGE FRAME 16060 TIE IN CLIP TO BELLY SKIN HAS CORROSION ON TOP SURFACE AROUND (3) RIVETS BETWEEN STRINGERS 1 AND 2. REPAIRED IAW FOKKER SRM 53-02-13, FIGURE 2, PAGE 4.SDR QXEA0101967Shear Tie · corrodedPDX - FUSELAGE FRAME 16060 TIE IN CLIP TO BELLY SKIN HAS CORROSION ON TOP SURFACE ROUND RIVETS BETWEEN STRINGERS 1 AND 74. REPAIRED IAW FOKKER SRM 53-01-01, PAGE 6 AND SRM 51-10-04, PARAGRAPH 4B, C, PAGE 9.SDR QXEA0101966Shear Tie · corrodedPDX - FUSELAGE FRAME 16060 TIE IN CLIP TO BELLY SKIN HAS CORROSION ON TOP SURFACE AROUND (3) RIVETS BETWEEN STRINGERS 73 AND 74. REPAIRED IAW FOKKER SRM 53-02-13, FIGURE 2, PAGE 4.SDR MWEA011445Longeron · corrodedMODERATE CORROSION IN LONGERON CHANNEL 29 LEFT FROM 313 TO 332 -- FABRICATED AND INSTALLED REPAIR FITTING ON LONGERON 29 LEFT AT STATION 313-332.SDR MWEA011443Shear Tie · corrodedSHEAR TIE AT FUSELAGE STATION 377.5, BETWEEN LONGERON 29 RIGHT AND LONGERON 29 LEFT IS CORRODED -- REMOVED, FABRICATED AND INSTALLED SHEAR TIE.SDR MWEA011442Shear Tie · corrodedSHEAR TIE AT FUSELAGE STATION 370 BETWEEN LONGERON 30 AND LONGERPM 29 RIGHT IS CORRODED -- REMOVED, FABRICATED AND INSTALLED SHEAR TIE.SDR UPS01837323Door Frame · crackedINSPECTION TYPE:IN CRACK IN COCKPIT DOOR FRAME, JUST ABOVE AND OUTBOARD OF DOOR (CLOSED) CATCH. INSTALLED DOUBLER ON DOOR FRAME AT DOOR CATCH PER DC-8 SRM 53-2-0.SDR MWEA011452Longeron · crackedFUSELAGE STATION 925 CRACKED AT LONGERON 16 LEFT -- STOP DRILLED CRACK. DRILLED ANGLES AND FRAME AND INSTALLED REPAIR ANGLES.SDR GTIA012263Structure · crackedFTW - FORWARD CARGO COMPARTMENT HAS A CRACK BETWEEN STATION 465-484 BETWEEN LONGERON 30 AND 29L. FORMED INTERCOSTAL IAW DOUGLAS PRING SR09530005. FORMED AND INSTALLED REPAIR PARTS. (M)SDR COMA0160945Web · crackedDURING INSPECTION I/A/W E.O. 53-021 OF ENGINE SUPPORT BOX BEAM, A 1.0 INCH CRACK WAS FOUND IN THE LOWER WEB L/H ACCESS PANEL CUTOUT OF F.S. 630 BL 40 LT.C/W REPAIR I/A/W REO 601R-53-61-366.SDR COMA0160944Web · crackedDURING INSPECTION I/A/W E.O. 53-021 OF ENGINE SUPPORT BOX BEAM, A .250 INCH CRACK WAS FOUND IN THE UPPER WEB AT F.S. 640 AND BL 9.5 RT.C/W TEMPORARY REPAIR I/A/W REO 601R-53-61-345.SDR 0104499994Tee Fitting · crackedDuring H ck at ATL, a tee at sta 756 floor beam outboard end LHS was found cracked. Material 7075-t6511 Aluminum. Repaired per EA 99-185274.SDR SWAA013132Web · crackedDURING SCHEDULED D CHECK, FOUND CREASE BEAM WEB CRACKED AT BS 616, RBL 64 AND WL 208. REMOVED AND REPLACED WEB PER SRM.SDR SWAA013137Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND VERTICAL BEAM WEBS CRACKED (2 EA) AT BS 178, WL 183, RBL 17.1 AND LBL 17.1. REPAIRED WEBS PERSWA RA.SDR SWAA013119Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND VERTICAL BEAM WEB CRACKED AT BS178, RBL 17.1. R&R WEB PER SRM.SDR SWAA013117Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND BULKHEAD WEB CRACKED AT BS 178, WL 234 & LBL 12. REPAIRED WEB PER SRM.SDR SWAA013116Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND VERTICAL BEAM WEB CRACKED AT BS 183, WL 233 & RBL 17.1. R&R WEB PER SRM.SDR MWEA011439Support Fitting · crackedAREA OVER CENTER WING LATERAL FLOOR SUPPORT BEAM ATTACH ANGLE IS CRACKED AT STATION 566 XCW 40 LEFT -- REMOVED FLOOR SUPPORT FITTING AND INSTALLED REPAIR ANGLE.SDR MWEA011438Longeron · crackedLEFT LAV HAS A CRACKED LONGERON AT FUSELAGE STATION 786 AND LONGERON 17 LEFT -- INSTALLED LONGERON REPAIR SPLICE SECTION.SDR MWEA011437Longeron · crackedRIGHT LAV HAS A CRACKED LONGERON AT FUSELAGE STATION 786 LONGERON 17 LEFT -- REMOVED DAMAGED SECTION OF LONGERON AND INSTALLED LONGERON REPAIR SPLICE.SDR MWEA011435Intercostal · crackedINTERCOSTAL BETWEEN FUSELAGE STATION 880 & 859 CRACKED AT RADIUS NEXT TO 859 ABOVE LONGERON 16 RIGHT -- INSTALLED REPAIR ANGLES.SDR MWEA011434Longeron · crackedFUSELAGE STATION 925 CRACKED AT LONGERON 17 RIGHT -- STOP DRILLED CRACK AND INSTALLED REPAIR ANGLES.SDR MWEA011440Beam · corrodedHEAVY CORROSION ON TOP OF FLOOR BEAM RIGHT HAND LAVE AROUND AND IN A SCREW HOLE APPROXIMATELY 2 FEET INBOARD FROM WALL AT FUSELAGE STATION 801 -- REMOVED, FABRICATED AND INSTALLED NEW FLOOR BEAM.SDR MWEA011436Clip · crackedCRACK INDICATION USING EDDY CURRENT ON ANGLE ON AFT SIDE OR FRAME AT STATION 544 LONGERON 10 LEFT. CRACKED IN TWO PLACES AROUND RIVETS -- REMOVED AND INSTALLED NEW CLIP.SDR MWEA011433Web · corrodedLIGHT CORROSION AROUND FASTENER HOLES AT STATION 714 AT LONGERON 25 RIGHT -- FABRICATED AND INSTALLED DOUBLER.SDR GTIA011111Door Frame · corrodedFTW - AFT CARGO COMPARTMENT JAMB AREA PLATE HAS CORROSION BETWEEN STATION 1155, 1211. FOUND CORROSION TO BE OUT OF LIMITS IAW MD80 SRM 53-01. REMOVED CARGO DOOR JAMB BEAM. INSTALLED NEW AFT CARGO DOOR JAMB BEAM IAW MD80 SRM 51-30-5. (M)SDR TSAA0153157Window Frame · crackedPERFORMED WINDOW CORNER FASTENER HOLE INSPECTION PER S/B 737-53A1177R6 AND DISCOVERED DEFECTS IN NUMEROUS AREAS AT LT FUSELAGE WINDOW CORNERS; 2 BETWEEN BS 500-520 AND 33 BETWEEN BS 727-907, RT FUSELAGE WINDOW CORNERS; 8 BETWEEN BS 360-540 AND 1 AT BS 727A-727SDR QXEA0102002Shear Tie · corrodedPDX - AFT CARGO BAY FRAME 15205 CASTELLATION TIE IN TO BELLY SKIN AT STRINGER 74 HAS CORROSION ON TOP SURFACE AROUND RIVET HOLE. REPAIRED IAW FOKKER SRM 53-02-13, SRM 51-10-04 AND SRM 51-31-01.
Back to JASC 5310