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 SWAA2021112933610Bracket · crackedCRACK FLOOR STRUCTURE SUPPORT ANGLE LOCATED BS867 AT LEVEL STR26L AT AFT CARGO COMPARTMENT ; 2021-487793 / [01] REPLACED SUPPORT BRACKET (ANGLE) AND FASTENERS LOCATED BS867 AT LEVEL STR26L AT AFT CARGO COMPARTMENT I.A.W. B737-700 SRM 51-10-02; DWG# 149A8102 SHSDR SWAA2021112433604Bear Strap · crackedCRACK FWD SERVICE DOOR CUTOUT BEAR STRAP, BS 294.5, S8-9R. PASSENGER CABIN. REPAIRED THE BEAR STRAP IAW SRM 53-10-01-2R-6, REPAIR 6.SDR SWAA2021112433609None · crackedCRACK INNER CHORD, BS 303.9S17L, FWD GALLEY AREA. REPLACED INNER CHORD IAW DGW 140A9810 REV 48, SRM 51-10-02, & SRM 51-40-02.SDR SWAA2021111833916Intercostal · crackedFWD CARGO COMPARTMENT FLOOR STRUCTURE INTERCOSTAL S25L BETWEEN STA 500B-500C CRACKED ; / [01] REMOVED DAMAGE INTERCOSTAL FROM FWD CARGO PER 737-700 SRM 51-40-02-0G-0-A00729 (GENERAL - FASTENER INSTALLATION AND REMOVAL - AIRFRAME - PERMANENT; [02] LOCATED AND DSDR SWAA2021111833917Intercostal · crackedFWD CARGO COMPARTMENT FLOOR STRUCTURE INTERCOSTAL S25L BETWEEN STA 500-500A CRACKED ; / [01] REMOVED DAMAGE INTERCOSTAL FROM FWD CARGO PER 737-700 SRM 51-40-02-0G-0-A00729 (GENERAL - FASTENER INSTALLATION AND REMOVAL - AIRFRAME - PERMANENT; [02] REMOVED INTERCSDR SWAA2021111533750Angle · crackedCRACK ANGLE LOCATED BS540 BETWEEN BL0 TO LBL24 AND LEVEL WL208.1 AT PASSENGER CABIN ; 2021-490361 / [01] REPLACED ANGLE LOCATED BS540 BETWEEN BL0 TO LBL24 AND LEVEL WL208.1 AT PASSENGER CABIN IAW B737-700 SRM 51-40-02 AND SRM 51-10-02 TEM 9. PART USED: 143A524SDR SWAA2021111533751Angle · crackedCRACK ANGLE LOCATED BS540 BETWEEN RBL24 TO RBL45 AND LEVEL WL 208.1 AT PASSENGER CABIN ; 2021-490363 / [01] DIGITAL CALIPER P/N: 500-196-30; S/N: A20229165; DUE DATE: 11/AUG/22; [02] TOOL USED: TEMPERATURE CONTROLLER: P/N: P3015GOES00000; S/N: 112031023; DUE DSDR SWAA2021111533753Angle · crackedCRACK ANGLE LOCATED BS540 BETWEEN BL0 TO RBL24 AND LEVEL WL208.1 AT PASSENGER CABIN ; 2021-490362 / [01] DIGITAL CALIPER P/N: 500-196-30; S/N: A20229165; DUE DATE: 11/AUG/22.; [02] TOOL USED: TEMPERATURE CONTROLLER: P/N: P3015GOES00000; S/N: 112031023; DUE DATSDR SWAA2021111533754Angle · crackedCRACK VERTICAL ANGLE LOCATED BS694 BETWEEN BL0 AND LEVEL 208.1 AT PASSENGER CABIN ; 2021-490364 / [01] TOOL USED DIGITAL CALIPER P/N 500-196-30 S/N A20231699 DUE DATE 06-SEP-22; [02] TOOL USED: TEMPERATURE CONTROLLER P/N P3015GOES00000 S/N 142811020 DUE DATE: SDR SWAA2021111533755Angle · crackedCRACK ANGLE LOCATED BS696 BETWEEN BL0 AND LEVEL WL208.1 AT PASSENGER CABIN ; 2021-490365 / [01] TOOL USED: DIGITAL CALIPER P/N: 500-196-30 S/N:A20231699 DUE DATE:06-SEP-22.; [02] TOOL USED EDDY CURRENT PN/ NORTEC 600D; SN/ 210138003; DUE DATE/ 05-MAR-22; [03] SDR SWAA2021111533920Intercostal · crackedFOUND INTERCOSTAL CRACKED AT BS947 RBL21 WL155 ; / [01] THIS PART NO FOUND ALLOWABLE DAMAGE ON SRM; REPAIR BY REMPLACEMENT PER SRM 51-10-02 PARA 9; [02] REMOVED INTERCOSTAL FROM AFT CARGO BETWEEN BS 927 TO BS 947 RBL 21 WL 155 PER SRM 51-40-02; [03] LOCATED ANSDR AALA202111108582None · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION, MEASURING L=1.875 IN, W=1.675 IN, D=0.08 IN, ON AFT CABIN DOOR SILL LOCATED AT FR68, S21L WL Z-500, BL Y-1292. REPLACED SILL PER SRM 51-44-11.SDR SWAA2021110133665Panel · elongatedFOUND 3 ELONGATED FASTENER HOLES ON TRAILING EDGE OF 193D PANEL; AS MARKED. ; FOND 3 ELONGATED FASTENER HOLES ON TRAILING EDGE OF 193D PANEL; AS MARKED. / [01] ADDED EA 21-153-03169 AS A SUBTASK.; [02] REPAIRED PANEL PER EA 21-153-03169SDR AALA202110274921Seat Track · corrodedAIRCRAFT WAS NOT GROUNDED: CORRODED AREA FOUND ON SEAT TRACK BEAM FROM FR64 TO FR66. LENGTH = 2.336 INCHES WIDTH = 1.250 INCHES DEPTH = 0.049 INCHES. REPLACED FLOOR BEAM Y765 AT AFT GALLERY AREA PER SRM 51-42-11-801.SDR LR7A2021091102973None · noneDURING SCHEDULED C-4 CHECK UNDER JOB CARD HC5314, FOUND THE FS587 UNDERFLOOR STIFFENER HAS WORN AT RBL32, WL133. / REPAIRED IAW LAC MEA 382-53-21-087. NR# 1000565830.SDR REXA2021120701094Bracket · corrodedTRANSVERSE BEAM ATTACH BRACKET IS CORRODED @ FS 310 RH LOWER SILL. C/A: REMOVED AND REPLACED BRACKET IAW CRJ 900 SRM 51-40-11-001-001-A01 & 51-42-21-001-001-A01.SDR REXA2021120701085Seat Track · corrodedCABIN FLOOR SEAT TRACK @ RBL 9 BEGINNING AT APPROX. FS 349.00 CORRODED IN SEVERAL LOCATIONS. C/A: REMOVED AND REPLACED SEAT RAIL IAW CRJ 900 AMM 53-00-49-000/400-801-A07..SDR REXA2021120701084Seat Track · corrodedCABIN FLOOR SEAT TRACK @ LBL9 BEGINNING AT APPROX. FS364.00 CORRODED IN SEVERAL LOCATIONS. C/A: REMOVED, FABRICATED AND REPLACED SEAT RAIL IAW CRJ 900 AMM 53-00-49-000/400-801-A07 & SRM 53-00-49-201-002-A01.SDR REXA2021120701063Intercostal · corrodedCORROSION ON INTERCOSTAL AT F.S.333 TO F.S.364 AT STGR 20R. C/A: REMOVED AND REPLACED INTERCOSTAL IAW CRJ 900 SRM 51-40-11-001-001-A01 & 51-42-06-001-001-A01.SDR REXA2021120701062Web · corrodedAFT MID WEB PROTECTOR (FITTING) AT GALLEY SERVICE DOOR SURROUND IS CORRODED. C/A: REMOVED AND REPLACED AFT MID WEB PROTECTOR (FITTING) IAW CRJ 900 SRM 51-40-11-001-001-A01, 51-42-06-001-001-A01 & 51-42-21-001-001-A01.SDR REXA2021120701061Plate · corrodedSERRATED PLATES (FWD & AFT) AT GALLEY SERVICE DOOR SURROUNDS ARE CORRODED. C/A: REMOVED AND REPLACED SERRATED PLATES IAW CRJ 900 AMM 53-21-27-000/400-802-A021SDR AALA202111109412Fitting · wornAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND MAIN LANDING GEAR DOOR ACTUATOR FITTING AT KEEL BEAM AFT LUG BORE WORN. REPLACED FITTING PER EA 331565.NOTE: THIS EVENT WAS PREVIOUSLY SUBMITTED ON AALA202110286979.SDR AALA202111094462None · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION, MEASURING L=0.357 IN, W= 0.236 IN, D= 0.0265 IN, ON PASSENGER CABIN LEFT HAND LOWER SILL LOCATED FROM FR67 TO FR68 AND S23L. REPAIRED SILL POER SRM 53-41-14-300-001.SDR SWAA2021110333488Scuff Plate · crackedAFT CARGO SCUFF PATE HAS A CRACK .(AFT PLATE) ; / [01] SCUFF PLATE WAS SENT TO J.L WELDING FOR REPAIR AND RECEIVED SERVICEABLE. ITEM WILL BE INSTALLED ON CUSTOMER CARD #TTG8Q0032CYS.; [02] VERIFIED 1.SDR REXA2021122001143None · corrodedCABIN FLOOR SEAT TRACK LBL27.0 FS375 IS CORRODED AND HAS SCRATCHES / GOUGES FS364 TO FS410. C/A: REMOVED AND REPLACED SEAT TRACK IAW CRJ 900 AMM 53-00-49-400-801-A07 AND SRM 53-00-49-201-002-A01.SDR REXA2021120701093Seat Track · corrodedCORROSION ON FLOOR SEAT TRACK AT LBL9 FS693.00 TO FS 830.00. C/A: REMOVED, FABRICATED AND INSTALLED SEAT RAIL IAW CRJ 900 SRM 53-00-49-001-0014-A01, 51-40-11-001-001-A01 AND CRJ 900 AMM 53-00-49-000/400-801-A07.SDR REXA2021120701083Seat Track · corrodedCABIN FLOOR SEAT TRACK AT LBL27 FROM FS364 HAS MULTIPLE AREAS OF CORROSION. C/A: REMOVED AND REPLACED SEAT RAIL IAW CRJ 900 AMM 53-00-49-000/400-801-A07SDR REXA2021120701077Seat Track · corroded1 EA SEGMENT OF RH SIDEWALL SEAT TRACK HAVE MULTIPLE SPOTS OF CORROSION FROM FS 744 TO FS 752. C/A: REMOVED AND REPLACED SEAT RAIL IAW CRJ 900 AMM 53-00-49-000/400-801-A07.SDR REXA2021120701065Seat Track · corrodedRH SIDE SEAT RAIL FS565-FS661 HAS SCRATCHES, WORN AND CORRODED C/A: REMOVED AND REPLACED SEAT RAIL IAW CRJ 900 AMM 53-00-49-000/400-801-A07SDR REXA2021120701051Stringer · corrodedSTRINGER 19R HAS CORROSION FS 310 TO FS 349. C/A: REMOVED AND REPLACED STRINGER IAW CRJ 900 SRM 51-42-06-001-001-A01 AND 51-42-21-001-001-A01.SDR SWAA2021111133096Seat Track · corrodedCAPTAINS OUTBOARD FWD SEAT TRACK IS CORRODED ; / [01] RECEIVED AND INSTALLED NEW CAPTAINS OUTBOARD FWD SEAT TRACK IAW AMM 25-11-11-400-801.; [02] VERIFIED CORRECTIVE ACTION 1.SDR SWAA2021111133098Seat Track · corrodedFIRST OFFICERS OUTBOARD FWD SEAT TRACK IS CORRODED ; / [01] RECEIVED AND INSTALLED NEW F/O'S OUTBOARD FWD SEAT TRACK IAW AMM 25-11-11-400-801.; [02] UPDATED MEASUREMENT FIELDS.; [03] VERIFIED CORRECTIVE ACTION 1.SDR SWAA2021111133097Seat Track · corrodedCAPTAINS INBOARD FWD SEAT TRACK IS CORRODED ; / [01] RECEIVED AND INSTALLED NEW CAPTAINS INBOARD FWD SEAT TRACK IAW AMM 25-11-11-400-801.; [02] VERIFIED CORRECTIVE ACTION 1.SDR SWAA2021111133099Seat Track · corrodedFIRST OFFICERS INBOARD FWD SEAT TRACK IS CORRODED ; / [01] RECEIVED AND INSTALLED NEW F/O'S INBOARD FWD SEAT TRACK IAW AMM 25-11-11-400-801.; [02] VERIFIED CORRECTIVE ACTION 1.SDR SWAA2021110533107None · elongatedCAP STRIP FOR PANELS 122DW AND 122EW HAS ELONGATED HOLES . ; / [01] REMOVED AND REPLACED CAP STRIP IN REF TO AMM 25-52-06SDR FDEA202110242603Support Channel · crackedR/H W/W FWD CUTOUT STA 1060 SEAL RETAINER CHANNEL CRACKED REMOVED AND REPLACED PER DWG 149N7550 REV HSDR SWIA2022010563497Bracket · corrodedMACHINE BRACKET HAS CORROSION LOCATED BETWEEN FS 581 -597 STRG LH 23-22 AS MARKED. (C-CHECK RO 1/7/2022) MACHINED BRACKET P/N SH670-33390-2 LOCATED BETWEEN FS581.00-FS597.00 AND STGR22LH-23LH WAS REMOVED AND REPLACED WITH A NEW PART IAW CRJ700 SRM 51-SDR FDEA202110232602Channel · crackedRWW FWD CUTOUT STA 1060 SEAL RETAINER CHANNEL CLIP CRACKED 35" IN OB REMOVED AND REPLACED SUPPORT BRACKET R/H W/W STA 1060 IAW FEDEX B757 DWG 149N7550 REV: H AND SRM 51-40-02 AND SEAL RETAINER CHANNELSDR REXA2021120701090Seat Track · corrodedCORROSION ON FLOOR SEAT TRACK AT LBL 27 FROM FS 485 TO FS 581. C/A: REMOVED AND REPLACED SEAT TRACK IAW CRJ 900 AMM 53-00-49-000/400-801-A19.SDR REXA2021120701088Seat Track · corrodedCORROSION ON FLOOR SEAT TRACK AT RBL 9 FROM FS 661+32 TO FS 693. C/A: REMOVED AND REPLACED SEAT TRACK IAW CRJ 900 AMM 53-00-49-000/400-801-A19.SDR REXA2021120701082Seat Track · corrodedL/H SIDE WALL SEAT TRACK HAS MULIPTLE SPOTS OF CORROSION FROM FS 927 TO FS 985. C/A: REMOVED AND REPLACED SEAT TRACK IAW CRJ 900 AMM 53-00-49-000/400-801-A19 AND SRM 53-00-49-201-002-A01.SDR REXA2021120701080Seat Track · corrodedL/H SIDE WALL SEAT TRACK HAS MULIPTLE SPOTS OF CORROSION FROM FS 785 TO FS 847+32. C/A: REMOVED AND REPLACED SEAT TRACK IAW CRJ 900 AMM 53-00-49-000/400-801-A19 AND SRM 53-00-49-201-002-A01.SDR REXA2021012071073Seat Track · corrodedLBL 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.SDR AALA202111154203Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE CRACKED AFT FLOOR STRUCTURE SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S 23L. REPLACED SHEAR PLATE PER SRM 51-42-11.SDR AALA202111085621None · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION, MEASURING L= 0.677 IN, W= 0.570 IN, D= 0.048 IN, ON PASSENGER CABIN LOWER RIGHT HAND SILL LOCATED FROM FR 67 TO FR 68 AT LEVEL S23R. REPAIRED SILL PER SRM 53-41-14-300-001.SDR REXA2021110400929Intercostal · damaged"FOUND IN 70R COSTAL DAMAGED @ FWD END BETWEEN STR 23L AND 22L FS
501-THRU 517.
" "CLEANED REPAIR AREA AND CIC BAYS BETWEEN STGR 23L TO 22L AND FS 501
THRU 517 IAW CRJ 900 SRM 51-26-00-001-001-A01 AND 51SDR REXA2021111700995Channel · crackedSTRAP ASSY ON PANEL 195DL IS CRACKED. - DRILLED, LOCATED, INSTALLED & MODIFIED C-CHANNEL IAW CRJ 900 SRM 51-42-13-001-001-A01, 51-40-11-001-001-A01, & BOMBARDIER IS 670538200021.SDR REXA2021111600964Seat Track · corrodedAFT CARGO BAY SEAT TRACK AT RBL9 BEGINNING AT APPROX. FS 985.00 CORRODED. - REMOVED SEAT TRACK, FABRICATED SEAT TRACK & INSTALLED SERVICEABLE SEAT TRACK IAW CRJ 900 SRM 53-00-49-201-002-A01 & 51-40-11-001-001-A01 & AMM 53-00-49-000/400-801-A07. WVAC EMP STAMP SDR REXA2021111600956Intercostal · corrodedSERVICE DOOR SURROUND STRUCTURE, INTERCOSTAL CORRODED BETWEEN FS 295 AND FS 333 AT STGR 20R. - REMOVED INTERCOSTAL AT RBL27 FOR ACCESS & INSTALLED, REMOVED & INTERCOSTAL AT 20R IAW CRJ 900 SRMS 51-42-21-001-001-A01, 51-42-06-001-001-A01, 51-40-11-001-001-A01, SDR REXA2021111600955Intercostal · corrodedPAX DOOR SURROUND STRUCTURE, INTERCOSTAL CORRODED AT STGR 20L BETWEEN FS 310 AND FS 349. - REMOVED, UNSERVICEABLE INTERCOSTAL, DRILLED & LOCATED & INSTALLED NEW SERVICEABLE INTERCOSTAL IAW CRJ 900 SRM'S 51-40-11-001-001-A01, 51-42-06-001-001-A01, & REINSTALLED
Back to JASC 5320