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 IPXA2024010935666Unknown · unknownCRACKED ANGLE, MAIN EQUIPMENT CENTER LEFT SIDE AT STA 246 LBL (REPLACE) OK TO WORKSDR IPXA2024010935810Unknown · unknown*** SDR FILED OPEN *** FAULT - CRACK - ANGLE BULK CARGO COMPARTMENT RIGHT SIDE STA 1578 RBL 60 OUTBOARD SIDE (REPLACE) OK TO WORKSDR IPXA2024010935744Unknown · unknownCRACK - ANGLE BULK CARGO COMPARTMENT RIGHT AREA STA 1578 RBL 60 INBOARD SIDE (REPLACE) OK TO WORKSDR IPXA2024010935793Unknown · unknown*** SDR FILED OPEN *** FAULT - CRACK - ANGLE BULK CARGO COMPARTMENT LEFT SIDE STA 1578 LBL 60 OUTBOARD SIDE (REPLACE) OK TO WORKSDR IPXA2024010935775Unknown · unknown*** SDR FILED OPEN *** FAULT - CRACK - ANGLE, BULK CARGO COMPARTMENT LEFT AREA STA 1578 LBL 60 INBOARD SIDE (REPLACE) OK TO WORKSDR REXA2024102500962Diaphragm · crackedWHILE COMPLYING WITH SB 670SH-53-043 REV C WE HAVE DISCOVERED L/H FS 768 DIAPHRAGM TO BE CRACKED AT LOWER BEAM TO DIAPHRAGM LOCATION ON THE I/B VERTICAL FACE. DRILLED AND INSTALLED NEW SERVICEABLE L/H DIAPHRAGM FS 768 PN SH670-36145-5 IAW CRJ-900 SRM 51-40-11-SDR SWAA2024020838453Floor Support · crackedINTERCOSTAL CRACKED AT FWD WET AREA LBL 11 BETWEEN BS 344 AND BS 360.<[01] REMOVED AND REPLACED INTERCOSTAL AT FWD WET AREA LBL 11 BETWEEN BS 344 AND BS 360 PER REF B737 SRM-51-40-02-0G-0 AND DWG-141A5400.;[02] FINAL INSPECTION; VERIFIED STEP #1.SDR SWAA2024020838454Floor Support · crackedINTERCOSTAL CRACKED AT FWD WET AREA LBL 13 BETWEEN BS 380 AND BS 400.<[01] REMOVED AND REPLACED CRACKED INTERCOSTAL AT FWD WET AREA LBL 13 BETWEEN BS 380 AND BS 400 AS PER SRM 51-40-02-0G-0 AND DWG#143A5400.;[02] VERIFIED REMOVED AND REPLACED CRACKED INTERCOSTSDR SWAA2024020838452Floor Support · crackedCORROSION AT FWD WET AREA INTERCOSTAL LOCATED AT LBL 11 BETWEEN BS 294 AND BS 312.<[01] REMOVED AND REPLACED INTERCOSTAL LOCATED AT LBL 11 BETWEEN STA 294.5 AND STA 312 REF B737-700 SRM 51-40-02-0G-0 AND DWG# 141A5600.;[02] FINAL INSPECTION; VERIFIED STEP #1.SDR SWAA2024020839134Threshold · corrodedACB CENTER THRESHOLD IS CORRODED AT BS 787+12 - 827+8; RBL 24-29; WL 157<[01] CORRECTION: UPDATED PART NUMBER ON MEASUREMENT TABLE;[02] REMOVED AND REPLACED ACB SUB-THRESHOLD WEB IAW SRM 51-40-02-0G-0SDR SWAA2024012939233Bracket · crackedPANEL 551FB BRACKET CRACKED FWD I/B AREA<[01] REPLACED BRACKET PER SRM 51-40-02.;[02] INSPECTION C/W FOR CA #1SDR R61A2024012600051Support Angle · corrodedCORROSION FOUND ON FLOOR SUPPORT ANGLE AT FR 76 STGR 22L-23L. REMOVED AND REPLACED FLOOR SUPPORT ANGLE AT FR 76 BETWEEN STGR 22L-23L AND RESTORED SURFACE PROTECTION TO FASTENERS PER SRM 51-40-08, 51-23-06 AND CPM 51-25-00SDR SWAA2024011738527Scuff Plate · crackedAFT CARGO BAY FWD CORNER SCUFF PLATE IS CRACKED<[01] UPDATED MEASUREMENT TABLE;[02] REPAIR SCUFF PLATE IAW SRM 53-60-15-2R-1;[03] VERIFIED MEASUREMENTS TABLE.SDR A6WA202401088693Strap · corrodedCORROSION ON FLOOR STRUCTURE RH STRAP PN 601R31025-29 AT FS 559.00 AND RBL27 - 42. ***** AIRCRAFT REMOVED FROM SERVICE *****SDR A6WA202401088694Strap · corrodedCORROSION ON FLOOR STRUCTURE RH STRAP PN 601R31025-29 AT FS 559.00 AND LBL27 - 45. AIRCRAFT REMOVED FROM SERVICE. REMOVED AND INSTALLED FLOOR STRUCTURE RH STRAP PN 601R31025-29 AT FS 559.00 AND LBL27 - 42 WITH FABRICATED NEW STRAP WITH MATERIAL 7075-T6, TSDR AALA202401109235Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT GALLEY AREA FLOOR STRUCTURE SUPPORT Z ANGLE AT STA 992, RBL 30. REPLACED SUPPORT ANGLE PER AARD 51-00-05-1.SDR DALA2024010900385Unknown · unknownSHIP 1603 FLOOR BEAM LWR STRAP BETWEEN STA 325 AND STA 347 ,RBL 11 FOUND CRACK. CORRECTIVE ACTION: DAMAGED AREA REPAIRED PER ERA 614334-14. (0144893)SDR VNAA20240214004Door Sill · corrodedCORROSION ON AFT CARGO COMPARTMENT DOOR SILL BTW FS 1000.00 TO FS 1047.00, BTW STGR 17LH AND STGR 18LH. (SM) DOOR SILL BTW FS 1000.00 TO FS 1047.00, BTW STGR 17LH AND STGR 18LH WAS REPLACED PER CRJ 900 SRM 51-42-06-001-001-A01 PAR. 6.C. CRJ 900 SRM 51-42-10-SDR VNAA20240212004Bracket · corrodedCORROSION ON BRACKET MACHINED (4EA) AT INTERNAL STRUCTURE FWD BAGGAGE BAY CARGO BELOW FLOOR BETWEEN STGR 23RH/23LH AND FS501.00 TO FS661.00+32.00. BRACKET MACHINED (4EA) AT INTERNAL STRUCTURE FWD BAGGAGE BAY CARGO BELOW FLOOR BETWEEN STGR 23RH/23LH AND FS501SDR SWAA2024020938771Intercostal · crackedCRACK ON INTERCOSTAL LOCATED BTW BS 294.5 TO BS 303.9 AT LEVEL STAR 16L AT FWD GALLEY AREA 2023-786075<[01] REPLACED INTERCOSTAL LOCATED BTW BS 294.5 TO BS 303.9 AT LEVEL STAR 16L AT FWD GALLEY AREA IAW B737-700 SRM 51-10-02 Ï¿½TEM 9; SRM 51-40-02 AND DWG 141ASDR SWAA2024020938772Floor Support · corrodedCORROSION ON INTERCOSTAL LOCATED BTW BS 294.5 TO BS 312 LBL 7 WL 208.1 AT FWD GALLEY AREA 2023-786078<[01] REPLACED INTERCOSTAL LOCATED BTW BS 294.5 TO BS 312 LBL 7 WL 208.1 AT FWD GALLEY AREA. IAW B737-700 SRM 51-40-02 ; SRM 51-10-02 ITEM 9 AND DWG: 141A5600 SDR SWAA2024020838761Scuff Plate · crackedCRACK FWD CORNER SCUFF PLATE AT FWD CARGO COMPARTMENT 2023-786060<[01] TOOL USED DIGITAL CALIPER P/N 500-193-30. S/N 0037632 DUE DATE 12-OCT-24;[02] TOOL USED P/N XRP 3000; S/N 1753759; DUE DATE 12-APR-24 STEP 4;[03] REPAIRED FWD CORNER SCUFF PLATE AT FWD CARGSDR SWAA2024020838777Web · crackedCRACK ON WEB LOCATED BTW BS 312 TO BS 328 LBL 46.5 WL 208.1 AT FWD GALLEY AREA 2023-786080<[01] REPLACED WEB AND FASTENERS LOCATED BETWEEN BS312 TO BS328 LBL46.5 WL208.1 IAW B737-700 SRM 51-40-02 AND DRAWING 141A5400 SHEET 26 REV ?.SEE INDIVIDUAL STEP SIGNOFF SDR SWAA2024020838779Angle · crackedCRACK ON ANGLE LOCATED BTW BS 291.5 TO BS 294.5 AT LEVEL STR 17R AT FWD GALLEY AREA 2023-786084<[01] REPLACED ANGLE LOCATED BTW BS 291.5 TO BS 294.5 AT LEVEL STRINGER 17R AT FWD GALLEY AREA. IAW B737-700 SRM 51-40-02 DWG # 141A8310 SHEET 25. ?SEE INDIVIDUAL SISDR SWAA2024020838773Web · crackedCRACK ON WEB LOCATED BTW BS 277 TO BS 294.5 RBL 5 WL 208.1 AT FWD GALLEY AREA 2023-786081<[01] REPLACED WEB AND FASTENERS LOCATED BTW BS 277 TO BS 294.5 RBL 5 WL 208.1 AT FWD GALLEY AREA IAW B737-700 SRM 51-10-02 ITEM 9 AND DWG 141A5400 REV. -<BR>SEE INDIVIDUASDR SWAA2024020838778Floor Support · corrodedCORROSION ON INTERCOSTAL LOCATED BTW BS 344 TO BS 360 RBL 35 WL 208.1 AT FWD GALLEY AREA 2023-786083 CRACK ON INTERCOSTAL LOCATED BTW BS 344 TO BS 360 RBL 35 WL 208.1 AT FWD GALLEY AREA<[01] REPLACED INTERCOSTAL LOCATED BTW BS 344 TO BS 360 RBL 35 WL 208.1 AT SDR VNAA202401210001Bracket · corrodedCORROSION ON BRACKETS, MACHINED (5EAS) OF INTERNAL STRUCTURE AT FWD CARGO COMPARTMENT. DUE TO STRUCTURE NO DAMAGE ALLOWED PER CRJ900 SRM 51-42-22-001-001-A01 AND CRJ900 SRM 51-42-21-001-001-A01 AND DETAILED VISUAL INSPECTION OF THE BRACKET MACHINE (1EA) ATSDR ASAA2024011747345Intercostal · crackedFWD WET AREA INTERCOSTAL STA 312 TO 328 LBL 45 IS CRACKED. GROUNDED - YES. REMOVED AND REPLACED INTERCOSTAL IAW B737-900ER SRM 51-40-02-0G-0.SDR CALA2024011700120Floor Support · corrodedMAIN CABIN FLOOR BEAM Y254 HAS CORROSION FR20 TO FR21 REMOVED AND REPLACED CABIN FLOOR BEAM I.A.W SRM 51-42-11. EMP: V 934614 WC: 78369 STA: ST ENG BFMSDR DALA2024010900389Unknown · unknownSHIP 6717 CORROSION FOUND ON STRAP BELOW FLOOR PANEL AT C2 DOOR CUTOUT THRESHOLD. STA 1380 TO STA 1440 WL 147. CORRECTIVE ACTION: REPLACED SIDE PANEL (STRAP) AND SPLICE PER B757-200 SRM. (0144097)SDR DALA2024010900325Unknown · unknownCRACK ON RH CUSP MEMBRANE ON STA Y=716 AND X=-44 AT PAX CABIN. SUMMARY OF NRC 00445: RH CUSP MEMBRANE ON STA Y=716 AND X=-44 AT PAX CABIN WAS REPAIRED PER B717-200 SRM 51-70-10-2R PROC 2 PAR 4. (LP #0144067)SDR DALA2024010900323Unknown · unknownCRACKS ON LOWER SURFACE OF CUSP WEB MEMBRANE RH ON STA Y=655, 674, 890, 694, AND 697 AT CPAX. SUMMARY OF NRC 00316: CRACKS ON LOWER SURFACE OF CUSP WEB MEMBRANE RH ON STA Y=655, 674, 694, AND 697 AT CPAX WERE REPAIRED PER B717-200 SRM 53-00-55-2R PROCEDURE 4 RSDR AALA202401082588Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY FROM STA 540 TO STA 601, LBL 3. REPLACED BREAK ASSEMBLY PER SRM 51-40-02-0G.SDR AALA202401082749Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT INTERCOSTAL FROM STA 440 TO STA 460 AT S25L. REPLACED INTERCOSTAL PER 53-00-01-06.SDR AALA202401081834Panel · out of toleranceAIRCRAFT IN BASE MAINTENANCE: ELONGATED HOLE IN PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY FROM BS 540 TO BS 601, RBL 3. REPLACED BREAK ASSEMBLY PER SRM 51-40-02-0G.SDR SWIA2024031100106Web · damagedDRILL START NOTED ON FWD CARGO DOOR WEB SILL AT APPROX.FS566 AND STRG26L (MARKED) (C-CHECK RO 3/10/2024) FWD CARGO DOOR WEB SILL AT APPROX.FS566 AND STRG26L REPAIRED PER MHIRJ REO 670-53-31-850 REV -- DATE 2024-02-08, COMPLIED WITH ALL STEPS OF TASK CARD 5SDR SCNA20240309065Intercostal · crackedAFT CARGO COMPARTMENT FROM STA 747 TO STA 767 AT RBL20 INTERCOSTAL WITH CRACK. REPLACED INTERCOSTAL AFT CARGO COMPARTMENT FROM STA 747 TO STA 767 AT RBL 20 I.A.W BOEING 737-800 BCF SRM 51-10-02 PARAG 9.SDR SCNA20240309064Intercostal · crackedAFT CARGO COMPARTMENT FROM STA 727A TO STA 727B AT LBL20 AND RBL20 INTERCOSTAL WITH CRACK. REPLACED INTERCOSTAL IAW B-737-800 SRM 51-10-02-0G-0 PARAG 9SDR IPXA2024021610520Drain Line · dentedRH WHEEL WELL AT FRAME 47 , STATION 2983 DRAIN TUBE HAS DENT . 89-130 INSTALLED NEW RH W/W AT FR47 ST2983 DRAIN TUBE IAW A300 AMM 20-23-12/001SDR SWIA202402013106Floor Support · corrodedFLOOR BEAM RBL9.00 BETWEEN FS. 409.00 +48 - 409.00 +128 HAS MULITPLE AREAS OF SURFACE CORROSION ON INBOARD FLOORBOARD LANDING. (C-CHECK RO 2/12/2024) REMOVED AND REPLACED FLOOR BEAM RBL9.00 BETWEEN FS. 409.00 +48 - 409.00 +128 IN REF TO SRM 51-42-34, 51-4SDR SWAA2024020838386Channel · corrodedAFT CARGO COMPARTMENT RIGHT SIDE; FLOOR STRUCTURE 'Z CHANNEL' AROUND HOLES HAS EVIDENCE CORROSION BETWEEN STA 787 TO STA 807. WL 155;5; RBL-21.<[01] CLEANED AREA AT AFT CARGO COMPT R/H SIDE FLOOR SUPPORT BETWEEN STA 787 TO STA 807 RBL 21 WL 155.5;NO CORROSION SDR SWAA2024020838392Channel · corrodedAFT CARGO COMPARTMENT RIGHT SIDE; FLOOR STRUCTURE 'Z CHANNEL' AROUND HOLES HAS EVIDENCE CORROSION BETWEEN STA 747 TO STA 767. WL 155;5; RBL-21.<[01] REMOVED AND REPLACED R/H Z-CHANNEL AT AFT CARGO COMPT FROM STA 727 TO STA 767 RBL 21 PER REF SRM 51-40-02-0G-0 SDR SWAA2024020838391Channel · corrodedAFT CARGO COMPARTMENT RIGHT SIDE; FLOOR STRUCTURE 'Z CHANNEL' AROUND HOLES HAS EVIDENCE CORROSION BETWEEN STA 727E TO STA 747. WL 155;5; RBL-21.<[01] THIS JOB CARD WILL BE ACCOMPLISHED ON TASK CARD TTG8Q00QS0D9;[02] VERIFIED STEP 1.SDR SWAA2024020838385Channel · corrodedAFT CARGO COMPARTMENT RIGHT SIDE; FLOOR STRUCTURE 'Z CHANNEL' AROUND HOLES HAS EVIDENCE CORROSION BETWEEN STA 727D TO STA 727E. WL 155;5; RBL-21<[01] THIS WORK CARD WILL BE ACCOMPLISH ON TASK CARD #TTG8Q00S0D9.;[02] (CORRECTION STEP1) THIS WORK CARD WILL BE ACSDR SWAA2024020838384Channel · corrodedAFT CARGO COMPARTMENT RIGHT SIDE; FLOOR STRUCTURE 'Z CHANNEL' AROUND HOLES HAS EVIDENCE CORROSION BETWEEN STA 727C TO STA 727D. WL 155;5; RBL-21<[01] THIS WORK CARD WILL BE ACCOMPLISH ON TASK CARD #TTG8Q00S0D9.;[02] (CORRECTION STEP1) THIS WORK CARD WILL BE ACSDR SWAA2024020838383Channel · corrodedAFT CARGO COMPARTMENT RIGHT SIDE; FLOOR STRUCTURE 'Z CHANNEL' AROUND HOLES HAS EVIDENCE CORROSION BETWEEN STA 727B TO STA 727C. WL 155;5; RBL-21.<[01] THIS JOB CARD WILL BE ACCOMPLISHED ON TASK CARD TTG8Q00QS0D9;[02] VERIFIED STEP 1.SDR SWAA2024020838390Channel · corrodedAFT CARGO COMPARTMENT RIGHT SIDE; FLOOR STRUCTURE 'Z CHANNEL' AROUND HOLES HAS EVIDENCE CORROSION BETWEEN STA 727A TO STA 727B. WL 155;5; RBL-21.<[01] THIS WORK CARD WILL BE ACCOMPLISH ON TASK CARD #TTG8Q00S0D9.;[02] (CORRECTION STEP1) THIS WORK CARD WILL BE ASDR SWAA2024020838389Channel · corrodedAFT CARGO COMPARTMENT LEFT SIDE; FLOOR STRUCTURE 'Z CHANNEL' AROUND HOLES HAS EVIDENCE CORROSION BETWEEN STA 747 TO STA 767. WL 155;5; LBL-21.<[01] THIS WORK CARD WILL BE ACCOMPLISH ON TASK CARD #TTG8Q00QRYM7.;[02] VERIFIED STEP 1.SDR SWAA2024020838388Channel · corrodedAFT CARGO COMPARTMENT LEFT SIDE; FLOOR STRUCTURE 'Z CHANNEL' AROUND HOLES HAS EVIDENCE CORROSION BETWEEN STA 727E TO STA 747. WL 155;5; LBL-21.<[01] THIS WORK CARD WILL BE ACCOMPLISH ON TASK CARD #TTG8Q00QRYM7.;[02] VERIFIED STEP 1.SDR SWAA2024020838387Channel · corrodedAFT CARGO COMPARTMENT LEFT SIDE; FLOOR STRUCTURE 'Z CHANNEL' AROUND HOLES HAS EVIDENCE CORROSION BETWEEN STA 727D TO STA 727E. WL 155;5; LBL-21.<[01] THIS WORK CARD WILL BE ACCOMPLISH ON TASK CARD #TTG8Q00QRYM7.;[02] VERIFIED STEP 1.
Back to JASC 5320