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 0103619853Bulkhead · crackedA radial crack was found in the 5910130-13 doubler that ran under the 5910130-11 channel. Inspection was unable to verify if the radial crack had terminated in a fastener hole or if it had been previously stopdrilled since the 5910130-11 channel covers the endSDR SWAA012689Angle · crackedDURING SCHEDULED SPECIAL VISIT, FOUND L ANGLES CRACKED ( 2 EA ) AT BS 178, WL 207, LBL 24 & RBL 24. R&R ANGLES PER SRM.SDR MWEA011361Doubler · dentedSKIN DENTED AT STATION 330, LONGERON 26 APPROXIMATELY 1 1/4 INCH BY .046 DEEP RIGHT HAND SIDE. -- REMOVED DAMAGE, INSTALLED INTERNAL DOUBLER AND FLUSH PLUG.SDR MWEA011343Door Frame · damagedVENTRAL DOOR JAMB HAS 4 EACH HOLES THAT ARE ELONGATED. HOLES ARE UNDER SILL PLATE. FABRICATED AND INSTALLED SCUFF PLATE AND REPAIR DOUBLER.SDR MWEA011357Intercostal · bentFORWARD PIT INTERCOASTAL IS BENT LOCATED BETWEEN FRAMES 484 AND 503 BEWEEN LONGERONS 28 LEFT AND 27 LEFT. -- FABRICATED AND INSTALLED INTERCOSTAL.SDR MWEA011340Fitting · crackedFRAME FITTING CRACKED, STATION 427, LONGERON 28 LEFT -- FABRICATED AND INSTALLED FITTINGSDR MWEA011339AngleTOOL DAMAGE, CORROSION AROUND BN NUT, ONE ELONGATED FASTENER HOLE AND THREE EMPTY FASTENER HOLES, FORWARD CARGO DOOR JAMB BAY, STATION 427 TO 435, LONGERON 28 RIGHT TO 26 RIGHT -- REMOVED, FABRICATED AND INSTALLED REPAIR ANGLE.SDR MWEA011355Intercostal · bentFORWARD PIT INTERCOSTAL IS BENT BETWEEN FRAMES 351 AND 370 AT LONGERON 29 LEFT. -- FABRICATED AND INSTALLED INTERCOSTAL.SDR AALA20011840Shear Tie · corrodedTUL - FOUND CORROSION ON SHEAR TIE STATION 680 BETWEEN STRINGER 28R AND STR 29R. REMOVED CORRODED SHEAR TIE FLANGE AND INSTALLED REPAIR ANGLE PER SRM 53-10-4 FIG 14. (M)SDR AALA20011839Shear Tie · corrodedTUL - FOUND CORROSION ON SHEAR TIE STATION 700 BETWEEN STRINGER 28R AND 29R. TRIMMED OFF DAMAGED SECTION OF SHEAR TIE AND INSTALLED REPAIR AT SKIN ATTACHMENT AS PER SRM 53-10-4 FIG 15 SHEET 3. (M)SDR SWAA012675Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BULKHEAD WEB CRACKED ( 2 EA ) AT BS 178, LBL 5, WL 198 & WL 201. REPAIRED WEB PER SRM.SDR AALA20011928Stop Fitting · crackedTUL - FOUND LEFT CENTER VAULT DOOR CUTOUT STOP SUPPORT CASTING HAS VISUAL INDICATION OF CRACK OF BOTTOM OF PAD BOLT. INSTALLED SERVICEABLE CASTING SRM 51-01. (M)SDR USAA011268Door Frame · crackedCLT - FOUND DOOR FRAME CRACKED .200 INCH, FORWARD SERVICE DOOR AFT FRAME NR 3 FITTING CUT OUT. INSTALLED DOUBLER PER EA 85464. (M)SDR SWAA012663Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND CEILING PRESS PANEL CUTOUT CRACKED (1 INCH ) IN NOSE W/W AFT INBD CORNER. REPAIRED PANEL CUTOUT PER SWA T1-235-001.SDR ABXA010504Rib · crackedFUSELAGE RIB AT FS 880 LEFT WAS CRACKED. MAINTENANCE REPLACED THE RIB AT FS 880 LEFT, IAW DC-8 SRM 51-1-21.SDR ABXA010505Longeron · crackedL24L FOUND CRACKED AT FORWARD MAIN ATTACH BOLT HOLE. MAINTENANCE REPLACED L24L IAW REA D853-41938MR.SDR ABXA010508Skin · crackedFUSELAGE EXTERIOR SKIN AT LEFT MID SERVICE DOOR CUTOUT FS 1287, CRACKED AT DOOR STRUT ATTACH POINT. MAINTENANCE INSTALLED A DOUBLER REPAIR AT FUSELAGE IAW REA D853-41936MR.SDR ABXA010511Doubler · corrodedCORROSION FOUND AT FUSELAGE STATION 960 LEFT AT FLOOR LINE FINGER DOUBLER. MAINTENANCE INSTALLED DOUBLER REPAIR IAW REA D853-41935MR.SDR MWEA011301Shear Tie · crackedSHEAR TIE CRACKED, STATION 1437, LONGERON 3 RIGHT. -- REMOVED AND REPLACED SHEAR TIE.SDR MWEA011300Shear Tie · crackedSHEAR TIE CRACKED, STATION 1437, LONGERON 3 LEFT. -- REMOVED AND REPLACED SHEAR TIE.SDR MWEA011298Gusset · corrodedFO'S CLEARVIEW WINDOW SILL LOWER AFT CORNER HAS A CORRODED GUSSET. -- BLENDED AREA UNDER GUSSET FOR CORROSION.SDR MWEA011292Shear Tie · corrodedMID CARGO BAY SHEAR TIE AND FUSELAGE SKIN AT STATION 807 HAVE AREAS OF LIGHT CORROSION BETWEEN LONGERON 28 THROUGH LONGERON 29 RIGHT. FABRICATED AND INSTALLED SHEAR TIE.SDR MWEA011284Shear Tie · corrodedAFT CARGO COMPARTMENT SHEAR TIE STATION 1338 HAS LIGHT CORROSION ON FORWARD SIDE AT LONGERON 23 LEFT. REMOVED AND REPLACED SHEAR TIE.SDR SWAA012666Tie Clip · crackedDURING SCHEDULED 1/4D CHECK, FOUND STRINGER TIE CLIPS CRACKED ( 2 EA ) AT BS 400, STR 4R, BS 767, STR 11L. R&R TIE CLIP PER SRM.SDR F3LA200100110Door Frame · corrodedDURING C-3 CHECK, INSPECTION REPORTED CORROSION ON LT SIDE OF E&E DOOR CUTOUT BETWEEN CHORD AND SKIN. REMOVED DOOR FITTINGS, CORRODED WEBS, SKIN AND CHORDS. INSTALLED NEW CHORDS, WEBS AND STIFFENERS, NEW SKIN, FASTENERS, DOOR FITTINGS AND ALL RELATED HARDWARSDR F3LA200100109Door Frame · crackedDURING C-3 CHECK, INSPECTION REPORTED AFT CARGO COMPARTMENT DOOR FRAME CRACKED AT LOWER SET OF BACK FASTENERS. REPAIRED PER SRM 51-40-04.SDR SWAA012692Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 927, BBL 0. REPAIRED FRAME PER SRM.SDR SWAA012650Beam · crackedDURING SCHEDULED SPECIAL VISIT, FOUND VERTICAL BEAM WEBS CRACKED ( 3 EA ) AT BS 178, LBL 17.1 & WL 229, BS 185, RBL 17.1 & WL 232, BS 178, RBL 17.1 & WL 220. R&R VERTICAL BEAMS PER SRM.SDR SWAA012649Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BULKHEAD WEB CRACKED ( 2 EA ) AT BS 178,WL 234, LBL 12 & RBL 9. REPAIRED WEB PER SRM.SDR USAA011263Shear Tie · damagedCLT - FOUND SHEAR TIE WITH WORKING FASTENERS, STATION 360 ATTACH LUG, BETWEEN STRINGER 28R AND 27R. REPAIRED SHEAR TIE PER SRM 53-10-4 FIG 9A. (M)SDR UPS01836977Longeron · crackedINSPECTION TYPE: C1, STA. 965 LONG. 24R IS CRACKED ON BOTTOM SIDE. REPAIRED LONGERON I.A.W. SRM. 53-2-2 FIG. 5SDR AALA20011882Window Frame · crackedTUL - FOUND PASSENGER WINDOW FRAME CRACKED ON RIGHT SIDE STATION 947 UPPER FORWARD CORNER. ROUTED OUT CRACK. INSTALLED DOUBLER PER AARD 53-10-00-25. (M)SDR SWAA012668Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAMES CRACKED ( 2 EA ) AT BS 500A & BS 500B, STR 14R. REPAIRED FRAMES PER SRM.SDR MWEA011278Longeron · crackedLONGERON 28 LEFT CRACKED STATION 560 -- REMOVED AND REPLACED LONGERON.SDR MWEA011277Frame · crackedFRAME CRACKED AT STATION 980 LONGERON RIGHT -- FABRICATED AND INSTALLED FRAME SPLICE, LONGERON ANGLE AND FILLER FRAME MATERIALS.SDR MWEA011276Shear Tie · crackedSHEAR TIE CRACKED IN 2 PLACES AT STATION 945 LONGERON 15 RIGHT. FABRICATED AND INSTALLED SHEAR TIE.SDR MWEA011275Longeron · gougedAFT CARGO BAY LONGERON 26 LEFT IS GOUGED AT STATION 794 -- FABRICATED AND INSTALLED LONGERON AND SPLICES.SDR SWAA012607Frame · crackedDURING SCHEDULED D CHECK, FOUND FRAME FASTENER HOLES CRACKED ( 2 EA ) AT BS 827, BETWEEN STR 8R & 9R, AND BS 867, BETWEEN STR 8R & 9R. REPAIRED FRAMES PER SRM.SDR SWAA012609Frame · crackedDURING SCHEDULED D CHECK, FOUND FRAME CRACKED AT BS 360, BETWEEN STR 7L & 8L. REPAIRED FRAME PER SRM.SDR SWAA012608Frame · crackedDURING SCHEDULED D CHECK, FOUND FRAME FASTENER HOLES CRACKED ( 2 EA ) AT BS 400, STR 8 L, AND BS 360, STR 8 L. REPAIRED FRAMES PER SRM.SDR SWAA012616Fitting · crackedDURING SCHEDULED RON, FOUND NLG UPPER ACTUATOR SUPPORT T FITTING CRACKED. R&R SUPPORT T FITTING PER MM.SDR CALA0100887Door Frame · corrodedINSPECTION FOUND MID BAGGAGE BIN LOWER DOOR JAMB CORRODED AROUND H-SHEAR AT STA 636-693. A REPAIR DOUBLER AND SPACER WERE INSTALLED IAW SRM 53-05, FIGURE 63.SDR CALA0100886Door Frame · corrodedINSPECTION FOUND AFT BAGGAGE BIN LOWER DOOR JAMB CORRODED BETWEEN STA 1155-1211. A Z-ANGLE BEAM REPAIR WAS INSTALLED IAW SRM 53-05, FIGURE 63.SDR 01FDEA00851Stringer · corrodedN 489 STRINGER 28R CORRODED AT BS 498. R&R STRINGER PER SRM 53-10-1 FIG 1.SDR SWAA012585Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND VERTICAL WEB CRACKED AT BS 178, LBL 5 & WL199. REPAIRED WEB PER SRM.SDR SWAA012584Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT LH OVERWING EMERGENCY EXIT, BS 616, WL 202. REPAIRED FRAME PER SWA T1-153-018.SDR SWAA012594Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND VERTICAL WEBS CRACKED ( 2 EA ) AT BS 180, WL 207 & RBL 26, BS 178, WL 219 & LBL 12. REPAIRED WEBS PER SRM.SDR SWAA012593Beam · crackedDURING SCHEDULED SPECIAL VISIT, FOUND VERTICAL BEAMS CRACKED ( 2 EA ) AT BS 183, WL 183 & RBL 5.7, WL 223 & RBL 17.1. R&R VERTICAL BEAMS PER SWA RA 1-353-2655.SDR CA011012013Frame · cracked(CAN) APPROXIMATELY 1 INCH CRACK AT FORWARD CARGO PIT DOOR CUTOUT FRAME LOCATED BS 540 BETWEEN S20 AND S21R AT DOOR STOP.SDR UPS01436859Shear Tie · crackedINSPECTION TYPE:C M/D, SHEAR TIE CRACKED, BETWEEN S-3R AND S-4R STA 1960. SHEAR TIE REPLACED PER SRM 51-10-01.
Back to JASC 5310