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 REXA2022082100677Support · corrodedNLG JACK FITTING SUPPORT INTERCOSTALS ARE CORRODED LOCATED AND DRILLED NEW SERVICEABLE R/H NOSE JACK PAD INTERCOSTAL P/N CC670-32179-3 IAW CRJ 900 SRM 51-40-11-001-001-A01 AND INSTALLED IAW CRJ 900 SRM 51-42-06-001-001-A01 AND 51-42-21-001-001-A01, REPAIRED IASDR REXA2022082100676Support · corrodedNLG JACK FITTING SUPPORT INTERCOSTALS ARE CORRODED LOCATED AND DRILLED NEW SERVICEABLE L/H NOSE JACK PAD INTERCOSTAL P/N CC670-32179-3 IAW CRJ 900 SRM 51-40-11-001-001-A01 AND INSTALLED IAW CRJ 900 SRM 51-42-06-001-001-A01 AND 51-42-21-001-001-A01, REPAIRED IASDR CALA2023082102588Threshold · corrodedAFT CARGO THRESHOLD PLATE HAS CORROSION @FR57 (A3NB-05-3-6023) GENERATED AT HAECO LCQ PER NR 9296480 (36480) BY MECH V061603. REMOVED AND REPLACED AFT CARGO TORSION BOX COVER UPPER SURFACE IAW A319 SRM 51-42-11 PER MECH V942327 INSP V061704SDR CALA2023082102585Unknown · corrodedSUPPORT TASK B737-53-3-0737-AFT- AFT CABIN WET AREA CABIN R-2 DOOR THRESHOLD SUPPORT CORROED STA 947 THRU STA 990 DOTS 921-35 REF TO PEMCO NR 14093.0506. REMOVED AND REPLACED NEW CHORD INNER P/N 147A8540U8 IAW B737-800 DWG 147A8540 AND SRM 51-40-02 AT AFT CABISDR JR2R20230819795Floor Support · corrodedFLOOR BEAM LBL11 CORRODED BETWEEN FR90 THRU FR91SDR JR2R20230819794Gusset · corrodedGUSSET THAT SITS ON TOP OF FR90 AND LBL11 CORRODEDSDR JR2R20230819793Shear Panel · corrodedFLOOR WEB BETWEEN FR87 THRU FR88 AND LBL11 THRU LBL42 CORRODEDSDR JR2R20230819791Strap · corrodedFLOOR BEAM AT LBL11 CORRODED BETWEEN FR85 THR FR86SDR JR2R20230819790Gusset · corrodedGUSSET THAT SITS ON TOP OF FR90 AND LBL2 CORRODEDSDR JR2R20230819789Gusset · corrodedGUSSET THAT SITS ON TOP OF FR91 AND RBL11 CORRODEDSDR JR2R202308197878Floor Support · corrodedFLOOR BEAM AT RBL11 CORRODED BETWEEN FR90 THRU FR91SDR JR2R20230819787Floor Support · corrodedFLOOR BEAM AT RBL11 CORRODED BETWEEN FR89 THRU FR90.SDR JR2R20230819786Gusset · corrodedGUSSET THAT SITS ON TOP OF FR90 AND RBL11 CORRODED.SDR JR2R20230819782Gusset · corrodedTEXAS DOUBLER THAT SITS ON TOP FO FR90 AND RBL20 CORRODEDSDR JR2R20230819781Floor Support · corrodedRH FLOOR SILL CORRODE BETWEEN FR88 THRU FR90SDR SWAA2023092591128Intercostal · crackedCRACK ON INTERCOSTAL WEB FLOOR STRUCTURE LOCATED BTW BS 328 TO BS 344 LBL 46.5 AT FWD GALLEY AREA 2023-530675<[01] REPLACED NEW WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BTW BS 328 TO BS 344 LBL 46.5 AT FWD GALLEY AND FASTENERS IAW B737-700 SRM 51-40-02<BR>ANDSDR SWAA2023092591127Web · crackedCRACK ON INTERCOSTAL WEB FLOOR STRUCTURE LOCATED BTW BS 312 TO BS 328 LBL 46.5 AT FWD GALLEY AREA 2023-530671<[01] REPLACED INTERCOSTAL WEB FLOOR STRUCTURE LOCATED BTW BS 312 TO BS 328 LBL 46.5 AT FWD GALLEY AREA IAW SRM B737-700 51-10-02 AND DRAWING 141A5400 SDR SWAA2023092591131Structure · corrodedCORROSION ON INNER CHORD LOCATED BTW BS 312 TO BS 344 AT LEVEL STR 17R WL 208.1 RBL 59 AT FWD GALLEY AREA 2023-530683<[01] REPLACED INNER CHORD LOCATED BETWEEN BS259.50 TO BS360 RBL59 WL208.1 AT FWD GALLEY AREA. I.A.W SRM B737-700 51-40-02 AND DRAWING #140A981SDR SWAA2023092591130Angle · corrodedCORROSION ON INNER CHORD LOCATED BTW BS 312 TO BS 344 AT LEVEL STR 17L WL 208.1 LBL 59 AT FWD GALLEY AREA 2023-530681<[01] REPLACED INNER CHORD LOCATED BTW BS 277 TO BS 360 AT LEVEL STR 17L WL 208.1 LBL 59 AT FWD GALLEY AREA IAW B737-700 SRM:51-10-02 Ï¿½TEM 9 SDR SWAA2023091990427Strap · corrodedWING CENTER SECTION CORROSION ON STRAP AT BS 685+13; RBL 65; WL 204. (MARKED) CORRECTION TO FAULT NAME CORROSION IS LOCATED ON ANGLE AT BS 685+13 RBL 65 WL 204.<[01] REMOVED CORROSION ON STRAP AT BS 685+13; RBL 65; WL 204 IN AN AREA OF 0.6'X1'X0.0013' IAW SRM SDR SWAA2023091990423Floor Support · crackedWING CENTER SECTION FLOOR BEAM SUPPORT CRACKED AT BS 540; WL 208; RBL 44. (MARKED)<[01] UPDATED STEPS 1 AND 2 AND OK TO INSTALL STEP 1;[02] REMOVED AND REPLACED WING CENTER SECTION FLOOR BEAM SUPPORT AT BS 540; RBL 25 - RBL 45; WL 208 IAW SRM 51-40-02-0G-0 ANDSDR SWAA2023091990424Floor Support · crackedWING CENTER SECTION FLOOR BEAM SUPPORT CRACKED AT BS 540; WL 208; RBL 1. (MARKED)<[01] REMOVED BEAM SUPPORTON WING CENTER SECTION AT BS 540; WL 208; RBL 1 IAW SRM SRM 51-40-02;[02] UPDATED STEP 1;[03] REMOVED AND INSTALLED NEW PART 143A5240U34 FLOOR BEAM SUPPOSDR SWAA2023091990425Floor Support · crackedWING CENTER SECTION FLOOR BEAM SUPPORT CRACKED AT BS 540; WL 208; LBL 1. (MARKED)<[01] REMOVED BEAM SUPPORTON WING CENTER SECTION AT BS 540; WL 208; LBL 1 IAW SRM 51-40-02;[02] UPDATED STEP 1;[03] REMOVED AND INSTALLED NEW PART 143A5240-33 FLOOR BEAM SUPPORT OSDR SWAA2023091990429Floor Support · crackedWING CENTER SECTION FLOOR BEAM SUPPORT CRACKED AT BS 540; WL 208; LBL 44. (MARKED)<[01] REMOVED AND INSTALLED NEW PART PN 143A5240U31 FLOOR BEAM SUPPORT ON BS 540; WL 208; LBL 44 IAW 51-40-02 DWG 143A0060. AND TABLE MEASUREMENTS COMPLETED;[02] VERIFIED TASK COSDR SWAA2023091890417Sidewall Support · corrodedCORROSION AFT CARGO BAY R/H FLOOR TO SIDEWALL SUPPORT PLATE HAS MULTIPLE AREAS AROUND NUT PLATE HOLES BS727B TO BS767 RBL22 WL156<[01] VERIFIED MEASUREMENT TABLE AND TASK CARD COMPLETE.SDR SWAA2023091890412Web · corrodedCORROSION AFT CARGO BAY SUB THRESHOLD WEB MULTIPLE AREAS AROUND NUT PLATE HOLES BS794 TO BS847 RBL 26.5 WL156<[01] REMOVED AND REPLACED AFT CARGO BAY SUB THRESHOLD WEB PER SRM 51-40-02-0G-0; SRM 51-40-05-0G-0; DWG 146A8340.SDR SWAA2023090691954Intercostal · brokenPASSENGER CABIN; INTERCOSTAL (BREAK ASSY.) BROKEN AT I/B FASTENER; STA.540; RBL 24 TO BL0<[01] REMOVED AND REPLACED INTERCOSTAL PER SRM 51-40-02;[02] INSPECTION C/WSDR R61A2023090500473Shear Plate · corrodedSHEAR CLIP CORRODED ON FRAME 17 FROM CENTER LINE TO STRINGER 28R. REMOVED AND REPLACED SHEAR CLIP ON FRAME 17 FROM CENTER LINE TO STRINGER 28R REF SRM 51-40-08.SDR SWAA2023090591955Intercostal · brokenPASSENGER CABIN; INTERCOSTAL (BREAK ASSY.) BROKEN AT I/B FASTENER; STA.540; LBL 24 TO BL0<[01] REMOVED AND REPLACED INTERCOSTAL PER SRM 51-40-02;[02] INSPECTION C/W<BR>PART WAS ORDERED ON CARD TTG8Q00MXR8USDR SWAA2023090590625Floor Support · crackedCOCKPIT FLOOR STRUCTURE STA 259 - 6' RBL 5' HAS A CRACK INDICATION PER HFEC HOLE PROBE (SUSPECT THE FRAME P/N 141A5161-2 CURRENT DIA. IS .215'<[01] ACCOMPLISHED HFEC HOLE PROBE INSP PER NDT PART 6 51-00-00 PROC. 16 CRACK INDICATION REMAINS. C/W. REPAIRED PER ESDR ASAA2023081844867Transition Panel · corrodedFWD PIT R/H TRANSITION PANEL STA 500+12 TO 500F+10 HAS CORROSION. GROUNDED - YES. REMOVED DAMAGE FROM FWD PIT R/H TRANSITION PANEL IAW B737-800 SRM 53-00-53-1A-2.2.D. ORIG. THICKNESS: .040 IAW B737-800 SRM 53-30-53-IO-2. REMOVED: .006, REMAINING: .034 & IS FOUSDR ASAA2023081844866Transition Panel · corrodedFWD PIT R/H TRANSITION PANEL STA 500H+10 TO 500H+18 HAS CORROSION. GROUNDED - YES. REMOVED DAMAGE FROM FWD PIT R/H TRANSITION PANEL IAW B737-800 SRM 53-00-531A-2.2.D. ORIG. THICKNESS: .040 IAW B737-800 SRM 53-30-53-0I-2. REMOVED: .007, REMAINING: .033 & IS FOUSDR ASAA2023081844864Transition Panel · corrodedFWD PIT R/H TRANSITION PANEL STA 500B+10 TO 500C+14 HAS CORROSION. GROUNDED - YES. REMOVED DAMAGE ON FWD PIT TRANSITION PANEL @ STA 500B+10 TO 500C+14 IAW B737-800 SRM 53-00-53-1A-2.2.D. ORIG. THICKNESS: .040 IAW B737-800 SRM 53-30-53-0I-2. REMOVD: .006, REMAISDR SWAA2023083090510Scuff Plate · crackedAFT CARGO FWD CORNER SCUFF PLATE CRAKED<[01] REMOVED AND REPLACED AFT CARGO FWD CORNER SCUFF PLATE PER SRM 51-40-02SDR ASAA2023081844761Transition Panel · corrodedFWD PIT L/H TRANSITION PANEL STA 500B+18 TO 500D+10 HAS CORROSION. GROUNDED - YES. REMOVED DAMAGE FROM FWD PIT L/H TRANSITION PANEL @ STA 500B+18 - 500D+10 IAW B737-800 SRM 53-00-53-1A-2.2.D. ORIG. THICKNESS: .040 IAW B737-800 SRM 52-30-53-0I-2. REMOVED: .006 SDR AALA202308224591Doubler · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN ELECTRICAL GROUND POWER RECEPTACLE SURROUND DOUBLER LOWER FLANGE, LOCATED AT BS 230, S23R, WL 150.45. REPAIRED DOUBLER PER SRM 53-10-15-2R-4.SDR DALA2023082106778Unknown · unknown(LOG 2924579) CORROSION ON AFT CARGO COMPARTMENT INTERCOSTAL STA 767+7 RBL 20 WL 157. REMOVED AND REPLACED INTERCOSTAL BETWEEN STA 767 AND 787 R/H SIDE RBL 20 WL 157 IAW B737 SRM 51-40-02 AND BOEING DWG # 146A0081.SDR DALA2023082106776Unknown · unknown(LOG 2924560) CORROSION ON INTERCOSTAL STA 947-967 RBL 25 WL 208. REPLACED INTERCOSTAL STA 947-967 RBL 25 WL 208 IAW B737 SRM 51-40-02-0G & DWG 147A5650.SDR REXA2022082100681Floor Support · corroded"LH FLOOR SILL IS CORRODED AT FS 565. REMOVED CORROSION AT FS 565 IAW CRJ900 SRM 53-00-45-201-001-A01 STEPS 6 A-E. PERFORMED UT THICKNESS OF LH FLOOR SILL FS565 REWORKED AREA IAW CRJ 900 NDTM PART 1 51-20-004-270-A01 REV 36 DATED 2/8/22. FOUND LOWEST REMAININSDR CALA2023082102584Web · corrodedFWD CARGO DOOR WEB HAS 2 SPOTS OF CORROSION BETWEEN FRAMES 27-28 . PER HAECO LCQ NR 9296265/36265 REMOVED AND REPALCED FWD CARGO DOOR WEB & REAPPLIED SURFACE PROT ECTION & FITTINGS IAW A310 SRM 51-72-11-911-001, 51-42-11-001, 5 1-44-11-001, 51-21-11-001, 51-23SDR KCSA202308181100Shim · crackedBULK PIT STA 2034 RBL 62 FOUND DAMAGED SHIM.SDR KCSA202308181099Angle · crackedBULK PIT STA 1980 RBL 62 FOUND DAMAGED ANGLE.SDR VNAA202308180019Angle · corrodedCORROSION ON MID CAP ANGLE ON STGR 18LH BTW FS 310.00 TO FS 349.00 AT PASSENGER DOOR FUSELAGE FRAME. MID CAP ANGLE ON STGR 18LH BTW FS 310.00 TO FS 349.00 AT PASSENGER DOOR FUSELAGE FRAME WAS EVALUATED (IS OUT LIMITS) PER CRJ900 SRM 53-21-23-101-001-A02 AND SDR VNAA202308180018Floor Support · corrodedCORROSION ON PASSENGER CABIN FLOOR SILL STRUCTURE RH BETWEEN FS 280.00 TO FS 295.00. PASSENGER CABIN FLOOR SILL STRUCTURE RH BETWEEN FS 280.00 TO FS 283.00 WAS REPAIRED PER CRJ/900 SRM 53-21-43-201-002-A01 AND FS 283.00 TO FS 295.00 WAS EVALUATED IS WITHIN LISDR VNAA202308180017Bracket · corrodedCORROSION ON BRACKET MACHINED (8EA) AT INTERNAL STRUCTURE FWD BAGGAGE BAY CARGO BELOW FLOOR BETWEEN STGR 23RH/23LH AND FS501.00 TO FS661.00+32.00. BRACKETS, MACHINED (8 EAS) OF INTERNAL STRUCTURE AT FWD CARGO COMPARTMENT WERE EVALUATED OUT OF LIMITS PER CRJ90SDR VNAA202308180004Door Sill · corrodedCORROSION ON AFT CARGO COMPARTMENT DOOR SILL BTW FS 1000.00 TO FS 1047.00, BTW STGR 17LH AND STGR 18LH. CORROSION ON AFT CARGO COMPARTMENT DOOR SILL BTW FS 1000.00 TO FS 1047.00, BTW STGR 17LH AND STGR 18LH WAS REMOVED PER CRJ-900 SRM 51-21-06-001-001-A01 ANSDR VNAA202308180003Drip Tray · corrodedCORROSION ON DRIP TRAY RH AT CROSSBEAM FS:280. EVALUATED, DUE TO EXCESSIVE CORROSION ON DRIP TRAY RH AT CROSSBEAM FS:280 PER CRJ-900 SRM 53-21-43-101-001-A03 AND REPLACED PER CRJ-900 SRM 51-42-10-001-001-A01.SDR ASAA2023081745416Fitting · corrodedDURING REMOVAL OF L1 DOOR SILL, FOUND UPPER, L/H FLOOR SUPPORT FITTING FOR SCUFF PLATE TO BE CORRODED GROUNDED - YES. RECEIVED NEW FITTING P/N D5311219820006 PO 1068187.1 REF ASA EA A320-53EA-01919 PART REMOVED AND REPLACED ON CUSTOMER CARD G1807072 HAECO CSDR SWAA2023092591089Plate · crackedCRACK PLATE FLOOR PANEL 140CF FWD CUTOUT AFT CARGO COMPARTMENT 2023-530584<[01] REPLACED PLATE FLOOR PANEL 140CF FWD CUTOUT AFT CARGO COMPARTMENT AND TOOK MEASURE OF CRACK IS L: 1.852 TOOL USED CALIPER: P/N: 500-752-20 S/N: B21037208 DUE DATE: 04/MAR/24 IAW B7SDR SWAA2023092190895Gusset · crackedFWD CARGO COMPARTMENT L/H SIDE WALL GUSSET CRACKED @ S-19L STA 500D MKD DOT<[01] GUSSET REPLACEMENT WAS ACCOMPLISHED ON TTG8Q00MZRHQ;[02] VERIFIED STEP:1
Back to JASC 5320