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 SWAA2021111532684Track · crackedCRACK TRACK RBBL 13.84 STA 767 AT AFT CARGO COMPARTMENT ; 2021-490340 / [01] TOOL EDDY CURRENT USED P/N: NORTEC 600D S/N: 190023010 AND DUE DATE: 01-DEC-21.; [02] MACHINED CARGO TRACK SECTION ( 1 E/ A ) LOCATED RBBL 13.84 STA 767 AT AFT CARGO COMPARTMENT MATERSDR SWAA2021111532688Support · corrodedCORROSION SUPPORT ZEE LOCATED BTW STA 727 TO STA 847 AT LEVEL STR 25L AND WL 155.5 AT AFT CARGO COMPARTMENT ; 2021-490343 / [01] REPAIRED SUPPORT ZEE LOCATED BTW STA 727 TO STA 847 AT LEVEL STR 25L AND WL 155.5 AT AFT CARGO COMPARTMENT IAW B737-700 SRM 51-40-0SDR SWAA2021111532687Support · corrodedCORROSION SUPPORT ZEE LOCATED BTW STA 727 TO STA 767 AT LEVEL STR 25R AND WL 155.5 AT AFT CARGO COMPARTMENT ; 2021-490344 / [01] REPLACED SUPPORT ZEE LOCATED BTW BS STA 727 TO BS STA 767 AT LEVEL STR 25R AND WL 155.5 AT AFT CARGO COMPARTMENT IAW B737-700 SRM 5SDR SWAA2021111532685None · corrodedCORROSION WEB - INTERCOSTAL LOCATED BTW STA 767 TO STA 792 STR 25R AND WL 155.5 AT AFT CARGO COMPARTMENT ; 2021-490342 / [01] REPLACED WEB - INTERCOSTAL LOCATED BTW STA 767 TO STA 792 STR 25R AND WL 155.5 AT AFT CARGO COMPARTMENT I.A.W B737-700 SRM 51-10-02 ITSDR SWAA2021111532686None · corrodedCORROSION WEB - INTERCOSTAL LOCATED BTW STA 847 TO STA 867 STR 25R AND WL 155.5 AT AFT CARGO COMPARTMENT ; 2021-490341 / [01] REPLACED WEB - INTERCOSTAL LOCATED BTW STA 847 TO STA 867 STR 25R AND WL 155.5 AT AFT CARGO I.A.W B737-700 SRM 51-10-02 ITEM 9 AND SRMSDR AALA202111082457Shear Tie · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON SHEAR TIE CLIP AT FR 65 AND S31R. REPLACED SHEAR TIE CLIP PER SRM 51-72-11.SDR SWAA2021102632683Strap · corrodedCORROSION STRAP LOCATED STA 767 BTW STR 25L TO STR 25R AND WL 155.5 AT AFT CARGO COMPARTMENT. REPLACED STRAP LOCATED STA 767 BTW STR 25L TO STR 25R AND WL 155.5 AT AFT CARGO COMPARTMENT IAW B737-700 SRM 51-10-02 TEM 9 AND DWG 146A7500 REV- .SDR FDEA202110222594None · crackedRIGHT WHEEL WELL SEAL RETAINER CHANNEL 149N7550-58 CLIP DAMAGED REMOVED AND REPLACED 149N7550-58 CLIP PER BAC DWG #149N7550 REV HSDR SWAA2021112332535Beam · elongatedELONGATED HOLE FLOOR STRUCTURE BEAM LOCATED BS986 AND BETWEEN RBL18 TO RBL39 AT AFT GALLEY AREA (2 EA) ; 2021-486671 / [01] REPLACED THE DAMAGE PART (TEE CHORD) TO RESTORE THE AIRCRAFT TO ITS APPROVED CONFIGURATION DEFINED IN EA 1-753-35993 REV IR. SEE INDIVIDSDR SWAA2021112332330Web · crackedCRACK WEB LOCATED BS 277-294.5, BL 0, FWD GALLEY AREA. REPLACED WEB IAW SRM 51-10-02, PARAGRAPH 9, SRM 51-40-02, & DWG 141A5400, SHEET 20, REV: -.SDR SWAA2021112332530None · crackedCRACK ANGLE - CLIP LOCATED BS500C AND RBL 21.0 AT FWD CARGO COMPARTMENT ; 2021-486659 / [01] TOOL USED ELECTRONIC CALIPER 0-6? PN 500-196-30 SN A20231699 DUE DATE 06SEP2S; [02] REPLACED NEW ANGLE-CLIP AND FASTENERS BS 500C; RBL21 AT FWD CARGO COMPARTMENT IAW BSDR SWAA2021112332531None · crackedCRACK ANGLE-CLIP BS 500B;LBL21 AT FWD CARGO COMPARTMENT ; 2021-486658 / [01] REPLACED NEW ANGLE-CLIP AND FASTENERS BS 500B;LBL21 AT FWD CARGO COMPARTMENT IAW B737-700 SRM 51-40-02; 51-10-02 Ï¿½TEM 9 DWG 143A7505 SHEET 5 REV B.; [02] REPLACED NEW ANGLE-CLIP ANDSDR SWAA2021112332534None · corrodedCORROSION WEB - INTERCOSTAL LOCATED BTW BSTA 500C AND BSTA 500D AT LEVEL STR 25L WL 156 LBL 21.84 AT FWD CARGO COMPARTMENT ; 2021-486669 / [01] TOOL USED: DIGITAL CALIPER P/N: DIGITAL150; S/N: AE-412610; DUE DATE: 21MAY22; [02] REPLACED WEB - INTERCOSTAL LOCATSDR SWAA2021112332536None · crackedCRACK WEB - INTERCOSTAL LOCATED BSTA 500B TO BSTA 500C AT LEVEL STR 25R WL 156 RBL 21.84 AT FWD CARGO COMPARTMENT ; 2021-486670 / [01] REPLACED WEB INTERCOSTAL LOCATED BSTA 500B TO BSTA 500C AT LEVEL STR 25R WL 156 RBL 21.84 AT FWD CARGO COMPARTMENT IN IAW B73SDR SWAA2021111932263None · corrodedLEFT TRANSITION ANGLE ANGLE HAS SURFACE CORROSION AROUND FASTNER HOLES FROM STA 500D TO 500E. / REPAIRED DAMAGED SECTION OF TRANSITION ANGLE PER SRM 53-00-53-2R-5 AND EA 21-153-03188. (D54)SA-M# A1184771SDR SWAA2021111932264Web · corrodedFWD CARGO DOOR SCUFF PLATE HAS SURFACE CURROSION FROM STA 440 TO STA 490 RBL 24-RBL 29 / REMOVED AND REPLACED DAMAGED WEB PER SRM 51-40-02SA-M 326 A1184757SDR SWAA2021111932269Intercostal · corrodedINTERCOSTAL AT STA 947; LBL 25 CORRODED (MARKED) / REMOVED AND REPLACED UPPER ANGLE (P/N 147A5430-7) OF INTERCOSTAL FROM STA. 927 TO STA. 947; LB 25 PER SRM 51-40--02. SA-M #A1184760 (D08)SDR SWAA2021111932271None · corrodedAFT GALLEY DOOR Z-ANGEL CORRODED / REMOVED & REPLACED AFT GALLEY DOOR Z ANGLE IAW SRM 51-40-02 (S/N A1184761)SDR SWAA2021111932274Angle · corrodedAFT CARGO COMPARTMENT RIGHT TRANSITION ANGLE HAS SIGNIFICANT AREAS OF CORROSION FROM STA 727 TO STA 767 RBL 22. / REMOVED AND REPLACED R/H TRANSITION ANGLE FROM STA. 727E+10 TO 767 PER SRM. 53-00-53-2A-5; 51-40-02(SA-M 326 ATTACHED: A1184782)SDR SWAA2021111932272Intercostal · corrodedINTERSTAT COMMON TO AFT GALLEY DOOR; FWD TROUGH DRAIN HAS LIGHT CORR / REMOVED AND REPLACED DAMAGED INTERCOSTAL PER SRM 51-40-02. P/N 147A5660422SA-M 326 ATTACHED: A1184762SDR SWAA2021111932254Angle · corrodedAFT CARGO COMP. LEFT TRANSITION ANGLE HAS SIGNIFICANT AREAS OF CORROSION FROM STA 727 THRU 727I LBL 22 / REMOVED AND REPLACED L/H TRANSITION ANGLE FROM. STA. 727C+10 - TO 727I+10 PER SRM. 53-00-53-2A-5; 51-40-02(SA-M 326 ATTACHED: A1184767)SDR REXA2021111700996Stringer · corrodedSTRINGER 20R CORRODED BETWEEN FS 295 TO FS 310. - REMOVED UNSERVICEABLE STRINGER 20R, DRILLED, LOCATED & INSTALLED NEW SERVICEABLE STRINGER IAW CRJ 900 SRM'S 51-42-06-001-001-A01, 51-42-21-001-001-A01, & 51-40-11-001-001-A01. WVAC EMP STAMP #774 MTCSDR REXA2021111700994Fitting · corrodedGALLEY SERVICE DOOR SILL PROTECTOR FITTINGS (4 EACH) CORRODED REMOVED UNDER OP #145, 146. - LOCATED & DRILLED 4EACH SILL PROTECTOR FITTINGS IAW CRJ 900 SRM 51-SRM'S 51-40-11-001-001-A01 & 51-42-21-001-001-A01. WVAC EMP STAMP #774 MTCSDR REXA2021111600954Angle · corrodedPAX DOOR SURROUND STRUCTURE, LOWER SILL ANGLE CORRODED BETWEEN FS 310 AND FS 349. - LOWER SILL ANGLE IDENTIFIED AS PART #SH670-31875-7. FOUND PART CORRODED BEYOND REPAIR AND REQUIRES REPLACEMENT IAW CRJ 900 SRM 51-77-00-001-001-A01. REMOVED AND REPLACED LOWER SDR REXA2021111600953Stringer · corrodedSTRINGER AT STGR 25L CORRODED FROM FS 319 TO FS 349. - REPAIRED IAW ENDEAVOR EA CRJ 953-12200 REV IR DATED 10/19/2021.SDR REXA2021111600951Frame · corrodedFRAME AT FS 295 CORRODED BETWEEN STGR 25L AND STGR 25R. - REPAIRED FRAME AT FS 295 IAW CRJ 900 SRM'S 53-00-06-201-006-A01 & 51-40-11-001-001-A01.SDR REXA2021111600946Fitting · corrodedGALLEY SERVICE DOOR BOTTOM SEAL STRIKER HAS CORROSION AROUND SCREW HOLES. - REMOVED & REPLACED STRIKER SEAL IAW CRJ SRM 51-40-11-001-001-A01, 51-42-21-001-001-A01, 51-42-06-001-001-A01 AND 53-21-23-001-002-A01.SDR AALA202111162182Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN AFT GALLEY AREA SHEAR PLATE LOCATED BETWEEN FR 69 TO FR70 AT S23R. REPLACED SHEAR PLATE PER 51-42-11-801 AND DRAWING D53474180.SDR SWAA2021111532386Angle · crackedCRACK ANGLE - SUPPORT LOCATED AT BS 500D AT LEVEL S-28R FWD CARGO COMPARTMENT ; 2021-490326 / [01] TOOL USED: POWER PACK P/N PE1068 S/N PE0118-94826 DUE DATE: 23-FEB-22.MULTIMETER P/N FLUKE 179 S/N 97220166 DUE DATE: 06-DEC-21. THERMOMETER P/N FLUKE 566 S/N 36SDR SWAA2021111532384Bracket · crackedCRACK BRACKET LOCATED STA 867 AT LEVEL OF LBL 12.50 FLOOR STRUCTURE AT AFT CARGO COMPARTMENT ; 2021-490318 / [01] TOOL USED: DIGITAL CALIPER P/N: 500-197-30 S/N: A21042060 DUE DATE: 11-AUG-22.; [02] REPLACED BRACKET AND FASTENERS LOCATED STA 867 AT LEVEL OF LBSDR SWAA2021111532385None · crackedCRACK CHANNEL SUPPORT LOCATED ON BULKHEAD STA 727 AND BTW RBL 3.00 AND RBL 8.10 AT AFT CARGO COMPARTMENT ; 2021-490320 / [01] REPLACED CHANNEL SUPPORT (BRACKET) LOCATED ON BULKHEAD STA 727 AND BTW RBL 3.00 AND RBL 8.10 AT AFT CARGO COMPARTMENT I.A.W B737-700 SSDR AALA202111159824Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: AFT CABIN FLOOR SHEAR PLATE CRACKED BETWEEN FR 69 AND FR 70 AT S23L. REPLACED SHEAR PLATE PER SRM 51-42-11.SDR R61A2021111000896Shear Web · corrodedLEVEL 2 CORROSION FOUND ON CFIII SHEAR WEB FR 87-88. SHEAR WEB WAS REPLACED IAW SRM 51-42-01.SDR AALA202111090934Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND AFT PASSENGER / CREW DOOR CUT OUT LOWER SILL CENTER FITTING BETWEEN FR 66 AND FR 68 AT S23L. REPLACED CENTER FITTING PER SRM 51-42-11.SDR REXA2021110400911Longeron · corroded"FWD BAGGAGE BAY DOOR SURROUND STRUCTURE, LOWER LONGERON HAS
DRILL HOLES IN SILL PLATE BTW FS517 AND FS533.
" "COMPLIED WITH ENDEAVOR EA# CRJ953-12093 REV IR DATED 9/15/2021 FOR
REPAIR. REMOVED AND REINSTALLED FWD BAGGAGE BAY DOOR BALANCE SPSDR SWAA2021110232346Scuff Plate · crackedAFT CARGO BAY AFT CORNER SCUFF PLATE CRACKED ; / [01] WELDED CRACK ON RADIUS OF ACB; AFT CORNER SCUFF PLATE USING ER4043 FILLER ROD LOT # 1131216 PER SRM 53-60-15-2R-1 PARA 4.B. (2) AND (4).<BR>WELDING MACHINE CAL I.D. E10583; S/N; KJ256554 12/2021; [02] VERIFSDR YENA2021102100711Web · corrodedDURING HEAVY MAINTENANCE, FROM AEROMAN NR 2021-428652 CORROSION WEB LOCATED BTW FR 69 TO FR 70 STRG 23R AT AFT GALLEY AREA ( CPCP RELATED 534195-01)SDR REXA2021111600948Seat Track · corrodedSEAT TRACK HAS MULTIPLE AREAS OF CORROSION AT RBL 9 FS 849.00+49 TO FS 977.00. - FOUND SEAT TRACK AT RBL 9 FS 849.00+49-FS 977.00 TO BE OUT OF REPAIRABLE LIMITS IAW CRJ 900 SRM 53-31-49-001-001-A02. REMOVED SEAT TRACK AT RBL 9 FS 849.00+49-FS 977 IAW CRJ 900 ASDR SWAA2021111531709Scuff Plate · crackedCRACK AFT CORNER SCUFF PLATE AT FWD CARGO COMPARTMENT ; 2021-490260 / [01] TOOL USED; DIGITAL CALIPER P/N:500-197-30 S/N: B20189531 DUE DATE: 22/NOV/21.; [02] REPAIRED AFT CORNER SCUFF PLATE OF FWD CARGO COMPARTMENT IAW BOEING 737-700 SRM 53-30-15-2R-1;REPAIR SDR SWAA2021111532051Support · crackedCRACK SUPPORT ZEE LOCATED BETWEEN BS500A TO BS500D AND STR26R AT FWD CARGO COMPARTMENT ; 2021-490273 / [01] TOOL USED: DIGITAL CALIPER P/N:500-197-30 S/N:A21043164 DUE DATE:01-SEP-22.; [02] REPLACED SUPPORT ZEE LOCATED BETWEEN BS500A TO BS500D AND STR 26R AT FSDR SWAA2021111532049Angle · crackedCRACK ANGLE - CLIP LOCATED BS500C FWD FACE AND STR26L FWD CARGO COMPARTMENT ; 2021-490267 / [01] REPLACED ANGLE-CLIP LOCATED BS500C FWD FACE AND STR26L FWD CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 AND DWG 143A7505 SHEET 82 REV -. SEE INDIVIDUAL SIGN OFF BELSDR SWAA2021111532038Angle · crackedCRACK ANGLE - CLIP LOCATED BS400 AFT FACE AND STR26L FWD CARGO COMPARTMENT ; 2021-490271 / [01] TOOL USED: DIGITAL CALIPER P/N:500-172-30 S/N:15237811 DUE DATE: 11-MAY-22.; [02] REPLACED ANGLE - CLIP AND FASTENERS LOCATED BS400 AFT FACE AND STR26L FWD CARGO COSDR AALA202111080476Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION, MEASURING L=2.5 IN, W=1.00 IN, D=0.01 IN, ON AFT CARGO AREA LEFT HAND TRANSITION PANEL LOCATED BETWEEN BS 767 AND BS 787 AT S25L. REPLACED PANEL PER SRM 53-00-53-2R-5. (SUPPLEMENTAL REPORT FOR AALA202111050476 TO ADD "ASDR AALA202111056332Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION MEASURING L=1.375 IN, W=0.75 IN, D=0.006 IN, ON FORWARD CARGO AREA LEFT HAND TRANSITION PANEL LOCATED BETWEEN BS 460 AND BS 500-F AT S25L. REPLACED PANEL PER SRM 53-00-53-2R-5.SDR AALA202111050476Transition Panel · corrodedCORROSION, MEASURING L=2.5 IN, W=1.00 IN, D=0.01 IN, ON AFT CARGO AREA LEFT HAND TRANSITION PANEL LOCATED BETWEEN BS 767 AND BS 787 AT S25L. REPLACED PANEL PER SRM 53-00-53-2R-5.SDR REXA2021110400908Intercostal · corroded"STRINGER AND INTERCOSTAL CORRODED AT STGR 20R BETWEEN FS 295 AND FS
349.
" "LOCATED, DRILLED AND INSTALLED NEW SERVICEABLE INTERCOSTALS AT STG 20R
IAW CRJ 900 SRM 51-40-11-001-001-A01, 51-42-06SDR REXA2021110400907Intercostal · corroded"STRINGER AND INTERCOSTAL CORRODED AT STGR 20R BETWEEN FS 295 AND FS
349.
" "LOCATED, DRILLED AND INSTALLED NEW SERVICEABLE INTERCOSTALS AT STG 20R
IAW CRJ 900 SRM 51-40-11-001-001-A01, 51-42-06SDR REXA2021110400906Stringer · corroded"STRINGER AND INTERCOSTAL CORRODED AT STGR 20R BETWEEN FS 295 AND FS
349.
" "LOCATED, DRILLED AND INSTALLED NEW SERVICEABLE INTERCOSTALS AT STG 20R
IAW CRJ 900 SRM 51-40-11-001-001-A01, 51-42-06SDR AALA202110213700Fitting · wornAIRCRAFT IN BASE MAINTENANCE: AFT CARGO DOOR CUTOUT LOWER GUIDE FITTING INNER FLANGE WORN ON THE AFT FRAME AT BS 1754.5. REPLACED GUIDE FITTING AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-35-00-820-801.SDR REXA2021120701074Seat Track · corrodedRBL 9 SEAT TRACK FROM APPROX FS 847+54 TO FS 977 HAS AREAS OF MINOR CORROSION. C/A: REMOVED, FABRICATED AND INSTALLED NEW SEAT TRACK IAW CRJ 900 SRM 53-00-49-201-002-A01 AND AMM 53-00-49-400-801-A07.
Back to JASC 5320