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 AALA202203221837Web · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLIGHT DECK FLOOR STRUCTURE WEB, LOCATED AT FR 11, WL Z-500, RBL Y-765. REPLACED WEB PER SRM 51-42-11.SDR AALA202203225274Channel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON ANTENNA SUPPORT U CHANNEL, LOCATED BETWEEN FR 59 AND FR 60, BETWEEN S42L AND S43L.SDR 7C7A2022031700009Shear Web · corrodedCORROSION DAMAGE TO BAGGAGE DOOR SURROUND SHEAR WEB PN 85330431 BETWEEN X545 - X564.50 OUTBOARD OF Y-19.23. REF 008.53-22.06SDR 7C7A2022031700007Strap · corrodedCORROSION DAMAGE TO THE INNER CAP STRAPS PN 8533501 STRAPS AT FRAME AT X618 BETWEEN STR. 20S-22S. REF. 008.53-22.12SDR REXA2022053100922None · corrodedRBL 9 FLOOR SEAT TRACK IS CORRODED BETWEEN FS 581 TO FS 661+32 REPLACED SEAT TRACK IAW CRJ 900 AMM 53-00-49-000/400-801-A07.SDR REXA2022051200872Stringer · corrodedSTRINGER 26R BETWEEN FS333 AND FS 349 IS CORRODED. REMOVED CORRODED STRINGER AND INSTALLED A NEW/SERVICEABLE STRINGER , IAW CRJ 900 SRM'S #51-40-11-001-001-A01, 51-42-06-001-001-A01, AND 51-42-21-001-001-A01.SDR REXA2022051200871Stringer · corrodedSTRINGER 26L BETWEEN FS333 AND FS 349 IS CORRODED. REMOVED CORRODED STRINGER AND INSTALLED A NEW/SERVICEABLE STRINGER , IAW CRJ 900 SRM'S #51-40-11-001-001-A01, 51-42-06-001-001-A01, AND 51-42-21-001-001-A01.SDR SWAA2022041884657Seat Track · corrodedCOCKPIT FLOOR CO-PILOT SEAT TRACK INB FWD HAS CORROSION AT BOTTOM OF TRACK. / [01] OK TO INSTALL SEAT TRACK.;[02] INSTALLED COCKPIT FLOOR SEAT TRACK INB FWD; AS PER REF: B737 AMM 25-11-11-400-801.;[03] VERIFIED INSTALLATIONSDR SWAA2022041884656Seat Track · corrodedCOCKPIT FLOOR CO-PILOT SEAT TRACK 0UTB FWD HAS CORROSION AT BOTTOM OF TRACK. / [01] OK TO INSTALL SEAT TRACK;[02] INSTALLED COCKPIT FLOOR CO-PILOT SEAT TRACK OUTB FWD; AS PER REF: B737 AMM 25-11-11-400-801;[03] VERIFIED INSTALLED.SDR SWAA2022041884659Seat Track · corrodedCOCKPIT FLOOR PILOT SEAT TRACK OUTB FWD HAS SEVERAL SPOTS OF CORROSION. / [01] OK TO INSTALL NEW SEAT TRACK.;[02] INSTALLED COCKPIT FLOOR PILOT SEAT TRACK OUTB FWD; AS PER REF: B737 AMM 25-11-11-400-801;[03] VERIFIED INSTALLATION;[04] VERIFIED STEPSSDR SWAA2022041884654Seat Track · corrodedCOCKPIT FLOOR PILOT SEAT TRACK INB FWD HAS SEVERAL SPOTS OF CORROSION. / [01] OK TO INSTALL NEW SEAT TRACK.;[02] INSTALLED COCKPIT FLOOR PILOT SEAT TRACK INB FWD; AS PER REF: B737 AMM 25-11-11-400-801.;[03] VERIFIED INSTALLATION.SDR SWAA2022041284633Angle · corrodedDOT#29-186 AFT CARGO COMPARTMENT Z ANGLE CORRODED STA 727H+6 TO 767 RBL 22 WL 156 / [01] REMOVED CORROSION ON Z ANGLE IAW SRM 51-10-02-0G-0 ITEM 15;[02] EVALUATED ALLOWABLE LIMITS : .040 ORIGINAL 'T' .028 REMAINING .012 LOSS; FOUND OUT OF LIMITS IAW SRM 53-00-SDR SWAA2022041284631Angle · corrodedDOT#31-186 AFT CARGO COMPARTMENT Z ANGLE CORRODED STA 727I TO 807 RBL 22 WL 156 CORRECTION; SHOULD READ LBL 22 / [01] REMOVED CORROSION ON Z ANGLE IAW SRM 51-10-02-0G-0 ITEM 15;[02] EVALUATED ALLOWABLE LIMITS : .040 ORIGINAL 'T' .033 REMAINING .007 LOSS FOUND SDR SWAA2022041284632Shield · corrodedDOT#32-186 AFT CARGO COMPARTMENT FWD SHILED CORRODED STA 767 TO 787 RBL 22 WL 156 / [01] EVALUATED ALLOWABLE LIMITS: 100 % MATERIAL LOSS FOUND OUT OF LIMITS IAW SRM 53-60-15-1A-1;[02] VERIFED STEP 1 IS COMPLETE;[03] VERIFIED STEP 1;[04] REMOVED DAMAGE SIDE SHISDR SWAA2022041284642Strap · corrodedDOT#35-186 AFT CARGO COMPARTMENT FLOOR 'T' STRAP CORRODED STA 887 RBL 22 TO LBL8 WL 156 / [01] REMOVED; LOCATED AND DRILLED; INSTALLED NEW AFT CARGO FLOOR SPLICE TEE STRAP AT BS 887 RBL22 TO LBL8 IAW SRM 51-40-02-0G-0 AND BOEING DWG# 146A7500 ID:0001 REV:B.;[0SDR REXA2022040800568Shim · corroded2 EA SHIMS COMMON TO FLOORBEAM @ FS 333 & RBL 9 ARE CORRODED - REPAIRED SHIMS I/A/W CRJ 900 SRM 51-21-06-001-001-A01, AND 51-42-06-001-001-A01.SDR SWAA2022040784636Strip · corrodedDOT#39-186 AFT CARGO COMPARTMENT #4 RH CAP STRIP CORRODED / [01] REMOVED COROSSION AND VERIFIED WITH 10X MAGINIFIER ALL COROSSION REMOVED IAW SRM 51-10-02-0G-0;[02] VERIFIED LIMITS; OUT OF LIMITS DUE TO NO PUBLISHED LIMITS IN SRM<BR>ORIGINAL THICKNESS .063'<BRSDR SWAA2022040784637Strip · corrodedDOT#40-186 AFT CARGO COMPARTMENT #3 RH CAP STRIP CORRODED / [01] REMOVED COROSSION AND VERIFIED WITH 10X MAGINIFIER ALL COROSSION REMOVED IAW SRM 51-10-02-0G-0;[02] VERIFIED LIMITS; OUT OF LIMITS DUE TO NO PUBLISHED LIMITS IN SRM<BR>ORIGINAL THICKNESS .063'<BRSDR SWAA2022040784643Strip · corrodedDOT#41-186 AFT CARGO COMPARTMENT #2 RH CAP STRIP CORRODED / [01] REMOVED COROSSION AND VERIFIED WITH 10X MAGINIFIER ALL COROSSION REMOVED IAW SRM 51-10-02-0G-0;[02] VERIFIED LIMITS; OUT OF LIMITS DUE TO NO PUBLISHED LIMITS IN SRM<BR>ORIGINAL THICKNESS .063'<BRSDR SWAA2022040784638Strip · corrodedDOT#42-186 AFT CARGO COMPARTMENT #1 RH CAP STRIP CORRODED / [01] REMOVED COROSSION AND VERIFIED WITH 10X MAGINIFIER ALL COROSSION REMOVED IAW SRM 51-10-02-0G-0;[02] VERIFIED LIMITS; OUT OF LIMITS DUE TO NO PUBLISHED LIMITS IN SRM<BR>ORIGINAL THICKNESS .063'<BRSDR SWAA2022040784648Scuff Plate · corrodedDOT#48-186 AFT CARGO COMPARTMENT FLOOR FWD HOCKY STICK SCUFF PLATE CORRODED / [01] VERIFIED AND REPLACED AFT CARGO COMPARTMENT FWD CARGO TIEDOWN PLATE ON PARTS RACK IAW IPC 25-52-10-04 AND BOEING DWG# 453A2600 ID:0026 REV:D;[02] VERIFIED STEP 1<BR>AUDIT CWSDR SWAA2022040784646Scuff Plate · corrodedDOT#49-186 AFT CARGO COMPARTMENT FLOOR AFT HOCKY STICK SCUFF PLATE CORRODED / [01] VERIFIED AND REPLACED AFT CARGO COMPARTMENT AFT CARGO TIEDOWN PLATE ON PARTS RACK IAW IPC 25-52-10-04 AND BOEING DWG# 453A2600 ID:0026 REV:D;[02] VERIFIED STEP 1<BR>AUDIT CWSDR SWAA2022040784647Strip · corrodedDOT#50-186 AFT CARGO COMPARTMENT 3EA CAP STRIPS CORRODED / [01] REMOVED COROSSION FROM 3 EA CAPSTRIPS AND VERIFIED WITH 10X MAGINIFIER ALL COROSSION REMOVED IAW SRM 51-10-02-0G-0;[02] VERIFIED LIMITS; OUT OF LIMITS DUE TO NO PUBLISHED LIMITS IN SRM<BR>ORIGINALSDR REXA2022040700590Angle · corrodedCORROSION FOUND ON UPPER PAX DOOR SILL ANGLE AT FS 319. - REPLACED PAX DOOR SILL ANGLE AT FS319 IAW CRJ 900 SRM 51-41-02-001-001-A01, 51-21-11-001-001-A01, 53-211-23-101-001-A02.SDR REXA2022040700580Stringer · corrodedSTGR 26R IS CORRODED BETWEEN F.S. 661+74 TO F.S. 669.40. - COMPLIED WITH EA CRJ953-12984 REV IR.SDR SWAA2022040584779Angle · crackedCRACK ANGLE LOCATED ON BS 867 AT LEVEL STR 26L AT AFT CARGO COMPARTMENT 2022-144868 / [01] REPLACED ANGLE LOCATED ON BS 867 AT LEVEL STR 26L AT AFT CARGO COMPARTMENT IAW B737-700 SRM-51-10-02 ITEM 9 SEE INDIVIDUAL SIGN-OF BELOW;[02] REPLACED ANGLE LOCATED ON BSDR SWAA2022040584778Bracket · crackedCRACK BRACKET LOCATED ON BULKHEAD BS 727 AT LEVEL STR 27R AT AFT CARGO COMPARTMENT 2022-144866 / [01] REPLACED BRACKET LOCATED ON BULKHEAD BS 727 AT LEVEL STR 27R AT AFT CARGO IAW B737-700 SRM 51-40-02 SRM 51-10-02 ITEM 9 DWG #144A2600 REV.- TOOL USED CALIPER SDR SWAA2022040584782Channel · corrodedCORROSION ON CHANNEL LOCATED BTW BS 500 TO BS 500A AT LEVEL STR 25R IN FWD CARGO COMPARTMENT 2022-144876 / [01] TOOL USED P/N 45 MG S/N 130060401 DUE DATE 23/MAY/21;[02] REPLACED CHANNEL LOCATED BTW BS 500 TO BS 500A AT LEVEL STR 25R IN FWD CARGO COMPARTMENT ISDR SWAA2022040484555Plate · corrodedAFT CARGO DOOR CUTOUT; FWD AND AFT SPLICE PLATES; CORRODED. / [01] RECEIVED NEW FWD AND AFT SPLICE PLATES LOCATED AT AFT CARGO DOOR CUT OUT. P/N 453A2611-1 AND 453A2611-2 PO#1741204 AND PO #174927. PLATES WILL BE INSTALLED ON FAULT TTG8Q004BY1W;[02] AFT CARGO SDR REXA2022040100545Joint · corrodedCIRCUMFERENTIAL BUTTSTRAP JOINT AT F.S.280 IS CORRODED BETWEEN STRINGER 23R AND 24R. REPAIRED CIRCUMFERENTIAL JOINT AT F.S.280 IAW ENDEAVOR AIR EA CRJ953-13055SDR REXA2022040100544Stringer · corrodedF.S. 349-7 INCHES, STRINGER 25R, IS CORRODED ON OUTBOARD SIDE REMOVED AND REPLACED LONGERON, STRINGER 25R BETWEEN F.S.333-364 IAW CRJ 900 SRM 51-40-11-001-001-A01, 51-42-06-001-001-A01, AND 51-42-21-001-001-A01.SDR IPXA2022032680517Cargo Track · brokenINSPECTION TYPE:C3BROKEN DAMAGE ON EXISTING REPAIR CARGO TRACK IN FWD CARGO COMPARTMENT AT STA 570 , RBL 45REPAIR I.A.W BOEING SR : 4-5465659276 AND UPS EO B747-5320-83274-ASDR AALA202203227186Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN DOOR STOP # 7 INTERCOSTAL FITTING LOCATED AT FR 16. REPLACED INTERCOSTAL FITTING PER SRM 51-42-11.SDR AALA202203225959Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN DOOR STOP # 7 INTERCOSTAL FITTING LOCATED AT FR 16, LEFT SIDE. REPLACED INTERCOSTAL FITTING PER SRM 51-42-11.SDR YENA2022031700274Shear Tie · corrodedDURING HEAVY MAINTENANCE, : INITIAL INSPECTION: [CPCP FINDING] CORROSION ON SHEAR CLIP OVER FR-81 BTW STGR-27L / STGR-28L AT AFT CARGO COMPARTMENT; REF TOMX WO 1846 NR -00137: SHEAR CLIP WAS REPLACED PER EMB-190 SRM 51-12-01 PAR 6 AND SRM 51-10-03 PAR 4 A ANSDR YENA2022031700273Shear Tie · corrodedDURING HEAVY MAINTENANCE, INITIAL INSPECTION: [CPCP FINDING] CORROSION IN SHEAR CLIP OVER FR-85 BTW STGR-27L / STGR-28L AT AFT CARGO COMPARTMENT; REF TOMX WO 1846 NR -00145: SHEAR CLIP WAS REPLACED PER EMB-190 SRM 51-12-01 PAR 6 AND SRM 51-10-03 PAR 4 A AND SSDR YENA2022031700272Shear Tie · corrodedDURING HEAVY MAINTENANCE, INITIAL INSPECTION: [CPCP FINDING] CORROSION IN SHEAR CLIP OVER FR-83 BTW STGR-27L / STGR-28L AT AFT CARGO COMPARTMENT; REF TOMX WO 1846 NR -00143 SHEAR CLIP WAS REPLACED PER EMB 190 SRM 51-12-01 PAR 6 AND SRM 51-10-03 PAR 4 D AND SRSDR YENA2022031700271Shear Tie · corrodedDURING HEAVY MAINTENANCE, INITIAL INSPECTION: [CPCP FINDING] CORROSION ON SHEAR CLIP OVER FR-- 76 BTW STGR-27L / STGR-28L AT AFT CARGO COMPARTMENT; REF TOMX WO 1846 NR -00115 SHEAR CLIP WAS REPLACED PER EMB-190 SRM 51-12-01 PAR 6 AND SRM 51-10- 03 PAR 4 A AND SDR YENA2022031700270Shear Tie · corrodedDURING HEAVY MAINTENANCE, INITIAL INSPECTION: [CPCP FINDING] CORROSION IN SHEAR CLIP OVER FR-82 BTW STGR-29L / STGR-28L AT AFT CARGO COMPARTMENT; REF TOMX WO 1846 NR -00142 SHEAR CLIP WAS REPLACED PER EMB-190 SRM 51-12-01 PAR 6 AND SRM 51-10-- 03 PAR 4 A AND SSDR JJBA20240404017Rivet · looseAT CF1 FLOOR STRUCTURE AREA, CORROSION AND TWO LOOSES RIVETS FOUND ON R/H OCTOGONAL DOUBLER AT FR 20 CF1, FLOOR STRUCTURE, OXTOGONAL DOUBLER RH OMEGA BEAM AT FR20 REMOVED/REPLACEDSDR REXA2022060601014Stringer · corrodedSTR 22R HAS MULTIPLE AREAS OF CORROSION BETWEEN FS333-349 WITH A MAX DEPTH OF .040". REMOVE AND REPLACE STRINGER.SDR REXA2022053100934Intercostal · corrodedF.S.310 - FS319, STRGR 20R, INTERCOSTAL, IS CORRODED. REMOVED AND REPLACED CORRODED INTERCOSTAL, FS310.00 - FS 319.00, IAW CRJ 900 SRM #51-40-11-001-001-A01,#51-42-06-001-001-A01 AND #51-42-21-001-001-A01.SDR REXA2022053100926Stringer · corrodedF.S.295 TO F.S.310 STGR 20R IS CORRODED. REMOVED CORRODED STRINGER 20R FROM F.S.295 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 SWAA2022042084212Intercostal · corrodedCORROSION ON UPPER SURFACE OF SUPPORT INTERCOSTAL AT B.S. 259-270 AT L.B.L. 3 - R.B.L. 3; W.L 207.54. / [01] SRM 53-10-51-0I-2 FOR IDENTIFICATION AND SRM 53-10-51-1A-1 FOR ALLOWABLE DAMAGE ARE APPLICABLE;[02] REMOVEVED CORROSION AT DISCREPANCY AREA L=3.' X W=1SDR SWAA2022041884147Channel · corrodedMAIN CABIN FLOOR STRUCTURE INNER CHORD HAS CORROSION AT STA 827 THRU 867 RBL 65. / [01] MAIN CABIN FLOOR STRUCTURE INNER CHORD FROM STA 827 TO STA 867 RBL 65 FOUND EXFOLIATED IN REFERENCE TO SRM 53-60-51-1A-1.] REMOVED EXFOLIATED INNER CHORD FLOOR STRUCTURE ANSDR AALA202204135601Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23R. REPLACED SHEAR PLATE PER SRM 51-72-11.SDR AALA202204126381None · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT AFT PASSENGER / CREW DOOR CUT OUT LOWER CENTER FITTING BETWEEN FR 66 AND FR 68 AT S23R. REPLACED CENTER FITTING PER SRM 51-42-11.SDR SWAA2022041184262Floorbeam · corrodedCORROSION FLOOR STRUCTURE BEAM LOCATED BS986.5 LBL43 AND WL208.1 AT AFT GALLEY AREA 2022-131775 / [01] TOOL USED P/N: 45MG; S/N: 130063701; DUE DATE: 11-MAY-22;[02] TOOL USED. EDDY CURRENT EQUIPMENT. P/N: NORTEC 500D. S/N: N500X12101V022233. DUE DATE: 02-JUN-2SDR SWAA2022041184261Floorbeam · corrodedCORROSION FLOOR STRUCTURE BEAM LOCATED BS986.5 RBL43 AND WL208.1 AT AFT GALLEY AREA 2022-131772 / [01] TOOL USED ULTRASONIC EQUIPMENT P/N: 45MG; S/N: 130063701; DUE DATE: 11-MAY-22;[02] TOOL USED. EDDY CURRENT EQUIPMENT. P/N: NORTEC 500D. S/N: N500X12101V02223SDR AALA202204084412None · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT AFT PASSENGER / CREW DOOR CUT OUT LOWER CENTER FITTING BETWEEN FR 66 AND FR 68 AT S23L. REPLACED CENTER FITTING PER SRM 51-42-11.
Back to JASC 5320