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 REXA2022060901116Seat Track · corrodedRH SIDE SEAT TRACK BETWEEN FS 863 TO FS 985 IS CORRODEDSDR REXA2022060901090None · corrodedFLOOR SEAT TRACK AT RBL9 BETWEEN FS 485.00 AND FS 581.00 IS CORRODED. REMOVED AND REPLACED SEAT RAIL IAW CRJ 700 AMM 53-0049-000/400-801-A03SDR REXA2022060701069Angle · corrodedFOUND REINFORCING ANGLE AT FS 265 BETWEEN STGR 26L AND 26R TO BE CORRODED LOCATED, DRILLED AND REPLACED REINFORCING ANGLE AT FS 265 IAW CRJ 700 SRM 51-40-11-001-001-A01 AND 51-42-06-001-001-A01SDR REXA2022060701068Stringer · corrodedSTRINGER 27 CORRODED BETWEEN F.S. 250.00 AND 265.00. REMOVED & REPLACED STRINGER IAW CRJ 700 SRM 51-40-11-001-001-A01, 51-42-06-001-001-A01 & 51-42-21-001-001-A01.SDR REXA2022060701064Stringer · corrodedBELOW THE FLOOR, STGR 19R IS CORRODED BETWEEN FS 295- 310 STGR FOUND OUT OF LIMITS IAW CRJ 700 SRM 53-21-03-101-002-A01, REMOVED LOCATED, DRILLED AND INSTALLED NEW STGR 19R IAW 51-42-06-001-001-A01,51-42-21-001-001-A01 AND 51-40-11-001-001-A01SDR REXA2022060701059Doubler · corrodedDOUBLER CORRODED AT STGR 27 BETWEEN FS 581.00 AND FS 597.00. REMOVED, FABRICATED AND REPLACED DOUBLER IAW CRJ 700 SRM 51-42-06-001-001-A01 & 51-24-16-001-001-A01 REFERENCING DRAWING SH670-33272 FOR FABRICATION.SDR SWAA2022060300578Web · corrodedCORROSION WEB BTW BS1016 TO BS1032 ;LBL4 TO LBL15;WL 208.1 AT AFT GALLEY AREA. 2022-223333 / [01] TOOL USED: TEMPERATURE CONTROLLER: P/N: P3015GOES00000; S/N: 142811020; DUE DATE: 02-FEB-23.;[02] TOOL USED: POWER PACK P/N FMK0003223 S/N PE0412/63335 DUE DATE: SDR SWAA2022060200409Strap · crackedCRACK STRAP LOC. BTW BS 400 TO 420 LBL 21 UPPER AREA AT FWD CARGO COMPARTMENT 2022-223309 / [01] REPLACED STRAP LOC. BTW BS 400 TO 420 LBL 21 UPPER AREA AT FWD CARGO COMPARTMENT IAW DWG 453A1110 SHEET 7 AND SRM B737-700 51-10-02;[02] CERTIFIED WORK PERFORMED.SDR SWAA2022053100811Web · corrodedCORROSION....R/H AFT CARGO COMPARTMENT FLOOR @ STA 847 - STA 867 STR 25R WL 160 AFT WEB HAS CORROSION. (18-050) / [01] REMOVED CORROSION AT R/H AFT CARGO COMPARTMENT FLOOR STA 847-STA 867 STR25R WL 160 AFT SHIELD AS PER REF B737 SRM 51-10-02-0G-0 FOUND EXFOLIASDR SWAA2022053100807Splice · corrodedAFT CARGO COMPARTMENT FLOOR @ STA 727D STR 25L - STR 25R WL 160 FLOOR PANEL ATTACHMENT HAS CORROSION. (18-045) / [01] REMOVED CORROSION AT AFT CARGO COMPARTMENT FLOOR STA727D STR 25L -STR 25R WL 160 FLOOR PANEL T SPLICE ;ASPER REF B737 SRM 51-10-02-0G-0 ;FOUNDSDR SWAA2022053100806Channel · corrodedCORROSION.....L/H AFT CARGO COMPARTMENT FLOOR @ STA 757 - STA 847 STR 25L WL 160 Z CHANNEL HAS CORROSION IN SEVERAL AREAS. (18-047) / [01] REMOVED CORROSION AT L/H AFT CARGO COMPARTMENT FLOOR STA 757-STA 847 STR 25L WL 160 Z CHANNEL AS PER REF B737 SRM 51-10-0SDR SWAA2022053100805Channel · corrodedCORROSION.....R/H AFT CARGO COMPARTMENT FLOOR @ STA 727D - STA 767 STR 25R WL 160 Z CHANNEL HAS CORROSION IN SEVERAL AREAS. (18-046) / [01] REMOVED CORROSION AT R/H AFT CARGO COMPARTMENT FLOOR STA 727D -STA767 STR 25R WL160 Z CHANNEL AS PER REF B737 SRM 51-10-SDR SWAA2022053100803Channel · corrodedR/H AFT CARGO COMPARTMENT FLOOR @ STA 727 - STA727D STR 25R WL 160 Z CHANNEL HAS CORROSION IN SEVERAL AREAS. (18-043). REMOVED CORROSION AT R/H AFT CARGO COMPARTMENT FLOOR STA 727-STA 727D STR 25R WL160 Z CHANNEL AS PER REF B737 SRM 51-10-02-0G-0 FOUND EXFOLIASDR SWAA2022053100802Channel · corrodedL/H AFT CARGO COMPARTMENT FLOOR @ STA 727 - STA 757 STR 25L WL 160 Z CHANNEL HAS CORROSION IN SEVERAL AREAS. (18-042). REMOVED CORROSION AT L/H AFT CARGO COMPARTMENT STA727-STA757 STR25L WL160 Z CHANNEL; ASPER REF B737 SRM 51-10-02-0G-0 .FOUND EXFOLIATE CORROSSDR SWAA2022052600568Support · corrodedCORROSION>>>>> AFT CARGO COMP DOOR SILL AREA ;FLOOR PANEL SUPPORT UPPER SURFACE HAS EVIDENCE OF SURFACE CORROSION BETWEEN BS 847 TO BS 867. / [01] REMOVED CORROSION ON AFT CARGO COMP DOOR SILL AREA ;FLOOR PANEL SUPPORT UPPER SURFACE BETWEEN BS 847 TO BS867 AS SDR REXA2022052701028Angle · corrodedCORROSION FOUND ON IMPACT ANGLE OF WATER WASTE SERVICE DOOR AT STRINGER 23R AND F.S. 379.00 AND 394.00. REMOVED AND REPLACED IMPACT ANGLE IAW CRJ 900 SRM 51-42-06-001-001-A01.SDR REXA2022052701010Seat Track · corrodedLBL 9 FLOOR SEAT TRACK IS CORRODED BETWEEN F.S.693 TO F.S.813. REMOVED AND REPLACED SEAT TRACK IAW CRJ 900 AMM 53-00-49-400-801-A07SDR REXA2022052701009Seat Track · corrodedRBL 9 FLOOR SEAT TRACK IS CORRODED BETWEEN F.S.693 TO F.S.813 REMOVED AND REPLACED SEAT TRACK IAW CRJ 900 AMM 53-00-49-400-801-A07SDR REXA2022052701006Frame · corrodedF.S. 533.00 FRAME IS CORRODED BETWEEN STRINGER 17L AND 18L. REMOVED AND REPLACED FRAME IAW CRJ 900 SRMS 51-40-11-001-001-A01, 51-42-06-001-001-A01, AND 51-42-21-001-001-A01SDR REXA2022052701002Stringer · corrodedSTR19R IS CORRODED BETWEEN FS394 AND FS409 REPAIRED CORROSION DAMGE IAW EA CRJ953-13227 REV IR DATED 5/1/22SDR REXA2022052601001Intercostal · corrodedINTERCOSTAL STRINGER 21L BETWEEN F.S.310 TO F.S.333 IS CORRODED REMOVED AND REPLACED INTERCOSTAL IAW CRJ 900 SRM 51-40-11-001-001-A01 AND 51-42-06-001-001-A01SDR REXA2022052600989None · corrodedRH SIDE SEAT RAIL AT FS 565 - FS 661+8 HAS MULTIPLE SPOTS OF CORROSION.. REMOVED AND REPLACED SEAT RAIL IAW CRJ 900 AMM 53-00-49-000/400-801-A19SDR REXA2022052600985None · corrodedCORROSION ON DOOR SILL BETWEEN F.S. 1015.00 AND 1047.00. REMOVED AND REPLACED DOOR SILL IAW CRJ 900 SRMS 51-40-11-001-001-A01, 51-42-06-001-001-A01, AND 51-42-21-001-001-A01.SDR SWAA2022052600839Angle · crackedAFT CARGO STA. 867; LAV. TANK POST HAS CRACKED ANGLE ON INSIDE STRUCTURE. / [01] REMOVED AND REPLACED ANGLE PER SRM 51-40-02 AND 51-10-02.;[02] C/W INSPECTIONSDR SWAA2022052600830Support · corrodedFLOOR SUPPORT HAS CORROSION AT STA. 946 LBL. 24.0 AFT WET AREA. / [01] FLOOR SUPPORT ANGLE IS OUT OF LIMITS PER SRM 53-70-51-1A-1.;[02] REMOVED AND REPLACED FLOOR SUPPORT ANGLE PER SRM 51-40-02. PART NUMBER OF NEW ANGLE IS 147A5430-7;[03] VERIFIED REPLACEMENT SDR SWAA2022052600598Angle · corrodedCORROSION ON R/H TRANSITION ANGLE UPPER SURFACE AROUND NUT PLATE HOLES BS 500A TO BS 500D. / [01] REMOVED DAMAGE I.A.W SRM 51-10-02. MEASURED DAMAGE DEPTH TO BE .008 INCHES. DAMAGE FOUND TO BE BEYOND ALLOWABLE DAMAGE LIMITS AS GIVEN IN SRM 53-00-53-1A-2.;[09] SDR SWAA2022052600599Angle · corrodedCORROSION ON L/H TRANSITION ANGLE UPPER SURFACE AROUND NUT PLATE HOLES BS 500A TO BS 500F.REMOVED DAMAGE I.A.W SRM 51-10-02. MEASURED DAMAGE DEPTH TO BE .014 INCHES. DAMAGE FOUND TO BE BEYOND ALLOWABLE DAMAGE LIMITS AS GIVEN IN SRM 53-00-53-1A-2.CUT AND REMOVESDR SWAA2022052600833Track · corrodedAFT CARGO STA. 792 RBL 14 CORROSION AROUND FLOOR CHANNEL NUT-PLATE HOLE. AFT CARGO FLOOR CHANNEL (TRACK) IS OUT OF LIMITS PER SRM 53-00-53-1A-2. REMOVED FASTENERS FROM FLOOR CHANNEL FROM B.S 767-887 I.A.W SRM 51-40-02. CUT FLOOR CHANNEL AT B.S 747+8 I.A.W SRM SDR SWAA2022052600834Angle · corrodedAFT SERVICE DOOR FLOOR DRAIN SUPPORT ANGLE HAS CORROSION F.S. 947 TO 967. / [01] SUPPORT ANGLE (MACHINED INTERCOSTAL) IS OUT OF LIMITS PER SRM 53-70-51-1A-1.;[02] REMOVED SUPPORT ANGLE AND DRILLED NEW SUPPORT ANGLE 147A5660U22 PER SRM 51-40-02 AND 51-10-02. OKSDR SWAA2022052600844Beam · corrodedAFT ENTRY DOOR FLOOR SUPPORT BEAM HAS CORROSION AT F.S. 947 LBL 50.0 AT THE FORWARD FLOOR DRAIN SUPPORT BEAM. / [01] SUPPORT BEAM (MACHINED INTERCOSTAL) IS OUT OF LIMITS PER SRM 53-70-51-1A-1.;[02] REMOVED OLD SUPPORT BEAM FROM STA 947-967 AT LBL 50 AND DRILLESDR SWAA2022051800456Service Door · corroded'CORROSION' TOILET SERVICE DOOR PAN CORROSION AT AFT LWR EDGE / [01] REMOVED LIGHT CORROSION AT TOILET SERVICE DOOR PAN AFT LOWER EDGE. MATERIAL ORIGINAL 0.100'. MATERIAL REMOVED 0.001. MATERIL REMAIN 0.099. TOOL USED RPT.583848 ID#453020 CAL DUE. 12/17/2022 ISDR AALA202205165964None · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO DOOR THRESHOLD WEB LOCATED BETWEEN BS 440 AND BS 792 AND RBL 24. REPLACED WEB PER DRAWING 143A8330 AND SRM 51-40-02.SDR AALA202205162141Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND AFT TRANSITION PANEL LOCATED BETWEEN BS 500A AND BS 500I, AT S25R, RBL 23. REPLACED TRANSITION PANEL PER SRM 53-00-53-1A-2.SDR SWAA2022051200773Angle · corrodedFWD CARGO RH Z ANGLE CORRODED WL 156; BS 500A TO 500I ; RBL 25 A225-00I / [01] REMOVED CORROSION IAW SRM 51-10-02 10X MAGNIFY ORIGINAL THICKNESS.040 .010 MATERIAL REMOVED .030 MATERIAL REMAINS FOUND TO BE OUT OF LIMITS IAW SRM 53-00-53-1A-2 AAR TOOL NO.36644 DSDR SWAA2022051200772Shield · corrodedFWD CARGO AFT SHIELD CORRODED WL 156; BS 500 TO 500A ; RBL 25 A225-004 / [01] REMOVED CORROSION IAW SRM 51-10-02 10X MAGNIFY ORIGINAL THICKNESS .040 .015 MATERIAL REMOVED .052 MATERIAL REMAINS OUT OF LIMITS IAW SRM 53-00-53-1A-2 AAR TOOL NO.36644 DUE DATE 08/2SDR SWAA2022051200771Support Angle · corrodedFWD CARGO AFT BLKD LOWER SUPPORT ANGLE CORRODED WL 156; BS 500I; RBL 25 TO LBL25 A225-003 / [01] REMOVED CORROSION IAW SRM 51-10-02 10X MAGNIFY MINIMUM ALLOWABLE MATERIAL REMAINING .056 .050 MATERIAL REMAINS FOUND TO BE OUT OF LIMITS IAW SRM 53-30-08-1A-1 AAR SDR SWAA2022051200776Angle · corrodedFWD CARGO LH Z ANGLE CORRODED WL 156; BS 500B - 8' TO 500I ; LBL 25 A225-006 / [01] REMOVED CORROSION IAW SRM 51-10-02 10X MAGNIFY ORIGINAL THICKNESS.040 .003 MATERIAL WAS REMOVED .037 MATERIAL REMAINS FOUND TO BE IN LIMITS IAW 53-00-53-1A-2 AAR TOOL NO.36644 SDR SWAA2022051200769Stringer Clip · crackedSTRINGER CLIP CRACKED AT LOWER RIVET (FRAME ATTACH) BS 500I; WL 153; S26RH. UNDER Z ANGLE A225-001 / [01] REMOVED S26R STR CLIP SRM SRM 51-40-02-0G-0;[02] VERIFIED NEW STR CLIP AS P/N 143A1010-48 ATAG A02631 IAW DWG 143A1234 REV A;[03] VERIFIED STEP 2;[04] LOCSDR REXA2022063001414Bracket · corrodedSUPPORT BRACKET AT STR 20R BETWEEN FS280-295 CORRODED. CORROSION MEASURES 3.5" X 3.0" X .018" DEEP. REMOVE AND REPLACE BRACKET.SDR REXA2022063001413Stringer · corrodedSTRINGER 24R HAS MULTIPLE SPOTS OF CORROSION WITH 100% MATERIAL LOSS BETWEEN FS295-310 REMOVE AND REPLACE STRINGER 24R.SDR REXA2022063001412Stringer · corrodedSTR 23R HAS MULTIPLE AREAS OF CORROSION WITH 100% MATERIAL LOSS BETWEEN FS319-333 REPLACE STR 23RSDR REXA2022063001411Stringer · corrodedSTRINGER 20R HAS AREAS OF CORROSION BETWEEN FS280-319 WITH 100% MATERIAL LOSS REMOVE AND REPLACE STRINGER.SDR REXA2022063001410Intercostal · corrodedINTERCOSTAL AT STR20R BETWEEN FS310-319 HAS CORROSION ON THE WEB WITH 100% MATERIAL LOSS. REMOVE AND REPLACE INTERCOSTAL.SDR SWAA2022060300189Web · crackedCRACK WEB - INTERCOSTAL LOCATED BETWEEN BS787 TO BS807 CEILING AREA AFT CARGO COMPARTMENT 2022-223215 . [02] REMOVED PROTECTIVE TREATMENT AND PERFORMED VISUAL INSPECTION ON WEB - INTERCOSTAL LOCATED BETWEEN BS787 TO BS807 CEILING AREA AFT CARGO COMPARTMENT ANDSDR SWAA2022060300407Fastener · brokenBROKEN SEAT TRACK FASTENER HEAD FWD POSITION LOCATED RBL 45.5 AND BS 727B AT PASSENGER CABIN 2022-223239 / [01] REPLACED SEAT TRACK FASTENER FWD POSITION LOCATED RBL 45.5 AND BS 727B AT PASSENGER CABIN IAW EA 22-153-01383 SEE INDIVIDUAL SIGN OFF BELOW;[02] REPSDR SWAA2022053100099Cap · corrodedR2 DOOR LOWER INNER CHORD HAS SEVERAL SPOTS OF CORROSION AT STA 897 TO STA 1007 / EXFOLIATED CORROSION NOTED AT R2 LOWER INNER CHORD BETWEEN STA 897 TO STA 1007 AND FOUND OUT OF LIMITS IAW B737-700 SRM 51-10-02-0G-0. REMOVED R2 LOWER INNER CHORD BETWEEN STA 89SDR SWAA2022053100110Intercostal · corrodedINTERCOSTAL HAS CORROSION BETWEEN STA 294.50 TO STA 312;LBL12. CORRECT LBL 11.16. REMOVED CORROSION AT INTERCOSTAL BETWEEN STA 294.50 TO STA 312 LBL12. WL 208 IN REF B737-700 SRM 51-10-02-0G-0.REMOVED INTERCOASTAL BETWEEN STA 294.5 TO STA 312; LBL 12 IN REF WISDR SWAA2022052600245Threshold · crackedAFT CARGO AFT THRESHOLD CORNER CRACKED. / [01] OK TO INSTALL PART;[02] REMOVED AND REPLACED PER SRM 51-10-02 AND AMM 53-11-02;[03] INSPECTED WORK PERFORMEDSDR SWAA2022052600261Scuff Plate · crackedFWD CARGO FWD THRESHOLD CRACKED / [01] INSTALLED NEW FWD SCUFF PLATE PER AMM 53-11-02SDR SWAA2022052500111Intercostal · crackedINTERCOSTAL IS CRACKED BETWEEN STA 312 TO STA 328;LBL47. / [01] REMOVED INTERCOSTAL CRACKED BETWEEN FS 312-328 LBL 47;WL 208 IN REF B737-700 SRM 51-40-02-0G-0;[02] LOCATED AND DRILLED NEW INTERCOSTAL BETWEEN FS 312-328 LBL 47;WL 208 IN REF B737-700 SRM 51-40-0
Back to JASC 5320