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 AALA202010129015Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION ON LEFT HAND AFT PASSENGER/CREW DOOR CUT OUT LOWER SILL AT FR 67 AND S23L. REPAIRED LOWER SILL, PER SRM A321 SRM 53-41-14-300-001 REPAIR PRINCIPLE 5.SDR V0XD20200910004Support Bracket · corrodedFLOOR BOARD MOUNT ON THE AFT SIDE OF FRAME 280 IS CORRODED OUT OF LIMITS. CORRECTIVE ACTION TO BE ACCOMPLISHED ON W/O: 80889 W/C: 1169.SDR V0XD20200910003Floor Support · corrodedLT FLOOR SUPPORT BEAM IS CORRODED OUT OF LIMITS BETWEEN FS 1000 AND FS 1047. CORRECTIVE ACTION TO BE ACCOMPLISHED ON W/O: 80889 W/C: 1215.SDR A6WA202010077315Cap · corrodedAFT CARGO BAY LBL 27 FS 610 HAS CORROSION AND PITTING ON T-CAP. AIRCRAFT REMOVED FROM SERVICE. REMOVED AND REPLACED AFT CARGO T-CAP LBL 27 FS 610 TO FS 513, IAW BOMBARDIER DRAWING 601R35031AND CRJ200 SRM 51-40-11.SDR V0XD20200610004Bracket · corrodedHYDRAULIC LINE MOUNT BRACKET ATTACHED TO STGR 26L BETWEEN FR 295 AND FR 310 IS CORRODED OUT OF LIMITS. CORRECTIVE ACTION TO BE ACCOMPLISHED ON AVMAX W/O: 80889 W/C: 1165.SDR V0XD20200610003Floor Support · corrodedRT FLOOR SILL BETWEEN FS 969 AND FS 1098 IS CORRODED OUT OF LIMITS. CORRECTIVE ACTION TO BE ACCOMPLISHED ON AVMAX W/O: 80889 W/C: 1218.SDR SWAA2021021120869Plate · corrodedR/H FWD CARGO COMPARTMENT STA 492 -STA 500A RBL21; WL155 SIDE PLATE CORRODED. (18-029) / REMOVED AND REPLACED SIDE PLATE AT FWD CARGO COMP. R/H SIDE STA 492 TO 500A RBL 21 AS PER B737-7 SRM 51-40-02-0G-0; DRAWING # 143A8126.SDR AALA202010209022Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION OF LT TRANSITION PANEL BETWEEN STA 500 AND STA 500I AT STR 25L, MEASURING L=3.0 IN, W=2.0 IN, D=0.01 IN. REPLACED TRANSITION PANEL WITH NEW, IAW 53-00-53-2R-5. SUPPLEMENTAL REPORT TO CORRECT SECTION 7 CORROSION LEVEL.SDR AALA202010309037Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE. FOUND CORROSION ON RIGHT TRANSITION PANEL FROM STA 500A TO 500I. REMOVED AND REPLACED TRANSITION PANEL.SDR SWAA2020102621227Floor Support · crackedFLOOR SUPPORT CRACKED BS 344-360 BL 0 WL 208. REMOVED AND REPLACED FLOOR SUPPORT BS 344-360 BL 0 WL 208, IAW SRM 51-40-02-0G-0 & SRM 51-40-0G-0 & PER DWG 141A5400 REV:- 92421U 10-10-20.SDR REXA2020102200700Angle · crackedLT AND RT OBLIQUE ANGLES ARE CRACKED AT STRINGER 14L AFT SIDE OF FS 621 BULKHEAD. REMOVED AND REPLACED LT & RT OBLIQUE ANGLES AFT SIDE OF FS 621 BULKHEAD AT STRINGERS 14L & 16R, IAW CRJ 200 SRM 51-82-21.SDR R61A2020102200696Shear Panel · corrodedDURING HEAVY CHECK MAINTENANCE FOUND CORROSION ON CENTER FUSELAGE III FLOOR STRUCTURE, LT SHEAR PANEL AT FR 87. LT SHEAR PANEL AT FR 87 REMOVED AND REPLACED, IAW EMB 170 SRM 51-42-01. A/C REMAINS IN CHECK.SDR R61A2020102200695Shear Panel · corrodedDURING HEAVY CHECK MAINTENANCE FOUND CORROSION ON CENTER FUSELAGE III FLOOR STRUCTURE MID SHEAR PANEL AT FR 87. MID SHEAR PANEL AT FR 87 AND FLOOR STRUCTURE REMOVED AND REPLACED, IAW EMB 170 SRM 51-42-01. A/C REMAINS IN CHECK.SDR R61A2020102200694Shear Panel · corrodedDURING HEAVY CHECK MAINTENANCE FOUND CORROSION ON CENTER FUSELAGE III FLOOR STRUCTURE RT SHEAR PANEL AT FR 87. FLOOR STRUCTURE RT SHEAR PANEL AT FR 87 REMOVED AND REPLACED, IAW EMB 170 SRM 51-42-01. A/C REMAINS IN CHECK.SDR R61A2020102200690Door Sill · corrodedDURING HEAVY CHECK MAINTENANCE FOUND CORROSION FOUND ON PREVIOUSLY BLENDED AREA ON AFT SERVICE DOOR(R2) LOWER SILL BEAM. AFT SERVICE DOOR (R2) LOWER SILL BEAM REMOVED AND REPLACED, IAW EMB 170 SRM 51-43-02 AND 51-43-01. A/C REMAINS IN CHECK.SDR AALA202010209001Shield · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION SHIELD BETWEEN BS 500 AND BS 500A AT S24R. REPLACED TRANSITION SHIELD, PER AARD 51-00-05-1.SDR AALA202010209020Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION OF INTERCOSTAL AT STA 949 AND RBL 50, MEASURING L=0.5 IN, W=0.5 IN, D=0.02 IN. REPLACED INTERCOSTAL WITH NEW, IAW SRM 51-40-02.SDR AALA202010159019Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE. CRACK IN SHEAR PLATE BETWEEN FR 69 AND FR 70 AT STR 23L, MEASURING L=0.970 IN. REPLACED SHEAR PLATE WITH NEW, IAW A321 SRM 51-72-11-911-001 AND 51-42-11-801 AND DRAWING D53474180.SDR AALA202010159018Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE. CRACK IN SHEAR PLATE BETWEEN FR 69 AND FR 70 AT STR 23R, MEASURING L=0.992 IN. REPLACED SHEAR PLATE WITH NEW, IAW A321 SRM 51-72-11-911-001 AND DRAWING D53474180.SDR AALA202010129025Support · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION OF LOWER SILL AT FR 68 AND STR 23L, MEASURING L=0.732 IN, W=0.529 IN, D=0.040 IN. ACCOMPLISHED PERMANENT REINFORCING REPAIR WITH REPAIR ANGLES AND FILLER, IAW A321 SRM 53-41-14-300-001.SDR AALA202010129022Web · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION OF WEB AT FR 16 AND STR 23L, MEASURING L=1.550 IN, W=1.192 IN, D=0.008 IN. REPLACED WEB WITH NEW, IAW A321 SRM 51-72-11-911-001 AND DRAWING D53114392.SDR LR7A2020100502633Stiffener · corrodedDURING SCHEDULED C-1 CHECK UNDER JOB CARD HC5314, FOUND THE FS 488 UNDERFLOOR SKIN STIFFENER CORRODED AT RBL 12-15 AND LBL 12-15, WL 132. REPAIRED IAW LOCKHEED SMP583 SRM, FIGURE 51-140-21. NR 7621.SDR LR7A2020100502631Channel · corrodedDURING SCHEDULED C-1 CHECK WHILE PERFORMING OTHER MAINTENANCE, FOUND THE CENTER WING RT TRAILING EDGE PANEL WITH CORRODED INNER HAT SECTIONS IN SEVERAL PLACES CWS 84R TO CWS 150R, FS 517 & FS 525. REPAIRED IAW LAC MEA 382-57-20-064. NR 7611.SDR LR7A2020100502614Angle · damagedDURING SCHEDULED C-1 CHECK UNDER JOB CARD HC5324, FOUND THE RT MAIN WHEEL WELL FS 517 TO 528 CHINE ANGLE WITH ELONGATED HOLES AT WL 142, RBL 61. REPAIRED IAW LOCKHEED SMP583 SRM, FIGURE 53-40-27. NR 7522.SDR LR7A2020100502577Fairing · crackedDURING SCHEDULED C-1 CHECK UNDER JOB CARD HC5321, FOUND THE LT FORWARD PRESSURE FAIRING CRACKED AT FS 478, LBL 23, WL 285. REPAIRED IAW LOCKHEED SMP583 SRM, FIGURE 51-140-12. NR 7250.SDR LR7A2020100502562Fitting · damagedDURING SCHEDULED C-1 CHECK UNDER JOB CARD HC5314, FOUND THE FS 577 RT PORK CHOP END FITTING WITH ELONGATED BOLT HOLE(S), WL 146 RBL 61. REPAIR BY REPLACEMENT ACCOMPLISHED, IAW LOCKHEED SMP583 SRM, CH 51-60 & 51-70. NR 7151.SDR LR7A2020100502549Stiffener · crackedDURING SCHEDULED C-1 CHECK WHILE PERFORMING OTHER MAINTENANCE, FOUND THE FS 928 AND FS 940 AFT FUSELAGE UPPER SKIN STIFFENER CRACKED AT RBL 22 (1 INCH TO 2 INCHES LONG) WL 285. REPAIR BY REPLACEMENT ACCOMPLISHED, IAW LOCKHEED SMP583 SRM, CH 51-60 & 51-70. NRSDR LR7A2020100502540Stiffener · crackedDURING SCHEDULED C-1 CHECK WHILE PERFORMING OTHER MAINTENANCE, FOUND THE FS 862 AFT FUSELAGE SKIN STIFFENER CRACKED. REPAIR BY REPLACEMENT ACCOMPLISHED, IAW LOCKHEED SMP583 SRM, CH 51-60 & 51-70. NR 6105.SDR LR7A2020100502536Brace · corrodedDURING SCHEDULED C-1 CHECK WHILE PERFORMING OTHER MAINTENANCE, FOUND THE LT MAIN WHEEL WELL FS 517 BEAM TO WL 200 BULKHEAD BRACE WITH ELONGATED HOLES, LBL 67-85. REPAIR BY REPLACEMENT ACCOMPLISHED, IAW LOCKHEED SMP583 SRM, CH 51-60 & 51-70. NR 6100.SDR LR7A2020100502531Tension Tie · corrodedDURING SCHEDULED C-1 CHECK WHILE PERFORMING OTHER MAINTENANCE, FOUND THE LT FS 617 TENSION TIE FITTING CORRODED. REPAIR BY REPLACEMENT ACCOMPLISHED, IAW LOCKHEED SMP583 SRM, CH 51-60 & 51-70. NR 6093.SDR LR7A2020100502455Cap · corrodedDURING SCHEDULED C-1 CHECK WHILE PERFORMING OTHER MAINTENANCE, FOUND THE FS 148 UNDERFLOOR BULKHEAD UPPER CAP CORRODED AT LBL 54, WL 195. REPAIR BY REPLACEMENT ACCOMPLISHED, IAW LOCKHEED SMP583 SRM, CH 51-60 & 51-70. NR 2982.SDR LR7A2020100502453Angle · crackedDURING SCHEDULED C-1 CHECK WHILE PERFORMING OTHER MAINTENANCE, FOUND THE LT CHINE ANGLE WITH A 2-INCH CRACK AT FS 477 BELOW THE STRUT SUPPORT. REPAIRED, IAW LOCKHEED SMP583 SRM, FIGURE 53-40-26. NR 2976.SDR LR7A2020100502445Tee Fitting · corrodedDURING SCHEDULED C-1 CHECK WHILE PERFORMING OTHER MAINTENANCE, FOUND THE LT MAIN WHEEL WELL INTERCOSTAL WEB AND AFT ATTACHMENT TEE EXTRUSION CORRODED AT FS 557-577, WL 175. REPAIR BY REPLACEMENT ACCOMPLISHED, IAW LOCKHEED SMP583 SRM, CH 51-60 & 51-70. NR 295SDR LR7A2020100502439Support · damagedDURING SCHEDULED C-1 CHECK WHILE PERFORMING OTHER MAINTENANCE, FOUND THE FLIGHT DECK FS 175 RBL 50 SUPPORT BRACE WITH ELONGATED HOLES. REPAIR BY REPLACEMENT ACCOMPLISHED, IAW LOCKHEED SMP583 SRM, CH 51-60 & 51-70. NR 2899.SDR LR7A2020100502429Beam · corrodedDURING SCHEDULED C-1 CHECK UNDER JOB CARD HC5321, FOUND THE CREW DOOR SILL BEAM WEB CORRODED, FS 203-208 WL 145, LBL 61. REPAIRED IAW LOCKHEED SMP583 SRM, FIGURE 51-140-23. NR 2798.SDR LR7A2020100502423Intercostal · crackedDURING SCHEDULED C-1 CHECK UNDER JOB CARD HC5323, FOUND THE LT MAIN WHEEL WELL FS 477 TO FS 517, WL 200 INTERCOSTAL BEAM ASSEMBLY CORRODED AND CRACKED LBL 62. REPAIR BY REPLACEMENT ACCOMPLISHED, IAW LOCKHEED SMP583 SRM, CH 51-60 & 51-70. NR 2764.SDR LR7A2020100502408Tee Fitting · crackedDURING SCHEDULED C-1 CHECK UNDER JOB CARD HC5315, FOUND THE AFT FUSELAGE CARGO COMPARTMENT LT FS 814 LOWER TEE FITTING CRACKED AT THE ATTACHMENT TO THE SLOPING LONGERON. REPAIR BY REPLACEMENT ACCOMPLISHED, IAW LOCKHEED SMP583 SRM, CH 51-60 & 51-70. NR 2629.SDR LR7A2020100502403Channel · crackedDURING SCHEDULED C-1 CHECK UNDER JOB CARD HC5313, FOUND THE AFT FUSELAGE FS 847 TO FS 865 RBL 60 WL 185 GUSSET CHANNEL WITH A 6-INCH LONG CRACK. REPAIR BY REPLACEMENT ACCOMPLISHED, IAW LOCKHEED SMP583 SRM, CH 51-60 & 51-70. NR 2571.SDR LR7A2020100502397Splice · corrodedDURING SCHEDULED C-1 CHECK WHILE PERFORMING OTHER MAINTENANCE, FOUND THE FS 537 TO FS 557 WL 175 SPLICE TEE CORRODED. REPAIR BY REPLACEMENT ACCOMPLISHED, IAW LOCKHEED SMP583 SRM, CH 51-60 & 51-70. NR 2561.SDR LR7A2020100502396Flange · crackedDURING SCHEDULED C-1 CHECK UNDER JOB CARD HC5313, FOUND THE LT CABIN WINDOW FLANGE CORRODED & CRACKED AT FS 267 & FS 347. REPAIR BY REPLACEMENT ACCOMPLISHED, IAW LOCKHEED SMP583 SRM, CH 51-60 & 51-70. NR 2560.SDR LR7A2020100502395Flange · corrodedDURING SCHEDULED C-1 CHECK UNDER JOB CARD HC5313, FOUND THE RT CABIN WINDOW FLANGE CORRODED AT FS 267 AND FS 347. REPAIR BY REPLACEMENT ACCOMPLISHED, IAW LOCKHEED SMP583 SRM, CH 51-60 & 51-70. NR 2559.SDR LR7A2020100502382Cap · crackedDURING SCHEDULED C-1 CHECK UNDER JOB CARD HC5312, FOUND THE UNDERDECK BELLY FS 196 BULKHEAD WL 136 LBL 58 LOWER CAP CRACKED. REPAIR BY REPLACEMENT ACCOMPLISHED, IAW LOCKHEED SMP583 SRM, CH 51-60 & 51-70. NR 2544.SDR LR7A2020100502381Longeron · corrodedDURING SCHEDULED C-1 CHECK UNDER JOB CARD HC5312, FOUND THE UNDERDECK BELLY FS 196-226, WL 129, LBL 27 LONGERON CORRODED. REPAIR BY REPLACEMENT ACCOMPLISHED, IAW LOCKHEED SMP583 SRM, CH 51-60 & 51-70. NR 2543.SDR LR7A2020100502380Web · damagedDURING SCHEDULED C-1 CHECK UNDER JOB CARD HC5312, FOUND THE FS 196 UNDERDECK LT WEB WITH ELONGATED HOLES AT WL 45 LBL 40. REPAIR BY REPLACEMENT ACCOMPLISHED, IAW LOCKHEED SMP583 SRM, CH 51-60 & 51-70. NR 2542.SDR LR7A2020100502373Support · crackedDURING SCHEDULED C-1 CHECK UNDER JOB CARD HC5312, FOUND THE UNDERDECK FLOOR SUPPORT (BRACE) CRACKED AT FS 196-244, LBL 30-RBL 30. REPAIR BY REPLACEMENT ACCOMPLISHED, IAW LOCKHEED SMP583 SRM, CH 51-60 & 51-70. NR 2523.SDR LR7A2020100502319Angle · corrodedDURING SCHEDULED C-1 CHECK UNDER JOB CARD HC5321, FOUND THE CENTER FUSELAGE LT CHINE ANGLE WITH INCORRECT REPAIR AT FS 597-637 AND CORRODED AT FS 697-737, WL 141-146, LBL 61. REPAIR BY REPLACEMENT ACCOMPLISHED, IAW LOCKHEED SMP583 SRM CH 51-60 & 51-70. NR 22SDR LR7A2020100502317Intercostal · corrodedDURING SCHEDULED C-1 CHECK UNDER JOB CARD HC5323, FOUND THE LT MLG WHEEL WELL FS 588-597, WL 215 INTERCOSTAL CORRODED LBL 62. REPAIR BY REPLACEMENT ACCOMPLISHED, IAW LOCKHEED SMP583 SRM CH 51-60 & 51-70. NR 2313.SDR LR7A2020100502313Intercostal · corrodedDURING SCHEDULED C-1 CHECK UNDER JOB CARD HC5324, FOUND THE RT MAIN WHEEL WELL FS 477-517, WL 200 INTERCOSTAL BEAM CORRODED RBL 62. REPAIR BY REPLACEMENT ACCOMPLISHED, IAW LOCKHEED SMP583 SRM CH 51-60 & 51-70. NR 2194.SDR LR7A2020100502287Angle · corrodedDURING SCHEDULED C-1 CHECK UNDER JOB CARD HC5321, FOUND THE LT FS 737.0E-817.0E CHIN ANGLE CORRODED. REPAIR BY REPLACEMENT ACCOMPLISHED, IAW LOCKHEED SMP583 SRM, CH 51-60 & 51-70 NR 2107.SDR LR7A2020100502286Angle · corrodedDURING SCHEDULED C-1 CHECK UNDER JOB CARD HC5321, FOUND THE RT FS 737.0E-817.0E CHIN ANGLE CORRODED. REPAIR BY REPLACEMENT ACCOMPLISHED, IAW LOCKHEED SMP583 SRM, CH. 51-60 & 51-70 NR 2106.
Back to JASC 5320