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 DALA2020111603729Floor Support · corrodedCORROSION FLOOR BEAM -Y765 BETWEEN FR 66 TO FR 70 AT AFT GALLEY AREA. CORRECTIVE ACTION: REPLACED FLOOR BEAM -Y765 BETWEEN FR 66 TO FR 70 AT AFT GALLEY AREA, AS PER A319 SRM 51-72-11.SDR DALA2020111603728Floor Support · corrodedCORROSION FLOOR STRUCTURE BEAM LOCATED BETWEEN FR 68 TO FR 69 AND - Y1162 IN PASSENGER CABIN. CORRECTIVE ACTION: REPLACED FLOOR BEAM AND FASTENERS LOCATED BETWEEN FR 68 TO FR 69 AND -Y1162 IN PASSENGER CABIN, AS PER A319 SRM 51-42-11 AND DWG D53472780 ISSUE KSDR SWAA2021080336009Bullnose · damagedTHE AFT CARGO ENTRY THRESHOLD BULLNOSE HAS AREAS OF DAMAGE. / INSTALLED NEW BULLNOSE PER A/M/M 53-11-02 AND LEAK CHECK PER M/M 05-51-91. LEAK CHECK GOOD.SDR SWAA2021072731986Angle · crackedCRACK ANGLE LOCATED BS500B FWD FACE AND STR 26L FWD CARGO COMPARTMENT / REPLACED ANGLE LOCATED BS 500B FWD FACE AND STR.26L FWD CARGO COMPARTMENT IAW B737-700 SRM 51-10-02 ITEM 9 B737-700 SRM 51-40-02 AND DRAWING 143A7505 REV.- ANGLE P/N:143A7502U159SDR SWAA2021060230490Pan · crackedAFT GALLEY SERVICE DOOR LOWER GATE SWEEPER BRACKET CRACKED. / R&R AFT GALLEY SERVICE DOOR LOWER PAN PER AMM 52-41-31.SDR SWAA2021052531985Gusset · crackedCRACK GUSSET LOCATED BS 500D AND STR 19L FWD CARGO COMPARTMENT / REPLACED GUSSET LOCATED AT BS5000 AND STR.19L FWD CARGO COMPARTMENT IAW B737-700 SRM 51-10-02 PARAGRAPH 9 51-40-02 AND DWG N 143A7902 REV.-SDR SWAA2021052531984Gusset · crackedCRACK GUSSET LOCATED BS 500D AND STR 19R FWD CARGO COMPARTMENT / REPLACED GUSSET LOCATED ON BS 500D AND STR19R AT FWD CARGO COMPARTMNET IAW B737-700 SRM 51-40-02 AND DWG #143A7902 REV.-SDR SWIA202055265Support Fitting · corrodedSTR 21R AVIONICS SUPPORT CLEAT PN: SH670-32605-1 AT FS 319.70 CORRODED. C-CHECK RO 1/5/2021. REMOVED, LOCATED, DRILLED, AND INSTALLED NEW STR 21R SUPPORT CLEAT AT FS 319.70, REF CRJ-700 SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01 PN SH670-32605-1.SDR SWAA2020121433737Plate · corrodedCORROSION CHANNEL SIDEPLATE LOCATED BS 500A TO BS 500B AND STR 26L WL 156 AT FWD CARGO COMPARTMENT. BLENDED CORROSION ON CHANNEL SIDE PLATE LOCATED BS 500A TO BS 500B AND STR 26L WL 156 AT FWD CARGO COMPARTMENT MEASURE: P1 L=0.876' W=0.590'; P2 L=0.792' W=0.5SDR SWAA2020121432742Intercostal · corrodedCORROSION WEB-INTERCOSTAL LOCATED BS 492 TO BS 500A AND STR 26R WL 156 FWD CARGO COMPARTMENT. REPLACED WEB-INTERCOSTAL (SHIELD) LOCATED BS 492 TO BS 500A AND STR 26R WL 156 FWD CARGO COMPARTMENT, IAW B737-700 SRM 51-10-02; SRM 51-40-02 AND DWG #143A0080 SHEETSDR SWAA2020121431987Intercostal · crackedCRACK WEB INTERCOSTAL LOCATED BS 927 TO BS 947.5 AND STR 25R AFT CARGO COMPARTMENT. REPLACED WEB LOCATED BS 927 TO BS 947.5 AND STR 25R AFT CARGO, IAW B737-700 SRM 51-10-02 STEP 9 AND DWG NR 147A7500 REV- P/N:147A7500Y22.SDR SCNA20201124332Channel · corrodedFWD CARGO COMP RT ZEE CHANNEL CORROSION AT MULTIPLE FASTENER HOLES STA 500A-STA 500I, RBL 24, WL 156. REMOVED AND REPLACED WITH REPLACEMENT LOT NR 5098219-1, IAW SRM 51-40-02-0G-0 DRG NR 143A7500. FWD CARGO COMPARTMENT STA 500A-500I RBL 24 WL 156.SDR AALA202011209029Angle · crackedAIRCRAFT IN BASE MAINTENANCE. CRACK IN BAFFLE CLIP FWD OF FRAME AT STA 500H AND STR 25R, MEASURING L=0.25 IN. REPLACED BAFFLE CLIP WITH NEW, IAW AARD 51-00-05.SDR AALA202011209028Angle · crackedAIRCRAFT IN BASE MAINTENANCE. CRACK IN BAFFLE CLIP ON AFT SIDE OF FRAME AT STA 500H AND STR 25R, MEASURING L=0.5 IN. REPLACED BAFFLE CLIP WITH NEW, IAW AARD 51-00-05.SDR SWAA2020111730228Vapor Barrier · crackedRIGHT WHEEL WELL VAPOR BARRIER CRACKED AT BS 663.75 BETWEEN RBL 31.83 AND RBL 45.64 8 INCHES ABOVE LOWER PANEL. CRACK MEASURES 14 INCHES, PERFORMED INTERIM REPAIR BY APPLYING BMS SEALANT AND ONE PLY OF BMS 9-3 FIGERGLASS CLOTH TO DAMAGED AREA, PER SRM 57-10-1SDR SWAA2021072132431Angle · crackedCRACK ANGLE LOCATED ON BS 296.5 AT LEVEL STR 17R RBBL 53 AT PASSENGER CABIN / REPLACED ANGLE LOCATED ON BS 296.5 AT LEVEL STR 17R RBBL 53 AT PASSENGER CABIN IAW B737-700 SRM 51-10-02 ITEM 9; B737-700 SRM 51-40-02 AND DRAWING 141A8310SDR SWAA2021062929782Angle · corrodedTHE R/H TRANSITION ANGLE HAS CORROSION FROM STA 787-767 / REMOVED AND REPLACED R/H TRANSITION ANGLE FROM STA 767-787 PER SRM 51-40-02SDR SWAA2021062929783Angle · corrodedTHE RIGHT HAND TRANSITION ANGLE IN THE AFT CARGO PIT HAS CORROSION FROM STA 767 TO 727H / REMOVED PART; FABRICATED AND INSTALLED AFT CARGO R/H TRANSITION ANGLE FROM 727H TO 767 PER SRM 53-00-53-2R-5. INSTALLED AND PUSH TESTED NUTPLATES PER SRM 51-40-10.(SA-M 3SDR SWAA2021060832518Floor Support · crackedCRACK ANGLE FLOOR STRUCTURE LOCATED BS380 TO BS400 AND RBL10 AT PASSENGER CABIN (1 EA) / REPLACED ANGLE FLOOR STRUCTURE LOCATED BS 380 TO BS 400 AND RBL 10 AT PASSENGER CABIN (1EA) IAW B737-700 SRM 51-10-02 ITEM 4 AND DWG 143A5400 SHEET 122 REV -SDR SWAA2021060832519Floor Support · crackedCRACK ANGLE FLOOR STRUCTURE LOCATED BS380 TO BS400 AND LBL13 AT PASSENGER CABIN (1 EA) / REPLACED ANGLE FLOOR STRUCTURE LOCATED BS380 TO BS400 AND LBL 13 AT PASSENGER CABIN (1EA) IAW B737-700 SRM 51-10-02 ITEM 9 AND DWG 143A5400 SHEET 120 REV -SDR SWAA2021051229675Skate Angle · damagedRH FWD SKATE ANGLE IS WOEN OUT OF LIMITS / REMOVED AND REPLACED DAMAGED SKATE ANGLE PER SRM 51-40-02; RESTORED INTERIOR FINISH PER AMM 51-21-99.SDR SWIA202055328Intercostal · corrodedPAX DOOR DD4 INTERCOSTAL CORRODED BETWEEN FS 320.163 AND FS 329.41. C-CHECK RO 1/6/2021. REMOVED AND REPLACED PAX DOOR DD4 INTERCOSTAL P/N 601R318081-1 BETWEEN FS 320.163 AND FS 329.41, IAW CRJ 700 SRM 51-40-11-001-001-A01, 51-42-06-001-001-A01 AND 51-42-21-SDR SWIA202055327Intercostal · corrodedPAX DOOR DD3 INTERCOSTAL CORRODED BETWEEN FS 323 AND FS 338.963. C-CHECK RO 1/6/2021. REMOVED AND REPLACED PAX DOOR DD3 INTERCOSTAL BETWEEN FS 323 AND 338.963, IAW CRJ 700 SRM 51-40-11-001-001-A01, 51-42-06-001-001-A01 AND 51-42-21-001-001-A01 REV 38 7-25-2SDR SWIA202054829Stiffener · crackedRT FS 280 LOWER WEB STRUCTURE (STIFFENER) IS CRACKED AT RBL 38.5. C-CHECK RO 12/26/2020. REMOVED AND REPLACED WITH A NEW PART (STIFFENER) RT FS 280 LOWER WEB STRUCTURE, REF CRJ900 SRM.SDR SWIA202054655Intercostal · corrodedCORROSION FOUND ON RT LATCH PIN INTERCOSTAL LOCATED BETWEEN FS 349.00-FS 364.00 AND BETWEEN STGR 27-STGR 26R. C-CHECK RO 12/14/2020. REMOVED AND INSTALLED NEW RT LATCH PIN INTERCOSTAL LOCATED BETWEEN FS 349.00-FS 364.00 AND BETWEEN STGR 27-STGR 26R, REF CRJ SDR SWIA202054653Intercostal · corrodedCORROSION ON BACK-UP SILL AT STGR 21L BETWEEN FS 333.00 AND FS 349.00. C-CHECK RO 12/14/2020. REMOVED AND INSTALLED NEW BACK-UP SILL AT STGR 21L BETWEEN FS 333.00 AND FS 349.00, REF CRJ 700 SRM DWG. COMPLIED WITH TASK CARD. PRESSURE CHECK GOOD.SDR SWIA202054652Intercostal · corrodedCORROSION ON INTERCOSTAL AT 21L FROM FS 310.00 TO FS 333.00. C-CHECK RO 12/14/2020. REMOVED AND INSTALLED NEW INTERCOSTAL AT 21 L FROM FS 310.00 TO 333.00, REF CRJ 700 SRM DWG. COMPLIED WITH TASK CARD. PRESSURE CHECKS GOOD.SDR SWAA2020121433736Floor Support · crackedCRACK WEB-INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN BS 270 TO BS 296 AT BL 0 AT FWD GALLEY AREA. REPLACED WEB-INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN BS 270 TO BS 296 AT BL 0 AT FWD GALLEY AREA, IAW B737-700 SRM 51-10-02 ITEM 9 AND SRM 51-40-02 AND DWG SDR SWAA2020121434949Floor Support · crackedCRACK WEB-INTERCOSTAL FLOOR STRUCTURE LOCATED BS 344 TO BS 360 AND BL 0 FWD GALLEY AND LAV (1 EA). REMOVED AND REPLACED WEB-INTERCOSTAL LOCATED BETWEEN BS 344 TO BS 360 AND BL 0 FLOOR STRUCTURE FWD GALLEY AREA, IAW B737-700 SRM 51-40-02 SRM 51-10-02 DRAWING NSDR SWAA2020120329784Angle · corrodedTHE LT TRANSITION ANGLE IN THE AFT CARGO PIT HAS CORROSION FROM STA 817 TO 727J. REMOVED AND REPLACED SECTION OF LT TRANSITION ANGLE IN AFT CARGO FROM STA 727H + 10' TO STA 807 +10' LBL 21', PER SRM 53-00-53-2R-5. SEE SA-M 326; S/N 1200891 FOR INDIVIDUAL WORSDR SWAA2020113033040Web · crackedCRACK WEB LOCATED BETWEEN BS 294.5 TO BS 303.9 AT LEVEL STR 16L AT FWD GALLEY AREA. REPLACED WEB (INTERCOSTAL) BETWEEN BS 294.5 TO BS 303.9 AT LEVEL STR 16L AT FWD GALLEY AREA, IAW B737-700 SRM 51-10-02 ITEM 9 AND DRAWING AT 141A8180 REC C P/N OF INTERCOSTAL SDR REXA2020113000785Intercostal · corrodedAVIONICS BAY DOOR SURROUND STRUCTURE, FWD INTERCOSTAL BETWEEN FS 349 AND FS 364 AT STGR 27L CORRODED. REMOVED AND INSTALLED NEW INTERCOSTAL AT FS 349-364 AT STR 27L, IAW CRJ 900 SRM 51-42-21-001-001-A01. OPERATIONS CHECK GOOD.SDR R61A2020112800826Floor Support · corrodedCF III FLOOR BEAM BETWEEN FR 86-FR 90 HAS CORROSION APPROXIMATELY 6" FWD OF FR 88. REPAIRED IAW SRM 53-23-10 REPAIR 01.SDR R61A2020112800821Shear Panel · corrodedCF III RT SHEAR PANEL BETWEEN FR 87-FR 88 HAS CORROSION. REPLACED IAW SRM 51-42-01.SDR R61A2020112800820Shear Panel · corrodedCF III CENTER SHEAR PANEL BETWEEN FR 87-FR 88 HAS CORROSION. REPLACED IAW SRM 51-42-01.SDR R61A2020112800819Shear Panel · corrodedCF III LT SHEAR PANEL BETWEEN FR 87-FR 88 HAS CORROSION. REPLACED IAW SRM 51-42-01.SDR R61A2020112800818Floor Support · corrodedCF III FLOOR SUPPORT AFT OF R2 DOOR BETWEEN FR 88-FR 90 HAS CORROSION. REPLACED IAW SRM 51-43-01 & 51-42-01.SDR R61A2020112800817Gusset · corrodedCF III FLOOR STRUCTURE RT INBOARD GUSSET ON FR 90 CROSSBEAM HAS CORROSION. REPLACED IAW SRM 51-41-02.SDR R61A2020112800816Gusset · corrodedCF III FLOOR STRUCTURE RT OUTBOARD GUSSET ON FR 90 CROSSBEAM HAS CORROSION. REPLACED IAW SRM 51-41-02.SDR R61A2020112800815Floor Support · corrodedCF III FLOORBEAM LT UPPER CAP BETWEEN FR 85-FR 86 HAS CORROSION. REPLACED IAW SRM 51-41-01 AND 51-43-01.SDR SWIA202054221Support · crackedFRAME 52 LT WEB SUPPORT CRACKED. C-CHECK RO 11/20/2020. REMOVED AND REPLACED FRAME 52 LT WEB, REF SRM.SDR SCNA20201124359Web · corrodedCORROSION AFT CARGO BS 847-857 RBL 24 WL 158 INTERCOSTAL/WEB TOP FLANGE AND BOTTOM OF FLANGE. REMOVED AND REPLACED INTERCOSTAL WITH A NEW FABRICATED INTERCOSTAL, IAW SRM 51-40-02-0G AND DWGS 146A8321 AND 146A8322 STA 847-857, RBL 24, WL 158.SDR SCNA20201124355Baffle · crackedCRACKED BAFFLE BS 500C-500D LBL 25 WL 156. REMOVED AND REPLACED WITH REPLACEMENT BAFFLE P/O 807474 STA 500C-500D LBL 25 WL 156, IAW SRM 51-40-02-0G-0 DRG 143A7505.SDR SCNA20201124340Support Angle · corrodedFWD CARGO COMP RT FRAME LINING SUPPORT ANGLE HAS CORROSION, STA500D, RBL26, WL160. REMOVED AND REPLACED FWD CARGO COMP RT FRAME LINING SUPPORT ANGLE AT STA 500D, RBL 26, WL 160, IAW SRM 51-40-02-0G-0 AND BOEING DWG NR 143A1225 RIB PO NR 807144.SDR REXA2020111800749Strap · corrodedCARGO BAY FLOOR CAP STRAP CORRODED BETWEEN LBL 9 AND LBL 27 AT FS 589. REMOVED, FABRICATED, LOCATED AND INSTALLED CARGO BAY FLOOR STRAP, IAW CRJ 200 SRM 51-42-06, 51-42-21, 51-24-36, 51-40-11 AND 51-25-00.SDR DALA2020111603749Web · crackedCRACK FLOOR STRUCTURE WEB LOCATED BETWEEN FR 68 TO FR 69 LEVEL STR 23L IN PASSENGER CABIN. CORRECTIVE ACTION: REPLACED NEW STRUCTURE WEB LOCATED BETWEEN FR 68 TO FR 69 LEVEL STR 23L IN PASSENGER CABIN, AS PER A319 SRM 51-72-11.SDR IPXA2020111562399Stiffener · crackedINSPECTION TYPE: 2C INTERCOSTAL CRACKED NEAR RT MLG WHEEL WELL HYD RESV ASSEMBLY. REMOVED, FABRICATED, AND REPLACED STIFFENER, IAW DWG AEA7035 AND SRM 51-33-01. (MINOR)SDR DALA2020111203695Intercostal · corrodedDURING INITIAL INSPECTION MAINTENANCE FOUND LEVEL 2 CORRION ON INTERCOSTAL LT BETWEEN FS STA 780+ 100-780+120, STGR 27L-26L AT FWD CARGO COMPARTMENT. REPAIRED PER SRM.SDR SWAA2021071434756Web · crackedCRACK WEB - INTERCOSTAL LOCATED BS 847 TO 867 AND LBL 22 UPPER POSITION AFT CARGO COMPARTMENT / REPLACED WEB (SUPPORT) LOCATED BS 847 TO BS 867 AND LBL 22 UPPER POSITION AFT CARGO COMPARTMENT IAW B737-700 SRM 51-40-02; SRM 51-10-02 AND DRAWING #149A8100 REV.- SDR SWAA2021062929528Angle · corrodedFORWARD CARGO RIGHT SIDE TRANSITION HAS CORROSION FIS 500C + 500E / REPAIRED FWD CARGO R/H TRANSITION ANGLE STA 500C TO STA 500E IAW SRM 53-00-53-2R-5
Back to JASC 5320