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 SWAA2021041356435Scuff Plate · crackedCRACK AFT CORNER SCUFF PLATE AT AFT CARGO COMPARTMENT / REPAIRED AFT CORNER SCUFF PLATE AT AFT CARGO COMPARTMENT IAW BOEING 737-700 SRM 53-60-15-2R-1 REPAIR 1 PARAGRAPH 4B(4) AND BAC 5975SDR SWAA2021040655696Angle · corrodedAFT CARGO RT TRANSITION ANGLE HAS NUMEROUS AREAS OF CORROSION OUT OF LIMITS FROM 727F + 15.5 INCHES TO 767. / REMOVED AND REPLACED SECTION TRANSITION ANGLE R/H FROM STA 727E + 10 TO 767 PER SRM. 51-10-02 INSTALLED SPLICES TRANSITION ANGLE PER SRM. 53-00-53-2R-SDR SIMA20210315002Support · corrodedSSI 53-200-29 TOILET WASTE VALVE SUPPORT IS CORRODED ON EXTERNAL SKIN. CORROSION LEVEL 2-C/A-REMOVED AND REPLACED WASTE VALVE SUPPORT IAW EMB 145 SRM 51-40-02SDR IPXA2021032467210Support · crackedINSPECTION TYPE:CEXTERNAL LOWER FUSELAGE AT FR45 AIRCON FAIRING 144FR AFT SUPPORT BRACKET CRACKEDREMOVED AND REPLACED IAW SRM 51-40-21SDR DALA2021031801537Stiffener · crackedDURING INSPECTION MAINTENANCE FOUND CRACK ON RH NOSE WHEEL VERTICAL STIFFNER FILLET RADIUS AT WL172 APPROX 1 INCH LONG REPAIRED ON WORK CARD 5312-01186-02B, (LP 1755420)SDR DALA2021031801536Stiffener · crackedDURING INSPECTION MAINTENANCE FOUND 01EA CRACK ON NOSE WHEEL LH VERTICAL STIFFENER FILLET RADIUS AT WL172 APPROX 1 INCH LONG. CRACKED AREA REPAIRED. (LP 1755419)SDR DALA2021031501450Strap · brokenDURING INSPECTION MAINTNENACE FOUND BROKEN STABILIZER STRAP BTW STA 365 377 AND 25 LBL AT MAIN EQUUIPMENT CENTER. AND REPAIRED PER SRM. (LP 1755294)SDR DALA2021031501457Intercostal · crackedSHIP 3247 CRACK INDICATION AT DOOR STOP #7, FR 16-, LH SIDE, HOLE #2 IN THE INTERCOSTAL. CORRECTIVE ACTION: COMPLIED WITH ERA 590536-14AD REV O. (1755490)SDR SWIA202158474Floor Support · corrodedCOCKPIT FLOOR SUPPORT HAS POSSIBLE CORROSION. (C-CHECK RO 5/25/2021) REMOVED AND REPLACED COCKPIT FLOOR SUPPORT IAW BOMBARDIER DWG CC670-34010 REV.-K CRJ-900 SRM 51-42-06-001-001-A01 REV.38 25JUL2020 CRJ-900 SRM 51-42-21-001-001-A01 REV.38 25JUL2020. COSDR SWIA202157980Door Sill · corrodedAFT CARGO DOOR LOWER SILL IS CORRODED. (C-CHECK RO 5/3/2021) REPLACED AFT CARGO DOOR LOWER SILL REF DWG MM670-35065 REV. L CRJ900 SRM 51-42-06-001-001-A01 CRJ900 SRM 51-42-13-001-001-A01 CRJ900 SRM 51-42-21-001-001-A01. LEAK CHECK GOOD. COMPLIED WITH 51SDR SWIA202157945Channel · dented* FS280 RBL9 CHANNEL DENTED AT APPROXIMATELY 3€? FROM UPPER SKIN & 2€? ABOVE FLOOR LEVEL (C-CHECK RO 5/3/2021) REPAIRED FS280 RBL 11 CHANNEL ( LOCATION CLARIFIED IN CONTINUATION) REF REO 601R-53-11-3679 REV-- DATED 2021-04-26. COMPLIED WITH SKYWESTSDR SWAA2021041456425Gusset · crackedCRACK GUSSET LOCATED ON BS500D AND STR19R FWD CARGO COMPARTMENT /REPLACED GUSSET LOCATED ON BS 500D AND STR 19R FWD CARGO COMPARTMENT IAW B737-700 SRM 51-10-02 ITEM 9; SRM 51-40-02 AND DRAWING #143A7902 REV. A; P/N USED:143A9481-5SDR SWAA2021041456427Angle · crackedCRACK ANGLE - CLIP LOCATED ON BS400 AND STR26L FWD CARGO COMPARTMENT / REMOVED AND REPLACED ANGLE -CLIP LOCATED BS400 AND STR26L FWD CARGO COMPARTMENT IAW BOEING 737-700 SRM 51-40-02 AND 51-10-02 DWG #143A7505 PN USED 143A7502U155 . REPLACED DUE TO NOT FOUND ASDR SWAA2021041456426Gusset · crackedCRACK GUSSET LOCATED ON BS500D AND STR19L FWD CARGO COMPARTMENT REPLACED GUSSET LOCATED ON BS 500D AND STR 19G FWD CARGO COMPARTMENT IAW B737-700 SRM 51-10-02 ITEM 9 SRM 51-40-02 AND DRAWING #143A7902 REV A PN USED 143A9481-6SDR SWAA2021041356428Scuff Plate · crackedCRACK FWD CORNER SCUFF PLATE AT AFT CARGO COMPARTMENT / REPAIRED BY WELD FWD CORNER SCUFF PLATE AT AFT CARGO COMPARTMENT IAW BOEING 737-700 SRM 53-60-15-2R-1 REPAIR 1 PARAGRAPH 4B STEP (4) AND BAC 5975SDR AALA202104129003Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: AFT GALLEY AREA CRACKED SHEAR PLATE LOCATED BETWEEN FR 69 AND FR 70 AT S23L. REPLACED SHEAR PLATE PER SRM 51-42-11-801 AND DRAWING D53474180.\\SDR AALA202104129002Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: AFT GALLEY AREA CRACKED SHEAR PLATE LOCATED BETWEEN FR 69 AND FR 70 AT S23R. REPLACED SHEAR PLATE PER SRM 51-42-11-801 AND DRAWING D53474180.SDR SWAA2021040755277Angle · corrodedAFT CARGO FLOOR STRUCTURE HAS CORROSION ON R/H TRANS ANGLE FROM STA 767-787 / REMOVED ERROR. ON TRANSITION ANGLE MATERIAL REMOVED FOUND OUT OF LIMITS PER SRM. 51-10-02; 53-00-53-1A-2; REMOVED AMD REPLACED R/H TRANSITION ANGLE FROM STATION 767 TO 793PER SRM 51-SDR AALA202104059002Support · corrodedAIRCRAFT IN BASE MAINTENANCE: FOUND CORRODED AREA ON LOWER SILL AT FR66 AND STR 23R IN AFT GALLEY AREA, MEASURING 0.797 X 0.375 X 0.015 INCH. REPLACED LOWER SILL IAW A321 SRM 51-42-11-801 AND DWG # D53480505.SDR AALA202104059001Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: FOUND CORRODED AREA ON CENTER FITTING AT FR66 AND STR 23L, MEASURING 1.171 X 0.360 X 0.010 INCH. REPLACED CENTER FITTING IAW A321 SRM 51-42-11-801 AND DWG D53480505.SDR AALA202103319011Support · corrodedAIRCRAFT IN BASE MAINTENANCE: FOUND CORRODED AREA ON LOWER SILL AT FR66 AND STR 23R MEASURING L= 0.589 INCH, W= 0.406 INCH, D= 0.006 INCH. PERFORMED PERMANENT REPAIR ON LOWER SILL LOCATED AT FR66 STR 23R IAW A321 SRM 53-41-14-300-001-A.SDR HNAA2021033000108Angle · corrodedCARGO DOOR LOWER INNER ANGLE HAS CORROSION AROUND NUT PLATE HOLES...REMOVED AND INSTALLED SERVICEABLE CARGO
DOOR LOWER INNER ANGLE IAW EMB 145 SRM 51-40-02.SDR AALA202103229017Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORRODED AREA ON LOWER SILL AT FR68 STR 23R L: 7.063 INCHES, W: 1.963 INCHES, D: 0.063 INCHES. PERFORMED PERMANENT REPAIR ON LOWER SILL AT FR68 STR 23R PER SRM 53-41-14-300-001.SDR SWAA2021031855206Panel · crackedFWD CARGO COMPARTMENT CARGO PANEL (122ZCC) HAS HOLE IN IT. REFERENCE MT 705-00-05 CRACK: LENGTH-4IN WIDTH-.4INPERFORMED INTERIM REPAIR ON CARGO PANEL (122ZCC) PER EA-A25-3722 REV. 4 EVERY 8 DAYS PERFORM A DETAILED VISUAL INSPECTION OF THE REPAIRED AREA FOR ADDSDR DALA2021031701513Panel · damaged(LOG 7182836) DURING POST-FLIGHT INSPECTION IT WAS DISCOVERED THAT THE PANEL AFT ON THE RIGHT WHEEL WELL IS BADLY DAMAGED- MOST OF IT IS MISSING. REMOVED BROKEN PANEL 193CR. INSPECTED UNDERLYING STRUCTURE NO DAMAGE NOTED. INSTALLED NEW PANEL PER B737 AMM 53-51SDR DALA2021031501449Angle · crackedDURING INSPECTION MAINTENANCE FOUND CORROSION AND CRACK ON ANGLE OF STRINGER 27R BTW STA 1360 TO 1380. CW ERA 590590 14 (LP 1755078)SDR DALA2022112807577Door Sill · damagedSHIP 659 ER/A 590590-14 SEC III REQUIRED FOR THE NO. 2 CARGO DOOR LOWER SILL CHORD. CORRECTIVE ACTION: SUMMARY: AREA WAS REPAIRED PER ER/A 590590-14 REV A SECTION II: PERMANENT REPAIR AND LOG PAGE 1754283, 2508077. (1754290)SDR DALA2021070203653Support Angle · crackedSHIP 3302 CRACK SUPPORT ANGLE BTW FR79 TO FR80 AT LEVEL STR 26L AT AFT GALLEY AREA. CORRECTIVE ACTION: REPLACED SUPPORT ANGLE BTW FR79 TO FR80 AT LEVEL STR 26L AT AFT GALLEY AREA AS PER A330 SRM 51-72 AND DRAWING F53470014. (1754153)SDR REXA2021050500192Angle · corrodedUPON REMOVAL OF FS 280 L/H LOWER WEB FOUND STIFFENER ANGLE AT LBL 17.46 TO BE DAMAGED. - REMOVED,LOCATED, AND DRILLED AND INSTALLED NEW SERVICEABLE STIFFENER ANGLE AT LBL 17.46 P/N:CC670-34151-5 IAW CRJ 700 SRM 51-40-11-001-001-A01 AND SRM 51-42-06-001-001-A01SDR SWIA202157897Support · cracked*SUPPORT AT APPROX FS 469 FOR RH UPPER WING TO FUSELAGE FAIRING 162EL HAS CRACK. (C-CHECK RO 4/25/2021) REMOVED AND REPLACED ANGLE SUPPORT FAIRING SIDE ACCES PN 601R31037-62 AT FS469.00 RH UPPER WING UNDER FUSELAGE FAIRING 162EL. REF. CRJ 200 SRM 51-42-SDR SWIA202157896Support · cracked*SUPPORT AT APPROX FS 461.5 FOR RH UPPER WING TO FUSELAGE FAIRING 162EL HAS CRACK. (C-CHECK RO 4/25/2021) REMOVED AND REPLACED ANGLE SUPPORT FAIRING SIDE ACCESS PN 601R31037-42 AT FS461.5 RH UPPER WING TO FUSELAGE FAIRING 162EL. REF. CRJ 200 SRM 51-42-0SDR SWIA202157895Support · cracked*SUPPORT AT APPROX FS 476 FOR LH UPPER WING TO FUSELAGE FAIRING 161DL HAS CRACK. (C-CHECK RO 4/25/2021) REMOVED AND REPLACED CRACK BRACKET WITH NEW BRACKET, LOCATED AT APPROX FS476, L/H UPPER WING TO FAUSELAGE FAIRING 161DL. REF: CRJ 200, SRM 51-41-02, SDR SWIA202157894Support · cracked*SUPPORT AT APPROX FS 469 FOR LH UPPER WING TO FUSELAGE FAIRING 161DL HAS CRACK. (C-CHECK RO 4/25/2021) REMOVED AND REPLACED CRACKED BRACKET WITH NEW BRACKET, LOCATED AT APPROX FS469, L/H UPPER WING TO FUSELAGE FAIRING 161DL. REF: CRJ 200, SRM 51-41-02,SDR SWIA202157889Floor Support · corroded*RBL9 FLOOR BEAM, BETWEEN APPROX. FS409+4 TO FS409+122 HAS CORROSION. (MARKED) (C-CHECK RO 4/25/2021) NO CORROSION FOUND AT RBL9 FLOOR BEAM FROM FS409+4 TO FS409+5 AND FROM FS409+118 TO FS409+122. REMOVED AND REPLACED THE FLOOR BEAM CAP RBL9 BETWEEN FS4SDR SWIA202157888Floor Support · corroded*RIGHT SIDE FLOOR SILL HAS CORROSION, BETWEEN APPROX. FS310 TO FS319(MARKED) (C-CHECK RO 4/25/2021) REMOVED AND REPLACED RH FLOOR SILL BETWEEN FS 310 AND FS319 REF CRJ200 SRM 51-42-06, CRJ200 SRM 51-45-00, CRJ200 SRM 51-42-21 AND DWG 601R31148 REV-J. COSDR FDEA202103130635Web · crackedR1 DOOR CUTOUT, HINGE BOX, INBOARD WEB IS CRACKED REMOVED, FABRICATED AND INSTALLED NEW WEB IAW BOEING DWG 141N8415 AND DWG 141N8441SDR SWAA2021040157083Bracket · crackedCRACK BRACKET LOCATED AT BST 867 AT LEVEL FLOOR STRUCTURE AT AFT CARGO COMPARTMENT / REPLACED BRACKET AND FASTENERS LOCATED AT BST 867 AND LBL 13.8 AT LEVEL FLOOR STRUCTURE AT AFT CARGO COMPARTMENT IAW B737-700 SRM 51-10-02; ITEM 9 AND DRAWING #149A8102 SHEET SDR SWAA2021040160648Fastener · crackedCRACK BRACKET LOCATED AT BST 867 AT LEVEL FLOOR STRUCTURE AT AFT CARGO COMPARTMENT / REPLACED BRACKET AND FASTENERS LOCATED AT BST 867 AND LBL 13.8 AT LEVEL FLOOR STRUCTURE AT AFT CARGO COMPARTMENT IAW B737-700 SRM 51-10-02; ITEM 9 AND DRAWING #149A8102 SHEET SDR HNAA2021033000113Door Sill · corrodedSERVICE DOOR FWD SILL IS CORRODED AT AFT SCREW HOLE....REMOVED SERVICE DOOR FWD SILL, REMOVED SERVICE DOOR FWD SILL FR-20 T BRACKET TO FOM. INSTALLED SERVICEABLE SERVICE DOOR FWD SILL AND INSTALLED SERVICE DOOR FWD SILL FR-20 T BRACKER AFTER MTX IAW EMB 145 SRSDR REXA2021032400175Retainer · crackedLH FS484 I/B O/B CLIP ARE CRACKED REMOVED AND REPLACED LH CLIP AT FS 484 IAW CRJ 200 SRM 51-42-21SDR DALA2021031601472Floor Support · crackedSHIIP 3302 CRACK FLOOR STRUCTURE WEB AT LEVEL STR 26L BTW FR75 TO FR76 AT AFT GALLEY AREA. CORRECTIVE ACTION: REPLACED NEW SHEAR WEB AND FASTENER LOC. AT LEVEL STR 26L BTW FR75 TO FR76 AS PER A330 SRM 51-42. (1754169)SDR AALA202103169006Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND CRACKED INTERCOSTAL BETWEEN STA 312 AND 328 AT LBL 46.25. REPLACED INTERCOSTAL PER SRM 51-00-05.SDR SWIA202157915Strap · corroded* CORROSION ON STRAP AT FS559+80 BETWEEN RBL9 AND RBL 27. (C-CHECK RO 4/25/2021) REMOVED AND REPLACED WITH NEW FLOOR SUPPORT PLATE P/N 601R32215-43 CRJ200 SRM 51-42-06SDR SWIA202157904Strap · corroded* CORROSION ON STRAP BETWEEN RBL9 AND RBL27 AT FS559+48. (C-CHECK RO 4/25/2021) REMOVED AND REPLACED WITH NEW FLOOR SUPPORT PLATE P/N 601R32215-43 CRJ200 SRM 51-42-06SDR SWIA202157886Floor Support · corroded* CORROSION ON LBL9 FLOOR BEAM CAP BETWEEN FS559+10 AND FS569 AT MULTIPLE LOCATIONS. (C-CHECK RO 4/25/2021) REMOVED CORROSION FROM THE LBL9 FLOOR BEAM CAP BETWEEN FS559+10 AND FS569 REF. CRJ200 SRM 51-21-06. EVALUATED AND FOUND TO BE OUT OF LIMITS. REMOSDR SWIA202157885Floor Support · corroded* CORROSION ON RBL9 FLOOR BEAM CAP BETWEEN FS559+10 AND FS569 AT MULTIPLE LOCATIONS. (C-CHECK RO 4/25/2021) REMOVED CORROSION ON THE RBL9 FLOOR BEAM CAP BETWEEN FS559+10 AND FS569 REF. CRJ200 SRM 51-21-06. EVALUATED AND FOUND TO BE OUT OF LIMITS. REMOVESDR SWIA202157884Floor Support · corroded* MULTIPLE SPOTS OF CORROSION ON LH FLOOR SILL BETWEEN FS559+16 AND FS559+84. (C-CHECK RO 4/25/2021) REMOVED AND REPLACED NEW LH FLOOR SILL P/N 601R31133-77 BETWEEN FS 559+16 AND FS 559+84 REF CRJ-200 SRM 51-42-06, CRJ-200 SRM 51-42-21, CRJ-200 SRM 51-4SDR SWIA202157883Floor Support · corroded* RBL 27 FLOOR BEAM CAP HAS CORROSION BETWEEN FS559+64 AND FS559+83. (C-CHECK RO 4/25/2021) REMOVED AND REPLACED WITH NEW FABRICATED FLOOR BEAM CAP AT RBL 27 BETWEEN FS 559+10 AND FS 569 REF DWG 601R31119 REV -H, DWG 601R31030 REV -P, DWG 601R31005 REV SDR SWIA202157882Floor Support · corroded* LBL 9 FLOOR BEAM CAP OUTBOARD FLANGE HAS SPOTS OF CORROSION BETWEEN FS589 AND FS621. (C-CHECK RO 4/25/2021) REMOVED CORROSION ON LBL 9 FLOOR BEAM CAP OUTB`D FLANGE BETWEEN FS 589 AND FS 621 REF CRJ200 SRM 51-21-06 / ORIGINAL MATERIAL THICKNESS OF FLOOSDR IPXA2021033067548Gusset · crackedINSPECTION TYPE:A300AC BAY CEILING LH PANEL SUPPORT RIB HAS CRACK MID SECTION APPROX 6IN O/B OF THE TORQUE TUBEREMOVED AND REPLACED IAW SRM 51-40-21
Back to JASC 5320