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 REXA2022032200479Intercostal · corrodedINTERCOSTAL AT DD7 CORRODED - REMOVED AND REPLACED INTERCOSTAL P/N 601R318826-1 AND CUP P/N 601R318824-1 AT DD7 IAW CRJ900 SRM 51-40-11-001-001-A01 AND 51-42-06-001-001-A01.SDR REXA2022032200467Seat Track · corrodedSIDE SEAT TRACK AT FS744.15-761.85 HAS MULTIPLE SPOTS OF CORROSION. - REMOVED AND REPLACED SEAT TRACK IAW CRJ 900 AMM 53-00-49-000/400-801-A11. PN SH690-36285-1.SDR REXA2022032200466Seat Track · corrodedLH SIDE SEAT TRACK AT FS847+16-905 HAS MULTIPLE SPOTS OF CORROSION - REMOVED AND REPLACED SEAT TRACK IAW CRJ900 AMM 53-00-49-000/400-801-A01SDR REXA2022032200465Seat Track · corrodedLH SIDE SEAT TRACK AT FS 785-847+16 HAS MULTIPLE SPOTS OF CORROSION - REMOVED AND REPLACED SEAT TRACK IAW CRJ900 SRM 53-00-49-201-002-A01, 51-40-11-001-001-A01 AND AMM 53-00-49-000/400-801-A11SDR REXA2022032200460Seat Track · corrodedRH SIDE SEAT TRACK OF FS570-661+16 HAS MULTIPLE SPOTS OF CORROSION - REMOVED AND REPLACED SEAT TRACK IAW CRJ 900 AMM 53-00-49-000/400-801-A11SDR REXA2022032200457Seat Track · corrodedSEAT TRACK FROM FS 847+16-985 RBL 9 HAS MULTIPLE SPOTS OF CORROSION - REMOVED, FABED, AND INSTALLED SEAT TRACK F/S 847+16 - 985 @ RBL9 IAW CRJ900 SRM 53-00-49-201-002-A01 AND AMM 53-00-49-000/400-801-A11SDR REXA2022032200451Seat Track · corrodedFLOOR SEAT TRACK AT RBL 9 BETWEEN FS 485.00 AND FS 581.00 IS CORRODED. - REMOVED FASTENERS & CORRECTED COUNTERSINKS & REINSTALLED FASTENERS IAW CRJ 900 SRM 51-40-11-001-001-A01 & 53-00-49-400-801 (CONFIG A11).SDR REXA2022032200442Intercostal · corrodedINTERCOSTAL 27R CORRODED BETWEEN FS 349 AND FS 364. - REMOVED AND REPLACED INTERCOSTAL 27R IAW CRJ 900 SRM 51-42-06-001-001-A01, 51-42-20-001-001-A01 AND 51-40-11-001-001-A01.SDR SWAA2022032178379Support · corrodedCORROSION SUPPORT ZEE LOCATED BETWEEN BS727 TO BS767 RBL21.80 WL156 AFT CARGO COMPARTMENT 2022-85714 / [01] TOOL USED ULTRASONIC THICKNESS GAUGE P/N: 45MG; S/N: 130064101; CAL DUE DATE: 11-MAY-22<BR>TOOL USED EDDY CURRENT EQUIPMENT P/N: NORTEC 500D; S/N: N500XSDR SWAA2022032178380Intercostal · corrodedCORROSION WEB - INTERCOSTAL LOCATED BETWEEN BS767 TO BS794.3 RBL21.80 WL156 AFT CARGO COMPARTMENT 2022-85715 / [01] REPLACED NEW WEB INTERCOSTAL AND FASTENERS LOCATED BETWEEN BS767 TO BS794.3 RBL21.80 WL156 AFT CARGO COMPARTMENT I.A.W B737-700 SRM 51-40-02 ANDSDR REXA2022031000431Joint · corrodedCORRODED STRINGER 21R FROM FS 280 TO FS 333. - REMOVED CLEATS AT STR 21R FROM FS 310, FS 319, AND FS 333 IAW CRJ 900 SRM 51-42-06-001-001-A01. REMOVED UNION SPLICE FROM STR 21R AT FS 333 IAW CRJ 900 SRM 51-42-06-001-001-A01 PART CORRODED BEYOND ALLOWABLE LIMITSDR REXA2022031000430Stringer · corrodedCORRODED STRINGER 21R FROM FS 280 TO FS 333. - REMOVED CLEATS AT STR 21R FROM FS 310, FS 319, AND FS 333 IAW CRJ 900 SRM 51-42-06-001-001-A01. REMOVED UNION SPLICE FROM STR 21R AT FS 333 IAW CRJ 900 SRM 51-42-06-001-001-A01 PART CORRODED BEYOND ALLOWABLE LIMITSDR AALA202203015913Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT PASSENGER / CREW DOOR CUT OUT LOWER CENTER FITTING BETWEEN FR 66 AND FR 68 AT S23L. REPLACED CENTER FITTING PER SRM 51-42-11.SDR SWAA2022040477741None · crackedAFT CARGO DOOR CUTOUT UPPER FWD CORNER STA 787 S-18R PANEL SUPPORT IS CRACKED AS MARKED. 124-034 / [01] REMOVED DAMAGED SUPPORT ANGLE ; AT AFT CARGO DOOR CUT OUT UPPER FWD CORNER AT STA 787S-18R AS PER B737-700 SRM 51-40-02-0G-A00729;[02] FABRICATED NEW SUPPORSDR SWAA2022040477736Angle · corrodedFLOOR SUPPORT ANGLE FROM STA 727 TO 767 FOUND CORROSION R/H SIDE / [01] REMOVED CORROSION AT AFT CARGO FLOOR SUPPORT ANGLE FROM STA 727 TO 767 ASPER B 737-700 SRM 53-00-53-1A-2;[02] VERIFIED STEP 1;[03] ORIGINAL MATERIAL 0.040 REMOVED MATERIAL 0.010 MATERIAL RSDR SWAA2022040477416Shield · corrodedFLOOR SUPPORT PLATE FROM 767 TO 787 FOUND CORROSION R/H SIDE. / [01] FLOOR SUPPORT ANGEL FOUND CORRODED AND IS OUT OF LIMIST AS PER B737-700 SRM 53-00-53-1A-2;[02] RECEIVED NEW FLOOR SUPPORT PLATE PO#1728471) LOCATED NEW FLOOR SUPPORT AND DRILLED NEW HOLES ASPSDR REXA2022040100526Seat Track · corrodedLH SIDE SEAT RAIL BETWEEN FS 785.00 AND 847.00+16 CORRODED. REMOVED AND REPLACED SIDE SEAT RAIL IAW CRJ AMM 53-00-49-000/400-801SDR REXA2022040100525Stringer · corrodedCORRODED STGR 26R FROM FS333.00 TO FS364.00 CA: REMOVED AND REPLACED STRINGER 25R FROM FS333.00 TO FS364.00 IAW CRJ900 SRM TASKS 51-42-06-001-001-A01 AND 51-40-11-001-001-A01.SDR REXA2022040100517Seat Track · corrodedLH SIDE SEAT RAIL BETWEEN FS 744.00 AND FS 752.00 CORRODED. REMOVED AND REPLACED SIDE SEAT RAIL IAW CRJ AMM 53-00-49-000/400-801SDR REXA2022040100516Seat Track · corrodedLH SIDE SEAT RAIL BETWEEN FS 847.00+16 AND FS 855.00 CORRODED. REMOVED AND REPLACED SIDE SEAT RAIL IAW CRJ AMM 53-00-49-000/400-801SDR SWAA2022032878073Support · corrodedCORROSION; FWD CARGO RH FLOOR TO SIDEWALL SUPPORT; UPPER SURFACE; BS 500A TO BS 500D; RBL 22 / [01] REMOVED CORROSION ON FWD CARGO R/H FLOOR TO SIDEWALL SUPPORT; UPPER SURFACE BTW BS 500A TO BS 500D RBL 22 MEASURES (1).- BS 500A+10'; L=1'. X W=.5' X D=0.010' (SDR SWAA2022032577904Scuff Plate · crackedAFT CARGO DOOR CUTOUT LOWER FORWARD CORNER SCUFF PLATE IS CRACKED.. / [01] RECEIVED SERVICEABLE SCUFF PLATE. TO BE INSTALLED ON REF. TTG8Q004EV1M.;[02] VERIFIED STEP 1..SDR SWAA2022032077720Scuff Plate · crackedCRACK AFT CORNER SCUFF PLATE AT FWD CARGO COMPARTMENT 2022-85697 / [01] TOOL USED; DIGITAL CALIPER P/N:500-197-30 S/N:B16144211; DUE DATE; 01/OCT/22.;[02] REPAIRED BY WELDS AFT CORNER SCUFF PLATE OF FWD CARGO COMPARTMENT IAW BOEING 737-700 SRM 53-30-15-2R-1; RSDR AALA202203115461Threshold · corrodedAIRCRAFT IN BASE MAINTENANCE: AFT CARGO DOOR THRESHOLD HAS CORROSION LOCATED BETWEEN 790 TO 847 AND RIGHT BUTT LINE 21. REMOVED AND INSTALLED SERVICEABLE AFT CARGO DOOR THRESHOLD PER AARD 51-00-05.SDR AALA202203113939Transition Panel · corrodedAIRCRAFT WAS NOT GROUNDED: FORWARD RIGHT TRANSITION SHIELD HAS CORROSION LOCATED BETWEEN STA 767 TO 790. AND RIGHT BUTT LINE 20. REMOVED AND INSTALLED NEW RIGHT TRANSITION SHIELD PER SRM 51-40-02.SDR AALA202203110860Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON TRANSITION ANGLE LOCATED BETWEEN STA 727-767 AND BUTT LINE 33. SPLICED IN NEW PIECE OF TRANSITION PANEL PER SRM 53-00-53--2R.SDR AALA202203116085Flange · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LOWER FLANGE OF FORWARD CARGO COMPARTMENT MOVABLE BULKHEAD, LOCATED AT STA 500I BETWEEN RBL 20 AND LBL 20. REPAIRED PER SRM 51-40-02.SDR AALA202203106487Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON LEFT TRANSITION PANEL, STA 480-500I, AND STR 25L. REMOVED OLD TRANSITION PANEL AND INSTALLED LEFT TRANSITION STATION 460-12 TO 500I AND REPAIR SPLICE PER SRM 53-00-53-2R-5.SDR AALA202203107279Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON THRESHOLD WEB AREA AT CARGO DOOR. LOCATION: STA 440 TO 492 AND RIGHT BUTT LINE 64. INSTALLED FORWARD CARGO THRESHOLD WEB PER BOEING DRAWING 143A8330 AND AARD 51-00-05-1.SDR AALA202203103285Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: RIGHT CREASE ANGLE AT THE R2 DOOR, MULTIPLE AREAS OF CORROSION ON THE SURFACE AND AROUND FASTENER HOLES. LOCATION: STA 893 TO 1006 RIGHT BUTT LINE 44. INSTALLED CREASE ANGLE ALL FASTENERS PER AARD 51-00-05-01 AND SRM 51-40-01.SDR REXA2022030200316Skin · noneWHILE ATTEMPTING TO PERFORM NDT TASK 900-46-900-921, FOUND PREVIOUS REPAIR IN THE INSPECTION AREA AROUND FWD ATG ANTENNA. - COMPLIED WITH INTELSAT EA 7104 REV B DATED 26 JAN 2022 ALL STEPS.SDR REXA2022040700611Seat Track · corrodedRH SIDEWALL SEAT TRACK HAS MULTIPLE SPOTS OF CORROSION FROM FS 565 TO FS 661+16. - REMOVED AND REPLACED RH SIDEWALL SEAT RAIL F/S 565-FS661+16 IAW CRJ900 AMM 53-00-49-000-801-(CONFIG A11) AND AMM 53-00-49-400-801(CONFIG A11)SDR REXA2022040700607Seat Track · corrodedLH SIDEWALL SEAT TRACK HAS MULTIPLE SPOTS OF CORROSION FROM FS 661+16 TO FS 677. - REMOVED, FABRICATED AND INSTALLED SEAT TRACK IAW CRJ 900 AMM 53-00-49-400-801-A11 AND SRM 53-00-49-201-002-A01SDR REXA2022040700593Seat Track · corrodedSEAT TRACK AT FS 349-485 RBL 9 IS CORRODED. - REMOVED AND REPLACED SEAT TRACK IAW CRJ 900 AMM 53-00-49-400-801-A11, REPLACED LAV MOUNT FITTINGS IAW CRJ 900 SRM 51-41-02-001-001-A01.SDR REXA2022040700592Seat Track · corrodedSEAT TRACK AT FS 376-485 LBL 9 IS CORRODED. - INSTALLED NEW SEAT TRACK PN 670-32249-3 FROM LBL 9 FS 376-485 IAW CRJ 900 AMM 53-00-49-400-801-A11.SDR REXA2022040700591Seat Track · corrodedSEAT TRACK FROM FS 364-485 LBL 28 IS CORRODED. - INSTALLED NEW SEAT TRACK PN SH690-321-27-3 FROM LBL 27 FS 364-485 IAW CRJ 900 AMM 53-00-49-400-801-A11.SDR REXA2022040700586Seat Track · corrodedSEAT TRACK AT F.S 847 + 16 - 985 BLB9 HAS CORROSION. - REMOVED AND INSTALLED SEAT TRACK AT LBL 9 AT FS 847+16 - 985 IAW CRJ 900 AMM 53-00-49-000/400-801-A11 PN SH690-37388-5.SDR REXA2022040700584Seat Track · corrodedSEAT TRACK AT FS 927-979 RBL 28 HAS CORROSION. - REMOVED AND INSTALLED SEAT TRACK AT FS 927-979 RBL 28 IAW CRJ 900 AMM 53-00-49-000/400-801-A11 PN SH690-37386-1.SDR SWAA2022040477724Support · debondedMAIN CABIN R/H SIDE WALL INSERT SUPPORT BRACKET DISBONDED @ S-11R STA 540 MKD DOT / [01] RE-SECURED INSERT SUPPORT AT STA. 540 & S-11R AS PER SOPM. 20-50-12.;[02] VERIFIED STEP 1SDR SWAA2022033177114Bear Strap · crackedCRACK IN BEAR STRAP BS294 BETWEEN STR 8R AND 9R AT FWD GALLEY DOOR. MARKED IN RED. CRACK LENGTH .250 IN FROM EDGE OF FASTENER GOING AFT AND UP. FOUND ON HFEC INSP / [01] VERIFIED SRM 53-10-01-2R-6 IS APPLICABLE FOR REPAIR TO FUSELAGE SKIN AND BEAR STRAP AT FWDSDR SWAA2022032877768Support · crackedCRACK ON PASSENGER CABIN FLOOR PANEL SUPPORT AT BS 540 RBL 26; RBL 44. / [01] REMOVED ON PASSENGER CABIN FLOOR PANEL SUPPORT AT BS 540 RBL 26 RBL 44 WL 208 PER SRM 51-40-02-0G-0;[02] RECIVED NEW FLOOR PANEL SUPPORT ITEM 143A5240-32 LOT 1470220-1 LOCATED AND<BRSDR AALA202204262006Shear Tie · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHEAR TIE AT FR 57 BETWEEN S43R AND S44R. REPLACED SHEAR TIE PER SRM 51-42-11.SDR REXA2022040700606Seat Track · corrodedLH SIDEWALL SEAT TRACK HAS MULTIPLE SPOTS OF CORROSION FROM FS 565 TO FS 661+16. - REMOVED AND RELACED LH SIDEWALL SEAT RAIL FS565-FS661+16 IAW CRJ 900 AMM 53-00-49-000-801 (CONFIG A11) AND AMM 53-00-49-400-801 (CONFIG A11)SDR SWAA2022040477011Gusset · crackedFWD CARGO COMPARTMENT GOSET CRACKED @ S-19R STA 500D MKD DOT / [01] REMOVED AND REPLACED GOSSETT AT FWD CARGO COMPARTMENT S-19R STA 500D AS PER IN REF SRM 51-40-02-OG-0;[02] VERIFIED STEP 1SDR SWAA2022040477016Gusset · crackedFWD CARGO COMPARTMENT GOSET CRACKED @ S-19L STA 500D / [01] REMOVED AND REPLACED GOSET AT FWD CARGO COMPARTMENT ON S-19L STA 500D AS PER REF SRM 51-40-02OG-0;[02] VERIFIED STEP 1SDR SWAA2022040477018None · crackedFWD CARGO COMPARTMENT. Z CHANNEL SUPPORT CLIP CRACKED @ S-25R STA 500C MKD DOT 001 / [01] REMOVED AND REPLACED SUPPORT CLIP AT FWD CARGO IN REF SRM 51-40-02;[02] VERIFIED STEP 1. CLIP AT S-25R; STA 500CSDR REXA2022040100502Stringer · corrodedSTGR 26R HAS CORROSION BETWEEN FS 295.00 AND FS333.00. REMOVED AND REPLACED STRINGER 26R FROM FS295.00 TO FS333.00 IAW CRJ900 SRM TASKS 51-42-06-001-001-A01 AND 51-40-11-001-001-A01SDR SWAA2022033177109Support Bracket · crackedCRACK ON AFT UNPRESSURIZED COMPARTMENT FIRE DETECTOR SENSOR SUPPORT BRACKET AT BS 1064 LBL 3 JUST ABOVE L/H STRINGER 26. / [01] EVALUATED CRACK ON AFT UNPRESSURIZED COMPARTMENT FIRE DETECTOR SENSOR SUPPORT BRACKET AT BS 1064 LBL 3 JUST ABOVE L/H STRINGER 26. NSDR SWAA2022032276512Angle · crackedCRACK ANGLE FLOOR STRUCTURE LOC. ON BS 380 TO BS 400 AND LBL 4 AT FWD GALLEY AREA 2022-80405 / [01] REPLACED NEW ANGLE AND FASTENERS EXACTLY LOCATION ON BS 380 TO BS 400 BL 0 AT FWD GALLEY AREA IAW B737-700 SRM 51-10-02 ITEM 9 AND 51-40-02 AND DWG 143A5400 REVSDR SWAA2022032176527Crease Beam · corrodedCORROSION CREASE BEAM WEB AT LEVEL STR 17R BETWEEN BS 500 AND BS 500A AT PASSENGER CABIN 2022-85525 / [01] TOOL USED DIGITAL CALIPER P/N:700-113-10 S/N: 0019298 DUE DATE: 01-APR-2022;[02] TOOL USED: TEMPERATURE CONTROLLER P/N P3015GOES00000 S/N 142811019 DUE D
Back to JASC 5320