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 DALA2023092507855Unknown · unknownCORROSION ON CUSP WEB STA FROM Y=860 TO Y=870 X=- 58, AT CABIN PAX. SUMMARY OF NRC 00621: CORROSION LEVEL 2. CUSP WEB STA FROM Y=860 TO Y=870 X=- 58 WAS REPAIRED PER B717 SRM 53-00-55-2R REPAIR 4 FIGURE 216. (LP #2982286)SDR CALA2023092502870Door Sill · corrodedR2 DOOR SHAPE SILL HAS CORROSION PER NR 9298803 / 32609 GEN BY V 061680 RMVD AND RPLDE SHAPE SILL ON R-2 DOOR SILL IAW SRM 51-42-11/001 AND 53-41-69-02-A BY MECH V906030 INSP BY V921658SDR CALA2023092502867Floor Support · corrodedCORROSION LOCATED ON PANEL SUPPORT RAIL JUST INSIDE SERVICE DOOR L2 REFERENCE AMES NR 163376-0200-0262SDR AALA202309226242Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: DOOR STOP FITTING #7 UPPER INBOARD FASTENER HOLE CRACKED AT FR 16 LEFT. REPLACED DOOR STOP FITTING PER SRM 51-72-11.SDR P5CA2023083000088Unknown · unknownM/D STA 1480 +20 - 1480 +40 RBL 75" HAT SECTION FOUND CRACK(<P>HAT SECTION CRACK AREA REPAIRED AS PER SRM 53-00-52-2R-10 REPAIR 10 FIG 201 REV 40, DATE 20 JUN 2023. NO FURTHER DEFECTS NOTED</P>)SDR IPXA2023103121037Tee Angle · corrodedFAULT: T-CHORD NEAR BODY STA. 1040, LH SIDE. HAS NUMEROUS RUSTED NUT PLATES. REVIEWED.SDR HNAA2023111700414Unknown · unknown53-2095 CTR OMEGA BEAM LH ANGLE TO WHEEL WELL CRACKED BTW FR46-50. REPAIRED IAW PIEDMONT EO1-53-23-0328SDR HNAA2023111700413Unknown · unknown53-2073 LH OMEGA BEAM VERTICAL FLANGE CRACKED AT FR36. REPAIRED IAW PIEDMONT EO1-53-53-0317SDR HNAA2023111700412Unknown · unknown53-2069 CTR OMEGA BEAM IB VERTICAL FLANGE CRCKED AT FR33. REPAIRED IAW ETD2023-145-025187 AND PIEDMONT EO 1-53-23-0318SDR HNAA2023111600406Unknown · unknown53-2314 ELONGATED HOLE ON OMEGA BEAM BTW FR20-21. REPAIRED IAW PIEDMONT EO1-53-23-0323SDR HNAA2023111600402Unknown · unknown53-2108 RH OMEGA BEAM IB ANGLE TO WHEEL WELL CRACKED BTW FR46-50. R&R'D RH OMEGA BEAM IB ANGLE IAW SRM 53-23-02SDR HNAA2023111600401Unknown · unknown53-2106 RH OMEGA BEAM OB AFT ANGLE TO WHEEL WELL BTW FR46-50 CRACKED. R&R'D OMEGA BEAM ANGLE IAW SRM 53-23-02 AND PIEDMONT EO1-53-23-0328.SDR HNAA2023111600400Unknown · unknown53-2105 LH OMEGA BEAM OB ANGLE TO WHEEL WELL CRACKED BTW FR46-50. R&R'D OB OMEGA BEAM ANGLE IAW SRM53-23-02 AND PIEDMONT EO1-53-23-0328SDR HNAA2023111600399Unknown · unknownTWO ANGLES SUPPORT UNDER MIDDLE GUSSET BTW FR18-23 ARE CRACKED. R&R'D ANGLES IAW SRM51-40-02TWO ANGLES SUPPORT UNDER MIDDLE GUSSET BTW FR18-23 ARE CRACKED. R&R'D ANGLES IAW SRM51-40-02SDR HNAA2023111600398Unknown · unknown53-2102 CORROSION FOUND ON MIDDLE GUSSET FLOOR STRUCTURE BTW FR18-22. R&R'D GUSSET IAW SRM 51-40-02SDR HNAA2023111600397Unknown · unknown53-2098 CORROSSION FOUND ON PREVIOUS REPAIR OF RH SERVICE DOOR AFT SILL FRAME AT FR22-23 AT FLOOR STRUCTURE AREA. REPAIRED IAW SRM 53-21-10SDR HNAA2023111600396Unknown · unknown53-2097 LH OMEGA BEAM IB ANGLE TO WHEEL WELL SKIN CRACKED AT FR46-50. R&R'D OMEGA BEAM IAW SRM 53-23-02 AND PIEDMONT EO1-53-23-0328SDR HNAA2023111600395Unknown · unknown53-2072 LH OMEGA BEAM (#3) IB VERTICAL FLANGE IS CRACKED AT FR31, FR33, FR34, ANFR35. R&R'D OMEGA BEAM IAW SRM 51-40-02SDR HNAA2023111600394Unknown · unknown53-2071 LH OMEGA BEAM (#2) IB VERTICAL FLANGE CRACKED AT FR24, FR26, FR27, AND FR28. R&R'D LH OMEGA BEAM 2 IAW SRM 51-40-02SDR HNAA202311160393Unknown · unknown53-2070 LH OMEGA BEAM IB VERTICAL FLANGE CRACKED AT FR21, FR22, FR23. R&R'D LH OMEGA BEAM IAW SRM51-40-02SDR HNAA2023111600392Unknown · unknown53-2068 CF2 CENTER OMEGA BEAM IB VERTICAL FLANGE CRACKED AT FR25 AND FR27. REPAIRED IAW ETD2023-145-024919SDR IPXA2023103119871Unknown · corrodedWING TO BODY T-CHORD, AT FR, 900 BETWEEN LBL 63 TO RBL 64 HAS CORROSION. DOT. 65-044. INSTALLED T-CHORD STA 900 R/H I.A.W SRM 51-40-02-0G.- REVIEWED.SDR SWI2023F00474Unknown · corrodedFOUND CORROSION ON LH WEB AT FS 280.00 (C-CHECK RO 11/10/2023) REMOVED AND REPLACED WITH NEW LH LOWER WEB AT FS 280.00 REF. CRJ 700 SRM 53-11-10-201-003-A01. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY. SEE CONTINUATION CARD FOR DETAILS.SDR SWI2023F0000474Unknown · corrodedFOUND CORROSION ON LH WEB AT FS 280.00 (C-CHECK RO 11/10/2023) REMOVED AND REPLACED WITH NEW LH LOWER WEB AT FS 280.00 REF. CRJ 700 SRM 53-11-10-201-003-A01. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY. SEE CONTINUATION CARD FOR DETAILS.SDR SWAA2023103102729Gusset · crackedFWD CARGO COMPARTMENT L/H SIDEWALL GUSSET CRACKED AT S-21L STA 500I<[01] REMOVED AND REPLACED L/H SIDEWALL GUSSET AT S-21L STA 500I PER SRM 51-40-02-0G-0 AND DWG#143A9481.;[02] VERIFIED ALL STEPSSDR SWAA2023103003074Gusset · crackedCRACK GUSSET LOCATED BS500D AT LEVEL STR19R FWD CARGO COMPARTMENT 2023-594255<[01] REPLACED GUSSET LOCATED BS500D AT LEVEL STR19R FWD CARGO COMPARTMENT IAW B737-700 SRM 51-40-02-0G-0 AND DWG 143A7902 SHEET 174 REV ?.SEE INDIVIDUAL SIGN-OFF BELOW.;[02] REPLACEDSDR SWAA2023103003071Angle · crackedCRACK ANGLE LOCATED BS500C AT LEVEL STR26L AT FWD CARGO COMPARTMENT 2023-594256<[01] REPLACED ANGLE LOCATED BS500C AT LEVEL STR26L AT FWD CARGO COMPARTMENT IAW B737-700 SRM 51-40-02;SRM 51-10-02 ITEM 9 AND DWG 142A7505 SHEET 5 REV B;[02] CORRECTED STEP 1<BR>RESDR SWAA2023103003072Angle · crackedCRACK ANGLE LOCATED BS500B AT LEVEL STR26L AT FWD CARGO COMPARTMENT 2023-594257<[01] REPLACED ANGLE LOCATED BS500B AT LEVEL STR26L AT FWD CARGO COMPARTMENT IAW B737-700 SRM 51-40-02;SRM 51-10-02 ITEM 9 AND DWG 142A7505 SHEET 5 REV B;[02] CORRECTED STEP 1<BR>RESDR SWAA2023103003073Web · crackedCRACK WEB LOCATED BS500 TO BS500A AT LEVEL STR26L AT FWD CARGO COMPARTMENT 2023-594258<[01] REPLACED WEB LOCATED BS500 TO BS500A AT LEVEL STR26L AT FWD CARGO COMPARTMENT IAW B737-700 SRM 51-40-05 AND DRAWING # 143A7505 REV - SHEET 37. SEE INDIVIDUALS SIGN OFF SDR SWAA2023102709485Gusset · crackedCRACK GUSSET LOCATED BS500D AT LEVEL STR19L FWD CARGO COMPARTMENT 2023-594254<[01] REPLACED NEW GUSSET LOCATED BS500D AT LEVEL STR19L FWD CARGO COMPARTMENT IAW B737-700 SRM 51-10-02 ITEM 9; SRM 51-40-02 AND DWG 143A7902 REV- SEE INDIVIDUAL SIGN OFFS BELOW.;[02SDR SWAA2023102303260Intercostal · crackedMAIN CABIN INTERCOSTAL CRACK AT LBL 12' BETWEEN STA 344-360<[01] REMOVED AND REPLACED INTERCOSTAL AT MAIN CABIN BETWWEEN STA 344 TO STA 360 AND LBL 12' IN REF B737-700 SRM 51-40-02-0G-0 AND BOEING DRAWING #141A5400.;[02] VERIFIED STEP 1SDR SWAA2023102303266Intercostal · crackedMAIN CABIN INTERCOSTAL CRACK AT BL 0' BETWEEN STA 277-294.5<[01] REMOVED AND REINSTALLED NEW INTERCOSTAL AT MAIN CABIN BL 0' BETWEEN STA 277-294.5 AS PER SRM 51-40-02-0G-0 & DWG 141A5400.;[02] VERIFIED STEP 1SDR SWAA2023102302916Panel · crackedCRACK FOUND AT AREA AFT OF FWD. CARGO COMPARMENT; LOCATED AT STA. 540 WL 208 RBL 1; SEE DOT # 31<[01] REMOVED AND REPLACE PANEL BREAK AT STA 540 WL 208 RBL 1. AS PER; SRM 51-40-02-0G-0 AND DWG 143A5240.;[02] CORRECTION ON STEP # 1: REMOVED AND REPLACED PANEL BSDR SWAA2023102303254Floor Support · corrodedMAIN CABIN AFT WET AREA CORROSION AT FLOOR SUPPORT STRAP BETWEEN STA 1016-1040 LBL 3'<[01] CLEAN AREA AT FLOOR SUPPORT STRAP BETWEEN STA 1016-1040 AND LBL 3' REF SOPM 20-30-03; TREAD AND PRIMER REF AMM 51-21-41-370-803 & AMM 51-21-72-370-804;[02] VERIFIED STEPSDR SWAA2023102303267Intercostal · corrodedMAIN CABIN FWD WET AREA CORROSION AT INTERCOSTAL UPPER SURFACE STA 294.5+11' LBL 12'<[01] REMOVED AND REPLACED INTERCOSTAL AT MAIN CABIN BETWEEN STA 294.5 TO STA 312 LBL 11.6 SRM 51-40-02-0G-0 AND DWG 141A5600;[02] VERIFIED STEP 1SDR SWAA2023101802748Baffle · crackedFWD CARGO R/H BAFFLE UNDER TRANSITION ANGLE AT STA E TO STA F CRACKED.<[01] REMOVED AND INSTALLED NEW BAFFLE PER SRM 51-40-02.;[02] INSPECTED AS REQUIRED. FOR CLARIFICATION BAFFLE REPLACEMENT AT STA. 500E-500FSDR AALA202309274405Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOOR SUPPORT BREAK ASSEMBLY LOCATED AT BS 540 AND BL 0. REPLACED BREAK ASSEMBLY PER AARD: 51-00-05-1 AND DWG 143A0060.SDR AALA202309274030Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOOR SUPPORT BREAK ASSEMBLY LOCATED AT BS 540 AND BL 0. REPLACED BREAK ASSEMBLY PER AARD: 51-00-05-1 AND DWG 143A0060SDR DALA2023092607942Unknown · unknownSHIP 0695 CORROSION ON FITING ON STA 1640, RBL 45.5 (W3). CORRECTIVE ACTION FITTING WAS REPLACED ON STA 1640 AND RBL 45.5 (W3). I.A.W. B- 757-200 SRM 51-10-02. (2985329)SDR DALA2023092507854Unknown · unknownFOUND INTERCOSTAL CRACKED BETWEEN STA 946.5 AND 954. FABBED NEW INTERCOSTAL PER DWG 9915578 AND SRM 53-20-51-0I PROC 7. INSTALLED INTERCOSTAL PER B717 SRM 51-41. (LP #2980699)SDR AALA202309252763Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND SIDE TRANSITION PANEL BETWEEN BS 767 AND BS 787 AT S25R. REPLACED TRANSITION PANEL. PER SRM 51-40-02.SDR DALA2023092207811Unknown · unknownSHIP 3129 CORROSION FLOOR BEAM -Y1292 LOCATED BTW FR 64 TO FR 66 AT AFT GALLEY AREA. CORRECTIVE ACTION: REPLACED FLOOR BEAM Y-1292 LOCATED BTW FR 64 TO FR 66 AT AFT GALLEY AREA AS PER A319 SRM 51-72-11. (2980763)SDR DALA2023092207810Unknown · unknownSHIP 3129 CORROSION FLOOR BEAM +Y1292 LOCATED BTW FR 64 TO FR 66 AT AFT GALLEY AREA. CORRECTIVE ACTION: REPLACED FLOOR BEAM Y1292 LOCATED BTW FR 64 TO FR 66 AT AFT GALLEY AREA AS PER A319 SRM 51-42-11 AND A319 SRM 51-72-11. (2980710)SDR SWI2023F00481Unknown · corrodedPAX DOOR FWD DD5 INTERCOSTAL HAS CORROSION(MARKED). (C-CHECK RO 11/21/2023) REMOVED AND INSTALLED NEWPAX DOOR FWD DD5 INTERCOSTAL REF CRJ 200 SRM 51-42-06,CRJ-200 SRM 51-42-21 AND DRAWING 601R31702 REV N.. COMPLIED WITH 51-900-1003-SKY AND PRESSURE CHECKSSDR SWAA2023110102714Floor Support · corrodedCORROSION FWD CARGO COMPARTMENT FLOOR SUPPORT Z CHANNEL S-26R FROM STA 500A TO STA 500I MKD DOT<[01] EVALUATED AREA AT FWD CARGO FLOOR SUPPORT Z-CHANNEL S-26R STA 500A TO 500C FOUND NO EVIDENCE OF CORROSION PER SRM 51-10-02-0G-0.<BR>REMOVED AND REPLACED RH Z CSDR SWAA2023110102579Intercostal · corrodedCORROSION AT FWD WET AREA FLOOR SUPPORT INTERCOSTAL @ LBL 12 BETWEEN STA 294.5 & 312 MKD DOT CORRODED P/N 141A5690-1<[01] REMOVED AND REPLACED FLOOR SUPPORT INTERCOSTAL AT LBL12' BETWEEN STA 294;5 TO STA 312 REF B-737-800 SRM 51-40-02-0G-0; DWG;141A5600;[02] RSDR SWAA2023110102711Angle · corrodedCORROSION AREA AFT OF FWD CARGO COMPARTMENT FLOOR SUPPORT ANGLE AT STA 500I FROM S-26L TO S-26R MKD DOT<[01] REMOVED DAMAGED FWD CARGO COMPARTMENT FLOOR SUPPORT ANGLE AT STA 500I FROM S-26L TO S-26R PER SRM 51-40-02-0G-0.LOCATED AND DRILLED NEW FWD CARGO FLOORSDR SWAA2023103102588Floor Support · crackedFWD CABIN WET AREA FLOOR SUPPORT INTERCOSTAL UPPER CAP CRACKED @ BL-0 BETWEEN STA 277 AND STA 294.5 MKD DOT<[01] REMOVED AND REPLACED FWD CABIN WET AREA FLOOR SUPPORT INTERCOSTAL AT BL-0 BETWEEN STA 277 AND STA 294.5 IN REFERENCE TO SRM 51-40-02-0G-0.;[02] RIISDR SWAA2023103102717Channel · crackedFWD CARGO COMPARTMENT FLOOR SUPPORT Z CHANNEL CLIP CRACKED @ S-26L STA 500K MKD<[01] REMOVED AND REPLACED FWD CARGO COMPARTMENT FLOOR SUPPORT Z CHANNEL CLIP AT S-26L STA 500H PER SRM 51-40-02-0G-0;[02] VERIFIED STEP 1SDR SWAA2023103102713Channel · crackedFWD CARGO COMPARTMENT FLOOR SUPPORT Z CHANNEL CLIP CRACKED @ S-26R FROM STA 500K MKD<[01] REMOVED AND REPLACED FWD CARGO COMPARTMENT FLOOR SUPPORT Z CHANNEL CLIP AT S-26R FROM STA 500H PER SRM 51-40-02-0G-0;[02] VERIFIED STEP 1;[03] VERIFIED STEP 1
Back to JASC 5320