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 REXA2022051200875Crossbeam · crackedR/H CROSSBEAM @ FS280 RBL 13.50 IS CRACKED REMOVED & REPLACED R/H CROSSBEAM @ FS 280 RBL 13.50 IAW CRJ 900 SRM 51-40-11-001-001-A01, 51-42-06-001-001-A01, 51-42-21-001-001-A01 & 51-42-22-001-001-A01.SDR REXA2022051200873Stringer · corrodedSTRINGER 25R BETWEEN FS 295 AND FS 310 IS CORRODED REMOVED, FABRICATED & REPLACED STRINGER IAW ENDEAVOR AIR EA CRJ953-13264 & CRJ 900 SRM 51-42-06-001-001-A01 & 51-42-21-001-001-A01.SDR SWAA2022050200204Guard · crackedLEFT OVERWING DOOR GUARD ASSY CRACKED / [01] C/W 22-153-01272SDR IXXA20220427002Panel · corrodedALC PANEL SUPPORT ON BILGE PANEL RBL16 AT STATION 1281 CORRODEDSDR IXXA2022042700002Tray · corrodedWING LOCK TRAY WEB CORRODEDSDR REXA2022060901119Seat Track · corrodedL/H SIDE SEAT TRACK IS CORRODED BETWEEN F.S. 565 TO F.S. 677. REMOVED, FBRACATED AND INSTALLED L/H SIDE SEAT TRACK BETWEEN F.S. 565 TO F.S. 677 IAW CRJ 700 SRM 53-00-49-201-002-A01.SDR REXA2022060901118Seat Track · corrodedL/H SIDE SEAT TRACK IS CORRODED BETWEEN FS 485 TO FS 565. REMOVED & REPLACED SEAT RAIL IAW CRJ 700 AMM 53-00-49-000/400-801-A03.SDR REXA2022060901117Seat Track · corrodedR/H SIDE SEAT TRACK IS CORRODED BETWEEN FS 485 TO FS 565. LOCATED AND DRILLED NEW SERVICEABLE SIDE SEAT TRACK FROM EXTRUSION P/N: 20276-280-0-0A IAW CRJ SRM 51-40-11-001-001-A01 AND SRM 53-00-48-201-002-A01SDR REXA2022060901113Seat Track · corrodedR/H SIDE SEAT TRACK IS CORRODED BETWEEN FS 379 TO FS 485. REMOVED & REPLACED SEAT RAIL IAW CRJ 700 AMM 53-00-49-000/400-801-A03.SDR REXA2022060901110Seat Track · corrodedLBL 9 SEAT TRACK IS CORRODED BETWEEN F.S. 985 - F. S.1000. FABRICATED SEAT TRACK SEGMENT AND REPLACED BETWEEN F.S. 985 - F.S. 1000 IAW CRJ 700 SRM 53-00-49-201-002-A01.SDR REXA2022060901109Seat Track · corrodedRBL 9 SEAT TRACK IS CORRODED BETWEEN FS1000 -FS1047. FABRICATED SEAT TRACK SEGMENT AND REPLACED IAW CRJ 700 SRM 51-42-02-001-001-A01, 51-40-11-001-001-A01 AND AMM 53-00-49-400-801.SDR REXA2022060901108Seat Track · corrodedRBL 9 SEAT TRACK IS CORRODED BETWEEN FS985 -FS1000. REMOVED RBL 9 SEAT TRACK. FABRIACTED SEAT TRACK AND INSTALLED A SERVICEABLE SEAT TRACK AT RBL 9 BETWEEN F.S. 985 TO F.S. 1000 IAW CRJ 700 SRM 53-00-49-201-002-A01.SDR REXA2022060901089None · corrodedFLOOR SEAT TRACK AT LBL9 BETWEEN FS 773.00 AND FS 830.00 IS CORRODED. REMOVED, FABRICATED & REPLACED SEAT RAIL IAW CRJ 700 AMM 53-00-49-000/400-801-A03 & SRM 53-00-49-201-002-A01.SDR REXA2022060901083Angle · corrodedFS280 CROSSBEAM J ANGLE IS CORRODED. REMOVED & REPLACED ANGLE IAW CRJ 700 SRM 51-40-11-001-001-A01, 51-42-06-001-001-A01 & 51-42-21-001-001-A01.SDR REXA2022060801082Angle · crackedFS 280.00 CROSSBEAM ANGLE AT RBL 12 IS CRACKED. REMOVED & REPLACED ANGLE IAW CRJ 700 SRM 51-40-11-001-001-A01 & 51-42-21-001-001-A01.SDR REXA2022060701058Channel · wornLH DIAPHRAM CHANNEL ASSY IN WHEEL WELL HAS ELONGATED HOLE. REMOVED & REPLACED CHANNEL IAW CRJ 700 SRM 51-40-11-001-001-A01, 51-42-21-001-001-A01 & 51-41-02-001-001-A01.SDR SWAA2022053197863Cap · elongatedAFT CARGO CAP STRIP PLATE WITH HOLES ELONGATED / [01] RECEIVED NEW AFT CARGO CAP STRIP PLATE P/N A-453A2611-1; NEW PLATE WILL BE INSTALLED IN CUSTOMER BAR CODE TTG8004FJTU.;[02] CORRECTION OF STEP 1 RECEIVED NEW AFT CARGO CAP STRIP PLATE P/N A-453A2611-1; NEW SDR SWAA2022053197862Scuff Plate · crackedAFT CARGO; AFT SCUFF PLATE CORNER CRACK / [01] RECEIVED SERVICEABLE AFT CARGO ; AFT SCUFF PLATE CORNER; WELDED BY JL WELDING; CUSTOMER ORDER 413426; W/O 16248;[02] VERIFIED STEP 1.SDR REXA2022053100928Stringer · corrodedSTGR AT 26L HAS MULTIPLE SPOTS OF CORROSION FROM F.S.985 TO F.S.1098. REPAIRED STRINGER 26L F.S.985 TO F.S.1088.20 IAW ENDEAVOR AIR EA CRJ953-13263 REV -- DATED 4-6-2022.SDR REXA2022053100915Stringer · corrodedF.S.295 TO F.S.310 STGR 19R IS CORRODED. REMOVED CORRODED STRINGER 19R FROM F.S.280 TO F.S.319.70 AND INSTALLED NEW SERVICABLE STRINGER IAW CRJ 900 SRM 51-42-06-001-001-A01 AND 51-42-21-001-001-A01.SDR IPXA2022052482453Floor Panel · damagedINSPECTION TYPE:A300PNL 152NG DAMAGED FABBED PER SREO A300-5320-16407-ESDR IPXA2022052482452Floor Panel · damagedINSPECTION TYPE:A300PNL 151VF DAMAGEDFABBED PER SREO A300-5320-16407-ESDR IPXA2022052582476Floor Panel · damagedINSPECTION TYPE:CPNL 252FK IS DAMAGED FABBED IAW SREO A300-5320-40552-BSDR IPXA2022052582475Floor Panel · crackedINSPECTION TYPE:CPNL 152VF CRACKED FABBED PER SREO A00-5320-16407-ESDR IPXA2022052582474Floor Panel · damagedINSPECTION TYPE:C PNL 132SG DAMAGED FABBED PER SREO A3005320-16407-ESDR IPXA2022052582472Floor Panel · damagedINSPECTION TYPE:CPNL 132PG DAMAGEDFABBED PER SREO A300-5320-16407-ESDR IPXA2022052582471Floor Panel · brokenINSPECTION TYPE:C PNL 131 RG BROKENFABBED PER SREO A300-5320-16407-ESDR IPXA2022052582470Floor Panel · damagedINSPECTION TYPE:CPNL 151KG DAMAGEDFABBED PER SREO A300-5320-16407-ESDR IPXA2022052582468Floor Panel · damagedINSPECTION TYPE:CPNL 152 SF DAMAGEDFABBED PER SERO A300-5320-6407-ESDR IPXA2022052582467Floor Panel · damagedINSPECTION TYPE:CPNL 132MG DAMAGEDFABBED PER SREO A300-5320-16407-ESDR IPXA2022052582466Floor Panel · damagedINSPECTION TYPE:CPNL 13ZRG BROKENFABBED PER SREO A300-532-16407-ESDR IPXA2022052582465Floor Panel · damagedINSPECTION TYPE:C PN 15ZLG DAMAGE FABBED PER SREO A300-5320-16407-ESDR SWAA2022051197820Bracket · crackedAPU FEED CABLE IN CABIN R/H STA 867 STRINGER 3 HANGER BRACKET CRACKED / BROCKEN. / [01] REMOVED AND REPLACED BRACKET PER SRM 51-40-02.;[02] VERIFIED REPAIR.SDR SWAA2022050498030Gusset · crackedFWD CARGO BAY GUSSET CRACKED AT BS 500D S-19L / [01] VERIFIED SRM 51-10-02-OG-0 STEP 9.IS APPLICABLE FOR REPAIR.;[02] PRIOR TO REMOVAL;FOUND PART TO HAVE NO ALLOWABLE DAMAGE LIMITS AND SO PART IS REPAIRABLE BY REPLACEMENT PER SRM 51-10-02.;[03] REMOVED GUSSET SDR SWAA2022050498031Gusset · crackedFWD CARGO BAY GUSSET CRACKED AT BS 500D S-20L / [01] VERIFIED SRM 51-10-02-OG-0 STEP#9;IS APPLICABLE FOR REPAIR.;[02] PRIOR TO REMOVAL;FOUND PART TO HAVE NO ALLOWABLE DAMAGE LIMITS AND SO PAR IS REPAIRABLE BY REPLACEMENT PER SRM 51-10-02.;[03] REMOVED GUSSET CSDR SWAA2022050498032Gusset · crackedFWD CARGO BAY GUSSET CRACKED AT BS 500D S-19R / [01] VERIFIED SRM 51-10-02-OG-0 STEP#9;IS APPLICABLE FOR REPAIR.;[02] PRIOR TO REMOVAL;FOUND PART TO HAVE NO ALLOWABLE DAMAGE LIMITS AND SO PART IS REPAIRABLE BY REPLACEMENT PER SRM 51-10-02.;[03] REMOVED GUSSET SDR REXA2022050300759Frame · corrodedFS 280 FRAME CORRODED ON UPPER FLANGE BETWEEN STR 25L AND 25R. REPAIRED IAW CRJ953-13274 REV IR DATED 4/7/2022.SDR REXA2022060901107Seat Track · corrodedRBL 27 SEAT TRACK IS CORRODED BETWEEN FS985 -FS1000. REMOVED RBL 27 SEAT TRACK BETWEEN F.S. 985 TO F.S. 1000. INSTALLED A SERVICEABLE RBL 27 SEAT TRACK BETWEEN F.S. 985 TO F.S. 1000 IAW CRJ 700 53-00-49-000-802, AND 53-00-49-400-802.SDR REXA2022060901103Seat Track · corrodedRBL 9 FLOOR SEAT TRACK IS CORRODED BETWEEN FS847 -FS969. REMOVED RBL 9 FLOOR SEAT TRACK BETWEEN F.S. 847 TO F.S. 969. INSTALLED A SERVICEABLE RBL 9 SEAT TRACK BETWEEN F.S. 847 TO F.S. 969 IAW CRJ 700 53-00-49-000-801-A03, AND 53-00-49-400-801-A03.SDR SWAA2022053197674Angle · corrodedCORROSION ANGLE - SUPPORT LOCATED BS312 TO BS328 AT RBL59 AND WL208.1 AT FWD GALLEY AREA 2022-207238. REPLACED ANGLE - SUPPORT LOCATED AT INNER CHORD BTW BS294.5 TO BS328 AT RBL59 AND WL208.1 AT FWD GALLEY AREA I.A.W B737-700 SRM 51-10-02 ITEM 9 AND DWG 141A83SDR SWAA2022053197673Angle · corrodedCORROSION INNER CHORD LOCATED BS328 AT RBL58 AND WL208.1 AT FWD GALLEY AREA 2022-207221 / [01] TOOL USED PN. 35DL; SN. 091419910; DUE DATE. 26-JAN-23;[02] REPLACED INNER CHORD LOC. BS328 AT RBL58 AND WL208.1 AT FWD GALLEY AREA IAW B737-700 SRM 51-40-02 AND DWGSDR REXA2022052701016Beam · corrodedFOUND R/H HALF OF FS280 BEAM CORRODED BEYOND LIMITS. REMOVED UNSERVICEABLE BEAM P/N CC670-34094-2, LOCATED, DRILLED, AND INSTALLED SERVICEABLE BEAM P/N CC670-34094-2 IAW CRJ 900 SRM 51-40-11-001-001-A01, 51-42-06-001-001-A01, 51-42-10-001-001-A01, AND 51-42-21SDR REXA2022052701005Bracket · crackedPANEL FLOOR SUPPORT IS CRACKED AT FS 597.00 STGR 25L. BRACKET WAS REMOVED, FABRICATED, AND INSTALLED IAW CRJ 900 SRM 51-42-06-001-001-A01, 51-40-11-001-001-A01, 51-24-36-001-001-A01, AND 53-32-58-001-001-A01.SDR REXA2022052701004Bracket · crackedPANEL FLOOR SUPPORT IS CRACKED AT FS 597.00 STGR 27. BRACKET WAS REMOVED, FABRICATED, AND INSTALLED IAW CRJ 900 SRM 51-42-06-001-001-A01, 51-40-11-001-001-A01, 51-24-36-001-001-A01, AND 53-32-58-001-001-A01.SDR FDEA202204251305Strap · corrodedCABIN STA 1420 FOUND CORROSION ON INTERCOSTAL STRAP RBL 24.75 AND RBL 45.5 PERFORMED FLOOR BEAM REPAIR STABILIZATION STRAP PER SRM 53-00-51-2R, FIG.201 REPAIR 13 MAJOR REPAIRSDR IPXA2022052582524Floor Panel · brokenINSPECTION TYPE:A300MDC FLOOR PANEL 241FN IS BROKENREPAIRED MDC FLOOR PANEL 241FN AS NEEDED IAW EO NO A300-5320-42722-FSDR IPXA2022052582523Floor Panel · brokenINSPECTION TYPE:A300MDC FLOOR PANEL 231RG IS BROKENREPAIRED MDC FLOOR PANEL 231RG AS NEEDED IAW EO NO A300-5320-42722-FSDR SWAA2022052697666Intercostal · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BS344 TO BS360 AT RBL32 FWD GALLEY AND LAV 2022-207219 REPLACED WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BS344 TO BS360 AT RBL32 FWD GALLEY AND LAV IAW B737-700 SRM 51-40-02 AND DWG 141A5400 SHEET 39 AND SRM 51-SDR SWAA2022052697668Intercostal · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BS294.5 TO BS312 AT RBL15 FWD GALLEY AND LAV 2022-207227 / [01] REPLACED WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BS294.5 TO BS312 AT RBL15 FWD GALLEY IAW B737-700 SRM 51-10-02 AND B737-700 SRM 51-40-02 AND DRAWSDR IPXA2022052582482Floor Panel · damagedINSPECTION TYPE:C PNL 252BN BROKEN FABBED IAW SREO A300-5320-40552-B
Back to JASC 5320