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 SWAA2021051065480Strap · corroded***CORROSION*** ON ACB FLOOR BOARD SPLICE STRAP BS 887; LBL 8 - RBL 8; WL 157 /SDR IPXA2021051069143Stiffener · crackedINSPECTION TYPE:3CAFT CARGO FLOOR VERTICAL STIFFENER AT STA 1841 & RBL 26 IS CRACKED.REMOVED AND REPLACED CRACKED AFT CARGO FLOOR VERTICAL STIFFENER AT STA 1841 & RBL 26 IAW SRM 51-33-01. (MINOR)SDR SIMA20210420006Door Sill · corrodedCARGO DOOR SILL IS CORRODED. (LEVEL 2 CORROSION)-C/A-REMOVED AND REPLACED CARGO DOOR SILL (PN 145-25480-603) IAW EMB 145 SRM 51-40-02SDR WX0A2021050373694Floor Support · corrodedDURING THE S1 CHECK OF PASSENGER CABIN FLOOR STRUCTURE, FOUND CORROSION LOCATED ON LONGITUDINAL BEAM Y122 AT FR 66 AREA / REPLACED LONGITUDINAL BEAM BTW FR 64 - 66 AND Y122 PER SRM 51-72-11."SDR IPXA2021043068814Floor Support · corrodedINSPECTION TYPE:3CCENTER CARGO HAS A CRACKED FLOOR SUPPORT AT STA. 1521 AND LBL 43.REMOVED, FABRICATED AND REPLACED SUPPORT IAW DWG. AEA0341 AND SRM 51-31-01.(MINOR)SDR IPXA2021050168842Floor Support · corrodedINSPECTION TYPE:3CAFT CARGO FLOOR SUPPORT ANGLE UNDER PANEL 187DF HAS CORROSION AT STA 1967.REMOVED AND REPLACED CORRODED AFT CARGO FLOOR SUPPORT ANGLE UNDER PANEL 187DF AT STA 1967 IAW SRM 51-31-01. (MINOR)SDR SIMA20210420005Floor Support · corrodedCPCP SSI: LH OUTBOARD FLOOR SUPPORT IS CORRODED AT NUTPLATE JUST AFT OF FRAME 20.-C/A-RAR'D LH OUTBD. FLOOR SUPPORT JUST AFT OF FR 20 IAW SRM 51-40-02.SDR N6WA2021042003Door Sill · corrodedAFT CARGO DOOR SILL HAS CORROSION.REMOVED CORROSION AT AFT CARGO DOOR SILL, INSTALLED NEW SILL ON AFT CARGO IAW CRJ 700 SRM 51-42-06SDR CALA2021042200518Intercostal · crackedRH FR-16 STOP #7 UPPER AND INBD LOWER HOLE HAS A CRACK INDICATIO N AT 1 O''CLOCK IN THE INTERCOSTAL GEN BY V061632 PER NR9292398 / 38398. REMOVED AND REPLACED RH FR16 STOP 7 INTERCOSTAL FITTING IAW A319 SRM 51-42-11-00 AND ECRA 5311-02542 DWG R531113118 BY MECSDR CALA2021042200517Intercostal · crackedRH FR-16 STOP #7 UPPER AND INBD LOWER HOLE HAS A CRACK INDICATIO N AT 1 O''CLOCK IN THE INTERCOSTAL GEN BY V061632 PER NR9292398 / 38398. REMOVED AND REPLACED RH FR16 STOP 7 INTERCOSTAL FITTING IAW A319 SRM 51-42-11-00 AND ECRA 5311-02542 DWG R531113118 BY MECSDR CALA2021042200516Intercostal · crackedLH FR16 #7 DOOR STOP UPPER AND LOWER INBD HOLES HAVE CRACK INDICATIONS PER NR9292406 / 38406 REMOVED AND REPLACED LH FR16 STOP 7 INTERCOSTAL FITTING IAW A319 SRM 51-42-11-001, ECRA 5311-02542 AND DWG R531113118.SDR IPXA2021042068427Tee Fitting · corrodedINSPECTION TYPE:SEG1WTB TEE CHORD P/N: 149N7528-106 HAS SEVERE CORROSION AT STA 1180, RBL 31-RBL40REMOVED AND REPLACED TEE CHORD IAW SRM 51-40-02-0G.SDR JGVR20210420003Panel · corrodedFOUND 200 AREAS OF CORROSION ON INNER THRESHOLD PANELS. REMOVED PAINT FROM SUSPECT AREAS ON INNER THRESHOLD PANELS AND FOUND 180 AREAS THAT WERE BEYOND SURFACE CORROSION. MATCH DRILLED AND TRIMMED NEW FWD(P/N: 6911084-11), CENTER(P/N: 6911084-5), AFT(P/N: 6911SDR SWIA2021072259678Door Sill · corroded* PAX DOOR LOWER SILL CORRODED IN MULTIPLE SPOTS BETWEEN FS310.00 AND FS349.00 (MARKED). (C-CHECK RO 7/20/2021) REPLACED PAX DOOR LOWER SILL WITH NEW SILL AT FS310-FS349 REF CRJ-700 SRM 51-42-06-001-001-A01, 51-42-21-001-001-A01, AND DWG SH670-31810 REVSDR SWIA202159106Floor Support · corrodedSERVICE DOOR- SERVICE DOOR FLOOR SUPPORT ANGLE (TOP ANGLE) P/N: SH670-31986-1 HAS CORROSION AT RADIUS (C-CHECK RO 6/22/2021) REMOVED DAMAGED SERVICE DOOR FLOOR SUPPORT ANGLE (TOPANGLE) P/N: SH670-31986-1 REF CRJ-900 SRM 51-42-06-001-001-A01 / INSTALLED SDR SWIA202158650Door Sill · corroded* PAX DOOR SURROUND LOWER SILL ANGLE IS CORRODED. (C-CHECK RO 6/04/2021) REPLACED WITH NEW PAX DOOR LOWER SILL ANGLE WITH NEW FASTENERS REF. CRJ700SRM 51-42-21-001-001-A01, CRJ700 SRM 51-42-06-001-001-A01, AND DRAWING SH670-31810 REV AE. COMPLIED WITH 5SDR SWIA202158647Floor Support · corrodedFLOOR BEAM CAP AT LBL27 FROM APPROX. FS1000.00 TO FS1047 HAS CORROSION (MARKED) (C-CHECK RO 6/04/2021) REPLACED FLOOR BEAM CAP AT LBL27 REF CRJ700 SRM 53-00-41-201-001-A01 AND CRJ 700 SRM 51-42-21-001-001-A01 COMPLIED WITH SKYWEST TASKCARD 51-900-100SDR SWIA202158646Floor Support · corrodedFLOOR BEAM CAP AT LBL9 FROM APPROX. FS1000.00 TO FS1047 HAS CORROSION (MARKED) (C-CHECK RO 6/04/2021) REMOVED AND INSTALLED NEW FLOOR BEAM SECTION AT LBL9 FROM FS980 TO FS1056 REF CRJ700 SRM 53-00-41-201-001-A01 (FIG 53-00-41-991-830) COMPLIED WITH SKYWSDR SWIA202158645Intercostal · corroded* FOUND SURFACE CORROSION AT THE INTERCOSTAL OF THE FWD FUSELAGE INTERNAL STRUCTURE BELOW THE FLOOR AT F.S333.00 APPROX AT STGR21L (AREA MARKED). (C-CHECK RO 6/04/2021) EVALUATED, REMOVED AND INSTALLED NEW INTERCOSTAL OF THE FWD FUSELAGE INTERNAL STRSDR SWIA202158644Door Sill · corroded* FWD CARGO DOOR SILL PLATE CORRODED FROM APROX FS 533 TO FS 581 BETWEEN STRG 26L AND 25L MARKED (C-CHECK RO 6/04/2021) REMOVED CORROSION ON FWD CARGO DOOR SILL PLATE FROM APROX FS 533 TO FS 581 BETWEEN STRG 26L AND 25L MARKED REF CRJ 700 SRM 51-21-06-SDR SWAA2021052766456Intercostal · corrodedCORROSION WEB - INTERCOSTAL LOCATED BETWEEN BS 787 AND BS 767 S-25R WL154.5 AT AFT CARGO COMPARTMENT / REPLACED WEB INTERCOSTAL AND FASTENER LOC BTW BS747 AND BS767 S-25R WL 154.5 AFT CARGO COMPARTMENT IAW SRM B737-700 51-10-02 ITEM 9 AND DRAWING 146A7502 MATESDR SWAA2021052766454Structure · crackedCRACK ENTRY DOOR CUT OUT INNER CHORD LOCATED ON BS 303.9 AND STRINGER 17L AT FWD GALLEY AREA / REPLACED INNER CHORD LOCATED ON BS 360 TO BS 270 AT LEVEL STRINGER 17L AT FWD GALLEY AREA IAW B737-700 SRM 51-40-02 AND SRM 51-10-02 ITEM 9 AND DWG # 142A0050 REV - SDR SWAA2021052766453Intercostal · crackedCRACK ENTRY DOOR CUT OUT INTERCOSTAL WEB LOCATED BEETWEN BS 294.5 TO BS 303.9 AND STRINGER 16L AT FWD GALLEY AREA / REPLACED ENTRY DOOR CUT OUT INTERCOSTAL WEB LOCATED BETWEEN BS 294.5 TO BS303-9 AND STRINGER 16L AT FWD GALLEY AREA UAW B737-700 SRM 51-40-02 ANSDR SWAA2021051065371Support · corroded***CORROSION*** AFT CARGO RH FLOOR TO SIDEWALL SUPPORT; BS 867 + 15; RBL 21 TO RBL 22; WL 156 / REMOVED AND REPLACED ACB FLOOR SUPPORT STA.867-947 PER SRM 51-40-05; 51-40-02; SOPM 20-41-02 AND DWG. 146A7502. 91195U 4-25-21SDR SWAA2021051065370Support · corrodedCORROSION AFT CARGO LH FLOOR TO SIDEWALL SUPPORT; BS 727A TO BS 807; LBL 21; WL 156 / REMOVED CORROSION AT ACB L/H FLOOR TO SIDEWALL SUPPORT BS727A TO BS807 LBL21 WL156 MAX MAT REMOVED IS MORE THAN 50% OF ORIGINAL THICKNESS; THEREFORE; FOUND TO BE OUT OF LIMITSDR SWAA2021051065363Support · elongatedFWD CARGO LH FLOOR TO SIDEWALL SUPPORT HAS ELONGATED FASTENER HOLES; LBL 23 WL 156; BS 500B + 2; BS 500B + 2.5 AND BS 500B + 6 / REMOVED AND INSTALLED NEW ON FCB L/H FLOOR TO SIDEWALL SUPPORT BS400 TO BS500D LBL23 FABRICATED FROM BAC 1496-444 #7D75T62 LOT# 145SDR SWAA2021050365131Channel · corrodedAFT CARGO R/H SIDE CHANNEL CORRORED AT STA 947.5 / FABRICATED NEW Z CHANNEL AT AFT CARGO FROM STA 867 TO STA 947.5 PER REF 737 SRM 51-40-02-0G-0 AND DRAWING NO.147A7500.SDR CALA2021042200511Door Sill · corrodedR2 DOOR SILL IS CORROED AT FR68 PER HAECO LCQ NON ROUTINE 929244 2/38442 GENERATED BY V061680 REPAIRED R2 DOOR SILL FR68 IAW SRM 53-41-14-283-002 AND 53-41-14 -300-001 BY MECH V914232 INSP BY V061629SDR VNAA202104219992Intercostal · corrodedINTERCOASTAL LOCATED AT FS 310 TO FS 333 STR 21L IS CORRODEDSDR DALA2021042002290Floor Support · corrodedSHIP 3244 CORROSION FLOOR BEAM -Y765 LOC. BTW FRAME 12 AND FRAME 24 AT FWD GALLEY AREA. CORRECTIVE ACTION: REPLACED FLOOR BEAM PER A320 SRM 51-72-11. (1786344)SDR KCSA202104191048Door Sill · corrodedEVIDENCE OF CORROSION ON UPPER CHORD OF BULK PIT LOWER SILL PLATESDR SWIA2021080960138Threshold · corrodedSERVICE DOOR THRESHOLD IS CORRODED BEYOND REPAIRABLE LIMITS ON THE THE UPPER FLANGE. NEEDS REPLACED (C-CHECK RO 8/5/2021) LOCATED , DRILLED AND INSTALLED NUTPLATES ON NEW SERVICE DOOR SILL THRESHOLD IAW CRJ 200 SRM 51-40-11 AND 51-42-06 . REFERENCE CONTSDR SWIA202158640Intercostal · corroded* INTERCOSTAL 20R HAS MULTIPLE AREAS OF CORROSION BETWEEN FRAMES FS 319.70 AND FS 349.00. (C-CHECK RO 6/04/2021) REPLACED INTERCOSTAL 20R BETWEEN FRAMES FS 319.70 AND FS 349.00 REF CRJ 700 SRM 51-42-06-001-001-A01 & DWG NO SH670-31950 REV Y. FOR MORE DSDR SWIA202158639Intercostal · corroded* INTERCOSTAL 20R FORWARD OF FS 319.70 FRAME HAS CORROSION. (C-CHECK RO 6/04/2021) REPLACED INTERCOSTAL 20R FWD OF FS319.70 FRAME REF CRJ-700 SRM 51-42-06-001-001-A01 AND DWG SH670-31950 REV Y. COMPLIED WITH TASK CARD 51-900-1002-SKYSDR SWIA202158638Floor Support · corroded* L/H FLOOR SILL FROM F/S 985 TO1000 HAS MULTIPLE AREAS OF CORROSION (C-CHECK RO 6/04/2021) REPAIRED LH FLOOR SILL WITH NEW SILL, INTERCOSTAL AND REPAIR ANGLES REF MHIRJ REO 670-53-61-1885 REV -- DATED 2021-05-07. COMPLIED WITH TASK CARD 51-900-1002-SKYSDR SWIA202158637Floor Support · corroded* R/H FLOOR SILL FROM F/S 1016 TO 1098 HAS MUTIPLE ARES OF CORROSION (C-CHECK RO 6/04/2021) REPLACED RH FLOOR SILL FROM FS1015 - FS1031 REF CRJ-700 SRM 51-42-06-001-001-A01 AND DWG MM670-35052 REV K. COMPLIED WITH TASK CARD 51-900-1002-SKY.SDR SWAA2021052765668Intercostal · crackedCRACK WEB - INTERCOSTAL LOCATED BETWEEN BS 847 AND BS 867 CEILING PANEL LBL 15 APPROX AFT CARGO COMPARTMENT / REPAIR WEB-INTERCOSTAL LOCATED BETWEEN BS 847 AND BS 867 CEILING PANEL LBL 15 APPROX AFT CARGO COMPARTMENT IAW SWA EA # 21-153-01307 REV IR AND AEROMASDR SWAA2021052765666Intercostal · corrodedCORROSION WEB - INTERCOSTAL LOCATED BETWEEN BS494 TO BS500A AT LEVEL STR26R AND RBL21.80 AT FWD CARGO COMPARTMENT / REPLACED WEB-INTERCOSTAL LOC BTW BS494 TO BS500A AT LEVEL STR 26R AND RBL 21.80 AT FWD CARGO COMPARTMEN PART NUMBER USED 143A8126-31 PO:0 IAW B7SDR SWAA2021052765671Support · corrodedCORROSION SUPPORT ZEE LOCATED BETWEEN BS 767 AND BS 727 S-25R WL 154.5 AT AFT CARGO COMPARTMENT / REPLACED SUPPORT ZEE LOCATED BETWEEN BS 727 TO BS 767 S-25R WL 154.5 AT AFT CARGO COMPARTMENT IAW SRM B737-700 51-10-02 ITEM 9 AND DRAWING #146A7500 REV:-MATERIALSDR SWAA2021052765670Support · corrodedCORROSION SUPPORT ZEE LOCATED BETWEEN BS 847 AND BS 727 S-25L WL 154.5 AT AFT CARGO COMPARTMENT / REPAIRED SUPPORT ZEE LOCATED BETWEEN BS 727 TO BS 847 S-25L WL 154.5 AT AFT CARGO COMPARTMENT IAW SRM B737-700 53-00-53-2R-6 REPAIR 6 AND DRAWING #146A7500 REV:-MSDR SWAA2021052465669Angle · crackedCRACK ANGLE LOCATED BS 867 S-26L AFT CARGO COMPARTMENT / REPLACED ANGLE AND FASTENRS LOCATED BS 867 AND STRINGER 26L AFT CARGO COMPARTMENT IAW B737-700 SRM 51-10-02 ITEM 9;SRM 51-40-02 DRAWING #149A8402. REVSDR DALA2021042902472Cap · detachedRIGHT WING AFT FAIRING CAP CAME OFF ON SHORT FINAL. CORRECTIVE ACTION: FORWARD #3 RH FLAP FAIRING TAIL CONE TO CDL. INSTALLED #3 RH FLAP FAIRING TAIL CONE.SDR HNAA2021051900212Door Sill · corrodedSERVICE DOOR CENTER SILL IS CORRODED. REMOVED AND REPLACED SERVICE DOOR CENTER SILL IAW EMB-145 SRM 51-40-02.SDR SWAA2021051065361Intercostal · corrodedCORROSION ON AFT CARGO DOORWAY INTERCOSTAL WEB UPPER FLANGE; BELOW LWR SUB THRESHOLD IB CHORD; BS 794 + 1.5; RBL 19; WL 156; MARKED / REMOVED AND INSTALLED NEW INTERCOSTAL WEB P/N 7530561 AND P/O. 821015. IAW SRM 51-40-02 AND DWG 146A8120. 92861U 23APR21.SDR SWAA2021051065266Web · corrodedCORROSION ON AFT CARGO DOORWAY; LWR SUB THRESHOLD WEB UPPER SURFACE AT 11 EA FASTENER HOLES; BS 794 + 3 TO BS 827 + 3; RBL 26; WL 156; MARKED / REMOVED AND REPLACED SUB THRESHOLD WEB AT ACB FROM BS 794 TO BS 847 RBL 26 WL 156 IAW SRM 51-40-02-0G-0 DWG 146A8340SDR HNAA2021050400192Floor Support · corrodedRH OUTBD FLOOR SILL #1 IS PITTED .... RAR RH OUTBD FLOOR SILL #1 IAW EMB 145 SRM 51-40-02 AND EMB 145 SRM 51-20-03SDR HNAA2021050400190Floor Support · corrodedRH OUTBD FLOOR SILL #3 IS PITTED .... BLENDED DAMAGE FOUND TO BE OUT OF ALLOWABLE LIMITS IAW EMB 145 SRM 53-23-10. REMOVED RH OUTBD FLOOR SILL #3 IAW EMB 145 SRM 51-40-02. DRILLED AND INSTALLED SERVICEABLE RH OUTBD #3 FLOOR SILL IAW EMB 145 SRM 51-20-03 AND 51SDR HNAA2021050400189Floor Support · corrodedLH OUTBD FLOOR SILL #3 IS PITTED .... BLENDED DAMAGE ON L/H #3 OUTBOARD FLOOR SILL AND FURTHER INVESTIGATION FOUND TO OUT OF LIMITS. IAW EMB145 SRM 53-22-10AD.REMOVED AND REPLACED LH OUTBD FLOOR SILL #3 IAW EMB145 SRM 51-40-02 AND SRM 51-20-01.SDR HNAA2021050400182Floor Support · corrodedLAV LH FLOOR SILL CORRODED AT LAV AFT BULKHEAD .... REMOVED AND REPLACED LAV LH FLOOR SILL AT LAV AFT BULKHEAD IAW EMB145 SRM 51-40-02SDR SWIA202157729Intercostal · crackedFRAME 621.00 INTERCOSTAL CONNECTING TO Z-MEMBER AT STR 14R CRACKED. (CRJ-200 SRM 53-61-17 ITEM #50) (FILED CLOSED) REMOVED AND REPLACED FRAME 621.00 INTERCOSTAL CONNECTING TO Z-MEMBER AT STR 14R IN REF TO SRM 51-42-06. COMPLIED WITH TASK CARD 51-900-1
Back to JASC 5320