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 SWIA2020062651224Gusset · corrodedSTR 23L FS 1000 CORNER GUSSET CORRODED. (C-CHECK) RO 6/24/2020 CORNER GUSSET/ CLIP AT STR 23L FS 1000 IS CORRODED OUT OF LIMITS AND REPLACED WITH NEW GUSSET CLIP PN MM670-36482-003 REF SRM AND DWG. COMPLIED WITH TASK CARD.SDR SWIA2020062651223Gusset · corrodedSTR 24L FS 1000 CORNER GUSSET CORRODED. (C-CHECK) RO 6/24/2020 CORNER GUSSET/ CLIP AT STR 24L FS 1000 IS CORRODED OUT OF LIMITS AND REPLACED WITH NEW GUSSET CLIP PN MM670-36482-003 REF SRM AND DWG. COMPLIED WITH TASK CARD.SDR SWIA2020062651222Gusset · corrodedSTR 25L FS 1000 CORNER GUSSET CORRODED, CHECK AREAS IMMEDIATELY ADJACENT. (C-CHECK) RO 6/24/2020 CORNER GUSSET/ CLIP AT STR 25L FS 1000 IS CORRODED OUT OF LIMITS AND REPLACED WITH NEW GUSSET CLIP PN MM670-36482-003 REF SRM AND DWG. COMPLIED WITH TASK CARD.SDR SWIA2020062651221Gusset · corrodedSTR 26L FS 989 CORNER GUSSET CORRODED. (C-CHECK) RO 6/24/2020 CORNER GUSSET/ CLIP AT STR 26L FS 989 IS CORRODED OUT OF LIMITS AND REPLACED WITH NEW GUSSET CLIP PN MM670-36482-004 REF SRM AND DWG. COMPLIED WITH TASK CARD.SDR SWIA2020062651220Gusset · corrodedSTR 19R FS 1051 CORNER GUSSET CORRODED. (C-CHECK) RO 6/24/2020 REMOVED AND REPLACED CLIP CORROSION BEYOND 30% OUT OF LIMITS PER SRM AT STR 19R FS1051.30. INSTALLED NEW CLIP PN SH670-36482-16 AND HARDWARE WET WITH SEALANT. REF REO AND ENG DWG. COMPLIED WITSDR SWIA2020062651219Gusset · corrodedSTR 26R FS 1031 CORNER GUSSET CORRODED. (C-CHECK) RO 6/24/2020 CORNER GUSSET/ CLIP AT STR 26R FS 1031 IS CORRODED OUT OF LIMITS AND REPLACED WITH NEW GUSSET CLIP PN. MM670-36482-008 REF SRM AND DWG. COMPLIED WITH TASK CARD.SDR SWIA2020062651214Door Sill · corrodedTHE RT PRESSURE FLOOR SILL HAS CORROSION AT FS797.00. (C-CHECK) RO 6/24/2020 REPAIRED DAMAGED AREA REF REO AND COMPLIED WITH ALL STEPS. COMPLIED WITH TASK CARD AND FORM M-337.SDR SWIA2020062651211Structure · crackedTHE PRESSURE FLOOR IS CRACKED BETWEEN BL0 AND RBL9.00 BETWEEN FS736.00 AND FS752.50. (C-CHECK) RO 6/24/2020 REPAIRED PRESSURE FLOOR CRACK BETWEEN BL 0 AND RBL 9.00 BETWEEN FS 736.00 AND FS 752.50 AS PER REO. COMPLIED WITH TASK CARD.SDR SWIA2020062651210Plate · corrodedTHE FWD CARGO PLATE BETWEEN FS581.00 AND FS597.00 AND STRINGER 23L AND 22L HAS CORROSION. (C-CHECK) RO 6/24/2020 REMOVED CORROSION ON FWD CARGO PLATE BETWEEN FS581.00 AND FS597.00 BETWEEN STR 23L AND STR 22L REF REO. COMPLIED WITH ALL STEPS.SDR SWAA2020061881138Floor Support · crackedCRACK WEB-INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN BS 344 AND BS 360 BLO FWD GALLEY AND LAV / REPLACED WEB INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN BS 344 AND BS 360 BLO FWD GALLEY AND LAV IAW B737-700 SRM 51-40-02 AND DWG 141A5400-27SDR SWAA2020061889852Floor Support · crackedCRACK WEB INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN BS 312 TO BS 328 AND LBL 46 FWD GALLEY AND LAV / REPLACED WEB INTERCOSTAL FLOOR STRUCTURE LOC BTW BS 312 TO BS 328 AND LBL 46 FWD GALLEY AND LAV I.A.W B737-700 SRM 51-10-02 ITEM 9SDR SWAA2020061889853Floor Support · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN BS 312 AND BS 328 RBL 31 FWD GALLEY AND LAV / REPLACED INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN BS 312 AND BS 328 RBL 31 FWD GALLEY IAW B737-700 SRM 51-10-02 ITEM 9 AND SRM 51-40-02 DRAWING #141A5400 RSDR IPXA2020061556531Stiffener · crackedINSPECTION TYPE:3C 3RD VERTICAL STIFFENER FROM FRONT IN RT MLG WW O/B AFT CUTOUT IS CRACKED. REPLACED CRACKED STIFFENER 3RD FROM FRONT IN RT MLG WW O/B AFT CUTOUT IAW SRM 51-35-01. (MINOR)SDR IPXA2020061256451Support Frame · brokenINSPECTION TYPE:A300 E AND E BAY FLOOR LT SIDE BELOW PANEL 121TF 1 CLAMP SUPPORT FRAME BROKEN. REMOVED OLD SUPPORT AND INSTALLED NEW SUPPORT FRAME PN A9242628900001 IAW SRM 51-40-21.SDR SWIA2020061251091Support Angle · corrodedSEVERE CORROSION FOUND ON FS280 FLOOR SUPPORT ANGLE. (C-CHECK) RO 6/8/2020 BLENDED AND EVALUATED FS280 FLOOR SUPPORT ANGLE. FOUND TO BE OUT OF LIMITS. REMOVED AND WET INSTALLED "NEW" FLOOR SUPPORT ANGLE LOCATED AT FS280 AS REQ'D REF DRWG, SRM COMPLIED WITH.SDR SWIA2020060951013Floor Support · crackedCABIN FLOOR SUPPORT ANGLE FWD OF FS 333 IS CRACKED (P/N=SH670-33332-5). (C-CHECK) RO 4/23/2020 REMOVED AND REPLACED CRACKED CABIN FLOOR SUPPORT ANGLE FWD OF FS333 WITH A NEW CABIN FLOOR SUPPORT ANGLE. REF SRM.SDR SWAA2020060879394Stiffener · crackedAFT CARGO BAY, WATER SERVICE PAN AFT STIFFENER IS CRACKED. REMOVED AND REPLACED ACB WATER SERVICE PAN AFT STIFFENER IAW SRM 51-40-02 AND AIPC 52-49-00-02.SDR SWAA2020060879393Angle · corrodedAFT CARGO BAY, ANGLE UNDER SHIELD HAS CORROSION AROUND NUTPLATES BS767 TO BS787 RBL21 WL157. CORROSION ON ANGLE UNDER SHIELD BS767-787 RBL21 WL157, FOUND TO BE OUT OF LIMITS DUE TO NO SRM LIMITS. REMOVED AND REPLACED ANGLE PER SRM 51-40-02-0G-0; SRM 51-40-05-SDR SWAA2020060879389Web · corrodedFWD CARGO BAY SUBTHRESHOLD WEB HAS AREAS OF CORROSION AROUND PLATE HOLES BS460 TO BS480 RBL23 WL156. CORROSION ON SUBTHRESHOLD WEB BS 460 - 480 RBL23 WL156 FOUND TO BE OUT OF LIMITS PER SRM 53-30-15-1A-1. REMOVED AND REPLACED SUBTHRESHOLD BS 440 - 492 RBL23 WSDR SWAA2020060879390Support · corrodedFWD CARGO BAY LT FLOOR TO SIDEWALL SUPPORT PLATE HAS CORROSION AROUND NUTPLATE HOLES BS500 TO BS500D LBL23 WL156. REPLACED CORROSION DAMAGED LT FLOOR TO SIDEWALL SUPPORT BS480-500D LBL23 WL156 IAW SRM 53-00-53-2R-5 AND DWG 143A7500.SDR SWAA2020060579067Angle · corrodedFORWARD CARGO PIT LEFT HAND Z-ANGLE HAS CORROSION BS 500D TO 500I LBL 24 WL 146. REMOVED CORROSION AT FWD CARGO PIT LEFT HAND Z-ANGLE STA 500D TO 500I LBL 24 IAW SRM 51-10-02-0G-0 ITEM 15. ORIGINAL 'T' .040 REMAINING .034 LOSS .006 AT BETWEEN STA 500G TO 500FSDR SWAA2020060579063Angle · corrodedFORWARD CARGO PIT; RIGHT HAND Z-ANGLE HAS CORROSION; BS 500A TO 500I RBL 24 WL 146. REMOVED CORROSION AT FWD CARGO PIT RT Z-ANGLE AT STA 500A TO 500I RBL 24. IAW SRM 51-10-02-0G-0 ITEM 15. ORIGINAL 'T' .040 REMAINING .033 LOSS .007 AT BETWEEN STA 500C TO 500SDR SWAA2020060379314Attach Angle · crackedCUSTOMER REQUEST LT STA 663 UPPER ATTACH ANGLE LBL 8 IS CRACKED. REPAIRED LT STA 663 UPPER ATTACH ANGLE LBL 8 IAW SRM 57-10-10-2R-5.SDR SWAA2020060379313Attach Angle · crackedCUSTOMER REQUEST RT STA 663 UPPER ATTACH ANGLE RBL 8 IS CRACKED. REPAIRED DAMAGED RT 663 UPPER ATTACH ANGLE RBL 8 IAW SRM 57-10-10-2R-5.SDR SWAA2020060379310Channel · corrodedCORROSION RT Z-CHANNEL IN AFT CARGO BAY HAS MULTIPLE AREAS OF CORROSION FROM STA 727-767, RBL21 AND WL 158. CORROSION ON RT Z-CHANNEL IN AFT CARGO BAY FROM STA 727 - 767, RBL 21 AND WL 158 FOUND TO BE OUT OF LIMITS IAW SRM 53-00-53-1A-2 FIG 103 DETAIL D. FABSDR SWAA2020060379309Channel · corrodedCORROSION LT Z-CHANNEL IN AFT CARGO BAY HAS MULTIPLE AREAS OF CORROSION FROM STA 727-847, LBL 21 AND WL 158. REMOVED LT Z-CHANNEL IN AFT CARGO AND INSTALLED NEW Z-CHANNEL O/N 146A1502-31 PO 786416 IAW SRM 51-40-02 AND B DWG 146A7500.SDR SIMA2020060219002Bracket · crackedFORWARD CARGO DOOR TORSION BAR BRACKET AT FRAME 61 HAS A 1/8" CRACK. INSTALLED NEW BRACKET IAW SRM 51-40-02.SDR SIMA202005219001Support · crackedSUPPORT ON THE AFT SIDE OF FRAME 68 FOR CARGO DOOR HOLD OPEN STRUT HAS A 3/4" CRACK.-C/A-REMOVED AND INSTALLED NEW SUPPORT IAW SRM 51-40-02.SDR IPXA2020052055527Angle · corrodedINSPECTION TYPE:SEG3ANGLE SUPPORT FWD RAT CUTOUT BEAM HAS CORROSION ON THE IB SIDE STA 1180REPLACED ANGLE IAW DWG 149N7734SDR IPXA2020052055516Angle · scratchedINSPECTION TYPE:SEGMCD FLOOR FR80 L/H SIDE ANGLE HAS A SCRATCH AT RADIUSREMOVED AND INSTALLED NEW ANGLESDR DU4R2020051900032Baffle · crackedLH BAFFLE BETWEEN 400D AND 500E CRACKED AT STRINGER 26LSDR DU4R2020051900031Support Web · crackedLH TRANSITION PANEL SUPPORT WEB AT STR 26L BETWEEN BS 400-420 CRACKEDSDR DU4R2020051900030Baffle · crackedBAFFLE CRACKED BETWEEN FR STATION 500E AND 500F AT STRINGER 26L FWD CARGO PITSDR DU4R2020051900027Channel · corrodedFORWARD LOWER CARGO COMPARTMENT L/H SIDE STR 26L FLOOR SUPPORT SIDE PLATE HAS CORROSION BETWEEN B.S 500B-500CSDR DU4R2020051900026Baffle · crackedCRACKED BAFFLE IN FWD PIT COMP BETWEEN BS 460-480 STR 26LSDR DU4R2020051900025Intercostal · crackedFUSELAGE FWD OF R1 DOOR AT STR 14R ADJACENT TO FRAME BS 277 HAS CRACK IN ITS FWD RADIUS TRIM OUT. REPAIR IN CONJUNCTION WITH SB 737-53A1241.SDR 2A6R2020051956401Structure · corrodedHEAVY CORROSION FOUND ALONG RIGHT HAND FUSELAGE CABIN FLOOR EDGING FRAMESDR DU4R2020051900018Support Plate · corrodedFORWARD LOWER CARGO COMPARTMENT RT SIDE STR26R FLOOR SIDE PLATE HAS CORROSION APPROX 6" FWD BS 500D.SDR SWAA2021081578855Shield · corrodedAFT CARGO PIT FLOOR; RH SIDE SHIELD HAS CORROSION; BS:767 TO 787; RBL: 22; WL: 156. / REMOVED .026' MATERIAL FROM ORIGINAL .050' THICKNESS AFT CARGO FLOOR SIDE SHEILD STA 767-787 RBL 22 WL156. REMAINIG .024' IS OUT OF LIMITS IAW SRM 53-60-15-1A-1. REMOVED EXISSDR SWAA2021081389846Support · damagedELONGATED HOLE SUPPORT ZEE BETWEEN BS 727D TO BS 727E AND STR 25R AFT CARGO COMPARTMENT (1 EA) / REPLACED SUPPORT ZEE BTW BS 727D TO BS 727E AND STR 25 AFT CARGO COMPARTMENT ALL STEPS HAS BEEN DOCUMENTED ON L170586SDR SWAA2021072189848Support · crackedCRACK INNER CHORD FLOOR STRUCTURE LOCATED ON BS303 AT LEVEL STR17L AT PASSENGER CABIN / REPLACED INNER CHORD AND FASTENERS LOC BS 277 TO BS 360 AT LEVEL STRINGER 17L AT PASSENGER CABIN IAW SRM B737-700 51-10-02 ITEM 9 AND DRAWING #141A8110 REV.ESDR SWAA2021052678971Gusset · crackedFWD CARGO BAY R/H GUSSET IS CRACKED AT BS500D AT STR 19R / REMOVED AND REPLACED GUSSET IN FCB @ BS 500D STR 19R IAW SRM 51-40-05; SRM 51-40-02 AND DWG 143A7902.SDR SWAA2021052678970Gusset · crackedFWD CARGO BAY L/H GUSSET IS CRACKED AT BS500D AT STR 19L / REMOVED AND REPLACED FWD CARGO BAY L/H GUSSET @ BS500D STR 19L IAW SRM 51-40-05; SRM 51-40-02; AND DWG 143A7902SDR SWIA2020062651207Door Sill · corrodedPAX DOOR SURROUND BACK-UP SILL AT STR 21L, BETWEEN FS310 AND FS319 HAS CORROSION. (C-CHECK) RO 6/24/2020 REPLACED PAX DOOR BACK-UP SILL PER SRM, DRAWING SH670-31810 REV Y, DRAWING. SEE CONTINUATION CARD FOR DETAILS. COMPLIED WITH TASK CARD AND FORM M-337.SDR SWIA2020062651206Door Sill · corrodedPAX DOOR SURROUND BACK-UP SILL AT STR 21L, BETWEEN FS333 AND FS349 HAS CORROSION. (C-CHECK) RO 6/24/2020 REPLACED PAX DOOR SURROUND BACK-UP SILL PER SRM, DRAWING. SEE CONTINUATION CARD FOR DETAILS. COMPLIED WITH TASK CARD.SDR SWIA2020062651205Intercostal · corrodedAVIONICS BAY DOOR SURROUND INTERCOSTAL STR 26R, BETWEEN FS349 AND FS364 HAS CORROSION. (C-CHECK) RO 6/24/2020 REMOVED CORROSION FROM STR 26R, FS349 - FS364 AND FOUND REWORKED AREA TO BE OUT OF LIMITS. REPLACED INTERCOSTAL REF SRM AND DWG. COMPLIED WITH TASK SDR SWIA2020062651204Intercostal · corrodedAVIONICS BAY DOOR SURROUND INTERCOSTAL STR 26L, BETWEEN FS349 AND FS364 HAS CORROSION. (C-CHECK) RO 6/24/2020 REMOVED CORROSION AND FOUND REWORKED AREA TO BE OUT OF LIMITS. REPLACED INTERCOSTAL AT STR 26L, FS349 - FS364 REF SRM, DWG. COMPLIED WITH TASK CARD.SDR SWIA2020062651203Intercostal · corrodedAVIONICS BAY DOOR SURROUND INTERCOSTAL TO THE LEFT SIDE OF STR 27 BETWEEN FS349 AND FS364 HAS CORROSION. (C-CHECK) RO 6/24/2020 REPLACED LT INTERCOSTAL AT LT AVIONICS BAY DOOR CUTOUT PER SRM & DRAWING. SEE CONTINUATION CARD FOR DETAILS. COMPLIED WITH TASK CSDR SWIA2020062651196Fitting · corrodedCLIP FOR INTERCOSTAL STR 20R, APPROX FS333, HAS CORROSION. (C-CHECK) RO 6/24/2020 CLIP FOR INTERCOSTAL STR 20R, APPROX FS333 OUT OF LIMITS OF SRM, REPLACED WITH NEW CLIP P/N SH670-32014-2 IAW DWG, & SRM C/W TASK CARD.SDR SWIA2020062651195Fitting · corrodedCLIP FOR INTERCOSTAL STR 20R, APPROX FS319, HAS CORROSION. (C-CHECK) RO 6/24/2020 CLIP FOR INTERCOSTAL STR 20R, APPROX FS319 P/N SH670-32046-3 IS OUT OF LIMITS OF SRM, REPLACED IAW SRM & DWG C/W TASK CARD.
Back to JASC 5320