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 CALA2022122103454Door Sill · corrodedL2 DOOR SILL HAVE CORROSION FWR AND AFT ENDS PER HA ECO LCQ N/R 9296328/40328. FWD SIDE WAS FOUND TO BE WITHIN LIMITS, AFT WAS OUT OF LIMITS, PERFORMED REPAIR PRINCIPLE 5 IAW SRM 53-41-14-300-001. RESTORED SURFACE PROTECTION IAW SRM 51-21-11.SDR FDEA202212202958Angle · chafedLH UPPEREXT FUSELAGE (ZONE 48), SKATE ANGLE AFT EDGE HAS CHAFING WEAR, AFT OF BS 1787 LH SKATE ANGLE REMOVED AND REPLACED IAW BLUEPRINT 148N3101 REV -SDR SWAA2022122083485Bracket · brokenPANEL 192 E L/H FWD HANGER BRACKET BROKE OFF . REMOVED AND REPLACED L/H FWD HANGER BRACKET FOR PANEL 192E IAW SRM 51-40-02.SDR SWAA2023020783301Intercostal · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BS312 TO BS328 AND RBL31 FWD GALLEY AND LAV 2022-697163<[01] REPLACED WEB - INTERCOSTAL AND FASTENERS FLOOR STRUCTURE LOCATED BS312 TO BS328 AND RBL31 FWD GALLEY AND LAV I.A.W B737-700 SRM 51-40-02; SRM 51-10-02 SDR SWAA2023020783299Intercostal · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BS344 TO BS360 AND RBL11 FWD GALLEY AND LAV 2022-697162<[01] TOOL USED: EDDY CURRENT INSTRUMENT P/N: NORTEC 600D; S/N: 210138103; DUE DATE: 11-APR-23;[02] TOOL USED: EDDY CURRENT FLAW DETECTOR; P/N: NORTEC 600 D;SDR SWAA2023020783302Intercostal · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BS344 TO BS360 AND LBL11 FWD GALLEY AND LAV 2022-697161<[01] REPLACED WEB- INTERCOSTAL AND FASTENERS FLOOR STRUCTURE LOCATED BS344 TO BS360 AND LBL11 FWD GALLEY AND LAV IAW B737-700 SRM 51-40-02; SRM 51-10-02 PARSDR SWAA2023020783303Web · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BS277 TO BS294.5 AT BL0 FWD GALLEY AND LAV 2022-697160<[01] REPLACED NEW WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BS 277 TO BS 294.5 AT BL 0 FWD GALLEY AND LAV I.A.W B737-700 SRM 51-10-02 AND DWG 141A5400; SHEETSDR SWAA2023020783306Intercostal · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BS312 TO BS328 AT LBL45 FWD GALLEY AND LAV 2022-697155<[01] REPLACED WEB - INTERCOSTAL FLOOR STRUCTURE AND FASTENERS LOCATED BS312 TO BS328 AT LBL45 FWD GALLEY AND LAV IAW B737-700 SRM 51-10-02; SRM 51-40-02 AND SDR SWAA2023020783307Structure · crackedCRACK INNER CHORD LOCATED BS303.9 AT LEVEL STR17L AT FWD GALLEY AREA 2022-697154<[01] REPLACED INNER CHORD LOCATED AT BS BS270 TO BS360 AT LEVEL STR 17L AT FWD GALLEY AREA IAW B737-700 SRM 51-10-02; SRM 51-40-02 AND DWG 141A8110 SHEET: 9 REV: A; DWG 141A8110 SSDR SWAA2023020783304Support Bracket · corrodedCORROSION SUPPORT BRACKET LOCATED BS312 AT LBL56 AND WL208.1 AT FWD GALLEY AREA 2022-697159<[01] REPLACED SUPPORT BRACKET LOCATED BS312 AT LBL56 AND WL208.1 AT FWD GALLEY AREA IAW B737-700 SRM 51-10-02 SEE INDIVIDUAL SIGNOFFS BELOW.;[02] CORRECTIVE ACTION 1 COSDR SWAA2023020783305Support Bracket · corrodedCORROSION SUPPORT BRACKET LOCATED BS344 AT LBL59 AND WL208.1 AT FWD GALLEY AREA 2022-697158<[01] REPLACED SUPPORT BRACKET LOCATED BS344 AT LBL59 AND WL208.1 AT FWD GALLEY ARE IAW B737-700 SRM 51-10-02; 51-40-02 SEE INDIVIDUALS SIGN OFF BELOW;[02] CORRECTIVE ACSDR SWAA2023020183331Sill Drain · elongatedELONGATED HOLE LOWER SILL LOCATED BILGE AREA BETWEEN BS440 TO BS492.4 AT FWD CARGO COMPARTMENT 2022-695552<[01] REPLACED LOWER SILL LOCATED BILGE AREA BETWEEN BS440 TO BS492.4 AT FWD CARGO COMPARTMENT IAW BOEING 737-700 SRM 51-40-02; SRM 51-10-02 ITEM 9 DWG-14SDR SWAA2023020183330Angle · corrodedCORROSION ANGLE LOCATED BS500D BETWEEN STR26L TO STR26R FLOOR STRUCTURE WL156 FWD CARGO COMPARTMENT 2022-695557<[01] REPLACED ANGLE LOCATED BS500D BETWEEN STR26L TO STR26R FLOOR STRUCTURE WL156 FWD CARGO COMPARTMENT IAW 51-10-02 ITEM 9; DWG 143A9481 REV:- SHEESDR SWAA2023020183329Intercostal · corrodedCORROSION WEB - INTERCOSTAL LOCATED BETWEEN BS500 TO500A AND RBL22; WL156 FWD CARGO COMPARTMENT 2022-695555<[01] REPLACED WEB-INTERCOSTAL LOCATED BETWEEN BS500 TO500A AND RBL22; WL156 FWD CARGO COMPARTMENT IAW<BR>B737-700 SRM 51-10-02 ITEM 9 AND SRM 51-40-02 DSDR SWAA2023012383347Angle · crackedCRACK ANGLE FLOOR STRUCTURE LOCATED AT BS 695 BL0 FWD SIDE WL208.1 CENTER SECTION. REPLACED ANGLE AND FASTENERS ANGLE FLOOR STRUCTURE LOCATED AT BS 695 BL0 FWD SIDE WL208.1 CENTER SECTION IAW SRM 51-40-02, SRM 51-10-02, AND DWG 237A9110, SHEET 6, REV A.SDR SWAA2023012383348Angle · crackedCRACK ANGLE FLOOR STRUCTURE LOCATED AT BS 695 RBL24.7 LOWER SURFACE WL 208.1 CENTER SECTION 2022-700744<[01] TOOLS USED: TEMPERATURE CONTROLLER P/N: P3015GOES00000; S/N: 112031023; DUE DATE: 01-FEB-23; CONTROLLER P/N: 48VFL11; S/N: 31448; DUE DATE: 14-JUN-23.;SDR SWAA2023012383343Stiffener · crackedCRACK STIFFENER FLOOR STRUCTURE LOCATED AT BS 540 BETWEEN BL0 AND RBL24.7 WL 208.1 CENTER SECTION 2022-700742<[01] REPLACED STIFFENER ON FLOOR STRUCTURE LOCATED AT BS 540 BETWEEN BL0 AND RBL24.7 WL 208.1 CENTER SECTION IAW B737-700 SRM 51-10-02 ITEM 9 AND DWG SDR SWAA2023012383346Stiffener · crackedCRACK STIFFENER FLOOR STRUCTURE LOCATED AT BS 540 BETWEEN BL0 AND LBL24.7 WL 208.1 CENTER SECTION 2022-700741<[01] REPLACED STIFFENER ON FLOOR STRUCTURE LOCATED AT BS 540 BETWEEN BL0 AND LBL24.7 WL 208.1 CENTER SECTION IAW B737-700 SRM 51-10-02 ITEM 9 AND DRAWSDR AALA202301195829Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN FLOOR BEAM BETWEEN FR 64 AND FR 67 AT -Y465. MAINTENANCE REPLACED FLOOR BEAM PER SRM 51-72-11.SDR AALA202301194284Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN FLOOR BEAM BETWEEN FR 66 AND FR 70 AT -Y765. MAINTENANCE REPLACED FLOOR BEAM PER SRM 51-72-11.SDR AALA202301199884Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN FLOOR BEAM BETWEEN FR 64 AND FR 66 AT +Y1292. MAINTENANCE REPLACED FLOOR BEAM PER SRM 51-72-11.SDR FDEA202212190122Floor Support · damagedMAIN DECK: SUB-FLOOR SUPPORT BRACKET IS BROKEN AT APPROX. STA. 890 LBL 70. "BROKEN" WRITTEN IN RED GREASE PENCIL REMOVE AND REPLACE PER. DOUGLAS DRAWING NCA6018SDR AALA202301183911Channel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD PASSENGER CABIN FLOOR STRUCTURE SUPPORT CHANNEL LOCATED FROM BS 259 TO BS 269 AT BL 0. REPLACED CHANNEL PER SRM 53-10-51-1A.SDR K11A2023011760178Strap · corrodedSTA 740 L/H LBL 55 EVIDENCE OF CORROSION ON STRAP ON THE UNDERSIDE OF FRAME.SDR AALA202301100718Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT INTERCOSTAL LOCATED AT BS 937 AT RBL 3. REPLACED INTERCOSTAL PER AARD 51-00-05-01, SRM 51-40-02 AND DWG 147A7500.SDR DALA2023010500084Structure · corrodedCORROSION FLOOR STRUCTURE CORNER FITTING FRAME 66 AND STRINGER 23RH AT AFT GALLEY AREA. REPLACED CORNER FITTING AND FASTENERS FRAME 66 AND STRINGER 23RH ON FLOOR STRUCTURE AT AFT GALLEY AREA AS PER A321 SRM 51-72-11AND DWG D53480505 RELEASE DATE 26/JAN/21 ISSUSDR AALA202301048376Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN Z ANGLE LOCATED AT BS 992, WL 208, AND RBL 31. REPLACED Z ANGLE PER SRM 51-40-02, AARD 51-00-05-1 AND DWG 147A5700.SDR AALA202301042932Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD LOCATED FROM BS 767 TO BS 787 AT RBL 36. REPLACED SHIELD PER AARD 51-00-05-1 AND SRM 51-40-02.SDR AALA202301045348Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN Z ANGLE LOCATED AT BS 992, WL 208, AND FROM RBL 34 TO RBL 43. REPLACED ANGLE PER SRM 51-40-02, DWG 147A5700 AND AARD 51-00-05-1.SDR AALA202212277267Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR LEFT HAND TRANSITION PANEL LOCATED BETWEEN BS 440 AND BS 500I AT RBL 21. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5 REPAIR 5.SDR AALA202212277433Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR RIGHT HAND TRANSITION PANEL LOCATED BETWEEN BS 500A AND BS 500I AT RBL 21. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5 REPAIR 5.SDR AALA202212278419Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL LOCATED FROM BS 1018 TO BS 1028 AT RBL 17. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202212272815Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT INTERCOSTAL LOCATED FROM BS 460 TO BS 480 AT S25L. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202212274935Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT INTERCOSTAL LOCATED FROM BS 500A TO BS 500B AT S25L. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202212276622Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT INTERCOSTAL LOCATED AT BS 500I AND S25L. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202212275497Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT INTERCOSTAL LOCATED FROM BS 500D TO BS 500E AT S25L. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202212277895Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL LOCATED FROM BS 967 TO BS 987 AT RBL 15. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR DALA2022122008264Pan · corrodedWASTE BOX PAN HAS CORRODED SPOT AT INBD UPPER CORNER. REPAIRED PER PRI 604453-14 REV 0, REV 1, REV 2, AND REV 3 AND VERIFIED WORK ACCOMPLISHED MATCHES ER/A 604453-14 REV ORIGINAL. CORROSION PRESENT ON WASTE BOX WAS BEYOND LIMITS. REPLACED WASTE BOX REF A220 ASSDR AALA202212209261Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT RIGHT HAND BAFFLE LOCATED FROM BS 500G TO 500H AND RBL 25. REPLACED BAFFLE PER SRM 51-40-02, AARD 51-00-05-1 AND DWG 143A7505.SDR AALA202212203638Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT RIGHT HAND BAFFLE LOCATED FROM BS 500F TO 500G AND RBL 25. REPLACED BAFFLE PER SRM 51-40-02, AARD 51-00-05-1, AND DWG 143A7505.SDR DALA2022121908173Floor Support · corrodedCORROSION ON FLOOR SUPPORT STA Y=180 BTW X=-9 - X=-42. CORROSION LEVEL 2. FLOOR SUPPORT WAS REPLACED IAW SRM 51-41-02-0G AND B717-200 SRM 51-41-05-0G.SDR AALA202302216974Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23R. MAINTENANCE REPLACED SHEAR PLATE PER SRM 51-72-11.SDR AALA202302169723Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23L. MAINTENANCE REPLACED SHEAR PLATE PER SRM 51-72-11.SDR AALA202302064580Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND AFT PASSENGER / CREW DOOR CUT OUT LOWER AFT CORNER SHAPE FITTING FASTENER HOLE CRACKED AT FR 68 BETWEEN S22L AND S23L. MAINTENANCE REPLACED AFT CORNER SHAPE FITTING PER SRM 51-42-11.SDR SWAA2023020182954Support Angle · elongatedELONGATED HOLE ANGLE - SUPPORT LOCATED BS727D AND STR24L AFT CARGO COMPARTMENT 2022-695518<[01] NOMINAL HOLE DIAMETER ON ANGLE - SUPPORT LOCATED BS727D AND STR24L AFT CARGO COMPARTMENT IS =0.250? IAW DWG 146A9403 SHEET 30 REV C AND DRILLED HOLE DIAMETER IS =0.SDR SWAA2023020182950Intercostal · corrodedCORROSION WEB - INTERCOSTAL LOCATED BETWEEN BS767 TO BS794.3 AND RBL21; WL156 AFT CARGO COMPARTMENT 2022-695505<[01] REPLACED WEB - INTERCOSTAL LOCATED BETWEEN BS767 TO BS794.3 AND RBL21; WL156 AFT CARGO COMPARTMENT IAW B737 700 SRM 51-40-02 SRM 51-10-02 ITEM SDR SWAA2023020182946Support · corrodedCORROSION SUPPORT ZEE LOCATED BETWEEN BS727 TO BS767 AND RBL21; WL156 AFT CARGO COMPARTMENT 2022-695501<[01] REPLACED SUPPORT ZEE LOCATED BETWEEN BS727 TO BS767 AND RBL21; WL156 AFT CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 AND SRM 51-10-02 ITEM 9 SEE INDIVISDR SWAA2023020182947Support · corrodedCORROSION SUPPORT ZEE LOCATED BETWEEN BS727 TO BS847 AND LBL21; WL156 AFT CARGO COMPARTMENT 2022-695503<[01] REPLACED SUPPORT ZEE LOCATED BETWEEN BS727 TO BS847 AND LBL21; WL156 AFT CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 AND SRM 51-10-02 ITEM 9 SEE INDIVISDR SWAA2023020182967Angle · corrodedCORROSION ANGLE LOCATED BS947.5 BETWEEN STR26L TO STR26R AND WL156 AT AFT CARGO COMPARTMENT 2022-695536<[01] REPLACED ANGLE LOCATED BS947.5 BETWEEN STR26L TO STR26R AND WL156 AT AFT CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 AND DWG 149A8117 SHEET 4 REV C; SESDR SWAA2023020197453Stiffener · elongated(CUSTOMER REQUEST) ELONGATED HOLE 2 E/A ON STIFFENER LOC. BS663 L/H AT LBL 15 MAIN WHEEL WELL COMPARTMENT 2022-691906<[01] TOOL USED PN: NORTEC 600D; SN:220272712; DUE DATE: 17-DEC-23.;[02] TOOL USED EDDY CURRENT EQUIPMENT PN: NORTEC500D; SN: N500X11290U021704
Back to JASC 5320