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 SWAA2021021127358Support · damagedFLOOR TO SIDEWALL SUPPORT HAS DAMAGE AT AFT CARGO BAY BS867 - BS887 RBL21 WL164. / REMOVED AND INSTALLED NEW FLOOR TO SIDEWALL SUPPORT AT AFT CARGO BAY BS 867-BS 887 EBL 21 WL 164. ITEM# 7535224 IAW SRM 53-00-53-01-2; SRM 53-00-53-1A-2; SRM 51-10-02-0G-0; SRM SDR SWAA2021021127347Shield · corroded***CORROSION*** ON AFT SHIELD AT AFT CARGO BAY BS847 - BS867 RBL20 WL164. / REMOVED AND INSTALLED NEW AFT SHIELD AT AFT CARGO BAY BS847-BS 867 RBL 20 WL 164 ITEM# 7531255 IAW SRM 51-10-02-0G-0; SRM 51-40-05-0G-0; SRM 51-40-02-0G-0; DWG#145A8127; DWG# 146A0081 SDR SWAA2021021127341Support · corroded***CORROSION*** ON FLOOR TO SIDEWALL SUPPORT AT AFT CARGO BAY BS727 - BS767 RBL22 WL156. / REMOVED AND REPLACED FLOOR TO SIDEWALL SUPPORT AT AFT CARGO BAY BETWEEN BS 727-BS 767 RBL 22 WL 156 PER SRM 51-40-02 AND DWG 146A7500SDR SWAA2021021127340Shield · corroded***CORROSION*** ON FWD SHIELD AT AFT CARGO BAY BS767 - BS787 RBL22 WL156. / REMOVED AND INSTALLED NEW ON FWD SHIELD AT ACB BS 767 - BS 787 RBL 22. IAW SRM 51-40-02; SRM 51-20-01; SRM 51-40-05 AND DWG 146A0081 80641U 12NOV20SDR SWIA202054534Floor Support · corrodedCORROSION ON FLOOR BEAM INBOARD FLANGE AT RBL 9 BETWEEN APPROXIMATELY FS 409.00+64-409.00+96, AREAS MARKED. C-CHECK RO 12/05/2020. REPAIRED CORRODED FLOOR BEAM INBOARD FLANGE AT RBL 9 BETWEEN APPROXIMATELY FS 409.00+64-409.00+96 OVER LIMIT, REF CRJ 200 SRM.SDR SWIA202054533Door Sill · corrodedCORROSION ON AFT CARGO DOOR SILL BETWEEN FS 574.00-621.00. C-CHECK RO 12/05/2020. REMOVED AND REPALCED WITH NEW CARGO FOOR SILL PN: 601R35011-63, REF CRJ200 SRM AND DWG. ALL CHECKS GOOD AND LEAK CHECKS GOOD.SDR SWIA202054425Angle · crackedCLIP ANGLE BETWEEN FS 621 AND FS 625 AT LBL 45 WL 93 IS CRACKED. C-CHECK RO 11/24/2020. REMOVED CRACKED CLIP ANGLE AND REPLACED WITH A SERVICEABLE BETWEEN FS 621 AND FS 625 AT LBL 45 WL 93, IAW CRJ200 SRM. APPLIED PROTECTIVE FINISH, IAW CRJ200 SRM.SDR SWAA2020113027277Floor Panel · damagedFWD FLOOR PANEL 222DF UPPER SKIN HAS MULTIPLE AREAS OF PULLED STRANDS. DUE TO THE EXTENT OF DAMAGE PANEL 222DF WAS REPLACED WITH A NEW PANEL, IAW SRM 51-10-02-0G-0 PAR 9 AND AIPC 53-21-00-50D ITEM 195.SDR SWAA2020113027249Floor Support · crackedCABIN FLOOR SUPPORT CRACKED AT BS 540 RBL 1 WL 208, MARKED. REMOVED AND REPLACED CABIN FLOOR SUPPORT AT BS 540 RBL 1 WL 208, PER SRM 51-40-02-0G-0; SRM 51-40-05-0G-0; SRM 51-40-06-0G-0; AND DRAWING NR 143A5240.SDR SWAA2020113027248Floor Support · crackedCABIN FLOOR SUPPORT CRACKED BS 540 LBL 1 WL 208, MARKED. REMOVED AND REPLACED CABIN FLOOR SUPPORT BS 540 LBL 1 WL 208, PER SRM 51-40-02-0G-0; SRM 51-40-05-0G-0; SRM 51-40-06-0G-0; AND DRAWING NR 143A5240.SDR SWAA2020113027339Floor Support · corrodedCORROSION ON INTERCOSTAL AT AFT CARGO BAY BS 807-BS 787 RBL 6 WL 153. REMOVED CORROSION ON INTERCOSTAL AT AFT CARGO BAY BS 807-BS 787 RBL 6 WL 153 MEASURED 19' X 2.3' X .010'. ORIGINAL MATERIAL THICKNESS .045', FOUND TO BE OUT OF LIMITS, IAW SRM 53-60-15-1A-SDR SWAA2020113027350Floor Support · corrodedCORROSION ON INTERCOSTAL AT AFT CARGO BAY BS 787 TO 793 RBL 24 WL 156. REMOVED & REPLACED NEW INTERCOSTAL P/N 146A8123-17 AT AFT CARGO BAY BS 787 TO 793 RBL 24 WL 156, IAW DWG 146A8120 DWG 146A0081 & SRM 51-40-02-0G-0.SDR SWAA2020113027333Floor Support · crackedCOCKPIT FLOOR SUPPORT INTERCOSTAL CRACKED AT BS 255 LBL 4 WL 208, MARKED. REMOVED AND REPLACED INTERCOSTAL COCKPIT FLOOR SUPPORT AT BS 255 LBL 4 WL 208, IAW SRM 51-40-02-0G-0 DWG 141A5100 59205U 10NOV20.SDR SWAA2020113027336Floor Support · corrodedCORROSION ON INTERCOSTAL AT AFT CARGO BAY BS 727A-BS 727B LBL 17 WL 154. REMOVED AND REPLACED INTERCOSTAL 146A7505-3 AT AFT CARGO BAY BS 727A-BS 727B LBL 17 WL 154, IAW SRM 51-40-05 AND DWG 146A7500.SDR SWIA202054200Floor Support · puncturedPUNCTURE FOUND ON FLOOR BEAM LOCATED AT RBL 9.0 INBOARD FLANGE BETWEEN FS 559.00+48-FS 559.00+64. C-CHECK RO 11/21/2020. REPAIRED FLOOR BEAM AT RBL 9.0 INBOARD FLANGE BETWEEN FS 559+48 AND FS 559+64, REF CRJ200 SRM. COMPLIED WITH TASK CARD. SEE CONTINUE CASDR AALA202011209021Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE. FOUND L=0.927 INCH CRACK ON SHEAR PLATE FR 69 TO FR 70 AND STR 23R AT AFT GALLEY AREA. REPLACED SHEAR PLATE, IAW A321 SRM 51-42-11-801 & DWG D53474180.SDR R61A2020111900781Channel · corrodedWHILE THE A/C WAS IN FOR HEAVY CHECK FOUND FWD CARGO COMPARTMENT CORROSION FOUND ON FR 16 OUTER FLANGE BETWEEN STR 27-28 RT. REPLACED FWD CARGO COMPARTMENT CORROSION FOUND ON FR 16 OUTER FLANGE PN 170-03860-003 BETWEEN STR 27-28 RT, IAW EMB SRM 51-41-01. FORSDR AALA202011169011Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE. FOUND L=0.863 INCH CRACK ON SHEAR PLATE AT FR 69 TO FR 70 AND STR 23L. REPLACED SHEAR PLATE, IAW SRM A321 51-72-11-911-001, 51-42-11-801 AND DWG D53474180.SDR SWIA202053864Floor Support · corrodedFLOORBEAM AT FS 409-409+16 LBL 9 COROSON IN TWO SPOTS ON INBOARD SIDE, MARKED. C-CHECK RO 11/6/2020. REMOVED CORROSION ON FLOOR BEAM AT LBL 9 BETWEEN FS 409-FS 409+16, INBOARD FLANGE AT 2 EA LOCATIONS IN SHADED ZONE, REF REO. REPAIRED PER REO. COMPLIED WITSDR DALA2020110303557Plate · corrodedDURING INSPECTION FOUND AWR, THICKNESS IS OUT OF ALLOWABLE DAMAGE DUE TO CORROSION ON RT SIDEPLATE, BETWEEN STA 727F TO 767 RBL 21 AT AFT CARGO COMPARTMENT. SIDE PLATE WAS REPLACED BETWEEN STA 727F AND STA 767 AND RBL 021 AT AFT CARGO COMPARTMENT, PER B737-80SDR DALA2020110203552Strap · crackedDURING INITIAL INSPECION FOUND CRACK ON STRAP STA Y 720, RBL 24 AT FWD CARGO COMPARTMENT (CCD). STRAP REPAIRED, PER SRM.SDR DALA2020110203551Floor Support · corrodedDURING INITIAL INSPECTION CORROSION LEVEL 2 FOUND ON FLOOR STRINGER RBL 2 FROM STA 1510 TO 1518 AT AFT CARGO COMPARTMENT (CCT). STRINGER REPAIRED, PER SRM.SDR DALA2020110203550Floor Support · corrodedDURING INITIAL INSPECTION FOUND CORROSION LEVEL 2 ON FLOOR STRINGER LBL 7 STA 1470 AT AFT CARGO COMPARTMENT (CCT). STRINGER WAS REPAIRED, PER SRM.SDR DALA2020110203549Floor Support · corrodedDURING INSPECTION FOUND CORROSION LEVEL 2 ON FLOOR STRINGER LBL 7 FROM STA .1510 TO 1518 AT AFT CARGO COMPARTMENT (CCT). STRINGER REPLACED, PER SRM.SDR IPXA2020103161878Angle · corrodedINSPECTION TYPE: LDS CORRODED SUPPORT ANGLE AT FS 212-237 LBL 64 (FLIGHT DECK FLOOR) ATTACHMENT TO WORK CARD PAGE 2 ITEM 2. FURTHER INSPECTION FOUND CORRODED EDGE ANGLE. FABRICATED REPLACEMENT PART, PER DWG 141T5188 AND GMM 09.10. INSTALLED PER SRM 51-40-02SDR IPXA2020103161877Support Angle · corrodedINSPECTION TYPE: LDSCORRODED SUPPORT ANGLE AT FS 212-237 LBL 64 (FLIGHT DECK FLOOR). REMOVED SUPPORT ANGLE, FABRICATED AND INSTALLED, PER EO B767-5310-78293-A.SDR IPXA2020103061871Web · crackedINSPECTION TYPE: A300 UPON REMOVED OF LAV SUPPORT Y1959 FR 12-FR 17 FOUND WEB AT FR 12A TO FR 14 CRACKED. REMOVED & REPLACED WEB, IAW SRM 51-40-21.SDR IPXA2020103061870Bracket · gougedINSPECTION TYPE: A300 LT WING TOP SURFACE INBOARD AREA UNDER WING TO BODY PANEL 577DT STRUCTURE ANGLE HAS GOUGE. REMOVED & REPLACED BRACKET, IAW SRM 51-40-21.SDR A6WA202011027378Structure · corrodedLBL 27 AT FS 559 +80 TO FS 559+120 T CAP EXTRUSION HAS CORROSION. AIRCRAFT REMOVED FROM SERVICE. REMOVED AND REPLACED T CAP EXTRUSION, LBL 27 AT FS 559 +80 TO FS 559+120, IAW DRAWING 601R35031 AND CRJ 200 SRM 51-42-20.SDR MASA20201102078Intercostal · corrodedC-CHECK INTERCOSTAL CORRODED STGR 21L BETWEEN FS 319-FS 333. REMOVED AND REPLACED INTERCOSTAL.SDR DALA2020103003538Angle · corrodedCORROSION LEVEL 2, DURING INITIAL INSPECTION, CORROSION ON LT SILL ANGLE FROM STA 418 TO STA 440, LBL 64 AT FWD WET ARE OF THE FLOOR STRUCTURE PASSENGER CABIN (CPAX). ANGLE REPLACED PER SRM.SDR DALA2020103003536Intercostal · corrodedAFTER BLEND OUT AREA ON INTERCOSTAL STA Y=680 700 S28L THICKNESS WAS FOUND OUT OF LIMITS. CORROSION LEVEL 2, INTERCOSTAL WAS REPAIRED PER SRM.SDR SWAA2021081330074Strap · corrodedAFT CARGO PIT FLOOR STRAP HAS CORROSION ON AROUND NUT PLATE HOLES AT STA 727D+5. / REMOVED AND REPLACED AFT CARGO FLOOR STRAP AT STA 727D+5; PER SRM 51-40-02 PN 146A9401-8.SDR SWAA2021081230073Strap · corrodedAFT CARGO PIT FLOOR STRAP HAS CORROSION ON AROUND NUT PLATE HOLES AT STA 767+5. / REMOVED AND REPLACED AFT CARGO FLOOR STRAP AT STA 767+5; PER SRM 51-40-02.PN 146A9401-4.SDR SWAA2021071630072Shield · corrodedAFT CARGO PIT RH SHIELD PLATE HAS CORROSION ON AROUND NUT PLATES FROM STA 767 TO STA 787. / WP:E59301-FLOREZ; CARLOS R. - 11/03/2020 13:27 COMPLETE: REMOVED AND REPLACED RH SHIELD (PN 146A8127-11) PER SRM 51-40-02.SDR SWAA2021071630069Support · corrodedFORWARD CARGO PIT R/H AFT SHIELD PLATE STA 490 TO STA 500A HAS CORROSION ON AROUND NUT PLATE HOLES . / WP:E107759-RICHARDSON; ROSS - 11/01/2020 15:02 COMPLETE: REMOVED AND REPLACED R/H SIDEPLATE-SUPPORT ZEE FROM STA 490-500A PER SRM 51-10-02 AND DWG 146A8125-5SDR SWAA2021062930075Angle · corrodedAFT CARGO PIT RH TRANSITION ANGLE HAS CORROSION ON AROUND NUT PLATE HOLES FROM STA 727 TO 767. / WP:E79050-WYATT; DUSTIN - 10/30/2020 14:56 COMPLETE: REMOVED AND REPLACED TRANSITION ANGLE ASSEMBLY I.A.W SRM 51-40-02 AND DWG. 146A7502SDR SWAA2021062430386Scuff Plate · crackedCRACK SCUFF PLATE SERVICE DOOR AT AFT GALLEY AREA / PERFORMED REPAIRED SCUFF PLATE SERVICE DOOR AT AFT GALLEY AREA IAW B737-700 SRM 51-70-15-2R-1 REPAIR 1 PARAGRAPH 4.BSDR SWAA2021052626955Gusset · crackedFWD CARGO BAY AFT BULKHEAD SUPPORT GUSSET IS CRACKED BS500D S-19R WL193. MARKED / DAMAGE FOUND ON FCB GUSSET BS 500D STR- 19R FOUND TO BE OUT OF LIMIT DUE TO NO LIMIT ON SRM PARTS WILL REPAIRE BY REPLACEMENT IAW SRM 51-10-02-0G-0 PAR. 9C LOCATED AND DRILLED NESDR SWAA2021052526954Gusset · crackedFWD CARGO BAY AFT BULKHEAD SUPPORT GUSSET IS CRACKED BS500D S-19L WL193. MARKED / DAMAGE FOUND ON FCB GUSSET BS500D STR-19L FOUND TO BE OUT OF LIMIT DUE TO NO LIMIT ON SRM PARTS WILL BE REPAIRED BY REPLACMENT IAW SRM 51-10-02-0G-0 PAR-9C LOCATED AND DRILLED NESDR SWAA2021021126949Support · corroded***CORROSION*** ON FLOOR TO SIDEWALL SUPPORT AT FWD CARGO BAY BS400 - BS420 RBL23 WL157. / REMOVED AND INSTALLED FLOOR TO SIDEWALL SUPPORT AT FCB BS 400 BS 420 FROM BAC1496-444-7075T62C LOT# 1440365-1 LOCATED AND DRILLED IAW SRM 53-00-53-1A-2; SRM 51-40-02; SRSDR SWAA2021021126928Shield · corroded***CORROSION*** ON AFT SHIELD AT FWD CARGO BAY BS500 - BS500A RBL23 WL157. / REMOVED AND INSTALLED ON AFT SHIELD AT FCB BS500-BS500A RBL23 ITEM 7531855 PO# 806203 IAW SRM 51-40-05; SRM 51-40-02; DWG 143A8126 AND DWG 143A0080 80641U 03NOV20SDR SWAA2021021126945Support · corroded***CORROSION*** ON FLOOR TO SIDEWALL SUPPORT AT FWD CARGO BAY BS400 - BS500D LBL23 WL157. / REMOVED & REPLACED FLOOR TO SIDEWALL SUPPORT AT FWD CARGO BAY FROM BS 400-BS 500D IAW DWG 143A7500 & SRM 51-40-02-0G-0SDR SWAA2021021126948Shield · corroded***CORROSION*** ON FWD SHIELD AT FWD CARGO BAY BS440 - BS420 RBL23 WL157. / REMOVED AND REPLACED FWD SHIELD AT FWD CARGO BAY BS420-440 RBL23 WL157 AS PER SRM 51-40-02-0G-0 AND DRAWING # 143A0080; SHIELD WAS EVALUATED AND FOUND TO BE OUT OF LIMITS DUE TO NO LIMSDR SWAA2021021126927Support · corroded***CORROSION*** ON FLOOR TO SIDEWALL SUPPORT AT FWD CARGO BAY BS500D - BS500A RBL23 WL157. / REMOVED AND REPLACED FLOOR SIDEWALL SUPPORT AT FCB BS 500D-500A RBL 23 WL 157 AS PER SRM 51-40-02-0G-0 AND DRAWING #143A7500; SIDEWALL SUPPORT WAS EVALUATED AND FOUND SDR SWIA202054831Door Sill · corrodedSERVICE DOOR LOWER SILL ALL ATTACH ANGLES AND LATCH FITTINGS CORRODED. C-CHECK RO 12/26/2020. REPLACED SERVICE DOOR LOWER SILL ALL ATTACH ANGLES AND LATCH FITTINGS, REF CRJ900 SRM AND CRJ900 AMM.SDR SWIA202054764Door Sill · corrodedSERVICE DOOR LOWER SILL CORRODED. C-CHECK RO 12/26/2020. REPLACED SERVICE DOOR LOWER SILL ANGLE, REF CRJ 900 SRM AND BOMBARDIER DWG.SDR SWIA202054763Door Sill · corrodedPAX DOOR LOWER SILL ANGLE CORRODED. C-CHECK RO 12/26/2020. PAX DOOR LOWER SILL HAS 100% EXFOLIATION, OUT OF LIMITS, REF CRJ900 SRM. INSTALLED NEW PAX DOOR LOWER SILL ANGLE, IAW CRJ 900 SRM AND BOMBARDIER DWG.SDR SWIA202054436Floor Support · corrodedFLOOR SUPPORT BOLT DOUBLER AT FS 308 LBL 20 IS CORRODED. C-CHECK RO 11/24/2020. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS, IAW CRJ 200 SRM. REMOVED AND REPLACED FLOOR SUPPORT BOLT DOUBLER AT FS 308, IAW CRJ 200 SRM. REFERENCE CONTINUATION CARD FOR WOSDR SWIA202054435Floor Support · corrodedFLOOR SUPPORT BOLT HOLE DOUBLER AT FS 288 LBL 37 IS CORRODED. C-CHECK RO 11/24/2020. REPLACED FLOOR SUPPORT BOLT HOLE DOUBLER AT FS 288 LBL 37. REFERENCE CONTINUATION CARD FOR THE WORK PERFORMED.
Back to JASC 5320