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 UIEA2022092801058Floor Support · corrodedU/D STA 400-460 LBL 20 - RBL 20 FLOOR BEAM FOUND CORROSION AT STA 406 TO STA 426 LBL 20(<P>CORROSION REMOVED AND REPROTECTED IAW SRM 51-10-02 AND 51-20-01 WITHIN SRM 53-00-01 ALLOWABLE DAMAGE 1 FIG 101 LIMITS</P>)SDR SWAA2022112364792Angle · corrodedAFT CARGO FLOOR TRANSITION ANGLE HAS AREAS OF CORROSION AROUND FASTENER HOLES FROM STA 787-807 LBL 21. REMOVED CORROSION PER SRM 51-10-02.FOUND TO BE WITHIN LIMITS PER SRM 53-00-53-1A-2. TREATED AND PRIMED THE AREA PER SRM 51-20-01. REMOVED CORROSION PER SRSDR SWAA2022112364784Web · corrodedAFT CARGO COMPARTMENT THRESHOLD WEB HAS AREAS OF CORROSION FORM STA 792-847. / [01] BLENDED AREA PER SRM 51-10-02. FOUND CORROSION TO BE OUT OF LIMITS PER SRM 53-60-15-1A-1. REMOVED DAMAGED WEB PER SRM 51-40-02.;[02] LOCATED HOLES AND DRILLED IN NEW WEB PER SRSDR R61A2022110000738Support · corrodedWHILE AC WAS IN FOR HVY CHECK CORROSION FOUND ON AFT CARGO BAGGAGE SUPPORT AT FR 77 STR 29L.MX REPLACED WITH NEW IAW SRM 51-41-02, 51-41-01, 51-43-01.PN 170-66350-001. AC RETURNED TO SERVICE.SDR R61A2022111900731Shear Panel · corrodedCORROSION FOUND ON CF III FLOOR STRUCTURE LH SHEAR PANEL BETWEEN FR 87 AND FR 88. R&R'ED SHEAR PANEL ON CF III FLOOR STRUCTURE LH SHEAR PANEL BETWEEN FR 87 AND FR 88. IAW EMB 170/175 SRM 51-42-01, SRM 51-42-02, AND SRM 51-43-01SDR R61A2022111700714Plate · corrodedCORROSION FOUND ON REAR FUSELAGE FLOOR STRUCTURE GUSSET PLATE LH INBD SIDE AT FR91, R&R'ED GUSSET PLATE ON REAR FUSELAGE FLOOR STRUCTURE LH INBD SIDE AT FR 91 IAW EMB 170/175 SRM 51-41-02SDR R61A2022111700713Shear Tie · corrodedCORROSION FOUND ON CF III SHEAR CLIP AT FR 90 BETWEEN STGR 29L AND STGR 29R . R&R'ED SHEAR CLIP AT FR90 BETWEEN STGR29L AND STGR 29R IAW SRM 51-43-03 AND SRM 51-41-02SDR R61A2022111700712Shear Tie · corrodedCORROSION FOUND ON CF III SHEAR CLIP AT FR 90 BETWEEN STGR 29L AND STGR 29R . R&R'ED SHEAR CLIP AT FR90 BETWEEN STGR29L AND STGR 29R IAW SRM 51-43-03 AND SRM 51-41-02SDR SWAA2022111664767Angle · crackedCRACKED ANGLE, BS 907-927, S25-27R IN THE AFT CARGO COMPARTMENT. REPLACED THE ANGLE IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 147A7221, SHEET 17, REV D.SDR SWAA2022111664265Support Angle · elongatedELONGATED HOLE ON SUPPORT ANGLE, BS 727 BULKHEAD AREA BETWEEN S25-26L IN THE AFT CARGO. REPLACED THE SUPPORT ANGLE IAW SRM 51-10-02, ITEM 9, AND DWG 144A2600, SHEET 255, REV -.SDR SWAA2022111664768Angle · crackedCRACKED ANGLE, BS 867, S26L-27L IN THE AFT CARGO COMPARTMENT. REPLACED THE ANGLE IAW SRM 51-10-02-0G-0, ITEM 9.SDR SWAA2022111664770Angle · corrodedCORROSION ANGLE, BS 947, S25R-26L IN THE AFT CARGO COMPARTMENT. REPLACED THE ANGLE AND FASTENERS IAW SRM 51-10-02, STEP 9, SRM 51-40-02, & DWG 149A8117, SHEET 4, REV C.SDR REXA2022111502550Angle · corrodedSERVICE DOOR LOWER SILL ANGLE (P/N SH670-31986-1) IS CORRODED. REMOVED AND REPLACED LOWER SILL ANGLE IAW CRJ-900 SRM 51-42-06-001-001-A01,51-42-21-001-001-A01 AND 51-42-36-001-001-A01.SDR SWAA2022111464964Support Channel · corrodedFWD CARGO STA. 500G-500I CORROSION AROUND NUT-PLATE HOLES ON RIGHT SUPPORT CHANNEL/TRANSITION ANGLE. / [01] ALL WORK TO BE PERFORMED ON NR TTG8Q00FRQC8 #1660;[02] C/W INSPECTION.SDR SWAA2022111464958Support Channel · corrodedFWD CARGO STA. 500D-500F CORROSION AROUND NUT-PLATE HOLES ON LEFT SUPPORT CHANNEL/TRANSITION ANGLE. / [01] WORK TO BE PERFORMED ON NR TTG8Q00FS334SDR SWAA2022111464966Support Channel · corrodedFWD CARGO STA. 500B-500D CORROSION AROUND NUT-PLATE HOLES ON LEFT SUPPORT CHANNEL/TRANSITION ANGLE. / [01] WORK TO BE PERFORMED ON NR TTG8Q00FS334SDR SWAA2022111464967Support Channel · corrodedFWD CARGO STA. 500B-500D CORROSION AROUND NUT-PLATE HOLES ON RIGHT SUPPORT CHANNEL/TRANSITION ANGLE. / [01] ALL WORK TO BE PERFORMED ON NR TTG8Q00FRQC8 #1660;[02] C/W INSPECTION.SDR SWAA2022111464962Channel · corrodedFWD CARGO STA. 500I; AFT BULKHEAD NUT-PLATE CHANNEL LBL 23 TO RBL 23 HAS CORROSION AROUND NUT-PLATE HOLES. REMOVED AND REPLACED WITH ASSEMBLY PER SRM 51-40-02;[02] C/W INSPECTION.SDR SWAA2022111464965Angle · corrodedFWD CARGO STA. 500D-500F CORROSION AROUND NUT-PLATE HOLES ON RIGHT SUPPORT CHANNEL/TRANSITION ANGLE. ALL WORK TO BE PERFORMED ON NR TTG8Q00FRQC8 #1660.SDR SWAA2022111464968Angle · corrodedFWD CARGO STA. 500-500B CORROSION AROUND NUT-PLATE HOLES ON LEFT SUPPORT CHANNEL/TRANSITION ANGLE. / [01] REMOVED LIGHT SURFACE CORROSION; FOUND WITH IN LIMITS TREATED AND PRIMED PER SRM 53-00-53-1A-2SDR SWAA2022111464959Angle · corrodedFWD CARGO STA. 500-500B CORROSION AROUND NUT-PLATE HOLES ON RIGHT SUPPORT CHANNEL/TRANSITION ANGLE. / [01] ALL WORK TO BE PERFORMED ON NR TTG8Q00FRQC8 #1660;[02] C/W INSPECTION.SDR SWAA2022111464960Channel · corrodedFWD CARGO STA. 396 CORROSION AROUND NUT-PLATE HOLES ON RIGHT SUPPORT CHANNEL/TRANSITION ANGLE. REMOVED LIGHT SURFACE CORROSION; FOUND WITH IN LIMITS TREATED AND PRIMED PER SRM 53-00-53-1A-2.SDR SWAA2022111464969Channel · corrodedFWD CARGO STA. 420-440 CORROSION AROUND NUT-PLATE HOLES ON RIGHT SUPPORT CHANNEL/TRANSITION ANGLE. REMOVED AND REPLACED WITH NEW PART PER SRM 51-40-02SDR REXA2022111102495Floor Support · corrodedCORROSION FOUND ON RH FLOOR SILL BETWEEN FS 349.00-364.00 CORROSION FOUND ON RH FLOOR SILL BETWEEN FS 349.00-364.00 IS ON A PREVIOUS REPAIR. NO ALLOWABLE DAMAGE. RECEIVED AND COMPLIED WITH MHIRJ REO 690-53-21-1557SDR REXA2022111102493Channel · corrodedRH WALL MOUNT CHANNEL BEHIND SIDE SEAT RAIL FS 743-753 HAS SEVERAL AREAS OF CORROSION. INSTALLED NEW SERVICEABLE RH SIDE SEAT RETAINER AT FS 744-752 PN SH690-37555-2 IAW CRJ900 AMM 53-00-49-400-801-A07.SDR REXA2022111102490Floor Support · corrodedCORROSION FOUND ON RH FLOOR SILL BETWEEN FS 280.00-295.00 INSTALLED R/H FLOOR SILL (P/N SH670-32172-11) BTW FS 280-319 IAW CRJ900 SRM 51-42-06-001-001-A01, 51-42-21-001-001-A01, AND 51-42-13-001-001-A01SDR REXA2022111102486Threshold · crackedFWD EQUIPMENT COMPARTMENT FLOOR IS CRACKED ABOVE RH AFT LATCH INSTALLED NEW LANDING THRESHOLD P/N CC670-33151-6S IAW CRJ 900 SRM 51-42-06-001-001-A01 AND SRM 51-42-13-001-001-A01SDR AALA202211089320Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN INTERCOSTAL LOCATED AT BS 947.50 AND LBL 24.75. REPLACED INTERCOSTAL PER SRM 53-70-51-2R-5, AARD 51-00-05-1 AND DWG 147A5650.SDR AALA202211046704Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: MAIN DECK AFT WET AREA BETWEEN STA 967 AND 986.5 AND LEFT BUTT LINE 17 APPROXIMATELY FLOOR SUPPORT UNDER SCREW HOLES CORRODED. REMOVED AND REPLACED FLOOR SUPPORT PER SRM 51-40-02-0G.SDR AALA202211040368Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: AFT CARGO COMPARTMENT RIGHT FLOOR TRANSITION PANEL HAS AREAS OF CORROSION ON UPPER SURFACE BETWEEN STATION 727F AND STATION 787 AND LEFT BUTT LINE 25. REMOVED AND REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5SDR AALA202211029290Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT FLOOR STRUCTURE MAIN FRAME AFT SIDE ATTACH ANGLE LOCATED AT BS 500H AND S26L. REPLACED ATTACH ANGLE PER SRM 51-40-02-0G.SDR AALA202211021730Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT FLOOR STRUCTURE MAIN FRAME FORWARD SIDE ATTACH ANGLE LOCATED AT BS 500H AND S26L. REPLACED ATTACH ANGLE PER SRM 51-40-02-0G.SDR DALA2022103107025Web · corroded(LOG 2469367) DURING INSPECTION FOUND CORROSION ON FWD CARGO COMPARTMENT SUB THRESHOLD WEB STA 440-495, RBL 24, WL 156. REMOVED AND REPLACED DAMAGED SUB THRESHOLD WEB IAW B737 SRM 51-40-02-0G-0 AND BOEING DWG 143A8122 AT STA 440-495, RBL 24, WL 156.SDR DALA2022103107024Shield · corroded(LOG 2469107) DURING INSPECTION FOUND AFT CARGO COMPARTMENT, SHIELD AFT OF CARGO DOOR CUTOUT IS CORRODED. REMOVED AND REPLACED AFT SHIELD IAW B737 SRM 51-40-02 AND BOEING DWG 146A0081.SDR KCSA202210261166Floor Support · crackedMAIN DECK FLOOR SUPPORT UPPER CORD @ STA 240 WL 199.80 , 30 INCHES TO LT OF BBL-0 IS DAMAGED ( CRACKED )SDR KCSA202210261165Stiffener · crackedFLOOR WEB STIFFNER CRACKED AT STA 1480 RBL 10 IN AFT PITSDR KCSA202210261164Stiffener · crackedFLOOR WEB STIFFENER CRACKED AT STA 1461 RBL10 IN AFT PITSDR A6WA202210258400Cover Plate · corrodedSERVICE DOOR LOWER SILL COVER PLATE HAD SEVERAL AREAS OF SEVERE CORROSION ALONG ENTIRE LENGTH OF PLATE FROM BS 319 - 349, RBL 42 - 46. AIRCRAFT REMOVED FROM SERVICE. REMOVED AND REPLACED SERVICE DOOR LOWER SILL COVER PLATE IAW 51-41-02, REV 39.SDR ASAA2022102541018Blanking Plate · corrodedLH AFT PASSENGER DOOR FLOOR HAS CORROSION AT FWD GIRT BAR GROUNDED - YES. REMOVED AND REPLACED FWD GIRT BAR BLANKING PLATE AT LH AFT PASSSENGER DOOR IAW A320 AMM 53-13-31-400-003-ASDR JJBA20221128026Angle · crackedRH MLG WHEEL WELL, AFT WEB, UPPER ANGLE CRACKED. DAMAGED AREA REMOVED BY CUT OUT ON R/H MLG WHEEL WELL AFT WEB UPPER ANGLE AT STA X 16783.5. R/H MLG WHEEL WELL AFT WEB UPPER ANGLE REPAIRED WITH ANGLE DOUBLE AND INSTALLED WITH SOLID RIVET AND HI-LOCK.SDR SWAA2022112264432Floor Support · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN BS344 TO BS360 LBL12 WL 208.1 FWD GALLEY AND LAV. REPLACED FLOOR SUPPORT IAW SRM 51-40-02 AND DWG 141A5400 REV A.SDR AALA202211188641Web · corrodedAIRCRAFT IN BASE MAINTENANCE: AFT CARGO DOOR LOWER SILL WEB CORRODED LOCATED BETWEEN STA 787 TO 847 AND STR 25R. REMOVED AND REPLACED INSTALLED SERVICEABLE AFT CARGO WEB SILL PER AARD 51-00-05-1.SDR AALA202211187344Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO AFT REMOVABLE BULKHEAD LOWER SUPPORT ANGLE HAS AREAS OF CORROSION LOCATED AT STA 500I AND BETWEEN RIGHT BUTT LINE 22 TO LEFT BUTT LINE 22. REMOVED AND REPLACED TRANSITION PANEL ASSEMBLY PER SRM 51-40-02.SDR AALA202211187120Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON SHIELD LOCATED BETWEEN 767 AND 787 AND STR 28R. REMOVED AND REPLACED SHIELD PER SRM 51-00-05-1.SDR SWAA2022111664281Scuff Plate · crackedCRACKED SCUFF PLATE THRESHOLD IN THE FWD CARGO COMPARTMENT. REPAIRED THE SCUFF PLATE THRESHOLD IAW SRM 53-30-15-2R-1, REPAIR 1, PARAGRAPH 4.C, STEPS 2 & 4 - 7 AND BAC 5975.SDR SWAA2022111564429Intercostal · crackedCRACKED INTERCOSTAL BS 344-360, BL 0, WL 208. REMOVED AND REPLACED IAW SRM 51-10-02-0G-0, PAR 9 C.SDR SWAA2022111564423Intercostal · crackedCRACKED INTERCOSTAL BS 344-360, LBL 11, WL 208. REMOVED AND REPLACED IAW SRM 51-10-02-0G-0, PAR 9.C.SDR SWAA2022111564424Intercostal · crackedCRACKED INTERCOSTAL STA 344-360; RBL 12; WL 208. NO ALLOWABLE LIMITS FOUND ON SRM. REMOVED AND REPLACED IAW SRM 51-10-02-0G-0 PAR 9.C.SDR SWAA2022111564105Angle · brokenFWD CARGO BAY SEAL DAM ANGLE BROKEN AT BS500I RBL23 WL156. REMOVED FCB SEAL DAM ANGLE IAW SRM 51-40-02-0G-0. LOCATED, DRILLED AND INSTALLED SEAL ANGLE IAW SRM 51-40-02-0G-0; SRM 51-40-05-0G-0; DWG 143A7904.SDR SWAA2022111564418Bracket · brokenBROKEN BRACKET BS 867, S3R. REMOVED AND REPLACED BRACKET IAW SRM 51-40-02-0G-0 AND DWG 146A7901 REV-.
Back to JASC 5320