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 AALA202211145105Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON WEB LOCATED FROM BS 986.5 TO BS 1016 AT LBL 33. REPAIRED WEB PER SRM 53-70-51-1A.SDR AALA202211048497Channel · corrodedAIRCRAFT IN BASE MAINTENANCE: LEFT Z CHANNEL LOCATED AT STA 992-1016 AND 33 INCHES LEFT BUTT LINE HAS CORROSION. REMOVED AND REPLACED Z CHANNEL PER SRM 53-70-51-1A.SDR REXA2022110302391Stringer · corrodedCORROSION FOUND ON STGR 26L BETWEEN FS 1015.00-1031.00 REPAIRED STGR 26L IAW MHIRJ REO 690-53-61-1126 REV. --, DATED 2022-10-24.SDR R61A2022110100678Floor Support · corrodedLH FLOOR SUPPORT BTWN FR 88 - 90 CORRODED. R&R IAW SRM 51-41-01, 51-43-01, 51-21-01 AND 51-23-05.SDR R61A2022110100675Floor Support · corrodedRH FLOOR SUPPORT BTWN FR 83 - 84 CORRODED. R&R IAW SRM 51-41-02, 51-41-01 AND 51-43-02.SDR R61A2022110100674Floor Support · corrodedLH FLOOR SUPPORT BTWN FR 83 - 84 CORRODED. R&R IAW SRM 51-41-01 AND 51-41-02.SDR R61A2022110100672Shear Web · corrodedLH SHEAR WEB BTWN FR 13 - 16 CORRODED. R&R IAW SRM 51-41-02.SDR R61A202211010671Shear Web · corrodedLH SHEAR WEB BTWN FR 13 - 16 CORRODED. R&R IAW SRM 51-41-02.SDR DALA2022110107076Floor Support · corroded(LOG 2474130) DURING INSPECTION FOUND CORROSION ON FLOOR SUPPOR RBL.59 BTW. STA. 947 TO STA.967 AT PASSENGER CABIN FLOOR STRUCTURE AREA W2. FLOOR SUPPORT RBL.59 STA 947 TO STA 967 WAS REPLACED PER B737-900 ER SRM 51-40-02-0G.SDR A6WA202210298368Floor Support · corrodedL/H FLOOR MEMBER FROM FS621 TO FS 574 HAS AREAS OF CORROSION ***AIRCRAFT REMOVED FROM SERVICE*** REMOVED AND INSTALLED NEW CARGO FLOOR SILLSDR A6WA202210298367Intercostal · corrodedL/H INTERCOSTAL AT STRR21 FS 319.00 THRU FS 333.0 IS CORRODED ***AIRCRAFT REMOVED FROM SERVICE*** REMOVED AND REPLACED INTERCOSTALSDR AALA202210311748Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INTERCOSTAL LOCATED BETWEEN BS 294.5 AND BS 312, AT LBL 12. REPLACED INTERCOSTAL PER SRM 53-10-51-1A-1.SDR 2024FA0000164Stiffener · crackedAFT FUSELAGE LOWER SKIN STIFFENER FOUND CRACKED. REPLACED WITH NEW STIFFENER.SDR SWAA2022111665823Strap · corrodedCORRODED STRAP, BS 767-787, LBL21- RBL21, WL 155.5 IN THE AFT CARGO COMPARTMENT. REPLACED THE STRAP IAW SRM 51-40-02, AND SRM 51-10-02, STEP 9.SDR AALA202211150397Shear Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND AFT SHEAR WEB LOCATED AT BS 990 AND RBL 33. REPAIRED SHEAR WEB PER SRM 53-70-51-2R-6. **SUPPLEMENTAL REPORT FOR AALA202210310397: ENGINEERING REVIEWED THIS EVENT AND DETERMINED THE CORRECT LEVEL WAS LEVEL 2SDR AALA202211157669Retainer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CABIN FLOOR BEAM RETAINER BETWEEN FR 12 AND FR 16 AT -Y81. MAINTENANCE REPLACED FLOOR BEAM ASSEMBLY PER SRM 51-72-11.SDR SWAA2022111465874Floor Support · corrodedFLOOR SUPPORT BETWEEN STA 747 AND 767 RBL 21 HAS CORROSION AROUND NUTPLATE HOLES. LOCATED, DRILLED, AND INSTALLED A NEW FLOOR SUPPORT IAW SRM 51-40-02.SDR SWAA2022111465875Angle · damagedFWD CARGO, LT TRANSITIONAL ANGLE AT BS 500B+8 THRU 500G+10, WAS FOUND TO BE OUT OF LIMITS. REMOVED DAMAGE SECTION IAW SRM 51-40-02. LOCATED AND DRILLED FWD SPICE AT BS 500B +9 IAW SRM 53-00-53-2R-5. REPAIRED IAW SRM 53-00-53-2R-5, REPAIR 5, AND EA M-22-1SDR AALA202211086554Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN THE INBOARD END OF PASSENGER CABIN FLOORBOARD SUPPORT LOCATED AT BS 540, FROM RBL 0 TO RBL 24. REPLACED FLOORBOARD SUPPORT PER AARD 51-00-05 AND DWG 143A5240.SDR AALA202211088279Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN THE INBOARD END OF PASSENGER CABIN FLOOR SUPPORT LOCATED AT BS 540, WL 208, AND LBL 2. REPLACED FLOOR SUPPORT PER AARD 51-00-05 AND SRM 51-40-02.SDR AALA202211086637Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 730 TO BS 735, AT RBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-1 AND DWG 146A7502.SDR AALA202211087592Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 847 TO BS 849, AT LBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-1 AND DWG 146A750.SDR REXA2022110302385Beam · corrodedTOP OF FLOOR BEAM AT RBL9 BETWEEN FS 693.00 AND 847.00 IS CORRODED IN MULTIPLE LOCATIONS. REPAIRED TOP OF FLOOR BEAM AT RBL 9 BETWEEN FS693.00 AND 847.00 CORROSION IAW MHIRJ REO 690-53-41-331 REV -- DATED 2022-10-21SDR AALA202210310397Shear Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND AFT SHEAR WEB LOCATED AT BS 990 AND RBL 33. REPAIRED SHEAR WEB PER SRM 53-70-51-2R-6.SDR IPXA2022102987598Web · crackedINSPECTION TYPE:CAFT CABIN R/H SIDE PLATE BETWEEN FR76 AND FR77 CRACKEDREMOVED AND INSTALLED WEB IAW SRM 51-40-21SDR IPXA2022102987597Support · crackedINSPECTION TYPE:CR/H SIDE SUPPORT AT FR76 -Y2462 CRACKED AND DEFORMEDREMOVED AND INSTALLED PROFILE IAW SRM 51-40-21SDR DALA2022103107027Web · cracked(LOG 2472318) DURING INSPECTION FOUND CRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOC. BS 270 TO BS 294.5 BL 0 AT FWD GALLEY AREA. REPLACED WEB - INTERCOSTAL FLOOR STRUCTURE LOC. BS 270 TO BS 294.5 BL 0 AT FWD GALLEY AREA AS PER B737-900 SRM 51-10-02-0G ITEM 9 ANDSDR SWAA2022102865398Support Web · crackedFLOOR BEAM SUPPORT WEB CRACKED 3INCHES AT NUT PLATE BETWEEN STA 312-328 AT LBL 46.5 JUST BELOW FLOOR PANEL / [01] REMOVED AND REPLCACED INTERCOSTAL SUPPORT WEB PER SRM 51-40-02SDR SWAA2022102865225Filler · missingAFT CARGO DOOR OPENING AFT LOWER CORNER IS MISSING SCUFF PLATE FILLER PIECE. / [01] REMOVED AND REPLACED AFT CARGO DOOR AFT LOWER CORNER SCUFF PLATE FILLER PIECE PER AMM 53-11-02.SDR 2022F00432Support · crackedCRACKS FOUND ON FASTENER LOCATION FS 354.41, 440.81, AND 375.65 ON FUSELAGE CENTER SUPPORT FARING. ACCOMPLISHED NJA 680A EO WC NO C68-53-0003_1 REV. 0 DATED FEB 15, 2019 LATITUDE LH/RH CENTER FAIRING SUPPORT SPLICE STRAP REPAIR.SDR AALA202211290835Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO TRANSITION PANEL BETWEEN STA 727 AND STA 767 AT STR 25L. INSTALLED NEW TRANSITIONAL PANEL AT AFT CARGO PER SRM 51-40-02.SDR AALA202211218743Angle · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND CRACK ON FLOOR SUPPORT LOCATED AT STA 540 AND RIGHT BUTT LINE 2. REMOVED AND REPLACED FLOOR SUPPORT ANGLE PER AARD 51-00-05-1.SDR AALA202211183411Support Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK FOUND ON FLOOR SUPPORT LOCATED AT STA 540 AND LEFT BUTT LINE 2. REMOVED AND REPLACED FLOOR SUPPORT ANGLE PER AARD 51-00-0501.SDR R61A2022111700722Shear Panel · corrodedCORROSION FOUND ON FWD FUSELAGE SHEAR PANEL ON RH OUTBD SIDE BETWEEN FR 12 AND FR 14, FWD OF R1 DOOR. R&R'ED FWD FUSELAGE SHEAR PANEL ON RH OUTBD SIDE BETWEEN FR 12 AND FR 14, FWD OF R1 DOOR. IAW EMB 170/175 SRM 51-41-02SDR SWAA2022111464974Angle · corrodedTHE AFT CARGO R/H TRANSITION ANGLE HAS CORROSION FROM STA 770 TO 774 / [01] FOUND CORROSION ON R/H SIDE PLATE FROM STA 767-792 TO BE OUT OF ALLOWABLE LIMITS PER SRM 53-00-53-1A-2.;[02] REMOVED SHIELD; MATCH DRILLED NEW SHIELD PER SRM 51-40-05;[03] INSP DRILLINSDR SWAA2022111464975Angle · corrodedTHE AFT CARGO R/H TRANSITION ANGLE HAS CORROSION FROM STA 727H +8 TO 767, FOUND TO BE OUT OF LIMITS IAW SRM 53-0053-1A-2. REMOVED DAMAGED SECTION OF RT TRANSITION ANGLE IAW SRM 53-00-53-2R-5. LOCATED, DRILLED, TREATED AND PRIMED. IAW SRM 53-00-53-2R-5. INSTASDR SWAA2022111464976Angle · corrodedTHE AFT CARGO L/H TRANSITION ANGLE HAS CORROSION FROM STA 727F+10 TO 807 / LT TRANSITION ANGLE UPPER SURFACE FORM STA 727I TO STA 807; LBL 21; WAS FOUND TO BE OUT OF ALLOWABLE LIMITS IAW SRM 53-00-53-1A-2. REMOVED DAMAGED SECTION OF LT SIDEPLATE CHANNEL ASSEMSDR SWAA2022111464990Channel · corrodedAFT CARGO FLOOR CHANNEL AT RBL 21, WL 156, BS 727-727E+10 CORRODED. FOUND OUT OF LIMITS IAW SRM 51-10-02-0G-0. LOCATED AND DRILLED A NEW CHANNEL IAW SRM 51-40-05-0G-0. TREATED AND PRIMED THE NEW CHANNEL IAW AMM 51-21-41-370-804 AND AMM 51-21-72-370-804.SDR SWAA2022111464998Channel · corrodedAFT CARGO FLOOR CHANNEL AT RBL 21, WL 157, BS 727E-767 CORRODED. THE CHANNEL REPLACED ON TASKCARD# TTG8Q00FQYPW.SDR SWAA2022111464999Channel · corrodedAFT CARGO FLOOR CHANNEL LBL 21, WL 156, BS 727-727+10 CORRODED. REMOVED CORROSION IAW SRM 51-10-02-0G-0. PERFORMED UT THICKNESS INSPECTION IAW NDT PART 4 51-00-00 PROCE 3. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-53-1A-2. REMOVED Z CHANNEL SECTION FROM STSDR SWAA2022111464991Strap · corrodedAFT CARGO FLOOR STRAP LBL 21 TO RBL 21, WL 157, BS 767+5 CORRODED. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-53-1A-2. REMOVED THE FLOOR STRAP. INSTALLED A NEW AFT CARGO FLOOR STRAP IAW SRM 51-40-OG-0.SDR SWAA2022111465439Shield · corrodedCORROSION ON FWD CARGO FLOOR STRUCTURE SHIELD (WEB) AT RBL 22 WL 158 BETWEEN BS 492-500A. FOUND TO BE OUT OF LIMITS IAW SRM 53-30-15-1A-1. LOCATED, AND DRILLED A NEW SHIELD IAW SRM 51-40-05-0G-0. TREATED AND PRIMED IAW AMM 51-21-41-370-804, AND AMM 51-21-7SDR AALA202211088481Baffle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON BAFFLE ASSEMBLY LOCATED BETWEEN BS 500F AND BS 500G AT S25R. REPLACED BAFFLE PER SRM 53-30-53 2R1.SDR AALA202211082703Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN INTERCOSTAL LOCATED AT BS 282 AT BL 0. REPLACED INTERCOSTAL PER SRM 51-40-02, AARD 51-00-05-1 AND DWG 141A5410-139.SDR AALA202211044733Plate · corrodedFORWARD CARGO LEFT ZEE CHANNEL SIDE PLATE CORRODED LEFT BUTT LINE 21 FROM STA 500-500I. REMOVED AND REPLACED SIDE PLATE PER SRM 53-00-53-2R-6.SDR A6WA202210278363Intercostal · corrodedL/H INTERCOSTAL AT STGR21 BTW FS 333.00 TO FS 349.00 IS CORRODED ****AIRCRAFT REMOVED FROM SERVICE**** REPLACED INTERCOSTALSDR KCSA202210271172Stiffener · crackedBULK CARGO STIFFENER SATION 1480 LBL 8 IS CRACKEDSDR KCSA202210271171Stiffener · crackedSTIFFENER BULK CARGO STATION 1461 LBL 8 IS CRACKEDSDR UIEA2022092801056Floor Support · corrodedU/D STA 400-460 LBL 20 - RBL 20 FLOOR BEAM CORROSION AT STA 400 LBL 10 TO LBL 14(<P>CORROSION REMOVED AND REPROTECED IAW SRM 51-10-02 AND 51-20-01 WITHIN SRM 53-00-51 ALLOWABLE DAMAGE 1 FIG 101 LIMITS </P>)SDR UIEA2022092801057Floor Support · corrodedU/D STA 400-460 LBL 20 - RBL 20 FLOOR BEAM FOUND CORROSION AT STA 426 TO STA 446 LBL 20(<P>CORROSION REMOVED AND REPROTECTED IAW SRM 51-10-02 AND 51-20-01 WITHIN SRM 53-00-01 ALLOWABLE DAMAGE 1 FIG 101 LIMITS</P>)
Back to JASC 5320