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 ABXA2021219022Floor Support · corrodedDURING C-CHECK AMES TAMPA FACILITY, FWD CARGO FLOOR DECK SUPPORT ANGLE UNDER FLOOR WEB AT I/B SIDE OF POWER DRIVE 6R CORRODED. REMOVED INTERCOSTAL. FOUND ORIG MAT .100", MAT LOSS .018", MAT REMAINING .082". AREA FOUND TO BE OUT OF LIMIT. LOCATED AND DRILLED NESDR SWAA2021032650003Bracket · corrodedCORROSION L-1 DOOR BS 312 LBL-57 FLOOR MOUNTED ESCAPE SLIDE BRAKET;ADAPTER PLATE SUPPORT FITTING CORRODED MKD 126-032. / REMOVED AND REPLACED GIRT BAR FITTING BRACKET AT L1 DOOR STA 312 LBL 57 REF B737-700 SRM 51-40-02-0G-0SDR SWIA202157068Intercostal · corrodedINTERCOSTAL AT STGR 26L BETWEEN FS349.00 AND FS364.00 HAS CORROSION (C-CHECK) RO 3/25/2021 EVAL CORROSION IS WITHIN 2D RADIUS OF FASTENERS MAKING IT OUT OF LIMITS. REMOVED AND INSTALLED NEW INTERCOSTAL ON STRINGER 26L BETWEEN F.S. 349.00 AND F.S. 365.00SDR SWAA2021031651603Web · corrodedCORROSION ON RT OVERWING EMERGENCY EXIT LOWER SILL BS619 - BS636 RBL71 WL222. MARKED / REMOVED CORROSION ON RT OVERWING EMERGENCY EXIT LOWER SILL BS.619-BS.636 RBL 71 WL 222; FOUND TO BE OUT OF LIMITS DUE TO LOCATION OF BLEND WITHIN 1' OF DRAIN HOLE ON LWR SILSDR REXA2021030900114Angle · corrodedPASSENGER DOOR LOWER SILL ANGLE IS CORRODED. REMOVED & INSTALLED SERVICEABLE PAX DOOR LOWER SILL IAW CRJ 900 SRM 51-42-21-001-001-A01, 51-42-06-001-001-A01, AND 51-40-21-001-001-A01. WVAC EMP# 603145SDR REXA2021030900084Door Sill · corrodedAFT CARGO DOOR SILL IS CORRODED. REPLACED AFT CARGO DOOR SILL IAW SRM 51-42-06-001-001-A01, 51-42-13-001-001-A01, 51-42-21-001-001-A01. WVAC EMP# 6027SDR MASA20210308073Web · corrodedDURING FS 280 LH BEAM REMOVAL, CORROSION ON LH LOWER WEB WAS FOUND|LH LOWER WEB WAS REPAIRED PER CRJ900 SRM 53-11-10-201-004-A01SDR MASA20210308072Angle · mismanufacturedINADEQUATE HOLES ON LH CAP ANGLE WAS FOUND|CAN ANGLE WAS REPLACED PER CRJ900 SRM 51-42-10-001-001-A01 AND SRM 51-42-06-001-001-A01SDR DALA2021022201011Floor Support · corrodedDURING INITIAL INSPECTION MAINTENANCE FOUND CORROSION LEVEL 2 ON FLOOR SUPPORT BTW STA 1640 TO 1681 LBL 52 APPROX AND REPLACED. (LP 1734524)SDR CALA2021022200195Fitting · corrodedAFT CARGO SUPPORT FITTING AT FR 56RH UNDERNEATH TORSION BOX COVER HAS CORROSION.(SUPPORT TASK). AT HAECO LCQ PER NR 9290725( 42725). REMOVED AND REPLACED FITTING AT FR 56 RH IAW A319 SRM 51-72-11- 911-001.SDR CALA2021022200194Fitting · mismanufacturedSUPPORT FITTING UNDERNEATH TORSION BOX COVER AT FR 57RH HAS DOUBLE DRILLED HOLE, (SUPPORT TASK). GENERATED AT HAECO LCQ PER NR 9290704 (42704). REMOVED AND REPLACED FITTING AT FR 57 RT IAW A319 SRM 51-72-11- 911-001.SDR JGVR20210219001Floor Support · corrodedMECHANICALLY BLENDED SEVEN AREAS OF CORROSION IN CABIN DROP AISLE FLOOR CONSISTING OF TWO AREAS ON LT FWD ANGLE APPROXIMATELY 3.5 AND 8 INCHES AFT OF FWD END OF DROP AISLE, RAISED DOUBLER/FLOOR BOARD SUPPORT WITH TWO AREAS ON THE FWD LT SIDE AND THREE ON FWD RSDR SWIA202157843Intercostal · corrodedINTERCOSTAL BETWEEN F.S.364 TO F.S.349 AT STRINGER 27 L IS CORRODED. (C-CHECK RO 4/25/2021) FOUND CORROSION TO OUT OF LIMITS, REMOVED AND REPLACED INTERCOSTAL, IAW CRJ 200 SRM 51-42-06, 51-40-11, 53-00-00, 53-21-17. / NO DEFECTS NOTED BY MXSDR SWIA202157418Support · corrodedSTGR21L BACK-UP SILL HAS CORROSION FROM FS333.00 TO FS349.00. (C-CHECK RO 4/4/2021) REMOVED AND REPLACED CORRODED BACK-UP SILL WITH NEW REPLACEMENT SILL (P/N SH670-31823-1) ONTO STGR21L BETWEEN FS333.00 AND FS349.00 WITH ALL NEW HARDWARE, REF BOMBARDIER DSDR SWIA202157417Support · corrodedSTGR21L BACK-UP SILL HAS CORROSION FROM FS310.00 TO FS333.00. (C-CHECK RO 4/4/2021) REMOVED AND REPLACED CORRODED BACK-UP SILL WITH NEW REPLACEMENT SILL (P/N SH670-31822-1) ONTO STGR21L BETWEEN FS310.00 AND FS333.00 WITH ALL NEW HARDWARE, REF BOMBARDIER DSDR SWAA2021032649820Shield · corrodedCORROSION>>>>>>>> FWD CARGO COMP SIDEWALL PANEL SUPPORT SHIELD R/H SIDE; BETWEEN BS 500A TO BS 490.RBL 22 MKD 126-024. / REMOVED AND REPLACED NEW SUPPORT SHIELD R/H SIDE. BETWEEN BS 500A TO BS 490 AS PER B737 SRM 51-40-02-0G-0 AND DWG 143A0080SDR SWAA2021032449815Door Sill · crackedL1 DOOR LOWER SILL INNER CHORD CRACKED AT FASTENER HOLE FRAME STA 312 / REMOVED AND REPLACED L1 DOOR LOWER SILL INNER CHORD BETWEEN STA 270 & STA 360 WL 208 REF B737-700 SRM 51-40-02-0G-0 & DWG #141A8110SDR SWAA2021032449816Angle · crackedFWD CARGO COMP GUSSET ANGLE CRACKED BETWEEN BS 500D AND STGR 19-R MKD 126-021 / REMOVED & REPLACED NEW GUSSET AT FWD CARGO COMP. BETWEEN BS 500D AND STGR NO 19R IAW B-737-700 SRM # 51-40-02-0G-0 & DWG # 143A9481SDR SWAA2021032449817Gusset · crackedFWD CARGO COMP GUSSET ANGLE CRACKED BETWEEN BS 500D AND STGR 19-L.MKD 126-022. / REMOVED & REPLACED GUSSET ANGLE AT FWD CARGO COMP. BETWEEN BS 500D AND STRG. 19L IAW B-737-700 SRM #51-40-02-0G-0 & DWG NO 143A7902SDR SWAA2021031549798Support · corrodedFWD CARGO FLOOR SUPPORT AT STRINGER 25R 500-TO 500A IS CORRODED. / REMOVED CORROSION AT FWD CARGO FLOOR SUPPORT STA 500-500A STR 25R REF B737-700 SRM 51-10-02-0G-0; FOUND TO BE OUT OF LIMITS REF B737-700 SRM 53-00-53-1A-1; REMOVED AND REPLACED FLOOR SUPPORT RESDR SWAA2021031549799Support Channel · corrodedFWD CARGO FLOOR SUPPORT 'Z' CHANEL AT STRINGER 25 RIGHT FROM 500A TO 500D IS CORRODED; WL 154. REMOVED AND REPLACED SIDE PLATE ('Z' CHANNEL) OF FWD CARGO STR 25R FROM STA 500A TO 500D IN REFERENCE SRM 5140020G0 AND DOCUMENT NUMBER 143A7500SDR SWAA2021031549804Support · corrodedFWD CARGO FLOOR SUPPORT AT 420-440 STRINGER 25 RIGHT IS CORRODED. / REMOVED AND REPLACED FLOOR SUPPORT AT FWD CARGO STA 420 TO STA 440 AND STR 25 RIGHT IN REFERENCE SRM 51-40-02-0G-0 AND DOCUMENT NUMBER 143A8126.SDR SWAA2021031549878Support Channel · corrodedAFT CARGO FLOOR SUPPORT AT 25R 'Z' CHANNEL IS CORRODED AT 727C TO 767. REMOVED AND REPLACED 'Z' CHANNEL FOR AFT CARGO COMPARTMENT FROM STA 727 STA 767 AS PER B737 SRM 514002060 AND DWG REF 146A 7502 VERIFIED SQUEEZED OUT AND 100% FASTENER INSTALLATION AS PER BSDR SWAA2021031549882Support Strap · corrodedAFT CARGO FLOOR SUPPORT AT BS 887 25L-25R IS CORRODED. WL 168 / REMOVED AND REPLACED FLOOR SUPPORT STRAP FOR AFT CARGO STA BS 887 25L-25R AS PER 51-40-02-0G-0 AND DWG REF 146A7500SDR SWAA2021031549884Support Angle · bentAFT CARGO BS 727 LOWER SUPPORT ANGLE FOR SIDE WALL PANEL IS BENT P/N 453A2611-26; / RECEIVED NEW ANGLE FOR AFT CARGO LOWER SUPPORT SIDEWALL PANEL REPLACEMENT. PART TO BE INSTALLED UPON CLOSE UP OF AFT CARGO COMPARTMENT REF JPANEL-141-CLOSE 2017037-1000-0076SDR SWAA2021030849880Channel · corrodedAFT CARGO LEFT SIDE FLOOR SUPPORT STRINGER 25L 'Z' CHANNEL FROM 727B TO 847 IS CORRODED. REMOVED AND REPLACED AFT CARGO FLOOR SUPPORT 'Z' CHANNEL FROM BS 727B TO 847. LBL 21 AS PER B737-7 SRM 51-40-02-0G-0 AND DWG REF 142A7502 ACCOMPLISHED SPLICE REPAIR BETWEESDR SWAA2021030849881Support · corrodedAFT CARGO FLOOR SUPPORT AT 727D+6 IS CORRODED AT 25L TO 25R_WL 155.5 / CLEANED AND EVALUATED CORROSION FOR FLOOR SUPPORT STRAP AT BS 727D+6' AS PER B737-7 SRM 51-10-02-0G-0. CORROSION FOUND TO BE OUT OF LIMITS AS PER B737-7 SRM 53-00-53-1A-2 FIG D. RECEIVED NESDR SWAA2021030849877Floor Support · corrodedAFT CARGO FLOOR SUPPORT AT BS 767+5 FROM 25L TO 25R IS CORRODED. CLEANED AND EVALUATED CORROSION FOR FLOOR SUPPORT STRAP AS BS 767+5 AS PER B737-7 SRM 51-10-02-0G-0. CORROSION FOUND TO BE OUT OF SERVICEABLE LIMITS AS PER B737-7 SRM 53-00-53-IA-2 FIG D. RECEIVESDR SWAA2021030849874Channel · corrodedFWD CARGO FLOOR SUPPORT 'Z' CHANNEL STRINGER 25L FROM 420 TO500D HAS AREAS OF LIGHT CORROSION MISSING PRIMER PAINT REMOVED AND INSTALLED NEW 'Z' CHANNEL (SIDE PLATE) AT STR25L FROM STA 396 TO STA 500D IN REF. SRM 51-40-02-0G-0 AND DOCUMENT NUMBER 143A7501.SDR SWAA2021030849876Support · corrodedAFT CARGO FLOOR SUPPORT AT 767-787 STRINGER 25R IS CORRODED / CLEAN CORROSION AT AFT CARGO FLOOR SUPPORT AT STA 767-787-25R AS PER B737-700 SRM 51-10-02-0G-0; PERFORM NDT ON REWORKED AREA AND MIN MAT THICKNESS WS 0.040' MAT REMOVED 0.010' FOUND OUT OF LIMITS ASDR FDEA202102180403Crease Beam · corrodedMAIN CABIN R/H FLOOR MOP SILL / CREASE WEB ANGLE HAS AREAS OF CORROSION ON UPPER SURFACE BETWEEN BS 1320 AND BS 1360. REMOVED CORROSION AT MAIN CABIN R/H CREASE WEB ANGLE "CHORD" ON UPPER SURFACE BETWEEN BS 1320 - 1360 IAW B 757 SRM 51-10-02-OG.EVALUATED ASDR AALA202103029925Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT LEFT HAND PASSENGER / CREW DOOR CUT OUT LOWER SILL AT FR 68 AND S23L. REPAIRED LOWER SILL PER SRM 53-41-14-300-001 REPAIR PRINCIPLE 5 FIGURE 001 SHEET 3.SDR SIMA20210218003Door Sill · corrodedCPCP SSI ITEM. FWD SERVICE DOOR SILL IS CORRODED FROM FR 18 TO FR 20 AT THE FLOOR LEVEL. (LEVEL 1 CORROSION)-C/A-INSTALLED NEW FWD SERVICE DOOR SILL IAW SRM 51-40-02.SDR UIEA2021021700340Ceiling Panel · damagedL1 DOOR POSSIBLE OUT OF RIG. FOUND CEILING PANEL DAMAGED AT CREW ENTRY DOOR, SEE NR 34 FOR CORRECTIVE ACTIONS. PERFORMED CREW ENTRY DOOR CHECK IAW AMM 52-12-00, FOUND NORMAL.SDR DALA2021022201007Plate · corrodedDURING INSPECTION MAINTENANCE FOUND CORROSION LEVEL 2 ON RT SIDE PLATE BTW STA 1380 TO 1200 AT AFT CARGO COMPARTMENT. SIDE PLATE REPLACED. (LP 1733890)SDR DALA2021022201006Floor Support · corrodedDURING INSPECTION MAINTENANCE FOUND CORROSION LEVEL 2 ON STRINGERS LBL 2.90, LBL 7.55, LBL 16.10 AND RBL 2.90, RBL 7.55, RBL 10.45 BTW STA 740 TO 760 OF FWD CARGO COMPARTMENT. STRINGERS REPAIRED PER SRM.SDR DALA2021022201005Intercostal · corrodedDURING INITIAL INSPECTION MAINTENANCE FOUND CORROSION LEVEL 2 ON INTERCOSTAL BTW STA 1600 TO STA 1620 AND S-29L TO S-30 AT AFT CARGO COMPARTMENT. REPLACED INTERCOSTAL PER SRM.SDR DALA2021021800950Strap · corrodedDURING INSPECTION MAINTENANCE FOUND CORROSION LEVEL 2 ON STRAP AT CARGO COMPARTMENT FLOOR PANEL.. FLOOR PANEL REPLACED. (LP 1733231)SDR DU4R2021021800006Stiffener · crackedDURING SCHEDULED INSPECTION AT HAECO LAKE CITY, FLORIDA FOUND STIFFENER AT RBL6.15 AND WL 170.4 HAS A CRACKED HOLE. S/O 660004 N/R 44991.SDR SWAA2021051351688Support · damagedELONGATED HOLE SUPPORT ZEE LOCATED BETWEEN BS 767 AND BS 727 AT LEVEL STR 25R AT AFT CARGO COMPARTMENT / REPLACED SUPPORT ZEE LOCATED BETWWEN BS767 AND BS727 AT LEVER STR 25R AT AFT CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 AND B737-700 DWG #146A 7502 REV A SDR SWAA2021031752809Stiffener · crackedCRACK STIFFENER FLOOR STRUCTURE BS 540 BETWEEN RBBL 24.5 AND RBBL 45 CENTER SECTION / REPLACED STIFFENER FLOOR STRUCTURE BS540 BETWEEN RBBL 24.5 AND RBBL 45 CENTER SECTION IAW B737-700 SRM 51-10-02 ITEM 9 AND 51-40-02 WITH ASSY P/N 143A5240-32 # PO 2021 118523SDR SWAA2021031549610Gusset · crackedFWD CARGO LH GUSSET CRACKED AT STA 520; STR 19L; WL 200. / REMOVED AND INSTALLED NEW GUSSET AT FWD CARGO L/H STA 520; STR 19L IN REF SRM 51-40-02-0G-0 AND DOCUMENTED NUMBER 143A9481SDR SWAA2021031549608Gusset · crackedFWD CARGO RH GUSSET CRACKED AT STA 520; STR 19R; WL 200. / REMOVED AND REPLACED GUSSET ON FWD CARGO COMPT AT STA 520; STR 19R; WL200 AS PER B737-700 SRM 51-40-02-0G-0SDR SWIA202156899Angle · crackedCLIP CRACKED AT FS193.00 FRAME WS80.00 AT OUTBOARD FASTENER LOCATION (C-CHECK) RO 3/10/2021 REMOVED AND REPLACED CLIP AT FS193.00 FRAME WS 80.00 LH. REF CRJ 200 SRM 51-42-06 AND DWG 600-33101 REV-RSDR AALA202103119006Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED SHEAR PLATE AT S23L BETWEEN FR69 AND FR70. REPLACED SHEAR PLATE PER SRM 51-42-11-801.SDR SWAA2021030851967Stiffener · crackedCRACK STIFFENER FLOOR STRUCTURE LOCATED BS540 AT LBL24.75 TO RBL24.75 CENTER SECTION (2 EA) / REPLACED STIFFENER 2 (E/A) LOCATED BS 540 AT LBL 24.75 TO RBL 24.75 CENTER SECTION DUE TO CRACK NOT ALLOWABLE DAMAGE PART NUMBER USED ARE:143A5240- 35 P.O 2021-118065SDR SWAA2021030851687Angle · crackedCRACK SUPPORT ANGLE LOCATED BS695 AND RBL24.75 CENTER SECTION / REPLACED SUPPORT ANGLE LOCATED BS 695 AND RBL 24.75 CENTER SECTION I.A.W B737-700 SRM 51-10-02 PARAGRAPH 9 SRM 51-40-02 MATERIAL USED BAC1490- 2782 CONDITION TO AND HEAT TREATED A CONDITION T73 POSDR SWAA2021030851044Support Angle · crackedCRACK ANGLE - SUPPORT LOCATED BS 867 AT LEVEL STRINGER 26L AFT CARGO COMPARTMENT / REPLACED ANGLE - SUPPORT LOCATED BS 867 AT LEVEL STRINGER 26L AFT CARGO COMPARTMENT DUE TO NOT FOUND ALLOWABLE DAMAGE IN SRM B737-700 TO CRACK; PART NUMBER USED 149A8109U114 P.OSDR SWAA2021030852510Intercostal · bentBENT WEB INTERCOSTAL LOCATED BETWEEN BS 767 AND BS 747 S25R AT AFT CARGO COMPARTMENT. REPLACED INTERCOSTAL LOCATED BETWEEN BS 767 AND BS747 STR 25R AT AFT CARGO COMPARTMENT IAW B737700 SRM 511002 AND DRAWING #146A7500 REV A.SDR SWAA2021030852507Gusset · crackedCRACK GUSSET LOCATED BS500D AT STR21R FWD CARGO COMPARTMENT / REPLACED GUSSET LOCATED BS 500 D AT STR 21R FWD CARGO COMPARMTMENT IAW B737-700 SRM 51-40-02 AND DWG #143A7902 REV.- MATERIAL USED ALUMINION SHEET PN 7073-T0 0.040 PO #2020-203286
Back to JASC 5320