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 MWEA011188Shear Tie · crackedSHEAR TIE CRACKED BETWEEN LONGERONS 14 RIGHT AND 15 RIGHT AT STATION 946. -- FABRICATED AND INSTALLED SHEAR TIE.SDR MWEA011187Intercostal · dentedAFT CARGO BAY HAS A DENTED INTERCOSTAL BETWEEN FLOOR BEAMS 918-937 AT AIRCRAFT CENTERLINE. -- FABRICATED AND INSTALLED INTERCOSTAL.SDR USAA011156Frame · corrodedCLT - FOUND FRAME CORRODED 2 INCHES BY 5 INCHES, BS 500 BL0. CORROSION LEVEL 1, TASK NR 90-25-01. CUT OUT DAMAGE ON FRM, HFEC INSPECTION FMD PARTS, HT TREAT/INSTALLED PER SRM 53-10-4/51-10-6/53-30-1. (M)SDR SWAA012462Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 188, STR 17L. REPAIRED FRAME PER SRM.SDR SWAA012461Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, BETWEEN STR 8R & 9R. REPAIRED FRAME PER SRM.SDR SWAA012460Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CORRODED AT BS 986.5, BETWEEN STR 21R & 22R. R&R SHEAR TIE PER SRM.SDR 2001UALA01878Shear Tie · corrodedMAJOR BODY STATION 743 STRINGER 37R-38R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01877Shear Tie · corrodedSTATION 743 STRINGER 37R-38R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01873Shear Tie · corrodedSTATION 1219 STRINGER 37R-38R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01871Shear Tie · corrodedSTATION 1219 STRINGER 35R-36R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01869Shear Tie · corrodedSTATION 1351 STRINGER 33R-34R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01868Shear Tie · corrodedSTATION 1219 STRINGER 36L-37L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01865Shear Tie · corrodedSTATION 1219 STRINGER 36L-37L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01864Shear Tie · corrodedSTATION 1285 STRINGER 38L-39L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01861Shear Tie · corrodedSTATION 1175 STRINGER 38L-39L SHEARTIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEARTIE REPAIR.SDR 2001UALA01859Shear Tie · corrodedBODY STATION 742 STRINGER 34L-33L SHEAR TIE CORRODED. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR SWAA012420Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIP CRACKED, BS 663, STRINGER 10R. R&R STRINGER CLIP PER SRM.SDR SWAA012418Frame · crackedDURING SCHEDULED D CHECK AT DALFORT, FOUND FUSELAGE Z-FRAME CRACKED, BS 787, STRINGER 8R. R&R Z- FRAME SECTION PER SRM.SDR SWAA012417Frame · crackedDURING SCHEDULED D CHECK AT DALFORT, FOUND FUSELAGE FRAME SHEAR TIE CRACKED, BS 360, BETWEEEN STRINGERS 14R-15R. REPAIRED SHEAR TIE PER SRM.SDR 01FDEA00773Beam · crackedMAIN CABIN DOOR UPPER CUTOUT SILL BEAM CRACKED AT BS 606 BETWEEN STR 2L & 3L. REMOVED AND REPLACED BEAM PER EA 7-5310-33368.SDR AWXA0002238Shear Tie · corrodedD: Clip corroded at BS 967 between STR 27R and 26RC: Repaired shear tie at BS 967 STR 27-26R IAW B737 SRM 53-00-07 pgs 219-221SDR SWAA012456Clip · crackedDURING SCHEDULED D CHECK, FOUND STR CLIPS CRACKED ( 4 EA ) AT BS 887, STR 4L & 4R, BS 328, STR 24R, BS 663, STR 10R. R&R STR CLIPS PER SRM.SDR SWAA012448Clip · crackedDURING SCHEDULED D CHECK, FOUND STR CLIPS CRACKED ( 2 EA ) AT BS 727, STR 2L & 2R. R&R STR CLIPS PER SRM.SDR UPS01236756Web · crackedINSPECTION TYPE:C SUSPECT CRACK R/H NLG PRESSURE WEB RBL 23 BS 293.5 NDT TO LOCATE CRACK ENDS, STOP DRILLED AND REPAIRED IAW SRM 51-40-2SDR AWXA0002201Doubler · crackedD: Internal doubler cracked P/N 65-50531-523 STA 227.8 C: Internal doubler repaired IAW SRM 51-10-2 and DWG 65-50531 (RH side)Repaired damaged doubler, fabbed new doubler from 2024-T3 040. Treated and installed REF SRM 51-10-2SDR MWEA011150Clip · crackedKEEL BEAM FORWARD END CLIP ON, LEFT SIDE IS CRACKED AND FASTENER HEAD IS SHEARED OFF, LOCATED AT STATION 609 BOTTOM END. -- FABRICATED AND INSTALLED FITTING/CLIP.SDR MWEA011167Former · crackedON FORWARD SIDE OF AFT PRESSURE BULKHEAD, LEFT SIDE STATION Z24 FORMER IS CRACKED ON OUTBOARD EDGE. -- FABRICATED AND INSTALLED FORMER.SDR MWEA011166Former · crackedAFT PRESSURE BULKHEAD FORMER ON LEFT SIDE STATION Z34 IS CRACKED ON OUTBOARD END. (FORWARD SIDE OF APB). -- REMOVED AND REPLACED FORMER.SDR MWEA011165Former · crackedON FORWARD SIDE OF AFT PRESSURE BULKHEAD, LEFT SIDE FORMER AT STATION Z14 HAS CRACK AT OUTBOARD END. -- REMOVED AND REPLACED FORMER.SDR MWEA011164Strap · misalignedVENTRAL DOOR JAMB UPPER STRAP HAS MISALIGNED HOLES. FABRICATED AND INSTALLED STRIKER STRAP.SDR MWEA011163Shear Tie · out of toleranceAFT CARGO BAY STATION 996 SHEAR TIE IS BLENDED OUT OF LIMITS BETWEEN LONGERON 23 TO 26 RIGHT. -- REMOVED AND REPLACED SHEAR TIE.SDR MWEA011161Clip · crackedTIE CLIP CRACKED THAT ATTACHES HORIZONTAL STIFFENER TO AFT PRESSURE BULKHEAD BETWEEN LONGERONS 16 LEFT AND 17 LEFT STATION 996. -- REMOVED AND REPLACED TIE CLIP.SDR MWEA011160Clip · crackedTIE CLIP CRACKED THAT ATTACHES HORIZONTAL STIFFENER TO AFT PRESSURE BULKHEAD BETWEEN LONGERONS 15 LEFT AND 16 LEFT STATION 996. -- REMOVED AND REPLACED NEW TIE CLIP.SDR MWEA011159Clip · crackedTIE CLIP CRACKED THAT ATTACHES HORIZONTAL STIFFENER TO APB AT LONGERON LEFT 15 STATION 996. -- REMOVED AND REPLACED TIE CLIP.SDR MWEA011157Floor Support · crackedFORWARD CARGO COMPARTMENT FRAME AND FLOOR SUPPORT HAVE A CRACK AT STATION 408 AT LONGERON 26 LEFT. -- FABRICATED AND INSTALLED SPLICED REPAIR. WELDED AND INSTALLED FLOOR SUPPORT.SDR MWEA011156Intercostal · dentedAFT CARGO BAY HAS A DENTED INTERCOSTAL BETWEEN FLOOR BEAMS 899 AND 918 AT AIRCRAFT CENTER LINE. -- FABRICATED AND INSTALLED INTERCOSTAL.SDR MWEA011151Angle · crackedKEEL BEAM AREA RIGHT SIDE, FRAME STATION 622 IS CRACKED ON OUTBOARD END. -- FABRICATED AND INSTALLED ANGLE.SDR MWEA011149Frame · crackedKEEL BEAM AREA LEFT SIDE, FRAME STATION 637 END CLIP HAS A CRACK ON OUTBOARD END. -- REMOVED AND REPLACED FRAME SEGMENT.SDR ASAA0110564Shear Tie · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND SHEAR TIE AT BS 767, STRINGER 25L-27L CORRODED. REPAIRED PER SRM. (M)SDR MALA010675Angle · corrodedFound during 4K-check in CWA, Frame and Angle at Sta 258 has heavy corrosion. Maintenance installed new Angle PN 7253722-001 and completed Frame repair IAW SRM 53-70-30-5.SDR MALA010676Seat TrackDuring 4K-check in CWA, LH Center Aisle seat track LBL 18.3 has heavy corrosion at Sta 297. Maintnenance repaired Seat Track IAW SR 53-70-60-2.Completed MAL EO S53060.SDR SWAA012434Tie · crackedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CRACKED AT BS 500A, LBL 25. R&R SHEAR TIE PER SRM.SDR CALA0100799Pan · corrodedINSPECTION FOUND FORWARD BAGGAGE BIN JAMB PAN CORRODED AT MID LOWER EDGE STA 344. A NEW PAN SECTION WAS INSTALLED IAW SRM 53-05, FIGURE 44.SDR USAA011149Web · crackedCLT - FOUND WEB CRACKED 1 INCH, BS 178 BULKHEAD AT WL 207.5 AT RBL 1 TO 2. INSTALLED DOUBLER DAMAGE. REMOVED HFEC DONE. PER EO 5300V153 EA 69902, SRM 53-10-08 FIG 211. (M)SDR SWAA012388Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND VERTICAL BEAM WEBS CRACKED ( 2 EA ) AT BS 180, WL 224, RBL 17.1 & BS 185, WL 227, LBL 17.1. R&R WEBS PER SRM.SDR SWAA012435Stringer · crackedDURING SCHEDULED D CHECK, FOUND STR CRACKED AT BS 807, STR 16L. REPAIRED STR PER SRM.SDR 01FDEA00767Shear Tie · corrodedCORROSION C53-113-01(1) ON FRAME BS 720 LBL 4 TO RBL 4 WL 149 AFT SIDE OF FRAME. REMOVED AND REPLACED SHEAR TIE 51-30-2, 51-31-000-2, 51-20-1, 51-20-021-7, 51-20-031-7.SDR 01FDEA00789Frame · crackedN 527 FUSELAGE TRANSVERSE FRAME CRACKED AT STA Y=1571 LEFT ALONG LONGERON 12L. ** S/D ** COMINGSDR F3LA200100103Intercostal · crackedDURING C-3 CHECK, INSPECTION REPORTED CRACK IN INTERCOSTAL AT BS 178, WL 195, RBL 24. MAINTENANCE REPAIRED INTERCOSTAL PER SRM 737-300 MM 53-10-08.SDR F3LA200100102Intercostal · crackedDURING C-3 CHECK, INSPECTION REPORTED CRACK IN INTERCOSTAL AT BS 178, WL 195, LBL 24. MAINTENANCE REPAIRED INTERCOSTAL PER SRM 737-300 MM 53-10-08.
Back to JASC 5310