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 SWAA2021060835109Floor Support · crackedTHE FWD FLOOR STRUCTURE HAS A CRACKED INTERCOSTAL AT STA 321 LBL 45 / REMOVED AND REPLACED DAMAGED FLOOR STRUCTURE PER SRM 51-40-02.SDR SWIA202055571Floor Support · corrodedCORROSION ON FLOOR BEAM LOCATED AT RBL 9.0 FS 571-FS 677. C-CHECK RO 1/17/2021. REMOVED CORROSION FROM FLOORBEAM RBL 9 FS 571-FS 677, "OUT OF LIMITS", REF CRJ700 SRM 51-21-06-001-001-A01, DRAWING SH670-33459 REV NC. REMOVED AND REPLACED FLOORBEAM RBL 9 FS 5SDR SWAA2021011338521Floor Support · corrodedCORROSION FLOOR STRUCTURE INNER CHORD BS 947/BS 987 AT LEVEL RBL 54 WL 208 AFT GALLEY AND LAVATORY. REPLACED INNER CHORD LOCATED BETWEEN BS 887 TO 1006 AT LEVEL RBL 54 WL 208 AFT GALLEY AREA, IAW SRM B737-700 51-40-02 AND DRAWING 147A8501 REV B PART NUMBER USSDR SWAA2021011235108Floor Support · crackedTHE FWD FLOOR STRUCTURE HAS A CRACKED INTERCOSTAL AT STA 292.5 BL 0. REMOVED AND REPLACED INTERCOSTAL AT STA 292.5 BL 0, PER SRM 51-10-02.SDR SWAA2021011239657Angle · wornWEAR CLOSURE ANGLE LOCATED ON BS 1088 TO BS 1156 AT LEVEL STR 2L AT UPPER FUSELAGE. PERFORMED PERMANENT REPAIR CLOSURE ANGLE LOCATED ON BS 1088 TO BS 1156 AT LEVEL STR 2L AT UPPER FUSELAGE, IAW B737-700 SRM 53-80-71-2R-6 REPAIR 6 MATERIAL USED: ANGLE 0.063' 2SDR SWIA202055299Intercostal · corrodedCORROSION FOUND ON INTERCOSTAL AT STGR 21L FS 333-FS 349. C-CHECK RO 1/5/2021. REMOVED AND REPLACED NEW INTERCOSTAL P/N SH670-31823-1S AT FS 333.00 TO FS 349.00 STGR 21L, REF CRJ700 SRM 51-42-06-001-001-A01 AND DWG SH670-31810 REV Y. COMPLIED WITH TASK CARDSDR AALA202012229021Angle · crackedAIRCRAFT IN BASE MAINTENANCE. FOUND CLIP CRACKED, LOWER OUTBOARD SIDE OF LEFT TRANSITION PANEL, AFT SIDE OF FRAME 500H. REPLACED CLIP, PER BOEING DRAWING 143A7502 AND AARD 51-00-05-01.SDR AALA202012229009Baffle · crackedAIRCRAFT IN BASE MAINTENANCE. FOUND CRACKED BAFFLE CLIP ON LOWER OUTBOARD SIDE OF RIGHT TRANSITION PANEL, FORWARD OF FRAME 500H. INSTALLED NEW CLIP, PER AARD 51-00-05-1 AND AARD 53-00-01-6.SDR DALA2020121004037Intercostal · crackedDURING INSPECTION MAINTENANCE FOUND A CRACK INDICATION AT LOWER INBOUND HOLE AT S-14R INTERCOSTAL. REPAIRED PER ER/A 588545-14AD.SDR DALA2020120904029Floor Support · corrodedCORROSION ON FLOOR BEAM -Y765 AT LEVEL OF FR 68 AFT GALLEY AREA. CORRECTIVE ACTION: REPLACED FLOOR BEAM -Y765 LOCATED FR 66+5" TO FR 70 AFT GALLEY AREA, AS PER SRM A320 51-72-11.SDR A6WA202012097455Tee Fitting · corrodedTCAP EXTRUSION ON LBL 27, FS 570 TO FS 605 CORRODED. AIRCRAFT REMOVED FROM SERVICE. REMOVED AND REPLACED T CAP AT LBL 27, FS 570 TO FS 605, IAW CRJ200 SRM 51-42-21-00 AND BOMBARDIER DRAWING 601R35031 REV P.SDR A6WA202012097454Tee Fitting · corrodedT-CAP EXTRUSION ON LBL 27 AT FS 570 TO FS 605 HAS CORROSION. AIRCRAFT REMOVED FROM SERVICE. REMOVED AND REPLACED T CAP EXTRUSION AT LBL 27, FS 570 TO FS 605, IAW CRJ 200SRM 51--42-00 AND BOMBARDIER DWG 601R35031 REV P.SDR DALA2020120804011Web · damagedDURING INSPECTION, MAINTENANCE FOUND HIDDEN DAMAGE ON WEB OF INTERCOSTAL BETWEEN STA 1500 TO STA 1500 TO 1520 BL 0 PASSENGER CABIN. REPAIRED PER SRM 51-70-13.SDR JR2R20201208636Web · corrodedUPPER FLOOR WEB CORRODED BETWEEN FLOOR BEAMS 13 AND 14 RBL 36 THRU RBL 48.SDR SWAA2021082638505Angle · crackedCRACK ANGLE - CLIP LOCATED ON BS 500B FWD FACE AT LEVEL STR 26L AT FWD CARGO COMPARTMENT / REPLACED ANGLE-CLIP LOC. ON BS 500B AND ANGLE-CLIP 500A FWD FACE AT LEVEL STR.26L AT FWD CARGO COMPARTMENT IAW B737-700 SRM 51-10-02 ITEM 9; SRM 51-40-02 ITEM 4 AND DWG SDR SWAA2021082638506Angle · crackedCRACK ANGLE - CLIP LOCATED ON BS 400 AFT FACE AT LEVEL STR 26L AT FWD CARGO COMPARTMENT / REPLACED ANGLE-CLIP LOCATED ON BS400 AFT FACE AT LEVEL STR.26L AT FWD CARGO COMP. IAW SRM B737-700 51-40-02; 51-10-02 AND DWG#143A7505 REV.'B'; REPLACED ANGLE DUE TO NOT SDR SWAA2021071638504Angle · crackedCRACK ANGLE - SUPPORT LOCATED BS727B TO BS727E AT LEVEL LBL51 CEILING STRUCTURE AREA AFT CARGO COMPARTMENT / REPLACED ANGLE - SUPPORT LOC BS 727B TO BS727E AT LEVEL LBL51 CEILING STRUCTURE AREA AFT CARGO COMPARTMENT MATERIAL USED ALUMINUM SHEET 2024T3 040' P/OSDR SWIA202055846Channel · corrodedAVIONICS BAY TCAS LOWER CHANNEL HAS SEVERAL AREAS OF CORROSION. (C-CHECK) RO 2/1/2021 REPLACED TCAS LOWER ANTENNA CHANNEL PER SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01 & DRAWING SH670-30023 REV G. CHECKS GOOD. SEE CONTINUATION CARD FOR DETAILS. CSDR SWIA202055690Support · corroded* RH AFT BAGGAGE BAY SILL HAS MULTIBLE AREA'S OF CORROSION 559.0 THRU 559.0+80. CIRCLED IN GP (C-CHECK) RO 1/29/2021 INSTALLED NEW R/H INTERCOSTAL, P/N 601R38842-3, PO# 7677-00008/89 STA559 TO STA559+16 REF. DWG 601R38842 REV. A AND CRJ 200 SRM 51-42-06, CSDR SWAA2021011338322Floorbeam · crackedCRACK ANGLE FLOOR STRUCTURE AT BS 693 AND BL 0 CENTER SECTION. REPLACED ANGLE LOCATED FLOOR STRUCTURE AT BS 693 AND BL 0 CENTER SECTION, IAW SRM B737-700 51-40-02 AND DWG 273A9111 SHEET 4 REV A DUE TO NO FOUND ALLOWABLE DAMAGE LIMITS IN SRM B737-700. FABRICASDR AALA202101049017Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION OF FLOOR SUPPORT AT STA 500I, MEASURING L=2.0 IN, W=18.0 IN, D=0.02 IN. REPLACED FLOOR SUPPORT WITH NEW, IAW SRM 51-10-02.SDR SWAA2021010435209Support Channel · corrodedCORROSION, INTERCOSTAL SUPPORT CHANNEL AT BS 259.5-BS 270 WL 208 LBL 4-RBL 4 HAS SEVERAL AREAS OF CORROSION. REMOVED, LOCATED AND DRILLED NEW CHANNEL AND INSTALLED INTERCOSTAL SUPPORT CHANNEL BS 259.5-270 LBL 4-RBL 4 WL 208, IAW BOEING DWG. 140A9810 AND SRM SDR REXA2020122300841Door Sill · corrodedAFT BAGGAGE BAY DOOR CUTOUT LOWER THRESHOLD CORROSION INDICATIONS FS 1020 TO FS 1045, FOUR PLACES AS MARKED. REMOVED & REPLACED AFT CARGO DOOR SILL P/N MM670-35655-003, IAW CRJ 900 SRM 51-42-06-001-001-A01, 51-42-21-001-001-A01, 51-42-21-001-001-A01, 51-40-11SDR DALA2020120804020Floor Support · corrodedCORROSION FLOOR BEAM YB BETWEEN FR 73/FR 74 AT AFT GALLEY AREA. CORRECTIVE ACTION: REPLACED FLOOR BEAM YB BETWEEN FR 73 TO FR 74 AT AFT GALLEY AREA, AS PER A330 SRM AND DWG.SDR DALA2020120804010Floor Support · corrodedDURING INSPECTION, FOUND CORROSION LEVEL 2 ON FLOOR STRUCTURE OF PASSENGER CABIN BETWEEN STA 980 AND 1020 AND RBL 64.5 AT WING CENTER AREA. CORROSION REPAIRED PER SRM.SDR DALA2020120804009Floor Support · corrodedDURING INSPECTION, MAINTENANCE FOUND CORROSION LEVEL 2 ON FLOOR STRUCTURE OF PASSENGER CABIN. REPAIRED PER SRM.SDR SCNA20201207406Angle · corrodedFOUND CORROSION ON Z-ANGLE ON SEVERAL SPOTS AT STA 727F TO 767 LBL 45. AFT CARGO BAY. REMOVED FABRICATED + INSTALLED NEW Z ANGLE AT STA 767 LBL 45 AFT CARGO, IAW B737-800 SRM 51-40-02, SRM 53-00-53, SRM 51-40-05 TREATED + PRIMED, IAW B737-800 SRM 51-20-01.SDR SWAA2021082638315Angle · crackedCRACK ANGLE - CLIP LOCATED ON BS 500C AT LEVEL STR 26L AT FWD CARGO COMPARTMENT / REPLACED ANGLE-CLIP LOC. ON BS500C AT LEVEL STR.26L AT FWD CARGO COMPARTMENT IAW SRM B737-700 51-40-02; 51-10-02 AND DWG#143A7505 REV. 'B' REPLACED DUE TO NOT FOUND ALLOWABLE DAMSDR SWAA2021052538314Gusset · crackedCRACK GUSSET LOCATED BS 500D AT LEVEL STR 19L FWD CARGO COMPARTMENT / REPLACED GUSSET LOC. BS 500D AT LEVEL STR.19L FWD CARGO COMPARTMENT IAW B737-700 SRM 51-10-02 ITEM 9; SRM 51-40-02 ITEM 4 AND DWG 143A7902 REV.- REPLACED GUSSET DUE TO NOT FOUND ALLOWABLE DASDR SWAA2021010634773Splice Angle · corrodedCORROSION ON LOWER AFT EDGE OF THE LEFT E&E BAY DOOR FRAME FWD OF BS 360 AND LEFT OF STR 28 WL 146, MARKED. REJECTED DUE TO THE EXTERIOR SKIN IS NOT BEEN PAINTED WHERE THE FASTENERS WERE REMOVED. NO ALLOWABLE LIMITS GIVEN, PER SRM. REMOVED AND REPLACED STR SDR DALA2020121004036Intercostal · corrodedDURING INITIAL INSPECTION MAINTENANCE FOUND LEVEL 2 CORROSION ON INTERCOSTAL BETWEEN STA 600 AND 620 AND BETWEEN S 26R AND 27R AT FWD CARGO COMPARTMENT. INTERCOSTAL WAS REPAIRED PER SRM 51-70-11.SDR AALA202012099014Floor Support · brokenAIRCRAFT WAS GROUNDED. FOUND FR 20 FLOOR SUPPORT FITTING SNAPPED OFF. INSTALLED NEW FLOOR SUPPORT FITTING AIRBUS SRM 51-42-11.SDR SCNA20201207405Angle · corrodedFOUND CORROSION ON Z-ANGLE ON SEVERAL SPOTS AT STA 727C TO 767 RBL 45 AFT CARGO BAY. REMOVED FABRICATED + INSTALLED NEW 2 ANGLES AT STA 727RBL 45 AFT, IAW B737-800 SRM 51-40-02, SRM 53-00-53, SRM 51-40-02 TREATED + PRIMED, IAW B737-800 SRM 51-20-01.SDR SCNA20201207404Angle · corrodedFOUND CORROSION ON Z-ANGLE SEVERAL SPOT FROM STA 500A TO 500I RBL 45. FWD CARGO BAY. REMOVED AND REPLACED Z ANGLE FROM STA 500 A TO 500 I RBL FWD CARGO BAY WITH FABRICATED Z ANGLE, IAW B737-700 SRM 51-40-02 SRM 53-00-53 REPAIR 5 SRM 51-20-01.SDR JR2R20201206648Gusset · corrodedGUSSET AT FLOOR BEAM 89 AND RBL 11 CORRODED.SDR JR2R20201206647Gusset · corrodedGUSSET PLATE THAT SITS ON TOP OF FLOOR BEAM 90 AND BETWEEN RBL 20 THRU RBL 27.SDR JR2R20201206644Doubler · corrodedUPPER FLOOR WEB BETWEEN FLOOR BEAMS 87 THRU 88 AND RBL 11 THRU RBL 40 ARE CORRODED.SDR SWAA2021072834470Fitting · crackedLOWE FUSELAGE AT STA 1016 DRAIN FITTING CRACKED. / REMOVED AND REPLACED 2 DRAIN FITTINGS AT LOWER FUSELAGE STA 1016. IAW B737-700 SRM 51-40-02-0G-0 AND DWG# 148A3320SDR SWIA202055295Support Channel · corrodedAFT DRAIN MAST SUPPORT CHANNEL IS CORRODED. C-CHECK RO 1/5/2021. REPLACED AFT DRAIN MAST SUPPORT CHANNEL, REF CRJ-700 SRM 51-42-06-001-001-A01 AND DWGMM670-43200 REV N. COMPLIED WITH TASK CARD 51-900-1002-SKY. LEAK CHECK GOOD.SDR SWIA202054723Intercostal · corrodedINTERCOSTAL BETWEEN FS 319.00 AND FS 349.00 AT STRINGER 20R FOUND TO BE CORRODED. C-CHECK RO 12/24/2020. REMOVED CORRODED INTERCOSTAL AND INSTALLED NEW SERVICEABLE INTERCOSTAL, IAW CRJ-700 SRM. COMPLETED ATTACHED SKY CARD AND M-337. NO CHANGE TO WEIGHT ANDSDR REXA2020122300849Bracket · corrodedFWD CARGO BAY BRACKET IS CORRODED BETWEEN FS 565 TO FS 580 AT STGR 27. LOCATED AND INSTALLED BRACKET PN SH670-33389-2 AT FS 565-580 STRINGER 27, IAW CRJ 900 SRM 51-42-21-001-001-A01 AND IAW CRJ 900 SRM 51-42-22- 001-001-A01.SDR FDEA202012053044Cusp Web · corrodedMAIN CABIN RT CUSP WEB CORRODED BETWEEN STA 580 AND STA 600. REMOVED CORROSION AT MAIN CABIN RT CUSP WEB BETWEEN STA 580 TO STA 600 AND AFTER EVALUATION FOUND CUSP WEB OUT OF LIMITS, IAW B757 SRM 51-10-02, 53-30-13-1A FIG 101 DET VIII. FABRICATED AND INSTASDR FDEA202012053043Cusp Web · corrodedMAIN CABIN RT CUSP WEB CORRODED BETWEEN STA 600 TO 620. REMOVED CORROSION AT MAIN CABIN RT CUSP WEB BETWEEN STA. 600 TO 620 AND EVALUATED ORIGINAL MAT .036", MAT LOSS .015", MAT REM .021". FOUND OUT OF LIMITS, IAW B757 SRM 53-30-13-1A FIG 101 DET VIII. FABRSDR DALA2020120804018Floor Support · corrodedCORROSION FLOOR BEAM LONGITUDINAL AT LEVEL Y450 BETWEEN FR 75/FR 78 AT AFT GALLEY AREA. CORRECTIVE ACTION: REPLACED FLOOR BEAM LOC Y 450 BETWEEN FR 75 TO FR 78 AT AFT GALLEY AREA, AS PER A330 SRM AND DWG.SDR UIEA2020102702317Threshold · corrodedBULK CARGO DOOR BOTTOM FWD CUTOUT ON FUS SUB THRESHOLD SUPT ABOVE EXT, FUSE SKIN CORRODED 3 SQUARE IN. STIFFNER LOCATED AT BULK CARGO DOOR BOTTOM FWD CUTOUT AT FUSE SUB THRESHOLD ABOVE EXT FUSE SKIN HAS 100% MATERIAL LOSS AND OUT OF LIMITS, IAW B767 SRM 53-00SDR UIEA2020110402348Web · corrodedFWD CARGO STA 632 RBL 37-43 CORROSION ON THE OUTBOARD SIDE FWD FACE OF THE WEB. REMOVED CORROSION FROM WEB AT STA 632 RBL 37-43 AND FOUND OUT OF LIMITS, IAW B767 SRM 53-00-51-1A-1. REPAIRED WEB, IAW B767 SRM 53-00-07-2R-3.SDR UIEA2020111002375Support · corrodedON PROCESS INSPECTION OF REMOVAL, FOUND CORROSION ON INTERCOSTAL RBL 28 FROM STA 610 TO 635. REMOVED CORROSION FROM INTERCOSTAL STA 610-635 RBL 28 AND FOUND OUT OF LIMITS, IAW B767 SRM 53-00-04-1A-1. FABRICATED NEW INTERCOSTAL AND APPLIED PROTECTIVE FINISHESSDR UIEA2020111302387Floor Support · corrodedFWD PIT CORROSION UNDER NUTPLATE LOWER SIDE OF WEB 566-588 RBL 4. REMOVED AND EVALUATED FWD CARGO INTERCOSTAL AT STA 566-588 RBL 4 AND FOUND OUT OF LIMITS, IAW B767 SRM 51-10-02. FABRICATED NEW AND INSTALLED INSTERCOSTAL, IAW B767 SRM 51-40-02 AND 53-30-53.SDR UIEA2020111702408Floor Support · corrodedAFT PIT CARGO FLOOR SUPPORT EXFOLIATED STA 1263 LBL 24. REMOVED AND EVALUATED AFT CARGO FLOOR SUPPORT AT STA 1263 LBL 24 FOUND OUT OF LIMITS WITH 100% MATERIAL LOSS. FABRICATED NEW AND INSTALLED FLOOR SUPPORT, IAW B767 SRM 51-10-02, 51-40-02 AND DWG 96F56678SDR UIEA2020111702413Floor Support · corrodedFLOOR BEAM STA 615-632 AND BETWEEN RBL 33-24 HAS CORROSION ON LOWER SURFACE. UPON THE EVALUATION OF FLOOR BEAM AT STA 615-632 BETWEEN RBL 24-33 THE CORROSION ON THE 'L' ANGLES 2 EA WERE FOUND CORRODED WITH 100% MATERIAL LOSS, IAW B767 SRM 51-10-02. FABRICATE
Back to JASC 5320