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 SWAA2021060169269Support Angle · crackedCRACK SUPPORT ANGLE LOCATED BS695 AND BL0 CENTER SECTION / REPLACED SUPPORT ANGLE LOCATED BS 695 AND BL0 CENTER SECTION IAW B737-700 SRM 51-10-02 ITEM 9 SRM B737-700 51-40-02 AND DRAWING #273A9111 SHEET 8 REV A MATERIAL USED EXTRUSION P/N BAC 1490-2883 PO 2020SDR AALA202105283517Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK FOUND ON SHEAR PLATE LOCATED AT FR 69, STR 23R. L = 1.225 INCHES. REPLACED SHEAR PLATE LOCATED AT STR 23R FROM FR 69 TO FR 70 AT AFT GALLEY AREA PER SRM 51-72-11-911-001.SDR IPXA2021052569808Floor Support · corrodedINSPECTION TYPE:3CMAIN CABIN FLOOR SUPPORT AT SAT 1481 AND LBL 90 IS CORRODED.REMOVED AND REPLACED CORRODED MAIN CABIN FLOOR SUPPORTAT STA 1481 AND BETWEEN LBL 75 - LBL 101 IAW SRM 51-33-01. (MINOR)SDR IPXA2021051869578Floor Support · corrodedINSPECTION TYPE:3CMAIN CABIN FLOOR SUPPORT AT STA 1256 & LBL 15 IS CORRODED.REMOVED AND REPLACED CORRODED MAIN CABIN FLOOR SUPPORT AT STA 1256 & LBL 15 IAW SRM 51-33-01. (MINOR)SDR AALA202105186413Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND L = 0.890 INCH CRACK ON SHEAR PLATE BETWEEN FR69 TO FR70 AT STR 23L. REPLACED SHEAR PLATE IAW A321 SRM 51-42-11-801 AND DRAWING 53474180.SDR IPXA2021051369346Angle · crackedINSPECTION TYPE:3CMAIN CABIN FLOOR PANEL SUPPORT INTERCOSTAL CLIP AT STA 5-32 AND LBL 29 IS CRACKED.REMOVED AND REPLACED CRACKED MAIN CABIN FLOOR PANEL SUPPORT INTERCOSTAL CLIP AT STA 5-32 AND LBL 29 IAW SRM 51-33-01 AND 51-35-01. (MINOR)SDR IPXA2021051169293Floor Support · corrodedINSPECTION TYPE:3CMAIN CABIN FLOOR SUPPORT AT STA 1159 AND LBL 16 IS CORRODED.REMOVED AND REPLACED CORRODED MAIN CABIN FLOOR SUPPORT AT STA 1159 AND LBL 16 IAW SRM 51-33-01. (MINOR)SDR IPXA2021051269326Stiffener · crackedINSPECTION TYPE:C2AFT CARGO COMPT VERTICAL STIFFENER CRACK AT STA.1841 RBL 30".REMOVED,FABRICATED AND REPLACED CRACKED VERTICAL STIFFENER IAW SRM 51-31-01 AND 51-35-01 (MINOR).SDR AALA202105115637Support · corrodedAIRCRAFT IN BASE MAINTENANCE: FOUND CORRODED AREA, MEASURING L= 0.810 IN, W= 0.510 IN, D= 0.055 IN, ON LEFT SILL AT FR68 AND STR 23L, PERFORMED PERMANENT REPAIR ON LOWER SILL AT FR68 AND STR 23L IAW A321 SRM 53-41-14-300-001 PRINCIPLE 5 REPAIR IS CATEGORY A.SDR IPXA2021051069155Floor Support · crackedINSPECTION TYPE:2CCENTER CARGO FLOOR SUPPORT AT STA 1521 BETWEEN RBL 10 - 22 IS CRACKED.REMOVED AND REPLACED CRACKED CENTER CARGO FLOOR SUPPORT AT STA 1521 BETWEEN RBL 10 - 22 IAW SRM 51-35-01. (MINOR)SDR IPXA2021051069154Intercostal · crackedINSPECTION TYPE:2CFWD CARGO INTERCOSTAL AT STA 6-50 & LONGERON 43L IS CRACKEDREMOVED AND REPLACED CRACKED FWD CARGO INTERCOSTAL AT STA 6-50 & LONGERON 43L IAW SRM 51-33-01. (MINOR)SDR IPXA2021051069147Floor Support · corrodedINSPECTION TYPE:3CMAIN CABIN FLOOR SUPPORT AT STA 1321 & LBL 15 IS CORRODED.REMOVED AND REPLACED CORRODED MAIN CABIN FLOOR SUPPORT AT STA 1321 & LBL 15 IAW SRM 51-35-01. (MINOR)SDR IPXA2021051069146Floor Support · crackedINSPECTION TYPE:3CMAIN CABIN FLOOR SUPPORT AT STA 1239 & LBL 99 IS CRACKED.REMOVED AND REPLACED CRACKED MAIN CABIN FLOOR SUPPORT AT STA 1239 & LBL 99 IAW SRM 51-33-01. (MINOR)SDR IPXA2021051069145Floor Support · corrodedINSPECTION TYPE:3CMAIN CABIN FLOOR SUPPORT AT STA 1159 & LBL 50 IS CORRODED.REMOVED AND REPLACED CORRODED MAIN CABIN FLOOR SUPPORT AT STA 1159 & LBL 50 IAW SRM 51-33-01. (MINOR)SDR IPXA2021050769120Floor Support · corrodedINSPECTION TYPE:3CMAIN CABIN FLOOR SUPPORT AT STA 1159 & LBL 6 IS CORRODED.REMOVED AND REPLACED CORRODED MAIN CABIN FLOOR SUPPORT AT STA 1159 & LBL 6 IAW SRM 51-33-01. (MINOR)SDR IPXA2021050569036Floor Support · corrodedINSPECTION TYPE:3CMAIN CABIN FLOOR SUPPORT AT STA 1321 & LBL 60 IS CORRODED.REMOVED AND REPLACED CORRODED MAIN CABIN FLOOR SUPPORT AT STA 1321 & LBL 60 IAW SRM 51-35-01. (MINOR)SDR ASAA2021042834735Channel · corrodedLH Z CHANNEL AT STA 767-787 IS CORRODED AND NUTPLATES ARE FALLING OFF GROUNDED - YES. REPAIR LH Z CHANNEL AT STA 727I TO 807 IAW B737-900 SRM 53-00-53-2R-5 W=1.5" O=.040 R=.035" L=15" D=.005"SDR ASAA2021042834734Intercostal · corrodedINTERCOSTAL AT STA RH 747-767 HAS CORROSION AROUND NUTPLATES GROUNDED - YES. REMOVED AND REPLACED INTERCOSTAL IAW B737-900 SRM 51-40-02-0G-0W=1.0" O=.032" R=.025" L=20' D=.007'SDR ASAA2021042834733Shield · corrodedINTERCOSTAL ATTACH ANGLE AT STA RH 767-794 HAS CORROSION AROUND NUTPLATES GROUNDED - YES. REMOVED AND REPLACED ATTACH ANGLE IAW BOEING 737-900 SRM 51-40-02W=3" O=.050 R=.044 L=1" D=.006SDR AALA202105049025Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND INTERCOSTAL CRACKED AT FLOORBOARD NUT CLIP HOLES LOCATED AT STA 328-344 AND RIGHT BUTT LINE 32. REPLACED CRACKED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202105049024Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND CRACKED INTERCOSTAL LOCATED AT STA 328-344, LEFT BUTT LINE 45. REPLACED CRACKED INTERCOSTAL PER SRM 51-10-02-0G.SDR AALA202105049023Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND CRACK ON INTERCOSTAL LOCATED AT STA 312-328, LEFT BUTT LINE 45. REPLACED CRACKED INTERCOSTAL PER SRM 51-10-02-0G AND AARD 51-00-05-1.SDR DALA2021050302509Stiffener · corrodedSHIP 665 L-4 DOOR SILL SCUFF PLATE SUPPORT STIFFENERS CORRODED 3 EA. CORRECTIVE ACTION: SUMMARY SEE NR FOR ADDITIONAL INFORMATION 002-0001:5311-01218-01A/022 00040 REPLACED STIFFENERS PER B757 SRM REF BAC DRWG. (1793850)SDR CALA2021043000571Shear Plate · damagedREMOVED AND REPLACED SHEAR PLATE AT FR69-FR70 STR 23 L/H P/N 534 7112420200 IAW SRM 51-42-11SDR JR2R40210428682Bracket · corrodedFLOOR BOARD ATTACH BRACKET FWD SIDE OF FR87 RBL30 CORRODEDSDR CALA2021042800564Door Sill · corrodedAFT CABIN R- 2 DOOR LOWER SILL PLATE CORR @ AFT END FR68 MKD DOT 60-076 REF. AAR N/R:9478800 GENERATED BY: V891378 REMOVED R2 DOOR LOWER SILL PLATE AND INSTALLED NEW R2 DOOR LOWER SILL PLATE IAW A320 SRM 51-42-11 AND 53-41-14-80A, AND RECONECTED DRAIN HOSES LSDR SWAA2022030179124Fitting · corroded***CORROSION*** AROUND DRAIN LINE AT AREA AFT OF ACB BS993 LBL17 WL188. / DRAIN MAST FITTING WHERE CORROSION WAS LOCATED (BS993; LBL17; WL188) WAS REMOVED & REPLACED ON CUSTOMER CARD: U312368.SDR SWAA2022030179125Fitting · corroded***CORROSION*** ON DRAIN MAST FITTING AT AREA AFT OF AFT CARGO BAY BS991 LBL17 WL184. / REMOVED AND REPLACED DRAIN MAST FITTING PER SRM 51-10-02-0G-0 STEP 9 & BOEING DWG 147A7443 SH4 7519U 23MAY21 OP CK GOOD PER AMM 38-31-01-400-802 STEP 5HSDR SWIA2021080960157Angle · crackedSTR 3L AT FS 280 IS CRACKED. (C-CHECK RO 8/5/2021) REMOVED DAMAGED ANGLE ON STRGR 3L AT FS 280. LOCATED, DRILLED, AND INSTALLED NEW SERVICEABLE ANGLE IAW: CRJ200-SRM-51-42-06, 51-42-21, AND 51-40-11SDR SWIA202160133Floor Support · corrodedRH FLOOR SILL MULTIPLE SPOTS OF CORROSION FROM FS559.00+112 TO FS621.00 (C-CHECK RO 8/5/2021) REPAIRED RH FLOOR SILL MULTIPLE SPOTS OF CORROSION FROM FS559.00+112 TO FS621.00 IAW REO 601R-53-61-7662 REV.--, DATED 6/19/21, REO 601R-53-00-526 REV. --, DATSDR SWIA202160132Floor Support · corrodedLH FLOOR SILL HAS MULTIPLE SPOTS OF CORROSION FROM FS574.00 TO FS621.00 (C-CHECK RO 8/5/2021) REPAIRED LH FLOOR SILL, FS574-FS621 IAW REO 601R53-61-1574 REV. B, DATED 04/15/2012, CRJ200 SRM 51-42-06, 51-40-11 AND 51-42-06. FORM 337 AND MAJOR REPAIR TASSDR JJBA2021008064023Profile · corrodedCORROSION ON PANEL 231 FF SUPPORT PROFILE AT L EDGE BETWEEN FR 18-19. REMOVED AND REPLACED PROFILE FOR PANEL 231FF AT LH EDGE BETWEEN FRAME 18 AND 19SDR SWIA202158670Buttstrap · corrodedFS280 BUTTSTRAP HAS SEVERAL SPOTS A CORROSION BETWEEN APPROXIMATE STRG 20L TO STRG 22R (C-CHECK RO 6/04/2021) REMOVED CORROSION AT FS280 BUTTSTRAP REF CRJ 700 SRM 51-21-06-001-001-A01, REPLACED RIVETS AND FASTENERS REF REO 670-53-21-2046, REV --, DATEDSDR SWAA2021060367741Web · corroded***CORROSION*** ON WEB AT AREA AFT OF AFT CARGO BAY BS1016 LBL9 WL191. MARKED / REPAIRED WEB AT AREA AFT OF AFT CARGO BAY; BS1016 AT LBL9 WL191 IAW EA 21-153-01325 REV IR AND ATS ER 21-01837 REV IRSDR SWAA2021060367126Support Angle · corroded***CORROSION*** ON AFT BULKHEAD LOWER SUPPORT ANGLE AT AFT CARGO BAY BS947 LBL7 TO RBL17 WL180. / REMOVED AND REPLACED ON AFT BULKHEAD LOWER SUPPORT ANGLE AT AFT CARGO BAY BTW BS 947; LBL 7 TO RBL 17 WL 180 IAW B 737-700; SRM 51-40-02-0G-0; DWGS # 14A8117; 149SDR SWAA2021060367128Support · corroded***CORROSION*** ON FLOOR TO SIDEWALL SUPPORT AT AFT CARGO BAY BS887 - BS947 RBL21 WL170. / REMOVED AND INSTALLED NEW FLOOR TO SIDEWALL SUPPORT BS887-BS947 I.AW SRM 51-40-02 AND DWG 147A7500. 92861U 09MAY21.SDR SWAA2021060367129Shield · corroded***CORROSION*** ON AFT SHIELD AT AFT CARGO BAY BS847 - BS867 RBL20 WL165. / REMOVED AND INSTALLED NEW SHIELD ON ACB BS847-BS867 RBL 20 ITEM 7531255 PO# 818515 LOCATED AND DRILLED IAW SRM 51-40-05; SRM 51-40-02 AND DWG146A0081 80641U 08MAY21SDR SWAA2021060367430Shield · corroded***CORROSION*** ON FWD SHIELD AT AFT CARGO BAY BS767 - BS787 RBL21 WL158. / REMOVED AND REPLACED FWD SHIELD WITH P/N 146A8127619 ITEM 7531132 P/O# 816185 LOCATED AT BS 767 - BS787; RBL21; WL158 PER B-737-700; SRM 51-40-02-0G-0; DWG# 146A0081SDR SWAA2021060367436Support Angle · corroded***CORROSION*** ON BULKHEAD LOWER SUPPORT ANGLE AT AFT CARGO BAY BS867 LBL6 WL166. / REPAIRED BULKHEAD LOWER SUPPORT ANGLE AT ACB BS867 LBL6; WL166 PER EA 1-21-153-01459 REV IR (ATS ER 21-01900 REV IR)SDR SWAA2021060367442Support · corroded***CORROSION*** ON FLOOR TO SIDEWALL SUPPORT AT AFT CARGO BAY BS727 - BS847 LBL21 WL161. / REMOVED CORROCION ON SUPPORT IAW SRM 51-10-02 REAVED NEW FLOOR TO SIDEWALL ITEM BAC 1496-377 LOT 1457346-1 LOCATED & DRILLED CARGO BAY BS 747-847; LBL 21; WL 161 SRM 51-SDR SWAA2021060367444Support · corroded***CORROSION*** ON FLOOR TO SIDEWALL SUPPORT AT AFT CARGO BAY BS727 - BS767 RBL21 WL157. / REMOVED AND INSTALLED NEW FLOOR TO SIDEWALL SUPPORT AT AFT CARGO BAY BS727 - BS767. RBL 21. IAW SRM 51-40-02 AND DWG 146A7500 92861U 10MAY21.SDR SWAA2021060367447Floor Support · corroded***CORROSION*** ON INTERCOSTAL AT AFT CARGO BAY BS787 - BS807 RBL6 WL154. / REMOVED AND INSTALLED NEW INTERCOSTAL AT ACB BS 787 - BS 807 RBL 6 WL 154 RECIEVED INTERCOSTAL FROM OSS IN FROM OF 7075-T62 # 0.045 PO # 824236-SWA LOCATED AND DRILLED IAW SRM 51-40-05SDR SWAA2021060367453Floor Support · corroded***CORROSION*** ON INTERCOSTAL AT AFT CARGO BAY BS767 - BS787 RBL21 WL156. / REMOVED AND REPLACED INTERCOSTAL P/N 146A8123U19; P/O 794007/1 LOCATED AT AFT CARGO BAY BS767-BS787; RBL21; WL156 PER B-737-700 SRM 51-40-02-0G;DWG# 146A0081 59202U 09MAY21SDR SWAA2021060367125Floor Support · crackedCRACKED INTERCOSTAL BS 277-294; RBL 1; WL208 / REMOVED AND REPLACED INTERCOSTAL AT BS277 TO BS294 RBL1 WL208 IAW SRM 51-40-02-0G-0 DWG 141A5400 59205U 28APR21SDR SWAA2021060367733Support Angle · crackedCRACKED SUPPORT ANGLE BEHIND WATER SERVICE PANEL AT AFT CARGO BAY BS914 RBL11 WL171. / REMOVED; LOCATED & DRILLED; & INSTALLED NEW WATER SERVICE PANEL SUPPORT ANGLE BS 914; RBL 11; WL 171 PER SRM 51-40-02-0G-0; SRM 51-40-05-0G-0 & BOEING DWG 147A7221SDR SWAA2021060367734Support Angle · crackedCRACKED SUPPORT ANGLE BEHIND WATER SERVICE PANEL AT AFT CARGO BAY BS918 RBL11 WL171. / REMOVED; LOCATED & DRILLED; & INSTALLED NEW WATER SERVICE PANEL SUPPORT ANGLE BS 918; RBL 11; WL 171 PER SRM 51;-40-02-0G-0; SRM 51-40-05-0G-0; & BOEING DWG 147A7221.SDR SWAA2021060367122Web · corroded***CORROSION*** AROUND FASTENERS ON LEFT OVER WING EXIT CUTOUT LOWER SILL WEB AT B.S. 619-639. L.B.L. 71; W.L. 222. / REWORKED DAMAGE ON THE LH OWE DOOR LOWER SILL WEB AT BS619-639; LBL71; WL222 PER 737-700 SRM 53-40-15 ALLOWABLE DAMAGE 1.SDR SWAA2021060367735Support · bentBENT WATER DRAIN LINE SUPPORT AT AREA AFT OF ACB BS986 BL0 WL186. / REMOVED; LOCATED & DRILLED; & INSTALLED NEW WATER DRAIN LINE SUPPORT BRACKET AT AREA AFT OF ACB BS 986; BLO; WL 186 PER SRM 51-40-02-0G-0; SRM 51-40-05-0G-0 & BOEING DWG! 417A2106.SDR SWAA2021060367743Angle · chafedLT FWD FUSELAGE FIN TO BODY INTERFACE CLOSURE ANGLE IS CHAFFED; BS 1009 TO 1016; LBL 14; WL 305 / EVALUATED DAMAGE ON CLOSURE ANGLE. LH FWD FUSELAGE AT BS1009 TO 1016 LBL 14 AND FOUND TO BE OUT OF LIMITS DUE TO NO LIMITS ON SRM. PART REPAIRABLE BY REPLACEMENT SDR SWAA2021060367744Angle · chafedLT AFT FUSELAGE FIN TO BODY INTERFACE CLOSURE ANGLE IS CHAFFED; BS 1016 TO 1156; LBL 14; WL 305 / EVALUATED DAMAGE ON CLOSURE ANGLE LH AFT FUSELAGE BS 1016 TO 1156 LBL14 AND FOUND TO BE OUT OF LIMITS DUE TO NO LIMITS ON SRM PART REPAIRABLE BY REPLACEMENT. I.A.
Back to JASC 5320