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 SWAA2021111731584Intercostal · crackedENG 2 O/B FAN COWL INTERCOSTAL CRACKED. REMOVED AND REPLACED INTERCOSTAL AT NR 2 ENGINE O/B FAN COWL IAW SRM 51-40-02-0G-0.SDR SWAA2021111531022Scuff Plate · crackedCRACK FWD CORNER SCUFF PLATE AT AFT CARGO COMPARTMENT ; 2021-466316 / [01] EVALUATED FWD CORNER SCUFF PLATE AT AFT CARGO COMPARTMENT FOUND CRACK ( 1 EA )L=0.5820 INCH. CRACK MUST BE REPAIRED BY WELDING IAW BOEING 737-700 SRM 53-60-15-2R-1; REPAIR 1. PARAGRAPH SDR SWAA2021111531785None · crackedCRACK ANGLE FLOOR STRUCTURE BETWEEN BS 685 TO BS 706 AT LEVEL RBBL 0.07 CENTER SECTION ; 2021-462040 / [01] REPLACED ANGLE FLOOR STRUCTURE BETWEEN BS 685 TO BS 706 AT LEVEL RBBL 0.07 CENTER SECTION IAW DWG 273A9112 REV-AND SRM B737 51-10-02 ITEM 9; [02] CORRECSDR SWAA2021111531786Structure · crackedCRACK ANGLE FLOOR STRUCTURE BETWEEN BS 685 TO BS 706 AT LEVEL RBBL 24.5 CENTER SECTION ; 2021-462041 / [01] TOOL USED: TEMPERATURE CONTROLLER: P/N: P3015GOES00000; S/N: 112031023; DUE DATE: 22-JAN-22; TEMPERATURE CONTROLLER: P/N: 38615K71; S/N: AE-40585; DUE DSDR SWAA2021111531696Gusset · crackedCRACK GUSSET LOCATED BS500D AND STR19R FWD CARGO COMPARTMENT ; 2021-490179 / [01] REPLACED GUSSET AND FASTENERS LOCATED BS500D AND STR19R FWD CARGO COMPARTMENT IAW B737-700 SRM 51-40-02; 51-10-02 ITEM 9 AND DWG: 143A7902 SHEET:174 REV - SEE INDIVIDUAL SIGNOFFSSDR SWAA2021110531142Fitting · crackedFITTING CRACKED FOR THE AFT CARGO VACUUM WASTE TANK ENCLOSURE SUPPORT INSTL STA 947.5 LBL 10 ; / [01] REMOVED AND INSTALLED NEW FITTING IAW SRM 51-40-02.; [02] INSPECTEDSDR REXA2021110400909Frame · corroded"FRAME AT FS 319 CORRODED BETWEEN STGR 19L AND STGR 25R.
" "REPLACED FRAME A FS319 IAW SRM 53-00-00-101-001-A01
51-42-06-001-001-A01, 53-00-06-201-006-A01 & APPLIED CIC IAW
SRM 51-21-11-001-001-A01.
WVAC EMP # 60SDR REXA2021110400896Channel · corroded"TCAS ANTENNA, LOWER CHANNEL CORRODED BETWEEN FS 295 AND FS 310 AT
STGR 27.
" "LOCATED, DRILLED, AND INSTALLED NEW TCAS CHANNEL IAW CRJ 900 SRM
51-40-11-001-001-A01, 51-42-06-001-001-A01, AND 51-SDR IPXA2021103075466Stiffener · crackedINSPECTION TYPE:4CAFT CARGO VERTICAL STIFFENER AT STA 1841 & X= 25.0 IS CRACKED.REMOVED AND REPLACED CRACKED AFT CARGO VERTICAL STIFFENER AT STA 1841 & X= 25.0 IAW SRM 51-33-01. (MINOR)SDR SWAA2021102831873Intercostal · crackedCRACK NOTED IN RADIUS OF LATERAL INTERCOSTAL AT BS 270; NEAR BL 0; .5' L; BELOW FLOOR LINE. BLENDED FWD SIDE OF LATERAL INTERCOSTAL AT BS 270 CRACK LOCATION IAW SRM 51-10-02-0G-0. UT MEASURED IAW B737 NDT P4 51-00-00 P2. FOUND .050' ORIG; .029' REM; .021'SDR SWAA2021102831258Shield · corrodedCORROSION ON AFT SHIELD AT AFT CARGO BAY BS847 - BS867 RBL21 WL164 LOWER SURFACE. FOUND TO BE OUT OF LIMITS IAW SRM 51-10-02-0G-0 PAR. 9C. LOCATED AND DRILLED A NEW SHILD IAW SRM 51-40-05-OG-0 AND DWG 146A8127. INSTALLED NEW SHIELD ON ACB AFT BS 847- BS 86SDR SWAA2021102531675Panel · crackedFWD CARGO PANEL JUST AFT OF DOOR RIGHT SIDE P/N 453A1200-156 122ZCC HAS 4' HORIZONTAL CRACKPERFORMED INTERM REPAIR PER EA 21-150-01357. EVERY 8 DAYS PERFORM A DETAILED VISUAL INSPECTION OF THE REPAIRD AREA FOR ADDITIONAL DAMAGE AND REPAIR INTEGRITY. IF FURTHERSDR FDEA202110192576Retainer · crackedR/H W/W L/E CUTOUT STA 1070-1090 SEAL RETAINER CRACKED REMOVED AND REPLACED PER DWG # 149N6016 REV BSDR AALA202110201413Coupling · elongatedAIRCRAFT IN BASE MAINTENANCE ELONGATE HOLE IN INBOARD UPPER FLOOR BEAM COUPLING LOCATED ON FR 63 AT LEVEL OF S23L, Y1292. REPLACED COUPLING PER SRM 51-42-11-801 AND EA 331166.SDR AALA202110201647None · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND AFT PASSENGER / CREW DOOR CUT OUT LOWER SILL CENTER FITTING BETWEEN FR 66 AND FR 68 AT S23L. REPLACED CENTER FITTING PER SRM 51-72-11.SDR CALA2021102001928None · noneTRANSCRIBED FROM ECRA 5311-02651 HAECO GSO NR 9284641. PLANNING TO CONTACT ENGINEERING AFTER 15-JAN-2023 BUT BEFORE 15-FEB-2023 AND REQUEST THAT UPDATED INSPECTION INSTRUCTIONS BE PROVIDED FOR ECRA 5311-02651. PLANNING TO CONTACT ENGINEERING AFTER 15-JAN-2023 SDR SWIA202201063648Floor Support · corrodedRH FLOOR SILL CORRODED BETWEEN FS349 TO FS364. (C CHECK RO 01-05-2022) ACCOMPLISHED A PERMANENT REPAIR IAW MHIRJ REO 670-53-21-2174 REV A DATED 2021-11-29. NO SIGNIFICANT CHANGE TO WEIGHT AND BALANCE, TASK CARD 51-900-1002-SKY AND M-337 COMPLETED AND ATTASDR REXA2021120701079Seat Track · corrodedRH SIDE SEAT TRACK HAS MULTIPLE SPOTS OF CORROSION FROM FS881-FS969. C/A: REMOVED AND REPLACED SEAT RAIL IAW CRJ 900 SRM 53-31-49-101-001-A02, 53-00-49-201-001-A02, 51/40/11/001/001/A01 AND AMM 53-00-49-000/400-801-A01.SDR REXA2021120701078Seat Track · corrodedRH SIDE SEAT TRACK FROM FS847+32-FS881 HAS AREAS OF CORROSION. C/A: REMOVED AND REPLACED SEAT RAIL IAW CRJ 900 SRM 53-31-49-101-001-A02, 53-00-49-201-001-A02, 51/40/11/001/001/A01 AND AMM 53-00-49-000/400-801-A01.SDR REXA2021120701076Seat Track · corrodedRBL 9 SEAT TRACK FROM FS838-847+54 HAS AREAS OF CORROSION. C/A: REMOVED AND REPLACED SEAT RAIL IAW CRJ 900 SRM 53-31-49-101-001-A02, 53-00-49-201-001-A02, 51/40/11/001/001/A01 AND AMM 53-00-49-000/400-801-A01.SDR REXA2021120701075Seat Track · corrodedLBL 9 SEAT TRACK FROM FS838-847+54 HAS AREAS OF CORROSION. C/A: REMOVED AND REPLACED SEAT RAIL IAW CRJ 900 SRM 53-31-49-101-001-A02, 53-00-49-201-001-A02, 51/40/11/001/001/A01 AND AMM 53-00-49-000/400-801-A01.SDR REXA2021120701071Seat Track · corrodedLH SIDE SEAT RAIL FS483-565 HAS CORROSION, TOOLING MARKS AND CORRODED FASTENERS. C/A: REMOVED AND REPLACED SEAT RAIL IAW CRJ 900 SRM 53-31-49-101-001-A02, 53-00-49-201-001-A02, 51/40/11/001/001/A01 AND AMM 53-00-49-000/400-801-A01.SDR REXA2021120701068Seat Track · corrodedRH SIDE SEAT RAIL FS483-565 HAS CORROSION, TOOLING MARKS AND CORRODED FASTENERS. C/A: REMOVED AND REPLACED SEAT RAIL IAW CRJ 900 SRM 53-31-49-101-001-A02, 53-00-49-201-001-A02, 51/40/11/001/001/A01 AND AMM 53-00-49-000/400-801-A01.SDR SWAA2021112330766Support Angle · crackedCRACK SUPPORT ANGLE LOCATED BETWEEN BS 380-400, BL0. REPLACED SUPPORT ANGLE IAW SRM 51-10-02 AND DRAWING 143A5300 REV D.SDR SWAA2021112242213Gusset · crackedCRACK GUSSET LOCATED STA 540D AND STR 19L FWD CARGO COMPARTMENT ; 2021-486450 / [01] TOOL USED CALIPER P/N=500-197-30; S/N=A21042060; DUE DATE=11/AUG/22.; [02] EXACTLY LOCATION OF GUSSET IS BS 500D AND STR 19L FWD CARGO COMPARTMENT; REPLACED GUSSET LOC BS 500DSDR SWAA2021111730939Channel · corrodedCORROSION ON AFT CARGO COMPARTMENT R/H FLOOR SUPPORT Z CHANNEL NUTPLATES BETWEEN BS 767 & 787. REMOVED CORROSION IAW SRM 51-10-02-0G-0. PERFORMED UT THICKNESS INSP. ON REWORKED AREA IAW NDT PART 4 51-00-00 PROC. 3. MIN THICKNESS .028'. EVALUATED REWORKED SDR SWAA2021111730941Support · corrodedCORROSION ON AFT CARGO BAY BILGE FRAME SUPPORT UPPER FLANGE BS 787, S26R. REMOVED CORROSION IAW SRM 51-10-02-0G-0. EVALUATED REWORKED AREA ORG MAT 0.088 MAT REMOVED 0.042 MAT REMAINING 0.046 FOUND TO BE OUT OF LIMITS IAW B737-7 SRM 53-00-53-1A-2 REMOVED AT ASDR SWAA2021110131209Gusset · crackedFWD CARGO COMPARTMENT STA 500D STR 19R GUSSET CRACKED ; / [01] REMOVED GUEEST AT BS 500D S-19R IAW SRM 51-40-02-0G-0; [02] VERIFY NEW PART PART NO.143A9481-5 LOCATED AND DRILLED GUSSET IAW SRM 51-40-05; [03] ITEM 2 SHOULD STATE VERIFIED NEW P/N 143A9481-5 IAW SDR REXA2021122001154None · corrodedL/H SIDE SEAT RAIL HAS CORROSION AROUND FASTENERS AT FS 897.70, CORRODED FASTENERS AND SCRATCH MARKS. C/A: REMOVED AND REPLACED LH SIDE SEAT RAIL AT FS 897.70 IAW CRJ 900 AMM 53-00-49-000-801-A07 AND 53-00-49-400-801-A07.SDR REXA2021120701112Seat Track · corrodedL/H SIDE SEAT RAIL HAS CORROSION AROUND FASTENERS AT FS 897.70, CORRODED FASTENERS AND SCRATCH MARKS. C/A: REMOVED AND REPLACED LH SIDE SEAT RAIL AT FS 897.70 IAW CRJ 900 AMM 53-00-49-000-801-A07 AND 53-00-49-400-801-A07.SDR REXA2021120701089Seat Track · corrodedCORROSION ON FLOOR SEAT TRACK AT RBL 9 FROM FS 581.0 TO FS 661+32. C/A: REMOVED AND REPLACED SEAT TRACK IAW CRJ 900 AMM 53-00-49-000/400-801-A19.SDR REXA2021120701066Seat Track · corrodedCORROSION ON FLOOR SEAT TRACK AT RBL 9 FROM FS 581.0 TO FS 661+32. C/A: REMOVED AND REPLACED SEAT TRACK IAW CRJ 900 AMM 53-00-49-000/400-801-A19.SDR SWAA2021112331075Scuff Plate · crackedCRACK FWD CORNER SCUFF PLATE AT AFT CARGO COMPARTMENT ; 2021-486397 / [01] TOOL USED DIGITAL CALIPER P/N:500-197-30;S/N:B20189510;DUE DATE:23-NOV-21.; [02] REPAIRED FWD CORNER SCUFF PLATE AT AFT CARGO COMPARTMENT IAW BOEING 737-700 SRM 53-60-15-2R-1 REPAIR 1 ASDR REXA2021111700992Stringer · corrodedSTRINGER 25R CORRODED BETWEEN FS 319 TO 333. - REMOVED STRINGER 25R AND 3EA CLIPS, 2EA STANDOFFS AT FS 280.00 TO FS 333, LOCATED AND DRILLED NEW STR 25R AND INSTALLED NEW STRINGER 25R PN:SH670-31212-2U, AND SAME SERVICEABLE 3EA CLIPS AND 2EA STANDOFFS, IAW CRJSDR REXA2021111700981Seat Track · corrodedR/H SIDE SEAT RAIL FS 744-752 HAS CORROSION ON MULTIPLE SPOTS. - REMOVED RH SIDE SEAT RAIL AT FS 744-FS 752 AND INSTALLED NEW SERVICEABLE SEAT RAIL IAW CRJ 900 AMM 53-00-49-000/400-801-A07. WVAC EMP # 56689SDR REXA2021111700976Seat Track · corrodedR/H SIDE SEAT RAIL FS 379-485 HAS CORROSION ON MULTIPLE SPOTS. - REMOVED RH SEAT RAIL IAW CRJ 900 AMM 53-00-49-00-801, SRM RAIL OUT OF LIMITS PER SRM 53-21-49-101-001-A01 AND INSTALLED NEW SEAT RAIL IAW AMM 53-00-49-400-801-A07 WVAC EMP # 56689SDR REXA2021111600952Stringer · corrodedSTRINGER 26R CORRODED BETWEEN FS 294-FS 310 - DAMAGE OUT OF TOLERANCE IAW SRM 53-21-03-101-002-A04. DRILLED NEW STR IAW SRM 51-40-11-001-001-A01 INSTALLED STR AND STR SPLICE IAW 51-42-06-001-001-A01 AND 51-42-21-001-001-A01 WVAC EMP # 56689SDR AALA202111160095Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: AFT GALLEY AREA CRACKED SHEAR PLATE LOCATED FROM FR 69 TO FR 70 AT S23L. REPLACED SHEAR PLATE PER SRM 51-72-11-911-001, SRM 51-42-11-801 AND DWG D53470100.SDR AALA202111161283Dummy Rail · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD GALLEY AREA RAIL DUMMY LOCATED AT LEVEL FR 16 AND Y503.2. REPLACED RAIL DUMMY PER SRM 51-72-11-911-001 AND DRAWING D53112825.SDR SWAA2021111530636Panel · brokenBROKEN BULKHEAD PANEL 142NWB AT AFT CARGO COMPARTMENT ; 2021-490055 / [01] REPLACED BULKHEAD PANEL 142NWB AT AFT CARGO COMPARTMENT IAW B737-700 AMM 25-52-01-201-801 PART USED # 453A2510-1 BATCH # 2021 214571; [02] REPLACED BULKHEAD PANEL 142NWB AT AFT CARGO COSDR AALA202111307286Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION MEASURING L= 0.0320 IN. W= 0.2060 IN. D= 0.002 IN. ON BULK CARGO COMPARTMENT LOWER DOOR SILL LOCATED AT FR62 AND S38R. REPAIRED SILL PER EA 331982.SDR SWAA2021111531167None · corrodedLH TRANSITION ANGLE HAS CORROSION AROUND FASTENER HOLE UPPER SURFACE AT STA 727E+14 ; / [01] COMPLIED WITH TOOL REQUIREMENT.; [02] REMOVED SURFACE CORROSION FOUND TO BE OUT OF LIMITS PER SRM 53-60-51-1A-1. REMOVE AND REPLACE ANGLE ON TASK CARD 5360-E-16462-NG SDR SWAA2021111530902None · corrodedCORROSION WEB - INTERCOSTAL LOCATED BETWEEN BS 767 TO BS 794.3 STR 25R WL 156 RBL2184 AT AFT CARGO COMPARTMENT ; 2021-461994 / [01] REPLACED WEB - INTERCOSTAL LOCATED BETWEEN BS 767 TO BS 794.3 STR 25R WL 156 RBL 21.84 AT AFT CARGO COMPARTMENT IAW B737-700 SRMSDR SWAA2021111530901Support · corrodedCORROSION SUPPORT ZEE LOCATED BETWEEN BS 727 TO BS 767 STR 25R WL156 RBL21.84 AT AFT CARGO COMPARTMENT ; 2021-461993 / [01] REPLACED SUPPORT ZEE LOCATED BETWEEN BS 727 TO BS 767 STR 25R WL156 RBL21.84 AT AFT CARGO COMPARTMENT IAW B737-700 SRM 51-10-02 ITEM 9; SDR SWAA2021111530903None · corrodedCORROSION SUPPORT ZEE LOCATED BETWEEN BS 727 TO BS 847 STR 25L WL156 LBL21.84 AT AFT CARGO COMPARTMENT ; 2021-461995 / [01] REPLACED SUPPORT ZEE LOCATED BETWEEN BS 727 TO BS 847 STR 25L WL156 LBL21.84 AT AFT CARGO COMPARTMENT IAW B737-700 SRM 51-10-02 ITEM 9; SDR SWAA2021111531180None · corrodedLH TRANSITION ANGLE HAS CORROSION AROUND FASTENER HOLE UPPER SURFACE AT STA 727E+10 ; / [01] COMPLIED WITH TOOL REQUIREMENT.; [02] REMOVED SURFACE CORROSION FOUND TO BE OUT OF LIMITS PER SRM 53-60-51-1A-1. REMOVE AND REPLACE ANGLE ON TASK CARD 5360-E-16462-NG SDR SWAA2021111531181None · corrodedLH TRANSITION ANGLE HAS CORROSION AROUND FASTENER HOLE UPPER SURFACE AT STA 727E+18 ; / [01] COMPLIED WITH TOOL REQUIREMENT.; [02] REMOVED SURFACE CORROSION FOUND TO BE OUT OF LIMITS PER SRM 53-60-51-1A-1. REMOVE AND REPLACE ANGLE ON TASK CARD 5360-E-16462-NG SDR SWAA2021111531179None · corrodedLH TRANSITION ANGLE HAS CORROSION AROUND FASTENER HOLE UPPER SURFACE AT STA 727E+6 ; / [01] COMPLIED WITH TOOL REQUIREMENT.; [02] REMOVED SURFACE CORROSION FOUND TO BE OUT OF LIMITS PER SRM 53-60-51-1A-1. REMOVE AND REPLACE ANGLE ON TASK CARD 5360-E-16462-NG (SDR SWAA2021111531182None · corrodedLH TRANSITION ANGLE HAS CORROSION AROUND FASTENER HOLE UPPER SURFACE AT STA 747+2 ; / [01] COMPLIED WITH TOOL REQUIREMENT.; [02] REMOVED SURFACE CORROSION FOUND TO BE OUT OF LIMITS PER SRM 53-60-51-1A-1. REMOVE AND REPLACE ANGLE ON TASK CARD 5360-E-16462-NG (CSDR REXA2021110400928Stringer · corrodedSTR 27 FS 310-333 IS CORRODED AROUND FASTENERS. "REPLACED STR 27 FS 310-333 & APPLIED CIC IAW SRM 51-42-06-011-
001-A01 & 51-21-11-001-001-A01. WVAC EMP #6027
"
Back to JASC 5320