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 DALA2021063003576Intercostal · corrodedSHIP 651 CORROSION ON ANGLE OF INTERCOSTAL BTW STA 1400 TO 1420 AND LBL 16 AT AFT CARGO COMPARTMENT. CORRECTIVE ACTION: SUMMARY OF NRC 00379 ANGLE OF INTERCOSTAL WAS REPLACED PER B757-200 SRM. (1855618)SDR DALA2021063003575Plate · corrodedSHIP 663 CORROSION ON RH SIDEPLATE BTW STA 1535-1559 AT AFT CARGO COMPARTMENT (IN REF NRC: 00459). CORRECTIVE ACTION: SUMMARY OF NRC 00912; RH SIDEPLATE WITH (IN REF NRC: 00459) BTW STA 1535-1559 AT AFT CARGO COMPARTMENT WAS REPAIRED PER B-757-200 SRM. (185552SDR DALA2021063003572Floor Support · corrodedSHIP 652 CORROSION ON FLOOR CHANNEL SUPPORT BTW STA 1660 TO 1680 AND LBL 54, ATAT PAX CABIN FLOOR STRUCTURE. CORRECTIVE ACTION: SUMMARY OF NRC 00645 FLOOR CHANNEL SUPPORT BTW STA 1660 TO 1680 AND LBL 54 WAS REPLACED PER B757-200 SRM. (1855395)SDR SWAA2021082787791Strip · corroded**CORROSION** AFT CARGO L/H FLOOR CAP STRIPS WITH CORROSION ; / [01] RECEIVED SERVICEABLE L/H AFT CARGO CAP STRIPS; INSTALLATION WILL BE ACCOMPLISHED ON TASK CARD TTG8Q004FEL2.; [02] VERIFIED STEP 1SDR SWAA2021082787792Strip · corroded**CORROSION** AFT CARGO R/H FLOOR CAP STRIPS WITH CORROSION ; / [01] RECEIVED SERVICEABLE R/H AFT CARGO CAP STRIPS; INSTALLATION WILL BE ACCOMPLISHED ON TASK CARD TTG8Q004FEL2.; [02] VERIFIED STEP 1SDR SWAA2021073088087Floor Support · crackedMAIN CABIN CENTER WING BOX FLOOR SUPPORT BREAK CRACKED AT STA 540 AND RBL 1 ; / [01] REMOVED DAMAGED FLOOR SUPPORT BREAK AT MAIN CABIN CTR. WING STA. 540 & RBL 1; REF. : B737-7 SRM 51-40-02-0G-0.; [02] OK TO INSTALL FLOOR SUPPORT; [03] INSTALLED NEW PANEL SUPPSDR AALA202107266636Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT GALLEY AREA SHEAR PLATE LOCATED BETWEEN FR69 TO FR70 AT S23R. REPLACED SHEAR PLATE PER SRM 51-72-11-911-001 AND DWG D53474180.SDR AALA202107262760Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT GALLEY AREA SHEAR PLATE LOCATED BETWEEN FR69 TO FR70 AT S23L. REPLACED SHEAR PLATE PER SRM 51-42-11-801 AND DWG D53474180.SDR SWAA2021071387749Angle · corrodedAFT CARGO R/H AFT TRANSITION ANGLE; JUST AFT OF DOOR; HAS LIGHT CORROSION AND A BROKEN NUTPLATE. ; / [01] REMOVED AND REPLACED TRANSITION ANGLE PER SRM 51-40-02; [02] TASK C/WSDR SWAA2021063088381Angle · damagedAFT CARGO BAY FWD SHIELD ATTACH ANGLE HAS DAMAGED FASTENER HOLE BS 767 - 787, RBL 21, WL 157. LOCATED DRILLED AND INSTALLED NUT PLATES ON NEW PART IAW SRM 51-40-02 SRM 51-40-05 SRM 51-40-08 AND DWG'S 146A8123 REV:- 146A0081 REV:-. INSTALLED AFT CARGO BAY FSDR DALA2021062703477Strap · crackedSHIP 651 DURING INITIAL INSPECTION MAINTENANCE FOUND CRACK ON STABILIZATION STRAP IN AFT CARGO COMPARTMENT (CILING AREA), STA. 1260, LBL 26 AND REPAIRED PER SRM. (LP 1854671)SDR DALA2021062703476Strap · crackedSHIP 651 DURING INITIAL INSPECTION MAINTENANCE FOUND CRACK ON STABILIZATION STRAP IN AFT CARGO COMPARTMENT (CILING AREA), STA. 1260, RBL 26. CRACK REPAIRED PER SRM. (LP 1854661)SDR DALA2021062703475Floor Support · corrodedSHIP 663 DURING INSPECTION MAINTENANCE FOUND CORROSION LEVEL 2 ON FLOOR STRINGERS LBL10.45 AND LBL 16.10 AT STA 640; LBL 10.45 BTW STA 700-720 ALSO LBL10.45 AND LBL 16.10 BTW STA 740-760 AT FORWARD CARGO COMPARTMENT. REPAIRED PER SRM. (LP 1854599)SDR DALA2021062703474Floor Support · corrodedSHIP 663 DURING INSPECTION MAINTENANCE FOUND CORROSION LEVEL 2 ON FLOOR STRINGER (UPPER/LOWER SURFACES) BTW STA 640 TO 660 RBL 7.55, 10.45 AND 16.10 AT FWD CARGO COMPARTMENT. STRINGERS REPLACED. (LP 1854511)SDR DALA2021062703473Floor Support · corrodedSHIP 663 DURING INSPECTION MAINTENANCE FOUND CORROSION LEVEL 2 ON STRINGERS RBL 2.90, RBL 7.55, RBL 16.10, LBL 2.90, LBL 7.55 AND LBL 10.45 FROM STA 1445 TO 1500 AT AFT CARGO COMPARTMENT. STIRINGERS REPLACED. (LP 1854438)SDR JR2R2021062678753Floor Support · corrodedR/H FLOOR SILL FR 88 TO FR 90 FOUND TO BE WITHIN LIMITS. REPLACED IAW E175 SRM 51-40-08.SDR JR2R2021062678762Floor Support · corrodedL/H FLOOR SILL FR 88 TO FR 90 CORRODED OUT OF LIMITS. REMOVED AND REPLACED IAW E175 SRM 51-40-08.SDR JR2R2021062678760Doubler · corrodedCENTER FLOOR DOUBLER BETWEEN FRAME 87 AND 88 CORRODED OUT OF LIMITS. REMOVED AND REPLACED IAW E175 SRM 51-40-08.SDR JR2R2021062678761Gusset · corrodedL/H FLOOR DOUBLER BETWEEN FR 87 AND 88 CORRODED OUT OF LIMITS. REMOVED AND REPLACED IAW E175 SRM 51-40-08.SDR JR2R2021062678758Gusset · corrodedFLOOR DOUBLER AT FR 89 RBL 11 CORRODED OUT OF LIMITS. REPLACED IAW E175 SRM 51-40-08.SDR JR2R2021062678759Gusset · corrodedFLOOR DOUBLER AT CENTER OF FRAME 90 CORRODED OUT OF LIMITS. REPLACED IAW E175 SRM 51-40-08.SDR JR2R2021062678755Gusset · corrodedFLOOR DOUBLER AT FRAME 90 CORRODED OUT OF LIMITS. REPLACED IAW E175 SRM 51-40-08.SDR JR2R2021062678768Doubler · corrodedFLOOR DOUBLER FWD OF R1 DOOR CORRODED OUT OF LIMITS. REPLACED IAW E175 SRM 51-40-08.SDR JR2R2021062678754Gusset · corrodedFLOOR DOUBLER AT FR 90 CORRODED OUT OF LIMITS. REMOVED AND REPLACED FLOOR DOUBLER IAW E175 SRM 51-40-08.SDR JR2R202106268756Shear Web · corrodedR/H FLOOR DOUBLER BETWEEN FR87 AND FR88 CORRODED OUT OF LIMITS. REMOVED AND REPLACED DOUBLER IAW E175 SRM 51-40-08.SDR SWIA2021090760762Angle · shearedANGLE CONNECTING INTERCOSTAL BETWEEN FS.449.85 & FS.461.00 TO PRESSURE FLOOR SUPORT BEAM AT LBL9.00 HAS ONE SHEARED RIVET HEAD. (C-CHECK RO 8/29/2021) REMOVED AND REPLACED 1EA SOLID RIVET IN THE INTERCOSTAL ATTACH ANGLE BETWEEN FS 449.85 AND FS 461 AT LSDR SWIA2021090760745Floor Support · corrodedLH PRESSURE FLOOR SILL FROM FS. 439.00 TO 559.00 HAS SEVERAL AREAS OF CORROSION MARKED WITH TAPE THAT REQUIRE EVALUATION. (C-CHECK RO 9/3/21) REMOVED CORROSION FROM LH PRESSURE FLOOR SILL FROM FS 439- FS 559 IAW REO 601R-53-41-666 REV C DATED 2012-11-06SDR SWIA2021090760743Floor Support · corrodedFLOOR BEAM FLANGES LBL9 , FS.574.00-FS.621.00 HAVE CORROSION IN MULTIPLE AREAS (C-CHECK RO 9/3/21) REMOVED AND REPLACED FLOOR BEAM CAP FROM FS 574- FS 621 IAW REO 601R-53-61-3780 REV A DATED 2011-07-15. COMPLETED TASK CARD 51-900-1003-SKY AND ATTACHED COMSDR SWIA2021090760742Floor Support · corrodedFLOOR BEAM FLANGES @ LBL 27, FS 574 TO FS 621 HAVE TOP SURFACE CORROSION (C-CHECK RO 9/3/21) REMOVED CORRODED FLOOR BEAM AT LBL 27 F.S. 574.00 - F.S. 621.00 AND INSTALLED NEW SERVICEABLE BEAM IAW CRJ-200 SRM 51-42-21 AND 51-40-11 REVISION 38B - 25 NOV 20SDR SWIA2021090760740Intercostal · corrodedPAX DOOR INTERCOSTAL DD5 BETWEEN FS 338 AND FS 347 IS CORRODED. (C-CHECK RO 9/3/21) REMOVED AND REPLACED PAX DOOR INTERCOSTAL DD5 AT FS 338 IAW CRJ 200 SRM 51-42-06, 51-42-21, AND 51-40-11. COMPLETED TASK CARD 51-900-1003-SKY AND ATTACHED COMPLETED FORM SDR SWIA2021090760739Intercostal · corrodedPAX DOOR INTERCOSTAL DD6 BETWEEN FS 338 AND FS 347 IS CORRODED (C-CHECK RO 9/3/21) REMOVED AND REPLACED PAX DOOR INTERCOSTAL DD6 BETWEEN FS 338 AND FS 347 IAW CRJ 200 SRM 51-42-06, 51-42-21, AND 51-40-11. COMPLETED TASK CARD 51-900-1003-SKY AND ATTACHED SDR SWIA202160738Intercostal · corrodedPAX DOOR INTERCOSTAL DD1A BETWEEN FS 338 AND FS 347 IS CORRODED. (C-CHECK RO 9/3/21) REMOVED AND REPLACED PAX DOOR INTERCOSTAL DD1A BETWEEN FS 338 AND FS 347 IAW CRJ 200 SRM 51-42-06, 51-42-21, AND 51-40-11. COMPLETED TASK CARD 51-900-1003-SKY AND ATTACHSDR SWIA2021090760737Intercostal · corrodedPAX DOOR INTERCOSTAL DD2 BETWEEN FS 320 AND FS 338 IS CORRODED. (C-CHECK RO 9/3/21) REMOVED PAX DOOR INTERCOSTAL DD2 BETWEEN F.S. 320.00 AND 338.00 IAW CRJ-200 SRM 51-42-06 AND 51-42-21 REVISION 38B - 25 NOV 2020 AND REPAIRED CORROSION ON INTERCOSTAL IAW SDR SWIA2021090760736Intercostal · corrodedPAX DOOR INTERCOSTAL DD3 BETWEEN FS 320 AND FS 338 IS CORRODED. (C-CHECK RO 9/3/21) REMOVED AND REPLACED PAX DOOR INTERCOSTAL DD3 BETWEEN FS 320 AND FS 338 IAW CRJ 200 SRM 51-42-06, 51-42-21, AND 51-40-11. COMPLETED TASK CARD 51-900-1003-SKY AND ATTACHEDSDR SWIA2021090760735Bracket · corrodedPAX DOOR BRACKET DD5 BETWEEN FS 311 AND FS 320 IS CORRODED. (C-CHECK RO 9/3/21) REMOVED AND REPLACED PAX DOOR BRACKET DD5 BETWEEN FS 311 AND FS 320 IAW CRJ 200 SRM 51-42-06, 51-42-21, AND 51-40-11. COMPLETED TASK CARD 51-900-1003-SKY AND ATTACHED COMPLETESDR SWIA202160734Intercostal · corrodedPAX DOOR INTERCOSTAL DD6 BETWEEN FS 320 AND FS 338 IS CORRODED. (C-CHECK RO 9/3/21) REMOVED AND REPLACED PAX DOOR INTERCOSTAL DD6 BETWEEN FS 320 AND FS 338 IAW CRJ 200 SRM 51-42-06, 51-42-21, AND 51-40-11. COMPLETED TASK CARD 51-900-1003-SKY AND ATTACHEDSDR SWIA2021081960387Angle · corroded*PAX DOOR MID CAP HAS AREAS OF CORROSION BETWEEN APPROX. FS 310.00 €“ 349.00. AREAS MARKED. (C-CHECK RO 8/18/2021) REMOVED PAX DOOR MID CAP ANGLE BETWEEN APPROX. FS 310.00 - 349.00 AND INSTALLED NEW MID CAP ANGLE IAW CRJ700 SRM 51-41-02-001-001-A01 ANDSDR SWIA2021081960386Intercostal · corroded*INTERCOASTAL CORRODED AT STRG 20R FROM FS310.00-FS319.00 (MARKED) (C-CHECK RO 8/18/2021) REMOVED AND INSTALLED NEW INTERCOSTAL AT STRG 20R FROM FS310.00-FS319.00 REF CRJ 700 SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01 & DWG NO: SH670-31950 REV YSDR SWIA2021081960385Intercostal · corroded*INTERCOASTAL CORRODED AT STRG 20R FROM FS349.00-FS364.00 (MARKED) (C-CHECK RO 8/18/2021) REMOVED, REPLACED AND INSTALLED NEW INTERAOSTAL BETWEEN FS 349.00 AND FS 364.00 STGR 20R REF CRJ 700 SRM 51-42-06-001-001-A01, CRJ 700 SRM 51-42-21-001-001-A01 ANDSDR SWAA2021080488338Floor Support · crackedCRACKED FLOOR SUPPORT UPPER ANGLE BS 380-400 LBL 1 WL 208. ; / [01] REMOVED FLOOR SUPPORT UPPER ANGLE BS380-400 LBL1; WL 208 PER SRM 51-40-02-0G-0; [02] LOCATED/DRILLED FLOOR SUPPORT UPPER ANGLE BS380-400 LBL1; WL 208 PER SRM 51-40-05-0G-0 AND DWG 143A5400. OKSDR SWAA2021080488339Floor Support · crackedCRACKED FLOOR SUPPORT UPPER ANGLE BS 380-400 LBL 13 WL 208. ; / [01] REMOVED FLOOR SUPPORT UPPER ANGLE BS380-400 LBL1; WL 208 PER SRM 51-40-02-0G-0; [02] LOCATED/DRILLED FLOOR SUPPORT UPPER ANGLE BS380-400 LBL13; WL 208 PER SRM 51-40-05-0G-0 AND DWG 143A5400. SDR SWAA2021080287862Support Angle · crackedCRACK SUPPORT ANGLE LOCATED BETWEEN BS 380 AND BS 400 BL 0 AT PASSENGER CABIN ; 2021-295488 / [01] REPLACED NEW SUPPORT ANGLE LOCATED BETWEEN BS 380 AND BS 400 BL 0 AT PASSENGER CABIN I.A.W B737-700 SRM 51-40-02-0G-0; 51-10-02-0G-0 ITEM 9 AND DWG 143A5400 REV SDR SWAA2021080287863Support Angle · crackedCRACK SUPPORT ANGLE LOCATED BETWEEN BS 380 AND BS 400 RBL 10 AT PASSENGER CABIN ; 2021-295483 / [01] REPLACED ANGLE AND FASTENERS LOC BETWEEN BS380 TO BS400 RBL10 AT PASSENGER CABIN IAW B737-700 SRM 51-40-02; SRM 51-10-02 ITEM 9 AND DRAWING 143A5400 REV A; [02SDR SWAA2021080287868Support Angle · crackedCRACK SUPPORT ANGLE LOCATED BETWEEN BS 380 AND BS 400 LBL 14 AT PASSENGER CABIN ; 2021-295489 / [01] TOOL USED: TEMPERATURE CONTROLLER P/N: P3015GOES00000; S/N: 112031023; DUE DATE: 22-JAN-22.; [02] REPLACED SUPPORT ANGLE AND FASTENERS LOCATED BETWEEN BS 380 ASDR SWAA2021080287859Web · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN BS 328 TO BS 344 AT LEVEL LBL 47 FWD GALLEY AND LAV ; 2021-295487 / [01] REPLACED WEB-INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN BS328 TO BS344 AT LEVEL LBL 47 FWD GALLEY AND LAV IAW DWG #141A5400; SHEETSDR SWAA2021080287867Web · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN BS 312 AND BS 328 RBBL 34 FWD GALLEY AND LAV ; 2021-295490 / [01] REPLACED WEB-INTERCOSTAL LOC. FLOOR STRUCTURE BETWEEN BS 312 AND BS 328 RBBL 34 FWD GALLEY; IAW B737-700 SRM 51-10-02 AND DWG # 141A5400 RSDR SWAA2021080287865Web · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN BS 294.5 TO BS 312 AT LEVEL BL0 FWD GALLEY AND LAV ; 2021-295484 / [01] REMOVED WEB-INTERCOSTAL LOCATED BETWEEN BS294.5 TO BS 312 AT LEVEL BL0 GALLEY AND LAV. IAW B737-700 SRM 51-40-02. PERFORMED VISUAL ISDR SWAA2021080287866Stiffener · crackedCRACK FLOOR STRUCTURE STIFFENER BS 540 BETWEEN LBL 24.5 AND BL 0 AT PASSENGER CABIN ; 2021-295460 / [01] REPLACED NEW STIFFENER AND FASTENERS LOC. FLOOR STRUCTURE BS 540 BETWEEN LBL 24.5 AND BL 0 AT PASSENGER CABIN I.A.W B737-700 SRM 51-10-02; ITEM 9 AND SRM 5SDR SWAA2021073088080Bracket · crackedFWD CARGO COMPT RIGHT HAND STA 500C STR 25 BRACKET UNDER ZEE ANGLE CRACKED ; / [01] REMOVED DAMAGED CLIP BRACKET P/N 143A7502-14;AT FWD. CARGO COMPT. R/H STA. 500C S-25R;UNDER 'Z' ANGLE. REF. :: B737-700 SRM 51-40-02-0G-0.; [02] VERIFIED STEP 1; [03] INSTALLEDSDR SWAA2021073088081Bracket · crackedFWD CARGO COMPT LEFT HAND STA 500D STR18 BRACKET CRACKED ; / [01] REMOVED CRACKED GUSSET BRACKET AT FWD. CARGO COMPT. L/H STA. 500D; S-18R; REF : B737-700 SRM 51-40-02-0G-0.; [02] RECEIVED NEW GUSSET BRACKET P/N : 143A9481-6; ISSUE TAG E26842; PO # 1698442.; [
Back to JASC 5320