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 SCNA20240508234Web · corrodedDEFECT NRC00180: CORROSION ON WEB AT AFT WET AREA BS1016+10 LBL20 WL208. WORK TO BE ACCOMPLISHED ON CUSTOMER CARD ID 00210.SDR SWI2023F00490Unknown · corrodedPAX DR CLEAT ON LOWER CHANNEL FS320 HAS CORROSION (C-CHECK RO 11/21/2023) REMOVED AND INSTALLED NEW REPLACEMENT CLIP P/N 600-31902-276 AT PAX DOOR FRAME FS.320 & LWR CHANNEL REF. CRJ200 SRM 51-42-06 & BOMBARDIER DWG. 600-31902 REV. Y . COMPLIED WITH 51-SDR SWI2023F00489Unknown · corrodedPAX DR AFT INTERCOSTAL DD3 HAS CORROSION (C-CHECK RO 11/21/2023) REMOVED AND INSTALLED NEW AFT DD3 INTERCOSTAL REF DWG 601R31702 REV N AND CRJ 200 SRM 51-42-06. COMPLIED WITH 51-900-1003-SKY AND PRESSURE CHECKS GOOD . SEE CONTINUATION CARD FOR DETAILSSDR AALA202311201211Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED INTERCOSTAL FITTING FASTENER HOLE H3 OF DOOR STOP #7 AND FR 16 RIGHT. REPLACED INTERCOSTAL FITTING PER SRM 51-42-11.SDR AALA202311167695Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED INTERCOSTAL FITTING AT FR 16 BETWEEN S21L AND S22L AT DOOR STOP #1 FASTENER HOLE #3. REPLACED INTERCOSTAL FITTING PER SRM 51-42-11.SDR AALA202311154107Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED INTERCOSTAL FITTING FASTENER HOLE H3 FOR DOOR STOP #7 AT FR 16 BETWEEN S10L AND S11L. REPLACED INTERCOSTAL FITTING PER SRM 51-42-11.SDR AALA202311132429Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23L. REPLACED SHEAR PLATE PER SRM 51-42-11.SDR AALA202311087534Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CENTER FITTING AT AFT GALLEY AREA LOCATED BETWEEN FR 66 AND FR 68, STR 23R. REPLACED CENTER FITTING PER SRM 51-42-11-801.SDR SWAA2023110703896Floor Support · crackedCABIN FLOOR SUPPORT INTERCOSTAL IS CRACKED BETWEEN B/S 328-344 46 INCHES LEFT OF CENTER LINE<[01] REMOVED & REPLACED CABIN FLOOR SUPPORT INTERCOSTAL BETWEEN B/S 328-344 ; 46 INCHES LEFT OF CENTER LINE REF. SRM 51-40-02-0G-0;[02] VERIFIED STEP 1;[03] VERIFIED SSDR SWAA2023110703888Angle · corrodedCORROSION BETWEEN STA 291.5 TO STA 344; LBL 64 AND WL 208.1<[01] REMOVED UPPER CORD ANGLE BETWEEN STA291.5 TO STA 344;LBL64 WL 208.1;LOCATED AND DRILLED REF:SRM 51-40-02-OG-0;[02] REMOVED UPPER CHORD ANGLE BETWEEN STA 291.5 TO STA 344; LBL 64 AND WL 208.1 AS PSDR SWAA2023110703897Angle · corrodedL1 DOOR SILL LOWER INNER ANGLE AT LBL56 HAS CORROSION.<[01] REMOVED LOWER ANGLE CORROSION FOUND TO BE OUT OF LIMITS; REMOVED L1 DOOR SILL LOWER INNER ANGLE AT LBL56 AS PER SRM-51-40-02-0G-0.LOCATED; DRILLED AND COUNTERSUNK NEW FASTENER HOLESTREATED AND PRIMED SDR SWAA2023110703889Unknown · corrodedCORROSION FROM STA 348 TO 358 LBL 64 WL 208.1; SEE DOT # 036<[01] LOWER SILL INNER CHORD WAS REPLACED ON ( TTG8Q00NLVSX );[02] VERIFIED CHORD REPLACED ON TTG8Q00NLVSXSDR SWAA2023110703890Unknown · corrodedCORROSION AT STA 350; RBL 64; WL 208.1; SEE DOT # 040<[01] INNER CHORD AT STA 350 RBL 64 WAS REPLACE ON TTG8Q00NL8SG;[02] VERIFIED INNER CHORD WAS REPLACED ON TTG8Q00NL8SGSDR SWAA2023110703892Intercostal · crackedCRACK FOUND AT STA 348.2; BL 0; WL 208.1; SEE DOT # 037 CRACKED INTERCOASTAL FOUND AT STA 348.2 BL 0 WL 208.1 SEE DOT # 037<[01] REMOVED AND INSTALLED NEW INTERCOSTAL AT STA 348.2; BL 0; WL 208.1 AS PER DWG #141A5410 AND SRM-51-40-02-0G-0.;[02] VERIFIED STEP :SDR SWAA2023110703895Floor Support · crackedCABIN FLOOR SUPPORT INTERCOSTAL IS CRACKED BETWEEN B/S 277-294.5 AT CENTER LINE<[01] REMOVED AND INSTALLED NEW FLOOR SUPPORT PART#141A5410 PO#2035568 AT MAIN CABIN B/S 277-294.5 AT CENTER LINE SEALANT MIX AT 10:15 A.M 10/04/23; SQUEEZE OUT TIME IS 12:15 A.M 10SDR AALA202311060667Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN SHEAR PLATE IN AFT GALLEY AREA LOCATED BETWEEN FR 69 TO FR 70 AND AT STR 23R. REPLACED SHEAR PLATE PER SRM 51-72-11-911-001.SDR SWAA2023110103579Channel · corrodedAFT CARGO COMPARTMENT RIGHT SIDE; FLOOR STRUCTURE 'Z CHANNEL' AROUND HOLES HAS EVIDENCE CORROSION BETWEEN STA767 TO STA787; WL 155.5; RBL-21<[01] REMOVED AND REPLACED SHIELD AT AFT CARGO COMPT STA 767-787 RBL 21 PER SRM 51-40-02-0G-0 AND DWG# 146A8127.;[02] RISDR AALA202310316928Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT AFT PASSENGER / CREW DOOR CUTOUT LOWER CENTER SHAPE FITTING BETWEEN FR 66 AND FR 68 AT S23L. REPLACED CENTER SHAPE FITTING PER SRM 51-72-11.SDR SWAA2023103003811Cargo Track · crackedCRACK CARGO TRACK LOCATED BS727E AT LEVEL RBL13.84 AT AFT CARGO COMPARTMENT 2023-594333<[01] TOOL USED ET EQUIPMENT: P/N: NORTEC 600D; S/N: 210138203; CAL DUE DATE: 09-JUN-24;[02] PERFORMED PERMANET REPAIR ON CARGO TRACK LOCATED BS727E AT LEVEL RBL13.84 AT AFTSDR SWAA2023103003813Angle · crackedCRACK ANGLE LOCATED BS907 TO BS927 AT LEVEL STR26R AT AFT CARGO COMPARTMENT 2023-594337<[01] REPLACED ANGLE AND FASTENERS LOCATED BS907 TO BS927 AT LEVEL STR26R AT AFT CARGO COMPARTMENT IAW B737-700 SRM 51-10-02 ITEM 9 AND DWG 147A7221 SHEET 24 REV - SEE INDIVSDR SWAA2023102303775Floor Support · corrodedAFT CARGO FLOOR SUPPORT AT B/S 771 22 INCHES RIGHT OF CENTER LINE IS CORRODED AT NUT PLATE HOLE<[01] WORK WAS ACCOMPLISHED PER TASK CARD TTG8Q00NM3MM;[02] VERIFIED STEP 1SDR FDEA202309231786Web · crackedFWD CARGO COMPT WAS FOUND A WEB CRACK AT STGR44LH, FR20 POS REMOVED CRACK WEB AND INSTALLED NEW WEB I.A.W A300-600F SRM 51-72-10-001, PAGE.2 AND 51-40-21-001, PARA.6, P.7B-P.23SDR AALA202309273514Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT AFT PASSENGER / CREW DOOR CUTOUT LOWER SILL AT FR 68 AND S23R. REPAIRED LOWER SILL PER SRM 53-41-14-300-001 REPAIR PRINCIPLE 5.SDR AALA202309278790Splice · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR PANEL SPLICE TEE ASSEMBLY LOCATED AT BS 727I BETWEEN S25L AND S25R. REPLACED TEE SPLICE ASSEMBLY PER SRM 51-40-02-0G.SDR AALA202309279600Support Bracket · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT REAR BULKHEAD SUPPORT BRACKET LOCATED AT BS 947.5 AND S27R. REPLACED BRACKET PER SRM 51-40-02-0G.SDR AALA202309277389Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED BETWEEN BS 727I AND BS 767 AT S25R. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-6.SDR AALA202309278153Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED BETWEEN BS 727A AND BS 767 AT S25R. REPLACED TRANSITION PANEL PER SRM 51-40-02.SDR AALA202309277248Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 727E TO BS 767 AT S25L. REMOVED AND REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202309261486Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT AFT PASSENGER / CREW DOOR CUTOUT LOWER CENTER SHAPE FITTING BETWEEN FR 66 AND FR 68 AT S23R. REPLACED CENTER SHAPE FITTING PER SRM 51-42-11.SDR DALA2023092507902Unknown · unknownSHIP 0668 CRACK ON STIFFENER BWT STA 560 LBL 45 AT FWD CARGO COMPARTMENT. CORRECTIVE ACTION: SUMMARY OF NRC 00411: STIFFENER BWT STA 560 LBL 45 WAS REAPIRED PER B757-200 SRM 53-00-51. (2984177)SDR DALA2023092507860Unknown · unknownCORROSION ON CUSP WEB STA Y=680 X=-50, AT CABIN PAX. SUMMARY OF NRC 00619: CORROSION LEVEL 2. CUSP WEB BTW STA 655 TO STA 684 X=-50 AT CABIN PAX WAS REPAIRED PER B717 SRM 53-00-55-2R-4 PAR 4 AND 5 FIGURE 223. (LP #2983819)SDR DALA2023092507859Unknown · unknownCORROSION ON CABIN FLOOR CUSP WEB UPPER AND LOWER FACE BTW STA=541 TO 560 FROM X=-58 TO X=-54, STA=598 TO 617 FROM X=-58 TO X=-54, STA=620 TO 630 FROM X=-58 TO X=-54, STA=636 TO 655 FROM X=-55 TO X=-46, AND BTW STA=655 TO STA=674 FROM X=-55 TO X=-46 RH SIDE ATSDR DALA2023092507858Unknown · unknownCORROSION ON CUSP WEB DOUBLERS (5 EA) RH SIDE; (4 EA) BTW STA Y=503 AND STA Y=579 ON X=-56 AND (1 EA) BTW STA Y=794 AND STA Y=813 ON X=-56 AT PAX CABIN. SUMMARY OF NRC 00323: CORROSION LEVEL 2. CUSP WEB DOUBLERS (5 EA) RH SIDE; (4 EA) BTW STA Y=503 AND STA Y=5SDR JR2R20230923999Seal Depressor · corrodedFWD CARGO CUT OUT AFT SEAL DEPRESSOR CORRODED AROUND SCREW HOLESSDR JR2R20230923899Seal Depressor · corrodedFWD CARGO CUT OUT CENTER SEAL DEPRESSOR CORRODED AROUND SCREW HOLESSDR JR2R20230923869Seal Depressor · corrodedFWD CARGO CUT OUT FWD SEAL DEPRESSOR CORRODED AROUND SCREW HOLESSDR SCNA20240311151Web · corrodedCORROSION ON WEB AT AFT WET AREA BS1016+6 RBL16 WL208. CORROSION ON WEB AT AFT WET AREA BS 1016 + 6 RBL 16 WL 208. WORK TO BE ACCOMPLISHED ON CUSTOMER CARD ID 00213. 728596 INTERIOR 5061 ATTACHED COPYSDR SCNA20240311150Web · corrodedCORROSION ON WEB AT AFT WET AREA BS1016 TO BS1016+12 RBL6 TO RBL16 WL208. CORROSION ON WEB AT AFT WET AREA BS 1016 TO BS 1016 + 12 RBL 6 TO RBL 16 WL 208 WORK TO BE ACCOMPLISHED ON CUSTOMER CARD ID 00213, 728596 INTERIOR 5061 ATTACHED COPYSDR SCNA20240309096Floor Support · deformedSCRATCH MARKS ON AFT WET AREA FLOOR SUPPORT BS947+4 LBL18 TO LBL38 WL208. REMOVED & REPLACED THE DAMAGED FLOOR SUPPORT AT THE AFT WET AREA BS947+4 LBL18 TO LBL38, W/L208 IAW SRM 51-40-02 & DWG #147A5650SDR SCNA20240309095Floor Support · corrodedCORROSION ON FLOOR SUPPORT AT AFT WET AREA BS947+3 RBL47 WL208. REMOVED & REPLACED THE DAMAGED FLOOR SUPPORT #147A5676-6 IAW SRM 51-40-02 & DWG #147A5650 BS 947 + 3 RBL 47, W/L 208SDR SCNA20240309094Floor Support · corrodedCORROSION ON FLOOR SUPPORT AT AFT WET AREA BS947+10 LBL50 WL208. REMOVED & REPLACED THE DAMAGED FLOOR SUPPORT AT AFT WET AREA BS 947 + 10 LBL 50, W/L 208 IAW SRM 51-40-02 & DWG #147A5650SDR SCNA20240309093Floor Support · corrodedCORROSION ON FLOOR SUPPORT AT AFT WET AREA BS947+15 LBL25 WL208. REMOVED & REPLACED THE DAMAGED FLOOR SUPPORT AT AFT WET AREA BS 947 + 15 LBL 25 W/L 208 IAW SRM 51-40-02 & DWG #147A5650SDR SCNA20240309092Floor Support · mechanic errorFLOOR SUPPORT HAS MISS DRILL AT AFT WET AREA BS984 RBL15 WL208. REMOVED AND REPLACED FLOOR SUPPORT BTW B/S 967.00 TO B/S 986.50 RBL16. WL208 DUE TO FOUND OUT ALLOWABLE DAMAGE LIMITS IAW SRM 51-40-02 AND DWE 140A9870 REV:B.SDR SCNA20240309090Web · corrodedCORROSION ON WEB AT AFT WET AREA BS987+2 LBL44 WL208. FOUND CORROSION ON WEB AT BS 987 + 2, LBL 44, WL208 TO BE OUT OF LIMITS DUE TO NO ALLOWABLE DAMAGE LIMITS FUOND IN THE SRM. WEB IS REPAIRABLE BY REPLACEMENT. REMOVED AND REPLACED WEB AT AFT WET ATEA, BS 987SDR SCNA20240309089Web · corrodedCORROSION ON WEB AT AFT WET AREA BS987+2 RBL32 WL208. REMOVED & REPLACED THE DAMAGED WEB AT AFT WET AREA BS987 + 2, RBL 32 W/L 208 TO 1016 RBL 44 IAW SRM 51-40-02-OG-0 & DWG #147A5700SDR SCNA20240309088Web · corrodedCORROSION ON WEB AT AFT WET AREA BS1016+4 RBL25 WL208. REMOVED AND INSTALLED NEW WEB AT AFT WET AREA BS 1016 + 4 RBL 25, WL 208 P/N 147A5712-4 I.A.W. ASRM 51-40-02-OG-0 DWG NO 147A5700SDR SCNA20240309086Strap · corrodedCORROSION ON TENSION STRAP AT AFT WET AREA BS1016+4 LBL27 WL208. REMOVED AND INSTALLED NEW STRAP AT AFT WET AREA BS 1016 + 4, LBL 27, WL 208 P/N 147A5714-3 I.A.W. SRM 51-40-02-OG-0 DWG NO 147A5700SDR SCNA20240309085Web · corrodedCORROSION ON WEB AT AFT WET AREA BS1016 TO BS1016+14 LBL5 TO LBL16 WL208. REMOVED AND INSTALLED NEW WEB AT AFT WET AREA BS 1016 + 4, LBL5 - LBL16 WL208 P/N147A5712-5 I.A.W. ASRM 51-40-02-OG-0 DWG NO 147A5700SDR SCNA20240309084Strap · corrodedCORROSION ON TENSION STRAP AT AFT WET AREA BS1016+4 LBL17 WL208. REMOVED AND INSTALLED NEW STRAP AT AFT WET AREA BS 1016 + 4, LBL 17, WL 208 P/N 147A5714-4 I.A.W. SRM 51-40-02-OG-0 DWG NO 147A5700SDR SCNA20240309083Strap · corrodedCORROSION ON TENSION STRAP AT AFT WET AREA BS1016+4 LBL3 WL208. REMOVED AND INSTALLED NEW STRAP AT AFT WET AREA BS 1016 + 4, LBL 3, WL 208 P/N 147A5714-5 I.A.W. SRM 51-40-02-OG-0 DWG NO 147A5700
Back to JASC 5320