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 SWIA2020090152098Strap · corroded*FLOOR STRAP AT FS 559.0 LBL 18-27 CORRODED (C-CHECK) RO 8/28/2020 REMOVED CORROSION ON FLOOR STRAP AT FS 559.0 & LBL 27-36 REF CRJ 200 SRM. ORIGINAL THICKNESS IS 0.050" WITH REMAINING 0.042" AND MATERIAL LOSS 0.008", MAX. PERMISSIBLE IS 0.005", THEREFOSDR SWAA2020082503380Floor Support · damagedFWD CABIN BETWEEN STA. 312 AND STA. 328 LBL 46 INTERCOSTAL FASTENER HOLE IS DAMAGED AND CRACKED. [DOT 124-016] / REPLACE INTERCOSTAL @ FWD CABIN BETWEEN STA 312 AND 328 LBL 46 AS PER B737-700 SRM 51-40-02-0G-0SDR SWAA2020082503381Floor Support · crackedFWD CABIN BETWEEN STA. 328 AND STA. 344 LBL 46 INTERCOSTAL HAS 2 CRACKS EXTENDING FROM FASTENER HOLE. [DOT 124-017] / REPLACED INTERCOSTAL @ FWD CABIN BETWEEN STA 328 AND STA 344 LBL 46 AS PER B737-700 SRM 51-40-02-0G-0SDR SWAA2020081708506Floor Support · crackedMAIN CABIN STA 540 RBL 1' INTERCOSTAL CRACKED / REMOVED AND REPLACED INTERCOSTAL P/N 143A5240-36 AT STA 540 RBL 0 TO RBL 24 PER SRM 51-40-02.SDR SWAA2020081708505Floor Support · crackedMAIN CABIN STA 540 LBL 1' INTERCOSTAL CRACKED / REMOVED AND REPLACED PER SRM 51-40-02SDR AALA2020080769021Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CENTER INTERCOSTAL AT STA 294.5 AND BL 0, MEASURING L=1.125 IN, W=0.75 IN, D=0.063 IN. REPLACED INTERCOSTAL WITH NEW IAW AARD 51-00-05.SDR FDEA2020073051716Angle · crackedAFT CARGO BILGE, CRACK ON FLOOR SUPPORT ANGLE AT FWD BULKHEAD, BS 1786, LBL 10.SDR SWAA2021062403734Scuff Plate · crackedAFT CARGO DOOR LOWER SURROUND STRUCTURE FWD SCUFF CRACKED; DOT56-01. / RECIEVED AFT CARGO DOOR LOWER SURROUND STRUCTURE FWD SCUFF PLATE; INSTALLATION WILL BE ACCOMPLISHED IN ITEM J753-721-00-01SDR SWIA2020090952429Floor Support · corrodedFLOOR SUPPORT BOLT HOLE DOUBLER AT FS 317 RBL 6 IS CORRODED. C-CHECK RO 9/5/2020. FLOOR SUPPORT DOUBLER WAS REMOVED, IAW CRJ 200 SRM. NEW PART WAS FABRICATED WITH DRAWING AND TEMPLATE AND INSTALLED IAW CRJ 200 SRM, AS DOCUMENTED ON ATTACHED CONTINUATION CARSDR SWIA2020090952423Floor Support · corrodedPAX DOOR LOWER SILL FLOOR SUPPORT CAP ANGLE HAS CORRODED FASTENERS. C-CHECK RO 9/5/2020. REMOVED AND REPLACED CORRODED FASTENERS IAW CRJ-200-SRM.SDR SWIA2020090952422Floor Support · corrodedPAX DOOR LOWER SILL FLOOR SUPPORT CUPS ARE CORRODED. C-CHECK RO 9/5/2020. PAX DOOR LOWER SILL FLOOR SUPPORT CUPS AND CLEATS WERE REMOVED AND NEW PARTS INSTALLED, IAW CRJ 200 SRM AS DOCUMENTED ON ATTACHED CONTINUATION CARD.SDR SWIA2020090952421Floor Support · corrodedFLOOR SUPPORT BOLT HOLE DOUBLER AT FS 310 LBL 37 IS CORRODED. C-CHECK RO 9/5/2020. FABRICATED NEW BOLT HOLE DOUBLER AND INSTALLED IAW CRJ 200 SRM.SDR SWIA2020082051880Floor Support · corroded* CORROSION DETECTED ON TOP SIDE OF AFT CARGO BAY FLOOR "BEAM" AT (RBL 9.00) IN NUMEROUS PLACES, BETWEEN F.S. 1000.00 AND F.S. 1069.75 (MARKED). (C-CHECK) RO 8/14/2020 REPLACED FLOORBEAM ON AFT CARGO BAY FLOOR FS1025 - FS1037 RBL9 REF CRJ-700 SRM.SEE CONTSDR SWIA2020082051879Floor Support · corroded* CORROSION DETECTED ON TOP SIDE OF AFT CARGO BAY FLOOR "BEAM" AT (LBL 27.00) IN NUMEROUS PLACES, BETWEEN F.S. 985.00 AND F.S. 1051.30 (MARKED). (C-CHECK) RO 8/14/2020 REPLACED FLOORBEAM ON AFT CARGO BAY FLOOR FS985 - FS1051.30 RBL9 REF CRJ-700 SRM. SESDR SWIA2020082051878Floor Support · corrodedCORROSION DETECTED ON L/H FLOOR "SILL" (4EA) PLACES, BETWEEN F.S. 985.00 AND F.S 1000.00 (MARKED). (C-CHECK) RO 8/14/2020 EVALUATED L/H FLOOR SILL BETWEEN F.S 985.00 AND F.S 1000.00 FOUND CORROSION 100% THROUGH PART. OUT OF LIMITS IAW CRJ 700 SRM. REPAIRSDR SWAA2020081203471Support · crackedCRACK SUPPORT ZEE LOCATED BTW BS727 TO BS847 AT LEVEL STR25L AND LBL 21.00 AFT CARGO COMPARTMENT / REPLACED SUPPORT ZEE LOCATED BTW B727 TO BS847 AT LEVEL STR25L AND LBL 21.00 AFT CARGO COMPARTMENT IAW SRM B737-700 51-40-02;53-00-53-2R-6 REPAIR 6 AND DWG'S 146SDR SWAA2020081203882Web · corrodedCORROSION FLOOR STRUCTURE WEB LOCATED BTW BS 767 TO BS 787 AT LEVEL OFSTR 25R AND RBL 21.00 AT AFT CARGO COMPARTMENT WL 156.5 / REPLACED WEB LOCATED BETWEEN BST 767 TO BST 787 AT LEVEL OF STR 25 RH AND RBL 21.00 AT AFT CARGO COMPARTMENT WL 156.5 IAW SRM B737-7SDR SWAA2020081203881Web · corrodedCORROSION BILGE AREA ON WEB LOCATED BTW BS 787 TO BS 807 STR 27R AND RBL3.00 AT AFT CARGO COMPARTMENT WL 156.5 / REPLACED WEB LOCATED BETWEEN BS 787 TO BS 807 STR 27R AND RBL 3.00 WL 156.5 AFT CARGO COMPARTMENT IAW SRM B737-700 51-10-02 PARAGRAPH 9 AND DRAWINGSDR AALA202008109023Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF LH TRANSITION PANEL AT FASTENER HOLES BETWEEN STA 500A AND STA 500I AT STR 25L, MEASURING L=1.5 IN, W=1.5 IN, D=0.033 IN. REPLACED TRANSITION PANEL WITH NEW IAW AARD 51-00-05-1.SDR ASAA2020080432977Transition Panel · corrodedFWD PIT RT TRANSITION PANEL CORRODED AT STA 500K. GROUNDED - YES. BLENDOUT CORROSION ON R/H TRANSITION PNL IN FWD CARGO PIT, FOUND TO BE OUT OF LIMITS IAW SRM 53 30 53 01 2 FABRICATED,LOCATED AND DRILLED AND INSTALLED NEW REPAIR PARTS IAW SRM 53-00-53-2R-5 REPSDR AALA2020080309011Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CREASE ANGLE BETWEEN BS 947 AND BS 967 AT RBL 54. REPAIRED CREASE ANGLE PER SRM 53-60-13.SDR AALA2020080309010Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CREASE ANGLE BETWEEN BS 947 AND BS 967 AT LBL 54. REPAIRED CREASE ANGLE PER SRM 53-60-13.SDR SWAA2021081503468Channel · corrodedCORROSION CHANNEL SIDEPLATE LOCATED BETWEEN BS492.4 TO BS500A; RBL21 AND WL156.5 AT FWD CARGO COMPARTMENT WL 156.5 / REPLACED CHANNEL SIDEPLATE LOC BTW BS492.4 TO BS500A; RBL21 AND WL156.5 AT FWD CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 SRM 51-10-02 AND DWGSDR SWAA2021081303608Splice Angle · corroded***CORROSION*** ON SPLICE AT AREA AFT OF ACB BS1016 BL0 WL187. MARKED / REMOVED SPLICE ANGLE AT AREA AFT OF ACB BS1016 BL0 WL187 I.A.W SRM 51-40-02-0G-0. REPLACED NEW SPLICE I.A.W SRM 51-40-02-0G-0 AND DWG 147A0070SDR SWAA2021081303616Strap · corroded***CORROSION*** ON STRAP AT AREA AFT OF ACB BS967 RBL40 WL193. MARKED / REMOVED CORROSION ON STRAP B/S 967 RBL40 WL193 DIMENSIONS L=1' W=0.700' ORIGINAL THICKNESS 0.056' REMAINING THICKNESS 0.053' MATERIAL LOSS 0.003' IAW SRM 51-10-02 PARAGRAPH 15 AND FOUND ALSDR SWAA2021081303466Strap · corrodedCORROSION STRAP LOCATED BETWEEN BS430; RBL21 TO LBL21 AND WL 156.5 AT FWD CARGO COMPARTMENT WL 156.5 / REPLACED STRAP LOC BTW BS430;RBL21 TO LBL21 AND WL 156.5 AT FWD CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 AND SRM 51-10-02SDR SWAA2021062906320Angle · corrodedAFT CARGO RH TRANSITION ANGLE HAS CORROSION ON AROUND NUT PLATE HOLES FROM STA 767 TO STA 794. / REMOVED CORROSION ON AFT CARGO RH TRANSITION ANGLE AROUND NUT PLATE HOLES FROM STA 767 TO STA 794. FOUND TO BE OUT OF LIMITS PER SRM 53-00-53-1A. REMOVED AND REPLASDR SWAA2021062906317Angle · corrodedAFT CARGO RH TRANSITION ANGLE HAS CORROSION ON AROUND NUT PLATE HOLES FROM STA 727 TO STA 767. / REMOVED AND REPLACED AFT CARGO RH TRANSITION ANGLE DUE TO CORROSION ON AROUND NUT PLATE HOLES BEING OUT OF LIMIT PER SRM53-00-53-1A FROM STA 727 TO STA 767. INSTALSDR SWAA2021062906318Angle · corrodedAFT CARGO LH TRANSITION ANGLE HAS CORROSION ON AROUND NUT PLATE HOLES FROM STA 727 TO STA 847. / REMOVED AND REPLACE TRANSITION ANGLE PER SRM 51-40-02.SDR SWAA2021052604873Gusset · crackedFWD CARGO AT STA 500D S-21L GUSSET BRACKET CRACK. / REMOVED AND REPLACED FWD CARGO GUSSET AT BS 500D S21L REF B737-700 SRM 51-40-02-0G-0 AND 51-40-05-G-0SDR SWAA2021052604872Gusset · crackedFWD CARGO AT STA 500D S-19L GUSSET BRACKET CRACK. / ACCOMPLISHED TOUCHED-UP PRIMER ON #1 ENGINE I/B AND O/B T/R STRIPS REF B737 AMM 51-21-72-370-804.SDR SWIA2020091652498Structure · crackedLT FWD EQUIPTMENT BAY FLOOR AT FRAME 193.00 POSSIBLE CRACK. C-CHECK RO 9/12/2020. COMPLIED WITH PERMANENT REPAIR RT FWD EQUIPMENT BAY FLOOR, REF REO. ALL APPLICABLE STEPS COMPLIED WITH, ALL CHECKS OKAY, COMPLETED TASK CARD.SDR SWIA2020090952419Strap · corrodedRT PRESSURE FLOOR STRAP CORRODED AT APPROX FS 559.00 AND BETWEEN RBL 36 AND RBL 45.00. C-CHECK RO 9/5/2020. REMOVED AND REPLACED RT PRESSURE FLOOR STRAP AT APPROX FS 559 BETWEEN RBL 36 AND RBL 45 P/N 601R31025-29, IAW CRJ200 SRM.SDR SWIA2020090952418Floor Support · corrodedRT FLOOR SILL CORRODED BETWEEN FS 559 TO FS 559+80 IN SEVERAL LOCATIONS ALONG RBL 42.90. C-CHECK RO 9/5/2020. COMPLIED WITH BOMBARDIER REO.SDR SWIA2020090952398Angle · crackedAFT EQUIPMENT BAY LEFT AND RIGHT FS 621 TO FS 625 OBLIQUE ANGLE CRACKED. C-CHECK RO 9/5/2020. REMOVED AND REPLACED LEFT AND RIGHT FS 621 TO FS 625 OBLIQUE ANGLES, IAW CRJ 200 SRM.SDR SWIA2020090952374Stand Off · brokenAFT EQUIP BAY RT SIDE RIVETED STAND OFF CLIP HAS BROKEN FREE OF STRINGER. C-CHECK RO 9/5/2020. FOUND STRINGER TO BE DAMAGED AND IN NEED OF REPAIR. REPAIRED STRINGER 18R IAW CRJ 200 SRM. CUT OUT DAMAGE AND INSTALLED REPAIR PARTS AS DOCUMENTED ON ATTACHED COSDR SWIA2020090952372Strap · corrodedLT PRESSURE FLOOR STRAP CORRODED AT APPROX FS 559.00 AND BETWEEN LBL 36 AND LBL 45.00. C-CHECK RO 9/5/2020. REMOVED AND REPLACED LT PRESSURE FLOOR STRAP AT APPX FS559 BETWEEN LBL36 AND LBL 45, IAW CRJ200 SRM.SDR AALA202008319013Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN SHEAR PLATE AT FR69+5 AND STR 23R, MEASURING L=1.570 IN. REPLACED SHEAR PLATE WITH NEW IAW A321 SRM 51-72-11-911-001 AND DRAWING D53474180.SDR SWAA2020083105784Support Angle · crackedCRACK SUPPORT ANGLE LOCATED BS692 AT BL0 CENTER SECTION (2 EA) / REPLACED SUPPORT ANGLE 2E/A LOCATED BS692 AT BL0 CENTER SECTION IAW B737-700 SRM 51-40-02 AND DWG 273A9110 SHEET 5 REV ASDR FDEA2020083131937Floor Support · corrodedAFT FLOOR INTERCOSTAL SUPPORT CORRODED BSTA 1661 BSTA 1681 LBL 53.5 REMOVED AFT FLOOR INTERCOSTAL SUPPORT IAW SRM 51-40-02. FABRICATED NEW SUPPORT IAW ST MOBILE AREOSPACE DRAWING 11864179-9 AND FEDEX GMM 7-0-1001. SUPPORT INSTALLED IAW SRM 51-40-02.SDR FDEA2020082031937Floor Support · corrodedAFT FLOOR SUPPORT CORRODED BS 1661 - 1681, LBL 53.5. REMOVED THE AFT FLOOR SUPPORT IAW SRM 51-40-02. FABRICATED A NEW FLOOR SUPPORT IAW DRAWING 11864179-9, AND GMM 7-0-1001. THE FLOOR SUPPORT WAS INSTALLED IAW SRM 51-40-02.SDR SWIA202082051877Floor Support · crackedL/H COCKPIT, FLOORBOARD SUPPORT ANGLE LOCATED BETWEEN FS 265.00 TO FS 280.00 AT LBL 12 HAS CRACK ON AFT END. REMOVED AND REPLACED L/H COCKPIT FLOORBOARD SUPPORT ANGLE IAW SRM AND DWG.SDR SWAA2020081303455Support Angle · crackedCRACK ANGLE - SUPPORT LOCATED ON BS500C FWD FACE AND STR26L FWD CARGO COMPARTMENT / REPLACED ANGLE - SUPPORT LOC ON BS500C FWD FACE AND STR.26L FWD CARGO COMP IAW B737-700 SRM 51-40-02 AND DWG #143A7505 REV.-SDR SWAA2020081303458Support Angle · crackedCRACK ANGLE - SUPPORT LOCATED ON BS500C AFT FACE AND STR26L FWD CARGO COMPARTMENT / REPLACED ANGLE - SUPPORT LOC. ON BS500C AFT FACE STR.26L FWD CARGO COMPARTMENT IAW B737-700 SRM 51-42-02 DWG #143A7505 REV.ASDR SWAA2020081303459Support Angle · crackedCRACK ANGLE - SUPPORT LOCATED ON BS500B FWD FACE AND STR26L FWD CARGO COMPARTMENT / REPLACED NAGLE-SUPPORT LOC ON VS500B FWD FACE STR STR 26L FWD CARGO COMPARTMENT IAW B737-700 SRM 51-40-02-0G-0 DWG # 143A7505 REV BSDR SWAA2020081303460Support Angle · crackedCRACK ANGLE - SUPPORT LOCATED ON BS500B AFT FACE AND STR26L FWD CARGO COMPARTMENT / REPLACED ANGLE- SUPPORT LOC. ON BS500B AFT FACE AND STR.26L FWD CARGO COMPARTMENT IAW SRM B737-700 51-40-02 DWG #143A7505 REV.BSDR SWAA2020081303462Support Angle · crackedCRACK ANGLE - SUPPORT LOCATED ON BS500A FWD FACE AND STR26L FWD CARGO COMPARTMENT / REPLACED SUPPORT ANGLE LOC ON BS 500A FWD FACE AND STR26L FWD CARGO COMPART IAW B737-700 SRM 51-40-02 DWG #143A7502-159 REV ASDR SWAA2020081303463Support Angle · crackedCRACK ANGLE - SUPPORT LOCATED ON BS480 FWD FACE AND STR26L FWD CARGO COMPARTMENT / REPLACED ANGLE-SUPPORT ; AND FASTENERS LOC. BS480 FWD FACE AND STR.26L FWD CARGO COMPARTMENT IAW B737-700 SRM 51-40-02-0G-0 DWG#143A7505 REV.-SDR SWAA2020081303464Support Angle · crackedCRACK ANGLE - SUPPORT LOCATED ON BS460 AFT FACE AND STR26L FWD CARGO COMPARTMENT / REPLACED ANGLE SUPPORT LOC ON BS 460 AFT FACE AND SW 26L FWD CARGO COMPARTMENT IAW B737-700 SRM 51-40-02-0G-0 DWG #143A7505 REV ASDR SWAA2020081303465Support Angle · crackedCRACKED SUPPORT ANGLE BS 500B FWD FACE AND STRINGER 26R FWD CARGO COMPARTMENT. REPLACED THE SUPPORT ANGLE IAW SRM 51-40-02-0G-0, AND DWG 1143A7505, REV B.
Back to JASC 5320