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 AALA202212131926Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN FLOOR INTERCOSTAL LOCATED AT BS 951 AND RBL 48. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR SWIA202266924Pan · corrodedSERVICE DOOR LOWER PAN IS CORRODED FORWARD AND AFT SIDES. REMOVED LOWER AFT SERVICE DOOR PAN IAW CRJ 200 SRM 51-42-06. INSTALLED SERVICEABLE LOWER AFT SERVICE DOOR PAN IAW CRJ 200 SRM 51-42-06. MAJOR REPAIR.SDR SWAA2022111559271Floor Support · crackedCABIN FLOOR SUPPORT, BS 344-360, BL 0 CRACKED. REMOVED THE FLOOR SUPPORT IAW SRM 51-40-02-0G-0. LOCATED AND DRILLED THE NEW FLOOR SUPPORT IAW SRM 51-40-05-0G-0. APPLIED ALODINE AND PRIME IAW SRM 51-20-01-0G-0, AND AMM 51-21-72-370-801. INSTALLED THE NEW FSDR ASAA2022101240721Transition Panel · corrodedRH TRANSITION PANEL HAS AREA OF CORROSION FROM STA 500A TO STA 500D. GROUNDED - YES. REMOVED CORROSION AND CHECKED LIMITS FOUND TRANSITION PANEL OUT OF LIMITS IAW B737-700 SRM 53-00-53-1A-2. REPAIRED TRANSITION PANEL IAW B737-700 SRM 53-00-52-2R-5.W= .8 O= .04SDR ASAA2022101240720Transition Panel · corrodedLH TRANSITION PANEL CORRODED FROM STA 420 TO STA 460. GROUNDED - YES. REMOVED CORROSION AND CHECKED LIMITS FOUND TRANSITION PANEL OUT OF LIMITS IAW B737-700 SRM 53-00-53-1A-2 REPAIRED TRANSITION PANEL IAW B737-700 SRM 53-00-53-2R-5.W= 0.8 O= .040 R= .032 L= 1.SDR REXA2022111002444None · corrodedCORROSION NOTED AT L/H FLOOR SILL BETWEEN FS985.00-FS1000 COMPLIED WITH EA NO. CRJ953-14731 REV IR DATE 10/19/2022SDR ASAA2022101240598Shield · corrodedRH FWD TRANSITION SHEILD HAS CORR. GROUNDED - YES. REMOVED CORR & CK'D LIMITS FOUND SHEILD TO BE OUT OF LIMITS IAW B737-700 SRM 53-60-15-1A-1 REMOVED & REPLACED SHEILD IAW B737-700 SRM 51-40-02-0G-0.SDR ASAA2022101240597Transition Panel · corrodedLH TRANSTION PNL HAS CORR FROM STA 727A TO STA 847. GROUNDED - YES. REMOVED CORR & CK'D LIMTS FOUND TRANSITION PNL TO BE OUT OF LIMITS IAW B737-700 SRM 53-00-53-1A-2 REPAIRED TRANSITION PNL IAW B737-700 SRM 53-00-53-2R-5. W 2.0 O .040 R .032 L 12.0 D .008SDR ASAA2022101240593Transition Panel · corrodedRH TRANSITION HAS AREAS OF CORROSION FROM STA 727B TO STA 787. GROUNDED - YES. REMOVED CORR & CHECKED TRANSITION PNL FOUND TO BE OUT OF LIMITS IAW B737-700 SRM 53-00-53-1A-2 REPAIRED TRANSITON PNL IAW B737-700 SRM 53-00-53-2R-5.SDR SWAA2022110159201Angle · crackedCRACK ANGLE - SUPPORT BETWEEN BS 907 TO BS 927 RBL 6 AT AFT CARGO COMPARTMENT (2E/A) 2022-517302 / [01] REPLACED NEW ANGLE - SUPPORT(STIFFENER) BETWEEN BS 907 TO BS 927 RBL 6 TO RBL 19 AT AFT CARGO COMPARTMENT (2E/A) AND FASTENERS IAW B737-700 SRM 51-10-02 ITESDR AALA202211014233None · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 490 TO BS 500A AND RBL 40. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR ASAA2022101240503Floor Support · crackedSTA 330.62-348.2 LBL 45 INTERCOSTAL IS CRACKED AT ATTACH HOLE. GROUNDED - YES. REMOVED AND REPLACED INTERCOSTAL AT STA 330.62 TO 348.2 LBL 45 IAW BOEING 737-700 SRM 51-40-02-0G-0.SDR SIMA20221012006Angle · corrodedDRAIN CUT OUT FWD BRACKET BTW FR 87-86 BTW STR 28R-27R IS CORRODED (LEVEL 2 CORROSION)-C/A-REMOVED AND REPLACED DRAIN CUT OUT FWD BRACKET BTW FR 87-86 BTW STR 28R-27R IAW EMB175 SRM 51-40-08.SDR REXA2022101402263Stringer · corrodedSTGR 19R FS 280 - 319 IS CORRODED. REMOVED AND REPLACED IAW CRJ900 SRMS 51-40-11-001-001-A01, 51-42-06-001-001-A01 AND 51-42-21-001-001-A01SDR IXXA20221202Web · corrodedCORROSION ON WEB STA. 1100.SDR IPXA2022101287088Stiffener · crackedINSPECTION TYPE:CAFT PIT FWD BULKHEAD AT FRAME 54 BL -Y1959 HAS STIFFNER P/N A53410076520200 IS CRACKED.REMOVED AND INSTALLED BRACKET IAW-SRM 51-40-21.SDR IPXA2022101287086Stiffener · crackedINSPECTION TYPE:CAFT PIT FWD BULKHEAD AT FRAME 54 BL -Y450 HAS STIFFNER P/N A5341076520400 IS CRACKED.REMOVED AND INSTALLED BRACKET IAW-SRM 51-40-21.SDR IPXA2022101287085Stiffener · crackedINSPECTION TYPE:CAFT PIT FWD BULKHEAD AT FRAME 54 BL -Y450 HAS STIFFNER P/N A5341076820100 IS CRACKED.REMOVED AND INSTALLED BRACKET IAW-SRM 51-40-21.SDR IPXA2022101287083Stiffener · crackedINSPECTION TYPE:CAFT PIT FWD BULKHEAD AT FRAME 54 BL 0 HAS STIFFNER P/N A5341076520600 IS CRACKED.REMOVED AND INSTALLED BRACKET IAW-SRM 51-40-21.SDR IPXA2022101287080Stiffener · crackedINSPECTION TYPE:CAFT PIT FWD BULKHEAD AT FRAME 54 BL Y953 HAS STIFFNER P/N A5341076820100 IS CRACKED.REMOVED AND INSTALLED BRACKET IAW-SRM 51-40-21.SDR IPXA2022101287077Stiffener · crackedINSPECTION TYPE:C, AFT PIT FWD BULKHEAD AT FRAME 54 BL Y953 HAS STIFFNER P/N A5341076520500 IS CRACKED. REMOVED AND INSTALLED BRACKET IAW-SRM 51-40-21.SDR IPXA2022101287075Stiffener · crackedINSPECTION TYPE:CAFT PIT FWD BULKHEAD AT FRAME 54 BL Y1959 HS STIFFNER P/N A5341076520300 IS CRACKED.REMOVED AND INSTALLED BRACKET IAW-SRM 51-40-21.SDR SWAA2022111058828Support · corrodedCORROSION SUPPORT ZEE LOCATED BS727 TO BS767 AT LEVEL RBL22 AND WL153.6 AFT CARGO COMPARTMENT 2022-562078 / [01] TOOL USED UT EQUIPMENT P/N: 45MG; S/N: 130066701; CAL DUE DATE: 08-APR-23;[02] REPLACED SUPPORT ZEE LOCATED BS727 TO BS767 AT LEVEL RBL22 AND WL153SDR SWAA2022111058827Intercostal · corrodedCORROSION WEB - INTERCOSTAL LOCATED BS767 TO BS787 AT RBL22 AND WL153.5 AFT CARGO COMPARTMENT 2022-562079 / [01] REPLACED WEB - INTERCOSTAL LOCATED BS767 TO BS787 AT RBL22 AND WL153.5 AFT CARGO COMPARTMENT IAW B737-700 SRM 51-10-02 ITEM 9; SRM 51-40-02 AND DWGSDR SWAA2022111058829Angle · corrodedCORROSION ANGLE LOCATED BS767 TO BS787 AT RBL22 AND WL153.5 AFT CARGO COMPARTMENT 2022-562080 / [01] REPLACED ANGLE LOCATED BS767 TO BS787 AT RBL22 AND WL153.5 AFT CARGO COMPARTMENT I.A.W. B737-700 SRM 51-40-02 AND 51-10-02 ITEM 9 AND DWG 146A8123 SHEET 16 REVSDR SWAA2022110458854Retainer · missingMISSING DOOR CUTOUT RETAINER UPPER SILL AT FWD CARGO COMPARTMENT (4 EA) 2022-576478 / [01] REPLACED RETAINER DOOR CUTOUT UPPER SILL AT FWD CARGO DOOR COMPARTMENT (4EA) IAW B737-700 SRM 51-10-02 Ï¿½TEM 9;[02] CORRECTIVE ACTION CERTIFIEDSDR SWIA202266704Intercostal · corrodedAFT WET AREA FR 86-87, STGR 27R-28R HAS 1(EACH) CORRODED INTERCOSTAL FWD OF AFT HOT DRAIN MAST. (C-CHECK RO 10/31/2022) / REMOVED AND REPLACED INTERCOSTAL BETWEEN FR 86-87, STGR 27-28R. REF SRM 51-40-08. DOES NOT EFFECT WEIGHT AND BALANCE OF AIRCRAFT.SDR AALA202211020900Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S22L. MAINTENANCE REPLACED SHEAR PLATE PER SRM 51-42-11.SDR AALA202210313825Shear 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 AALA202210254219Floor Support · brokenAIRCRAFT IN BASE MAINTENANCE: CABIN FLOORBOARD SUPPORT BROKEN AT INBOARD END LOCATED AT BS 540 AND LBL 22. REPLACED FLOORBOARD SUPPORT PER AARD 51-00-05.SDR HNAA2022102500280Guide · damagedE938354 - CDT INTERIOR CABIN, THE LOWER LH COCKPIT TO PAX PARTITION GUIDE PIN HOLE IS ELONGATED ..... COMPLETED INSTALLATION OF INTERIOR CABIN LOWER LH COCKPIT TO PAX PARTITION GUIDE PIN HOLE DOUBLER IAW EMB 145 SRM 53-21-02 SECTION 4 FIG 204SDR SIMA20221011009Shear Panel · corrodedSSI 53-23-005 LH SHEAR PANEL CORRODED BETWEEN FR 87 AND FR 88 (LEVEL 2 CORROSION) -C/A-RAR AFT GALLEY LH SHEAR PANEL IAW EMB-175 SRM 51-40-08.SDR SIMA20221011010Shear Panel · corrodedSSI 53-23-005 RH SHEAR PANEL CORRODED BETWEEN FR 87 AND FR 88 (LEVEL 2 CORROSION). -C/A-INSTALLED AND EDGE SEALED SERVICEABLE RH SHEAR PANEL BETWEEN FR 87-88 IAW EMB 175 SRM 51-40-08, EMB 75 SRM 51-21-02.SDR REXA2022101302250Floor Support · corrodedF.S.319.70 FRAME TO FLOOR SILL FITTING IS CORRODED AT STGR 17R. REMOVED CORROSION ON FS319.70 FRAME TO FLOOR SILL FITTING AT STGR 17R IAW CRJ900 SRM 51-21-06-001-001-A01. FOUND TO BE OUT OF LIMITS IAW CRJ-900 SRM 53-21-23-101-002-A02. REMOVED FITTING AT FS319.SDR SWAA2022111558335Support Bracket · crackedAFT CARGO FWD BULKHEAD LOWER RT SIDE OF CENTER PANEL SUPPORT BRACKET IS BROKEN. PANEL SUPPORT BRACKET REMOVED IAW SRM 51-40-02-0G-0-A00729. INSTALLED THE NEW BRACKET IAW SRM 51-40-02-0G-0 AND DRAWING 144A9401.SDR SWAA2022111558331Gusset · crackedFWD CARGO COMPARTMENT GUSSET AT BS 500D, S19R FOUND CRACKED. REMOVED THE GUSSET IAW SRM 51-40-02-0G-0. LOCATED AND DRILLED A NEW GUSSET IAW SRM 51-40-05-0G-0. TREATED AND PRIMED THE NEW GUSSET IAW SRM 51-20-01-0G-0. INSTALLED AND SEALED THE NEW GUSSET ISDR SWAA2022102858323Support · corrodedFWD CARGO BAY R/H FLOOR TO SIDEWALL SUPPORT PLATE HAS CORROSION AROUND NUT PLATE HOLE BS500F+7 RBL24.5 WL156 / [01] UPDATED MEASUREMENT TABLE FOR PICTURE OF CORROSION ATTACHED;[02] EVALUATED CORROSION AT BS 500F+7' REMOVED 0.015' IN A AREA OF 1'X1' ORIGINAL THSDR SWAA2022102858314Splice · corrodedAFT CARGO BAY FLOOR SPLICE HAS CORROSION AROUND NET PLATE HOLE BS887 LBL6.5 WL167.5 / [01] UPDATED MEASUREMENT TABLE FOR PICTURE OF CORROSION ATTACHED;[02] CORROSION ON SPLICE FOUND TO BE OUT OF LIMITS DUE TO NO LIMITS ARE GIVEN IN THE SRM.;[03] VERIFIED CORRESDR SWAA2022102858315Attach Angle · corrodedAFT CARGO BAY LOWER ATTACH ANGLE COMMON TO SHIELD HAS CORROSION AROUND NUT PLATE HOLE BS767+2 RBL21 WL156 / [01] UPDATED MEASUREMENT TABLE FOR PICTURE OF CORROSION ATTACHED;[02] CORROSION ON SUPPORT WAS FOUND TO BE OUT OF LIMITS DUE TO NO LIMITS ARE GIVEN IN TSDR AALA202210258991Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN FLOOR SUPPORT INTERCOSTAL LOCATED AT BS 950 AND RBL 24. REPLACED INTERCOSTAL PER AARD 51-00-05-1 AND DWG 147A5660.SDR AALA202210198946Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON FLOORBOARD SUPPORT ANGLE AT STA 500I AT CARGO AFT BULKHEAD LOCATED AT LEFT BUTT LINE 42 TO RIGHT BUTT LINE 42. REMOVED AND REPLACED FLOORBOARD SUPPORT ANGLE PER AARD 51-00-05-1.SDR REXA2022101302257Stringer · crackedFOUND FS280-295 STRINGER 3L HAS CRACK INDICATION NOTED IN MARKED FASTENER HOLES. REPAIRED STRG 3L F.S. 280-295 IAW BOMBARDIER REO 670-53-21-493 REV.-C DATED 2011/12/08SDR SROM101020221Intercostal · corrodedCORROSION DAMAGE ON STRINGER INTERCOSTAL AT STATION X100.800 - X116.00 STRINGER 24S. DAMAGE BEYOND MANUFACTURES PUBLISHED LIMITS.SDR IXXA2022101001Support Bracket · corrodedFWD LOWER CARGO WEB SUPPORT BRACKET AT STATION 484 RBL 48 HAS CORROSIONSDR 2022F00396Frame · crackedAUX FRAME AT BS 500C LBL 45 CRACKED AT VLOWER FLANGESDR SWAA2022111557757Channel · corrodedAFT CARGO FLOOR SIDEPLATE RBL21 FROM STA 727D+10-16 AND WL 156 CORRODED. REPLACED IAW TASKCARD TTG8Q00F9U30.SDR SWAA2022111557740Channel · corrodedAFT CARGO FLOOR SIDEPLATE RBL21 FROM STA 727E-747 AND WL156 CORRODED. REPLACED IAW TASKCARD TTG8Q00F9U30.SDR SWAA2022111557741Channel · corrodedAFT CARGO FLOOR SIDEPLATE LBL21, BS 747-767,WL 156, CORRODED. WILL BE ACCOMPLISHED ON NON-ROUTINE TTG8Q00F9N7B.SDR SWAA2022111557758Channel · corrodedAFT CARGO FLOOR SIDEPLATE RBL 21, BS 747-767, WL 156 CORRODED. FOUND OUT OF LIMITS IAW SRM 53-00-53-1A-2. DRILLED & LOCATED A NEW CHANNEL SECTION IAW SRM 51-40-05-0G-0. TREATED & PRIMED NEW HOLES IAW AMM 51-21-41-370-804, & AMM 51-21-72-370-804.SDR SWAA2022111557760Channel · corrodedAFT CARGO FLOOR SIDEPLATE LBL21 BETWEEN STA 767-787 AND WL 156 WITH CORROSION. WILL BE ACCOMPLISHED USING NON-ROUTINE#TTG8Q00F9N7B.
Back to JASC 5320