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 SWAA2022110150963Plate · corrodedCORROSION ON PLATE LOCATED BTW BS 1006 TO BS 1016 RBL 3 WL 208.1 AFT GALLEY AREA 2022-517137 / [01] TOOL USED: ULTRASONIC GAGE: P/N: 45MG; S/N: 130060401; DUE DATE: 26-JAN-23;[02] REPLACED PLATE AND FASTENERS LOCATED BETWEEN BS1006 TO BS1030 AFT PRESSURE BULKHSDR SWAA2022110150951Web · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE BS 294.5 TO BS 312 RBL 40 AT FWD GALLEY AREA 2022-517124 / [01] REPLACED NEW WEB-INTERCOSTAL AND FASTENERS ON FLOOR STRUCTURE BS 294.5 TO BS 312 RBL 40 AT FWD GALLEY AREA. I.A.W B737-700 SEM 51-10-02 SRM 51-40-02; DWG 14SDR SWAA2022110150945Web · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE BS 294.5 TO BS 312 RBL 16 AT FWD GALLEY AREA 2022-517125 / [01] REPLACED NEW WEB - INTERCOSTAL AND FASTENERS FLOOR STRUCTURE BS 294.5 TO BS 312 RBL 16 AT FWD GALLEY AREA IAW B737-700 SRM 51-10-02 SRM 51-40-02 AND DRAWINGSDR SWAA2022110150955Web · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE BS 344 TO BS 360 BL 0 AT FWD GALLEY AREA 2022-517129 / [01] REPLACED INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN BS 344 TAND BS 360 AT BL 0 FWD GALLEY AREA IAW B737-700 SRM 51-10-02; SRM 51-40-02 AND DWG 141A5400 SH 32 RSDR SWAA2022110150952Web · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE BS 344 TO BS 360 LBL 12 AT FWD GALLEY AREA 2022-517130 / [01] REPLACED NEW WEB - INTERCOSTAL AND FASTENERS FLOOR STRUCTURE BS 294.5 TO BS 312 RBL 16 AT FWD GALLEY AREA IAW B737-700 SRM 51-10-02 PARAGRAPH 9; SRM 51-40-02 SDR SWAA2022110150957Web · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE BS 312 TO BS 328 LBL 45 AT FWD GALLEY AREA 2022-517132 / [01] REPLACED WEB INTERCOSTAL ON FLOOR STRUCTURE LOCATED BETWEEN BS 312 AND BS 328 AT LBL 45 FWD GALLEY AREA IAW B737-700 SRM 51-10-02 PARAGRAPH 9; SRM 51-40-02 ANSDR SWAA2022110150958Web · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE BS 328 TO BS 344 LBL 45 AT FWD GALLEY AREA 2022-517133 / [01] REPLACED FASTENERS AND WEB - INTERCOSTAL FLOOR STRUCTURE BS 328 TO BS 344 LBL 45 AT FWD GALLEY AREA IAW B737-700 SRM 51-10-02 Ï¿½TEM 9 ; B737-700 SRM 51-40-02SDR SWAA2022110150953Angle · crackedCRACK ANGLE - SUPPORT LOCATED BTW BS 907 TO BS 927 AT LEVEL RBL 45.57 CEILING AREA AT AFT CARGO COMPARTMENT 2022-517134 / [01] REPLACED ANGLE - SUPPORT LOCATED BTW BS 907 TO BS 927 AT LEVEL RBL 45.57 CEILING AREA AT AFT CARGO COMPARTMENT IAW B737-700 SRM 51-10SDR SWAA2022110150965Structure · crackedCRACK INNER CHORD BS 303.9 LT SIDE AT FWD GALLEY AREA 2022-517141 / [01] REPLACED INNER CHORD AND FASTENERS LOC. BTW BS 277 TO BS 360 LT SIDE FWD GALLEY AREA IAW B737-700 SRM 51-10-02 PARAGRAPH 9; SRM 51-40-02 AND DRAWING 141A8110 REV 'A' AND DRAWING 140A9810 SDR SWAA2022110150950Intercostal · crackedCRACK INTERCOSTAL - WEB FLOOR STRUCTURE BS 270 TO BS 294.5 BL 0 AT FWD GALLEY AREA 2022-517122 / [01] REPLACED WEB INTERCOSTAL ON FLOOR STRUCTURE LOCATED BETWEEN BS 270 AND BS 294.5 AT BL 0 FWD GALLEY AREA IAW B737-700 SRM 51-10-02 PARAGRAPH 9; SRM 51-40-02 ANSDR SWAA2022102556965Fastener · looseMAIN CABIN SEAT TRACK LBL45.50 STA 727B FASTENER B LOOSE / [01] PERFORMED A HIGH FREQUENCY EDDY CURRENT (HFEC) HOLE PROBE INSPECTION OF THE COUNTERSINK COMMON TO THE REMOVED FASTENER POSITION PER 737 NDT PART 6; 53-30-00; PROCEDURE 3. NO CRACKS. TOOL USED OLYMSDR SWAA2022101851221Scuff Plate · crackedAFT CARGO AFT CORNER SCUFF PLATE CRACKED / [01] RECEIVED SCUFF PLATE PART # 146A8341-9 FROM JL WELDING TAG #011178 LOCATED AND DRILLED AS PER B 737-700 SRM 51-40-05-0G-0 SCUFF PLATE TO BE INSTALLED ON ITEM #TTG8Q00F4DRW;[02] [FINAL] VALIDATED STEP 1SDR AALA202210175018Splice · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON SPLICE UPPER INBOARD POSITION AT FR 66 AND S23L. REPLACED SPLICE PER SRM 51-72-11.SDR AALA202210176369Splice · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON SPLICE UPPER OUTBOARD POSITION AT FR 66 AND S23L. REPLACED SPLICE PER SRM 51-72-11.SDR REXA2022100502190None · corrodedAFT CARGO DOOR SILL IS CORRODED REMOVED AND REPLACED CARGO DOOR LOWER SILL.SDR REXA2022100502189Seat Track · corrodedLBL 9 FLOOR SEAT TRACK IS CORRODED BETWEEN F.S. 847+48 TO F.S. 985. FABRICATED AND INSTALLED SEAT TRACK AT LBL 9 F.S 847+48 TO F.S. 985. IAW CRJ 900 AMM 53-00-49-400-801-A07SDR 2VKA202210050001Support · crackedCRACK FOUND IN VERTICAL TUNNEL WEB @ RBL 4.0 STA 87.5 WL 67.92.SDR REXA2022100402187Stringer · corrodedCORROSION FOUND ON STGR 26R BETWEEN FS 1015-1031. REPAIRED IAW ENDEAVOR EA CRJ953-14232 REV. A DATED 8/8/2022.SDR REXA2022100402186Stringer · corrodedCORROSION FOUND ON STGR 26R BETWEEN FS 1051.30-1069.75 REPAIRED IAW ENDEAVOR EA CRJ953-14233 REV. A DATED 8/8/2022.SDR REXA2022100402185Stringer · corrodedCORROSION FOUND ON STRINGER 23R BETWEEN F.S. 333.00 TO F.S. 379.00. REMOVED AND REPLACED IAW CRJ 900 SRMS 51-40-11-001-001-A01, 51-42-06-001-001-A01, 51-42-21-001-001-A01.SDR REXA2022100402184Stringer · corrodedCORROSION FOUND ON STRINGER 23R BETWEEN F.S. 280.00 TO F.S. 333.00. REMOVED AND REPLACED IAW CRJ 900 SRMS 51-40-11-001-001-A01, 51-42-06-001-001-A01, 51-42-21-001-001-A01.SDR REXA2022100402183Splice · corrodedCORROSION FOUND ON SPLICE AT 23R AT F.S. 333. REMOVED AND REPLACED IAW CRJ 900 SRMS 51-40-11-001-001-A01, 51-42-06-001-001-A01, 51-42-21-001-001-A01.SDR REXA2022100402182Angle · corrodedL/H FLOOR SILL ANGLE IS CORRODED BETWEEN F.S.720 TO F.S.847. REPAIRED IAW ENDEAVOR EA CRJ953-14337 REV IR DATED 8/10/22.SDR REXA2022100402181None · corrodedRH SIDE SEAT RAIL BETWEEN FS 469-483 HAS MULTIPLE SPOTS OF CORROSION. REMOVED AND REPLACED IAW CRJ 900 SRM 53-00-49-201-002-A01 AND CRJ 900 AMM 53-00-49-400-801-A07.SDR REXA2022100402180Stringer · corrodedSTRINGER 24L IS CORRODED BETWEEN FS 501.00 AND 517.00. REMOVED AND REPLACED IAW CRJ 900 SRMS 51-40-11-001-001-A01 AND 51-42-06-001-001-A01.SDR REXA2022100402179Frame · corrodedFRAME IS CORRODED AT FS 485.00 BETWEEN STGR 24L AND 26R. REPAIRED IAW ENDEAVOR EA CRJ953-14201 ISSUE DATE 8/3/2022 REV IRSDR LR7A2022093003210Angle · crackedDURING N409LC NOSE WHEEL WELL STRUCTURAL REPAIR, FOUND FS196 BULKHEAD ANGLE CRACKED AT LBL73, WL185. / REPAIRED IAW LOCKHEED SMP583 SRM, FIGURE 51-140-23. NR#0035 / PSE# 53-30-11, AD 2012-06-09SDR SWAA2022100352130Support Angle · crackedFWD NOSE COMPT WEATHER RADAR UNIT VERTICAL AND HORIZONTAL SUPPORT ANGLES CRACKED 2022-488961 / [01] REPLACED DRIP SHIELD AND SUPPORT ANGLE LOC. FWD NOSE COMPT WEATHER RADAR UNIT VERTICAL AND HORIZONTAL SUPPORT IAW B737-700 SRM-51-10-02 Ï¿½TEM 9 AND SRM-51-40-0SDR SWAA2022100350924None · crackedFWD NOSE COMPT WEATHER RADAR UNIT VERTICAL AND HORIZONTAL SUPPORT ANGLES CRACKED 2022-488961 / [01] REPLACED DRIP SHIELD AND SUPPORT ANGLE LOC. FWD NOSE COMPT WEATHER RADAR UNIT VERTICAL AND HORIZONTAL SUPPORT IAW B737-700 SRM-51-10-02 Ï¿½TEM 9 AND SRM-51-40-0SDR FDEA202209302420Shear Web · corrodedMAIN CABIN, AFT FLOOR, SHEAR WEB HAS SEVERAL, AREAS OF CORROSION, STA 1681 TO 1720, LBL 56 TO RBL 56 REPAIRED THE AFT MAIN CABIN SHEAR WEB (DECK PLATE), STA 1681 TO 1720, LBL 56 TO RBL 56, IAW FEDEX E.A. F-5310-T0370865-P1, RELEASE DATE: 29 SEPTEMBER, 2022SDR FDEA202209302411Stiffener · crackedEMPENNAGE TAILCONE BULKHEAD STATION 2164 MOST LOWER STIFFENER FOUND CRACKS. TAILCONE BULKHEAD STATION 2164 MOST LOWER CRACKED STIFFENER REMOVED AND REPLACED AS PER SRM 51-33-01-OG. STIFFENER REWORKED AS PER DOUGLAS DRAWING AJC7001 REVISION DT. REPAIR CLASSDR IXXA2022093010001Intercostal · corrodedFLC INTERCOSTAL CORRODEDSDR SWAA2022110946509Support · corrodedFWD CARGO COMPARTMENT L/H FLOOR TO SIDEWALL SUPPORT IS CORRODED FROM STA 440 TO STA 500D; WL 156.5; LBL 22 TO 24. / ;FOUND PART TO BE OUT LIMITS;IAW SRM 53-00-53-1A-2 ALLOWABLE DAMAGE 2 AND SRM 53-30-53-0I-2 IDENTIFICATION 2;TOOL USED ID ATS2678;S/N UNKNOWN;DUSDR SWAA2022110946510Support · corrodedCORROSION ON FWD CARGO COMPARTMENT FLOOR TO SIDEWALL SUPPORT FROM STA 500A TO 500C+8; RBL 24; WL 156.5 / [01] REMOVED CORROSION ON FWD CARGO COMPARTMENT FLOOR TO SIDEWALL SUPPORT BETWEEN STA 500B+13' RBL 24; WL 156.5 MEASURE MAX.MATERIAL LOSS L=1.7' X W=.6' D=SDR SWAA2022110146795Angle · crackedCRACK ANGLE PASSENGER CABIN LOC BS 380 BTW BS 400 BL 0 2022-517016 / [01] REPLACED NEW ANGLE AND FASTENERS PASSENGER CABIN LOC. BS 380 BTW BS 400 BL 0 IAW B737-700 SRM 51-10-02; SRM 51-40-02 AND DRAWING 143A5400 SHEET: 66 REV: -. SEE INDIVIDUAL SIGN OFFS BELOWSDR SWAA2022102849266Gusset · crackedCRACK GUSSET LOCATED STA 500D AND STR 19L FWD CARGO COMPARTMENT 2022-517050 / [01] REPLACED GUSSET LOCATED STA 500D AND STR 19L FWD CARGO COMPARTMENT I.A.W B737-700 SRM 51-10-02; SRM 51-40-02 AND DWG# 143A7902 SHEET:174 REV: -. SEE INDIVIDUAL SIGN OFF BELOW.;[SDR SWAA2022102849271Gusset · crackedCRACK GUSSET LOCATED STA 500D AND STR 19R FWD CARGO COMPARTMENT 2022-517051 / [01] REPLACED GUSSET LOCATED STA 500D AND STR 19R FWD CARGO COMPARTMENT IAW B737-700 SRM 51-10-02 ITEM 9 AND DWG 143A7902 SHEET 174 REV-. SEE INDIVIDUAL SIGN OFFS BELOW.;[02] REPLACESDR IPXA2022102087315Web · corrodedINSPECTION TYPE:3CCENTER CARGO BLIGE AREA HAS A CLIP, VERTICAL INTERCOSTAL-WEB AT STA 1730 RBL5 WITH CORROSION.REPLACED THE CLIP, INTERCOSTAL-WEB IAW SRM 51-31-01. (MINOR)SDR IPXA2022102087314Tee Fitting · corrodedINSPECTION TYPE:3CCENTER CARGO BLIGE AT STA 1745 RBL5 HAS A TEE-CLIP WITH CORROSION.REPLACED TEE-CLIP AT STA 1745 RBL5 IAW SRM-51-31-01. (MINOR)SDR SWAA2022101749304Shield · corrodedAFT CARGO BAY FLOOR FWD SHIELD HAS AREAS OF CORROSION STA 767 TO 787 WL 157. / [01] ENTERED MEASUREMENTS.;[02] B737-700 SRM 53-00-53-1A-2 IS APPLICABLE FOR THIS EVALUATION.<BR>NO ALLOWABLE DAMAGE GIVEN IN SRM 53-00-53-1A-2 FOR THIS PART.<BR>REPAIR BY REPLACEMESDR SWAA2022101749294Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT HAS CORROSION STA 727 +7; +9.5 AND +14 TO 727A RBL 23 TO 25; WL 157. / [01] REMOVED CORROSION ON AFT CARGO BAY R/H FLOOR TO SIDEWALL SUPPORT BS 727+7' IN L=2' X W=2' X D=0.010' FROM ORIGINAL TICKNESS OF 0.040' FOUND TO BSDR SWAA2022101749295Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT HAS CORROSION AT STA 727A +6; +14 TO 727B RBL 23 TO 25 WL 157. / [01] REMOVED CORROSION ON AFT CARGO BAY R/H FLOOR TO SIDEWALL SUPPORT BS 727A+6' IN L=2' X W=2' X D=0.006' FROM ORIGINAL TICKNESS OF 0.040' FOUND TO BE OUTSDR SWAA2022101749296Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT HAS CORROSION AT STA 727B +6;+14.5 TO 727C RBL 23 TO 25; WL 157. / [01] REMOVED CORROSION ON AFT CARGO BAY R/H FLOOR TO SIDEWALL SUPPORT BS 727B+6' IN L=2' X W=2' X D=0.0010' FROM ORIGINAL TICKNESS OF 0.040' FOUND TO BE SDR SWAA2022101749305Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT HAS CORROSION AT STA 727C +2;+6;+10;+14;+15;+18 TO 727D RBL 23 TO 25; WL157. / [01] REMOVED CORROSION ON AFT CARGO BAY R/H FLOOR TO SIDEWALL SUPPORT BS 727C+2' IN L=2' X W=2' X D=0.007' FROM ORIGINAL TICKNESS OF 0.040' FSDR SWAA2022101749297Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT HAS CORROSION AT STA 727D +3;+5;+8;+10.5;+3;+15;+18 TO 727E; RBL 23 TO 25; WL 157. / [01] REMOVED CORROSION ON AFT CARGO BAY R/H FLOOR TO SIDEWALL SUPPORT BS 727D+3' IN L=2' X W=2' X D=0.007' FROM ORIGINAL TICKNESS OF 0.SDR SWAA2022101749306Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT HAS CORROSION AT STA 727E 2;+6;+10;+14;+18 TO STA 747;RBL 23 TO 25; WL157. / [01] REMOVED CORROSION ON AFT CARGO BAY R/H FLOOR TO SIDEWALL SUPPORT BS 727E+2' IN L=2' X W=2' X D=0.007' FROM ORIGINAL TICKNESS OF 0.040' FOUSDR SWAA2022101749307Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT HAS CORROSION AT STA 747 +2;+6;+8.5;+10;+14;+15.5;+18; RBL 23 TO 25; WL 157. / [01] REMOVED CORROSION ON AFT CARGO BAY R/H FLOOR TO SIDEWALL SUPPORT BS 747+2' IN L=2' X W=2' X D=0.007' FROM ORIGINAL TICKNESS OF 0.040' FOSDR SWAA2022101749298Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT HAS CORROSION AT STA 727A +3 ; LBL 23 TO 25; WL 157. / [01] ENTERED MEASUREMENTS;[02] B737-700 SRM 53-00-53-1A-2 IS APPLICABLE FOR THIS EVALUATION.<BR>REMOVED CORROSION DAMAGE IAW SRM 51-10-02-0G-0.<BR><BR>AREAS OF CORROSDR SWAA2022101749308Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT HAS CORROSION AT STA 727B +18.5; LBL 23 TO 25; WL 157. / [01] ENTERED MEASUREMENTS.;[02] B737-700 SRM 53-00-53-1A-2 IS APPLICABLE FOR THIS EVALUATION.<BR>REMOVED CORROSION DAMAGE IAW SRM 51-10-02-0G-0.<BR><BR>AREAS OF COSDR SWAA2022101749299Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT HAS CORROSION AT STA 727D +5;+8;+14;+16 TO 727E; LBL 23 TO 25;WL 157. / [01] ENTERED MEASUREMENTS;[02] B737-700 SRM 53-00-53-1A-2 IS APPLICABLE FOR THIS EVALUATION.<BR>REMOVED CORROSION DAMAGE IAW SRM 51-10-02-0G-0.<BR><
Back to JASC 5320