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 SWAA2022101749301Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT HAS CORROSION AT STA 747 +5;+6;+10;+14 TO 767; LBL 23 TO 25; WL 157. / [01] SRM 53-00-53-1A-2 IS APPLICABLE FOR THIS;[02] BLENDED AREA ON AFT CARGO BAY FLOOR TO SIDEWALL SUPPORT AT BS 747; WORK AREA BS 747+2; L 0.9' X W SDR SWAA2022101749309Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT HAS CORROSION AT STA 767 +6;+10.5;+19 TO 787; LBL 23 TO 25; WL 157. / [01] SRM 53-00-53-1A-2 IS APPLICABLE FOR THIS;[02] BLENDED AREA ON AFT CARGO BAY FLOOR TO SIDEWALL SUPPORT AT BS 767; WORK AREA BS 767; L 0.8' X W 0.9SDR SWAA2022101749302Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT HAS CORROSION AT STA 787 +2;+6.5;+8.5 TO 907; LBL 23 TO 25; WL 157. / [01] CLARIFICATION OF DAMAGE STATEMENT. AFT CARGO BAY FLOOR TO SIDEWALL SUPPORT HAS CORROSION AT STA 787 +2;+6.5;+8.5 TO 807; LBL 23 TO 25; WL 157;[02SDR SWAA2022101746845Shield · corrodedFWD CARGO DOOR CUTOUT FWD SHIELD IS CORRODED FROM STA 420 TO STA440; RBL 23 TO 25; WL 157. / [01] NOT ALLOWABLE DAMAGE PER SRM AND REPAIR BY REPLACEMENT;[02] VERIFIED CORRECTIVE ACTION #1;[03] CAL TOOL ID ATS2711 S/N G01589 EXP: 02/2023;[04] PROCURED NEW SHIELSDR SWAA2022101746842Shield · corrodedFWD CARGO DOOR CUTOUT AFT SHIELD IS CORRODED FROM STA 480+14 TO 500A; RBL 23 TO 25; WL 157. / [01] NOT ALLOWABLE DAMAGE PER SRM AND REPAIR BY REPLACEMENT;[02] VERIFIED CORRECTIVE ACTION #1;[03] PROCURED NEW SHIELD; LOCATED AND DRILLED PER SRM 51-40-05-0G-0; SRSDR SWAA2022101746846Support · corrodedCORROSION ON FWD CARGO BAY FLOOR TO SIDEWALL SUPPORT FROM STA 400+16 TO STA 420; RBL 24; WL 157. / [01] REMOVED CORROSION ON FWD CARGO BAY FLOOR TO SIDEWALL SUPPORT FROM BS 400+16 ; L 3.5' X W 1.0' X D 0.007 FOUND TO BE OUT OF LIMITS IAW SRM 53-00-53-1A-2 ; USSDR SWAA2022101746843Support · corrodedCORROSION ON FWD CARGO BAY FLOOR TO SIDEWALL SUPPORT FROM STA 500A TO STA 500C+10; RBL 23 TO 25; WL 157. / [01] BLENDED CORROSION ON FWD CARGO BAY FLOOR TO SIDEWALL SUPPORT ; WORK AREA BS 500A+2 ; L 1.0' X W 1.0' X D 0.010' ; BS 500A+6 ; L 1.0' X W 1.0' X D 0.SDR SWAA2022101746847Support · corrodedCORROSION ON FWD CARGO BAY FLOOR TO SIDEWALL SUPPORT FROM STA 480+6 TO STA 500C+15 LBL 23 TO 25; WL 157. / [01] SRM 53-00-53-1A-2 IS APPLICABLE FOR THIS;[02] SRM 53-00-53-1A-2 IS FOUND TO BE APPLICABLE FOR THIS EVAL. REMOVED CORROSION FROM MANY POINTS. THE DEESDR IPXA2022101587151Support Bracket · crackedINSPECTION TYPE:3CCAC COMPARTMENT R/H LRU RACK R/H LWR SUPPORT BRACKET IS CRACKED.REPLACED SUPPORT BRACKET IN THE CAC COMPARTMENT ON THE R/H LRU RACK IAW SRM 51-31-01 (MINOR)SDR AALA202210047948Fitting · crackedAIRCRAFT WAS GROUNDED: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540, RBL 15.04. REPLACED SHEAR FITTING PER EA 339148.SDR AALA202210047832Fitting · crackedAIRCRAFT WAS GROUNDED: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540, RBL 32.40. REPLACED SHEAR FITTING PER EA 339148.SDR AALA202210040217Fitting · crackedAIRCRAFT WAS GROUNDED: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540, RBL40.87. REPLACED SHEAR FITTING PER EA 339148.SDR AALA202210043556Fitting · crackedAIRCRAFT WAS GROUNDED: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540, RBL 54.60. REPLACED SHEAR FITTING PER EA 339148.SDR AALA202210040298Fitting · crackedAIRCRAFT WAS GROUNDED: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540, LBL 6.14. REPLACED SHEAR FITTING PER EA 339148.SDR AALA202210045937Fitting · crackedAIRCRAFT WAS GROUNDED: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540, LBL 15.04. REPLACED SHEAR FITTING PER EA 339148.SDR AALA202210044957Fitting · crackedAIRCRAFT WAS GROUNDED: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540, LBL 40.87. REPLACED SHEAR FITTING PER EA 339148.SDR AALA202210042883Plate · crackedAIRCRAFT WAS GROUNDED: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540, LBL 54.60. REPLACED SHEAR FITTING PER EA 339148.SDR REXA2022100302172Cleat · corrodedSTRINGER BRACKET AT STRINGER 21R AT F.S.319 IS CORRODED REMOVED AND REPLACED STRINGER BRACKET (CLEAT).SDR REXA2022100302171Frame · corrodedF.S.364 FRAME IS CORRODED ON LOWER ATTACHMENT FLANGE BETWEEN STRINGER 27 AND STRINGER 26R REPAIRED LOWER FRAME SECTION F.S.364SDR REXA2022100302167None · corrodedCORROSION FOUND ON CARGO FLOOR BEAM AT RBL27 BETWEEN FS605-FS621 REPAIRED SEAT RAIL 601R35031-263 AND FLOOR BEAM FITTING 601R35289-4SDR REXA2022100302160Stiffener · crackedLBL 27 FS 280 BULKHEAD STIFFENER CRACKED. REMOVED AND REPLACED STIFFENER IAW CRJ 900 SRMSSDR SWAA2022101846420Floor Support · corrodedCRACKED INTERCOSTAL BS 277-294 WL 208 RBL 1. / [01] REMOVED CRACKED INTERCOSTAL STA 277-294; RBL 1; WL 208 PER SRM 51-40-02-0G-0.;[02] LOCATED AND DRILLED AND DEBURRED NEW INTERCOSTAL STA 277-294; RBL 1; WL 208 PER SRM 51-40-02-0G-0; SRM 51-40-05-0G-0; DWG# 14SDR SWAA2022101846421Floor Support · crackedCRACKED INTERCOSTAL BS 312-328 WL 208 RBL 30. / [01] REMOVED DAMAGED INTERCOSTAL STA 312-328; RBL 30; WL 208 PER SRM 51-40-02-0G-0.;[02] LOCATED AND DRILLED AND DEBURRED NEW INTERCOSTAL STA 312-328; RBL 30; WL 208 PER SRM 51-40-02-0G-0; 51-40-05-0G-0; DWG# 141SDR SWAA2022101846422Floor Support · crackedCRACKED INTERCOSTAL BS 312-328 WL 208 LBL 46. / [01] REMOVED DAMAGED INTERCOSTAL STA 312-328; LBL 46; WL 208 PER SRM 51-40-02-0G-0.;[02] LOCATED AND DRILLED AND DEBURRED INTERCOSTAL STA 312-328; LBL 46; WL 208 PER SRM 51-40-02-0G-0; SRM 51-40-05-0G-0; DWG# 141SDR SWAA2022101846417Floor Support · crackedCRACKED INTERCOSTAL BS 380-*400 WL 208 LBL 6. / [01] REMOVED DAMAGED INTERCOSTAL STE 380-400; LBL 6; WL 208 PER SRM 51-40-02-0G-0.;[02] LOCATED AND DRILLED AND DEBURRED NEW INTERCOSTAL STE 380-400; LBL 6; WL 208 PER SRM 51-40-02-0G-0; SRM 51-40-05-0G-0; DWG# 1SDR SWAA2022101846416Floor Support · crackedCRACKED INTERCOSTAL BS 344-360 WL 208 LBL 1. / [01] CRACK DAMAGED INTERCOSTAL AT BS 344 TO BS 360 LBL 1 WL 208 CRACK LENGTH MEASURED AT .580' FOR AND AFT .662' FROM INBOARD EDGE USING MICROMETER PER2242 S/N UNKNOWN CAL DUE 01/2023 FOUND TO BE OUT OF LIMITS IAWSDR AALA202210198212Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: INTERCOSTAL CRACKED BETWEEN STA 312 AND 328 AND LEFT BUTT LINE 46. REMOVED AND REPLACED INTERCOSTAL PER BOEING DRAWING.SDR SWAA2022101746831Seat Track · corrodedCORROSION ON PASSENGER CABIN SEAT TRACK AT RBL 45 BS 540+14; BS 580; BS 600+13; BS 620+14; BS 640+18; BS 660+15-660+19; BS 680+9. / [01] SEAT TRACK FROM BS 540-727B RBL 45 TO BE REPLACED ON FAULT TTG8Q00F3486;[02] COMPLETE;[03] TSR ATTACHED FOR CLEARIFICATION;SDR SWAA2022101746816Seat Track · corrodedCORROSION ON PASSENGER CABIN SEAT TRACK AT RBL 45 BS 380+4-380+15; BS 400+11; BS 400+14; BS 420+3; BS 420+7; BS 440+15; BS 460+16. / [01] VERIFIED APPLICABILITY OF SRM 53-00-52-1A-1.<BR>EVALUATED ALL AREAS OF CORROSION ON SEAT TRACK AT RBL 45; FROM BS 370 TO 4SDR SWAA2022101746832Seat Track · corrodedCORROSION ON PASSENGER CABIN SEAT TRACK AT RBL 45 BS 700+5-700+9; BS 700+18; BS 727+13-727+16; BS 727A+6; BS 727A+13. / [01] UPDATED TABLE;[02] REMOVED CORROSION ON LOWER WELL OF SEAT TRACK IN A 4'X0.7'X.048' AREA AT BS 727+13- 727+16 RBL 45 WL 208.1 IAW SRM 5SDR AALA202210173518Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL LOCATED AT BS 352 AND LBL 1. REPLACED INTERCOSTAL PER AARD 51-00-05-1 AND DWG 141A5410.SDR AALA202210060325Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN INTERCOSTAL LOCATED BETWEEN BS 312 AND BS 328 AT LBL 42. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA202210068941Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT RIGHT HAND BAFFLE LOCATED BETWEEN BS 500E TO BS 500D AT RBL 30. REPLACED BAFFLE PER AARD 53-00-01 AND DWG 143A7505.SDR AALA202210066147Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT RIGHT HAND BAFFLE LOCATED BETWEEN BS 500A AND BS 500B AT RBL 36. REPLACED BAFFLE PER AARD 53-00-01 DWG 143A7505.SDR AALA202210041061Fitting · crackedAIRCRAFT WAS GROUNDED: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540, LBL 32.40. REPLACED SHEAR FITTING PER EA 339148.SDR AALA202210047299Fitting · crackedAIRCRAFT WAS GROUNDED: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540, RBL 6.14. REPLACED SHEAR FITTING PER EA 339148.SDR REXA2022093002158Cleat · corrodedFOUND CORROSION ON STRINGER CLEAT LOCATED AT F.S.349 AND STRINGER 21L REMOVED AND REPLACED STRINGER CLEAT AT F.S.349 STRINGER 21LSDR REXA2022093002157Stringer · corrodedSTRINGER 25L IS CORRODED BETWEEN F.S.295 AND F.S.310 REMOVED AND REPLACED STRINGER 25L BETWEEN F.S.295 AND F.S.310SDR REXA2022093002156Cleat · crackedRIGHT TRU BAY DOUBLER OVER TRU BAY FLOOR IS CRACKED AT F.S.193. REPAIRED BY FABRICATING AND INSTALLING NEW DOUBLER AND REPLACING ATTACHING CLEATSDR V0XD2022102800001Threshold · corrodedSIGNS OF CORROSION UNDER THE SERVICE DOOR THRESHOLD. CORRECTIVE ACTION: REMOVED AND REPLACED SERVICE DOOR THRESHOLD IAW EMB 145 SRM 51-40-02.SDR AALA202211257036Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23R. REPLACED SHEAR PLATE PER SRM 51-72-11.SDR SWIA202266901Intercostal · corrodedDURING REMOVAL OF INTERCOSTAL AT STR20R FS349-364 FOUND POTABLE WATER SERVICE PAN FORMER CORRODED (C-CHECK RO 11/12/2022) REPLACED FWD POTABLE WATER SERVICE PAN FORMER SEGMENT IAW CRJ200 SRM 51-42-06, 51-42-21,DWG 601R38316 REV-Y C/W 51-900-1003-SKY LEASDR AALA202211113534Web · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CABIN FLOOR WEB BETWEEN FR 8 AND FR 11 AT -Y765. MAINTENANCE REPLACED WEB PER SRM 51-42-11.SDR AALA202211114571Shear 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-42-11.SDR SWAA2022102030849Web · corrodedFWD CARGO COMPARTMENT DOOR THRESHOLD WEB HAS CORROSION IN AND AROUND FASTENER HOLES FROM STA-440 TO STA-492 (MARKED) / [01] REMOVED DAMAGE I.A.W SRM 51-10-02. MEASURED DAMAGE DEPTH TO BE .027?. DAMAGE FOUND TO BE BEYOND ALLOWABLE LIMITS AS GIVEN IN SRM 53-00-5SDR SWAA2022102040982Web · corrodedAFT CARGO COMPARTMENT WEB PLATE THRESHOLD HAS CORROSION FORM STA 792 THROUGH STA 847 / [01] REMOVED CORROSION PER SRM 51-10-02. BLENDED AREA IS OUT OF LIMITS PER SRM 53-60-15-1A-1.;[02] REMOVED DAMAGED WEB FOR REPLACEMENT PER SRM 51-40-02 .;[03] LOCATED AND DRSDR SWAA2022101839537Web · corrodedAFT CARGO BAY SUB THRESHOLD WEB HAS MULTIPLE AREAS OF CORROSION AROUND NUT PLATE HOLES BS794 TO BS847 RBL26 WL156 / [01] EVALUATED CORROSION AT ALL LOCATIONS; FOUND DEEPEST LOCATION TO BE AT BS 807+10 RBL 26 WL 156; FOUND 0.015 REMOVED FROM ORIG 0.045 IN NUMERSDR SWAA2022101839543Support · corrodedAFT CARGO BAY L/H FLOOR TO SIDEWALL SUPPORT PLATE HAS MULTIPLE AREAS OF CORROSION AROUND NUT PLATE HOLES BS727F TO BS847 LBL22 WL156 / [01] EVALUATED CORROSION AT ALL LOCATIONS; FOUND THE DEEPEST LOCATION TO BE AT BS 727H+10 LBL 22 WL 156; FOUND 0.015 REMOVED SDR SWAA2022101861092Plate · corrodedAFT CARGO BAY L/H FLOOR TO SIDEWALL SUPPORT PLATE HAS MULTIPLE AREAS OF CORROSION AROUND NUT PLATE HOLES BS727F TO BS847 LBL22 WL156 / [01] EVALUATED CORROSION AT ALL LOCATIONS; FOUND THE DEEPEST LOCATION TO BE AT BS 727H+10 LBL 22 WL 156; FOUND 0.015 REMOVED SDR SWAA2022101839544Support · corrodedAFT CARGO BAY R/H FLOOR TO SIDEWALL SUPPORT PLATE HAS MULTIPLE AREAS OF CORROSION AROUND NUT PLATE HOLES BS727G TO BS767 RBL22 WL156 / [01] EVALUATED CORROSION AT ALL LOCATIONS; FOUND THE DEEPEST LOCATION TO BE AT BS 727J+10 RBL22 WL 156; FOUND 0.015 REMOVED F
Back to JASC 5320