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 SWAA2022101078770None · corrodedFWD CARGO; RH TRANS. ANGLE HAS CORROSION;STA.500-492.4 / [01] REMOVED CORROSION PER SRM 51-10-02. REMOVED .006 INCH OF MATERIAL AT STATION 500 + 6. REMAINING THICKNESS IS .032 INCH AND IS OUT OF LIMITS PER SRM 53-00-53-1A-2. PART REQUIRES REPLACEMENT.;[02] LOCSDR SWAA2022101078768None · corrodedFWD CARGO; RH TRANS. ANGLE HAS CORROSION;500F-500E / [01] REMOVED CORROSION PER SRM 51-10-02. REMOVED .012 INCH OF MATERIAL. REMAINING THICKNESS IS .028 INCH AND IS OUT OF LIMITS PER SRM 53-00-53-1A-2. TRANSITION ANGLE ASSEMBLY TO BE REPLACED ON NON-ROUTINE TTSDR SWAA2022101078772None · corrodedLH TRANS. ANGLE; HAS CORROSION STA.500H-500G / [01] TRANSITION ANGLE ASSEMBLY TO BE REPLACED ON NON-ROUTINE TTG8Q00EV0RQ DUE TO OUT OF LIMITS DAMAGE AT OTHER LOCATIONS ALONG LENGTH OF SIDEPLATE.SDR SWAA2022101078773None · corrodedLH TRANS. ANGLE; HAS CORROSION STA.500G-500F / [01] TRANSITION ANGLE ASSEMBLY TO BE REPLACED ON NON-ROUTINE TTG8Q00EV0RQ DUE TO OUT OF LIMITS DAMAGE AT OTHER LOCATIONS ALONG LENGTH OF SIDEPLATE.;[02] TRANSITION ANGLE ASSEMBLY TO BE REPLACED ON NON-ROUTINE TTG8SDR SWAA2022101871698Floor Support · crackedCRACK WEB LOCATED BETWEEN BS312 TO BS328 LBL46 AND WL208 AT FWD GALLEY AREA 2022-518183 / [01] REPLACED WEB - INTERCOSTAL LOCATED BETWEEN BS312 TO BS328 LBL46 AND WL208 AT FWD GALLEY AREA IAW B737-700 SRM 51-10-02 ITEM 9 AND DWG 141A5400; SHEET 26; REV -. <BR>SDR SWAA2022101871702Floor Support · crackedCRACK FLOOR STRUCTURE INNER CHORD LOCATED BS294 PLUS 10INCH LBL54 AND WL208 AT FWD GALLEY AREA 2022-518202 / [01] INSPECTION REJECTED IN STEP 7<BR>SEE NON ROUTINE CARD TTG8Q00F55PE;[02] REPLACED INNER CHORD AND FASTENER LOCATED ON FLOOR STRUCTURE BS277 TO BS 3SDR SWAA2022101871703Floor Support · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN BS344 TO BS360 LBL12 AND WL208 AT FWD GALLEY AREA 2022-518209 / [01] REPLACED WEB - INTERCOSTAL ON FLOOR STRUCTURE LOCATED BETWEEN BS344 TO BS360 LBL12 AND WL208 AT FWD GALLEY AREA IAW B737-700 SRM 51-10-SDR SWAA2022101871701Floor Support · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN BS344 TO BS360 BL0 WL208 AT FWD GALLEY AREA 2022-518210 / [01] REPLACED WEB - INTERCOSTAL ON FLOOR STRUCTURE LOCATED BETWEEN BS344 TO BS360 BL0 WL208 AT FWD GALLEY AREA IAW B737-700 SRM 51-10-02 ITEM 9 ANSDR SWAA2022101871693Floor Support · corrodedCORROSION FLOOR STRUCTURE INNER CHORD LOCATED BS967 TO BS986 RBL48 AND WL208 AT AFT GALLEY AREA 2022-518164 / [01] REPLACED INNER CHORD LOCATED BS 907 TO BS 1006 RBL 48 AND WL208 AT AFT GALLEY AREA. IAW B737-700 SRM 51-40-02 AND DWG # 147A8501; SHEET 93 REV ?ASDR AALA202210053045Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED BETWEEN BS 500A AND BS 500I AT S26L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202210044019Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 500A TO BS 500I, RBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202209308383Plate · corrodedAIRCRAFT IN BASE MAINTENANCE: MULTIPLE AREAS OF CORROSION AROUND FASTENER HOLES AND UPPER SURFACE OF FORWARD CARGO COMPARTMENT FLOOR STRUCTURE RIGHT SIDE PLATE BETWEEN BODY STATION 500 A AND BODY STATION 500 I RIGHT BUTT LINE 24. FABRICATED NEW PART PER SRM 53SDR AALA202209303461Plate · corrodedAIRCRAFT IN BASE MAINTENANCE: MULTIPLE AREAS OF CORROSION AROUND FASTENER HOLES AND UPPER SURFACE IN THE FORWARD CARGO COMPARTMENT FLOOR STRUCTURE LIGHT SIDE PLATE BETWEEN BODY STATION 455 AND BODY STATION 500I AND LEFT BUTT LINE 24. REMOVED AND REPLACED SIDESDR AALA202209300130Panel · corrodedCORROSION AROUND FASTENER HOLE IN THE FORWARD CARGO COMPARTMENT RIGHT SIDEWALL PANEL SUPPORT LOWER END BODY STATION 500I APROXIMATLY RIGHT BUTT LINE 25.5. FABRICATED PANEL SUPPORT PER SRM 51-70-11-2R.SDR REXA2022092702151Splice · corrodedSTR 25R SPLICE AT FS 333 HAS MULTIPLE SPOTS OF CORROSION WITH UP TO 100% MATERIAL LOSS REPLACED STRINGER SPLICESDR AALA202209268848Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOOR SUPPORT LOCATED AT BS 540 BETWEEN RBL 0 AND RBL 25. REPLACED FLOOR SUPPORT PER AARD 51-00-05-1.SDR REXA2022092102115Seat Track · corrodedCORROSION FOUND ON LBL 27 SEAT TRACK BETWEEN FS 364-485. REMOVED AND REPLACED SEAT TRACK AT LBL 27 BETWEEN F.S.364 TO F.S.485SDR REXA2022092102114Seat Track · corrodedCORROSION FOUND ON LBL 9 SEAT TRACK BETWEEN FS 379-485. REMOVED AND REPLACED SEAT TRACK AT LBL 9 BETWEEN F.S.379 TO F.S.485SDR SWIA202266890Intercostal · corrodedINTERCOSTAL DD4 LOCATED BETWEEN FS338.963 AND FS347.25 IS CORRODED (C-CHECK RO 11/12/2022) INTERCOSTAL DD4 LOCATED BETWEEN FS338.963 AND FS347.25 FOUND TO BE OUT OF LIMITS OF CRJ200 SRM 52-00-00, REMOVED AND REPLACED IAW CRJ200 SRM 51-42-06. AND DWG 601SDR SWIA202266889Intercostal · corrodedINTERCOSTAL DD3 LOCATED BETWEEN FS338.963 AND FS347.25 IS CORRODED (C-CHECK RO 11/12/2022) INTERCOSTAL DD3 LOCATED BETWEEN FS338.963 AND FS347.25 FOUND TO BE OUT OF LIMITS OF CRJ200 SRM 52-00-00, REMOVED AND REPLACED IAW CRJ200 SRM 51-42-06. AND DWG 601SDR REXA2022103102323Stiffener · crackedAFT CARGO DOOR SURROUND UPPER FRAME STIFFENER ON AFT FRAME HAS 2.0" CRACK. REPLACED STIFFENERSDR REXA2022103102322Floor Support · corrodedRH FLOOR SILL AT FS 319.70 HAS MULTIPLE AREAS OF CORROSION WITH A MAX DEPTH OF .030". REMOVED AND REPLACED FLOOR SILLSDR SWAA2022101871658Panel · crackedCRACK ON THRESHOLD PANEL LOC ON FWD CARGO DOOR CUT OUT LOWER POSITION 2022-518097 / [01] REPLACED THRESHOLD PANEL LOC ON FWD CARGO DOOR CUT OUT LOWER POSITION IAW B737-700 AMM 53-11-02-401-NG;[02] REPLACED THRESHOLD PANEL LOC ON FWD CARGO DOOR CUT OUT LOWER POSDR SWAA2022100671980Support Angle · corrodedCORROSION ON FSD MOPSILL SUPPORT ANGLEBS294+10-BS 312+7 RBL 55 WL 209 / [01] VERIFIED SRM 53-10-15-1A-2 IS APPLICABLE. REMOVED CORROSION ON FSD MOPSILL SUPPORT ANGLE BS294+10-BS 312+7 RBL 55 WL 209 PER SRM 51-10-02. ORIGINAL THICKNESS IS .090'. MAXIMUM MATERIASDR AALA202210059348Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED BETWEEN BS 787 AND BS 807 AT LBL 25. REPLACED TRANSITION PANEL PER SRM 51-40-02.SDR AALA202210056183Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED BETWEEN BS 747 AND BS 767 AT RBL 24. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5 AND SRM 51-40-02.SDR AALA202210048880Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND SHIELD LOCATED FROM BS 767 TO BS 787, RBL 25. REPLACED SHIELD PER AARD 51-00-05-1 AND DWG 146A0081.SDR AALA202210040261Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT DOOR SILL PLATE WEB LOCATED FROM BS 440 TO BS 492.4, S25R. REPLACED WEB PER AARD 51-00-05-1 AND SRM 51-40-02.SDR REXA2022092702150Cleat · corrodedSTR 22R CLEAT AT FS310.00 HAS AREA OF CORROSION WITH 100% MATERIAL LOSS REPLACED STR 22R CLEATSDR REXA2022092702149Stringer · corrodedSTR 25R HAS MULTIPLE SPOTS OF CORROSION BETWEEN FS319-333 WITH UP TO 100% MATERIAL LOSS. REPLACED STRINGERSDR IPXA2022091486261Web · crackedINSPECTION TYPE:CFWD CARGO COMPARTMENT UNDER FLOOR WEB AT FR 21 AT Y2464 HAS A CRACKREMOVED AND REPLACED FLOOR WEB FR 21 AT Y2464 IAW-SRM 51-40-21SDR REXA2022111002425Seat Track · corrodedLH SIDE SEAT TRACK HAS MULTIPLE SPOTS OF CORROSION BETWEEN FS 785.15-847+32 WITH A MAX DEPTH OF .055" REMOVED AND REPLACED SEAT TRACKSDR REXA2022111002424Seat Track · corrodedRH FLOOR SEAT TRACK HAS MULTIPLE SPOTS OF CORROSION BETWEEN FS847+62-975 WITH A MAX DEPTH OF .010" AROUND FASTENER HOLES REMOVED AND REPLACED SEAT TRACKSDR REXA2022111002423Seat Track · corrodedLH FLOOR SEAT TRACK HAS MULTIPLE SPOTS OF CORROSION BETWEEN FS847+62-988 WITH A MAX DEPTH OF .010" DEEP AROUND FASTENER HOLES REMOVED AND REPLACED SEAT TRACKSDR REXA2022111002422Seat Track · corrodedRH FLOOR SEAT TRACK HAS MULTIPLE SPOTS OF CORROSION BETWEEN FS830-847+62 WITH A MAX DEPTH OF .010" AROUND FASTENER HOLES REMOVED AND REPLACED SEAT TRACKSDR REXA2022111002421Seat Track · corrodedLH FLOOR SEAT TRACK HAS MULTIPLE SPOTS OF CORROSION BETWEEN FS830-847 WITH A MAX DEPTH OF .075" REMOVED AND REPLACED SEAT TRACKSDR REXA2022111002420Seat Track · corrodedRH FLOOR SEAT TRACK HAS MULTIPLE SPOTS OF CORROSION BETWEEN FS693-830 WITH A MAX DEPTH OF .010" AROUND FASTENER HOLES REMOVED AND REPLACED SEAT TRACKSDR REXA2022111002419Seat Track · corrodedLH FLOOR SEAT TRACK HAS MULTIPLE SPOTS OF CORROSION BETWEEN FS693-830 WITH A MAX DEPTH OF .075" REMOVED AND REPLACED SEAT TRACKSDR REXA2022111002418Seat Track · corrodedLH FLOOR SEAT TRACK HAS MULTIPLE SPOTS OF CORROSION BETWEEN FS661+32-693 WITH A MAX DEPTH OF .075" REMOVED AND REPLACED SEAT TRACKSDR REXA2022110402416Seat Track · corrodedRH FLOOR SEAT TRACK HAS MULTIPLE SPOTS OF CORROSION BETWEEN FS661+32-693 WITH A MAX DEPTH OF .070" REMOVED AND REPLACED SEAT TRACKSDR REXA2022110402415Seat Track · corrodedRBL9 FLOOR SEAT TRACK HAS MULTIPLE SPOTS OF CORROSION BETWEEN FS581-661+32 WITH A MAX DEPTH OF .070" REMOVED AND REPLACED SEAT TRACKSDR REXA2022110402414Seat Track · corrodedLBL9 FLOOR SEAT TRACK HAS MULTIPLE SPOTS OF CORROSION BETWEEN FS581-661+32 WITH A MAX DEPTH OF .075" REMOVED AND REPLACED SEAT TRACKSDR SWAA2022100552547None · corrodedFORWARD CARGO BAY SUBTHRESHOLD WEB HAS CORROSION BS 440+15 RBL 28 WL 156 / [01] EVALUATED CORROSION ON SUBTHRESHOLD WEB; AT BS 440+15 RBL 28 WL 156; FOUND 0.015 REMOVED FROM ORIG 0.045 IN 1'X1' AREA; FOUND TO BE OUT OF LIMITS PER SRM 53-30-15-1A-1 USING DIAL DSDR SWAA2022100552820Angle · damagedCORROSION ON L/H FWD EMERGENCY EXIT DOOR LOWER HINGE SUPPORT ANGLE AT LBL 67 WL 221 BS 580+9; BS 580+15. / [01] REMOVED L/H FWD EMERGENCY EXIT DOOR LOWER CLOSEOUT LINING ASSEMBLY AT BS 578 TO BS 601 LBL 67 WL 221 IAW AMM 25-21-20-000-801 STEP 6 (A) AND (B) REMSDR SWAA2022100552821Angle · corrodedCORROSION ON R/H FWD EMERGENCY EXIT DOOR LOWER HINGE SUPPORT ANGLE AT RBL 67 WL 221 BS 580+9; BS 580+15. / [01] REMOVED R/H FWD EMERGENCY EXIT DOOR LOWER CLOSEOUT LINING ASSEMBLY AT BS 578 TO BS 601 RBL 67 WL 221 IAW AMM 25-21-20-000-801 STEP 6 (A) AND (B) REMSDR SWAA2022100572267Floor Support · crackedFWD CABIN FLOOR SUPPORT BETWEEN STA 380 AND STA 400 RBL 9 INTERCOASTAL FRAME CRACK WL 208.1. / [01] REMOVED INTERCOSTAL AT FWD CABIN FLOOR SUPPORT;BET.STA 380 TO SAT 400;RBL 9.WL 208.1 PER B 737-700 SRM 51-40-02-0G-0.;[02] VERIFIED STEP 1.;[03] OK TO INSTALL NSDR REXA2022100302174None · corrodedFWD GALLEY SERVICE DOOR SILL SEAL STRIKER HAS AREAS OF CORROSION WITH 100% MATERIAL LOSS. REPLACED SEAL STRIKERSDR REXA2022100302173None · corrodedAFT CARGO DOOR SILL HAS MULTIPLE AREAS OF CORROSION WITH 100% MATERIAL LOSS. REPLACED AFT CARGO DOOR SILLSDR V0XR20220930001Floor Support · corrodedCORROSION FOUND ON FLOOR SUPPORT BEAM BL0 BETWEEN FR 57 AND FR 61.SDR SWAA2022092765277Intercostal · crackedINTERCOSTAL AT BL 0; IS CRACKED BS 345 WL 208 / [01] HIDDEN DAMAGE INSPECTION ACCOMPLISHED. NO ADDITIONAL DAMAGE NOTED.;[02] HIDDEN DAMAGE RE-INSPECT REQUIRED UPON REMOVAL OF INTERCOSTAL.;[03] ADDITIONAL DAMAGE FOUND TO T-CHORD AND STRAP UPON REMOVAL OF INTERC
Back to JASC 5320