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 QXEA200500515Crossbeam · corrodedYYC - FUSELAGE INTERIOR FLOOR SUPPORT CROSSBEAM AT FS280 IS CORRODED. REPAIRED IAW REO 670-53-11-047.SDR 050606393Door Frame · crackedPAX DOOR FRAME TOP RADIUS CRACKED AT 1 INCH IN LENGTH FORWARD OF DATUM 1 AT FS 338.90.SDR SWAA050625Door Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND R1 DOOR AFT FRAME CRACKED AT 3RD STOP FITTING. REPAIRED R1 DOOR FRAME PER SRM.SDR SWAA050617Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON SHEAR TIE AT BS 847, RBL 17, WL 154. REPAIRED SHEAR TIE PER SRM.SDR UPS05M43954Seal · looseUPPER CARGO DECK GRAY LINER AT FWD LEFT BULKHEAD WALL IS PULLED AWAY FROM SIDE LINER. RESECURED SMOKE SEAL IAW MD-11 M/M 25-59-15.SDR DHL2005805671Door Frame · crackedAFT PASSENGER DOOR AFT UPPER JAMB CORNER HAS CRACKS 0.250, 0.750 STA 1660.000 BETWEEN L-9 AND L-10L (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW SRM 53-2-0 FIG 18 TR NR 53-134, TR NR 53-199 DWG SR 08530021 DWG 5750776. REMOVED FASTENERS IAW SRM 51-1-21 PAGE 1.SDR SWAA050604Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON LT CREASE BEAM WEB AT BS 727D, LBL 68. REPAIRED CREASE BEAM WEB PER SRM.SDR SWAA050603Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON RT CREASE BEAM WEB AT BS 727B, RBL 70. REPAIRED CREASE BEAM WEB PER SRM.SDR SWAA050596Shear Tie · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND CORROSION ON SHEAR TIE AT BS 344, LBL 8-12, WL 148. REPAIRED SHEAR TIE PER SRM.SDR SWAA050595Shear Tie · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND CORROSION ON SHEAR TIE AT BS 380, LBL 5 TO RBL 5, WL 148. REPAIRED SHEAR TIE PER SRM.SDR 72300055Crease Beam · corrodedSEVERAL AREAS OF CORROSION ON BOTTOM SIDE OF WEB WITHIN A 7 INCH BY 40 INCH AREA.SDR SWAA050574Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON SHEAR TIE AT BS 344, RBL 17. REPAIRED SHEAR TIE PER SRM.SDR SWAA050572Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON SHEAR TIE AT BS 907, BL 0, WL 160. REPAIRED SHEAR TIE PER SRM.SDR SWAA050552Shear Tie · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION ON SHEAR TIE AT BS 787, BETWEEN STR 26R & 27R. REPAIRED SHEAR TIE PER SRM.SDR 050546235Door Frame · crackedPAX DOOR FRAME TOP RADIUS CRACKED AT 1 INCH IN LENGTH FORWARD OF DATUM 1 AT FS 338.90.SDR 050546234Door Frame · crackedPAX DOOR FRAME TOP RADIUS CRACKED AT 1 INCH IN LENGTH FORWARD OF DATUM 1 AT FS 320.90.SDR 2005UALA00173Shear Web · corrodedAFT CABIN FLOOR, SHEAR WEB CORRODED AT BS 1681 RBL38. AFT PRESSURE DECK SHEAR WEB DAMAGE CAUSED BY TYPICAL GALLEY AREA CORROSION. CORROSION WAS REMOVED AND DECK WEB WAS REPAIRED USING DOUBLERS AND SHIMS.SDR UPS05844021Finger Doubler · corrodedINSPECTION TYPE: C1, FINGER DOUBLER CRACKED & HAS SHEARED RIVET HEADS IN MAIN CABIN SUBFLOOR, STA 875 LBL 5. REMOVED FINGER DOUBLER & FOUND IT HEAVILY CORRODED ON UNDERSIDE. NO CORROSION NOTED ON PRESSURE WEB. FAB REPLACEMENT FINGER DOUBLER FROM 2024T3-.050SDR UPS05844012Fitting · crackedINSPECTION TYPE: C1, BATH-TUB FITTING CRACKED ON LONG 4R, STA 902. REMOVED AND REPLACED FITTING REF SRM 51-1-20D.SDR SWAA050551Crease Beam · crackedDURING SCHEDULED D-CHECK, FOUND CRACK AT LT CREASE BEAM WEB AT BS 375. REPAIRED BEAM WEB PER SRM.SDR SWAA050525Shear Web · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION AT SHEAR WEB, BS 956, RBL 21. REMOVED AND REPLACED SHEAR WEB ANGLE PER SRM.SDR SWAA050524Crease Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION ON CREASE BEAM Z-ANGLE, RT SIDE, BETWEEN BS 927 AND BS 1006. REMOVED AND REPLACED RT CREASE BEAM Z-ANGLE PER SRM.SDR CALA0500052Shear Tie · corrodedINSPECTION FOUND SKIN CLIP CORRODED AT STA 500, RBL 2 IN FORWARD BAGGAGE BIN FLOOR AREA. A REPAIR DOUBLER WAS INSTALLED IAW SRM 53-00-07 FIGURE 207.SDR UPS05844121Angle · crackedINSPECTION TYPE:C1 ANGLE CRACKED INSIDE L1 DOOR JAMB AT STA 35. NDT VERIFIED CRACK TERMINATED AT FASTENER HOLE. FAB REPAIR DOUBLER FROM SHT2027T3-.063. TREAT, PRIME, INSTALL REPAIR REF SRM 51-1-21, 51-1-8, 51-3-0, 53-2-0 FIG 1B, 51-1-21A, DWG 5597646.SDR SWAA050511Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB FROM BS 360 TO BS 371, LBL 64, CORRODED. REMOVED AND REPLACED CREASE BEAM SECTION WEB PER SRM.SDR 2005UALA00165Crease Beam · corrodedCABIN LT CREASE BEAM AT STA 670-680, LBL 64 HAS CORROSION. DAMAGE CAUSED BY TYPICAL FLOOR AREA CORROSION AT DOOR SILL LOCATIONS. ANGLE WHICH IS PART OF THE LOWER DOOR SILL INSTALLATION WAS REMOVED AND REPLACED TO ADDRESS THE OUT OF LIMITS CORROSION.SDR SWAA050465Structure · crackedDURING SCHEDULED D-CHECK, FOUND STRUCTURE CRACKED FROM BS 787 TO BS 847, STRINGER 8L. REPAIRED STRUCTURE SECTION PER SRM.SDR IXXA0500152SDoor Frame · wornDURING A ROUTINE C CHECK INSPECTION, RT FUSELAGE AFT CENTER SECTION AFT CARGO COMPARTMENT AFT DOOR AFT JAMB WEAR DAMAGE AT STA FS 1440.00, L-30R TO L-31R. MAJOR REPAIR ACCOMPLISHED REMOVAL OF FASTENERS AND DAMAGED AREA. PERFORMED AN NDT INSPECTION, FABRICATESDR SWAA050473Crease Beam · crackedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB AT BS 638, CRACKED. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR SWAA050470Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM INNER CHORD ANGLE AT BS 360, LBL 64, CORRODED. REMOVED AND REPLACED CREASE BEAM CHORD ANGLE PER SRM.SDR SWAA050463Beam · crackedDURING SCHEDULED D-CHECK, FOUND 3 EACH CRACKS ON LONGITUDINAL BEAMS FROM BS 540 TO BS 727B, FROM RBL 45 TO LBL 24. REPAIRED BEAMS PER ER.SDR 05048656Structure · burnedEVENT SUMMARY STATED LAV SMOKE IND, EMERGENCY DECLARED. PERFORMED ENG AND APU RUNS. COULD NOT DUPLICATE SMOKE. INSPECTED AND FOUND LAV WALL BEHIND ORDINANCE SIGN BURNED AND DAMAGED. REPAIRED WALL. OPS CHECK GOOD.SDR SWAA050450Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB FROM BS 927 TO BS 947, LBL 55, CORRODED. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR GTIA050045Beam · corrodedAFT PIT LOWER DOOR JAMB BEAM CORRODED AND HAS BARE METAL. REMOVED CORROSION, FABRICATED REPAIR IAW SRM. OK TO TREAT, PRIME AND TOPCOAT REPAIR. LOCATED AND DRILLED 2 DOOR STOP FITTINGS AND INSTALLED DOOR JAMB BEAM REPAIR. (K)SDR ASAA0580107Door Frame · gougedOKC C-CHECK - FWD CARGO DOOR JAMB GOUGED. REPLACED DAMAGED SECTION IAW EA. (K)SDR DHL2005781528Torque Box · lightning strikeDURING A C-CHECK, PREVIOUS REPAIR ON LOWER TORQUE BOX LIGHTENING HOLE IMPROPERLY DONE R/SIDE AT FWD STA 1243. REMOVED PREVIOUS REPAIR ON LOWER TORQUE BOX LIGHTENING HOLE R/SIDE AT FWD STA 1243 IAW B727 SRM B727 SRM 51-30-2. STOP DRILL CRACK 250 TERIMINATED ASDR ABXA050053Door Frame · crackedCRACK IN VENTRAL DOOR JAMB STRUCTURE AT UPPER RIGHT CORNER. REPAIRED DAMAGED VENTRAL DOOR JAMB IAW DC-9 SRM 53-05.SDR COMA0570017Beam · corrodedTRANSVERSE BEAM AT FS 280 FROM LBL 36 TO RBL 36 IS CORRODED ALONG THE UPPER AND LOWER EDGES. REPLACED THE TRANSVERSE BEAM AT FS 280 IAW BOMBARDIER AEROSPACE REO 670-53-11-047, BRAS EO'S 610R-53-5986, 601R-53-5987, 601R-53-5977 AND CRJ 700 SRM 51-42-06-001-001SDR IXXA0500131SFastener · missingDURING A ROUTINE C-CHECK INSPECTION FOUND RT FUSELAGE AFT CENTER SECTION LOWER PLATING OLD OMEGA ANTENNA DOUBLER MISSING ON ROW FASTENERS AND MAX PITCH EXCEEDS LIMITS AT STA FS 1322.00L, 35.5R. MAJOR REPAIR ACCOMPLISHED REMOVAL OF EXISTING REPAIR. REMOVED DASDR DHL2005781535Stop Fitting · wornDURING A C-CHECK, LT W/W AFT DOOR STOP FITTING BS 950 HAS PLAY. REMOVED LT W/W AFT BODY FAIRING AT BS 950 AND FUEL VENT TUBE IAW B727 SRM 51-30-2. FABRICATED ANGLES (2EA) FAIRING FROM 2024T3-050 PO 9001576 DIM 19.375 X 3.3125 X .75 X .75 (2EA) IAW B727 SRM 5SDR 2003792Window Frame · crackedON ROUTINE STRUCTURAL INSPECTION, ALL THREE EMERGENCY EXIT WINDOW PANS HAVE CRACKS. WINDOW PANS REPLACED, AIRCRAFT RETURNED TO SERVICE.SDR SWAA050412Shear Tie · crackedDURING SPV FOUND SHEAR TIE AT BS 540, STRINGER 10R, CRACKED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA050411Shear Tie · crackedDURING SPV, FOUND SHEAR TIE AT BS 360, BETWEEN STRINGERS 14R AND 15R, CRACKED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR WX0500021Structure · vibrationENROUTE LAS TO ICT A/C ENCOUNTERED POCKET OF SEVERE TURBULENCE AND ON RETURN FLT ICT TO LAS CREW REPORTED MODERATE AIRFRAME VIBRATION STRONGEST IN FWD FUSELAGE, SIMILAR TO HAVING FULL SPOILER DEFLECTION AND LANDING LIGHTS EXTENDED IN CRUISE FLT. THROTTLE SETSDR QXEA200500290Door Frame · bentYYC - AFT FUSELAGE - AFT BAGGAGE BAY DOOR SURROUND STRUCTURE AFT DOOR TRACK MOUNTING STRUCTURE LOWER MOUNTING BRACKET BENT. REPAIRED IAW 51-24-21-001-001-A01 AND 51-25-01-001-001-A01.SDR SWAA050407Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE AT BS 380, BETWEEN STRINGERS 13L AND 14L, CRACKED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR 05FDEA00272Shear Tie · damagedREPAIR SHEAR TIE AT BS 380 BETWEEN STR 14 AND 15 TO COMPLY WITH FED EX EO 7-5340-7--5002 P1. REPAIRED PER SRM 51-20-1, 51-20-4, 51-30-2.SDR 05FDEA00271Shear Tie · damagedREPAIR SHEAR TIE AT BS 380 BETWEEN STR 15 AND 16 LT TO COMPLY WITH FED EX EO 7-5340-5002 P1. *S/D* REPAIRED PER SRM 51-20-1, 51-20-4, 51-30-2.SDR SWAA050378Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB AT BS 840, LBL 65, CORRODED. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR SWAA050380Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE AT BS 360, STRINGER 14R, CRACKED. REMOVED AND REPLACED SHEAR TIE PER SRM.
Back to JASC 5310