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 REXA2021041600265Floor Support · corrodedAFT BAGGAGE BAY DOOR FLOOR SILL HAS CORROSION CO# 10134221 JOB 81013425 OP 80. - FOUND CORROSION TO BE OUT OF LIMITS PER REO 670-53-61-913 REV A PERFORM REPAIR OF AFT BAGGAGE DOOR FLOOR SILL IAW ENDEAVOR EA CRJ 753-11465 REV IR DATED 4-6-21. PERFORMED REPAIR OSDR DALA2021042102323Door Sill · fodSHIP 5642 ESCAPE SLIDE GIRT BAR ENGAGEMENT LIGHTS 3L DOOR SLIDE LIGHT INOP. CORRECTIVE ACTION: REMOVED DEBRIS FROM DOOR SILL. OPS NML. (1783444)SDR AALA202104219009Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT GALLEY AREA CENTER FITTING LOCATED BETWEEN FR66 AND FR68 AT S23L. L=8.265 INCHES, W=0.675 INCHES, D=0.015 INCHES. REPLACED CENTER FITTING PER SRM 51-42-11-801, 51-72-11-911-001 AND DWG D53480505.SDR DALA2021041902282Intercostal · corrodedDURING INSPECTION MAINTENANCE FOUND CORROSION LEVEL 2 ON INTERCOSTAL AT STA 1562-1582 AT STR 38R APROX WL 140. REPLACED INTERCOSTAL. (LP 1783475)SDR N6WA2021041602Intercostal · corrodedINTERCOSTAL AT FRAME 333-348 STGR 20R HAS CORROSION. R&R INTERCOSTAL AT FRAME 333-348 STGR 20R HAS CORROSION IAW CRJ 550 SRM 51-42-00SDR N6WA2021041601Intercostal · corrodedINTERCOSTAL AT FRAME 310-318 STGR 20R HAS CORROSION. R&R INTERCOSTAL AT FRAME 310-318 STGR 20R HAS CORROSION IAW CRJ 550 SRM 51-42-00SDR QMLA2021041520031Intercostal · chafedDAMAGE WAS REPORTED ON THE RWL1505 INTERCOSTAL (PN: B533K5396-204) IN THE FORM OF CHAFES. THE CHAFES WERE MEASURED TO BE APPROXIMATELY 0.007” AND 0.010” DEEP. THIS DAMAGE HAS BEEN REPAIRED AND DOCUMENTED ON FAA FORM 337 DATED 06/05/2021.SDR SWIA202158699Support · corroded* FS 939.0 LOCATION LOWER FAIRING SUPPORT STRUCTURE HAS ANGLE WITH CORROSION. AT STR 27 EXTERNAL FUSELAGE. (C-CHECK RO 6/04/2021) REMOVED AND REPLACED LOWER FAIRING SUPPORT ANGLE AT F.S 939 AT STGR 27 REF CRJ 700 SRM 51-42-06-001-001-A01SDR SWAA2021050764257Baffle · crackedBAFFLE UNDER TRANSITION ANGLE ON R/H SIDE; STA 500C-500D IS CRACKED ON FWD END. MARKED / REMOVED AND REPLACED BAFFLE UNDER TRANSISTION ANGLE ON R/H STA 500C-500D PER SRM 51-40-02SEE SA-M 326: A1302938SDR SIMA20210415008Floor Support · crackedSSI CENTER OMEGA BEAM OUTBD SUPPORT ANGLE IS CRACKED JUST AFT OF FRAME 46 -C/A-REPAIRED CENTER OMEGA BEAM OUTBD SUPPORT ANGLE JUST AFT OF FR46 IAW SRM 53-23-02-RE AND SRM 51-40-02.SDR SIMA20210415005Channel · crackedR/H HAT BEAM SUPPORT IS CRACKED BETWEEN FRAMES 47 AND 48. -C/A-REPAIRED RH HAT BEAM SUPPORT IAW SRM 53-23-02. AND SRM 51-40-02.SDR SIMA20210415006Support · corrodedCPCP SSI R/H FLOOR/WALL SUPPORT IS CORRODED FROM FRAMES 50-57.-C/A-RAR RH FLOOR/WALL SUPPORT FROM FRAMES 50-57 IAW EMB 145 SRM 51-40-02.SDR CALA2021041600477Door Sill · out of limitsFR68 L2 DOOR SILL FLANGE FOUND TO BE OUT OF LIMITS ON NR 9292441 AND WILL REQUIRE TO BE REPAIRED AREA A PER NR 9292635 / 38635 REPAIRED FR68 L2 DOOR SILL FLANGE IAW SRM 53-41-14-300-001 FIG 0 01 PRINCIPAL 7 SHEET 4 .SDR SWIA202159052Intercostal · corrodedMAIN AVIONICS BAY STR 20R INTERCOSTAL FROM FS349.00 TO FS364.00 CORRODED (C-CHECK RO 6/22/2021) CORROSION FOUND ON INTERCOSTAL TO BE OUT OF LIMITS REF. CRJ-900 SRM, 53-22-55-101-001-A02. REMOVED MAIN AVIONICS BAY INTERCOSTAL BETWEEN FS349.00-FS364.00 STSDR SWIA202159051Intercostal · corrodedMAIN AVIONICS BAY STR 20R INTERCOSTAL FROM FS319.70 TO FS349.00 CORRODED (C-CHECK RO 6/22/2021) REMOVED AND REPLACED INTERCOSTAL AT STGR 20R BETWEEN FS319.70 AND FS349.00 REF. CRJ900 SRM 51-42-06-001-001-A01 AND DWG # SH670-31950 REV. Y SHEET 9 / COMPLISDR SWIA2021062859050Intercostal · corrodedMAIN AVIONICS BAY STR 20R INTERCOSTAL FROM FS310.00 TO FS319.70 CORRODED (C-CHECK RO 6/22/2021) CORROSION ON MAIN AVIONICS BAY STR 20R INTERCOSTAL FROM FS310.00 TO FS319.00 IS OUT OF LIMITS. REMOVED AND REPLACED INTERCOSTAL. REF: CRJ900 SRM 53-21-23-101SDR SWIA2021062859049Intercostal · corrodedMAIN AVIONICS BAY RH LATCH-PIN INTERCOSTAL FROM FS349.00 TO FS364.00 CORRODED (C-CHECK RO 6/22/2021) REMOVED AND REPLACED CORRODED RH LATCH PIN INTERCOSTAL FROM FS349-FS364. REF CRJ900 SRM 51-42-06-001-001-A01, REF CRJ900 SRM 51-42-21-001-001-A01 AND DWSDR SWIA2021062859048Intercostal · corrodedMAIN AVIONICS BAY LH LATCH-PIN INTERCOSTAL FROM FS349.00 TO FS364.00 CORRODED (C-CHECK RO 6/22/2021) REMOVED AND REPLACED CORRODED AVI BAY LH LATCH-PIN INTERCOSTAL FROM FS349 - FS364. REF CRJ900 SRM51-42-06-001-001-A01, REF CRJ900 SRM 51-42-21-001-001-ASDR SWIA2021062258855Intercostal · crackedRH INTERCOSTAL BETWEEN 621 AND 625 FRAMES APPROX STRG 14R IS CRACKED. (C-CHECK - RO 6/19/21) / REMOVED CRACKED INTERCOSTAL/CLIP AT STRINGER 14R AND FS 621-625 AND INSTALLED A NEW INTERCOSTAL/CLIP REF CRJ 200 SRM 51-42-06 AND DRAWING 601-35012 REVD, COMPLISDR SWAA2021051871797Skate Angle · chafedRT SKATE ANGLE HAS NUMEROUS AREAS OF CHAFING. / R/R'D RT SKATE ANGLE REF SRM 51-40-02. SEE INDIVIDUAL SIGN OFFS.SDR SWAA2021051871796Skate Angle · chafedLT SKATE ANGLE HAS NUMEROUS AREAS OF CHAFING. / R/R'D LT SKATE ANGLE REF SRM 51-40-02. SEE INDIVIDUAL SIGN OFFS.SDR SWAA2021050764036Support Strap · corrodedCORROSION ON AFT CARGO FLOOR SUPPORT STRAP AT B.S. 887+4 / REPLACED STRAP PER SRM 51-10-2PN OFF/ON 146A9401U39SDR SWAA2021050764035Support Strap · corrodedCORROSION ON AFT CARGO FLOOR SUPPORT STRAP AT B.S. 767+4 / REPLACED STRAP PER SRM 51-10-02P/N OFF 146A9401-4 P/N ON 146A9401-4SDR SWAA2021050764034Support Strap · corrodedCORROSION ON AFT CARGO FLOOR SUPPORT STRAP AT B.S. 727I+4 / REPLACED STRAP PER SRM 51-10-02P/N OFF 146A9401-8 P/N ON 146A9401-8SDR SWAA2021050764033Support Strap · corrodedCORROSION ON AFT CARGO FLOOR SUPPORT STRAP AT B.S. 727D+4 / REPLACED STRAP PER SRM 51-10-02P/N OFF 146A940118 P/N ON 146A9401-18SDR SWAA2021050764032Angle · corrodedCORROSION ON L/H TRANSITION ANGLE IN AFT CARGO COMPARTMENT AT B.S. 807+13 (MARKED) / REMOVED & REPLACED TRANSISITON ANGLE REPAIR SECTION PER SRM 53-00-53-2R-5SEE SA-M : 326: A1184694SDR SWAA2021050764028Angle · corrodedCORROSION ON R/H TRANSITION ANGLE IN AFT CARGO COMPARTMENT AT B.S. 747 THRU 767 MULTIPLE LOCATIONS (MARKED) / REMOVED AND REPLACED SECTION TRANSITION ANGLE FROM STATION 727 AT +10 TO 767 FIND REPAIRED SPLICED PER SRM . 51-10-02 AND 53-00-53-2R-5 REF SRM 53-60-SDR SWAA2021050764018Web · corrodedCORROSION ON AFT CARGO DOOR THRESHOLD WEB / R&R AFT CARGO DOOR THRESHOLD WEB PER SRM 51-10-02;51-40-02 P/N 146A8123-25SEE SA-M : A1184697SDR AALA202105049019Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED INTERCOSTAL AT STA 320 LBL 46. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR IPXA2021042868740Intercostal · crackedINSPECTION TYPE:SEGMDCC BETWEEN FR 76 & FR 77 RH SIDEWALL FLOOR LEVEL INTERCOSTAL WEB HAS A CRACK AT AFT CORNER.REPLACED DAMAGED WEB WITH REPLACEMENTWEB USING 2024-T3.063C BATCH NUMBER IAW A300 SRM 51-40-21.SDR SWIA202157921Support · corrodedCORROSION ON FWD WET AREA R/H FWD SILL BETWEEN FR13 AND FR14 IN 2 LOCATIONS AS MARKED. (C-CHECK RO 4/27/2021) REMOVED AND REPLACED SILL AT FWD WET AREA R/H FWD SILL BETWEEN FR13 AND FR14 REF EMB SRM 51-40-08SDR AALA202104219019Angle · out of toleranceAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN FLOOR, STA 887 LBL 24.75, SEAT TRACK CARRY THRU ANGLE HAS ELONGATED/OVERSIZE HOLES. REMOVED AND REPLACED CARRY THRU ANGLE IAW BAC DWG # 147A5300 REV A AND B737NG SRM 51-40-02.SDR AALA202104219018Angle · out of toleranceAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN FLOOR STA 887 AND RBL 45.5 SEAT TRACK CARRY THRU ANGLE HAS OVERSIZED/ELONGATED HOLES. REMOVED AND REPLACED SEAT TRACK CARRY THRU ANGLE IAW BAC DWG 147A5300 REV A AND B737NG SRM 51-40-02.SDR DALA2021041602219Gusset · corrodedDURING INSPECITON MAINTENANCE FOUND CORROSION LEVEL 2 ON GUSSET AT 1577 AT RBL 3 APROX WL 140. GUSSET REPLACED. (LP 1781886)SDR DALA2021041602218Stiffener · corrodedDURING INSPECITON MAINTENANCE FOUND CORROSION LEVEL 2 ON STIFFINER AT STA 1568-1577 AY RBL 3 APROX WL 140. REPLACED STIFFINER. (LP 1781883)SDR DALA2021041602217Gusset · corrodedDURING INSPECTION MAINTENANCE FOUND CORROSION LEVEL 2 ON GUSSET AT STA 1568 RBL 3 APROX. WL 140. GUSSET REPLACED. (LP 1781868)SDR FDEA202104140916Support Angle · crackedLEFT HAND FUSELAGE INTERIOR - UPON REMOVAL OF BLADDER CELL FOUND CENTER WING LOWER BARREL STRUCTURE SUPPORT ANGLE AT APPROXIMATE STATION 1236.8 CRACKED. LEFT HAND FUSELAGE INTERIOR BLADDER CELL CENTER WING LOWER BARREL STRUCTURE STATION 1236.8 SUPPORT ANGLSDR SWIA2021090360716Floor Support · corrodedLH FLOOR SILL HAS MULTIPLE SPOTS OF CORROSION FROM FS985.00 TO FS1000.00 (C-CHECK RO 8/31/21) REMOVED AND REPLACED SILL IAW REO 670-53-61-1900 REV -- DATED 2021-05-20, REFER TO CONTINUE CARD FOR DETAILS OF WORK PERFORMED.SDR SWIA202160653Fitting · corrodedFORWARD JACK FITTING INTERCOSTALS R/H AND L/H ARE CORRODED FROM FS 265 TO FS 280. (C-CHECK RO 8/31/21) INSTALLED JACK FITTING AND NEW INTERCOSTALS PN: CC670-32179-1 AND CC670-32179-2 IAW CRJ 700 SRM 51-42-21-001-001-A01 AND CRJ 700 SRM 51-42-06-001-001-SDR SWIA202160652Floor Support · corrodedFLOOR BEAM AT LBL27 HAS MULTIPLE SPOTS OF CORROSION FROM FS1000.00 TO FS1088.20 (C-CHECK RO 8/31/21) REMOVED AND REPLACED FLOOR BEAM FROM FS 977 TO FS1057 AND OUTBOARD SPLICE ANGLES IAW CRJ-700 SRM 53-00-41-201-001-A01. M-337 AND MAJOR REPAIR TASK CARD 51-SDR SWIA202160650Floor Support · corrodedFLOOR BEAM AT LBL9 HAS MULTIPLE SPOTS OF CORROSION FROM FS985.00 TO FS1088.20 (C-CHECK RO 8/31/21) FLOOR BEAM AT LBL9 FROM FS985.00 TO FS1088.20 WAS REPAIRED IAW CRJ700 SRM 53-00-41-201-001-A01.COMPLETED AND ATTACHED FORM 337 AND MAJOR REPAIR TASKCARD 51-SDR SWIA2021090360649Door Sill · corrodedAFT CARGO DOOR SILL ANGLE HAS MULTIPLE SPOTS OF CORROSION FROM FS1000.00 TO FS1047.00 (C-CHECK RO 8/31/21) REMOVED CORRODED AFT CARGO DOOR SILL ANGLE IAW CRJ-700 SRM 51-42-06-001-001-A01 AND 51-42-21-001-001-A01 AND INSTALLED SERVICABLE AFT CARGO DOOR SILSDR SWIA202160648Floor Support · corrodedRH FLOOR SILL HAS MULTIPLE SPOTS OF CORROSION FROM FS985.00 TO FS1088.20 (C-CHECK RO 8/31/21) REMOVED AND REPLACED RH FLOOR SILL (SIDE BEAM) FROM FS985.00 TO FS1088.20 IAW MHI REO 670-53-61-1913 REV. --, DATED 6/1/21. FORM 337 AND MAJOR REPAIR TASK CARD 5SDR SWIA202160647Intercostal · corrodedL/H INTERCOSTAL FROM FS 349 TO FS 364 IS CORRODED (C-CHECK RO 8/31/21) REMOVED AND INSTALLED L/H INTERCOSTAL FROM FS 349 TO FS 364 IAW CRJ-700 SRM 51-42-21-001-001-A01, 51-42-06-001-001-A01, 51-25-16-001-001-A01 AND 51-40-11-001-001-A01 REV 38B-14DEC2020, SDR SWIA202158188Angle · crackedFS 280 RBL 9, INBOARD VERTICAL ANGLE APPEARS CRACKED AT TOP END. (C-CHECK RO 5/16/2021) REMOVED AND REPLACED VERTICAL ANGLE UNDER FLOOR LEVEL AT FS.280 RBL.9 (INBD) REF REO 601R-53-11-171 REV.-D DATED 13 FEB 07 AND CRJ 200 SRM 51-42-21 AND COMPLIED WITHSDR SWIA202158187Angle · crackedFS 280 LBL 9, INBOARD VERTICAL ANGLE APPEARS CRACKED AT TOP END. (C-CHECK RO 5/16/2021) REMOVED AND REPLACED VERTICAL ANGLE UNDER FLOOR LEVEL AT FS.280 LBL.9 (INBD) REF REO 601R-53-11-171 REV.-D DATED 13 FEB 07 AND CRJ 200 SRM 51-42-21 COMPLIED WITH 51-SDR SWAA2021050763743Angle · corrodedRH TRANSITION ANGLE HAS MINOR SURFACE CORROSION / REMOVED AND REPLACED SECTION OF R/H TRANSITION ANGLE FROM BS 500A-BS500E+9 PER SRM 53-00-53-2R-5 AND EA 21-153-01041SA-M 326 A1184674INSP D08SDR AALA202105049021Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON TRANSITION PANEL LOCATED BETWEEN STA 767 AND 787 AT RBL 24. REPLACED TRANSITION PANEL SRM 51-10-02-0G.SDR AALA202105049020Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORRSION ON TRANSITION PANEL LOCATED BETWEEN STA 500B AND 500I AT LBL 24. REPLACED PANEL PER SRM 51-40-02.SDR REXA2021042700279Intercostal · corrodedINTERCOSTAL AT STRINGER 20R BETWEEN FS 349 TO FS 364 IS CORRODED. REMOVED AND REPLACED INTERCOSTAL AT STR 20R FS 349 TO FS 364 IAW CRJ 900 SRM 51-40-11-001-001-A01 & 51-42-06-001-001-A01.
Back to JASC 5320