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 SIMA20210422006Support Angle · crackedRT OMEGA BEAM SUPPORT ANGLE IS CRACKED , BETWEEN FR 47 AND FR 48 -C/A-REPLACED RH OMEGA BEAM SUPPORT ANGLE BETWEEN FR 47 AND FR 48 IAW SRM 53-23-02 AND SRM 51-40-02. RT OMEGA BEAM SUPPORT ANGLE IS CRACKED , BETWEEN FR 47 AND FR 48 -C/A-REPLACED RH OMEGA BEAM SSDR HNAA2021050400186Door Sill · corrodedSERVICE DOOR FWD SILL AFT NUTPLATE CORRODED .... INSTALLED DOUBLER REPAIR ON THE SERVICE DOOR FWD SILL ON THE AFT END IAW EMB 145 SRM 53-21-10RE ITEM 5, FIG 204 SHEET 1.SDR REXA2021050300282Support Beam · gougedCARGO DOOR SUPPORT STRUCTURE FOR DOOR TRACKS CROSS MEMBER GOUGED ON BOTH ENDS FOR DOOR RETRACT CABLE.
REMOVED UNSERVICEABLE SUPPORT STRUCTURE AND INSTALLED SERVICEABLE IAW CRJ 200 SRM 51-42-21, 51-42-00, AND 51-40-11.SDR SWIA202157919Floor Support · corrodedL/H FLOOR BEAM AT FR 86 TO FR 87 HAS CORROSION AS MARKED. (C-CHECK RO 4/27/2021) REMOVED AND REPLACED L/H FLOOR BEAM AT FR 86 TO FR 87 REF SRM 51-40-08. RESTORED SURFACE PROTECTION REF SRM 51-23-06. PART REPLACED WITH FACTORY REPLACEMENT NO WEIGHT CSDR WX0A2021042673688Door Sill · not reportedEVALUATED DOOR SILL FR 67-68 STRG 23LH, REPAIR IS REQUIRED IAW A320 SRM 53-41-14-300-001 FIG 001 PRINCIPLE 7. // REPAIRED DOOR SILL IAW SRM 53-41-14-300-001."SDR N6WA2021042206Intercostal · corrodedINTERCOSTAL AT 26R HAS LEVEL II CORROSION. REMOVED AND REPLACED DAMAGED INTERCOSTAL AT 26R IAW CRJ700 SRM 51-42-06 AND 51-42-21.SDR N6WA2021042205Intercostal · corrodedINTERCOSTAL AT 26L HAS LEVEL II CORROSION.REMOVED AND REPLACED DAMAGED INTERCOSTAL AT 26L IAW CRJ700 SRM 51-42-06 AND 51-42-21.SDR N6WA2021042204Intercostal · corrodedINTERCOSTAL AT 27R HAS LEVEL II CORROSION.REMOVED AND REPLACED DAMAGED INTERCOSTAL AT 27R IAW CRJ700 SRM 51-42-06 AND 51-42-21.SDR N6WA2021042203Intercostal · corrodedINTERCOSTAL AT 27L HAS LEVEL II CORROSION. REMOVED AND REPLACED DAMAGED INTERCOSTAL AT 27L IAW CRJ700 SRM 51-42-06 AND 51-42-21.SDR DALA2021042302365Floor Support · corrodedSHIP 3244 CORROSION FLOOR STRUCTURE BEAM LOCATED BTW FR 68 TO FR 69 AND - Y1162 AT AFT GALLEY AREA. CORRECTIVE ACTION: REPLACED FLOOR BEAM PER A320 SRM 51-72-11. (1788888)SDR FDEA202104220980Cusp Web · crackedMAIN CUSP AREA STA 640-660 LBL 62.5 AS VIEWED FROM BOTTOM FILLER PN BACF3F020B197NN CRACKED AT FASTENER LOCATION ACCOMPLISHED FEDEX EA # F-5321-T0361228-P1 FUSELAGE - CARGO COMP FLOORS - MAIN CABIN - STA 640 - LBL - 62.5 - CRACKEDSDR BIGA2021042200113Insulation · meltedDURING A MAINTENANCE ACCEPTANCE FLIGHT, SOMETIME AFTER INITIATING CABIN HEAT, IT WAS NOTICED THAT THE FLIGHT STATION WAS BECOMING HAZY. THE PILOT LOOKED AFT AND SAW THAT THE CABIN WAS ALSO HAZY. CABIN HEAT WAS SECURED, AND THE AIRCRAFT VENTILATED. SUBSEQUENT SDR SWIA2021072259690Intercostal · corroded*RH BL2R INTERCOSTAL BETWEEN FS 349 AND FS 364 HAS EVIDENCE OF CORROSION AT OUTBOARD AFT SKIN FLANGE. (C-CHECK RO 7/20/2021) REPLACED INTERCOSTAL BETWEEN FS349 - FS364 STGR 26R REF CRJ-700 SRM 51-42-21-001-001-A01, 51-42-06-001-001-A01, AND DWG# SH670-3SDR SWIA2021072259689Intercostal · corroded*LH BL2L INTERCOSTAL BETWEEN FS 349 AND FS 364 HAS EVIDENCE OF CORROSION AT INBOARD AFT LOWER EDGE. (C-CHECK RO 7/20/2021) REPLACED INTERCOSTAL BETWEEN FS349-FS364, STGRS 26L-27 REF CRJ-700 SRM 51-42-06-001-001-A01, 51-42-21-001-001-A01, DWG SH670-32050SDR SWIA2021072259688Intercostal · corroded*STRINGER 20R INTERCOSTAL HAS EVIDENCE OF CORROSION BETWEEN FS 310. TO FS 319.70 (C-CHECK RO 7/20/2021) REMOVED AND REPLACED INTERCOSTAL P/N SH670-32047-1 ON STRINGER 20R BETWEEN FS 310. TO FS319.70. REF: DWG# SH670-31950, REV A, CRJ 700, SRM 51-42-06-0SDR SWIA2021072259685Intercostal · corroded*STRINGER 21L INTERCOSTAL HAS EVIDENCE OF CORROSION BETWEEN FS 333 AND FS 349. (C-CHECK RO 7/20/2021) REMOVED AND REPLACED WITH NEW INTERCOSTAL STRINGER 21L BETWEEN FS 333 AND FS 349.REF CRJ-700 SRM 51-42-06-001-001-A01 AND DWG# SH670-31810 REV Y.PRESSSDR SWIA2021070159222Angle · corrodedCAP ANGLE MID CENTER AT PAX DOOR SURROUND CORRODED (C-CHECK RO 6/29/2021) PAX DOOR CAP ANGEL MID CENTER WAS REMOVED AND ASERVICABLE ANGLE INSTALLED IAW CRJ 700 SRM 51-40-11-001-001-A01, 51-45-00-001-001-A01, AND 51-42-06-001-001-A01. M-337 AND 51-900-10SDR SWIA202158285Gusset · corrodedGUSSET LOCATED AT FS310 AT STR.21R CORRODED. (C-CHECK RO 5/20/2021) GUSSET AT F/S310.00 STR 21R REPLACED WITH A MADE REPAIR PART IAW CRJ700 SRM 51-42-21-001-001-A01 AND 51-42-06-001-001-A01 WITH REFERNCE TO DWG# SH670-32600 REV-AA. COMPLIED WITH TASK CSDR SWIA202158284Gusset · corrodedGUSSET LOCATED AT FS319, STR.21R CORRODED. (C-CHECK RO 5/20/2021) GUSSET LOCATED AT F/S 310.00 ON STR 21R WAS REPLACED WITH A MADE REPAIR PART IAW CRJ700 SRM 51-42-06-001-001-A01 AND 51-42-21-001-001-A01 WITH REFERNCE TO DWG# SH670-32600 REV-AK. COMPLISDR SWIA202158283Gusset · corrodedGUSSET LOCATED AT FS295, STR. 21R CORRODED. (C-CHECK RO 5/20/2021) GUSSET AT 21R FS295.00 WAS REPLACED WITH A MADE REPAIR PART IAW CRJ700 SRM 51-42-06-001-001-A01 AND 51-42-21-001-001-A01 WITH REFERENCE TO DWG# SH670-32600 REV-AK. COMPLIED WITH TASK CASDR SWIA202158139Support Angle · crackedFR 52 SUPPORT ANGLE IS CRACKED THROUGH THE O/B FASTENER FWD OF THE LH MLG WHEEL WELL AREA AS MARKED. (C-CHECK RO 5/8/2021) REMOVED AND REPLACED L/H FR 52 SUPPORT ANGLE FWD OF MLG WHEEL WELL REF SRM 51-40-08. DOME SEALED AND TOPCOATED FASTENERS REF SRM 5SDR IPXA2021051069158Intercostal · corrodedINSPECTION TYPE:2CLT AFT A/C BAY INTERCOSTAL IS CORRODED BETWEEN STA 550 - 590 AND BETWEEN LONGERONS 44L & 45L.REMOVED AND REPLACED CORRODED LT AFT A/C BAY INTERCOSTAL BETWEEN STA 550 - 590 AND BETWEEN LONGERON 44L & 45L IAW SRM 51-33-01 & 51-35-01. (MINOR)SDR IPXA2021043068802Stiffener · crackedINSPECTION TYPE:C12CRACK ON CENTER WING TANK STIFFENER (P/N:111T2011-6) ON STA 785.9,RBL 55.REPAIR I.A.W 767-300F SRM 57-10-10-2R-2 REPAIR 2 REV.80.00 AND UPS EO B767-5740-58151-C AND B767-5720-76672-A.SDR IPXA2021043068801Stiffener · crackedINSPECTION TYPE:C12CRACK ON CENTER WING TANK STIFFENER(P/N:111T2008-12)ON STA 785.9,RBL 33.REPAIR I.A.W 767-300F SRM 57-10-10-2R-2 REPAIR 2 REV.80.00 AND UPS EO B767-5740-58151-C AND B767-5720-76672-A.SDR AALA202104299003Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND CRACKED BAFFLE CLIP AT STA 500G AND STR 25L. REMOVED AND REPLACED BAFFLE CLIP REF EA327043 AND SRM 51-70-13-2R-1.SDR WX0A2021042673687Plate · corrodedDURING REMOVAL OF FWD CARGO TIE-DOWNS FOR REPLACEMENT, FOUND SUSPECTED CORROSION ON STRUCTURE CENTER PLATE BELOW TIE-DOWNS ON FRAME 27, FRAME 29 AND FRAME REPLACEMENT REQUIRED IAW SRM 51-72-11 REV 136. // REPLACED FORWARD CARGO STRUCTURE CENTER PLACE BELOW TIESDR CALA2021042200522Door Sill · corrodedL2 DOOR SILL FR66 FLANGE FOUND TO BE OUT OF LIMITS PER NR 929244 1 AND WILL REQUIRE REPAIR AREA C PER NR 9292634 / 38634 REPAIRED L2 DOOR SILL AT FR66 IAW SRM 53-41-14-700-001.SDR SWIA2021072259684Support Angle · corroded*CORROSION NOTED ON SUPPORT CLIP AT STRG26L FOR FRAME AT FS1015.00 (MARKED) (C-CHECK RO 7/20/2021) REMOVED & INSTALLED NEW SUPPORT CLIP AT STRG26L AND FS1015.00. REF CRJ700 SRM 51-42-06-001-001-A01 AND DWG# MM670-36062 REV E. / COMPLIED WITH TASKCARD 51SDR SWIA2021072259683Support Strap · corroded* SERVICE DOOR SURROUND LOWER FWD SUPPORT STRAP HAS SPOTS OF CORROSION AT APOX. FS319.70 (MARKED) (C-CHECK RO 7/20/2021) REMOVED AND REPLACED FITTING PN# SWH670-31990-1 AT FS 319 STR 17R PER REFERENCE DRAWING# SH670-31950 REV Y AND CRJ 700 SRM 51-42-2SDR SWIA2021072259682Floor Support · corroded* RH FLOOR SILL BETWEEN FS 280.00 AND FS295.00 HAS MULTIPLE SPOTS OF CORROSION (MARKED). (C-CHECK RO 7/20/2021) RH FLOOR SILL BETWEEN FS 280.00 AND FS295.00 FOUND OUT OF LIMITS IN REF CRJ700 SRM 53-00-45-201-001-A01, REMOVED AND REPLACED NEW FLOOR SILSDR SWIA2021072259679Floor Support · corroded* RH FLOOR SILL AFT OF SEVICE DOOR BETWEEN APROX. FS349.00 AND FS364.00 HAS SPOTS OF CORROSION (MARKED). (C-CHECK RO 7/20/2021) COMPLIED WITH REO 670-53-21-2020 REV -A DATED 2021-05-11 TO REPAIR RH FLOOR SILL AFT OF SEVICE DOOR BETWEEN APROX. FS349.00 SDR AALA202107134998Stiffener · damagedAIRCRAFT IN BASE MAINTENANCE: DAMAGED HOLE ON STIFFENER LOCATED AT STA 927 AND LBL 24.75. REPLACED STIFFENER PER DWG 147A5350 AND SRM 51-40-05.SDR SWAA2021052766465Support Bracket · crackedCRACK SUPPORT BRACKET LOCATED BS 540 BETWEEN BL 0 TO LBL 24 AT PASSENGER CABIN / REMOVED AND REPLACED SUPPORT BRACKET LOCATED BS540 BTW BL 0 TO LBL 24 AT PASSENGER CABIN IAW B737-700 SRM 51-40-02SDR SWAA2021052766460Angle · corrodedCORROSION Z ANGLE LOCATED BETWEEN BS 294.5 TO BS 332.1 WL 207.54 RBL 6 4 AT FWD GALLEY AREA / REPLACED Z ANGLE LOCATED BETWEEN BS 294.5 TO 332.1 WL 207.54 RBL 64 AT FWD GALLEY AREA IAW SRM B737- 700 51-10-02 ITEM 9 AND DRAWING #141A8310 REV: B PART NUMBER USEDSDR SWAA2021052766459Angle · corrodedCORROSION Z ANGLE LOCATED BETWEEN BS 312 TO BS 344 WL 207.54 LBL 64 AT FWD GALLEY AREA / REPLACED Z ANGLE LOCATED BETWEEN BS312 TO BS 344WL 207.54 LBL 64 AT FWD GALLEY AREA AND FASTENERS IAW B737-700 SRM 51-10-02 AND DRAWING 141A8110-13 REV.-SDR SWAA2021052468920Support Angle · crackedCRACK SUPPORT ANGLE LOCATED BETWEEN BS 380 TO BS 400 BL 0 AT PASSENGER CABIN / REPLACED SUPPORT ANGLE AND FASTENER LOC BTW BS 380 AND BS 400 BL0 FWD PASSENGER CABIN IAW SRM B737-700 51-10-02 ITEM 9 AND DRAWING 143A5400 REV - MATERIAL USED ALLUMINIUM SHEET 7075SDR SWAA2021052466458Web · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN BS 277 TO BS 294 AND BL 0 FWD GALLEY AND LAV / REPLACED WEB-INTERCOSTAL AND FASTENERS FLOOR STRUCTURE LOCATED BETWEEN BS277 TO BS294 AND BL0 FWD GALLEY AND LAV IAW SRM B737-700 51-10-02 ITEM 9 AND DRAWINGSDR SWAA2021052465347Floor Support · crackedFWD CABIN FLOOR STRUCTURE;SHOWS INTERCOSTAL;BETWEEN B.S.312 AND B.S.328 LBL 44.0 WITH UPPER MID SURFACE CRACKED AT HOLE AREA.(MKD 26-032) / REMOVED; REPLACED AND INSTALLED NEW INTERCOSTAL AT MAIN CABIN FLOOR STRUCTURE - BETWEEN BS. 312 AND B.S. 328 LBL 44.0 IASDR SWAA2021052465348Floor Support · corrodedFWD CABIN FOOR STRUCTURE AT L1 DOOR CUTOUT;SHOW SIGNS OF UPPER SURFACE CORROSION IN 3 AREAS;BETWEEN B.S.328.0 AND B.S.336.0 LBL 64 WL 207.54.MKD 26-034) /SDR SWAA2021052465345Floor Support · crackedFWD CABIN FLOOR STRUCTURE AT DOOR CUTOUT AREA;SHOWS INNER CHORD WITH SIGNS OF CRACK AT B.S.302.9 LBL 64.0 WL 207.54.(MKD 26-031) /SDR HNAA2021051900215Door Sill · corrodedSSI 53-30-48: CARGO DOOR CUTOUT LWR SILL CORRODED. REMOVED AND REPLACED CARGO DOOR CUTOUT LOWER SILL IAW EMB145 SRM 51-40-02.SDR IPXA2021051469384Stiffener · crackedINSPECTION TYPE:3CAFT CARGO FLOOR VERTICAL STIFFENER AT STA 1841 & LBL 38 IS CRACKED.REMOVED AND REPLACED CRACKED AFT CARGO FLOOR VERTICAL STIFFENER AT STA 1841 & LBL 38 IAW SRM 51-33-01. (MINOR)SDR IPXA2021051469383Stiffener · crackedINSPECTION TYPE:3CAFT CARGO FLOOR VERTICAL STIFFENER AT STA 1841 & LBL 31 IS CRACKED.REMOVED AND REPLACED CRACKED AFT CARGO FLOOR VERTICAL STIFFENER AT STA 1841 & LBL 31 IAW SRM 51-33-01. (MINOR)SDR IPXA2021051469382Stiffener · crackedINSPECTION TYPE:3CAFT CARGO FLOOR VERTICAL STIFFENER AT STA 1841 & LBL 26 IS CRACKED.REMOVED AND REPLACED CRACKED AFT CARGO FLOOR VERTICAL STIFFENER AT STA 1841 & LBL 26 IAW SRM 51-33-01. (MINOR)SDR IPXA2021051469381Stiffener · crackedINSPECTION TYPE:3CAFT CARGO FLOOR VERTICAL STIFFENER AT STA 1841 & LBL 20 IS CRACKED.REMOVED AND REPLACED CRACKED AFT CARGO FLOOR VERTICAL STIFFENER AT STA 1841 & LBL 20 IAW SRM 51-33-01. (MINOR)SDR IPXA2021051469380Stiffener · crackedINSPECTION TYPE:3CAFT CARGO FLOOR VERTICAL STIFFENER AT STA 1841 & RBL 20 IS CRACKED.REMOVED AND REPLACED CRACKED AFT CARGO FLOOR VERTICAL STIFFENER AT STA 1841 & RBL 20 IAW SRM 51-33-01. (MINOR)SDR IPXA2021051469378Stiffener · crackedINSPECTION TYPE:3CAFT CARGO FLOOR VERTICAL STIFFENER AT STA 1841 & RBL 38 IS CRACKED.REMOVED AND REPLACED CRACKED AFT CARGO FLOOR VERTICAL STIFFENER AT STA 1841 & RBL 38 IAW SRM 51-33-01. (MINOR)SDR SWAA2021051165374Scuff Plate · crackedFWD CARGO BAY AFT CORNER SCUFF PLATE CRACKEDSDR SWAA2021051065481Splice Strap · corroded***CORROSION*** ON ACB FLOOR BOARD SPLICE STRAP BS 727D+6; LBL 10 - RBL 10; WL 157 / CORROSION FOUND ON ACB FLOOR SPLICE STRAP BS727D+6 LBL-10-RBL10 WL-157 FOUND TO BE OUT OF LIMIT DUE TO NO LIMIT ON SRM REPLACED PARTS P/N 146A9401-8 IAW SRM 51-10-02-0G-0 PAR-SDR SWAA2021051065476Web · elongatedFCB DOOR CUTOUT LWR THRESHOLD WEB HAS SEVERAL ELONGATED HOLES BS 440 - BS 480; RBL 18; WL 157 / REMOVED AND INSTALLED NEW FCB DOOR CUTOUT LWR THRESHOLD WEB AT BS-440-BS-480; RBL18; WL157 ITEM# 7530597; PO# 819204; IAW SRM 53-30-15-01-1 SRM 53-30-15-1A-1; SRM 5
Back to JASC 5320