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 SWAA2022050390810Intercostal · crackedCRACK WEB INTERCOSTAL LOCATED BS685 TO BS706 AND STR14L AT PASSENGER CABIN 2022-168785 / [01] INSTALLED WEB INTERCOSTAL ANGLES(2E/A) ; STRAP(1E/A) AND FASTENERS LOCATED BS685 TO BS706 AND STR14L AT PASSENGER CABIN IAW B737-700 SRM 51-40-02 AND DWG 144A7500 SHESDR SWAA2022042990718Bracket · corrodedIN THE FLIGHT DECK BETWEEN STATIONS 259 AND 270; THE CENTER BRACKET IN THE FLOOR STRUCTURE HAS EVIDENCE OF CORROSION ON THE UPPER SURFACES. REMOVED CORROSION WITHIN LIMITS; ALODINED; AND PRIMED IAW SRM 53-10-51-1A-1.SDR IPXA2022041181076Stiffener · crackedINSPECTION TYPE:2CR/H MLG W/W 3RD STIFFNER AT O/B WEB IS CRACKED.REMOVED AND REPLACED STIFFNER IAW SRM 51-35-01. (MINOR)SDR VNAA202204039993Floorbeam · corrodedCORROSION ON FLOOR BEAM FS 333 AT STRG. 17 RBL FLOOR STRUCTURE PAX CABIN.
CORRECTIVE ACTION:CSDR SWAA2022050490632Support Angle · crackedCRACK ANGLE - SUPPORT LOCATED BS727 BULKHEAD AFT CARGO COMPARTMENT 2022-165321 / [01] REPLACED ANGLE SUPPORT LOCATED BS727 BULKHEAD AFT CARGO COMPARTMENT IAW B737-700 SRM 51-10-02 ITEM 9 AND DWG 144A2600; SHEET 309; REV. -. SEE INDIVIDUAL SING-OFFS BELOW.;[02]SDR SWAA2022050490633Support Angle · crackedCRACK ANGLE LOCATED BETWEEN BS907 TO BS927 AND STR25R TO 27R FWD POSITION AFT CARGO COMPARTMENT 2022-165318 / [01] TOOL USED CALIPER P/N: 700-113-10; S/N: 0019306; DUE DATE: 05-NOV-22;[02] REPLACED ANGLE AND FASTENERS LOCATED BETWEEN BS907 TO BS927 AND STR25R SDR SWAA2022050490629Angle · crackedCRACK ANGLE LOCATED BETWEEN BS907 TO BS927 AND STR25R TO STR27R AFT POSITION AFT CARGO COMPARTMENT 2022-165319 / [01] TOOL USED CALIPER P/N: 700-113-10; S/N: 0019306; DUE DATE: 05-NOV-22;[02] REPLACED ANGLE AND FASTENERS LOCATED BETWEEN BS907 TO BS927 AND STR2SDR SWAA2022050490628Support · corrodedCORROSION SUPPORT ZEE LOCATED BETWEEN BS727E TO BS807; LBL21.00; WL156 AFT CARGO COMPARTMENT 2022-165320 / [01] REPLACED SUPPORT ZEE LOCATED BETWEEN BS727E TO BS847; LBL21.00; WL156 AFT CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 AND DWG: 146A7500; SHEET: 61; SDR SWAA2022050490630Support · corrodedCORROSION SUPPORT ZEE LOCATED BETWEEN BS727E TO BS767; RBL21.00; WL156 AFT CARGO COMPARTMENT 2022-165322 / [01] REPLACED SUPPORT ZEE LOCATED BETWEEN BS727 TO BS767; RBL21.00; WL156 AFT CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 AND DWG 146A7500 SHEET 61 REV -SDR SWAA2022050490631Intercostal · corrodedCORROSION WEB - INTERCOSTAL LOCATED BETWEEN BS767 TO BS794; RBL 21; WL156 AFT CARGO COMPARTMENT 2022-165323 / [01] TOOL USED: DIGITAL CALIPER P/N:500-196-30 S/N=A20230907 DUE DATE:28-AUG-22.;[02] REPLACED WEB INTERCOSTAL (SHIELD) LOCATED BETWEEN BS767 TO BS794SDR SWAA2022050490646Support · corrodedCORROSION SUPPORT ZEE LOCATED BTW BS 727 TO BS 767 AT LEVEL STR 25R AND RBL 21 AT AFT CARGO COMPARTMENT 2022-168766 / [01] REPLACED SUPPORT ZEE LOCATED BTW BS 727 TO BS 767 AT LEVEL STR 25R AND RBL 21 AT AFT CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 SRM 51-1SDR SWAA2022050490642Support · corrodedCORROSION SUPPORT ZEE LOCATED BTW BS 727 TO BS 807 AT LEVEL STR 25L AND LBL 21 AT AFT CARGO COMPARTMENT 2022-168764 / [01] REPLACED NEW SUPPORT ZEE LOCATED BTW BS 727 TO BS 807 AT LEVEL STR 25L AND LBL 21 AT AFT CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 AND SDR SWAA2022050490643Threshold · corrodedCORROSION BILGE AREA LOWER SILL THRESHOLD LOCATED BTW BS 787 TO BS 847 AT LEVE STR 25R AND RBL 25 AT AFT CARGO COMPARTMENT 2022-168761 / [01] REPLACED FASTENERS AND THRESHOLD LOCATED BTW BS 787 TO BS 847 AT LEVE STR 25R AND RBL 25 AT AFT CARGO COMPARTMENT IAW SDR SWAA2022050390645Intercostal · crackedCRACK WEB INTERCOSTAL LOCATED BS294.5 TO BS303.9 AND STR16L AT PASSENGER CABIN 2022-168765 / [01] TOOL USED EDDY CURRENT EQUIPMENT PN. NORTEC 600D; SN. 60009161631; DUE DATE: 03-DEC-22;[02] TOOL USED TEMPERATURE CONTROLLER P/N:P3015GOES00000;S/N:142811020;DUE SDR SWAA2022050390640Tie Clip · crackedCRACK TIE CLIP LOCATED BS277 AND STR10R AT PASSENGER CABIN 2022-168759 / [01] REPLACED TIE CLIP LOCATED BS277 AND STR10R AT PASSENGER CABIN IAW SRM 51-40-02;51-10-02 ITEM 9 DWG 141A1110 REV -;[02] CERTIFIED WORK PERFORMED RIISDR SWAA2022050390641Support Angle · crackedCRACK SUPPORT ANGLE LOCATED BS291.5 TO BS294.5 AND STR17R AT PASSENGER CABIN 2022-168760 / [01] REPLACED SUPPORT ANGLE AND FASTENERS LOCATED BS291.5 TO BS294.5 AND STR17R AT PASSENGER CABIN IAW B737-700 SRM 51-40-02 DWG: DWG 141A8310 REV -;[02] COMPLETE TASK CSDR SWAA2022050390639Shield · corrodedCORROSION FLOOR STRUCTURE SHIELD PLATE LOCATED BTW BS 767 TO BS 787 AT LEVEL STR 25R AND RBL 20 AT AFT CARGO COMPARTMENT 2022-168745 / [01] REPLACED SHIELD PLATE LOCATED BTW BS 767 TO BS 787 AT LEVEL STR 25R AND RBL 20 AT AFT CARGO COMPARTMENT IAW DGW 146A0081SDR SWAA2022050390644Frame · crackedCRACK FRAME LOCATED BS312 AND BETWEEN STR5L TO STR6L AT PASSENGER CABIN 2022-168763 / [01] TOOL USED PN NORTEC 500D SN N500X1693P030456 DUE DATE 26-JAN-23;[02] TOOL USED TEMPERATURE CONTROLLER P/N:P3015GOES00000;S/N:142811020;DUE DATE:02-FEB-23;TEMPERATURE CONSDR SWAA2022050290660Stiffener · corrodedFOUND FWD WET AREA FLOOR STTIFENER WITH CORROSSION STA 328 LBL 5 / [01] REMOVED AND REPLACED FLOOR STIFFENER AT FWD WET AREA STA 328 LBL 5 AS PER 51-40-02-0G-0;[02] VERIFIED STEP 1SDR AALA202204287308Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23R. REPLACED SHEAR PLATE PER SRM 51-42-11.SDR REXA2022042700729Stringer · corrodedSTGR 20L IS CORRODED BETWEEN FS 295 TO FS 310. - REPAIRED STGR 20L FS 295-310 IAW EA CRJ953-13114 REV IR DATED 3/24/2022.SDR AALA202204263383Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23L. REPLACED SHEAR PLATE PER SRM 51-42-11.SDR AALA202204162043None · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT FORWARD PASSENGER / CREW DOOR CUT OUT LOWER CENTER FITTING BETWEEN FR 16 AND FR 20 AT S23R. REPLACED CENTER FITTING PER SRM 51-42+11.SDR AALA202204141884None · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT FORWARD PASSENGER / CREW DOOR CUT OUT LOWER CENTER FITTING BETWEEN FR 16 AND FR 20 AT S23L. REPLACED CENTER FITTING PER SRM 51-42-11.SDR CALA2022040400866Floor Support · corrodedSUPPORT TASK- MAIN CABIN FLOOR STA 720-740 RBL65 HAS CORROSION O N UPPER SURFACE. TRANSCRIBED FROM HAECO GSO NRC 9284976SDR 2024FA0000152Stiffener · crackedAFT FUSELAGE LOWER SKIN STIFFENER FOUND CRACKED. REPLACED WITH NEW STIFFENER.SDR REXA2022060600964Stringer · corrodedSTR 23L HAS MULTIPLE AREAS OF CORROSION BETWEEN FS319-333 WITH UP TO 100% MATERIAL LOSS. REPLACED STR 23L IAW EA CRJ953-13351SDR REXA2022060601022None · corrodedAVIONICS BAY DOOR SEAL RETAINER CORRODED. CORROSION MEASURES 10.0"X.200"X100% MATERIAL LOSS. REMOVE AND REPLACE SEAL RETAINER.SDR REXA2022050300777Plate · corrodedGALLEY 1 FORWARD INBOARD AND OUTBOARD MOUNTS CORRODED. CA: REMOVED AND REPLACED GALLEY 1 INBOARD AND OUTBOARD MOUNT PLATES IAW CRJ 900 SRM 51-40-11-001-001-A01 & 51-42-21-001-001-A04SDR SWAA2022042090559Cap Seal · elongatedAFT CARGO R/H CAP STRIPS WITH HOLES ELONGATED / [01] RECEIVED NEW AFT CARGO CAP STRIPS 2 EACH ;P/N 453A2611-11 AND 453A 2611-9; NEWS CAP STRIPS TO BE INSTALLED ON CUSTOMER BAR CODE TTG8Q004GEPO; 5360-E-16462-NG;[02] ORRECTION RECEIVED NEW AFT CARGO CAP STRIPS SDR R61A202204190080Gusset · corrodedCABIN FLOOR CF III GUSSET SPLICE IA CORRODED AT FR 90, BL 0.R&R IAW SRM 51-43-03.SDR R61A202204190076Panel Support · corrodedDURING HEAVY MAINTENANCE FOUND CORROSION ON CFIII FLOOR BOARD SUPPORT AT FR84, RH OUTBD SIDE. CFIII CORRODED FLOOR BOARD SUPPORT AT FR84, RH OUTBD SIDE, REMOVED AND REPLACED IAW EMBRAER 170/175 SRM 51-41-02, 51-41-01, AND 51-43-02.SDR R61A202204190079Floor Support · corrodedCABIN FLOOR SUPPORT BTW FR 88 & FR 90 R/H O/B IS CORRODED. R&R IAW EMB 170/175 SRM 51-43-01 AND 51-42-01.SDR AALA202204143632Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CABIN FLOOR INTERCOSTAL AT BS 285 AND RBL 1. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR REXA2022040800565Sill Drain · corrodedAFT BAGGAGE BAY DOOR SILL CORRODED BETWEEN FS1000 AND FS1047. - REMOVED CORRODED DOOR SILL BETWEEN F.S.1000 AND F.S.1047 AND INSTALLED NEW SERVICABLE DOOR SILL IAW CRJ 900 SRM 51-42-06-001-001-A01, 51-42-13-001-001-A01 AND51-42-21-001-001-A01.SDR AALA202204081797Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR SUPPORTS AT BS 540 BETWEEN LBL 24 AND RBL 24. **SUPPLEMENTAL REPORT FOR AALA202204071797: REPLACED LEFT HAND FLOOR SUPPORT AND RIGHT-HAND FLOOR SUPPORT (AALA202204086530) PER AARD 51-00-05** (CLOSED)SDR AALA202204086530Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR SUPPORTS AT BS 540 BETWEEN LBL 24 AND RBL 24. **ORIGINAL REPORT WAS AALA202204071797** REPLACED LEFT HAND FLOOR SUPPORT AND RIGHT-HAND FLOOR SUPPORT (AALA202204086530) PER AARD 51-00-05.SDR AALA202204075694Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CABIN FLOOR INTERCOSTAL AT BS 330 AND LBL 42. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202204079855Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CABIN FLOOR INTERCOSTAL AT BS 315 AND RBL 33. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202204071797Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR SUPPORTS AT BS 540 BETWEEN LBL 24 AND RBL 24. **SUPPLEMENTAL REPORT WILL BE SUBMITTED** (OPEN)SDR IPXA2022040180743Floor Panel · damagedINSPECTION TYPE:SEG3MCD FLOOR PANEL 231XMF IS DELAMINATED ON THE LOWER SIDE CORNERFABBED PANEL 231XMF FROM 5024N400001SS-G, BATCH#3855847 PER SREO B7575-5320-9692-KSDR IPXA2022040180741Floor Panel · damagedINSPECTION TYPE:SEG3MCD FLOOR PANEL 231XJF IS DELAMINATED ON SIDE AREAFABBED PANEL 231XJF FROM 5024N400001SS-G, BATCH #3855847 PER SREO B7575-5320-9692-KSDR IPXA2022040180740Floor Panel · damagedINSPECTION TYPE:SEG3MCD FLOOR PANEL 231XEF IS CRACKED IN 2 PLACES ON SIDE AREAFABBED PANEL 231XEF FROM 5024N400001SS-G, BATCH#3855847 PER SREO B7575-5320-9692-KSDR SWAA2022051090258Bracket · crackedCRACK SUPPORT BRACKET LOCATED BS540 AND LBL8 AT LOWER FUSELAGE 2022-168646 / [01] REPLACED BRACKET LOCATED BS540 AND LBL8 AT LOWER FUSELAGE IAW B737-700 SRM 51-40-02 AND 51-10-02;[02] COMPLETE TASK CERTIFIEDSDR SWAA2022051090259Bracket · crackedCRACK SUPPER BRACKET LOCATED BS540 AND RBL8 AT LOWER FUSELAGE 2022-168647 / [01] REPLACED BRACKET LOCATED BS540 AND RBL8 AT LOWER FUSELAGE IAW B737-700 SRM 51-40-02 AND 51-10-02;[02] COMPLETE TASK CERTIFIEDSDR SWAA2022051090257Angle · crackedCRACK ANGLE LOCATED BS663.75 AND LBL28 AT LOWER FUSELAGE 2022-168648 / [01] TOOL USED: TEMPERATURE CONTROLLER P/N: P3015GOES00000; S/N: 142811020; DUE DATE: 02-FEB-23.;[02] INSTALLED ANGLE (ONLY FASTENERS COMMON TO VAPOR BARRIER) LOCATED BS 663 AND BTW LBL 5 TSDR REXA2022050500814Stringer · corrodedSTRINGER 26R BETWEEN FS 280.00 TO FS 364.00 HAS CORROSION AROUND SEVERAL FASTENER TAILS. PERFORMED REPAIR ON STRINGER 26R BETWEEN FS 280.00 TO FS 364.00 PER ENGINEERING AUTHORIZATION CRJ953-12934 REV IR DATED 2/16/2022.SDR REXA2022050300782Seat Track · corrodedRH CABIN SIDE SEAT TRACK CORRODED FS847+31 CA: REMOVED AND REPLACED IAW CRJ 900 AMM 53-00-49-400-801-A11SDR REXA2022050300779None · crackedFS. 280 RBL 9 OB CLIP CRACKED CA: REPLACED RBL. 9 FS.280. CLIP IAW CRJ 900 SRM 51-40-11-001-001-A01.SDR REXA2022050300778None · corrodedRH FLOOR SILL HAS MINOR CORROSION BETWEEN FS295.00 AND FS 310.00 CA: REMOVED CORROSION I.A.W. CRJ SRM #51-21-06-001-001-A01,SILL FOUND TO BE SERVICEABLE I.A.W #53-00-45-201-001-A01, FINISH AND CIC RESTORED.
Back to JASC 5320