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 FDEA2020081211863Web · corrodedMAIN DECK BETWEEN BS 1681 - 1720 BL 0 - RBL 58.22 WEB CORRODED.SDR ABXR2020081100071Support Bracket · corrodedMAIN DECK CARGO DOOR VIEW PORT CORRODED ON THE MOUNTING FLANGE. REPAIRES MAIN DECK CARGO DOOR VIEW PORT MOUNTING FLANGE I/A/W REA 47417REA20 AND NR 0669.SDR VNAA202008119995Floor Support · corrodedFLOOR BEAM CAP CORRODED AT LBL 27 FS 617 TO 621. REMOVED LBL 27 FLOORBEAM FITTING AT FS 617 - 621 IAW CRJ 200 SRM 51-42-06 AND 51-42-21. PN 601R35289-1. INSTALLED NEW SERVICEABLE LBL 27 FLOORBEAM FITTING IAW REO 601R-53-61-3778 REV B DATED 12/19/16.SDR VNAA202008119994Floor Support · crackedFLOOR BEAM CAP CORRODED AND CRACKED AT LBL 27 BETWEEN FS 574.00 TO FS 621.00. INSTALLED NEW SERVICEABLE FLOOR BEAM CAP IAW REO 601R-53-61-3778 REV B DATED 12/19/16.SDR ABXR2020081100067Floor Support · corrodedCORRODED INTERCOSTAL, LOCATED AT BOTTOM OF UPPER CARGO FLOOR BEAM AT STA 764, RBL 12. REMOVED AND REPLACED INTERCOSTAL IAW SRM 53-30-50.SDR SWAA2021081107684Strip · damagedAFT CARGO BAY FORWARD BULKHEAD CAP STRIP (453A2511-1) IS DAMAGED / RECEIVED NEW ACB FWD BLK HD CAP STRIP (453A2511-1) ON PO# 800158. NEW CAP STRIP TO BE INSTALLED ON CUST CARD # JPANEL-141-CLOSESDR SWAA2021072807413Support Angle · crackedFWD CARGO COMPMT. BILGE SUPPORT CLIP CRACKED AT S-27R AND STA 500 MKD DOT 60-022 / REMOVED AND REPLACED SUPPORT CLIP AT FWD CARGO STA 500 S-27R AS REF B737-700 SRM 51-40-02-0G-0SDR SWAA2021071507426Floor Support · corrodedCORROSION AFT OF AFT CARGO COMPMT. BILGE FLOOR SUPPORT ANGLE FASTENER HOLES BETWEEN STA 927 & 947.5 RBL-13.8 WL155.5 MKD DOT 60-028 / FOUND DEEP CORROSION AROUND FASTENERS OUT OF LIMITS AT AFT CARGO FLOOR SUPPORT ANGLE (TRACK) STA 927 TO 947 AS PER REF. B737-7SDR SWAA2021052607060Gusset · crackedFWD CARGO COMPARTMENT; FWD OF (AFT BULKHEAD) STA 500D; S20L ANGLE NOTED CRACKED. / REMOVED AND INSTALLED NEW GUSSET (ANGLE) AS PER B737-700 SRM 51-40-02-0G-0.SDR SWAA2021040807430Channel · corrodedCORROSION AFT CARGO COMPMT. BILGE FLOOR SIDE Z CHANNEL FROM STA 727E + 10 TO STA 847 S-26L WL 155.5 MKD DOT 60-032 / REMOVED DAMAGED Z CHANNEL AND REPLACED AT AFT CARGO L/H STA 727E TO STA 847 AS PER B737-700 SRM 51-40-02-0G-0 AND DWG # 146A7502. FOUND DEEP COSDR SWIA202052714Intercostal · corroded20L LONGITUDINAL JOINT FS 310 TO 319 INTERCOSTAL CORRODED. C-CHECK RO 9/21/2020. REMOVED AND REPLACED INTERCOSTAL/BACK UP SILL, REF DWG SH670-31810 REV AE AND CRJ700 SRM. ALL CHECKS OKAY, COMPLETED TASK CARD.SDR AALA202008279003Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF LOWER FRAME WEB ON AFT CARGO DOOR BETWEEN STA 797 AND STA 827 AT STR 25R, MEASURING L=10.0 IN, W=3.0 IN, D=0.008. REPLACED WEB WITH NEW IAW AARD 51-00-05-1.SDR AALA202008269007Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: FOUND CORROSION ON RH SHIELD BETWEEN STA 492-500A AND BL 25R. REMOVED AND REPLACED SHIELD.SDR AALA202008199001Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: FOUND CORRODED TRANSITION PANEL AT STA 500C-500I AND STR 25L. REPLACED SECTION OF TRANSITION PANEL AND SPLICED PER SRM 53-00-53-32R-5.SDR SWAA2020081707397Angle · crackedRIGHT PACK BAY. LOWER CENTER TANK HORIZONTAL ANGLE AT STATION 663 IS CRACKED 2ND FASTENER OUTBOARD OF VERTICAL KEEL BEAM ANGLE. MARKED /SDR UIEA2020081381640Channel · cracked1EA THROUGH THICKNESS CRACK WAS FOUND ON THE MARKED HOLE AT THE AFT CHANNEL LAYER ( 2ND LAYER COUNTED FROM FWD ) ON 5 O'CLOCK POSITION ON RH STA 840 TENSION TIE.(<P>REPAIRED AS PER SRM 53-20-30-2R-1 REPAIR 1 FIG 201.</P>)SDR AALA202008119002Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM 2 END FITTING BEARING ON RH HORIZONTAL STABILIZER. REPLACED HINGE ARM FITTING #2 ON RH ELEVATOR IAW AMM 55-16-42-400-001-A.SDR IPXA2020081108879Floorboard · damagedINSPECTION TYPE: SEG, FLOORBOARD 231XG DAMAGED. REPAIRED IAW SREO A300-5320-42722-F.SDR ABXR2020081000055Shear Tie · corrodedBS 720 SHEAR TIE CORRODED BETWEEN STRINGERS 35L-36L. REMOVED THE CORROSION, ORIGINAL THICKNESS .060, REMOVED .015, REMAINING THICKNESS .045, AND FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07. REMOVED AND REPLACED THE SHEAR TIE IAW SRM 51-40-02.SDR ABXR2020081000052Shear Tie · corrodedSTA 698 HAS CORR SHEAR TIE BETWEEN STR 34L AND 35L. REMOVED CORROSION ORIGINAL THICKNESS .050 REMOVED .010 REMAINING THICKNESS .040 FOUND TO BE OUT OF LIMITS IAW B767 SRM 53-00-07. REMOVED OLD SHEAR TIE AND REPLACED WITH NEW SHEAR TIE B767 SRM 51-40-02.SDR ABXR2020081000050Web · corrodedCORROSION ON WEB AT BS 390, STRINGERS 29L-28L. REMOVED AND REPLACED WEB AT STA390 STR 29L-28L IAW BOENING DWG 14IT1223, AND SRM 51-40-02. REF CWO 123512-0020 AND AMES REA 47417 FAB 06.SDR ABXR2020081000047Floor Support · crackedFLOOR STRINGER SUPPORT IS CRACKED AT THE UPPER RIVET, ON THE FWD SIDE OF FRAME 1417, ABOVE STR.38L, AT FRAME 1417 UPPER CHORD. REMOVED AND REPLACED FLOOR STRINGER SUPPORT ON THE FWD SIDE OF 1417 AT STR 38L IAW B767 SRM 51-40-02 PAR. 7SDR SWAA2021081311232Support Angle · corrodedCORROSION SUPPORT ZEE LOCATED BETWEEN BS727B TO BS767; RBL19 AND WL154.5 AFT CARGO COMPARTMENT / REPLACED SUPPORT ZEE LOCATED BETWEEN BS727B TO BS767 RBL 19 AND WL 154.5 AFT CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 AND SRM 51-10-02 ITEM 9 DRAWING #146A7500 SDR SWAA2021081311234Strap · corrodedCORROSION STRAP LOCATED BETWEEN BS767 TO BS787; RBL19 TO LBL19 AND WL154.5 AFT CARGO COMPARTMENT (1 EA) / REPLACED STRAP LOCATED BETWEEN BS 767 TO BS 787 RBL 19 TO LBL 19 AND WL 154.5 AFT CARGO COMPARTMENT I.A.W B737-700 SRM 51-40-02 AND DWG 146A7500 REV.- SHESDR SWAA2021062407174Scuff Plate · crackedFWD CARGO DOOR AFT SCUFF PLATE CORNER IS CRACKED.DOT 82-004. / ACCOMPLISHED WELDING REPAIR OF DAMAGE SCUFF PLATE AT FWD CARGO AFT CORNER PER REF B737 SRM 53-30-15-2R-1. INSTALLATION WILL BE ACCOMPLISHED ON CUSTOMER CARD J753-646-62-01SDR AALA202008169012Fitting · corrodedAIRCRAFT IN BASE MAINTENACE. FOUND CORROSION ON L-4 DOOR SHAPE. REMOVED AND REPLACED DOOR SHAPE. SUPPLEMENTAL REPORT: AFTER FURTHER EVALUATION ENGINEERING DETERMINED THIS EVENT NOT TO BE CPCP RELATED AND DOWNGRADED THE CORROSION LEVEL FROM 2 TO 0. SECTION SDR SWIA202052707Floor Support · corrodedCORROSION ON RT PRESSURE FLOOR SILL BETWEEN FS 797.00 FS 830.40, MARKED. C-CHECK RO 9/21/2020. REMOVED CORROSION ON RT FLOOR SILL ANGLE BETWEEN FS 797.00 FS 830.40, REF CRJ700 SRM. COMPLIED WITH MHIRJ REO. SEE CONTINUATION FOR DETAILS.SDR SWIA202052706Floor Support · corrodedCORROSION ON LT PRESSURE FLOOR SILL BETWEEN FS 797.00 FS 813.00, MARKED. C-CHECK RO 9/21/2020. REMOVED CORROSION ON LT FLOOR SILL BETWEEN FS 797.00 FS 813.00, REF CRJ700 SRM. COMPLIED WITH MHIRJ REO. SEE CONTINUATION FOR DETAILS.SDR SWIA202052705Floor Support · corrodedCORROSION ON LT FLOOR SILL BETWEEN FS 677.00 FS 693.00, MARKED. C-CHECK RO 9/21/2020. REPAIRED CORROSION DAMAGE ON FLOOR SILL FS 677.00 FS 693.00 LT, COMPLIED WITH ALL STEPS CRJ700 SRM. LOCALLY BLENDED OUT DAMAGE TO A SMOOTH CONTOUR, NO BLEND PERFORMED OVERSDR SWIA202052704Floor Support · corrodedCORROSION ON LT FLOOR SILL BETWEEN FS 517.00 FS 533.00, MARKED. C-CHECK RO 9/21/2020. REMOVED CORROSION ON LT FLOOR SILL BETWEEN FS 517.00 TO FS 533.00, REF CRJ700 SRM. EVALUATED BLENDS NR 1, NR 2 AND NR 3 ON LT FLOOR SILL BETWEEN FS 517.00 TO FS 533.00 ORISDR SWIA202052703Floor Support · corrodedCORROSION ON RT FLOOR SILL AT FS 693.00, MARKED. C-CHECK RO 9/21/2020. REMOVED CORROSION ON FLOOR SILL RBL 36 FS 690.00 TO 693.00, REF CRJ700 SRM. EVALUATED CORROSION REMOVAL FLOOR SILL RBL 36 BETWEEN FS 690.00 TO FS 693.00. THE REMAINING MATERIAL THICKNESSDR SWIA202052695Intercostal · corrodedCORROSION ON VARIOUS AREAS OF INTERCOSTAL ATTACHED TO STGR 24L BETWEEN FS 517.00 FS 533.00, MARKED. C-CHECK RO 9/21/2020. REMOVED CORROSION ON INTERCOSTAL ATTACHED TO STGR 24L BETWEEN FS 517.00 FS 533.00, IAW CRJ700 SRM. EVALUATED BLEND NR 1 AND NR 2 ON INTSDR SWIA202052692Door Sill · corrodedCORROSION ON VARIOUS AREAS OF THE FWD CARGO DOOR SILL, MARKED. C-CHECK RO 9/21/2020. REPAIRED CORROSION ON VARIOUS AREAS OF THE FWD CARGO DOOR SILL, REF MHIRJ REO AND CRJ700 SRM. COMPLIED WITH TASK CARD.SDR SWIA202052689Plate · corrodedCORROSION ON UPPER INTERNAL JOINT PLATE AT FS 581.00 STGR 19L, MARKED. C-CHECK RO 9/21/2020. REPAIRED CORROSION ON UPPER INTERNAL JOINT PLATE AT FS 581.00 STGR 19L, REF MHIRJ REO. SEE CONTINUATION FOR DETAILS. COMPLIED WITH TASK CARD.SDR SWIA202052680Floor Support · corrodedLT CABIN FLOOR SILL FS 969.00 1000.00 HAS CORROSION AROUND FASTENER HOLES, MARKED. C-CHECK RO 9/21/2020. REPAIRED CORROSION DAMAGE ON FLOOR SILL FS 969.00 TO FS 1000.00 LT COMPLIED WITH ALL STEPS CRJ700 SRM. LOCALLY BLENDED OUT DAMAGE TO A SMOOTH CONTOUR, SDR SWAA2020092111581Web · crackedCRACK WEB LOCATED BETWEEN BS 294.5 TO BS 303.9 STRINGER 16L AT FWD GALLEY AREA. REPLACED WEB LOC BETWEEN BS 294.5 TO BS 303.9 STRINGER 16L AT FWD GALLEY AREA, IAW B737-700 SRM 51-10-02-0G-0 AND B737-700 SRM 51-40-02-0G-0 AND DWG 141A8180 SHEET 27 REV C.SDR SWAA2020092111231Support · corrodedCORROSION SUPPORT ZEE LOCATED BETWEEN BS 727B TO BS 807 LBL 19 AND WL 154 .5 AFT CARGO COMPARTMENT. REPLACED SUPPORT ZEE LOC BETWEEN BS 727B TO 847 LBL 19 AND WL 154.5 AFT CARGO COMPARTMENT, IAW B737-700 SRM 51-10-02 PAR 9 DWG 146A7500 REV 0 AND REPAIRED IAW SDR AALA202008319020Shear Web · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND LEFT SHEAR WEB CRACKED 1.25" AT FR 69 AND STR 23L. REPLACED SHEAR WEB IAW SRM 51-42-12.SDR AALA202008269006Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: FOUND CORRODED CREASES ANGLE AT STA 312 AND RBL 56. REMOVED AND REPLACED CREASE ANGLE.SDR AALA2020081969013Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: R/S DOOR SILL AT STR 23R AND FR68 HAS 2 FLOOR HOLES AND FLANGE CORRODED. REMOVED CORROSION AND INSTALLED REINFORCING REPAIR PER SRM 53-41-14-300.SDR AALA2020081969012Fitting · corrodedAIRCRAFT IN BASE MAINTENACE: FOUND CORROSION ON L-4 DOOR SHAPE. REMOVED AND REPLACED DOOR SHAPE.SDR AALA2020081769014Door Sill · corrodedAICRAFT IN BASE MAINTENANCE: LEFT SIDE DOOR SILL FLOOR HOLE AND FLANGE CORRODED (L= 1.5 INCH, W= 0.7 INCH, D= 0.05 INCH) AT FR68 AND STR 23L. REMOVED CORROSION AND INSTALLED REPAIR ANGLE IAW SRM 53-41-14-300.SDR IPXA2020081098810Angle · crackedINSPECTION TYPE:2CUPPER CARGO COMPT. T-ANGLE CRACK AT LON 15R STA.1341. REMOVED AND INSTALLED CRACKED T-ANGLE AT LON 15R STA.1341 IAW SRM 51-33-01 AND 51-35-01. (MINOR)SDR IPXA2020081098808Angle · crackedINSPECTION TYPE:2C, UPPER CARGO BAY TEE ANGLE CRACKED AT END OF LONGERON 15L, BS 1341. REMOVED AND INSTALLED A NEW ANGLE IAW SRM 51-35-01, AND 51-33-01. (MINOR)SDR AALA202009159017Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND 1 INCH CRACK AREA ON SHEAR PLATE AT FR 69-FR 70 AND STR 23R AT AFT GALLEY. REMOVED AND REPLACED SHEAR PLATE, REF SRM 51-72-11-911-001.SDR SWIA2020090952345Door Sill · corrodedSERVICE DOOR ENTRY WAY LOWER SILL HAS AREAS OF MILD CORROSION, C-CHECK RO 9/5/2020. REPLACED WITH NEW SERVICE DOOR ENTRY WAY LOWER SILL, REF CRJ700 SRM AND DRAWING. COMPLIED WITH TASK CARD.SDR AALA202009089015Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN SHEAR PLATE BETWEEN FR69 AND FR70 AT STR 23L, MEASURING L=1.011 IN. REPLACED SHEAR PLATE WITH NEW IAW A321 SRM 51-42-11-801 AND DRAWING D53474180.SDR AALA2020082879010Support · corrodedAIRCRAFT IN BASE MAINTENANCE: FOUND CORROSION (L= 1.403 INCHES W= 0.954 INCHES D= 0.048 INCHES) ON LOWER SILL LOCATED FROM FR66 TO FR68 AND STR 23L AT AFT GALLEY AREA. REPLACED SILL IAW A321 SRM 51-72-11-911-001 AND DWG # D53480505 AND # E53474250.SDR AALA202008269005Web · corrodedAIRCRAFT IN BASE MAINTNENANCE: CORROSION OF WEB AT STA987 AND RBL31, MEASURING L=1.0 IN, W=1.0 IN, D=0.008 IN. ACCOMPLISHED PERMANENT REINFORCING REPAIR WITH DOUBLER IAW SRM 51-70-13 AND EA307877.SDR AALA2020081209032Shade · defectiveAIRCRAFT IN BASE MAINTENANCE - L3 EMERGENCY EXIT HATCH, WINDOW SHADE (17A) BUNCHES UP, WILL NOT RETRACT. MEL 8-462NEF-N: COACH SEAT WINDOW SHADE/HANDLE AUTHORIZED. REPLACED WINDOW SHADE PER AMM 25-21-12, OPERATIONAL CHECK GOOD.
Back to JASC 5320