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 SWAA2021100412498Intercostal · crackedCRACKED SUPPORT INTERCOSTAL (LOWER AFT CORNER) AT STA 500D OF LH TRANSITION ANGLE IN FWD CARGO COMPARTMENT. ; / [01] REMOVED INTERCOSTAL PER SRM 51-40-02.; [02] REMOVED AND REPLACED PER SRM 51-40-02.; [03] C/W INSPECTIONSDR SWAA2021100412497Attach Angle · crackedCRACKED ATTACH ANGLE AT STA 500B(FWD SIDE OF FRAME) FOR SUPPORT INTERCOSTAL OF LH TRANSITION ANGLE IN FWD CARGO COMPARTMENT. ; / [01] REMOVED CLIP PER SRM 51-40-02; [02] REMOVED AND REPLACED PER SRN 51-40-02.; [03] C/W INSPECTIONSDR SWAA2021100412496Angle · crackedCRACKED ATTACH ANGLE AT STA 420 FOR SUPPORT INTERCOSTAL OF LH TRANSITION ANGLE IN FWD CARGO COMPARTMENT. ; / [01] REMOVED AND REPLACED PER SRM 51-40-02.; [02] C/W INSPECTIONSDR SWAA2021100412489Intercostal · crackedCRACKED ATTACH ANGLE AT STA 400 FOR SUPPORT INTERCOSTAL OF LH TRANSITION ANGLE IN FWD CARGO COMPARTMENT. ; / [01] REMOVED L/H SUPPORT INTERCOSTAL STA 400-420; [02] REMOVED AND REPLACED PER SRM 51-40-02.; [03] PART INFO ENTRY.; [04] REMOVED AND REPLACED PER SRMSDR SWAA2021100412512Angle · corrodedL/H TRANSITION ANGLE AT STA 767-787 HAS EVIDENCE OF CORROSION. ; / [01] CORROSION FOUND TO BE OUT OF LIMITS PER SRM 53-0053-1A-2.; [02] REMOVED L/H TRANSITION ANGLE PER SRM 51-40-02.; [03] BACK DRILLED HOLES IN NEW ANGLE PER SRM 51-40-05-0G-0. ANGLE TO BE INSTSDR SWAA2021100412510Angle · corrodedL/H TRANSITION ANGLE AT STA 727B-727C HAS EVIDENCE OF CORROSION. ; AFT CARGO LH TRANSITION ANGLE AT STA 727B-727C HAS EVIDENCE OF CORROSION. / [01] CORROSION FOUND TO BE OUT OF LIMITS PER SRM 53-0053-1A-2.; [02] REMOVED L/H TRANSITION ANGLE PER SRM 51-40-02.; SDR SWAA2021100412504Angle · corrodedR/H TRANSITION ANGLE AT STA 727E-747 HAS EVIDENCE OF CORROSION. ; AFT CARGO. / [01] CORROSION FOUND TO BE OUT OF LIMITS PER SRM 53-0053-1A-2.; [02] REMOVED AFT CARGO R/H TRANSITION ANGLE; STA 727+4 TO STA 767 PER SRM 51-40-02.; [03] BACK DRILLED HOLES IN NEW ASDR SWAA2021100412511Angle · corrodedR/H TRANSITION ANGLE AT STA 747-767 HAS EVIDENCE OF CORROSION. ; AFT CARGO. / [01] CORROSION FOUND TO BE OUT OF LIMITS PER SRM 53-0053-1A-2.; [02] REMOVED AFT CARGO R/H TRANSITION ANGLE; STA 727+4 TO STA 767 PER SRM 51-40-02.; [03] BACK DRILLED HOLES IN NEW ANSDR SWAA2021100412509Angle · corrodedL/H TRANSITION ANGLE AT STA 727D-727E HAS EVIDENCE OF CORROSION. ; AFT CARGO / [01] CORROSION FOUND TO BE OUT OF LIMITS PER SRM 53-0053-1A-2.; [02] REMOVED L/H TRANSITION ANGLE PER SRM 51-40-02.; [03] BACK DRILLED HOLES IN NEW ANGLE PER SRM 51-40-05-0G-0. ANGLSDR SWAA2021100412508Angle · corrodedL/H TRANSITION ANGLE AT STA 727E-747 HAS EVIDENCE OF CORROSION. ; AFT CARGO / [01] CORROSION FOUND TO BE OUT OF LIMITS PER SRM 53-0053-1A-2.; [02] REMOVED L/H TRANSITION ANGLE PER SRM 51-40-02.; [03] BACK DRILLED HOLES IN NEW ANGLE PER SRM 51-40-05-0G-0. ANGLESDR SWAA2021100412507Angle · corrodedL/H TRANSITION ANGLE AT STA 747-767 HAS EVIDENCE OF CORROSION. ; AFT CARGO / [01] CORROSION FOUND TO BE OUT OF LIMITS PER SRM 53-0053-1A-2.; [02] REMOVED L/H TRANSITION ANGLE PER SRM 51-40-02.; [03] BACK DRILLED HOLES IN NEW ANGLE PER SRM 51-40-05-0G-0. ANGLE SDR SWAA2021100412505Angle · corrodedR/H TRANSITION ANGLE AT STA 727D-727E HAS EVIDENCE OF CORROSION. ; AFT CARGO. / [01] CORROSION FOUND TO BE OUT OF LIMITS PER SRM 53-0053-1A-2.; [02] REMOVED AFT CARGO R/H TRANSITION ANGLE; STA 727+4 TO STA 767 PER SRM 51-40-02.; [03] BACK DRILLED HOLES IN NEW SDR SWAA2021092211797Angle · crackedCRACK ANGLE - CLIP LOCATED FWD FACE BS500C AT LEVEL STR26L FWD CARGO COMPARTMENT ; 2021-392155 / [01] REMOVED ANGLE - CLIP LOCATED FWD FACE BS500C AT LEVEL STR26L FWD CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 AND PERFORMED VISUAL INSPECTION ON ADJACENT AREA SDR SWAA2021092211794Gusset · crackedCRACK GUSSET LOCATED BS500D AND STR19R FWD CARGO COMPARTMENT ; 2021-392157 / [01] EVALUATED DAMAGE ON GUSSET AND NOT FOUND ALLOWABLE DAMAGE LIMITS IN SRM B737-700; REMOVED GUSSET AND FASTENERS IAW B737-700 SRM 51-40-02 AND PERFORMED VISUAL INSPECTION ON COMMONSDR SWAA2021092211798Gusset · crackedCRACK GUSSET LOCATED BS500D AND STR19L FWD CARGO COMPARTMENT ; 2021-392156 / [01] EVALUATED DAMAGE ON GUSSET AND NOT FOUND ALLOWABLE DAMAGE LIMITS IN SRM B737-700; REMOVED GUSSET AND FASTENERS IAW B737-700 SRM 51-40-02 AND PERFORMED VISUAL INSPECTION ON COMMONSDR SWAA2021092212340Angle · elongatedELONGATED HOLE ANGLE LOCATED BS847 AND RBL 21 AT AFT CARGO COMPARTMENT ; 2021-392173 / [14] REPLACED ANGLE AND FASTENERS LOCATED BS847 AND RBL 21 AT AFT CARGO COMPARTMENT IAW B737-700 SRM 51-10-02 ITEM 9 SRM 51-40-02 DRAWING 146A8321 REV<BR>RIISDR SWAA2021092212339Support Angle · crackedCRACK ANGLE - SUPPORT LOCATED BS867 AT LEVEL STR26L AFT CARGO COMPARTMENT ; 2021-392163 / REPLACED ANGLE SUPPORT LOCATED BS867 AT LEVEL STR26L AFT CARGO COMPARTMENT IAW B737-700 SRM 51-40- 02 AND B737-700 SRM 51-10-02 ITEM 9 DWG 149A8102 SHEET 17 REV. .SDR SWAA2021092212336Web · crackedCRACK WEB - INTERCOSTAL LOCATED BETWEEN BS927 TO BS947.5 AT LEVEL STR25R AFT CARGO COMPARTMENT ; 2021-392167 / [19] REPLACED WEB-INTERCOSTAL AND FASTENERS LOCATED BTW BS 927 AND BS 947.5 AT STR 25R IAW B737-700 SRM 51-10-02 PARAGRAPH 9; 51-40-02 AND DWG 147A75SDR SWAA2021092212335Support · corrodedCORROSION SUPPORT ZEE LOCATED BETWEEN BS727C TO BS807 AND LBL21 WL154.5 AFT CARGO COMPARTMENT ; 2021-392160 / [25] REPLACED SUPPORT ZEE LOCATED BETWEEN BS727 TO BS847 AND LBL21 WL154.5 AFT CARGO COMPARTMENT I.A.W B737-700 SRM 51-40-02 AND DWG 146A7500 SHEET 85SDR SWAA2021092212338Web · corrodedCORROSION WEB - INTERCOSTAL LOCATED BETWEEN BS767 TO BS794 AND RBL21 WL154.5 AFT CARGO COMPARTMENT ; 2021-392161 / REPLACED WEB-INTERCOSTAL LOCATED BETWEEN BS 767 TO BS 794 AND RBL21; WL154.5 AFT CARGO COMPARTMENT IAW B737-700 SRM 51-10-02 ITEM 9 AND IAW B737-SDR SWAA2021092212337Support · corrodedCORROSION SUPPORT ZEE LOCATED BETWEEN BS727A TO BS767 AND RBL21 WL154.5 AFT CARGO COMPARTMENT ; 2021-392159 / [17] REPLACED SUPPORT ZEE SECTION LOCATED ON BETWEEN BS 727+4 INCHS TO BS 767 AND RBL 21 WL 154.5 AFT CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 B737SDR SWAA2021091511198Angle · crackedAFT CARGO COMPARTMENT (LEEKA) ANGLE CRACKED AT BS 867; AT LOWER WASTE TANK BULKHEAD STRUCTURE. / REMOVED AFT CARGO COMPARTMENT DAMAGED 'LEEKA' ANGLE AT BS 867; AT LOWER WASTE TANK BULKHEAD STRUCTURE AND REPLACED NEW IAW BOEING DRAWING 149A8109 REV B AND B-737 SDR SWAA2021091312220Support Angle · crackedACB WASTE TANK ENCLOSE BULKHEAD SUPPORT ANGLE CRACKED. BS867-1.5; LBL10; WL161 ; / [01] REMOVED BULKHEAD ANGLE SUPPORT AT BS867-1.5' LBL10 WL161 IAW SRM 51-40-02 NO ALLOWABLE LIMITS FOR CRACK; ANGLE IS REPAIRED BY REPLACEMENT IAW SRM 51-10-02; [02] REMOVED BULSDR SWAA2021091312145Shield · corrodedACB FWD SHIELD CORROSION. BS767+11.5; RBL22; WL151 ; / [01] NO ALLOWABLE DAMAGE FOUNDED ON SRM; REPLACE PART FOR REPAIR; THE REP AIR WILL BE DONE UNDER CUSTOMER FAULT TTG8Q006A1HS; [02] NO ALLOWABLE DAMAGE FOUNDED ON SRM; REPLACE PART FOR REPAIR; THE REPAIR WISDR SWAA2021091312820Shield · corrodedCORROSION ON FORWARD BAY SHIELD AT B.S. 494-500A; R.B.L. 24; W.L. 154. ; / [01] NO ALLOWABLE DAMAGE LIMITS IN SRM REPAIR BY REPLACEMENT IAW SRM 51-10-02-0G-0 RECEIVED NEW BAY SHIELD ITEM HFAB53-SHD-011; LOT:1467549-1; PO NUMBER: 835449. LOCATED AND DRILLED; COSDR SWAA2021091312818Support · corrodedCORROSION ON FORWARD CARGO BAY AFT BULKHEAD CENTER PANEL LOWER SUPPORT AT B.S. 500D; L.B.L. 24 - R.B.L. 24; W.L. 154. ; / [01] ADDED MEASURMENTS; [02] NO ALLOWABLE DAMAGE FOUND IN B737-700 SRM FOR FORWARD CARGO BAY AFT BULKHEAD CENTER PANEL LOWER SUPPORT AT BSSDR SWAA2021091312191Support · corrodedACB FLOOR TO SIDEWALL SUPPORT CORROSION. BS747+4; RBL22; WL151 ; / REMOVED CORROSION ON ACB FLOOR TO SIDEWALL SUPPORT AT BS 747+4'; RBL 22; WL 151 ; WORK AREA 1.0'X 1.0' X 0.012' ; REMAINING THICKNESS IS 0.028 ; ORIGINAL THICKNESS IS 0.040; FOUND TO BE OUT OF SDR SWAA2021091312185Shield · corrodedACB FWD SHIELD CORROSION. BS767+3.5; RBL22; WL151 ; / [01] REMOVED CORROSION ON ACB FWD SHIELD BS767+3.5 RBL21 WL151; L=.500 W=.500 D=.005;USED CALIBRATION TOOL ID:ATS1866 SERIAL:UNKNOWN DATE DUE:01/2022; NO ALLOWABLE LIMITS IN SRM; SHIELD IS REPAIRED BY REPLASDR SWAA2021091312195Support · corrodedACB FLOOR TO SIDEWALL SUPPORT CORROSION. BS747+14.5; RBL22; WL151 ; / [01] REMOVED CORROSION ON ACB FLOOR TO SIDEWALL SUPPORT AT BS 747+14.5'; RBL 22; WL 151 ; WORK AREA 1.0'X 1.0' X 0.012' ; REMAINING THICKNESS IS 0.028 ; ORIGINAL THICKNESS IS 0.040; FOUND TOSDR SWAA2021091312130Strap · corrodedACB DOOR SURROUND STRUCTURE STRAP CORROSION BS807+2; RBL19.25; WL154. ; / [01] REMOVED AND EVALUATED CORROSION AT BS807+2 RBL19 WL154. DAMAGE MEASURES 1.3LX1.1WX0.025D. DAMAGE FOUND TO BE OUT OF LIMITS PER SRM 53-60-15-1A-1. PART TO BE REPAIRED BY REPLACEMENT.SDR SWAA2021091312241Web · corrodedACB DOOR SURROUND; SUB THRESHOLD WEB CORROSION. BS827+2.2; RBL27; WL153. REMOVED CORROSION ON AFT CARGO BAY SUB THRESHOLD WEB AT BS 827+2.2' RBL 27 WL 153. MEASURED L 1' X W .5' AND 0.006' DEEP. ORIGINAL THICKNESS .050'; REMAINING THICKNESS .049'. FOUND TO SDR SWAA2021091312240Web · corrodedACB DOOR SURROUND; SUB THRESHOLD WEB CORROSION. BS827+2.5; RBL27; WL153 ; / [01] REMOVED CORROSION ON AFT CARGO BAY SUB THRESHOLD WEB AT BS 827+2.5' RBL 27 WL 153<BR>MEASURED L 1' X W 1' AND 0.006' DEEP. ORIGINAL THICKNESS .050'; REMAINING THICKNESS .049'<BR>FSDR SWAA2021091312132Support · corrodedACB FLOOR TO SIDEWALL SUPPORT CORROSION. BS787+10.25; LBL22; WL153 ; / [01] REMOVED CORROSION FROM FLOOR TO SIDEWALL SUPPORT BS 787 + 10.25 LBL 22 ACB IN AREA OF L=.5' X W=.5' D=.006' REMAINING THICKNESS =.034' FROM ORIGINAL THICKNESS .040' FOUND TO BE OUT OF SDR SWAA2021091312189Support · corrodedACB FLOOR TO SIDEWALL SUPPORT CORROSION; LOWER SURFACE. BS767+18.5; LBL22; WL151 ; / [01] REMOVED CORROSION FROM FLOOR TO SIDEWALL SUPPORT BS 767 +18.5 LBL 22 ACB IN AREA OF L=.5' X W=.5' D=.006' REMAINING THICKNESS =.034' FROM ORIGINAL THICKNESS .040' FOUND TSDR SWAA2021091312188Support · corrodedACB FLOOR TO SIDEWALL SUPPORT CORROSION. BS767+10.5; LBL22; WL151 ; / [01] REMOVED CORROSION FROM FLOOR TO SIDEWALL SUPPORT BS 767=10.5 LBL 22 ACB IN AREA OF L=.5' X W=.5' D=.006' REMAINING THICKNESS =.034' FROM ORIGINAL THICKNESS .040' FOUND TO BE OUT OF LIMISDR SWAA2021091312197Support · corrodedACB FLOOR TO SIDEWALL SUPPORT CORROSION. BS747+16.25; RBL20; WL151 ; / [01] REMOVED CORROSION ON ACB FLOOR TO SIDEWALL SUPPORT AT BS 747+16.25'; RBL 20; WL 151 ; WORK AREA 1.0'X 1.0' X 0.011' ; REMAINING THICKNESS IS 0.029 ; ORIGINAL THICKNESS IS 0.040; FOUND SDR SWAA2021091312153Support · corrodedACB FLOOR TO SIDEWALL SUPPORT CORROSION; LOWER SURFACE. BS767+5.5; LBL22; WL151 ; / [01] REMOVED CORROSION FROM FLOOR TO SIDEWALL SUPPORT BS 767 + 5.5' LBL 22 ACB IN AREA OF L=.5' X W=.5' D=.006' REMAINING THICKNESS =.034' FROM ORIGINAL THICKNESS .040' FOUND TSDR SWAA2021091312154Support · corrodedACB FLOOR TO SIDEWALL SUPPORT CORROSION; LOWER SURFACE. BS767+14.5; LBL22; WL151 ; / [01] REMOVED CORROSION FROM FLOOR TO SIDEWALL SUPPORT BS 767+14.5 LBL 22 ACB IN AREA OF L=.5' X W=.5' D=.006' REMAINING THICKNESS =.034' FROM ORIGINAL THICKNESS .040' FOUND TOSDR SWAA2021091312152Support · corrodedACB FLOOR TO SIDEWALL SUPPORT CORROSION. BS767+14.5; LBL22; WL151 ; / [01] REMOVED CORROSION FROM FLOOR TO SIDEWALL SUPPORT BS 767 + 14.5 LBL 22 ACB IN AREA OF L=.5' X W=.5' D=.006' REMAINING THICKNESS =.034' FROM ORIGINAL THICKNESS .040' FOUND TO BE OUT OF LISDR SWAA2021091312167Support · corrodedACB FLOOR TO SIDEWALL SUPPORT CORROSION. BS767; RBL22; WL151 ; / [01] REMOVED CORROSION ON ACB FLOOR TO SIDEWALL SUPPORT AT BS 767; RBL 22; WL 151 ; WORK AREA 1.0'X 1.0' X 0.012' ; REMAINING THICKNESS IS 0.028; ORIGINAL THICKNESS IS 0.040; FOUND TO BE OUT OF LSDR SWAA2021091312158Support · corrodedACB FLOOR TO SIDEWALL SUPPORT CORROSION. BS747+18.5; LBL22; WL151 ; / [01] REMOVED CORROSION FROM FLOOR TO SIDEWALL SUPPORT BS 747+18.5 LBL 22 ACB IN AREA OF L=.5' X W=.5' D=.006' REMAINING THICKNESS =.034' FROM ORIGINAL THICKNESS .040' FOUND TO BE OUT OF LIMISDR SWAA2021091312156Support · corrodedACB FLOOR TO SIDEWALL SUPPORT CORROSION. BS747+10.5; LBL22; WL151 ; / [01] REMOVED CORROSION FROM FLOOR TO SIDEWALL SUPPORT BS 747+10.5 LBL 22 ACB IN AREA OF L=.5' X W=.5' D=.006' REMAINING THICKNESS =.034' FROM ORIGINAL THICKNESS .040' FOUND TO BE OUT OF LIMISDR SWAA2021091312157Support · corrodedACB FLOOR TO SIDEWALL SUPPORT CORROSION. BS747+14.5; LBL22; WL151 ; / [01] REMOVED CORROSION FROM FLOOR TO SIDEWALL SUPPORT BS 747 +14.5 LBL 22 ACB IN AREA OF L=.5' X W=.5' D=.006' REMAINING THICKNESS =.034' FROM ORIGINAL THICKNESS .040' FOUND TO BE OUT OF LIMSDR SWAA2021091312155Support · corrodedACB FLOOR TO SIDEWALL SUPPORT CORROSION. BS747+6.5; LBL22; WL151 ; / [01] REMOVED CORROSION FROM FLOOR TO SIDEWALL SUPPORT BS 747+6.5 LBL 22 ACB IN AREA OF L=.5' X W=.5' D=.006' REMAINING THICKNESS =.034' FROM ORIGINAL THICKNESS .040' FOUND TO BE OUT OF LIMITSSDR SWAA2021091312200Support · corrodedACB FLOOR TO SIDEWALL SUPPORT CORROSION. BS747+19; RBL21; WL151 ; / [01] REMOVED CORROSION ON ACB FLOOR TO SIDEWALL SUPPORT AT BS 747+19'; RBL 21; WL 151 ; WORK AREA 1.0'X 1.0' X 0.015' ; REMAINING THICKNESS IS 0.025 ; ORIGINAL THICKNESS IS 0.040; FOUND TO BE SDR SWAA2021091312198Support · corrodedACB FLOOR TO SIDEWALL SUPPORT CORROSION; LOWER SURFACE. BS747+16; RBL21; WL151 ; / [01] REMOVED CORROSION ON ACB FLOOR TO SIDEWALL SUPPORT AT BS 747+16'; RBL 21; WL 151 ; WORK AREA 1.0'X 1.0' X 0.012' ; REMAINING THICKNESS IS 0.028 ; ORIGINAL THICKNESS IS 0.04SDR SWAA2021091312199Support · corrodedACB FLOOR TO SIDEWALL SUPPORT CORROSION. BS747+18.5; RBL22; WL151 ; / [01] REMOVED CORROSION ON ACB FLOOR TO SIDEWALL SUPPORT AT BS 747+18.5'; RBL 22; WL 151 ; WORK AREA 1.0'X 1.0' X 0.015' ; REMAINING THICKNESS IS 0.025 ; ORIGINAL THICKNESS IS 0.040; FOUND TOSDR SWAA2021091312196Support · corrodedACB FLOOR TO SIDEWALL SUPPORT CORROSION. BS747+15.75; RBL21; WL151 ; / [01] REMOVED CORROSION ON ACB FLOOR TO SIDEWALL SUPPORT AT BS 747+15.75'; RBL 21; WL 151 ; WORK AREA 1.0'X 1.0' X 0.011' ; REMAINING THICKNESS IS 0.029; ORIGINAL THICKNESS IS 0.040; FOUND TSDR SWAA2021091312163Support · corrodedACB FLOOR TO SIDEWALL SUPPORT CORROSION. BS747+2; RBL21; WL151 ; / [01] REMOVED CORROSION ON ACB FLOOR TO SIDEWALL SUPPORT AT BS 747+2'; RBL 22; WL 151 ; WORK AREA 1.0'X 1.0' X 0.035' ; REMAINING THICKNESS IS 0.005 ; ORIGINAL THICKNESS IS 0.040; FOUND TO BE OUSDR SWAA2021091312194Support · corrodedACB FLOOR TO SIDEWALL SUPPORT CORROSION. BS747+10.5; RBL22; WL151 ; / [01] REMOVED CORROSION ON ACB FLOOR TO SIDEWALL SUPPORT AT BS 747+10.5'; RBL 22; WL 151 ; WORK AREA 1.0'X 1.0' X 0.013' ; REMAINING THICKNESS IS 0.027 ; ORIGINAL THICKNESS IS 0.040; FOUND TO
Back to JASC 5320