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 SCNA20201007086Support · damagedTOOLING DAMAGE ON LAV HARD POINT SUPPORT BS 294.5 TO 312 LBL 11.16 WL 208. TOOLING DAMAGE ON LAV HARD POINT SUPPORT BS 294.5-312 LBL 11.16 WL 208 FOUND TO BE OUT OF LIMITS DUE TO NO ALLOWABLE LIMITS, PER SRM. REMOVED AND REPLACED LAV HARD POINT SUPP BS 294.5SDR SCNA20201007085Support · brokenWASTE TANK ENCLOSURE LOWER STANCHION SUPPORT BROKEN BS 867 LBL 10 WL 160. REMOVED BROKEN STANCHION SUPPORT AT BS 867 LBL 10 WL 160, IAW SRM 51-40-02-0G-0. INSTALLED NEW STANCHION P/O 802020/1, IAW SRM 51-40-02-0G-0 AND BOEING DWG 149A8102 REV C.SDR SCNA20201007083Floor Support · crackedINTERCOSTAL BETWEEN BS 312 AND BS 328 LBL 11 CRACKED. REMOVED AND REPLACED CRACKED INTERCOSTAL STA 312-328 LBL 11, IAW SRM 51-40-02-0G-0, SRM 51-40-05-0G-0 AND DWG 141A5400 SHEET 27 REV- 57901U.SDR SCNA20201007082Floor Support · damagedTOOLING MARK ON FLOOR STRUCTURE BS 277 TO BS 294.5 LBL 11. TOOLING MARK ON FLOOR STRUCTURE BS 277-294.5 LBL 11 FOUND TO BE OUT OF LIMITS, DUE TO NO ALLOWABLE LIMITS, PER SRM. REMOVED AND REPLACED INTERCOSTAL, IAW SRM 51-40-02-0G-0, SRM 51-40-05-0G-0 AND DWG SDR SCNA20201007081Floor Support · damagedTOOLING MARKS ON FLOOR STRUCTURE BS 328 TO BS 344 LBL 11. REMOVED TOOLING MARKS ON FLOOR STRUCTURE STA 328-344 LBL 11 IN AN AREA OF L 2" X W .6" X D .017", IAW SRM 51-10-02-0G-0. DAMAGE FOUND TO BE OUT OF LIMITS, IAW SRM 53-10-51-1A-1 FIGURE 105 DETAIL C. RSDR SCNA20201007080Shield · corrodedCORROSION FOUND ON SHIELD AFT OF AFT CARGO COMPARTMENT DOOR STA 856 TO 867 RBL 21 WL 159. CORROSION ON AFT CARGO AFT SHIELD STA 856 TO 867 RBL 21 WL 159 FOUND TO BE OUT OF LIMITS, DUE TO NO LIMITS FOUND IN SRM 53-60-15-1A-1. REMOVED SHIELD, IAW SRM 51-40-02-SDR R61A2020093000663Door Sill · corrodedCORROSION FOUND ON FWD CARGO DOOR SURROUND, LOWER SILL BEAM. REPAIRED IAW ETD2020-170-027672.SDR REXA2020092800664Strap · corrodedSTRAP IS CORRODED BETWEEN LBL 36 TO LBL 27 AT FS 559. REMOVED AND REPLACED STRAP LOCATED BETWEEN LBL 36 TO LBL 27 AT FS 559, IAW CRJ 200 SRM 51-42-06 AND CRJ 200 SRM 51-40-11.SDR KCSA202009111146Tension Tie · crackedFASTENER HOLE ON STA 1180 RT SIDE ON TENSION TIE CRACKED AS MARKED.SDR KCSA202009111143Stiffener · crackedCRACK NOTED ON LONGITUDINAL STIFFENERS AT APROX STA 300 RBL 10 INTERIOR OF NWW.SDR SWAA2021081315142Web · damagedFOUND DAMAGE WEB AT FWD CARGO COMP UNDER RT SIDE PLATE AT STA 500 / REMOVED AND REPLACED WEB AT FWD CARGO COMP. UNDER SIDE PLATE RT AT STA 500 IAW B-737-700 SRM 51-40-02-0G-0 AND DWG # 143A8122-2.SDR SWAA2021072116125Support Angle · corrodedCORROSION ANGLE - SUPPORT ON BS 947.5 BTW STR 25R TO STR 25L AND BTW RBBL 21 TO LBBL 21 AT AFT CARGO COMPARTMENT WL=155.5 / REPLACED ANGLE SUPPORT ON BS947.5 BTW STR 25R TO STR25L AND BTW RBBL21 TO LBBL21 AT AFT CARGO COMPARTMENT WL=155.5 IAW B737-700 SRM 51-4SDR SWIA202053375Floor Support · corrodedLT FLOOR SILLS BETWEEN FS 1000-1047 HAS CORROSION. C-CHECK RO 10/16/2020. CORROSION ON LT FLOOR SILL BETWEEN FS 1000.00 & FS 1047.00 WAS FOUND TO BE OUT OF LIMITS AND WAS REPLACED WITH A NEW AFT CARGO DOOR FLOOR SILL P/N: MM670-35655-003. RESTORED FINISH ANSDR SWIA202053310Support Bracket · crackedRADAR LOWER SUPPORT BRACKET STIFFNER AT FS 169 HAS A SUSPECTED CRACK ON THE RT SIDE. C-CHECK RO 10/13/2020. REMOVED AND REPLACED RADAR LOWER SUPPORT BRACKET P/N: 601-34010-39, REF BOMBARDIER DWG CRJ-200 SRM. OPERATIONAL CHECKS GOOD, REFERENCE THE CONTINUE CSDR FDEA202009102235Strap · damagedUPON CLOSE UP INSP FOUND STABILIZER STRAP AT BSTA 580 LBL 24 DAMAGE ON LOWER SIDE OF FLOOR BEAMS REPAIRED STABILIZER STRAP AT BSTA 580 LBL 24, IAW SRM 53-00-51-2R REPAIR 12.SDR SCNA20201007079Attach Angle · corrodedFWD ENTRY INNER CHORD SCUFF PLATE ATTACH ANGLE STA 287 TO STA 335 LBL 59 WL 208 CORROSION DAMAGE. FWD ENTRY INNER CHORD SCUFF PLATE ATTACH ANGLE BS 287-335 LBL 59 FOUND TO BE OUT OF LIMITS, DUE TO NO ALLOWABLE LIMITS, IAW B737-800 SRM. REMOVED AND REPLACED ASDR SCNA20201007075Channel · corrodedAFT CARGO BAY LEFT HAND Z CHANNEL HAS MULTIPLE AREAS OF CORROSION STATION 727B-827, MARKED. REMOVED AND REPLACED AFT CARGO LEFT HAND Z CHANNEL FROM BS 727B-827, IAW B737-800 SRM 51-40-02-0G-0 AND BOEING DRAWING 146A7502 REV. NOTE: CORROSION WAS FOUND TO BE OSDR SWIA202052888Support · crackedLT MLG FAIRING DIAPHRAGM ASSY SUPPORT STRUCTURE CRACKED, MARKED. C-CHECK RO 9/27/2020. THE CRACKED LT MLG FAIRING DIAPHRAGM ASSY SUPPORT (P/N CC670-39205-5) HAS BEEN REPLACED WITH NEW AND INSTALLED WITH NEW HARDWARE, REF CRJ700 SRM.SDR SWIA202052782Angle · corrodedCORRODED 3 EA LOWER ANGLES AND 1 EA CRACK RECEPTACLE ON PANEL 1441FR. C-CHECK RO 9/24/2020. REMOVED AND REPLACED 2 EA LOWER ANGLES. PERFORMED BLENDOUT ON (1) ANGLE, FOUND TO BE WITHIN LIMITS. REPLACED DAMAGED RECEPTABLE ON PANEL 1441FR, REF EMB SRM. RESTOSDR SWIA202052777Floor Support · corrodedCORROSION, AFT WET AREA RT FLOOR BEAM UPPER SHEET HAS CORROSION AS MARKED FR 85-86. C-CHECK RO 9/24/2020. REMOVED AND REPLACED AFT WET AREA RT FLOOR BEAM UPPER SHEET FR 85-86, REF EMB SRM. SEE CONTINUATION CARD FOR WORK PERFORMED.SDR SWIA202052775Floor Support · corrodedCORROSION, AFT WET AREA FR 87 PANEL SUPPORT FWD OF RT SHEAR PANEL CORRODED, AS MARKED. C-CHECK RO 9/24/2020. REMOVED AND REPLACED AFT WET AREA FR 87 PANEL SUPPORT FORWARD OF RT SHEAR PANEL, REF EMB SRM. SEE CONTINUATION CARD FOR WORK PERFORMED.SDR SWIA202052774Floor Support · corrodedCORROSION, AFT WET AREA RT PANEL SUPPORT HAS CORROSION AT FR 90, AS MARKED. C-CHECK RO 9/24/2020. REMOVED AND REPLACED RT PANEL SUPPORT AT FRAME 90, REF SRM.SDR SWIA202052773Floor Support · corrodedCORROSION, AFT WET AREA RT PANEL SUPPORT HAS CORROSION AT FR 90, AS MARKED. C-CHECK RO 9/24/2020. REMOVED CORROSION, MATERIAL LOSS FOUND TO BE BEYOND ANY SRM LIMITS. REMOVAL AND REPLACEMENT OF AFT WET AREA RH PANEL SUPPORT AT FR90, REF EMB175 SRM.SDR IPXA2020092460590Floor Support · corrodedINSPECTION TYPE: 2C FLOOR PANEL SUPPORT IS CORRODED BETWEEN STA 392-440 AND X= -8.5 TO X= -27.5. REMOVED, FABRICATED, AND REPLACED FLOOR SUPPORT, IAW DWG WSP0668 AND SRM 51-33-01. (MINOR)SDR AALA202009239019Web · corrodedAIRCRAFT IN BASE MAINTENANCE: FOUND CORRODED AREA ON WEB AT FR 20 AND STR 23R IN FORWARD GALLEY MEASURING L=3.157 IN W=2.997 IN D=0.020 IN. REPLACED WEB IAW A321 SRM 51-42-11-801 AND DRAWING NR D53112545.SDR DALA2020091113043Floor Support · corrodedSHIP 3241, CORROSION FLOOR BEAM -Y1225 FROM FR66 TO FR68 AFT GALLEY AREA (SSI 534 147). CORRECTIVE ACTION: REPLACED FLOOR BEAM -Y1225 LOCATED BETWEEN FR66 TO FR68 AFT GALLEY AREA, AS PER A320 SRM51-72-11 AND DRAWING D53472000, RELEASE DATE:06-JAN -03,ISSUE AFSDR DALA2020091113042Floor Support · corrodedSHIP 3241, CORROSION FLOOR BEAM -Y1162.5 LOCATED BETWEEN FR 68 TO FR 69 AT AFT GALLEY AREA. CORRECTIVE ACTION: REPLACED FLOOR BEAM -Y1162.5 LOCATED BETWEEN FR68 TO FR69 AFT GALLEY AREA, AS PER A320 SRM 51-72-11 AND DRAWING D53472000, RELEASE DATE 06 -JAN-03. SDR DALA2020091103049Web · crackedSHIP 3278, CRACK INDICATION ON WEB AT OPEN FASTENER HOLE COMMON TO AFT LT T ANGLE POSITION, IN MAIN WHEEL WELL. CORRECTIVE ACTION: PERFORMED REPAIR INSTRUCTIONS ON SECTION I PERMANENT REPAIR ON FR.42 AT AFT LT SIDE "T" ANGLE POSITION IN MAIN WHEEL WELL, AS PESDR DALA2020091103030Strap · crackedDURING INSPECTION FOUND CRACKED STRAP SUPPORT ON CEILING AREA RIGHT SIDE AT STA 720 AT FWD CARGO COMPARTMENT. STRAP WAS REPAIRED PER SRM 53-00-51.SDR AALA202009119012Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RT AFT PASSENGER/CREW DOOR CUT OUT LOWER AFT CORNER FITTING AT FR 68 AND S23R. REPLACED CORNER FITING PER SRM 51-42-11.SDR SWAA2021081515138Channel · corrodedCORROSION CHANNEL SIDEPLATE LOC BS500 TO BS500A AT LEVEL STR26R AND WL156.5 FWD CARGO COMPARTMENT / REPLACED CHANNEL SIDEPLATE LOC BS500 TO BS500A AT LEVEL STR26R AND WL156.5 FWD CARGO COMPARTMENT IAW B737-700 SRM 51-10-02 ITEM 9 AND DWG #143A0080 REVSDR SWAA2021071515139Support Angle · corrodedCORROSION BILGE AREA ON SUPPORT ANGLE LOCATED BS500D BETWEEN STR26L TO STR26R AND WL156.5 FWD CARGO COMPARTMENT / REPLACED SUPPORT ANGLE (RAIL) AND FASTENERS LOC BS500D BTW S-26L TO S-26R AND WL 156.5 FWD CRAGO COMPARTMENT IAW SRM B737-700 51-40-02 AND DRAWINGSDR AALA202010269019Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE. CRACK IN SHEAR PLATE BETWEEN FR 69 AND FR 70 AT STR 23R, MEASURING L=0.203 IN. REPLACED SHEAR PLATE WITH MODIFIED PART, IAW SRM A321 51-72-11-911-001 AND 51-42-11-801 AND DRAWING D53474180.SDR SWIA202053635Plate · corrodedCORROSION ON GROUND PLATES AT FS 319.00 STGR 21R. C-CHECK RO 10/22/2020. REMOVED AND REPLACED GROUND PLATES AT FS 319.00 STGR 21R, REF CRJ700 SRM AND DWG. COMPLETED FORM M-337. SEE CONTINUATION CARD FOR DETAILS.SDR SWIA202053490Support · crackedLEFT WINDSHIELD SIDE POST SUPPORT P/N 601R34032-21 IS CRACKED AT THE RADIUS ABOVE STRINGER. C-CHECK RO 10/18/2020. REMOVED AND REPLACED SUPPORT, IAW CRJ 200 SRM. MAJOR REPAIR TASK AND FORM M337 COMPLETED AND ATTACHED. NO WEIGHT CHANGE, WAS A PART FOR PART SDR AALA202010199013Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE. FOUND 0.810-INCH CRACK ON SHEAR PLATE AT FR 69 TO FR 70 AND STR 23L IN AFT GALLET AREA. REMOVED AND REPLACED SHEAR PLATE, IAW SRM A321 51-72-11-911-001, 51-42-11-801 AND DRAWING D53474180.SDR SWIA202053309Floor Support · corrodedTHE RT FLOOR SILL PANEL HAS MULTIPLE SPOTS OF CORROSION BETWEEN FS 409+128 AND FS 559, MARKED WITH RED GREASE PENCIL. C-CHECK RO 10/13/2020. REPAIRED THE RT FLOOR SILL PANEL MULTIPLE SPOTS OF CORROSION BETWEEN FS 409+128 AND FS 559, REF REO. SEE CONTINUATIOSDR SWIA202053308Floor Support · corrodedTHE LT FLOOR SILL PANEL HAS MULTIPLE SPOTS OF CORROSION BETWEEN FS 409+128 AND FS 559. MARKED WITH RED GREASE PENCIL. C-CHECK RO 10/13/2020. REPAIRED CORROSION DAMAGE ON LT PRESSURE FLOOR SILL PANEL, REF REO. COMPLIED WITH TASK CARD.SDR AALA202010019009Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION OF CENTER FITTING BETWEEN FR 68 AND FR 70 AT STR 23L, MEASURING L=5.957 IN, W=0.588 IN, D=0.078 IN. REPLACED CENTER FITTING WITH MODIFIED PART, IAW A321 SRM 51-72-11-911-001 AND 51-42-11-801 AND DRAWING D53480505.SDR R61A2020093000668Floor Support · corrodedCORROSION FOUND ON CENTER FUSELAGE III FLOOR STRUCTURE RT LONGITUDINAL BEAM FR 86-89. REPLACED IAW SRM 51-43-01.SDR R61A2020093000667Shear Panel · corrodedCORROSION FOUND ON CENTER FUSELAGE III FLOOR STRUCTURE RT SHEAR PANEL AT FR 88. REPLACED IAW SRM 51-42-01.SDR R61A2020093000666Shear Panel · corrodedCORROSION FOUND ON CENTER FUSELAGE III FLOOR STRUCTURE, MID SHEAR PANEL. AT FR 88. REPLACED IAW SRM 51-42-01.SDR R61A2020093000665Angle · corrodedCORROSION FOUND ON CENTER FUSELAGE III FRAME STABILIZER CLIP AT FR 84 AND STR 19L. REPLACED IAW SRM 51-41-01.SDR R61A2020093000664Angle · corrodedCORROSION FOUND ON CENTER FUSELAGE III FRAME STABILIZER CLIP AT FR 85 AND STR 19L. REPLACED IAW SRM 51-43-01.SDR IPXA2020092860728Channel · corrodedINSPECTION TYPE: 2C CENTER CARGO LOADING SYSTEM CHANNEL HAS CORROSION BETWEEN STA 1571 TO 1611 AND X= -33. REPAIRED CORRODED CENTER CARGO LOADING SYSTEN CHANNEL BETWEEN STA 1571 TO 1611 AND X= -33, IAW UPS EO MD11-2550-77908-A. MAJOR.SDR IPXA2020092460582Intercostal · crackedINSPECTION TYPE: 2C LOWER FWD CARGO BETWEEN STA 6-30 TO 6-50 & ABOVE L43L INTERCOSTAL IS CRACKED. REMOVED, FABRICATED, AND REPLACED INTERCOSTAL, IAW DWG ACA7049 AND SRM 51-33-01.SDR AALA202009259019Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE. FOUND CORRODED SHAPE CENTER FITTING AT STR 23R BETWEEN FR 66 AND F 68 AT AFT GALLEY AREA MEASURING L=2.081 IN W=0.696 IN D=0.092 IN. REPLACED CENTER FITTING, IAW A321 SRM 51-72-11-911-001 51-42-11-801 AND DWG NR D53480505.SDR SWAA2020092416124Support · crackedCRACK BILGE AREA ON SUPPORT ZEE LOCATED BETWEEN BS 500 TO BS 500A AT LEVEL STR 26L AT FWD CARGO COMPARTMENT. PERFORMED REPAIR SUPPORT ZEE LOCATED BETWEEN BS 480 TO BS 500D AT LEVEL STR 26L AT FWD CARGO COMPARTMENT, IAW SRM B737-700; 53-00-53-2R-6 AND DRAWING SDR SWAA2020092415136Cargo Track · crackedCRACK FLOOR STRUCTURE CARGO TRACK RBBL 13.84 ON BS 727E AT AFT CARGO COMPARTMENT. PERFORMED PERMANENT REPAIR ON FLOOR STRUCTURE CARGO TRACK RBBL 13.84 ON BS 727B TO BS 747 RBBL 13.84, IAW SRM B737-700 53-00-53-2R-3 REPAIR 3 ALTERNATIVE 1 AND SW EA NR 20-153-0SDR IPXA2020092260511Intercostal · crackedINSPECTION TYPE: 2C LOWER FWD CARGO BETWEEN STA 6-30 TO 6-50 ABOVE L43R, INTERCOSTAL IS CRACKED IN 3 PLACES. REMOVED, FABRICATED, AND REPLACED INTERCOSTAL IAW DWG ACA7049 AND SRM 51-33-01 MINOR.
Back to JASC 5320