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 AWXA0000568Shear Tie · corrodedC-CHECK CORROSION LEVEL 1, SHEAR TIE CORRODED AT STA 947 BETWEEN STR 24L TO 26L. REMOVED AND REPLACED SHEAR TIE IAW 737 SRM 51-30-02.SDR SWAA001545Door Frame · crackedDURING SCHEDULED C4 CHECK, FOUND FWD ENTRY DOOR FRAME LOWER FWD CORNER CRACKED. REPAIRED FRAME PER MM.SDR MWEA00742Shear Tie · crackedMKE - FOUND SHEAR TIE AT STATION 639 IS CRACKED AT THE END WHERE IT ATTACHES TO THE RIGHT DRAG ANGLE. FABRICATED AND INSTALLED REPAIR ANGLES. (M)SDR MWEA00741Shear Tie · crackedMKE - FOUND SHEAR TIE AT STATION 617 RIGHT IS CRACKED WHERE SHEAR TIE ATTACHES TO RIGHT DRAG ANGLE. FABRICATED AND INSTALLED REPAIR ANGLES. (M)SDR QXEA0002463Structure · corrodedPDX- CORROSION NEAR LOWER EDGE OF VERTICAL STRUT AT FRAME 5305 JUST ABOVE STRINGER 65. REPAIRED IAW FOKKER SRM 51-10-4.SDR MWEA00730Shear Tie · crackedMKE - FRAME SHEAR CLIP CRACKED AT STATION 945 NEAR LONGERON RIGHT 15. REMOVED AND REPLACED SHEAR TIE. (M)SDR MWEA00727Shear Tie · crackedMKE - FOUND CRACK ON SHEAR TIE, FRAME STATION 980, LONGERON 14 RIGHT. REMOVED AND REPLACED SHEAR TIE. (M)SDR AT0000440Frame · lightning strikeFOUND LIGHTNING STRIKE AT WINDOW FRAME NR 50 LOWER FORWARD CORNER. BLENDED AREA AND FOUND TO BE WITHIN LIMITS IAW TIMCO REO-L00252, 51-10-3 AND 53-05 FIGURE 11.SDR USAA001236Torque Box · crackedCLT - FOUND TORQUE BOX CRACKED .25 INCH, STATION 1112, LEFT SIDE JUST BELOW UPPER TORQUE BOX. INSTALLED DOUBLER AND FILLER PER EA 67773 AND SRM 51-40-3. (M)SDR 0003021243Door Frame · corrodedDURING H/COMMISSIONING CHECK, CORROSION WAS FOUND ON THE FORWARD FACE OF THE CENTER CARGO DOOR JAMB AT BS 1781 FRAME BETWEEN L41 AND L43. REPAIRED PER EA 12-175715.SDR USAA001336Beltframe · crackedPIT - FOUND BELTFRAME CRACKED .25 INCH THREE PLACES, STATION 617, LONGERON 27R. STOP DRILLED 2 CRACKS AND ROUTED OUT 2. FABRICATED AND INSTALL REPAIR ANGLE PER EA 56203. (M)SDR SWAA001522Shear Tie · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 727E SHEAR TIE CRACKED NEXT TO KEEL BEAM, RBL 9. REPAIRED SHEAR TIE PER SRM.SDR RRXA002791Door Frame · damagedDURING A MAINTENANCE VISIT FOUND A LARGE TEAR IN STRUCTURE ABOVE MAIN CARGO DOOR CENTER (DOOR JAM) AT STA 210-220 AND L6 L AND L7L, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED PART AND INSTALLED IAW DSDR GAIA00477Shear Tie · corrodedDISCREPANCY: NO FLIGHT: FOUND DURING ROUTINE SCHEDULED MAINTENANCE AT TIMCO/OSC MAINTENANCE FACILITY. FOUND SHEAR TIE CORRODED AT BS 950B FRAME, OUTBOARD OF STRINGER S29L. REF 20626. CORRECTIVE ACTION: REPAIRED SHEAR TIE IAW B727 SRM 53-10-1 AND 53-10-4. A/C SDR MWEA00661Door Frame · crackedMKE - PASSENGER DOOR JAMB AFT WEB CRACKED AT STATION 208, LONGERON 15 LEFT. FABRICATED AND INSTALLED REPAIR DOUBLER AND FILLER. (M)SDR MWEA00652Rib · crackedMKE - EMERGENCY OVERWING EXIT DOOR AFT RIGHT, BOTTOM AFT BAY RIB HAS A CRACK ON EDGE OF LIGHTNING HOLE. FABRICATED AND INSTALLED REPAIR DOUBLER. (M)SDR MWEA00690Shear Tie · damagedMKE - SHEAR TIE HAS OBLONG HOLES FROM LONGERON 10 LEFT TO 16 LEFT AT STATION 945. REMOVED AND REPLACED SHEAR TIE. (M)SDR QXEA0002325Skin · dentedYXX- RIGHT HAND FUSELAGE HAS DENT BETWEEN STRINGER 29 AND 30 AT STATION X182.00. REPAIRED IAW HORIZON AIR EA 9-53-561 AND DHC-8 SRM 51-00-05.SDR CALA0001258Beam · corrodedINSPECTION FOUND MID CARGO DOOR FRAME LOWER BEAM CORRODED. THE MID CARGO DOOR LOWER BEAM WAS REMOVED AND REPLACED IAW SRM 51-10-4, 51-30-2, AND 51-30-5.SDR CALA0001252Fitting · corrodedINSPECTION FOUND FORWARD SERVICE DOOR GIRT BAR MOUNT FITTINGS CORRODED. THE MOUNT FITTINGS WERE REMOVED AND NEW MOUNT FITTINGS WERE INSTALLED IAW SRM 51-10-4 AND 51-30-2.SDR CALA0001251Pan · corrodedINSPECTION FOUND FORWARD CARGO DOOR LOWER DOOR JAMB PAN CORRODED AROUND FASTENER HOLES. THE LOWER DOOR JAMB PAN WAS REMOVED AND REPLACED IAW SRM 53-05.SDR ASAA0010115Frame · crackedPAE - DURING C-CHECK, THE AFT VERTICAL BULKHEAD BS 727 LEFT OUTBOARD CHORD CRACKED. REPAIRED PER EM 5310-01380. (M)SDR ASAA0010117Skin · dentedPAE - DURING C-CHECK, A DENT WAS FOUND IN THE FUSELAGE SKIN AT BS 338, STRINGER 17L, BELOW THE FORWARD ENTRY DOOR. REPAIRED PER BFG ENGINEERING REPAIR NR 00-0887PB, BAC SRM. (M)SDR AALA20001396Door Frame · corrodedTUL - FOUND CORROSION ON DOOR JAMB BEAM FROM STATION 1159 TO 1208, BOTTOM SIDES. INSTALLED DOUBLER PER AARD 53-10-00-3 OF STATION 1194. (M)SDR AALA20001393Shear Tie · corrodedTUL - FOUND SHEAR TIE CORRODED, STATION 1148-1149, LONGERON 29-30R. REMOVED SHEAR TIE. REMOVED CORROSION. REINSTALLED SHEAR TIE PER MM 20-10-15-2. (M)SDR USAA001235Door Frame · corrodedCLT - FOUND DOOR FRAME CORRODED .25 INCH, RBL 24, FS 793 FORWARD LOWER DOOR FRAME. INSTALLED DOUBLER PER SRM 53-00-07 FIG 201 AND SRM 51-70-11. (M)SDR AWXA0000531Shear Tie · crackedC-CHECK, SHEAR TIE AT STR 17R, BELOW THE RT OVERWING EXIT IS CRACKED AT STA 639. STOP DRILLED CRACK IAW 737 SRM 51-10-02, FABRICATED AND INSTALLED SHEAR WEB IAW DWG 65-C34793-5 AND 737 SRM 51-40-02.SDR UPS00434110Forging · corrodedINSPECTION TYPE:C, PLEASE REPLACE CORRODED WINDOW FORGINGS AT BS 240 - 260 LT SIDE IAW SRM. WINDOW FORGING REMOVED IAW SRM 51-30-02 NEW FORGING FITTED SRM 51-30-02 & QUERY NOTE N691UP 11/2000.SDR EISA20000113Structure · crackedDURING ROUTINE C-CHECK INSPECTION, CRACK INDICATIONS NOTED AT RT SIDE 760.95 HOLES, TOTAL OF 4 HOLES AS MARKED. INSTALLED BOEING PREVENTATIVE MOD KIT 65C36279-36 PER BOEING SERVICE BULLETIN 727-53-0197, INSTALLED 2 DOUBLERS AND 1 STRAP.SDR EISA20000111Strap · crackedDURING ROUTINE C-CHECK INSPECTION, FUSELAGE EXTERIOR SUPPORT STRAP HAS CRACKED FLANGE STR 18-A STA 940. REMOVED DAMGED SUPPORT, RECEIVED NEW SECTION OF SUPPORT, RECEIVED MOD KIT, LOCATED, DRILLED AND INSTALLED IAW B727 SRM 51-30-2, 51-30-5 AND BAC DWG 65C2906SDR PCAA0008054Structure · crackedMDT - DURING A FLEET INSPECTION THE REAR FUSELAGE STRUCTURE WAS FOUND CRACKED AT FRAME 4, STRINGER 4 ON THE LEFT SIDE. REPAIRS WERE MADE IAW RD8-55-199 AND THE AIRCRAFT WAS RETURNED TO SERVICE.SDR PCAA00087054Structure · crackedMDT - DURING A FLEET INSPECTION THE REAR FUSELAGE STRUCTURE WAS FOUND CRACKED AT FRAME 4, STRINGER 4, LEFT SIDE. REPAIRS WERE DONE IAW RD8-55-199 AND THE AIRCRAFT WAS RETURNED TO SERVICE.SDR PCAA0008053Structure · crackedMDT - DURING A FLEET INSPECTION THE REAR FUSELAGE STRUCTURE WAS FOUND CRACKED AT FRAME 4, STRINGER 4, RIGHT SIDE. REPAIRS WERE MADE IAW RD8-55-199 AND THE AIRCRAFT WAS RETURNED TO SERVICE.SDR GAIA00422BDoubler · crackedDURING INSPECTION PER SB 56-11 A CRACK WAS FOUND IN UPPER AFT CORNER OF THE LEFT COCKPIT SLIDING WINDOW FRAME INTERNAL DOUBLER. THE AIRCRAFT WAS FERRIED FROM FWA TO DFW FOR REPAIRS. THE DOUBLER WAS REMOVED AND REPLACED PER THE DC-9 SRM AND THE AIRCRAFT WAS RSDR GAIA00473Shear Tie · damagedFOUND DURING ROUTINE SCHEDULED MAINTENANCE, AT BS 1010 BETWEEN STRINGER 30L AND STRINGER 29L, FOUND A SHEAR TIE DRILLED INTO FROM A PREVIOUS REPAIR, AND SIX EACH BAD FASTENERS, REF NR 20529. FABRICATED REPAIR PARTS AND INSTALLED THEM IAW B727 SRM 53-10-4. THSDR USAA001428Beltframe · corrodedPIT - FOUND BELTFRAME CORRODED 1 INCH BY 7 INCH, STATION 1155 BETWEEN LONGERON 30 AND 29 RIGHT. BELTFRAME REPLACED WITH NEW. CORROSION LEVEL 1, TASK NR C57-53304. (M)SDR SWAA001488Strap · crackedDURING SCHEDULED D-CHECK, FOUND BS 951 FRAME STRAP CRACKED, STRINGER 5R. REPLACED FRAME STRAP PER SRM AND BAC DRAWING.SDR SWAA001483Doubler · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER 18A SHEAR BEAM DOUBLER CRACKED AT BS 695 ON LT SIDE. REPAIRED DOUBLER PER SRM.SDR CALA0001211Door Frame · bentINSPECTION FOUND LOOSE AND PULLED RIVETS IN FUSELAGE SKIN AND AFT NLG DOOR JAMB WAS BENT AND GOUGED AT STA 110. THE RIVETS WERE REMOVED AND REPLACED IAW SRM 51-30-2. THE AFT DOOR JAMB WAS REMOVED AND A NEW DOOR JAMB WAS INSTALLED IAW SRM 51-30-2, 51-10-4, 51SDR PCAA0008048Structure · crackedMDT - DURING SPOT INSPECTION, THE REAR FUSELAGE STRUCTURE AT FRAME 4 STRINGER 4 ON THE RIGHT SIDE WAS FOUND CRACKED. REPAIRS WERE MADE IAW DHC RD8-55-199. AIRCRAFT WAS RETURNED TO SERVICE.SDR MWEA00627Door Frame · crackedMKE - CRACK IN PAX DOOR JAMB WEB, AFT OF DOOR OPENING AT LONGERON 14 LEFT AT APPROXIMATELY STATION 200. FABRICATED AND INSTALLED REPAIR DOUBLER AND FILLER. (M)SDR MWEA00624Shear Tie · damagedMKE - SHEAR TIE AT STATION 1400 BETWEEN LONGERON 25 LEFT AND LONGERON 24 LEFT IS BLENDED BEYOND LIMITS. FABRICATED AND INSTALLED NEW SHEAR TIE. (M)SDR MWEA00616Shear Tie · gougedMKE - SHEAR TIE GOUGED IN RADIUS FROM LONGERON 28 LEFT, 28 RIGHT STATION 1041. INSTALLED NEW SHEAR TIE. (M)SDR MWEA00615Door Frame · crackedMKE - LEFT WHEELWELL FORWARD FRAME/STRUCTURE, FOR MLG DOOR IS CRACKED. AFT OF HYDRAULIC SERVICE PANEL ON AFT SIDE OF FRAME. INSTALLED NEW FRAME. (M)SDR MWEA00614Door Frame · crackedMKE - FOUND 2 INCH CRACK IN AFT CABIN DOOR JAMB WEB, RIGHT SIDE, NEAR UPPER CORNER. FABRICATED AND INSTALLED NEW WEB. (M)SDR MWEA00632Structure · damagedMKE - FUSELAGE EXTERIOR BETWEEN STATION 1079 AND 1098 AT LONGERON AREA 19 LEFT, AT FAIRING ATTACH POINT. THERE ARE TWO ATTACH HOLES THAT ARE OVERSIZED. FABRICATED AND INSTALLED DOUBLERS. (M)SDR USAA001151Door Frame · corrodedCLT - FOUND FRAME CORRODED 2 INCHES BY 6 INCHES, STATION 787 PLUS 6 AFT CARGO DOOR FRAME. CORROSION LEVEL 1, C53-208-01. INSTALLED DOUBLER PER SRM 51-70-11 AND 53-00-07 FIG 201. (M)SDR USAA001150Door Frame · corrodedCLT - FOUND FRAME CORRODED 2 INCHES BY 5 INCHES, FORWARD SERVICE DOOR AFT FRAME BELOW FLOOR LEVEL. CORROSION LEVEL 1, C53-107-02. REMOVED AND REPLACED Z-ANGLE PER DWG 65 45875. (M)SDR TWAA0013106Shear Tie · crackedDURING OP 15 MAINT CHECK, FORMER FOOT WAS CRACKED AT STA 945, LONGERON 15L. INSTALLED NEW FRAME PER MO 72J14 PHASE G.SDR ABXA000389Shear Tie · crackedSHEAR CLIP CRACKED AT STATION 111.000 AND REAR SPAR STRINGER 11. REPLACED SHEAR CLIPIAW DC9 SRM 51-30-5.
Back to JASC 5310