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 SWAA041932Shear Tie · crackedDURING SPV, FOUND SHEAR TIE AT BS 360, STRINGER 14L, CRACKED. REPAIRED SHEAR TIE PER SRM.SDR SWAA041927Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND BEADED PRESSURE WEB AT BS 663, LBL 33, CRACKED. REPAIRED PRESSURE WEB PER SRM.SDR UPS04243015Window Frame · crackedINSPECTION TYPE: C, REPLACE LT WINDOW FRAME AT BS 1100 P/N:65-19850-149. FRAME REPLACED WITH NEW FRAME IAW SRM 51-30-2.SDR C2XA04SH439Shear Tie · crackedSHV - DURING C-CHECK THE SHEAR TIE WAS FOUND TO BE CRACKED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SHEAR TIE IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH438Shear Tie · crackedSHV - DURING C-CHECK THE SHEAR TIE WAS FOUND TO BE CRACKED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SHEAR TIE IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR CALA0400568Shear Tie · corrodedINSPECTION FOUND SHEAR TIE CORRODED IN E&E COMPARTMENT AT STA 360, LBL 5 BETWEEN S28L AND S29L. THE CORRODED SECTION OF SHEAR TIE WAS CUT OUT AND REPAIRED IAW SRM 53-00-07, FIGURE 207, REPAIR 1.SDR 04FDEA02019Door Frame · corrodedFORWARD PIT, FORWARD DOOR FRAME STATION 886 HAS CORROSION. DOOR FRAME FOUND TO BE OUT OF LIMITS. CUT AND REMOVED CORRODED FRAME SECTION, CUT WEB TO FOM. FABRICATED -15, -13 AND WEB REPAIR DOUBLER AND INSTALLED REPAIR COMPONENTS IAW DC10 SRM 51-31-01 VOL II,SDR SWAA041914Shear Tie · crackedDURING SPV, FOUND SHEAR TIE AT BS 520, STRINGER 10R, CRACKED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR UPS04242855Door Frame · crackedINSPECTION TYPE:C, SUSPECT CRACK ON AFT CARGO DOOR FRAME SKIN FLANGE RADIUS OF NR 3 FWD STOP FITTING (REF DETAIL I FIGURE 1 FLANGE 1 OF EO SECTION B-B). HFEC CONFIRMED CRACK AND MARKED END. REMOVED CARGO DOOR BALANCE MECHANISM IAW MM 52-31-53. REMOVED AFT CSDR DLM88040697Beam · corrodedCORROSION ON C3 CARGO BIN DOOR JAMB BEAM FOUND DURING MTC VISIT. REPLACED C3 CARGO BIN DOOR JAMB BEAM PER DOUGLAS DRAWING 5936038.SDR DLM88040696Beam · corrodedCORROSION ON C2 CARGO BIN DOOR JAMB BEAM FOUND DURING MTC VISIT. REMOVED CORROSION FROM C2 BIN DOOR JAMB BEAM AND WAS FOUND TO BE OUT OF LIMITS PER SRM 53-05D FIG 63 SECTION E-E SHEET 2 AND WAS REPAIRED IAW SRM 53-05D FIG 63.SDR C2XA04SH443Rib · crackedSHV - DURING C-CHECK THE BATTERY COMPARTMENT CENTER RIB WAS FOUND TO BE CRACKED AND BENT. MAINTENANCE REMOVED AND REPLACED THE AFFECTED RIB IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH441Shear Tie · crackedSHV - DURING C-CHECK THE SHEAR TIE WAS FOUND TO BE CRACKED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SHEAR TIE IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR MWEA040119Doubler · crackedAT STATION 370 ON THE FORWARD CARGO DOOR WEB THERE IS A CRACK ON THE WEB UNDER THE FLOOR RAIL. FABRICATED AND INSTALLED DOUBLER.SDR C2XA04SH458Shear Tie · crackedSHV - DURING C-CHECK THE SHEAR CLIP ON FRAME 66 WAS FOUND TO BE CRACKED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SHEAR CLIP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WILL BE APPROVED FOR RETURN TO SERVICE UPON COMPLETION OF C-CHECK.SDR UPS04842868Bracket · gougedINSPECTION TYPE: C-3, B-PIT DOOR LINK HINGES ARE GOUGED/ WORN PORTION ON AIRFRAME (NOT DOOR). REMOVED 2 EACH EXISTING C2 DOOR LINK HINGE FITTINGS. RECEIVED NEW FITTING 2 EACH PN 4654281. LOCATED AND DRILLED TRANSFER HOLES FOR NEW HINGE FITTINGS IAW SRM 51-1-2SDR DHL2004745512Window Frame · damagedDURING A C-CHECK, THE FOLLOWING DESCREPANCIES WERE NOTED; RT "F-N" WINDOW POST CROCK INDICATION AT POINT N MOST OB BOLT HOLE TOP FRAME WINDOW NR 5 MARKED NDT X-RAY FINDING. INSTALLED RT WINDOW POST REPAIR KIT PN65635282-8 PO NR 427441 IAW S/B 727-53-0086 REV SDR C2XA04SH450Shear Tie · crackedSHV - DURING C-CHECK THE SHEAR TIE WAS FOUND TO BE CRACKED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SHEAR TIE IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WILL BE APPROVED FOR RETURN TO SERVICE UPON COMPLETION OF C-CHECK.SDR C2XA04SH449Shear Tie · crackedSHV - DURING C-CHECK THE SHEAR TIE WAS FOUND TO BE CRACKED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED TIE IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WILL BE APPROVED FOR RETURN TO SERVICE UPON COMPLETION OF C-CHECK.SDR C2XA04SH436Shear Tie · crackedSHV - DURING C-CHECK THE SHEAR TIE WAS FOUND TO BE CRACKED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SHEAR TIE IAW EMB 145 SRM 53-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH435Shear Tie · crackedSHV - DURING C-CHECK THE SHEAR TIE WAS FOUND TO BE CRACKED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SHEAR TIE IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR 04FDEA01932Shear Tie · corrodedCORROSION AND FLAKING PAINT AND PRIMER AT STATION 1821, LONGERON 51L-51R. REMOVED CORROSION IAW DC10 SRM 51-21-01 VOL 2, FOUND TO BE OUT OF LIMITS IAW DC10 SRM 58-00-01 VOL I. FABRICATED AND INSTALLED REPAIR DOUBLER IAW DC10 SRM 53-30-00 VOL I, 51-21-01 VOL SDR UPS04842869Door Frame · crackedINSPECTION TYPE: C3 B- PIT DOOR FRAME AFT SIDE CRACKED DOT NR Y52Y. MAT ID 2024-0 .071 PO 4255761 IAW SRM 52-2-0 AND 52-4-1. RECEIVED MATERIAL USED FOR REPAIR DOUBLER FROM HEAT TREAT. HEAT TREATED FROM 2024-T4 IAW TPS 1003 REV A. FABRICATED REPAIR DOUBLER ISDR ABXA040252Shear Tie · crackedSHEAR TIE CRACKED FS 1019 JUST ABOVE LONGERON 17 LEFT. REPAIRED IAW DC-9 SSRM K05159.SDR C2XA04SH437Shear Tie · crackedSHV - DURING C-CHECK THE SHEAR TIE WAS FOUND TO BE CRACKED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SHEAR TIE IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR MWEA040112Door Frame · corrodedFORWARD CARGO DOOR JAMB PAN, LOWER EDGE HAS AREAS OF SEVERE CORROSION. FABRICATED AND INSTALLED REPAIR PARTS.SDR C2XA04SH407Shear Tie · crackedSHV - DURING C-CHECK THE SHEAR TIE WAS FOUND TO BE CRACKED AT FRAME 68 AND STRINGERS 6R-7R. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SHEAR TIE IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH405Sill · corrodedSHV - DURING C-CHECK THE RIGHT HAND FLOOR SILL WAS FOUND TO BE CORRODED FROM FRAME 36 TO FRAME 41. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SILL IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR IXXA060283SWindow Frame · corrodedDURING ROUTINE C CHECK, FOUND WINDOW CUT OUT CORRODED FROM STATION 1240 TO 1260 RIGHT SIDE. REPAIRED PER ALL APPLICABLE DATA.SDR IXXA060282SWindow Frame · corrodedDURING ROUTINE C CHECK, FOUND WINDOW CUT OUT CORRODED FROM STATION 1240 TO 1260 LEFT SIDE. REPAIRED PER ALL APPLICABLE DATA.SDR IXXA060281SWindow Frame · corrodedDURING ROUTINE C CHECK, FOUND WINDOW CUT OUT CORRODED FROM STATION 1280 TO 1300 LEFT SIDE. REPAIRED PER ALL APPLICABLE DATA.SDR IXXA060280SWindow Frame · corrodedDURING ROUTINE C CHECK, FOUND WINDOW CUT OUT CORRODED FROM STATION 1320 TO 1340 LEFT SIDE. REPAIRED PER ALL APPLICABLE DATA.SDR IXXA060258SWindow Frame · corrodedDURING ROUTINE C CHECK FOUND WINDOW CUT OUT FRAME CORRODED FROM STATION Y1400 TO STATION Y1420 RIGHT HAND SIDE. REPAIRED PER ALL APPLICABLE DATA.SDR AALA20040752Beam · crackedTUL - FRAME 51 LEFT HAND GANTRY BEAM NUMBER 4 CRACKED AT LOWER OUTBOARD FLANGE AT STATION 3195. CRACK IS 2 INCHES IN LENGTH. REPAIRED PER ESO 30595 DATED 2004 JULY 01 REPAIR NUMBER 40 531500 3505.SDR SWAA041864Shear Tie · crackedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE AT BS 500D, STRINGER 27L, CRACKED. REPAIRED SHEAR TIE PER SRM.SDR SWAA041861Window Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND BOTH LT AND RT NR 1 COCKPIT WINDOW POSTS CRACKED AT UPPER CORNERS. REPAIRED RT AND LT WINDOW POSTS PER EA.SDR SWAA041859Shear Tie · crackedDURING SCHEDULED C1 CHECK, FOUND SHEAR TIE AT BS 380, STRINGER 15R, CRACKED. REPAIRED SHEAR TIE PER SRM.SDR COOSDR040003Door Frame · crackedMAIN CARGO CABIN Y STA 480 AFT JAMB BETWEEN LONGERON 21 LT AND LONGERON 19 LT, FRAME WITH WEAR AND CRACKED.SDR SWAA041841Door Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND AFT CARGO DOOR FWD FRAME CUTOUT, CRACKED. REPAIRED FRAME PER SRM.SDR 04FDEA01888Tear Strip · crackedDURING P TO F MODIFICATION TRANSITION CHECK, AFTER REMOVAL SKIN IS NOTED 2EA TEAR STRIP WITH CRACK .50 INCH LONG STA 879 AND 899 BETWEEN L46 TO L48 RIGHT SIDE. FABRICATE A NEW TEAR STRIP (INCREASE LENGTH .10 INCH TO ENSURE 2DE MARGINE) IAW SRM 51-35-01.SDR SWAA041832Stiffener · crackedDURING SCHEDULED D-CHECK, FOUND BULKHEAD STIFFENER AT BS 291.5, RT WL 240 TO RT WL 253, CRACKED. REMOVED AND REPLACED STIFFENER PER SRM.SDR 2004UALA00622Door Frame · deformedFWD LOWER E AND E DOOR FWD FRAME SECTION AND CENTER INTERCOSTAL JUST FWD OF DOOR HANDLE DEFORMED DUE TO IMPACT WITH TOW BAR. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FRAME AND INTERCOSTAL REPLACED.SDR C2XA04SH448Buttstrap · corrodedSHV - DURING C-CHECK THE LEFT BUTTSTRAP WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WILL BE APPROVED FOR RETURN TO SERVICE UPON COMPLETION OF C-CHECK.SDR C2XA04SH447Buttstrap · corrodedSHV - DURING C-CHECK THE LEFT BUTTSTRAP WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WILL BE APPROVED FOR RETURN TO SERVICE UPON COMPLETION OF C-CHECK.SDR C2XA04SH440Buttstrap · corrodedSHV - DURING C-CHECK THE CENTER OMEGA BEAM BUTTSTRAP WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED STRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA041822Crease Beam · crackedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM AT BS 580, RBL 65, CRACKED. REMOVED AND REPLACED CREASE BEAM SECTION PER SRM.SDR SWAA041813Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE AT BS 480, LBL 18, CORRODED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA041811Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE AT BS 767, BETWEEN STRINGER 25R AND STRINGER 26R, CORRODED. REPAIRED SHEAR TIE PER SRM.SDR ASAA0410298Shear Tie · corrodedPAE - FOUND SHEAR TIE CORRODED BETWEEN STRINGER 27R AND 28R BS 520 PREVIOUS FRAME SHEAR TIE REPAIR. REMOVED AND REPLACED SHEAR TIE. (M)SDR CA040708002Door Frame · crackedRT EMERGENCY EXIT DOOR REMOVED TO GAIN ACCESS TO LEVELLING DATUM PLATE TO JACK AIRCRAFT, A CRACK WAS DISCOVERED IN FRAME ON AFT SIDE OF THE DOOR. CRACK EXTENDS FROM LIGHTENING HOLE BETWEEN STRINGERS 22P AND 23P THROUGH THE FRAME RETURN ON THE INBOARD SIDE. F
Back to JASC 5310