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 AALA2020070869027Splice · damagedAIRCRAFT IN BASE MAINTENANCE: PREVIOUS REPAIR ON THE RIGHT HAND AFT DOOR CUT OUT LOWER SILL WAS REMOVED AND A NEW SILL WAS INSTALLED. AS PART OF THE SILL REPLACEMENT THE UPPER OUTBOARD SPLICE WAS REPLACED AT FR 66 AND S23R PER SRM 51-72-11.SDR SWAA2021062495779Scuff Plate · crackedFWD CARGO DOOR AFT SCUFF PLATE CRACKED. / LOCATED AND DRILLED NEW FWD CARGO DOOR AFT SCUFFPLATE AS PER B-737 SRM 51-40-05-0G-0SDR SWAA2021062496047Scuff Plate · crackedAFT CARGO DOOR CUTOUT AFT CORNER SCUFF PLATE IS CRACKED. [DOT 124-010] / RECEIVED SERVICABLE AFT CARGO AFT SCUFF PLATE INSTALL TO BE ACCOMPLISHED ON CUSTOMER T/C 753-140-00-024SDR SWAA2021062497879Scuff Plate · brokenAFT CARGO DOOR SCUFF PLATE FWD CORNER HAS BROKEN FLANGE / LOCATED AND DRILLED NEW AFT CARGO DOOR SCUFF PLATE FWD CORNER IAW SRM 51-40-05. OK TO INSTALL 88928C 29JUN20 INSP 86 29JUN20. INSTALLED AFT CARGO DOOR SCUFF PLATE FWD CORNER IAW AMM 53-11-02-420-801SDR UIEA2020063011175Web · corrodedU/D STA 620-640 RT OTBD FLOOR WEB WAS FOUND CORRODED. THE CORROSION WAS REMOVED AND THE WEB PROTECTED IAW SRM 51-10-02, AND SRM 51-20-01. CHECKED WITHIN LIMITS IAW SRM 53-00-51, ALLOWABLE DAMAGE, FIG 101.SDR UIEA2020063011176Support · corrodedBODY FAIRING SUPPORT, BS 987.35, BL 0 - RBL 55 HAD SURFACE CORROSIONG. THE SUPPORT CORROSION WAS REMOVED AND PROTECTED IAW SRM 51-10-02, AND SRM 51-20-01. CHECKED WITHIN LIMITS IAW SRM 53-00-71, ALLOWABLE DAMAGE 1, FIG 101.SDR UIEA2020063011177Support · corrodedBODY FAIRING SUPPORT AT BS 880, LBL 60 TO RBL 55 HAD SURFACE CORROSION. THE CORROSION WAS REMOVED AND THE SUPPORT PROTECTED IAW SRM 51-10-02, AND SRM 51-20-01. CHECKED WITHIN LIMITS IAW SRM 53-00-71, ALLOWABLE DAMAGE 1, FIG 101.SDR UIEA2020063011178Support · corrodedBODY FAIRING SUPPORT STA 1040 LBL 7 TO RBL 7 HAD SURFACE CORROSION. THE CORROSION WAS REMOVED AND THE SUPPORT PROTECTED IAW SRM 51-10-02, AND SRM 51-20-01. CHECKED WITHIN LIMITS IAW SRM 53-00-71, ALLOWABLE DAMAGE 1, FIG 101.SDR UIEA2020063011179Support · corrodedBODY FAIRING SUPPORT BS 987.35, BL 0 TO LBL 65 HAD SURFACE CORROSION. THE CORROSION WAS REMOVED AND THE SUPPORT PROTECTED IAW SRM 51-10-02, AND SRM 51-20-01. CHECKED WITHIN LIMITS IAW SRM 53-00-71, ALLOWABLE DAMAGE 1, FIG 101.SDR UIEA2020063011180Support · corrodedBODY FAIRING SUPPORT BS 840, LBL 14 HAD SURFACE CORROSION. THE BODY FAIRING SUPPORT CORROSION WAS REMOVED AND PROTECTED IAW SRM 51-10-02, AND SRM 51-20-01. CHECKED WITHIN LIMITS IAW SRM 53-00-71 ALLOWABLE DAMAGE 1 FIG 101.SDR UIEA2020063011181Support · corrodedBODY FAIRING SUPPORT BS 920, LBL 1, HAD SURFACE CORROSION. THE BODY FAIRING SUPPORT SURFACE CORROSION WAS REMOVED AND PROTECTED IAW SRM 51-10-02, AND SRM 51-20-01. CHECKED WITHIN LIMITS IAW SRM 53-00-71 ALLOWABLE DAMAGE 1 FIG 101.SDR UIEA2020063001182Support · corrodedBODY FAIRING SUPPORT BS 1112.1, LBL 4, HAD SURFACE CORROSION. THE FAIRING SUPPORT CORROSION WAS REMOVED AND PROTECTED IAW SRM 51-10-02, AND SRM 51-20-01. CHECKED WITHIN SRM 53-00-71 ALLOWABLE DAMAGE 1 FIG 101, LIMITS.SDR UIEA2020063051289Support · corrodedLT BS 1480 BODY FAIRING SUPPORT FOUND CORRODED. THE FAIRING SUPPORT WAS REPLACED IAW SRM 51-10-02, AND SRM 51-40-02.SDR UIEA2020063061294Channel · crackedBS 1200, RBL 40-50, RT TENSION TIE FWD CHANNEL FOUND CRACKED AROUND FASTENER. THE TENSION TIE FWD CHANNEL WAS REPAIRED IAW RI-53-00-14084, REV A.SDR UIEA2020063061295Channel · crackedBS 1200, RBL 40 - 50, RT TENSION TIE AFT CHANNEL WAS CRACKED AROUND FASTENER. THE TENSION TIE AFT CHANNEL WAS REPAIRED IAW RI-53-00-14084 REV A.SDR SWAA2020062995727Threshold · corrodedCORROSION FOUND ON THE UPPER FUSELAGE FWD CABIN FLIGHT DECK DOOR THRESHOLD PANEL 211AF, BOTTOM SURFACE, FWD & AFT EDGES.SDR SWAA2021072197136Stiffener · damagedELONGATED HOLE INTERNAL STRUCTURE VERTICAL STIFFENER LOCATED AT BS 907 LH SIDE AT AFT CARGO COMPARTMENT / REPLACED VERTICAL STIFFENER LOC. AT BS 907 LH SIDE AT AFT CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 AND 51-10-02 ITEM 9SDR SWAA2021042995868Gusset · crackedFWD CARGO; STA 500D; STR 19R; STRINGER CLIP GUSSET IS CRACKED IN UPPER RADIUS COMMON TO BULKHEAD SUPPORT ANGLE. / REMOVED CRACKED GUSSET IN FWD CARGO STA 500D STR 19RH AND INSTALLED NEW GUSSET IAW SRM 51-40-02-0G-0 AND DWG 143A7902 REV E. APPLIED CIC IAW SRM 5SDR SWAA2021042995867Gusset · crackedFWD CARGO; STA 500D; STR 19L; STRINGER CLIP GUSSET IS CRACKED IN UPPER RADIUS COMMON TO BULKHEAD SUPPORT ANGLE. / REMOVED CRACKED GUSSET STA 500D STR 19 L/H AND INSTALLED NEW GUSSET ALL IAW SRM 51-40-02-0G-0 AND DWG 143A7902 REVE. APPLIED CIC IAW AMM 51-21-91-SDR SWIA2020081251766Diaphragm · corrodedFWD DRAIN MAST DIAPHRAGM IN THE A BAY BETWEEN F.S. 333 AND 347 COMMON TO STGR 25R IS CORRODED OUT OF LIMITS. REMOVED AND INSTALLED A NEW FWD DRAIN MAST DIAPHRAGM IAW SRM AND DWG.SDR SWIA2020080451598Angle · crackedFS409+128 RH & LH SIDE OF BL0 VERTICAL POST HAS ONE EACH INDICATION .15" LONG BY 80% FSH IN THE UPPER AFTER RADIUS @ WL69. FAILED NDT INSPECTION. (C-CHECK) RO 7/31/2020 REMOVED AND REPLACED FS 409+128 VERTICAL POST AT RH AND LH OF BL0 IAWE CRJ 200 SRM ANSDR SWIA2020080451589Post · crackedFS409+128 RBL18 VERTICAL POST HAS AN INDICATION .13" LONG BY 75% FSH IN THE UPPER AFT RADIUS @ WL69. FAILED NDT INSPECTION. REPAIRED AREA IAW SRM AND REO.SDR SWIA2020072951531Web · corrodedSERVICE DOOR FOURTH FROM FWD PROTECTOR FLOOR WEB FOUND CORRODED. REMOVED AND REPLACED CORRODED SERVICE DOOR FORTH FROM FWD PROTECTOR FLOOR WEB WITH NEW (P/N SH670-32040-4) WITH NEW HARDWARE, IAW DWG AND SRM.SDR SWIA2020072951530Web · corrodedSERVICE DOOR THIRD FROM FWD PROTECTOR FLOOR WEB FOUND CORRODED. REMOVED AND REPLACED CORRODED SERVICE DOOR THIRD FROM FWD PROTECTOR FLOOR WEB WITH NEW (P/N SH670-32040-4) WITH NEW HARDWARE, IAW DWG AND SRM.SDR SWIA2020072951529Web · corrodedSERVICE DOOR SECOND FROM FWD PROTECTOR FLOOR WEB FOUND CORRODED. REMOVED AND REPLACED CORRODED SERVICE DOOR SECOND FROM FWD PROTECTOR FLOOR WEB WITH NEW (P/N SH670-32040-3) WITH NEW HARDWARE, REF DWG# SH670-31950 REV Y AND SRM.SDR SWIA2020072951528Web · corrodedSERVICE DOOR FIRST FROM FWD PROTECTOR FLOOR WEB FOUND CORRODED. REMOVED AND REPLACED CORRODED SERVICE DOOR FIRST FROM FWD PROTECTOR FLOOR WEB WITH NEW (P/N SH670-32040-3) WITH NEW HARDWARE, REF DWG# SH670-31950 REV Y AND CRJ700 SRM 51-42-21-001-001 A01. SEE SDR AALA202007279026Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN SHEAR PLATE BETWEEN FR69 AND FR70 AT STR 23R, MEASURING L= 1.354 IN. REPLACED SHEAR PLATE WITH NEW IAW SRM A321 51-72-11-911-001 AND 51-42-11-801 AND DWG D53474180.SDR AALA2020072329004Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK ON SHEAR PLATE BETWEEN FR69 AND FR70 AT STR23L, MEASURING 1.184 IN. SHEAR PLATE REPLACED IAW SRM A321 51-42-11-801, 51-72-11-911-001 & DWG D53474180.SDR SWAA2020072296012Structure · crackedCRACK INNER CHORD LOCATED BS 294.5, STR 17R IN THE FWD GALLEY AREA. REPLACED THE INNER CHORD IAW SRM 51-10-02, 51-40-02, AND DWG 141A8310, REV.SDR AALA202007189021Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND AFT PASSENGER / CREW DOOR CUT OUT LOWER SILL CENTER SILL SHAPE FITTING BETWEEN FR 66 AND FR 68 AT S23L. REPLACED CENTER SILL SHAPE FITTING PER SRM 51-72-11-911-001.SDR AALA202007149015Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROISON ON AFT CARGO COMPARTMENT TRANSITION PANEL SHIELD BETWEEN BS 767 AND BS 787 AT S25R. REPLACED TRANSITION PANEL SHEILD PER 51-00-05-1.SDR SWAA2021072900443Threshold · crackedFWD CARGO DOOR AFT THRESHOLD CORNER CRACKED. / REMOVED AND REPLACED FWD CARGO DOOR AFT THRESHOLD CORNER PER AMM 53-11-02.SDR AALA202008179006Shear Plate · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF RH SHEAR PLATE BETWEEN FR69 AND FR70, MEASURING L=3.215 IN, W=1.59 IN, D=0.032 IN. REPLACED SHEAR PLATE WITH NEW IAW SRM 53-41-17-01A, SRM 51-72-11-401, AND SRM 51-42-11-001.SDR AALA202008109016Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF R4 DOOR SILL PLATE AFT OF FWD GIRT BAR HOOK AT FR66 AND BL 124.5R, MEASURING L=4.5 IN, W=1.0 IN, D=0.177 IN. REPLACED SILL PLATE WITH NEW IAW AARD 51-00-00-03 AND SRM 51-42-00.SDR AALA202008109015Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF R4 DOOR SILL PLATE BETWEEN FR67 AND FR68 AT BL 124.5R, MEASURING L=4.5 IN, W=1.0 IN, W=0.177 IN. REPLACED SILL PLATE WITH NEW IAW AARD 51-00-00-03 AND SRM 51-42-00.SDR AALA202008109014Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF R4 DOOR SILL PLATE AT FWD GIRT BAR HOOK SUPPORT AT FR66 AND BL 124.5R, MEASURING L=4.5 IN, W=1.0 IN, D=0.177 IN. REPLACED SILL PLATE WITH NEW IAW AARD 51-00-00-03 AND SRM 51-42-00.SDR AALA202008109013Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF R4 DOOR SILL PLATE AT FASTENER HOLES INBD OF FWD GIRT BAR HOOK AT FR66 AND BL 124.5R, MEASURING L=4.5 IN, W=1.0 IN, D=0.177 IN. REPLACED SILL PLATE WITH NEW IAW AARD 51-00-00-03 AND SRM 51-42-04.SDR AALA202008109012Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF R4 DOOR SILL PLATE AT FASTENER HOLES INBD OF AFT GIRT BAR HOOK AT FR68 AND BL 124.5R, MEASURING L=4.5 IN, W=1.0 IN, D=0.177 IN. REPLACED DOOR SILL PLATE WITH NEW IAW AARD 51-00-00-03 AND SRM 51-42-00.SDR AALA2020080429007Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF R1 DOOR THRESHOLD FITTING BETWEEN FR17 AND FR20 AT RBL 74, MEASURING L=1.35 IN, W=0.9 IN, D=0.021 IN. REPLACED THRESHOLD FITTING WITH NEW IAW SRM 51-72-11.SDR AALA2020080429006Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF L1 DOOR THRESHOLD FITTING BETWEEN FR17 AND FR20 AT LBL 74, MEASURING L=1.5 IN, W=0.9 IN, D=0.031 IN. REPLACED THRESHOLD FITTING WITH NEW IAW SRM 51-72-11.SDR SWIA2020080451586Channel · chafedCARGO DOOR SURROUND STRUCTURE FWD UPPER WEB CHANNEL AT FS 574 IS CHAFED APPROX. .750" IN LENGTH, .062" IN WIDTH, AND .030" IN DEPTH. (C-CHECK) RO 7/31/2020 REMOVED AND REPLACED CARGO DOOR SURROUND STRUCTURE UPPER WEB CHANNEL IAW SRM.SDR SWIA2020080451585Channel · crackedCARGO DOOR SURROUND STRUCTURE, FWD/LWR C-CHANNEL IS CRACKED 1" IN LENGTH. REMOVED DAMAGED CARGO DOOR SURROUND STRUCTURE FWD/LWR C-CHANNEL, LOCATED AND DRILLED NEW C-CHANNEL, AND INSTALLED IAW CRJ200 SRMSDR AALA202007099016Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR INTERCOSTAL / BREAK ASSEMBLY PANEL AT BS 530 AND RBL 2. REPLACED INTERCOSTAL / BREAK ASSEMBLY PANEL PER SRM 51-40-02.SDR AALA2020071099015Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR INTERCOSTAL / BREAK ASSEMBLY PANEL AT BS 530 AND LBL 2. REPLACED IINTERCOSTAL / BREAK ASSEMBLY PANEL PER SRM 51-40-02.SDR AALA2020070869028Splice · damagedAIRCRAFT IN BASE MAINTENANCE: PREVIOUS REPAIR ON THE LEFT HAND AFT DOOR CUT OUT LOWER SILL WAS REMOVED AND A NEW SILL WAS INSTALLED. AS PART OF THE SILL REPLACEMENT THE UPPER OUTBOARD SPLICE WAS REPLACED AT FR 66 AND S23L PER SRM 51-72-11.SDR AALA2020070869026Splice · damagedAIRCRAFT IN BASE MAINTENANCE: PREVIOUS REPAIR ON THE RIGHT HAND AFT DOOR CUT OUT LOWER SILL WAS REMOVED AND A NEW SILL WAS INSTALLED. AS PART OF THE SILL REPLACEMENT THE UPPER INBOARD SPLICE WAS REPLACED AT FR 66 AND S23R PER SRM 51-72-11.SDR AALA2020070549007Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR INTERCOSTAL BETWEEN BS 344 AND BS 360 AT LBL 11. REPLACED INTERCOSTAL PER 51-00-05-1.SDR AALA202006309002Fitting · wornAIRCRAFT IN BASE MAINTENANCE: LEFT HAND AFT PASSENGER DOOR CUT OUT LOWER SILL AFT CORNER FITTING WORN AT FR 68 AND S23L. REPLACED CORNER FITTING PER SRM 51-72-11-911-001.SDR KCSA202006261097Reveal · crackedL5 DOOR REVEAL IS CRACKED AT STA 2231 JUST ABOVE S-17 L APPROX. 1.5" LONGSDR SWAA2021081395980Support Angle · crackedCRACK ANGLE - SUPPORT LOCATED AT BS 294.5 AND STR17R AT FWD GALLEY AREA / REPLACED ANGLE-SUPPORT LOCATED AT BS 294.5 AND STR 17R AT FWD GALLEY AREA IAW SRM B737-700 51-10-02 ITEM 9; 51-40-02 AND DWG #141A8310 REV D.
Back to JASC 5320