JASC 5320
Service difficulty reports · 216,207
Reports filed under 5320 · Fuselage Miscellaneous 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 = '5320' 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 = '5320' 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 SWAA2022120769935Support Angle · corrodedCORRODED SUPPORT ANGLE, BS 294.5 + 3, RBL 11, WL 208.1. REPLACED THE SUPPORT ANGLE IAW SRM 51-10-02, ITEM 9, AND DWG 141A5400, SHEET 8 REV-.SDR SWAA2022120769927Angle · crackedCRACK ANGLE BS 695, RBL 24. REPLACED ANGLE IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 111A6000, SHEET 236, REV-.SDR SWAA2022120769957Angle · corrodedAFT CARGO RT SIDE PLATE CHANNEL HAS CORROSION AROUND FASTENER HOLES RBL 21, BS 727G-727H. THE TRANSITION ANGLE TO BE REPLACED ON NR TTG8Q00G0A7F.SDR SWAA2022120769958Angle · corrodedAFT CARGO RT SIDE PLATE CHANNEL HAD CORROSION AROUND FASTENER HOLES RBL 21, BS 727H-727I. THE RT TRANSITION ANGLE TO BE REPLACED ON NR TTG8Q00G0A7F.SDR SWAA2022120769959Angle · corrodedAFT CARGO R/H SIDE PLATE CHANNEL HAS CORROSION AROUND FASTENER HOLES RBL 21; BS 727I-727J. RT TRANSITION ANGLE TO BE REPLACED ON NR TTG8Q00G0A7F.SDR SWAA2022120669747Floor Support · crackedMAIN CABIN BS277 TO BS294.5 RBL 1 WL 208.1 INTERCOSTAL CRACKED AT 2 LOCATION / [01] REMOVED INTERCOSTAL CRACK AT MAIN CABIN BS. 277 TO BS. 294.5 RBL. 1. REF. SRM. 51-40-02-0G-0.;[02] VERIFIED; STEP # 1.;[03] RECEIVE; LOCATED AND DRILLE HOLES IN NEW INTERCOSTALSDR SWAA2022120669755Floor Support · crackedMAIN CABIN BS380 TO BS400 LBL 1 WL 208.1 INTERCOSTAL CRACKED / [01] REMOVED ANGLE SUPPORT AT MAIN CABIN BS 380 TO BS 400 LBL 1 WL 208.1 REF SRM 51-40-02-0G-0;[02] CORRECTION STEP;# 1: REMOVED INTERCOSTAL UPPER CHORD (ANGLE SUPPORT) AT MAIN CABINBS380 TO BS400 SDR SWAA2022120669749Floor Support · crackedMAIN CABIN BS380 TO BS400 LBL 14 WL 208.1 INTERCOSTAL CRACKED / [01] REMOVED ANGLE SUPPORT AT MAIN CABIN BS 380 TO BS 400 LBL 14 WL 208.1 REF SRM 51-40-02-0G-0;[02] VERIFIED 1. OK TO INSTALL INTERCOSTAL UPPER CHORD (ANGLE SUPPORT);[03] INSTALLED INTERECOSTAL USDR SWAA2022120669750Floor Support · crackedMAIN CABIN BS380 TO BS400 RBL 9 WL 208.1 INTERCOSTAL CRACKED / [01] REMOVED ANGLE SUPPORT OF INTERCOSTAL AT MAIN CABIN BS380 TO BS400 RBL 9. REF; SRM. 51-40-02-0G-0;[02] CORRECTION STEP.#1: REMOVED INTERCOSTAL UPPER CHORD (ANGLE SUPPORT) AT MAIN CABIN BS380 TOSDR SWAA2022120669751Floor Support · crackedMAIN CABIN BS380 TO BS400 RBL 40 WL 208.1 INTERCOSTAL CRACKED / [01] REMOVED ANGLE SUPPORT OF INTERCOSTAL AT MAIN CABIN BS380 TO BS400 RBL. 40; REF. SRM. 51-40-02-0G-0;[02] CORRECTION STEP. 1:REMOVED INTERCOSTAL UPPER CHORD (ANGLE SUPPORT) AT MAIN CABIN BS380 SDR SWAA2022120669752Floor Support · corroded'CORROSION' MAIN CABIN BS294.5 +10 LBL 12 WL 208.1 INTERCOSTAL SPOT OF CORROSION / INTERCOSTAL FOUND OUT LIMITS. REMOVED INTERCOSTAL IAW SRM 51-40-02-0G-0. LOCATED AND DRILLED THE NEW INTERCOSTAL IAW SRM 51-40-02-0G-0. APPLIED TREAT AND PRIMER IAW AMM 51-21SDR SWAA2022113069956Channel · corrodedAFT CARGO RT CHANNEL CORRODED AROUND FASTENER HOLES, RBL 21, BS 727F-727G. CHANNEL REPAIRED IAW SRM 53-00-53-2R-5, REPAIR 5, AND EAM-22-153-01550.SDR SWAA2022113069960Channel · corrodedAFT CARGO RT CHANNEL CORRODED AROUND FASTENER HOLES, RBL 21, BS 747-767. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW SRM.53-00-53-1A-1. LOCATED AND DRILLED A NEW CHANNEL IAW SRM. 53-00-53-2R-5. TREATED AND PRIMED IAW SRM. 51-20-02. INSTALLED THE NSDR SWAA2022113069966Channel · corrodedAFT CARGO RT CHANNEL CORRODED AROUND FASTENER HOLES, RBL 21, BS 767-787. REMOVED THE CHANNEL DUE TO OUT OF LIMITS IAW SRM 51-40-02. LOCATED AND DRILLED, AND INSTALLED THE NEW CHANNEL IAW SRM 51-10-02.SDR SWAA2022113069738Web · corrodedCORROSION ON WEB, BS 294.5 - 312, S22L, WL 174.1 IN THE E/E BAY. REPLACED THE WEB IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, & DWG 141A1350, SHEET 8, REV -.SDR SWAA2022113069943Channel · corrodedAFT CARGO R/H SIDE PLATE CHANNEL HAS CORROSION AROUND FASTENER HOLES RBL 21; STA 727J-747. RT TRANSITION CHANNEL REPLACED ON NR TTG8Q00G0A7F.SDR R61A2022112900759Intercostal · corrodedINTERCOSTAL AT FR 17 STR 23R CORRODED. R7R IAW SRM 51-41-01 & 51-41-02.SDR R61A2022112900750Support Frame · corrodedFWD CARGO SUPP FRAME CORRODED. R&R IAW SRM 51-41-01.SDR SWAA2022111469552Support Fitting · crackedPANEL 192E RH FWD SUPPORT FITTING CRACKED. REMOVED AND REPLACED FITTING REF SRM 51-40-02SDR SWAA2022111469553Support Fitting · crackedPANEL 192E LH FWD SUPPORT FITTING CRACKED. REMOVED AND REPLACED FITTING REF SRM 51-40-02SDR DALA2022111407308Intercostal · corrodedDURING INSPECTION FOUND CORROSION ON INTERCOSTAL BTW STA 747-767 AND STRG 25R AT AFT CARGO COMPT. INTERCOSTAL BTW STA 747-767 AND STRG 25R AT AFT CARGO COMPT WAS REPLACED PER B737-900ER SRM 51-40-02-0G.SDR DALA2022111407307Floor Support · corrodedDURING INSPECTION FOUND CORROSION ON FLOOR SUPPORT STA= 493 TO STA 500A RBL=22 AT FWD CARGO CARGO COMPARTMENT C-1. FLOOR SUPPORT STA= 493 TO STA= 500A RBL=22 AT FWD CARGO COMPARTMENT WAS REPLACED PER B737-900ER SRM 51-40-02-0G PAR.7.D. AND SRM 51-40-02-0G.SDR DALA2022111407306Floor Support · corrodedDURING INSPECTION FOUND CORROSION ON INTERCOSTALS (3EA) BTW RBL 24 AND STA'S 500A-500B, 500B-500C AND 500H-500I AT FWD CARGO COMPT. INTERCOSTALS (2EA) BTW RBL 24 AND STA'S 500A-500B AND 500H-500I WERE REPLACED PER B737-900ER SRM 51-40-02-0G PAR.7D AND INTERCOSSDR REXA2022111102536Housing · chafedAFT CARGO DOOR HAS CHAFES AROUND OUTER HANDLE CUTOUT. REMOVED AND REPLACED IAW CRJ 900 SRM 51-40-11-001-001-A01, 51-42-21-001-001-A01, AND CRJ 900 AMM 52-31-03-400-801-A01.SDR CALA2022111103120Door Sill · corrodedAFT WET AREA LH 2 DOOR SILL HAS CORROSION AT FR 68 2EA PLACES. REMOVED AND REPLACED WITH NEW LH L-2 DOOR SILL AT FR 66-68 IAW A 319 SRM 51-72-11-911-001.SDR KCSA202211071210Intercostal · corrodedAFT PIT TORQUE BOX INTERCOSTAL AT STA 1329-1351 RBL 14 HAS EVIDENCE OF CORROSIONSDR KCSA202211071209Web · corrodedAFT PIT TORQUE BOX WEB AT STA 1153-1175 BL 0 HAS EVIDENCE OF CORROSION.SDR KCSA202211071208Intercostal · corrodedAFT PIT TORQUE BOX INTERCOSTAL AT STA 1263-1285 RBL 33 HAS EVIDENCE OF CORROSIONSDR KCSA202211071207Intercostal · corrodedAFT PIT TORQUE BOX INTERCOSTAL AT STA 1329-1351 RB 16 HAS EVIDENCE OF CORROSIONSDR KCSA202211071206Intercostal · corrodedAFT PIT TORQUE BOX INTERCOSTAL AT STA 1329-1351 RBL 18 HAS EVIDENCE OF CORROSIONSDR KCSA202211071205Intercostal · corrodedAFT PIT TORQUE BOX INTERCOSTAL AT STA 1329-1351 RBL 22 HAS EVIDENCE OF CORROSIONSDR KCSA202211071204Intercostal · corrodedAFT PIT TORQUE BOX INTERCOSTAL AT STA 1329-1351 RBL 25 HAS EVIDENCE OF CORROSIONSDR KCSA202211071203Intercostal · corrodedAFT PIT TORQUE BOX INTERCOSTAL AT STA 1329-1351 RBL 33 HAS EVIDENCE OF CORROSIONSDR KCSA202211071201Web · corrodedEVIDENCE OF CORROSION IN AFT PIT STA 1328 RBL 3 FLOOR WEBSDR KCSA202211071200Web · corrodedEVIDENCE OF CORROSION IN AFT PIT STA 1328 RBL 26 FLOOR WEBSDR KCSA202211071199Fitting · corrodedEVIDENCE OF CORROSION IN AREA AFT OF BULK PIT STA 1579 STR38-39LSDR KCSA202211071198Panel · corrodedAFT PIT TORQUE BOX UPPER PANEL HAS EVIDENCE OF CORROSION AT STA 1275 RBL 2SDR V0XD2022111003Door Sill · corrodedCORROSION ON RH SILL FR 20 BY SERVICE DOOR ; REMOVED, FABRICATED, AND INSTALLED REPAIR DOUBLER ANGLE IAW EMB 145 SRM 51-40-02, EMB 145 SRM 53-21-10 FIG 204 SHTR 1SDR V0XD2022111002Plate · corrodedCORROSION ON DIGITAL PLATE BL 0 FR 15; CORRECTIVE ACTION: REPAIRED DIGITAL PLATE ON FLOOR SILL IAW EMB 135/145 SRM 53-21-10SDR V0XD2022111001Doubler · corrodedLH VERTICAL PARTITION DOUBLER AT FR61 HAS CORROSION; CORRECTIVE ACTION: REMOVED AND REWPLACED PARTITION DOUBLER ON LH VERTICAL FR 61 IAW EMB 135/145 SRM 51-40-02SDR SWAA2022120869471Angle · corrodedCORROSION ZEE ANGLE, BS 500D, S26L - 26R, WL 156.5, IN FWD CARGO BAY. REPLACED THE ANGLE IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DRAWING 143A9481, SHEET 7, REV A.SDR SWAA2022120869469Support · crackedCRACKED SUPPORT ZEE, BETWEEN BS 400 - 420, S26R IN FWD CARGO BAY. REPLACED THE SUPPORT ZEE AND FASTENERS IAW SRM 51-40-02, AND DWG 143A7500, SHEET 58, REV -.SDR COEA2022120708807Support · crackedWO 239777 NR 200074 HEAVY CHECK COE/MINOR REPAIR: FORWARD CARGO DOOR DRAIN CHANNEL SUPPORT STRUCTURE AFT OF FRAME 17 WAS FOUND CRACKED. CORRECTIVE ACTION: REPLACED SUPPORT PLATE PER ATR72 SRM 51-25-01.SDR SWAA2022120669369Scuff Plate · crackedFWD CARGO DOOR CUT OUT SCUFF PLATE FWD CORNER WITH CRACK DAMAGED / [01] RECEIVED NEW SCUFFPLATE FOR REPLACE P/N 654A0004-337 PO#:1772343;[02] LOCATED; DRILLING AND COUTERSINK HOLES TO NEW SCUFFPLATE FOR REPLACE REF.737-700-SRM 51-40-02-0G-0;[03] FWD CARGO SCUFSDR SWAA2022120669370Scuff Plate · crackedFWD CARGO DOOR CUT OUT SCUFF PLATE AFT CORNER WITH CRACK DAMAGED / [01] RECEIVED NEW SCUFFPLATE FOR REPLACE P/N 143A8331-4 PO#:1728471;[02] VERIFIED 1;[03] LOCATED; DRILLING AND COUTERSINK TO NEW SCUFFPLATE FOR REPLACE REF.737-700-SRM 51-40-02-0G-0;[04] REF TASDR SWAA2022120169486Plate · corrodedCORRODED PLATE, BS 1016 - 1040, LBL 4. REPLACED THE PLATE IAW SRM 51-10-02, SRM 51-40-02, AND DRAWING 147A5600, SHEET 1, REV-.SDR SWAA2022120169493Strap · corrodedCORRODED STRAP, BS 1016 - 1040, RBL 4. REPLACED THE STRAP IAW SRM 51-10-02, 51-40-02, AND DRAWING 147A5700, SHEET 99, REV B.SDR SWAA2022120169481Structure · corrodedCORROSION INNER CHORD, BTW BS 947.5 TO BS 967 RBL 51 IN THE AFT GALLEY. REPLACED WITH A NEW INNER CHORD IAW SRM 51-10-02, SRM 51-40-02, AND DWG 147A0000, SHEET 45 REV A, DWG 147A8501, SHEET: 93, REV A.SDR SWAA2022120169482Web · corrodedCORROSION ON WEB LOCATED FLOOR STRUCTURE BTW BS 1016 TO 1040 BL 5 AT AFT GALLEY AREA. REPLACED THE WEB IAW SRM 51-10-02, PARAGRAPH 9, SRM 51-40-02, AND DRAWING 147A5700, SHEET 99, REV B.SDR AALA202211216659Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK FOUND ON CARGO BAFFLE LOCATED BETWEEN STA 500C AND 500D AND LEFT BUTT LINE 25. REMOVED AND REPLACED PER AARD 55-00-05-1.
Back to JASC 5320