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 SWAA2023082888996Access Panel · crackedAFT CENTER WHEEL WELL ACCESS PANEL # 193D HAS BULGING/CRACKED FASTENER HOLES<[01] APPLIED A PERMANENT REPAIR ON DAMAGED FASTENER HOLES AS MARKED ON PANEL #193D AS PER B737 SRM 51-70-04-2R-9 PARA 4.L-M-N ; MATERIAL USED PO#2011230; PO#1775890 AND PO#1690463;[02SDR SWAA2023082483246Shield · corrodedAFT CARGO R/H FWD SHIELD FROM ST 767 TO 787 ; RBL 20 AROUND THE 4 FASTENER HOLE HAVE COROCION. (228-008) AFT CARGO R/H FWD SHIELD FROM ST 767 TO 787 RBL 21 AROUND THE 4 FASTENER HOLE HAVE CORROSION. (228-008) [TTG8Q00MGCG3]<[01] REMOVED CORROSION AT R/H FWD SHSDR SWAA2023082483245Channel · corrodedAFT CARGO R/H Z CHANNE AT ST 747 + 18.5' ; RBL 20 HAS CORROCION ATROUND THE HOLE FASTENER (228-007) AFT CARGO R/H CHANNE AT ST 747 + 18.5' RBL 21 HAS CORROCION ATROUND THE HOLE FASTENER (228-007) [TTG8Q00MGCEU]<[01] AFT CARGO R/H Z CHANNE AT ST 747 + 18.5' ; RSDR SWAA2023082483243Channel · corrodedAFT CARGO R/H Z CHANNE AT ST 747 + 10' ; RBL 21 HAS CORROCION ATROUND THE HOLE FASTENER (228-005)<[01] AFT CARGO R/H Z CHANNE AT ST 747 + 10' ; RBL 21; TO BE REPLACED ON CUSTOMER BAR CODE TTG8Q00MGCKT.;[02] VERIFIED STEP # 1.SDR SWAA2023082483242Channel · corrodedAFT CARGO R/H Z CHANNE AT ST 747 + 6' ; RBL 21 HAS CORROCION ATROUND THE HOLE FASTENER (228-004)<[01] AFT CARGO R/H Z CHANNE AT ST 747 + 6' ; RBL 21 ; TO BE REPLACED ON CUSTOMER BAR CODE TTG8Q00MGCKT;[02] VERIFIED STEP # 1.SDR SWAA2023082483244Channel · corrodedAFT CARGO R/H Z CHANNE AT ST 747 + 15' ; RBL 20 HAS CORROCION ATROUND THE HOLE FASTENER (228-006) AFT CARGO R/H CHANNE AT ST 747 + 15' RBL 21 HAS CORROCION ATROUND THE HOLE FASTENER (228-006) [TTG8Q00MGCED]<[01] AFT CARGO R/H Z CHANNE AT ST 747 + 15' ; RBL 21;SDR SWAA2023082483241Channel · corrodedAFT CARGO R/H Z CHANNE AT ST 727E + 8.5' ; RBL 20 HAS CORROCION ATROUND THE HOLE FASTENER (228-003) AFT CARGO R/H CHANNEL AT ST 727E + 8.5' RBL 21 HAS CORROSION AT ROUND THE HOLE FASTENER (228-003) [TTG8Q00MGCCH]<[01] AFT CARGO R/H Z CHANNE AT ST 727E + 8.5' ;SDR SWAA2023082483247Channel · corrodedAFT CARGO R/H Z CHANNE AT ST 727D + 8' ; RBL 20 HAS CORROCION ATROUND THE HOLE FASTENER (228-002) AFT CARGO R/H Z CHANNEL AT ST 727D + 8' RBL 21 HAS CORROSION AT ROUND THE HOLE FASTENER (228-00<[01] INSTALLED NEW FABRICATED Z CHANNEL R/H AFT CARGO; FROM STA. 7SDR SWAA2023082483240Channel · corrodedAFT CARGO R/H Z CHANNE AT ST 727D + 3' ; RBL 20 HAS CORROCION ATROUND THE HOLE FASTENER (228-001) AFT CARGO R/H CHANNE AT ST 727D + 3' RBL 21 HAS CORROSION AT ROUND THE HOLE FASTENER (228-001) [TTG8Q00MGCBY]<[01] FT CARGO R/H Z CHANNE AT ST 727D + 3' ; RBL 21;SDR SWIA20230728Unknown · corrodedPAX FLOOR STRUCTURE, RH FLOOR SILL / PANEL SUPPORT CORRODED AT FR87-89. (C-CHECK RO 8/14/2023) REMOVED AND REPLACED PANEL SUPPORT AT FR87-89RH . RESTORED ORIGINAL FINISH AND APPLIED SURFACE PROTECTION. REF EMB SRM 51-40-08, 51-23-00, CPM 51-25-00SDR SWIA20230816728Unknown · corrodedPAX FLOOR STRUCTURE, CENTER RH BEAM HAS CORRODED HARDWARE BETWEEN FR 84-88 AS MARKED. (C-CHECK RO 8/14/2023) REMOVED AND REPLACED CENTER RH BEAM AT FR84-88 . RESTORED ORIGINAL FINISH/ SURFACE PROTECTION AS REQUIRED. REF EMB SRM 51-40-08, 51-23-00, CPM 5SDR AALA202308169827Transition Panel · corrodedAIRCRAFT N BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL LOWER ATTACH FITTING LOCATED FROM BS 767 TO BS 787, RBL 24. REPLACED TRANSITION PANEL PER SRM 51-10-02-0G.SDR ASAA2023072844588Transition Panel · corrodedFORWARD CARGO COMPARTMENT, R/H TRANSITION PANEL CORRODED THROUGHOUT. GROUNDED - YES. REPLACED FORWARD CARGO COMPARTMENT, RIGHT HAND TRANSITION PANEL IAW BAC DWG 143A7500 AND B737-900ER SRM 53-00-53-2R-5,.SDR AALA202308104001Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM BS 767 TO BS 787 AT S25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202308102704Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM BS 727 TO BS 767 AT S25R. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202308073616Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED AT BS 500A AT RBL 26. REPLACED TRANSITION PANEL PER SRM 51-40-02.SDR AALA202308075639Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT DOOR SHIELD LOCATED AT BS 495 AT S26R. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202308071346Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT DOOR SHIELD LOCATED AT BS 787 AT S24R. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202308079965Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 727 TO BS 767 AT LBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-1SDR AALA202308079300Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED BETWEEN BS 500I AND BS 500C AT LBL 25. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R PROCEDURE 5.SDR AALA202308073561Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 727 TO BS 767 AT S26R. REPLACED TRANSITION PANEL PER SRM 53-00-53-1A.SDR DALA2023080106213Transition Panel · corroded(LOG 2889757) AFT CARGO FLOOR SUPPORT TRANSITION PANEL @ STA 727- STA 747 S-25L HAS CORROSION AROUND THE FASTENER HOLES SEVERAL AREAS. FABRICATED AND INSTALLED NEW TRANSITION PANEL IAW B737 SRM 53-60-53-0I AND B737 SRM 51-40-02-0G AT AFT CARGO COMPT FLOOR BETWSDR SWAA2023090583268Support Angle · crackedCRACK SUPPORT ANGLE LOCATED BS695 AT RBL24.75 CENTER SECTION 2023-469924<[01] TOOL USED: TEMPERATURE CONTROLLER: P/N: P3015GOES00000; S/N: 112820025; DUE DATE: 01-FEB-24.;[02] REPLACED SUPPORT ANGLE LOCATED BS695 AT RBL24.75 CENTER SECTION IAW B737-700 SRM 51-SDR SWAA2023090583269Support Angle · crackedCRACK SUPPORT ANGLE LOCATED BS695 AT RBL1 AFT POSITION CENTER SECTION 2023-469923<[01] REPLACED SUPPORT ANGLE LOCATED BS695 AT RBL1 AFT POSITION CENTER SECTIO IAW B737-700 51-40-02; SRM 51-10-02 ITEM 9 AND DWG 273A9110 SHEET 6 REV A.<BR>SEE INDIVIDUAL SIGNOFF SDR SWAA2023090583270Support Angle · crackedCRACK SUPPORT ANGLE LOCATED BS695 AT RBL1 FWD POSITION CENTER SECTION 2023-469922<[01] TOOLS USED: TEMPERATURE CONTROLLER: P/N: P3015GOES00000; S/N: 142811020; DUE DATE: 25-JAN-24; TEMPERATURE CONTROLLER: P/N: P3015GOES00000; S/N: 112820025; DUE DATE: 01-FEB-2SDR SWAA2023090583271Stiffener · crackedCRACK STIFFENER ASSY LOCATED BS540 AND BETWEEN LBL24.75 TO LBL45.5 AT PASSENGER CABIN 2023-469921<[01] REPLACED STIFFENER ASSY LOCATED BS540 AND BETWEEN LBL24.75 TO LBL45.5 AT PASSENGER CABIN IAW B737-700 SRM 51-10-02 Ï¿½TEM 9 AND DRAWING 143A0060 SHEET 36 REVSDR SWAA2023082482970Angle · crackedCRACK ANGLE FLOOR STRUCTURE LOCATED STA294.5 AND RBL55; WL208.1 AT FWD GALLEY AREA 2023-461458<[01] REPLACED ANGLE AND FASTENERS FLOOR STRUCTURE LOCATED STA294.5 AND RBL55; WL208.1 AT FWD GALLEY AREA IAW B737-700 SRM 51-40-02-0G; SRM 51-10-02-0G Ï¿½TEM 9 AND DSDR SWAA2023082482978Angle · crackedCRACK ANGLE FLOOR STRUCTURE LOCATED BETWEEN STA927 TO STA947.5 AND BL 0; WL208.1 AT AFT GALLEY AREA 2023-461467<[01] TOOLS USED: TEMPERATURE CONTROLLER: P/N: P3015GOES00000; S/N: 142811020; DUE DATE: 25-JAN-24; TEMPERATURE CONTROLLER: P/N: P3015GOES00000; S/N:SDR SWAA2023082482963Intercostal · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN STA 312 TO STA 328 AND RBL 31; WL208.1 FWD GALLEY AND LAV 2023-461451<[01] REPLACED WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN STA 312 TO STA 328 AND RBL 31; WL208.1 FWD GALLEY AND LAV IAW B737-700SDR SWAA2023082482966Intercostal · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN STA344 TO STA360 AND BL0; WL208.1 FWD GALLEY AND LAV 2023-461446<[01] REPLACED WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN STA344 TO STA360 AND BL0; WL208.1 FWD GALLEY AREA IAW SRM B737-700 51-40-02SDR SWAA2023082382987Channel · corrodedAFT CARGO COMPARTMENT LH 'Z' CHANNEL STA 727B TO STA 787 HAS SEVERAL SPOTS OF CORROSION.<[01] REMOVED AND REPLACED AFT CARGO COMPARTMENT L/H ZEE CHANNEL FROM STA 727 TO STA 847 LBL 21 DUE TO CORROSION OUT OF LIMITS; REF B737 SRM 53-00-53-2R-6 AND DWG# 146A7500SDR SWAA2023082382985Channel · corrodedAFT CARGO COMPARTMENT RH 'Z' CHANNEL STA 727D TO STA 767 HAS SEVERAL SPOTS OF CORROSION<[01] REMOVED; FABRICATED AND INSTALLED NEW AFT CARGO R/H ZEE CHANNEL; REF B737 SRM 51-40-02-0G-0 AND DWG# 146A7500.;[02] VERIFIED AFT CARGO R/H ZEE CHANNEL REPLACEMENT.SDR SWAA2023082382982Intercostal · corrodedCABIN FLOOR INTERCOSTAL UPPER SURFACE HAS CORROSION PIT BS 294.1+11 LBL 11. 8-57<[01] REMOVED CORROSION AT CABIN INTERCOSTAL UPPER SURFACE;FWD WET AREA.BS 294.1 +11;LBL 11 PER B 737-700 SRM 51-10-02-0G-0;[02] REMOVED CORROSION AT MAIN CABIN FWD WET AREA INTERCSDR SWAA2023081783180Shield · corrodedA 221 DOT 13; AFT CARGO COMPARTMENT BETWEEN STA 847 AND 867 AFT FLOOR SHIELD IS CORRODED 4EA AREAS TOP SKIN AS MARKED<[01] AUDIT CWSDR SWAA2023081683182Angle · corrodedA 221 DOT 17; AFT CARGO COMPARTMENT BETWEEN STA 767 AND 787 +6' L ANGLE THAT TIES INTERCOSTAL TO FWD FLOOR SHIELD IS CORRODED IN SEVERAL AREAS AS MARKED<[01] VERIFIED PART USING ATAG WN33472 P/N 146A8125-53 AND DWG 146A0081 REV:A STARTED LOCATING AND DRILLING SDR SWAA2023081683181Shield · corrodedA 221 DOT 16; AFT CARGO COMPARTMENT BETWEEN STA 767 AND 787 +6' FWD FLOOR SHIELD HAS SEVERAL AREAS OF CORROSION TOP AND BOTTOM SKIN AS MARKED<[01] C/W<BR>AUDIT C/W;[02] UPDATED PARTS INFO;[03] C/W<BR>AUDIT C/WSDR SWAA2023081683184Angle · corrodedA 221 DOT 20; AFT CARGO COMPARTMENT BETWEEN STA 787 AND 727F TOP AND BOTTOM SKIN OF THE L/H/S ZEE ANGLE IS CORRODED IN SEVERAL AREAS AS MARKED<[01] REMOVED CORROSION VISUALLY INSPECTED CORRODED ARE WITH 10X MAGNIFIER<BR>NO DEFECTS NOTED I.A.W SRM 53-00-53-1A-2SDR ASAA2023072744529Transition Panel · corrodedAFT CARGO L/H TRANSITION PANEL FROM 727C TO STA 787 HAS CORROSION(CIRCLED IN RED) GROUNDED - YES. REMOVED CORROSION FROM L/H TRANSITION PANEL STA 727 TO STA 847. FOUND TO BE OUT OF LIMITS WITH 100% MATERIAL LOSS, REMOVED TRANSITION PANEL STA 727-847, MATERIALSDR ASAA2023072744528Transition Panel · corrodedAFT CARGO R/H TRANSITION PANEL FROM STA 727C TO STA 767 HAS CORROSION. GROUNDED - YES. REMOVED CORROSION FROM R/H TRANSITION PANEL STA 727-767.FOUND TO BE OUT OF LIMITS WITH 100% MATERIAL LOSS.REMOVED TRANSITION PANEL STA 727-767, MATERIAL ID BAC 1496-377 7075SDR AALA202308091619Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL LOCATED FROM BS 312 TO BS 328 AT RBL 30. REPLACED INTERCOSTAL PER AARD 51-00-05-1 AND SRM 51-10-02.SDR AALA202308097197Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL LOCATED FROM BS 277 TO BS 294 AT BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR DALA2023073106171Web · corroded(LOG 2887289) FORWARD CARGO COMPARTMENT CARGO DOOR CUTOUT LOWER SILL HAS AREAS OF CORROSION ON UPPER SURFACE BETWEEN BS 440 AND BS 500. REMOVED AND REPLACED FWD CARGO DOOR LOWER SILL WEB IAW B737 SRM 51-40-05 AND B737 SRM 51-40-02-0G.SDR SWAA2023072882830Floor Support · crackedFLOOR BOARD SUPPORT R/H PANEL BRAKE ASSY. CRACKED - LOCATED AT STA 540 (P/N 143A5240-36) (ZONE 126)<[01] REMOVED AND REPLACED R/H PANEL BRAKE ASSY AT STA.540 PER SRM 51-40-02.SDR DALA2023072806111Unknown · unknownCORROSION ON LOWER DOOR JAMB AT FWD CARGO COMPARTMENT BTW STA Y370 AND STA Y427 (INNER AND OUTER SIDE). SUMMARY OF NRC 00081: CORROSION LEVEL 2. LOWER DOOR JAMB AT FWD CARGO COMPARTMENT BTW STA Y370 AND STA Y427 WAS REPLACED AND INSTALLED PER B717-200 SRM 51-4SDR DALA2023072806110Unknown · unknownCORROSION ON FITTINGS (2 EA) OF FWD SERVICE DOOR JAMB AT FWD PAX CABIN FLOOR. SUMMARY OF NRC 0180: CORROSION LEVEL 2. FITTINGS (2 EA) WERE REPLACED PER B717-200 SRM 51-41-02-0G. (LP #2887630)SDR COEA2023101101816Web · corrodedWO 247829 NR 100024 HEAVY CHECK COE/MINOR REPAIR: AFT CARGO DOOR THRESHOLD WEB HAS LEVEL 2 CORROSION BETWEEN FRAMES 36-39. CORRECTIVE ACTION: REPLACED THRESHOLD WEB PER ATR72 SRM 51-25-01 & 51-21-08.SDR SWI2023F00374Unknown · corrodedSUPPORT ANGLE COMMON TO INTERCOSTAL DD4 AND AFT FORMER AT FS347 IS CORRODED (C-CHECK RO 9/13/2023) FOUND TO BE OUT OF LIMITS, REMOVED AND REPLACED PAX DOOR SUPPORT ANGLE COMMON TO INTERCOSTAL DD4 AND AFT FORMER AT FS347 IAW CRJ700 SRM 51-42-06-001-001-ASDR SWAA2023090182569Scuff Plate · crackedCRACK FWD CORNER SCUFF PLATE AT FWD CARGO COMPARTMENT 2023-469741<[01] TOOL USED: DIGITAL CALIPER P/N: 500-193-30 S/N: 0037624 DUE DATE: 13-DEC-23;[02] TOOL USED: RADIOMETER/PHOTOMETER. P/N: XRP-3000. S/N: 1998072. DUE DATE: 15-OCT-23.;[03] REPAIRED BY WELDINGSDR SWAA2023090182572Scuff Plate · crackedCRACK AFT CORNER SCUFF PLATE AT FWD CARGO COMPARTMENT. 2023-469742<[01] TOOL USED: RADIOMETER PHOTOMETER; PN: XRP-3000; SN: 1753759; DUE DATE: 14-OCT-23;[02] REPAIRED BY WELDING AFT CORNER SCUFF PLATE AT FWD CARGO COMPARTMENT I.A.W. BOEING 737-700 SRM 53-30-15SDR AALA202309011519Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND FASTENERS HOLES IN FLOOR SUPPORT INTERCOSTAL LOCATED AT BS 950, FROM RBL 24 TO RBL 51. REPLACED INTERCOSTAL PER AARD 51-00-05-1.
Back to JASC 5320