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 SWAA2023013081180Angle · crackedCRACK ANGLE - CLIP ON BS 400 AT LEVEL STR 26L AT FWD CARGO COMPARTMENT 2022-691708<[01] REPLACED ANGLE - CLIP LOCATED ON BS 400 AT LEVEL STR 26L AT FWD CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 ;SRM 51-10-02 PARAGRAPH 9 AND DWG 143A7505 SHEET 81 REV- .SEE INSDR SWAA2023013081174Support Channel · corrodedCORROSION CHANNEL SUPPORT ZEE BTW BS 500 TO BS 500D AT LEVEL STR 26L AND WL 154.5 AT FWD CARGO COMPARTMENT 2022-691703<[01] REPLACED SUPPORT ZEE BTW BS 500 TO BS 500D AT LEVEL STR 26L AND WL 154.5 AT FWD CARGO COMPARTMENT IAW B737-700 SRM 51-40-02; SRM 51-10-0SDR SWAA2023013081176Support Channel · corrodedCORROSION CHANNEL SUPPORT ZEE BTW BS 500A TO BS 500D AT LEVEL STR 26R AND WL 154.5 AT FWD CARGO COMPARTMENT 2022-691699<[01] REPLACED CHANNEL SUPPORT ZEE BTW BS 500A TO BS 500D AT LEVEL STR 26R AND WL 154.5 AT FWD CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 ;SSDR HNAA2023011700029Floor Support · corrodedE949909 - CORROSION ON LH OTBD # 2 FLOOR SILL .... RAR LH OUTBD #2 FLOOR SILL IAW EMB 145 SRM 51-40-02SDR FDEA2023013250090Splice Strap · corrodedCTR CARGO COMPT BILGE AREA, EXFOLIATED CORROSION ON LONGERON SPLICE STA 5-55 L-48 RT. REMOVED AND REPLACED SPLICE STRAP REF DWG AEA7653. ORIG SUBMISSION DATE: 1/13/2023SDR SCNA20230110030Strap · corrodedDEFECT TC 532400000 NR 00314: CORROSION OUT OF LIMITS ON LOWER STRAP BS 840-860 RBL 20 WL 160 (DOOR SURROUND STRUCTURE PSE) RESOLUTION: CORROSION ON LOWER STRAP BS 840-860 RBL 20 FOUND TO BE OUT OF LIMITS IAW SRM 53-60-15-1A-1 PAR 4 F-1 REMOVED AND REPLACED SDR SCNA20230110026Web · corrodedDEFECT JC 802558 NR 00310: WEB ASSY BS 847-857 RBL 20 WL 160 UNDER SHIELD FWD OF CARGO DOOR. RESOLUTION: CORROSION ON WEB ASSY BS 847-857 RBL 20 WL 160 FOUND TO BE OUT OF LIMITS IAW SRM 53-60-15-1A-1. REMOVED WEB ASSY IAW SRM 51-40-02-0G-0. INSTALLED NEW WEBSDR SCNA20230109025Web · corrodedAFT CARGO WEB ASSY UNDER SHIELD FWD OF CARGO DOOR AT STA 787-784 RBL 20 WL 160 HAS CORROSION AROUND FASTENERS HOLES. CORROSION ON WEB FOUND TO BE OUT OF LIMITS STA 787 TO 794 RBL 20 WL160 IAW SRM 53-60-15-1B-1. REV 77. REMOVED WEB ASSY IAW SRM 51-40-02-06-0 RSDR SWAA2023010981336Angle · corrodedAFT CARGO RIGHT SIDE TRANSITION ANGLE STA 727 J TO 747 HAS CORROSION. AFT CARGO RIGHT SIDE TRANSITION ANGLE STA 727 J TO 747. ACCOMPLISHED REMOVED AND REPLACED ON FAULT # TTG8QOOGKXZS LINE #1530SDR SWAA2023010681238Depressor · crackedCRACKED BS 294.5 LOWER DEPRESSOR, S17R. REPLACED THE DEPRESSOR IAW SRM 51-40-02, 51-10-02, AND DWG 141A8370, REV D.SDR HNAA2023010300007Floor Support · corrodedCORROSION ON LT OTBD NR 2 FLOOR SILL. R & R THE FLOOR SILL IAW SRM 51-40-02.SDR SWAA2022122980838Cap · crackedAFT CARGO COMPARTMENT FLOOR CAPSTRIP AT RBL 21, BS 787, FOUND CRACKED. A NEW FLOOR CAPSTRIP WILL BE INSTALLED ON TTG8Q004DTJR.SDR FDEA202212133024Floor Support · corrodedBS 1741 LBL 80 FLOOR SUPPORT CORRODED REMOVED CORRODED FLOOR SUPPORT AT STA 1741 LBL 80 AND INSTALLED SERVICEABLE FLOOR SUPPORT AFA 3853-9 PER DWG AFA 3853 AND SRM 51-33-01-0G.SDR FDEA202212133023Floor Support · corrodedMAIN DECK -- BS 1661 LBL 80 FLOOR SUPPORT CORRODED REMOVED CORRODED FLOOR SUPPORT AT STA 1661 LBL 80 AND INSTALLED SERVICEABLE FLOOR SUPPORT AFA 3853-5 PER DWG AFA 3853 AND SRM 51-33-01-0G.SDR JJBA20221222016Gusset · corrodedCF4, LH GUSSET CORRODED BTW FRAME 59-61. CORROSION ON LH GUSSET FR 59-61 BLENDED AND FOUND OUT OF LIMIT. LH GUSSET BTW FR59 AND 61 REPLACED. CUT OUT PERFORMED AT 2X ANCHOR NUT LOCATION. LH OMEGA BEAM REPAIRED AT 2X ANCHOR NUT LOCATION WITH HAT SECTION REPAIR.SDR AALA202212229381Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN INTERCOSTAL LOCATED AT BS 947 AND RBL 50. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR A6WA202212138418Plate · corrodedSERVICE DOOR THRESHOLD PROTECTOR (P/N; 601R38957-31) CORRODED INBD LOWER SURFACE. AIRCRAFT REMOVED FROM SERVICE. REPLACED SERVICE DOOR THRESHOLD PROTECTOR PER SRM 51-41-02 PAR 7SDR DALA2022121508125Support · damagedTHE R-1 DOOR CUTOUT GIRT BAR SUPPORT BACKUP FITTINGS SUPPORT WEB IS DAMAGED. REPLACED SUPPORT REF DWG 9957828.SDR A6WA202212138407Angle · crackedCRACKED MLG WHEEL BAY WEB, FWD OF OUTBOARD SIDE AT BS 409+128 ON THE AFT SPAR. AIRCRAFT REMOVED FROM SERVICE. REMOVED AND REPLACED THE ANGLE IAW EA AWAC-CRJ253-01913, REV IR.SDR A6WA202212138409Strap · out of positionPREVIOUS REPAIR ON PASSENGER DOOR FRAME 310 .0 DAMAGE FROM INPROPER DOOR CLOSING. AIRCRAFT REMOVED FROM SERVICE. INSTALLED NEW REPAIR STRAP 601R-53-22-033-1 IAW REO 601R-53-22-033 REV -D DATE 2014/02/17 REPAIR TYPE 1 FOR FASTENER CALL OUTSDR SWAA2022121380907Attach Bracket · crackedFWD RH ATTACH BRACKET FOR PANEL 192F CRACKED / [01] R&R FWD RH ATTACH BRACKET FOR PANEL 192F PER AMM 53-12-12.;[02] R&R FWD RH ATTACH BRACKET FOR PANEL 192F PER AMM 51-40-02.;[03] R&R FWD RH ATTACH BRACKET FOR PANEL 192F PER SRM 51-40-02;[04] REMOVED AND REPLASDR SWIA2023011967124Striker · dented* PASSENGER DOOR AFT SEAL STRIKER DENTED NEAR UPPER END. REPAIED PASSENGER DOOR AFT SEAL STRIKER NEAR UPPER END IAW REO 601R-53-22-033, REV -D,SDR SCNA20230110027Web · corrodedDEFECT TC 532400000 NR 00288: AFT CARGO LOWER MAIN SILL WEB AT STA 787-847 RBL 20 WL 158 HAS CORROSION AROUND MULTIPLE FASTENER HOLES (MARKED). RESOLUTION: CORROSION ON AFT CARGO LOWER MAIN SILL WEB FOUND TO BE OUT OF LIMITS IAW 53-60-15-1A-1 STEP 4-6-2-B, REMSDR SWAA2022122980866Shield · elongatedELONGATED HOLE OF SHIELD LOCATED ON AFT DOOR CUTOUT BTW BS847 AND BS867 AT LEVEL OF STRG25R WL156.4 AND RBL21 AT AFT CARGO COMPARTMENT 2022-688516<[01] REPLACED NEW SHIELD LOCATED ON AFT DOOR CUTOUT BTW BS847 AND BS867 AT LEVEL OF STRG25R WL156.4 AT AFT CARGO SDR AALA202212289827Angle · corrodedAIRCRAFT IN BASE MAINTENANCE. RIGHT TRANSITION ANGLE HAD CORROSION, BS 500A-500G+9, RBL 24. INSTALLED A NEW ANGLE.SDR SWAA2022122080836Scuff Plate · crackedAFT CARGO DOOR CORNER SCUFF PLATE FWD POSITION CRACKED AT ATF CORNER<[01] ACCOMPLISHED WELDING REPAIR AT AFT CARGO COMP. FWD CORNER SCUFF PLATE BY OUTSIDE VENDOR WITH PO.#413972 PER B737-700 SRM 53-60-15-2R-1 STEP B-4 AND BAC 5975. THIS SCUFF PLATE WILL BE INSSDR CALA2022121403390Beam · corrodedMAIN CABIN FLOOR STRUCTURE. BEAM AT Y765 CORRODED AT FR68 AND FW D OF FR70. () REMOVED AND REPLACED NEW BEAM PART# D534721922000 BATCH# 0003916 319 AT Y765 IAW SRM 51-42-11-001 EMP#: V914954 WORK ACC0MPLISHED AT ST ENGINEERING OF MOBILE AT BFM ON NR#: 48024SDR JR2R20221212287Support · corrodedRH SILL BETWEEN FR88 AND FR90 CORRODEDSDR JR2R20221212288Gusset · corrodedGUSSET AT FR90 AND RBL24 CORRODEDSDR JR2R20221212290Shear Panel · corrodedCENTER SHEAR PANEL BETWEEN FR87 AND FR88 CORRODEDSDR JR2R20221212298Gusset · corrodedGUSSET AT FR90 AND LBL11 CORRODEDSDR JR2R20221212291Gusset · corrodedGUSSET AT FR90 AND RBL 11 CORRODEDSDR JR2R20221212297Gusset · corrodedGUSSET AT LBL 11 AND FR89 CORRODEDSDR JR2R20221212294Gusset · corrodedGUSSET AT RBL11 AND FR89 CORRODEDSDR JR2R20221212289Shear Panel · corrodedRH SHEAR PANEL DOUBLER BETWEEN FR87 AND FR88 CORRODEDSDR JR2R20221212293Gusset · corrodedDOUBLER ON FRAME 90A AND RBL11 CORRODEDSDR AALA202302010882Coupling · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT AFT PASSENGER / CREW DOOR CUT OUT LOWER SILL UPPER COUPLING AT FR 66 AND S23R. MAINTENANCE REPLACED COUPLING PER SRM 51-42-11.SDR SWAA2023013080567Gusset · crackedCRACK GUSSET LOCATED BS500D AND STR19L FWD CARGO COMPARTMENT 2022-691590<[01] REPLACED GUSSET LOCATED BS500D AND STR19L FWD CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 AND SRM 51-10-02 PARAGRAPH 9 DWG 143A7902 SHEET 209 REV-.SDR SWAA2023013080569Gusset · crackedCRACK GUSSET LOCATED BS500D AND STR19R FWD CARGO COMPARTMENT 2022-691592<[01] REPLACED GUSSET LOCATED BS500D AND STR19R FWD CARGO COMPARTMENT IAW B737-700 SRM 51-10-02 PARAGRAPH 9; SRM 51-40-02 AND DWG 143A7902 SHEET 209 REV- .SDR HNAA2023011700028Floor Support · corrodedCORROSION ON LH OTBD # 3 FLOOR SILL .... REMOVED AND REPLACED LH OUTBOARD #3 FLOOR SILL IAW EMB 145 SRM 51-20-03, 51-40-02 AND 51-40-09.SDR HNAA2023011700027Floor Support · corrodedLEFT CABIN FLOOR SUPPORT NR 7 IS CORRODED. R & R LT CABIN FLOOR SUPPORT NR 7 IAW SRM 51-40-02.SDR HNAA2023010300005Floor Support · corrodedLEFT CABIN FLOOR SUPPORT NR 7 WAS CORRODED. R & R THE FLOOR SUPPORT IAW SRM 51-40-02.SDR AALA202212281805Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: LEFT TRANSITION PANEL HAS CORROSION LOCATED AT STA 490 AND 500G+9 AND STR 25L. REMOVED AND REPLACED TRANSITION PANEL.SDR AALA202212216508Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN LEFT HAND FLOOR SUPPORT INTERCOSTAL LOCATED AT BS 957 LBL 48. REPLACED INTERCOSTAL PER AARD 51-00-05-1 AND DWG 147A5650.SDR YENA2022121501250Doubler · corrodedDURING HEAVY MAINTENANCE: REF TOMX W/O NR 00031. AFTER CLEANING THE AREA IN REFERENCE TO NRC 00022, CORROSION IN THE INTERNAL DOUBLER OF THE WASTE WATER PANEL WAS FOUND; REF TOMX W/O 2088 NR 00031. THE CUTOUT STRUCTURE AT WASTE SERVICE PANEL WAS REPAIRED PER SDR SWAA2023010980151Plate · corrodedFWD CARGO; L/H SIDE PLATE HAS CORROSION AROUND FASTENER HOLES AT BS500A - BS500B<[01] REMOVAL;FABRICATION AND INSTALLATION OF LEFT TRANSITION ANGLE FROM 480+8 TO 500I WILL BE ACCOMPLISHED ON TTG8Q00GKCY5.SDR SWAA2023010980377Floor Support · corrodedAFT CARGO STA 772 FLOOR SUPPORT HAS CORROSION AROUND NUT PLATE HOLES.<[01] OBTAINED NEW PART. WILL BE INSTALLED ON CARD TTG8Q00GAQME.SDR SWAA2023010980132Plate · corrodedFWD CARGO; R/H SIDE PLATE HAS CORROSION AROUND FASTENER HOLES AT BS500A - BS500B<[01] REMOVED DAMAGE PER SRM 51-10-02 AND FOUND TO BE OUT OF LIMITS PER SRM 53-00-53-1A-2. REMOVED RH TRANSITION ANGLE FROM STA 500 A TO STA 500 I PER SRM 51-40-02.;[02] ADD TOOL;[SDR SWAA2023010980149Plate · corrodedFWD CARGO; L/H SIDE PLATE HAS CORROSION AROUND FASTENER HOLES AT BS500+5 - BS500+17<[01] REMOVED DAMAGE PER SRM 51-10-02 AND FOUND TO BE OUT OF LIMITS PER SRM 53-00-53-1A-2. REMOVED L H TRANSITION ANGLE FROM STA 480+8 TO STA 500I PER SRM 51-40-02.;[02] FABRICASDR SWAA2023010980368Angle · corrodedAFT CARGO RIGHT SIDE TRANSITION ANGLE STA 727 E TO 727 F HAS CORROSION.<[01] AFT CARGO RIGHT SIDE TRANSITION WILL BE INSTALLED IN REFERENCE TO TASK TTG8Q00GKXZS.;[02] CERTIFIED;[03] UPDATED FOR CLARIFICATION. AFT CARGO RH TRANSITION ANGLE CORROSION OUT OF LIMI
Back to JASC 5320