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 UIEA2021041800933Door Sill · corrodedFWD CARGO STA 560 RBL 44 APPROX DOOR SILL CORRODED(<P>REMOVED CORROSION ON FWD CARGO DOOR SILL STA 560 RBL 44. REWORKED AREA IN COMPLIANCE WITH EA:21033 REV:IR, B767 SRM 51-40-02,51-10-02,53-00-15,51-20-01,AMM 51-24-22</P>)SDR CALA2021042600530Support Beam · corrodedR2 DOOR SILL PANEL SUPPORT BEAM FOUND CORROSION AT FR68 REFER HAECO NON-ROUTINE LP 9428470 - ORIGINATED BY EMP V906558 SPEC NO AENB-53-3-6187 PERFORM BY EMP V905768 R2 DOOR SILL PANEL SUPPORT BEAM REPLACED AS PER SRM 51-72-11 REV 135,INSTALLED AS PER SRM 51-42SDR KCSA202104231051Shear Web · corrodedPOSSIBLE CORROSION ON UPPER DECK FLOOR SHEAR WEB AT STA 460-500SDR KCSA202104231050Floor Support · corrodedPOSSIBLE CORROSION ON UPPER DECK FLOOR STRUCTURE STA 500, AT TOP OF CREW LADDERSDR JR2R20210423647Support Bracket · corrodedFLOOR PANEL SUPPORT BRACKET CORRODED AT FR90 RH OB END OF BEAMSDR JR2R202104230002Gusset · corrodedRH CENTER DOUBLER ON FR89 CORRODEDSDR JR2R20210423604Support · corrodedRH SILL BETWEEN FR88 AND FR90 CORRODED IN SEVERAL PLACESSDR JR2R20210423602Shear Panel · corrodedCENTER DOUBLER BETWEEN FR87 AND FR88 CORRODED IN SEVERAL PLACESSDR JR2R20210423601Shear Panel · corrodedLH DOUBLER BETWEEN FR87 AND FR88 CORRODED IN SEVERAL PLACESSDR JR2R20210423693Gusset · corrodedGUSSET AT RBL9 FR90 CORRODEDSDR JR2R20210423687Floor Support · corrodedRH FLOOR SILL AT FR 89 CORRODEDSDR JR2R20210423688Gusset · corrodedGUSSET AT FR90 LBL 24 CORRODEDSDR JR2R20210423690Shear Panel · corrodedRH SHEAR PANEL AT FR 87 IS CORRODEDSDR JR2R20210423691Shear Panel · corrodedCENTER SHEAR PANEL AT FR87 CORRODEDSDR JR2R20210423692Gusset · corrodedGUSSET AT RBL9 AND FR89 CORRODEDSDR JR2R20210423001Gusset · corrodedGUSSET AT RBL AND FR89 CORRODEDSDR JR2R20210423698Floor Support · corrodedRH FLOOR SILL CORRODED AT FR17SDR SWIA2021072259691Door Sill · corroded*MULTIPLE SPOTS OF CORROSION NOTED ON ANGLE COMMON TO AFT CARGO DOOR SILL AT APPROX. FS1000.00-FS1047.00 (MARKED) (C-CHECK RO 7/20/2021) REPLACED THE AFT CARGO DOOR ANGLE COMMON TO SILL. REF CRJ700 SRM 51-42-06-001-001-A01, REF CRJ700 SRM 51-42-13-001-0SDR SWIA2021070159223Angle · corrodedAT PAX DOOR LOWER SILL DOOR SURROUND LOWER ANGLE CORRODED (C-CHECK RO 6/29/2021) REMOVED DAMAGED LOWER ANGLE AND INSTALLED A NEW SERVICABLE ANGLE IAW CRJ 700 SRM 51-42-06-001-001-A01, 51-40-11-001-001-A01 AND 51-45-00-001-001-A01. M-337 AND TASK CARD 5SDR SWIA202158657Support · corrodedBACK-UP SILL AT STGR21L BETWEEN FS333.00 AND FS349.00 CORRODED. (C-CHECK RO 6/04/2021) EVALUATED, REMOVED AND INSTALLED NEW BACK-UP SILL AT STGR21L BETWEEN FS333.00 AND FS349.00 REF DWG SH670-31810 REV Y AND CRJ 700 SRM 51-42-06-001-001 A01. SEE CONTSDR SWAA2021060365741Floor Support · corroded***CORROSION*** ON B.L. 0 SUPPORT INTERCOSTAL AT B.S. 259-270; W.L. 207.54 / EVALUATED DAMAGE ON SUPPORT INTERCOSTAL AT BS 259 - 270 BL 0 WL. 207.54 AND FOUND TO BE OUT OF LIMITS DUE TO 50% MATERIAL LOSS I.A.W SRM 53-10-51-1A-1. REMOVED AND REPLACED SUPPORT INSDR ASAA2021042234889Plate · corrodedAFT CARGO LH TRANSITION PANEL HAS COROSSION FROM STA. 727A TO 787. GROUNDED - YES. REPAIRED TRANSITION PANEL 727A-847 IAW B737-800 SRM 53-00-53-2R-5 REPAIR 5W 1.1 O .040 R .031 L 2.4 D .009.SDR SWAA2021052465878Retainer · corrodedCORROSION LMLG CUT OUT RETAINER WL 156; BS 727; LBL43 UPPER /SDR SWAA2021052465877Retainer · corrodedCORROSION LMLG CUT OUT RETAINER WL 156; BS 727; LBL33 LOWER /SDR AALA202105200884Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND 0.095 INCH CRACK BETWEEN FR69 TO FR70 AND STR 23L ON SHEAR PLATE. REPLACED SHEAR PLATE AT AFT GALLEY AREA IAW A321 SRM 51-72-11-911-001 AND DWG 53470100.SDR AALA202105206138Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK FOUND ON SHEAR PLATE LOCATED BETWEEN FR69 TO FR 70, STR 23R. L= 0.811 INCHES. REPLACED SHEAR PLATE STR 23R BETWEEN FR69 TO FR 70 AT AFT GALLEY AREA PER SRM 51-72-11-911-001.SDR ASAA2021042234839Support Angle · corrodedFWD. CARGO STA. 500I LOWER CENTER BULK'HD SUPPORT ANGLE CORRODED STR. 25L-25R. GROUNDED - YES. REMOVED & REPLACED RAIL ASSY IAW 737-800 SRM 51-40-02-00-0 W=2 O=.071 R=0 L=2 D=.071SDR ASAA2021042234838Transition Panel · corrodedFWD. CARGO LH TRANSITION PANEL STA. 500G-500I CORRODED. GROUNDED - YES. REPAIRED FWD CARGO L/H TRANSITION PANEL STA 500G-500I IAW B737-800 SRM 53-00-53-2R-5 W 3.0 O .040 R 0 L 3.0 D .040SDR AALA202105180983Support · corrodedAIRCRAFT IN BASE MAINTENANCE: FOUND CORROSION, MEASURING L=1 INCH, W=0.09 INCH, D=0.002 INCH, ON LOWER SILL AT FR68 AND STR 23R. REPLACED LOWER SILL REF A321 SRM 51-72-11-911-001 AND DWG D53480505.SDR AALA202105183899Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LOWER SILL CENTER FITTING LOCATED FROM FR66 TO FR68 AT S23L. REPLACED CENTER FITTING PER SRM 51-42-11-801 AND DWG D53480009.SDR AALA202105189481Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LOWER SILL LOCATED AT FR 68 STR 23L. REPAIRED PER SRM 53-41-14-300-001.SDR ASAA2021042234790Channel · corrodedRH TRANSITION PANEL HAS CORROSION FROM STA 727B TO 767 GROUNDED - YES. REPAIRED RH TRANSITION PANLE FROM STA 727 TO 767 IAW B737-800 SRM 53-00-53-2R-5 REPAIR 5 W 1.2 O .040 R .032 L 2.1 D .008SDR ASAA2021042234787Shield · corrodedAFT CARGO RH FWD. SHIELD PANEL HAS CORROSION. GROUNDED - YES. AFT CARGO R/H FWD, SHIELD PNL REMOVED AND REPLACED IAW B737-800 SRM 51-40-02-0G-0 AND B737-800 SRM 51-40-05-0G-0W 1.0 O .050 R .032 L 2.0 D .018SDR IPXA2021051169300Web · crackedINSPECTION TYPE:2CMAIN CABIN L3 DOOR TORQUE BOX FWD LOWER WEB IS CRACKED AT LIGHTNING HOLE.REPAIRED CRACKED L3 DOOR JAMB INNER WEB BETWEEN STA 1250.75 & 1256.75 IAW VT-SAA EA 011-5310-01-A9060 REV. IR AND UPS EO MD11-5310-80323-A. (MAJOR)SDR R61A2021051200404Shear Plate · corrodedCFIII CORROSION FOUND ON CENTER SHEAR PLATE BTWN FR 87-88. REPLACED SHEAR PLATE IAW SRM 51-42-01.SDR R61A2021051200405Floor Support · corrodedCFIII CORROSION FOUND ON RH IB FLOOR SUPPORT BTWN FR 90-91. REPLACED FLOOR SUPPORT IAW SRM 51-41-01 & 51-43-01.SDR R61A2021051200395Floor Support · corrodedCFIII, CORROSION FOUND ON LH OB PANEL SUPPORT PROFILE AT FR91. REMOVED AND REPLACED PANEL SUPORT IAW SRM 51-41-01, 51-42-01 AND 51-43-01.SDR R61A2021051200406Floor Support · corrodedCORROSION FOUND ON LH IB FLOOR SUPPORT BTWN FR 90-91. REPLACED FLOOR SUPPORT IAW SRM 51-41-01 & 51-43-01.SDR R61A2021051200396Shear Plate · corrodedCORROSION FOUND ON RH SHEAR PLATE BTWN FR87-88. REPLACED CORRODED SHEAR PLATE IAW SRM 51-42-01SDR R61A2021051200398Splice Plate · corrodedCORROSION FOUND ON RH SPLICE PLATE BTWN FR87-88. REPLACED CORRODED SPLICE PLATE IAW SRM 51-42-02SDR R61A2021051200399Gusset · corrodedCFIII, CORROSION FOUND ON RH AFT OB GUSSET PLATE AT FR90. REPLACED CORRODED GUSSET PLATE IAW SRM 51-42-02SDR R61A2021051200407Gusset · corrodedCFIII CORROSION FOUND ON AFT RH IB GUSSET PLATE AT FR91. REPLACED GUSET PLATE IAW SRM 51-41-02.SDR R61A2021051200408Fitting · corrodedCFIII CORROSION FOUND FITTING BELOW RH OB PANEL SUPPORT PROFILE AT FR89. REPLACED WITH MADE PART IAW DWG 170-86124-001.SDR R61A2021051200409Gusset · corrodedCFIII CORROSION FOUND ON LH AFT GUSSET PLATES IB & OB AT FR 90. REPLACED GUSET PLATES IAW SRM 51-41-02.SDR R61A2021051200402Splice Plate · corrodedCFIII CORROSION FOUND ON LH OB SPLICE PLATE BTWN FR87-88. REPLACED SPLICE PLATE IAW SRM 51-52-02.SDR R61A2021051200403Shear Panel · corrodedCFIII CORROSION FOUND ON LH SHEAR PLATE BTWN FR 87-88. REPLACED SHEAR PLATE IAW SRM 51-42-01.SDR SIMA202105120008Floor Support · corrodedSSI 53-20-11 POSSIBLE CORROSION DAMAGE ON THE LH OMEGA BEAM AT FR 20 ON THE JUNCTION WITH THE CROSSBEAM.(LEVEL 2 CORROSION) -C/A-REMOVED, FABRICATED AND INSTALLED EXTERNAL ANGLE, FILLER AND SHIM ON LH OMEGA BEAM AT FR 20 ON THE JUNCTION WITH THE CROSSBEAM IAW SDR SIMA20210510007Door Sill · corrodedAT THE SERVICE DOOR, THE RH CENTER SILL HAS CORROSION DAMAGE (LEVEL 2 CORROSION)-C/A-RAR RH SERVICE DOOR CENTER SILL IAW EMB 145 SRM 51-40-02SDR SWAA2021050765910Support Bracket · brokenAFT CARGO FWD BULKHEAD SUPPORT BRACKET BROKEN RH SIDE OF APU BLEED AIR DUCT JUST ABOVE FLOOR LEVAL / REMOVED BROKEN SUPPORT BRACKET AND REPLACED WITH NEW BRACKET AT AFT CARGO FORWARD BULKHEAD; RIGHT HAND SIDE OF APU BLEED AIR DUCT I/A/W SRM 51-40-02SDR R61A2021050600383Gusset · corrodedWHILE AC WAS IN FOR HVY CK FOUND CF3 FLOOR STRUCTURE CORROSION FOUND ON GUSSET PLATE RH SIDE AT FR 90. REPLACED GUSSET PLATE PN 170-60259-001 IAW SRM 51-41-02. SEE AAR NRC# 4500889-1000-0116 FOR WORK PERFORMED. AC REMAINS IN YQG FOR COMPLETION.
Back to JASC 5320