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 YENA2021093000624Shear Plate · corrodedDURING HEAVY MAINTENANCE, CORROSION SHEAR PLATE STR 23RH BTW FR69 & FR 70, AFT GALLEY AREA ( CPCP RELATED REFER TO MPD 534195-01); R & R SHEAR PLATE STGR 23 R, BTW FR69 & FR 70, AFT GALLEY AREA (CPCP RELATED MPD TASK 534195-01). NOTE: REPAIR WAS ACCOMPLISHED SDR YENA2021093000623Floor Support · corrodedDURING HEAVY MAINTENANCE, CORROSION FLOOR BEAM SYTRUCTURE L/H WEB BTW FR69 AT AFT GALLEY AREA (CPCP RELATED REFER TO MPD TASK 534195-01); R & R FLOOR STRUCTURE LH WEB BTW FR69 AND FR70 AT AFT GALLEY AREA IAW SRM A320- 51-72-11 AND DWG D534-74180. WORK WAS ACCOSDR YENA2021093000622Floor Support · corrodedDURING HEAVY MAINTENANCE, CORROSION ON FLOOR BEAM +Y765, FR 68, AT AFT GALLEY AREA (REF CPCP MPD TASK 534195-01); R & R FLOOR BEAM Y765 AT AFT GALLEY AREA IAW A320 SRM 51-42-11 AND A320 SRM 51-72-11, DWG D534-72795 AND DWG D534-78913. REPAIR WAS ACCOMPLISHED ASDR YENA2021093000621Floor Support · corrodedDURING HEAVY MAINTENANCE, CORROSION FLOOR STRUCTURE LH WEB BTW FR69 & FR 70 AT AFT GALLEY AREA (CPCP RELATED REFER TO MPD TASK 534195-01); R & R FLOOR STRUCTURE LH WEB BTW FR 69 AND FR 70 AT AFT GALLEY AREA IAW SRM A320 51-72-11 AND DWG D534-74180. REF AEROMANSDR SWAA2021110322019Intercostal · crackedAFT OF FWD CARGO INTERCOSTAL CRACKED BS 520 S-25R. 8-90 ; / [01] REMOVED INTERCOSTAL AT AFT OF FWD CARGO ;STA 520 STGR - 25R AS PER B737-700 SRM 51-40-02-0G-0; [02] FABRICATED INTERCOSTAL FOR AFT OF FWD. CARGO BS. 520 S-25R IAW. DWG#143A9803-58; HEAT TREATED FSDR SWAA2021110121869None · crackedCRACKED WEB, BS 294.5 - 303.9, S16L. REMOVED WEB IAW SRM 51-40-02. REPLACED THE WEB IAW DWG 181A8180, REV C, AND SRM 51-40-02.SDR SWAA2021110121876None · crackedCRACKED SUPPORT, BS 400, S26L, REMOVED THE SUPPORT IAW SRM 51-40-02. REPLACED THE SUPPORT IAW SRM 51-40-02 AND DWG 143A7505, SHEET 2, REV B.SDR SWAA2021110121890Gusset · crackedCRACK GUSSET LOCATED BS500D AND STR19R FWD CARGO COMPARTMENT. REMOVED GUSSET IAW SRM 51-40-02 AND PERFORMED VISUAL INSPECTION AND NO FOUND MORE DAMAGE. DRILLED NEW GUSSET IAW SRM 51-40-05. APPLIED PROTECTIVE TREATMENT ON NEW GUSSET HOLES IAW SRM 51-20-0SDR SWAA2021110121875None · crackedCRACK ANGLE - SUPPORT LOCATED BS500B AT LEVEL STR26L AT FWD CARGO COMPARTMENT ; 2021-431869 / [11] REPLACED ANGLE-SUPPORT AND FASTENERS LOC. BS500B AT LEVEL STR26L AT FWD CARGO COMPARTMENT IAW B737-700 SRM 51-40-02; SRM 51-10-02 AND DWG#143A7505 SHEET 5 REV BSDR SWAA2021110121871Plate · elongatedELONGATED HOLE ON PLATE, BS 540, LBL 22.5 . REPLACED THE PLATE IAW SRM 51-10-02-0G-0, STEP 9.SDR AALA202111011336Shear Plate · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23R. REPLACED SHEAR PLATE PER SRM 51-72-11.SDR SWAA2021101821865None · corrodedAFT CARGO LH TRANSITION ANGLE HAS CORROSION AT STA 727B TO 727D ; / [01] REMOVED CORROSION PER SRM 51-10-02. FOUND TO BE OUT OF LIMITS PER SRM 53-00-53-1A-1; [02] REPAIRED PER SRM 53-00-53-2R-5. TRANSITION ANGLE TO BE INSTALLED ON 5360-E-16462-NG; [03] REMOVEDSDR AALA202110077644Plate · corrodedAIRCRAFT WAS GROUNDED: CORROSION ON LAVATORY SERVICE PANEL CUT OUT REINFORCEMENT PLATE AT FR 65 AND S39R. REPLACED REINFORCEMENT PLATE PER SRM 51-72-11 AND EA 330800.SDR R61A2021100600786Floor Support · corrodedDURING HEAVY CHECK MAINTENANCE FOUND CORROSION ON REAR FUSELAGE FLOOR SUPPORT STRUCTURE GUSSET PLATE AT FR90, RH SIDE. CORROSION ON REAR FUSELAGE FLOOR SUPPORT STRUCTURE GUSSET PLATE AT FR90, RH SIDE REPLACED WITH NEW AND INSTALLED IAW EMB SRM 51-41-02.SDR AALA202110018141Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FLOOR BOARD SUPPORT LOCATED AT STA 540 AND LBL 20. BETWEEN SEAT TRACK 3 AND 4. REPLACED SUPPORT PER SRM 51-10-02.SDR AALA202110014413Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FLOOR BOARD SUPPORT LOCATED AT STA 540 AND RBL 0 TO SEAT TRACK 3. REPLACED SUPPORT PER SRM 51-10-02.SDR SWAA2021102521465Floor Panel · missingSUPPLEMENTAL INFORMATION: MISSING MATERIAL FLOOR PANEL 242CF AT PASSENGER CABIN ; 2021-430136 / [20] REPAIRED FLOOR PANEL 242CF AT PASSENGER CABIN AS PER B737-700 SRM 53-00-50-2R-1 REPAIR 1; [21] REPAIRED FLOOR PANEL 242CF AT PASSENGER CABIN AS PER B737-700 SRSDR SWAA2021102521457Floor Panel · missingSUPPLEMENTAL INFORMATION: MISSING MATERIAL FLOOR PANEL 232BF AT PASSENGER CABIN ; 2021-430103 / [19] REPAIRED FLOOR PANEL 232BF AT PASSENGER CABIN AS PER B737-700 SRM 53-00-50-2R-1 REPAIR 1; [20] JOB TASK COMPLETED. RII INSPECTION COMPLETED.SDR SWAA2021102521454Floor Panel · delaminatedSUPPLEMENTAL INFORMATION: DELAMINATED FLOOR PANEL 221DF AT PASSENGER CABIN ; 2021-430101 / [21] REPAIRED FLOOR PANEL 221DF AT PASSENGER CABIN AS PER B737-700 SRM 53-00-50-2R-1 REPAIR 1.; [22] REPAIRED FLOOR PANEL 221DF AT PASSENGER CABIN AS PER B737-700 SRM 53SDR SWAA2021102521449Floor Panel · missingSUPPLEMENTAL INFORMATION: MISSING MATERIAL FLOOR PANEL 231CF AT PASSENGER CABIN ; 2021-430107 / [20] REPAIRED FLOOR PANEL 231CF AT PASSENGER CABIN AS PER B737-700 SRM 53-00-50-2R-1 REPAIR 1.; [21] JOB TASK COMPLETED. RII INSPECTION COMPLETED.SDR SWAA2021102521443Floor Panel · missingSUPPLEMENTAL INFORMATION: MISSING MATERIAL FLOOR PANEL 241CF AT PASSENGER CABIN ; 2021-430066 / [19] REPAIRED FLOOR PANEL 241CF AT PASSENGER CABIN AS PER B737-700 SRM 53-00-50-2R-1 REPAIR 1.; [20] JOB TASK COMPLETE. RII INSPECTION COMPLETED.SDR SWAA2021102521439Floor Panel · missingSUPPLEMENTAL INFORMATION: MISSING MATERIAL FLOOR PANEL 242AF AT PASSENGER CABIN ; 2021-430060 / [21] REPAIRED FLOOR PANEL 242AF AT PASSENGER CABIN AS PER B737-700 SRM 53-00-50-2R-1 REPAIR 1. RIISDR SWAA2021102521433Floor Panel · missingSUPPLEMENTAL INFORMATION: MISSING MATERIAL FLOOR PANEL 231XF AT PASSENGER CABIN ; 2021-430054 / [19] REPAIRED FLOOR PANEL 231XF AT PASSENGER CABIN AS PER B737-700 SRM 53-00-50-2R-1 REPAIR 1.; [20] REPAIRED FLOOR PANEL 231XF AT PASSENGER CABIN AS PER B737-700 SSDR AALA202111029126Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN AFT GALLEY AREA SHEAR PLATE LOCATED FROM FR69 TO FR70 AT LEVEL S23L. REPLACED SHEAR PLATE PER SRM 51-42-11-801 AND DWG D53474180.SDR SWAA2021110121371None · crackedCRACK WEB - INTERCOSTAL LOCATED BETWEEN BS500D TO BS520 AT LEVEL STR28L FWD CARGO COMPARTMENT ; 2021-431837 / [19] INSTALLED REPAIR WEB - INTERCOSTAL LOCATED BETWEEN BS500D TO BS520 AT LEVEL STR28L FWD CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 AND DWG # 143ASDR SWAA2021110121372None · crackedCRACK WEB - INTERCOSTAL LOCATED BETWEEN BS500D TO BS520 AT LEVEL STR28R FWD CARGO COMPARTMENT ; 2021-431838 / [18] INSTALLED REPAIR WEB - INTERCOSTAL LOCATED BETWEEN BS500D TO BS520 AT LEVEL STR28R FWD CARGO COMPARTMENT. IAW B737-700 SRM 51-40-02 AND DWG # 143SDR SWAA2021102520358Floor Panel · missingMISSING MATERIAL FLOOR PANEL 221AF AT PASSENGER CABIN ; 2021-430041 / [18] REPAIRED FLOOR PANEL 221AF AT PASSENGER CABIN AS PER B737-700 SRM 53-00-50-2R-1 REPAIR 1.; [19] VERIFIED STEP 18. AS RII COMPLETED <BR>REPAIRED FLOOR PANEL 221AF AT PASSENGER CABIN AS PSDR SWAA2021102520364Floor Panel · missingCRACK FLOOR PANEL 221CF AT PASSENGER CABIN ; 2021-430044 / [19] REPAIRED FLOOR PANEL 221CF AT PASSENGER CABIN AS PER B737-700 SRM 53-00-50-2R-1 REPAIR 1. RIISDR SWAA2021102520366Floor Panel · missingMISSING MATERIAL FLOOR PANEL 221CF AT PASSENGER CABIN ; 2021-430045 / [18] REPAIRED FLOOR PANEL 221CF AT PASSENGER CABIN AS PER B737-700 SRM 53-00-50-2R-1 REPAIR 1.; [19] REPAIRED FLOOR PANEL 221CF AT PASSENGER CABIN AS PER B737-700 SRM 53-00-50-2R-1 REPAIR 1.SDR SWAA2021101321160None · pulledFWD WET AREA FLOOR BOARD 221CF; UPPER SURFACE; AREAS OF COMPOSITE FACE SHEET PLIES PULLING; MRK'D. / REPLACED FLOOR BOARD 221CF BY FABRICATING NEW PANEL IAW DWG 141A5810-9 REV. B AND SRM 53-00-50-2R-0 REV . 73SDR SWAA2021101320268None · pulledFWD WET AREA FLOOR BOARD 222DF; UPPER SURFACE; AREAS OF COMPOSITE FACE SHEET PLIES PULLING; MRK'D. / REPAIRED FWD WET AREA FLOOR BOARD 222DF UPPER SURFACE IAW B737 SRM 53-00-50-2R-1SDR SWAA2021101320267None · pulledFWD WET AREA FLOOR BOARD 222CF; UPPER SURFACE; AREAS OF COMPOSITE FACE SHEET PLIES PULLING; MRK'D. / REPAIRED AREA'S OF PULLED FIBERS ON UPPER SURFACE OF PANEL 222CF IAW B737-800 SRM 53-00-50-2R-1; SRM 53-00-50-2R-0SDR SWAA2021101320266None · pulledFWD WET AREA FLOOR BOARD 221FF; UPPER SURFACE; AREAS OF COMPOSITE FACE SHEET PLIES PULLING; MRK'D. / REPAIRED UPPER SURFACE OF FLOOR PANEL 221FF IAW B737-800 SRM 53-00-50-2R-1 REPAIR 1 A57959 A13436SDR SWAA2021101320265None · pulledFWD WET AREA FLOOR BOARD 221GF; UPPER SURFACE; AREAS OF COMPOSITE FACE SHEET PLIES PULLING; MRK'D. / REPAIRED DAMAGE TO UPPER SURFACE FLOORBOARD 221GF IAW SRM 53-00-50-2R-0 REPAIR GENERAL; SRM 53-00-50-2R-1 REPAIR 1 TAP TEST GOODSDR SWAA2021101320264None · pulledFWD WET AREA FLOOR BOARD 221DF; UPPER SURFACE; AREAS OF COMPOSITE FACE SHEET PLIES PULLING; MRK'D. / REPAIRED UPPER SURFACE FACESHEET PULLED FIBERS WITH WET-LAY-UP REPAIR I/A/W; B737-800 SRM 53-00-50-2R-1 (3) A-M (REV 73)SDR SWAA2021101320261None · pulledFWD WET AREA FLOOR BOARD 221CF; UPPER SURFACE; AREAS OF COMPOSITE FACE SHEET PLIES PULLING; MRK'D. / REPLACED FLOOR BOARD 221CF BY FABRICATING NEW PANEL IAW DWG 141A5810-9 REV. B AND SRM 53-00-50-2R-0 REV . 73SDR SWAA2021101320260None · pulledFWD WET AREA FLOOR BOARD 222BF; UPPER SURFACE; AREAS OF COMPOSITE FACE SHEET PLIES PULLING; MRK'D. / REPAIRED FWD WET AREA FLOORBOARD 222BF UPPER SURFACE WITH MISSING PLIES AS MARKED IAW SRM 53-00-50-2R-1 AND SRM 53-00-50-2R-0 REPAIR GENERALSDR SWAA2021101320259None · pulledFWD WET AREA FLOOR BOARD 222AF; UPPER SURFACE; AREAS OF COMPOSITE FACE SHEET PLIES PULLING; MRK'D. / REPAIRED FWD WET AREA FLOORBOARD 222AF UPPER SURFACE IAW SRM 53-00-50-2R-1 AND SRM 53-00-50-2R-0 REPAIR GENERALSDR SWAA2021101320257None · pulledFWD WET AREA FLOOR BOARD 221AF; UPPER SURFACE; AREAS OF COMPOSITE FACE SHEET PLIES PULLING; MRK'D. / REPLACED FLOORBOARD 221AF BY FABROCATING NEW PANEL IAW DWG 141A5810-728 REV. B AND SRM 53-00-50-2R-0 REV. 73SDR SWAA2021101321156None · pulledFWD WET AREA FLOOR BOARD 221AF; UPPER SURFACE; AREAS OF COMPOSITE FACE SHEET PLIES PULLING; MRK'D. / REPLACED FLOORBOARD 221AF BY FABROCATING NEW PANEL IAW DWG 141A5810-728 REV. B AND SRM 53-00-50-2R-0 REV. 73SDR SWAA2021101321642Support · corrodedCORROSION ON FORWARD CARGO BAY AFT BULKHEAD RIGHT HAND PANEL LOWER SUPPORT AT B.S. 500D; R.B.L. 24; W.L. 154. ; / [01] REMOVED CORROSION ON AFT BULKHEAD LOWER SUPPORT AT BS500D; RBL24; WL154; REWORKED AREA: L=1.5'; W=1'; D=0.010; WAS FOUND WITHIN LIMIT; REMAINSDR SWAA2021101220256None · pulledFWD WET AREA FLOOR BOARD 221BF; UPPER SURFACE; COMPOSITE FACE SHEET PLIES PULLING; MRK'D. / REPAIRED FWD WET AREA FLOORBOARD 221BF UPPER SURFACE MISSING PLIES AS MARKED IAW SRM 53-00-50-2R-1 AND SRM 53-00-50-2R-0 REPAIR GENERALSDR SWAA2021101221159None · pulledFWD WET AREA FLOOR BOARD 222BF; UPPER SURFACE; AREAS OF COMPOSITE FACE SHEET PLIES PULLING; MRK'D. / REPAIRED FWD WET AREA FLOORBOARD 222BF UPPER SURFACE WITH MISSING PLIES AS MARKED IAW SRM 53-00-50-2R-1 AND SRM 53-00-50-2R-0 REPAIR GENERALSDR SWAA2021101221164None · pulledFWD WET AREA FLOOR BOARD 221GF; UPPER SURFACE; AREAS OF COMPOSITE FACE SHEET PLIES PULLING; MRK'D. / REPAIRED DAMAGE TO UPPER SURFACE FLOORBOARD 221GF IAW SRM 53-00-50-2R-0 REPAIR GENERAL; SRM 53-00-50-2R-1 REPAIR 1 TAP TEST GOODSDR SWAA2021101221167None · pulledFWD WET AREA FLOOR BOARD 222DF; UPPER SURFACE; AREAS OF COMPOSITE FACE SHEET PLIES PULLING; MRK'D. / REPAIRED FWD WET AREA FLOOR BOARD 222DF UPPER SURFACE IAW B737 SRM 53-00-50-2R-1SDR SWAA2021101221158None · pulledFWD WET AREA FLOOR BOARD 222AF; UPPER SURFACE; AREAS OF COMPOSITE FACE SHEET PLIES PULLING; MRK'D. / REPAIRED FWD WET AREA FLOORBOARD 222AF UPPER SURFACE IAW SRM 53-00-50-2R-1 AND SRM 53-00-50-2R-0 REPAIR GENERALSDR SWAA2021101221163None · pulledFWD WET AREA FLOOR BOARD 221DF; UPPER SURFACE; AREAS OF COMPOSITE FACE SHEET PLIES PULLING; MRK'D. / REPAIRED UPPER SURFACE FACESHEET PULLED FIBERS WITH WET-LAY-UP REPAIR I/A/W; B737-800 SRM 53-00-50-2R-1 (3) A-M (REV 73)SDR SWAA2021101221166None · pulledFWD WET AREA FLOOR BOARD 222CF; UPPER SURFACE; AREAS OF COMPOSITE FACE SHEET PLIES PULLING; MRK'D. / REPAIRED AREA'S OF PULLED FIBERS ON UPPER SURFACE OF PANEL 222CF IAW B737-800 SRM 53-00-50-2R-1; SRM 53-00-50-2R-0SDR SWAA2021101221155None · pulledFWD WET AREA FLOOR BOARD 221BF; UPPER SURFACE; COMPOSITE FACE SHEET PLIES PULLING; MRK'D. / REPAIRED FWD WET AREA FLOORBOARD 221BF UPPER SURFACE MISSING PLIES AS MARKED IAW SRM 53-00-50-2R-1 AND SRM 53-00-50-2R-0 REPAIR GENERALSDR SWAA2021101220724Support Splice · corrodedCORROSION ON FLOOR SUPPORT SPLICE IN THE AFT CARGO BAY, BS 767, LBL 10 - RBL 10. CORROSION FOUND TO BE OUT OF LIMITS IAW SRM 51-10-02. LOCATED AND DRILLED THE NEW SPLICE IAW SRM 51-40-05-OG-0, & DWG 146A9401. REMOVED AND INSTALLED THE NEW SPLICE ON CARD
Back to JASC 5320