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 AALA202012079027Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE. FOUND CORROSION ON FLOOR BEAM Y1292 FROM FR 12 TO FR 24 AT FWD GALLEY AREA, MEASURING L=0.755 INCHES W=0.330 INCHES D=0.061 INCHES. REPLACED FLOOR BEAM Y1292, IAW SRM A321 51-72-11-911-001, 51-42-11-801 AND DWG D531109200.SDR AALA202011249008Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE. FOUND CORRODED AREA ON FLOOR BEAM -Y765 FROM FR 66 TO FR 70 AT AFT GALLEY AREA, MEASURING L=1.401 INCH, W=0.624 INCH, D=0.062 INCH. REPLACED FLOOR BEAM -Y765, IAW A321 SRM 51-72-11-911-001, 51-42-11-801 & DWG D53472780.SDR IPXA2020111762502Transition Panel · corrodedINSPECTION TYPE: SEG 4 RT TRANS PANEL STA 1440-1530 HAS CORROSION. REMOVE, FABRICATE, INSTALL IAW DWG 146N5391 & SRM 51-70-11.SDR MASA20201117082Web · corrodedC-CHECK SILL WEB CORRODED RT FORWARD CABIN OUTBOARD FS 282 STGR 17. REMOVED AND INSTALLED NEW SILL ASSEMBLY.SDR SWAA2021062930712Angle · corrodedAFT CARGO RH TRANS ANGLE LOWER SURFACE NUT PLATE HAS CORROSION STA 767+5' / REMOVED AND REPLACED R/H TRANSITION ANGLE FROM STA 767-794 PER SRM 51-40-02 ( PN# 146A8127-12)SDR SWIA202054905Angle · corrodedPAX DOOR SILL MID CAP ANGLE IS CORRODED. C-CHECK RO 12/28/2020. REPLACED PAX DOOR MID CAP ANGLE, IAW CRJ700 SRM AND DRAWING. SEE CONTINUATION CARD FOR DETAILS. COMPLIED WITH TASK CARD.SDR SWIA202054904Door Sill · corrodedPAX DOOR SILL KICKPLATE ANGLE IS CORRODED. C-CHECK RO 12/28/2020. REPLACED PAX DOOR LOWER SILL KICKPLATE ANGLE, PER SRM & DRAWING. SEE CONTINUATION CARD FOR DETAILS. COMPLIED WITH TASK CARD.SDR SWIA202054873Angle · corrodedCORROSION FOUND ON CLIP AT FS 333, STGR 24R. C-CHECK RO 12/26/2020. REMOVED AND REPLACED CLIP AT FS 333, STGR 24R, REF CRJ900 SRM.SDR AALA202012289003Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE. FOUND L=1.0585 INCH CRACK ON SHEAR PLATE AT FR 69 TO FR 70 AND STR 23L IN AFT GALLEY AREA. REPLACED SHEAR PLATE, IAW SRM A321 51-72-11-911-001, SRM 51-42-11-801 AND DRAWING D53470100.SDR AALA202012289002Shear Plate · corrodedAIRCRAFT IN BASE MAINTENANCE. FOUND CORROSION ON SHEAR PLATE AT FR 69 TO FR 70 AND STR 23R IN AFT GALLEY AREA, MEASURING L=0.517 INCHES W=0.916 INCHES D=0.020 INCHES. REPLACED SHEAR PLATE, IAW SRM A321 51-72-11-911-001, 51-42-11-801 & DWG D53470100.SDR SWAA2020120930777Structure · corrodedCORROSION BS 270 FWD CHORD RBL 4-RBL 10 WL 208. THE DAMAGE IS REPAIRED, PER EA 1-A53-13812 REV 3 AND ER 20-03616 REV IR.SDR SWAA2020120830699Angle · corrodedCORROSION ON ANGLE AT FLOOR STA 986.5 + 6 RBL 32. REMOVED AND REPLACED FLOOR SUPPORT ANGLE WITH NEW ANGLE AT STATION 986.5 + 6 RBL 32, IAW SRM 51-40-02.SDR REXA2020120700821Floor Support · corrodedRT FLOOR SILL CORRODED BETWEEN FS 319 AND FS 364. REPAIRED AREA IAW EA CRJ953-10961 DATED 11/3/20 REV IR.SDR REXA2020120700820Intercostal · corrodedINTERCOSTAL IS CORRODED BETWEEN FS 364 TO 349 AND STRINGERS 27 AND 26R. REMOVED & REPLACED INTERCOSTAL FS 364-349 BETWEEN STR 27 & 26R, IAW SRM 51-42-06-001-001-A01. REMOVED & REINSTALLED ORIGINAL GUSSETS, IAW SRM
51-42-21-001-001-A01.SDR REXA2020120700818Door Sill · corrodedCARGO DOOR CUTOUT LOWER SILL ANGLE IS CORRODED. REMOVED, DRILLED UP AND REPLACED CARGO DOOR CUTOUT LOWER SILL ANGLE, IAW SRM 51-40-11-001-001-A01, 51-42-06-001-001-A01 AND 51-42-21-001-001-A01. ATTACHED CERT AS REQUIRED.SDR SWIA202054507Strap · corrodedRT OUTBOARD STRAP AT FS 559.00 CORRODED IN SEVERAL AREAS 601 R31025-29. C-CHECK RO 12/04/2020. REMOVED DAMAGED RT OUTBOARD STRAP AT FS 559 AND INSTALLED NEW SERVICEABLE STRAP, IAW CRJ200-SRM.SDR SWIA202054496Floor Support · corrodedPAX DOOR FLOOR SUPPORT ANGLE IS CORRODED. C-CHECK RO 12/04/2020. REPLACED PAX DOOR FLOOR SUPPORT ANGLES. REFERENCE CONTINUATION CARD FOR WORK PREFORMED.SDR SCNA20201201396Baffle · corrodedCORROSION AFT CARGO BAFFLE BS 747-767 RBL 25 WL 160 BOTTOM SIDE. REMOVED AND REPLACED BAFELE IN AFT CARGO BS 747-767 RBL 25 WL 160, IAW SRM 51-40-05 SRM 51-40-02 AND DWG NR 146A7502.SDR SCNA20201124351Shield · corrodedAFT CARGO COMP CORROSION FWD SHIELD STA 767-787+6, RBL 22, WL 157. CORROSION ON AFT CARGO FWD SHIELD STA 767-787 FOUND TO BE OUT OF LIMITS, DUE TO NO ALLOWABLE DAMAGE IN THE SRM. REMOVED AND REPLACED PO 807782, IAW SRM 51-40-02-0G-0, BOEING DWG 146A0081 REV SDR SCNA20201124349Shield · corrodedAFT CARGO COMP CORROSION ON AFT SHIELD STA 847+7, RBL 23, WL 164. REMOVED AND REPLACED SHIELD WITH NEW, IAW SRM 51-40-02-0G-0 AND DWG 146A0081. SHIELD WAS REPLACED DUE TO NO PUBLISHED LIMITS IN SRM.SDR DALA2020111703754Intercostal · corrodedDURING INITIAL INSPECTION MAINTENANCE FOUND CORROSION LEVEL 2 ON TWO INTERCOSTALS FROM STA 1400 TO 1420 BETWEEN ST 28L-28R AT CARGO COMPARTMENT (C2). INTERCOSTALS REPAIRED, PER SRM.SDR DALA2020111603746Floor Support · corrodedCORROSION FLOOR BEAM -Y765 LOCATED BETWEEN FR 12 TO FR 24 FWD GALLEY AREA. CORRECTIVE ACTION: REPLACED FLOOR BEAM -Y765 LOCATED FR 12 TO FR 24 IN FWD GALLEY AREA, AS PER A319 SRM 51-72-11 AND A319 SRM 51-42-11.SDR DALA2020111603745Floor Support · corrodedCORROSION FLOOR BEAM -Y1292 LOCATED BETWEEN FR 12 TO FR 24 FWD GALLEY AREA. CORRECTIVE ACTION: REPLACED NEW FLOOR BEAM -Y1292 LOCATED BETWEEN FR 12 TO FR 24 FWD GALLEY AREA BRACKETS (6 EA) SPLICE (1 EA) AND FASTENERS, AS PER SRM A319 51-42-11 AND 51-72-11 ANDSDR DALA2020111603744Floor Support · corrodedCORROSION FLOOR BEAM +Y1292 AT LEVEL OF FR 20 AT FWD GALLEY AREA. CORRECTIVE ACTION: REPLACED FLOOR BEAM +Y1292 BETWEEN FR 12 TO FR 24 FWD GALLEY AREA, AS PER A319 SRM 51-72-11 AND DRAWING D53112813 ISSUE G00.SDR SWAA2021080530627Strip · damagedTHE CAPSTRIP AT STA 727 FLOOR BEAM AREA DAMAGED. / REPLACED PART PER SRM 51-10-02SDR SWAA2021062930549Baffle · crackedINTERCOSTAL / BAFFLE CRACKED AT STATION 500E TO 500F UNDER RIGHT HAND TRANSITION ANGLE / REMOVED AND REPLACED INTERCOSTAL/BAFFLE FROM STA. 500E TO STA. 500F UNDER R/H TRANSITION ANGLE @ RBL 22' PER SRM 51-40-02SDR SWAA2021062136057Scuff Plate · crackedAFT LOWER CORNER SCUFF PLATE IS CRACKED. / REMOVED AND REPLACED LOWER AFT CORNER SCUFF PLATE IAW AMM 53-11-02.SDR SWIA202055043Angle · corrodedPASSENGER DOOR LOWER SILL ANGLE FLANGE IS CORRODED AT FORWARD EDGE APPROXIMATELY FS 347. C-CHECK RO 12/30/2020. PASSENGER DOOR LOWER SILL ANGLE FLANGE FOUND TO BE OUT OF LIMITS, IAW CRJ 200 SRM. REVIEW WORK PERFORMED ON CAMP 21840703.SDR SWIA202055004Bracket · crackedANGLE IS CRACKED IN RADIUS AT RIGHT SIDE STRINGER 14 BETWEEN FS 621 TO FS 625. C-CHECK RO 12/30/2020. REMOVED AND REPLACED WITH SERVICEABLE ANGLE PN 601-35012-52, IAW CRJ 200 SRM.SDR SWIA202055003Bracket · crackedANGLE IS CRACKED IN RADIUS AT LEFT SIDE STRINGER 14 BETWEEN FS 621 TO FS 625. C-CHECK RO 12/30/2020. REMOVED AND REPLACED WITH SERVICEABLE ANGLE PN 601-35012-51, IAW CRJ200 SRM.SDR SWIA202054902Door Sill · corrodedAFT CARGO DOOR FLOOR SILL FS 1000-FS 1047 IS CORRODED, MARKED. C-CHECK RO 12/28/2020. BLENDED CORROSION AT AFT CARGO DOOR SILL FS1000-FS1047 REF CRJ700 SRM. ORIGINAL THICKNESS OF AFT CARGO DOOR SILL P/N MM670-35655-003 IS .063". MINIMUM BLENDED MATERIAL IS SDR SWAA2020120930470Structure · corrodedCORROSION BS 259 FWD CHORD LBL 10- RBL 4 WL 208. REMOVED AND REPLACED BS 259 FWD CHORD LBL 32-RBL 32 WL 208, IAW BOEING DWGS 141A0631, 141A7430, 141A7434 AND SRM 51-40-02-0G-0.SDR SWAA2020120830471Structure · corrodedCORROSION BS 259 AFT CHORD LBL 8-RBL 4 WL 208. DAMAGE REPAIRED, PER EA 20-153-02333 REV IR (ATS ER 20-03616 REV IR). REFER TO NRC U240471 FOR TRACKING.SDR SWIA202054490Plate · crackedCARGO DOOR FLOOR SILL CORRODED IN NUMEROUS AREAS AND ALSO IS CRACKED. C-CHECK RO 12/04/2020. REMOVED AND REPLACED CARGO DOOR FLOOR SILL, IAW REO CRJ-200 SRM. MAJOR REPAIR TASK & FORM M-337 COMPLETED AND ATTACHED. NO WEIGHT CHANGE REQUIRED. REFERENCE CONTISDR REXA2020113000798Floor Support · corrodedAFT CARGO LT OUTBOARD FLOOR SILL BETWEEN FS 985.00 TO FS 1000 IS CORRODED IN SEVERAL LOCATIONS, LT SIDE. CW ENDEAVOR AIR EA CRJ953-10919 REV IR DATED 10-28-20 FOR AFT CARGO OUTBOARD FLOOR SILL BETWEEN FS 985.00 TO FS 1000.SDR SWIA202054178Panel · corrodedRACK, PANEL 192CR INTERNAL DOUBLER CORRODED, AS MARKED. C-CHECK RO: 11/20/2020. REMOVED AND REPLACED PANEL 192CR INTERNAL DOUBLER, REF EMB175 SRM.SDR SCNA20201124333Support · corrodedFWD CARGO COMP AFT LOWER BULKHEAD PANEL SUPPORT CORROSION STA 500I, RBL 25, WL 156. REMOVED AND REPLACED NEW BULKHEAD SUPPORT ON RT AT STA 500I RBL 25, IAW SRM 51-40-02-0G-0 + DWG 143A9481.SDR REXA2020111800778Floor Support · corrodedFLOORBEAM AT LBL 27 BETWEEN FS 559+16 AND FS 570 IS CORRODED. R & R UNSERVICEABLE FLOORBEAM AT LBL 27 BETWEEN 559+116 AND 570 WITH SERVICEABLE FLOORBEAM, IAW MHIRJ REO 601R-53-61-7489 REV-- DATED 2020-11-12 AND REO 601R-53-00-027 REV D DATED 26-NOV-2009.SDR REXA2020111800775Frame · corrodedFRAME AT FS 605 CORRODED BETWEEN STGR 25R AND STRG 24L. R & R 605 FRAME SECTION FROM 25R TO 25L, IAW ENDEAVOR EA CRJ253-10963 REV IR DATED 11-4-20, CRJ 200 SRM 51-42-06 AND 51-25-01.SDR GTIA2020111635447Floor Support · corrodedDURING INSPECTION FLOOR BEAM Y-765 BETWEEN 67-68 WAS FOUND WITH CORROSION. RAF 2649076-01 CREATED SEE LTPR NRI 5001024992-0010 FOR CORRECTIVE ACTION. REVIEWED LTPR NRI 5001024992-0010 FLOOR BEAM Y-765 BETWEEN FR 67-68 CORRODED AND HAS BEEN ACCOMPLISHED, PER SDR CALA2020111601278Intercostal · crackedRT FWD EMERGENCY EXIT DOOR INTERNAL STRUCTURE FWD VERTICAL INTERCOSTAL CRACKED AT FASTENER HOLES. REMOVED AND REPLACED RT FWD EMERGENCY EXIT DOOR INTERNAL STRUCTURE FWD VERTICAL INTERCOSTAL SEGMENT, IAW A320 SRM 51-72-11-911-0 01.SDR 2020FA0000501Web · crackedNETJETS REQUEST A PERMANENT REPAIR TO THE NOSE WHEEL WELL STRUCTURE CRACKING. REFERENCE TEXTRON AVIATION STANDARD REPAIR SR-680A-ATA53-25890 REV- DATED JUNE 01, 2020 AND FAA FORM 8100-9 DATED 6/1/2020. STANDARD REPAIR-CRACK DAMAGE, NOSE LANDING GEAR WHEEL WESDR SWAA2021071530593Angle · corrodedAFT CARGO COMPARTMENT ANGLE BELOW FWD SHIELD AT BS 767-787; RBL 24; WL 156; IS CORRODED / REMOVED CORROSION AT AFT CARGO ANGLE BELOW FWD SHIELD AT STA 767-787 RBL 24 IA-W SRM 51-10-02-0G-0. VERIFIED MATERIAL LOSE ORIGINAL 0.050 REMOVED .015 REMAIN .035 ALLOWABSDR SWIA202055042Support Bracket · corrodedFS 409 AVIONICS BAY FLOORBOARD SUPPORT ANGLE IS CORRODED. C-CHECK RO 12/30/2020. REMOVED FRAME INTERCOSTAL ANGLE AFT OF FS 409 LOCATED AND DRILLED NEW ANGLE AND INSTALLED, IAW CRJ 200 SRM.SDR SWIA202055002Angle · crackedWHILE WORKING 621 BULKHEAD REPAIR. FOUND LOWER ANGLE FOR CARGO BAY DOOR BEAM TO BE CRACKED. C-CHECK RO 12/30/2020. REMOVED AND REPLACED THE CARGO BAY DOOR BEAM LOWER BRACKET, IAW CRJ 200 SRM.SDR SWIA202054752Angle · corrodedWHILE ACCESSING FOUND CIRCUMFERENTIAL JOINT ANGLE WITH CORROSION. C-CHECK RO 12/24/2020. REMOVED AND REPLACED CIRCUMFERENTIAL JOINT ANGLE, IAW CRJ 700 SRM & SKY CARD. NO WEIGHT CHANGES FORM 337 IS ATTACHED. REF ATTACHED CONTINUATION CARD FOR DETAILS OF WORSDR REXA2020120700801Support · crackedELECTRICAL POWER RECEPTACLE SUPPORT STRUCTURE CRACKED. REPLACED EXTERNAL AC POWER RECEPTICAL PROVISIONS BOX, IAW CRJ 900 AMM 24-40-03-000/400-801-A01 AND SRM 51-42-06. OPERATIONS CHECK GOOD.SDR REXA2020111800779Floor Support · corrodedCARGO BAY FLOORBEAM CORRODED AT LBL 27 BETWEEN FS 605 AND FS 621. REPAIRED CARGO FLOOR BEAM AT LBL 27.0 BETWEEN 605-621, IAW ENDEAVOR EA CRJ253-10960 REV IR DATED 11-2-20. THIS IS A MAJOR REPAIR.SDR DALA2020111703753Floor Support · corrodedDURING INSPECTION MAINTENANCE FOUND CORROSION LEVEL 2 ON FLOOR SUPPORT FROM STA 900 TO 1040 LBL 64 AT CPAX. FLOOR SUPPORT REPLACED.SDR FDEA202011142850Angle · crackedE&E COMPARTMENT (OVERHEAD LT TUNNEL), MAIN CABIN FLOOR SUPPORT SUB-STRUCTURAL STIFFENER ANGLE IS CRACKED IN THE UPPER CORNER OF THE RADIUS AT STA 246 APPROXIMATELY LBL 50. FABRICATED NEW SUPPORT ANGLE, PER BAC DWG 141T5146 REV B. REMOVED AND REPLACED SUPPORT
Back to JASC 5320