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 SWAA2022111556895Scuff Plate · crackedFWD CARGO COMPARTMENT FWD CORNER SCUFF PLATE CRACKED. WELDING REPAIR IAW SRM 53-30-15-2R-1AND SOPM 20-20-02 . SCUFF PLATE WILL BE INSTALL ON T/C TTG8Q004EWZ3.SDR AALA202211152321Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 747 TO BS 767 AND S25L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R REPAIR 5. OPENSDR SWAA2022110956747Frame · corroded947 FRAME RBL 17-22 UPPER SURFACE IS CORRODED AND HAS GOUGE IN FRAME WL160 / FOUND TO BE OUT LIMITS I.A.W SRM 53-70-07-0L-1 FOR IDENTIFICATION AND SRM;53-00-07-1A-1.;[02] UPDATED MEASUREMENTS.;[03] VERIFIED CORRECTIVE ACTION #1<BR>VERIFIED MEASUREMENTS;[04] CUSDR SWAA2022110857193Intercostal · crackedINTERCOSTAL TOP ANGLE AT BL 0; BS 500D TO BS 520; WL 208 HAS MULTIPLE CRACKS / [01] NO ALLOWABLE DAMAGE FOUND ON SRM . PART TO BE REPAIR BY REPLACEMENT PER SRM 51-10-02 PARAGRAPH 9.C;[02] VERIFIED ITEM 1 CORRECTIVE ACTIONS.;[03] INSTALLED FOD PROTECTION OF ELESDR AALA202211031024Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON TRANSITION PANEL LOCATED AT STA 747 AND STR 25R. REMOVED AND REPLACED TRANSITION PANEL PER SRM 53-0-53-2R.SDR AALA202211012321None · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 747 TO BS 767 AND S25L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R REPAIR 5.SDR SWAA2022102856546Intercostal · corrodedCABIN INTERCOAST UPPER SURFACE HAS CORROSION BETWEEN STA 294.5 TO STA 312 LBL 10 WL 208. / FOUND TO BE OUT OF LIMITS PER REF SRM 53-10-51-1A-1 AND DWG #141A5690.;[06] PARTIALLY REMOVED OUT OF LIMITS INTERCOASTAL BETWEEN STA 294.5 TO STA 312 LBL 10 WL 208 IN RESDR SIMA20221006005Panel · corrodedAFT GALLEY R/H SHEAR PANEL FLOOR STRUCTURE AT FR87-88 IS CORRODED ON TOP SIDE.-C/A-REMOVED AND REPLACED AFT GALLEY R/H SHEAR PANEL FLOOR STRUCTURE AT FR87-88 IAW EMB-175 SRM 51-40-08, 51-21-01, AND 51-40-02SDR SIMA20221006004Panel · corrodedAFT GALLEY L/H SHEAR PANEL FLOOR STRUCTURE AT FR87-88 IS CORRODED ON TOP SIDE (LEVEL 2 CORROSION)-C/A-REMOVED AND REPLACED AFT GALLEY L/H SHEAR PANEL FLOOR STRUCTURE AT FR87-88 IAW EMB-175 SRM 51-40-08, 51-21-01, AND 51-40-02SDR R61A2022102100658Floor Support · corrodedRH FLOOR SILL AT FR 84 CORRODED. R&R IAW SRM 51-41-01 AND 51-41-02.SDR R61A2022102100657Floor Support · corrodedLH FLOOR SILL AT FR 84 CORRODED. R&R IAW SRM 51-41-01 AND 51-41-02.SDR R61A2022102100656Floor Support · corrodedFLOOR STRUCTURE RH O/B PANEL SUPPORT BTWN FR 88-90 CORRODED. R&R IAW SRM 51-43-03.SDR R61A2022102100655Gusset · corrodedFLOOR GUSSET AT FR 90 LH I/B SIDE CORRODED. R7R IAW SRM 51-41-02.SDR R61A2022102100653Floor Support · corrodedFLOOR STRUCTURE LH I/B SUPPORT BEAM BTWN FR 86-89 CORRODED. R&R IAW SRM 51-41-01, 51-42-01 & 51-43-01.SDR R61A2022102100652Shear Web · corrodedFLOOR STRUCTURE LH SHEAR WEB BTWN FR 87-88 CORRODED. R&R IAW SRM 51-42-01 & 51-43-01.SDR R61A2022102100650Splice Plate · corrodedFLOOR STRUCTURE L/H O/B SPLICE PLATE AT FR 88 CORRODED. R&R IAW SRM 51-42-02.SDR R61A2022102100649Shear Web · corrodedFLOOR STRUCTURE RH SHEAR WEB BTWN FR 87-88 CORRODED. R&R IAW SRM 51-42-01.SDR R61A2022102100648Gusset · corrodedFLOOR GUSSET PLATE AT FR 90, BL 0 CORRODED. R&R IAW SRM 51-43-03.SDR REXA2022101102228None · corrodedCORROSION FOUND RH SIDE SEAT RAIL BETWEEN FS 571.00-661+14 REPLACED RH SIDE SEAT RAIL FOR FS 571.00-661+14 IAW CRJ900 AMM 53-00-49-400-801-A07SDR REXA2022101102227None · corrodedCORROSION FOUND RH SIDE SEAT RAIL BETWEEN FS 379.00-483.00. REPLACED RH SIDE SEAT RAIL FOR FS 379.00-483.00 IAW CRJ900 AMM 53-00-49-400-801-A07SDR EVCA202210070002Floor Support · crackedTHERE IS AN APPROX 1/2 INCH CRACK ON RH RIB AT INBOARD OUTER EDGE.SDR EVCA20221007001Floor Support · crackedTHERE IS AN APPROX 1/2 INCH CRACK ON LH RIB AT INBOARD OUTER EDGE.SDR V0XD20221006002Floor Support · corrodedCORROSION ON FLOOR BEAM 3 PLACES BL-0 FR 19-23: CORRECTIVE ACTION: REMOVED AND REPLACED FLOOR BEAM AT BL-0 FR 19-23 IAW EMB 145 SRM 51-40-02SDR V0XD20221006001Gusset · corrodedCORROSION ON GUSSETT BL-0 FR 20-21: CORRECTICE ACTION: REMOVED AND REPLACED GUSSETT IAW EMB 145 SRM 51-40-02SDR IXXA2022100601Web · corrodedFLC WEB CORRODEDSDR AALA202212213635Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 760 TO BS 787 AND FROM LBL 19 TO LBL 22. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202212215637Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 727I TO BS 767 AND FROM RBL 19 TO RBL 22. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R.SDR AALA202212214705Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 727G TO BS 727H AND FROM LBL 19 TO LBL 22. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R.SDR AALA202212219542Transition Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED AT BS 727I AND LBL 22. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R.SDR ASAA2022100540242Transition Panel · corrodedAFT PIT L/H TRANSITION PANEL FROM STA 727 TO 727E+10 IS CORRODED. GROUNDED - YES. REPAIRED THE AFT PIT L/H TRANSITION PANEL FROM STA 727 TO 727E+10 USING MAT BAC 1496-377 PER B737-800 SRM 53-00-53-2R-5.SDR SWAA2022102456485Angle · corrodedAFT CARGO; L/H TRANSITION ANGLE STA. 727H+10 THRU STA.787+10 CORROSION OUT OF LIMITS. AFT CARGO L/H TRANSITION ANGLE STA. 727H+10 THRU STA.787+10 CORROSION OUT OF LIMITS. / [01] REMOVED DAMAGE SECTION AND FABRICATED NEW ANGLE; DRILLED AND DEBURED FROM 727H+10 SDR R61A2022102400670Shear Plate · corrodedCORRODED SHEAR CLIP AT FR 84 BETWEEN STGR 27R AND 28R. REMOVED AND REPLACED SHEAR CLIP PER SRM 51-40-08SDR R61A2022102100661Floor Support · corrodedRH FLOOR BOARD SUPPORT BRACKET AT FR 17 CORRODED. R&R IAW SRM 51-41-01.SDR R61A2022102100660Shear Web · corrodedLH SHEAR WEB BTWN FR 19-20 CORRODED. R&R IAW SRM 51-41-02 AND 51-43-02.SDR R61A2022102100659Gusset · corrodedCABIN FLOOR GUSSET PLATE AT FR 90 RH O/B SIDE CORRODED. R&R IAW SRM 51-41-02.SDR R61A2022102100651Gusset · corrodedCABIN FLOOR GUSSET PLATE AT FR 90 RH I/B SIDE CORRODED . R&R IAW SRM 51-41-02.SDR SWAA2022101756395Track · crackedAFT CARGO BAY LBL 17 TIEDOWN TRACK IS CRACKED AT BS 727E WL 156 / [01] REMOVED TIEDOWN TRACK AT ACB LBL 17 BS 727 TO BS 867 WL 156 IAW SRM 51-40-02;[02] UPON FURTHER EVALUATION CRACK AT AFT CARGO COMPARTMENT TIEDOWN TRACK STA 727E; LBL 17; WL 166 LENGHT= .5'. SDR SWAA2022101756396None · crackedAFT CARGO BAY RBL 13 TIEDOWN TRACK IS CRACKED AT BS 727E WL 156 / [01] REMOVED AFT CARGO BAY RBL 13 TIEDOWN TRACK BETWEEN BS 727+4 TO BS 887; WL 156 IAW SRM 51-40-02-0G-0;[02] CRACK ON SEAT TRACK BTW 727 TO 747+10' IT IS OUT OF LIMITS WILL BE REPAIRED BY REPLASDR FDEA202210052464Floor Support · corrodedLOWER CENTER CARGO COMPARTMENT STATION 1841 WEB LOWER FLOOR SUPPORT FOUND WITH CORROSION. LOWER CENTER CARGO COMPARTMENT STATION 1841 WEB , CORROSION AT LOWER FLOOR SUPPORT EVALUATED FOUND EXFOLIATED AND EXCEEDED LIMIT AS PER SRM 53-00-00-2R FIGURE 202 RSDR SWAA2022100656615Scuff Plate · crackedREF EA 22-153-02985-TLD FWD ENTRY DOOR LOWER THRESHOLD FWD INNER REVEAL CRACKED AT AFT FASTENER; REQUIRES REPLACEMENT. / [01] REMOVED AND REPLACED FWD ENTRY LOWER THRESHOLD FWD INNER SCUFF PLATE CORNER PER AMM 53-11-01.SDR SWAA2022100653966None · crackedPANEL BREAK ASSY AT FUSELAGE STA 537.45 CRACKED / [01] INSTALLED CENTER FLOOR PANEL AT STA 540 IN REF. TO AMM 53-21-00.SDR SWAA2022100653967None · crackedPANEL BREAK ASSY AT FUSELAGE STA 537.45 CRACKED / [01] INSTALLED CENTER FLOOR PANEL AT STA 540 IN REF. TO AMM 53-21-00.SDR REXA2022100502207None · corrodedRIGHT SIDE SEAT RAIL BETWEEN FS 785.00 AND 847+16 IS CORRODED REPLACED RH SIDE SEAT RAIL P/N SH670-36260-5 FROM FS 785.00 TO 847+16 IAW CRJ 900 AMM 53-00-49-400-801(A07).SDR SWAA2022111555580Floor Splice · brokenAFT CARGO LT SIDE FLOOR CAP STRIP SPLICE AT APPROX. STA 767 IS BROKEN. INSTALLED ON ROUTINE T/C TTG8Q004E3DG.SDR SWAA2022110354879Structure · corrodedCORROSION SPOTS ON AFT WET AREA INNER CHORD UPPER SURFACE B.S.951-992.8 RBL. 45'-55' W.L. 208. (51-014) / [01] REMOVED CORROSION ON AFT WET AREA INNER CHORD UPPER SURFACE B.S 951-992.8 RBL 45'-55' WL 208 AS PER B737 SRM 51-10-02-0G-0-A00248;[02] VERIFIED STEP SDR SWAA2022110254871Strap · corrodedCORROSION SPOTS 0N AFT WET AREA FLOOR WEB AND STRAP B.S. 1016 TO AFT PRESSURE BLKHD. CENTER BL. TO LBL. 20' W.L. 208.(51-007) / [01] REMOVED LIGHT SURFACE CORROSION SPOTS ON AFT WET AREA FLOOR WEB AND STRAP B.S 1016 TO AFT PRESSURE BLKHD;[02] VERIFIED STEP #1.SDR SWAA2022110152318Channel · corrodedAFT CARGO COMPARTMENT LEFT SIDE; FLOOR STRUCTURE 'Z CHANNEL'; AROUND HOLES HAS EVIDENCE CORROSION BETWEEN STA 727C TO 727D; WL 155.5; LBL-21. / [01] Z-CHANNEL (PN:146A7502-27) STA 727-847 REPLACED FOR WORK ACCOMPLISHED REFERENCE TASK CARD# TTG8Q00F6526;[02] VESDR SWAA2022110152330Channel · corrodedAFT CARGO COMPARTMENT LEFT SIDE; FLOOR STRUCTURE 'Z CHANNEL'; AROUND HOLES HAS EVIDENCE CORROSION BETWEEN STA 727D TO STA 727E; WL 155.5; LBL-21 / [01] Z-CHANNEL (PN:146A7502-27) STA 727-847 REPLACED FOR WORK ACCOMPLISHED REFERENCE TASK CARD# TTG8Q00F6526;[02]SDR SWAA2022110152331Channel · corrodedAFT CARGO COMPARTMENT LEFT SIDE; FLOOR STRUCTURE 'Z CHANNEL'; AROUND HOLES HAS EVIDENCE CORROSION BETWEEN STA 727E TO 747; WL 155.5; LBL-21 / [01] FOUND EXFOLIATED CORROSION AT AFT CARGO LH Z CHANNEL STA 727E TO 747 LBL21 OUT OF LIMITS PER REF SRM 51-10-02-0G-SDR SWAA2022110152332Channel · corrodedAFT CARGO COMPARTMENT LEFT SIDE; FLOOR STRUCTURE 'Z CHANNEL'; AROUND HOLES HAS EVIDENCE CORROSION BETWEEN STA 747 TO 767; WL 155.5; LBL-21 / [01] Z-CHANNEL (PN:146A7502-27) STA 727-847 REPLACED FOR WORK ACCOMPLISHED REFERENCE TASK CARD# TTG8Q00F6526;[02] VERIF
Back to JASC 5320