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 SWAA2023062755903Angle · corrodedA-221-04 AFT CARGO COMPARTMENT L//H/S Z ANGLE BETWEEN STA 807 AND 727F TOP SKIN SURFACE SEVERAL AREAS AS MARKED ARE CORRODED<[01] BLENDED OUT CORROSION SPOTS FROM STA 727F TO STA 807; FOUND TO BE WITHIN LIMITS FROM STA 727F TO 727H + 10' AND FROM STA 767+10' TSDR SWAA2023062155883Intercostal · corrodedAFT CARGO INTERCOSTAL RBL 21 BETWEEN STA 747 AND STA 767 HAS CORROSION<[01] FOUND CORROSION TO BE OUT OF ALLOWABLE LIMITS PER SRM 5300-53-1A-2.;[02] REMOVED AND REPLACED AFT CARGO INTERCOSTAL AT STA 747-767 RBL 21 PER SRM 51-40-02.;[03] C/W INSPECTION OF WORK SDR AALA202306214452Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT DOOR THRESHOLD WEB LOCATED AT BS 440 AND WL 30. REPLACED THRESHOLD WEB PER AARD 51-00-05-1 AND DWG 143A8126.SDR AALA202306205620Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 500A TO BS 500G AT S25R. REPLACED TRANSITION PANEL PER SRM 51-40-02 AND SRM 53-00-53.SDR AALA202306196742Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 500G TO BS 500H AT LBL 28. REPAIRED TRANSITION PANEL PER SRM 53-00-2R-6.SDR AALA202306183857Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 400 TO BS 420 AT RBL 25. REPLACED TRANSITION PANEL PER DWG 143A7501, AARD 51-00-05-1, AND SRM 51-40-02.SDR AALA202306182961Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 500A TO BS 500F AT S26L. REPLACED TRANSITION PANEL PER DWG 143A7500, AARD 51-00-05-1, AND SRM 51-40-02.SDR AALA202306167018Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND TRANSITION SHIELD LOCATED FROM BS 420 TO BS 440 AT RBL 25. REPLACED TRANSITION SHIELD PER DWG 143A8126, AARD 51-00-05-1, AND SRM 51-40-02.SDR AALA202306160350Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND TRANSITION SHIELD LOCATED FROM BS 500 TO BS 500A AT RBL 25. REPLACED TRANSITION PANEL PER DWG 143A0080, AND AARD 51-00-05-1.SDR AALA202306161167Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED AT BS 500C PLUS 12 INCHES AND RBL 28. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R-6 AND SRM 51-40-02.SDR DALA2023060604610Unknown · unknownSHIP 660 SECONDARY NRC IN REF NRC 00356: CORROSION ON FLOOR STRINGER STA 1470 RBL 16 AND RBL 10 ALSO ON PREVIOUS REPAIR RB 7 AT AFT CARGO COMPARTMENT. CORRECTIVE ACTION: SUMMARY OF NRC 00767: FLOOR STRINGER STA 1470 RBL 16, RBL 10 AND PREVIOUS REPAIR RBL 7 WERSDR DALA2023060604609Unknown · unknownSHIP 660 SECONDARY NRC IN REF NRC 00342: CORROSION ON LH SIDE PLATE FROM BTW STA 1530 TO STA 1580 AT AFT CARGO COMPARTMENT IN REF NRC 00342. CORRECTIVE ACTION: SUMMARY OF NRC 00780 LH SIDE PLATE FROM BTW STA 1530 TO STA 1580 WAS REPAIRED PER B757-200 SRM. (279SDR DALA2023060604608Unknown · unknownSHIP 660 CORROSION ON LH SIDE PLATE FROM STA 1200 TO STA 1310 AT AFT CARGO COMPARTMENT. CORRECTIVE ACTION: SUMMARY OF NRC 00345: LH SIDE PLATE FROM STA 1200 TO STA 1310 WAS REPLACED PER B757-200 SRM. (2795987)SDR DALA2023060504538Unknown · unknownSHIP 3356 CORROSION FLOOR STRUCTURE CROSS BEAM LOC. FR75 AND -Y280 AT AFT GALLEY AREA. CORRECTIVE ACTION: COMPLIED WITH PRI 608875-14, VALIDATED ER/A 608875-14 MATCHES PRI 608875-14. (2796816)SDR DALA2023060204426Unknown · unknownCRACK ON CUSP MEMBRANE (WEB) X=56 AND STA 611 AT CPAX. CRACK WAS REPAIRED PER B-717-200 SRM 53-00-55-2R PROCEDURE 4 PAR 5 FIG 204. (LP #2795916)SDR AALA202306021378Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AFT ENTRY FLOOR STRUCTURE INTERCOSTAL LOCATED FROM BS 986.6 TO BS 1006 AT LBL 32. REPLACED INTERCOSTAL PER SRM 51-40-02 AND SRM 51-40-05.SDR AALA202306025553Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AFT ENTRY FLOOR STRUCTURE INTERCOSTAL LOCATED FROM BS 986.6 TO BS 1006 AT RBL 32. REPLACED INTERCOSTAL PER SRM 51-40-02 AND SRM 51-40-05.SDR AALA202306024119Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202306022182Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202306026624Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202306026907Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202306024203Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202306022852Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202306028551Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202306020811Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202306024749Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202306023402Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR SWAA2023070555112Angle · crackedCABLE INTERCOSTAL ATTACH ANGLE IS CRACKED IN RADIUS BS 692; RBL 1; WL 206<[01] REMOVED DAMAGED CABLE INTERCOSTAL ATTACH ANGLE BS 692; RBL 1; WL 206 IAW SRM 51-40-02;[02] FORMED NEW INTERCOSTAL ATTACH ANGLE BS 692 ; RBL 1 WL 206 MATERIAL USED 7075T0 ; 0.050' CLSDR SWAA2023070355252Attach Angle · corrodedCORROSION AFT CARGO BAY ATTACH ANGLE UNDER SHIELD HAS MULTIPLE AREAS UNDER NUT PLATES BS767 TO BS787 RBL21 WL156<[01] CORROSION ON ANGLE WAS FOUND TO BE OUT OF LIMITS DUE TO NO LIMITS ARE GIVEN IN THE SRM.;[02] VERIFIED CORRECTIVE ACTION 1SDR SWAA2023070355251Shield · corrodedCORROSION AFT CARGO BAY SHIELD FWD OF CARGO DOOR AROUND MULTIPLE NUT PLATE HOLES BS767+3 TO BS794 RBL22 WL156<[01] CORROSION ON SHIELD WAS FOUND TO BE OUT OF LIMITS DUE TO NO LIMITS ARE GIVEN IN THE SRM.;[02] VERIFIED CORRECTIVE ACTION 1;[03] UPDATE TO CORRECTSDR SWAA2023070355253Angle · corrodedCORROSION AFT CARGO BAY ATTACH ANGLE UNDER SHIELD HAS MULTIPLE AREAS UNDER NUT PLATES BS767 TO BS787 RBL21 WL156<[01] CORROSION ON ANGLE WAS FOUND TO BE OUT OF LIMITS DUE TO NO LIMITS ARE GIVEN IN THE SRM.;[02] VERIFIED CORRECTIVE ACTION 1;[03] UPDATE TO CORRESDR SWAA2023070355299Door · corrodedCORROSION ON FWD ENTRY DOOR MOPSILL BS 300-312; LBL 65; WL 208.<[01] VERIFIED APPLICABILITY OF SRM 53-10-15-1A-1; REMOVED CORROSION OF FWD ENTRY DOOR MOPSILL BS 300-312; LBL 65; WL 208 AND FOUND OUT OF LIMITS; MATERIAL THICKNESS 0.090' REMOVED MATERIAL 0.020' SDR SWAA2023070355250Shield · corrodedCORROSION AFT CARGO BAY SHIELD FWD OF CARGO DOOR AROUND MULTIPLE NUT PLATE HOLES BS767+3 TO BS794 RBL22 WL156<[01] CORROSION ON SHIELD WAS FOUND TO BE OUT OF LIMITS DUE TO NO LIMITS ARE GIVEN IN THE SRM.;[02] VERIFIED CORRECTIVE ACTION 1SDR SWAA2023070355099Intercostal · corrodedCORROSION WEB - INTERCOSTAL LOCATED BETWEEN BS767 TO BS794.3 AND RBL21 WL156 AFT CARGO COMPARTMENT 2023-360225<[01] REPLACED WEB - INTERCOSTAL LOC. BETWEEN BS767 TO BS794.3 AND RBL21 WL156 AFT CARGO COMPARTMENT IAW B737-700 SRM-51-40-02 AND DWG-146A8127 REV: -SDR SWAA2023070355098Angle · corrodedCORROSION ANGLE LOCATED BS767 TO BS787 AND RBL20 WL156 AFT CARGO COMPARTMENT 2023-360223<[01] REPLACED ANGLE LOCATED BS767 TO BS787 AND RBL20 WL156 AFT CARGO COMPARTMENT IAW B737-700 SRM 51-10-02 ITEM 9. AND DRAWING # 146A8123. REV: - . SEE INDIVIDUAL SIGN OFFSDR SWAA2023070355096Support · corrodedCORROSION SUPPORT ZEE LOCATED BETWEEN BS727 TO BS767 AND RBL21 WL156 AFT CARGO COMPARTMENT 2023-360220<[01] REPLACED SUPPORT ZEE LOCATED BETWEEN BS727 TO BS767 AND RBL21 WL156 AFT CARGO COMPARTMENT IAW B737-700 SRM-51-40-02 AND DWG-146A7500 REV: -; SEE INDIVIDSDR SWAA2023070355097Support · corrodedCORROSION SUPPORT ZEE LOCATED BETWEEN BS727D TO BS807 AND LBL21 WL156 AFT CARGO COMPARTMENT 2023-360222<[01] TOOL USED: ULTRASONIC THICKNESS GAGE; P/N: 38DL PLUS; S/N: 120398603; CAL DUE DATE:07-NOV-23;[02] REPLACED SUPPORT ZEE LOCATED BETWEEN BS727 TO BS 847 SDR SWAA2023062954982Angle · crackedCRACKED INTERCOSTAL AT PASSENGER CABIN BS500D+6 BL0 WL208.<[01] REMOVED PASSENGER CABIN UPPER ANGLE INTERCOSTAL FROM BS500D - BS420; BL 0; PER SRM 51-40-02-0G-0.<BR>RECEIVED FROM TOOL ROOM NEW INTERCOSTAL UPPER ANGLE P/N 143A5410-170; LOCATED AND DRILL PER SRMSDR SWAA2023062954980Intercostal · crackedCRACKED INTERCOSTAL AT PASSENGER CABIN BS380+14 LBL13 WL208.<[01] DRILLED FASTENERS AND REMOVED INTERCOSTAL IAW SRM 51-40-02;[02] CERTIFY;[03] UPDATED MEASUREMENT TABLE;[04] RECEIVED NEW ANGLE PER CUSTOMER RO: N923207-SWA;[05] VERIFIED CORRECTIVE ACTION 4;[06]SDR SWAA2023062954983Intercostal · crackedCRACKED INTERCOSTAL AT PASSENGER CABIN BS380+14 BL0 WL208.<[01] REMOVED PASSENGER CABIN UPPER ANGLE INTERCOSTAL FROM BS380 - BS400; BL 0; PER SRM 51-40-02-0G-0<BR>RECEIVED FROM TOOL ROOM NEW INTERCOSTAL UPPER ANGLE P/N 143A5410-170; LOCATED AND DRILL PER SRM 5SDR SWAA2023062955102Angle · crackedCRACK ANGLE LOCATED BETWEEN BS907 TO BS927 AND STR25R TO STR27R AFT POSITION AFT CARGO COMPARTMENT 2023-360228<[01] REPLACED ANGLE LOCATED BETWEEN BS907 TO BS927 AND STR25R TO STR27R AFT POSITION AFT CARGO COMPARTMENT IAW B737-700 SRM 51-10-02 ITEM 9 AND DRAWISDR SWAA2023062955285Floor Support · crackedPASSENGER CABIN FLOOR SUPPORT BS 380-400; RBL 10; WL 208 IS CRACKED.<[01] NO ENTRIES FOUND ON SRM FOR PASSENGER CABIN FLOOR SUPPORT BS 380-400; RBL 10; WL 208 PART TO BE REMOVED AND REPLACED PER SRM 51-10-02-0G-0 PAR 9.C;[02] REMOVED PASSENGER CABIN FLOOR SUPPSDR SWAA2023062955287Floor Support · crackedPASSENGER CABIN FLOOR SUPPORT BS 380-400; LBL 15; WL 208 IS CRACKED.<[01] NO ENTRIES FOUND ON SRM FOR CRACKED INTERCOSTAL UPPER ATTACH ANGLE STA 380-400; LBL 15; WL 208 PART TO BE REMOVED AND REPLACED PER SRM 51-10-02-0G-0 PAR 9.C;[02] REMOVED CRACKED INTERCOSSDR SWAA2023062955283Floor Support · crackedPASSENGER CABIN FLOOR SUPPORT BS 380-400; RBL 1; WL 208 IS CRACKED.<[01] NO ENTRIES FOUND ON SRM FOR PASSENGER CABIN FLOOR SUPPORT BS 380-400; RBL 1; WL 208 PART TO BE REMOVED AND REPLACED PER SRM 51-10-02-0G-0 PAR 9.C;[02] REMOVED PASSENGER CABIN FLOOR SUPPORSDR SWAA2023062954829Shield · elongatedFORWARD CARGO BAY AFT SHIELD HAS AN ELONGATED FASTENER HOLE BS495 RBL22 WL 156<[01] ELONGATED HOLE ON SHIELD WAS FOUND TO BE OUT OF LIMITS DUE TO NO LIMITS ARE GIVEN IN THE SRM.;[02] VERIFIED CORRECTIVE ACTION 1;[03] UPDATE TO CORRECTIVE ACTION STEP 1. ELONGATSDR SWAA2023062955255Bracket · brokenAFT CARGO BAY LAV TANK BULKHEAD LOWER BRACKET IS BROKEN BS867 LBL10 WL166<[01] REMOVED DAMAGED ACB LAV TANK BULKHEAD LOWER BRACKET BS 867; LBL10; WL166 PER SRM 51-40-02-0G-0.;[02] LOCATED AND DRILLED ACB LAV TANK BULKHEAD LOWER BRACKET BS 867; LBL10; WL166 PERSDR SWAA2023062955100Angle · crackedCRACK ANGLE LOCATED BS867 AND LBL11 WL157 AFT CARGO COMPARTMENT 2023-360234<[01] REPLACED ANGLE AND FASTENERS LOCATED BS867 AND LBL11 WL157 AFT CARGO COMPARTMENT IAW B737-700 SRM 51-40-05 AND DWG: 149A8102 REV: -; SEE INDIVIDUAL SIGN-OFF BELOW.;[02] CORRECTED SDR SWAA2023062955103Tie Clip · crackedCRACK BILGE AREA TIE CLIP LOCATED BS727E AND STR26R AT AFT CARGO COMPARTMENT 2023-360242<[01] REPLACED TIE CLIP AND FASTENERS LOCATED BS727E AND STR26R AT AFT CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 AND SRM 51-10-02 ITEM 9 AND DWG:146A1221 SHEET: 50 REV: -SDR SWAA2023062955086Scuff Plate · crackedAFT CARGO BAY FWD CORNER SCUFF PLATE IS CRACKED<[01] WELDED CRACK ON AFT CARGO DOOR FWD CORNER SCUFF PLATE USING ER4043 FILLER ROD LOT NUMBER 1131216 PER SRM 53-60-15-2R-1 REPAIR 1 PARAGRAPH 4.B. (2) AND (4)<BR>EQUIP USED: WELDING MACHINE E10583; CAL DUE 01/20SDR SWAA2023062955087Scuff Plate · crackedAFT CARGO BAY AFT CORNER SCUFF PLATE IS CRACKED<[01] WELDED CRACK ON AFT CARGO BAY AFT CORNER SCUFF PLATE USING ER4043 FILLER ROD LOT NUMBER 1131216 PER SRM 53-60-15-2R-1 REPAIR 1 PARAGRAPH 4.B. (2) AND (4)<BR>EQUIP USED: WELDING MACHINE E10583; CAL DUE 01/202
Back to JASC 5320