JASC 5311
Service difficulty reports · 61,554
Reports filed under 5311 · Fuselage Main, Frame, 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 = '5311' 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 = '5311' 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 VTZA200500199Doubler · crackedRIGHT FRAME DOUBLER IS CRACKED IN RADIUS AT 1 INCH IN LENGTH.SDR SWAA052916Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 847, RBL 21. REPAIRED FRAME PER SRM.SDR SWAA052915Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR AFT FRAME, BOTTOM DOOR STOP CUTOUT. REPAIRED FRAME PER BFG ER.SDR SWAA052914Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR SWAA052913Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR SWAA052912Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R TO STR 9. REPAIRED FRAME PER SRM.SDR SWAA052910Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA052909Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR SWAA052908Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 294.5, L1 DOOR UPPER CUTOUT. REPAIRED FRAME PER BFG ER.SDR SWAA052897Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 20L. REPAIRED FRAME PER SRM.SDR AWXA200501271Frame · crackedMCN - DURING C18 CHECK DISCOVERED FRAME ANGLE CRACKED, .375 INCHES IN LENGTH, AT BS 500D AND STR 13L. MAINTENANCE REMOVED FRAME ANGLE FROM STR 11L TO STR 13L AND BS 500D IAW BOEING 737-300 SRM 51-40-02-0G. FABRICATED REPLACEMENT FRAME ANGLE IAW BOEING DRAWINSDR AWXA200501237Frame · crackedDURING C18 CHECK DISCOVERED FRAME ANGLE CRACKED, .5 INCHES IN LENGTH, AT BS 400 AND STR 14L. MAINTENANCE TRIMMED OUT CRACK ON FRAME IAW AMERICA WEST AIRLINES ENGINEERING REPAIR NR 03-5332-05284-HF1. FABRICATED REPAIR ANGLE, SPLICE ANGLE AND FILLER IAW AWA ERSDR 2005UALA01031Frame · crackedAFT CABIN FRAME IS CRACKED AT STA 827 NEAR STR 8L MARKED. FABRICATED AND INSTALLED ANGLE, FILLER AND SUPPORT PER MM 53-10-84SDR 2005UALA01030Frame · crackedAFT CABIN STA 867 FRAME IS CRACKED NEAR STR 8L. FABRICATED AND INSTALLED REPAIR PARTS WITH REF. TO MM CHAPT 53-10-84. FABRICATED NEW RAIL SUPPORT BRACKET.SDR 2005UALA01029Frame · crackedAFT CABIN FRAME IS CRACKED AT STA 787 NEAR STR 8L MARKED. FABRICATED ANGLE,FILLER & SUPPORT BRACKET PER MM 53-10-84 AND INSTALLED.SDR 2005UALA01028Frame · crackedAFT CABIN FRAME IS CRACKED AT STA 907 NEAR STR 8L. FABRICATED AND INSTALLED REPAIR PARTS WITH REF TO MM 53-10-84. FABRICATED NEW RAIL SUPPORT BRACKET.SDR 05FDEA03069Frame · puncturedLOWER FUSELAGE STATION 808 FRAME HAS PUNCTURE DAMAGE FROM SKIN SIDE OF J-ANGLE AT LONGERON 51L. REMOVED DAMAGE, FABRICATED NEW ANGLE SECTION AND INSTALLED REPAIR SPLICE AND FILLER IAW DC10 SRM 53-30-00 FIG 5 VOL I.SDR 2005UALA01020Frame · crackedAFT CABIN FRAME IS CRACKED AT STA 867 NEAR STR 8R, AROUND FASTENER HOLE. REMOVED DAMAGED AREA ON FRAME. VERIFIED CRACK WAS REMOVED BY HFEC INSPECTION. FABRICAT ED AND INSTALLED REPAIR ANGLES. ANGLES FORMED FROM 7075-0 MAT ERIAL AND HEAT TREATED TO 7075 T6. FSDR 05FDEA03060Frame · corrodedCORROSION, FWD CARGO BAY (C53-111-01(2)) ON FRAME BS 660 BETWEEN BL 0 AND STRINGER 38RT (ON FWD SIDE OF FRAME). REPAIRED FRAME AT BS 660 BETWEEN BL0 AND STR 28RT IAW SRM 51-40-2.SDR 05FDEA03059Frame · dentedFORWARD CARGO BAY, FRAME IS DENTED ON IB FLANGE AT BS 560 BETWEEN STRINGER 24 LT AND 25 LT. REPAIRED FWD CARGO BAY FRAME AT BS 560 BETWEEN STR 24LT & 25LT PER SRM 51-40-3.SDR 05FDEA03057Frame · dentedFWD CARGO BAY, FRAME IS DENTED ON IB FLANGE AT BS 520 BETWEEN STR 22 LT AND 25 LT. REPAIRED PER SRM 53-10-1, 51-30-2, 51-40-3 FIG 1 MAJOR REPAIR.SDR 05FDEA03058Frame · dentedFORWARD CARGO BAY, FRAME IS DENTED ON IB FLANGE AT BS 520 BETWEEN STRINGER 24 RT AND 26RT. REPAIRED FRAME AT B.S. 520 STR 24R & 26R PER SRM 51-40-3.SDR 05FDEA03056Frame · dentedDENT IN FRAME BETWEEN STR 24R-25R BS 660. REPAIRED DENT IN FRAME AT B.S. 660, STR 24R-25R PER SRM 51-40-3.SDR 05FDEA03055Frame · dentedDENT IN FRAME AT BS 660 STR 24L. REPAIRED DENT IN FRAME AT B.S. 660 STR 24L PER SRM 51-40-3.SDR 05FDEA03054Frame · dentedFORWARD CARGO BAY, FRAME IS DENTED ON IB FLANGE AT BS 680 STRINGER 25 RT. REPAIRED FRAME AT BS 680 STR 25R PER SRM 51-40-3.SDR USAA051142Frame · crackedFRAME CRACKED BS 380 JUST BELOW STR 8L. CUT OUT CRACKED AREA, INSTALLED REPAIR PER T/R 53-10-20B, DEFECT SIZE: APPROX 1 INCH CRACK.SDR ASAA0540497Frame · crackedRT APU CHORD AT FWD HINGE CUTOUT CRACKED. REMOVED AND REPLACED CHORD IAW SRM. (K)SDR ASAA0540496Frame · crackedPAE FRAME CRACKED BIN RAIL SUPPORT BETWEEN STR 8 AND 9 LT AT IB FASTENER. REPAIRED DAMAGED FRAME AT BIN RAIL SUPPORT IAW SRM. (K)SDR 72400005Frame · crackedA 1 INCH CRACK ON FUSELAGE FRAME.SDR ASOA05783Frame · crackedDURING A C-CHECK IN MCN, THE LEFT FS 718 FRAME REPAIR WAS FOUND TO POSSIBLY BE CRACKED. S/D - MAINTENANCE INSTALLED A NEW 718 DOUBLER AND A NEW REPAIR DOUBLER IAW BOMBARDIER REO601R-53-61-243. (M)SDR AWXA200501200Frame · crackedMCN - MAJOR REPAIR - DURING C18 CHECK DISCOVERED FORWARD CARGO COMPARTMENT DOOR FRAME CRACKED, 1.5 INCHES IN LENGTH, AT THE UPLOCK AT BS 445 AND STR 24R. MAINTENANCE REMOVED THE CRACKED FRAME IAW BOEING 737-300 SRM 51-40-02-0G FIG 8 AND FIG 11. INSTALLED NEWSDR SWAA052887Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STUB FRAMES CRACKED AT BS 188, LT & RT SIDE, WL 208. REPAIRED STUB FRAMES PER SRM.SDR 05FDEA03035Frame · dentedAFT CARGO BAY, FRAME IS DENTED AT BS 950C BETWEEN STR 25R AND STR 26R. REPAIRED FRAME AT BS 950C, STR 25R-26R PER SRM 51-40-3.SDR 05FDEA03034Frame · dentedFRAME DENTED AT BS 970, ABOVE STR 26L. REPAIRED PER SRM 53-10-1.SDR 05FDEA03033Frame · dentedFRAME DENTED AT BS 990, BELOW STR 25L. REPAIRED FRAM AT BS 990 STR 25L PER SRM 51-40-3.SDR 05FDEA03032Frame · dentedFRAME DENTED IN 2 PLACES AT BS 1050, STR 23L AND 25L. REPAIRED FRAME AT BS 1050 STR 23L & 25L PER SRM 51-40-3.SDR 05FDEA03031Frame · dentedFRAME DENTED AT BS 1050, BELOW STR 26R. REPAIRED FRAME AT B.S. 1050 BELOW STR 26R PER SRM 51-40-3.SDR 05FDEA03030Frame · dentedFRAME DENTED AT BS 1130, STR 26L. REPAIRED FRAME AT BS 1130 STR 26L PER SRM 51-40-3SDR 05FDEA03029Frame · dentedFRAME DENTED AT BS 1130, STR 26L. REPAIRED FRAME AT BS 1130 STR. 26L PER SRM 51-40-3.SDR 05FDEA03028Frame · dentedAFT CARGO BAY, BS 950B FRAME BETWEEN STR 25R AND STR 26R HAS A DENT. REPAIRED FRAME AT BS 950B STR 26R PER SRM 51-40-3.SDR 05FDEA03027Frame · dentedFRAME DENTED AT BS 1070, JUST BELOW STR 25R. REPAIRED FRAME AT B.S. 1070, STR 25R PER SRM 51-40-3.SDR SWAA052879Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 494, FWD CARGO DOOR CUTOUT LOWER STOP FITTING. REPAIRED FRAME PER SWA EA.SDR SWAA052873Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907 BETWEEN STR 8L & STR 9L. REPAIRED FRAME PER SRM.SDR ASAA0510308Failsafe · cutYXX - FOUND FAIL/SAFE AT BS 360 TO BE CUT FOR ACCESS AT STRINGER 26 RT. REPAIRED IAW B737-200 SRM 51-40-3 FIGURE 1. (M)SDR PIDA20050120Frame · crackedFRAME CRACKED AT BS 360 ABOVE STR 9 RT AT RAIL ATTACHMENT. REPAIRED PER SRM 53-10-4.SDR SWAA052865Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 312, STR 6R. REPAIRED FRAME PER SRM.SDR SWAA052864Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SWA EA.SDR SWAA052862Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR SWAA052861Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA052860Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 500, STR 28L TO STR 28R. REPAIRED SHEAR TIE PER SRM.
Back to JASC 5311