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 SWAA2021030948151Structure · crackedCRACK INNER CHORD LOCATED BS 303.9 AND LBL 60 AT FWD GALLEY AREA / REPLACED INNER CHORD LOC. BS 303.9 AND LBL 60 AT FWD GALLEY AREA IAW B737-700 SRM 51-10-02-0G-0 AND DWG 141A8110 REV A; REPLACED DUE TO CRACK IS NOT FORMITTED IAW SRM B737-700; PN USED:654A0004SDR SWAA2021030948147Web · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN BS 344 AND BS 360 BL O FWD GALLEY AND LAV / REPLACED WEB INTERCOSTAL AND FASTENER LOC. BTW BS BS 344 AND BS360 BL0 FWD GALLEY IAW B737-700 SRM 51-40-02;51-40-05 AND DWG #141A5400-27 REV ASDR SWAA2021030948148Web · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BS 277 TO BS 294.5 AND BL 0 FWD GALLEY AND LAV / REPLACED WEB- INTERCOSTAL FLOOR STRUCTURE LOCATED BS 277 TO BS 294.5 AND BLO FWD GALLEY AND LAV IAW B737-700 SRM 51-40-02 DWG 141A5400 REV.- SHEET 20SDR SWAA2021030948150Web · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN BS 344 AND BS 360 LBL 12 FWD GALLEY AND LAV / REPLACED WEB INTERCOSTAL AND FASTENERS LOC BTW BS 344 AND BS360 LBL 12 FWD GALLEY IAW B737-700 SRM 51-40-02 51-40-05 AND DWG#141A5400-42 REV A AND PART USED ISDR SWAA2021030948848Angle · crackedCRACK ANGLE LOCATED BETWEEN BS 380 AND BS 400 BL0 AT PASSENGER CABIN / REPLACED ANGLE LOCATED BETWEEN BS 380 AND BS 400 BL0 AT PASSENGER CABIN IAW SRM B737-700 51-10-02 ITEM 9 AND DRAWING #143A5400 REV:- MATERIAL USED 7075-T610.063' PO: 2020-180549SDR SWAA2021030948845Structure · crackedCRACK STIFFENER FLOOR STRUCTURE AT BS 540 LOCETED BETWEEN RBBL 0 AND RBBL 45 AT PASSENGER CABIN (2 EA) / REPLACED STIFFENER FLOOR STRUCTURE AT BS 540 BTW RBBL O AND RBBL 45 PASSENGER CABIN (2EA) IAW SRM B737-700 51-40-02 AND DRAWING 143A5240 REV.- PART USED 14SDR SWAA2021030948146Angle · crackedCRACK ANGLE - SUPPORT LOCATED BS 400 AT LEVEL STR 26R AT FWD CARGO COMPARTMENT / REPLACED ANGLE-SUPPORT LOCATED BS400 AT LEVEL STR26R AT FWD CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 DWG 143A7505 REV BSDR SWAA2021030147221Sidewall Panel · crackedAFT CARGO COMPARTMENT R/H SIDEWALL PANEL 142BW CRACKED AND TORN. /SDR SWAA2021030147222Sidewall Panel · crackedAFT CARGO COMPARTMENT L/H SIDEWALL PANEL 141AW CRACKED. /SDR SWAA2021030147223Sidewall Panel · crackedAFT CARGO COMPARTMENT L/H SIDEWALL PANEL 141EW CRACKED. /SDR SWAA2021030147145Angle · corrodedAFT CARGO R/H TRANSITION ANGLE HAS CORROSION AROUND SCREW HOLES BETWEEN STA. 8' AFT OF 7276-767 / REPAIRED AFT CARGO RT TRANSITION ANGLE BETWEEN STA 727F TO STA 767 IAW SRM 53-00-53-2R-5. BONED NUTPLATES TO BE INSTALLED REF NRC D471735SDR SIMA20210205008Door Sill · corrodedSERVICE DOOR CENTER SILL CORRODED CORROSION LEVEL 2-C/A-RAR SERVICE DOOR CENTER SILL IAW EMB 145 SRM 51-40-02.SDR SWAA2021022447217Scuff Plate · corrodedCORROSION AFT CARGO COMPARTMENT FLOOR @ STA 787 FWD SCUFF PLATE HAS CORROSION. RBL 13' AND W.L. 155.5 / REMOVED CORRORED PLATE AND INSTALLED NEW PLATE PN AFT CARGO COMPARTMENT STA 787 RBL 13; PER REF 737 SRM 51-40-02-0G-0 AND DRAWING NO. 453A2611SDR SIMA20210205007Support · crackedLEFT OMEGA BEAM OUTBD SUPPORT AT FR 47-48 CRACKED. CRACK LENGTH .25 NUMBER OF CRACKS 1-C/A-PERFORMED A PERMANENT REPAIR OF THE LT OMEGA BEAM OUTBD SUPPORT AT FR 47-48 IAW EMB 145 SRM 53-23-02RE.SDR SWAA2021022347407Channel · corroded**CORROSION** AFT CARGO FLOOR STRUCTURE L/H ZEE PLATE UPPER SURFACE VARIOUS CORROSION SPOTS BETWEEN STA 727D AND 787. / REMOVED AND REPLACED ZEE CHANNEL AT AFT CARGO COMPT. L/H SIDE STA 727D TO STA 792 REF B737-700 SRM 51-40-02-0G-0SDR SIMA20210205003Floor Support · crackedRIGHT OMEGA BEAM INBD SUPPORT AT FR 47-48 CRACKED 1 CRACK, .25 IN LENGTH. C/A-PERFORMED PERMANENT REPAIR TO RT OMEGA BEAM INBD SUPPORT AT FR 47-48 IAW EMB 145 SRM 53-23-02RE.SDR DALA2021020800735Floor Support · corrodedSHIP 3236 CORROSION FLOOR BEAM -Y1162 LOCATED BTW FR 68 TO FR 69 AT AFT GALLEY AREA SSI 534147. CORRECTIVE ACTION: REPLACED FLOOR BEAM AND INSTALLED SPLICES AND HARD POINT AS PER A320 SRM 51-72 AND APPLIED PROTECTIVE TREATMENT. (1723763)SDR DALA2021020800729Support · corrodedSHIP 3251 CORROSION LOWER SILL RH SIDE LOCATED AT LEVEL FR66 AT AFT GALLEY AREA SSI 514147. CORRECTIVE ACTION: PERFOMRED PERMANENT REPAIR AS PER SRM A320 53-41-14. (1723627)SDR DALA2021020800706Strap · crackedDURING INITIAL INSPECTION MAINTENANCE FOUND CRACK STABILIZATION STRAP AT STA 345 LBL 45 AT PASSENGER COMPARTMENT. STRAP REPAIRED PER SRM. (LP 1723733)SDR DALA2021020800705Strap · crackedDURING INITIAL INSPECTION MAINTENANCE FOUND CRACK ON STABILIZATION STRAP AT STA 1620 AND LBL 50 APRRX AT PASSENGER CABIN. STRAP REPAIRED PER SRM. (LP 1723727)SDR DALA2021020800704Strap · crackedDURINNG INSPECTION MAINTENANCE FOUND CRACK ON STABILIZER STRAP STA 1620 AND 45 LBL AT AFT CARGO COMPARTMENT. STRAP REPAIRED PER SRM. (LP 1723539)SDR REXA2021050500195Intercostal · corrodedAVIONICS BAY DOOR FWD INTERCOSTAL IS CORRODED BETWEEN STGR 27 TO 26L. - REMOVED AND REPLACED AVIONICS BAY DOOR FWD INTERCOSTAL IAW CRJ700 SRM 51-42-06-001-001-A01 AND 51-42-21-001-001-A01. WVAC EMP # 585987SDR REXA202105040129Intercostal · corrodedPAX DOOR INTERCOSTAL BETWEEN FS 333 TO FS 349 AT STGR 20L IS CORRODED. - REMOVED UNSERVICEABLE PAX DOOR INTERCOSTAL BETWEEN FS 333 TO FS 349 AT STR 20L IAW CRJ 700 SRM 51-42-06-001-001-A01 AND 51-42-21-001-001-A01. LOCATED, DRILLED AND INSTALLED A NEW SERVICEASDR REXA2021020400124Intercostal · corrodedFWD AVIONICS BAY DOOR INTERCOSTAL IS CORRODED BETWEEN STGR 26L TO 25L. - INTERCOSTAL FOUND TO BE OUT OF LIMITS IAW CRJ 700 SRM 53-21-23-101-003-A01. LOCATED AND DRILLED SERVICEABLE INTERCOSTAL IAW CRJ 700 SRM 51- 40-11-001-001-A01. INSTALLED SERVICEABLE INTERCSDR SWAA2021031547013Track · corrodedCORROSION ON TRACK IN MULTIPLE AREAS AT FWD CARGO BAY BS500C- BS500D LBL17 WL157. / REMOVED AND REPLACED TRACK BTW B/S 400 TO B/S 500D DWG 143A7500 REF:A 59900U 11FEB21SDR SWAA2021031547014Angle · crackedCRACKED TRACK AT FWD CARGO BAY BS420 RBL13 WL156. / REMOVED & REPLACED TRACK AT FWD CARGO BAY RBL13 WL156 IAW SRM 51-40-02-0G-0 & DWG 143A7500 REV - & 143A7501 REV - 59191U 02-22-21SDR SWAA2021031547255Angle · crackedCRACKED INTERCOSTAL ATTACH ANGLE AT FWD CARGO BAY BS400 LBL25 WL155. / REMOVED AND REPLACED INTERCOSTAL ATTACH ANGLE AT FWD CARGO BAY B/S 400 LBL25 WL155 LOT:1441153-1 IAW SRM 51-40-02 SRM 51-10-02 PARAGRAPH 9 AND DWG 143A7505 REV:A 59900U 10FEB21SDR SWAA2021031547256Angle · crackedCRACKED INTERCOSTAL ATTACH ANGLE AT FWD CARGO BAY BS440 AFT SIDE LBL25 WL155. / REMOVED AND REPLACED INTERCOSTAL ATTACH ANGLE AT FWD CARGO BAY B/S 440 AFT SIDE LBL 25 WL 155 IAW SRM 51-40-02 SRM 51-10-02 PARAGRAP 9 AND DWG 143A7505 REV:A LOT#: 1446403-5 59900USDR SWAA2021031547258Angle · crackedCRACKED INTERCOSTAL ATTACH ANGLE AT FWD CARGO BAY BS500C FWD SIDE LBL25 WL155. / REMOVED AND REPLACED ANGLE LOC B/S 500C LBL25 WL155 (INTERCOSTAL ATTACH ANGLE FWD SIDE) LOT:7531258 PO: 813150/1 IAW SRM 51-40-02 SRM 51-10-02 PARAGRAPH 9 AND DWG 143A7505 REV:A 5SDR SWAA2021031547257Angle · crackedCRACKED INTERCOSTAL ATTACH ANGLE AT FWD CARGO BAY BS500B FWD SIDE LBL25 WL155. / REMOVED AND REPLACED ANGLE LOC AT FWD BAY B/S 500B LBL 25 WL155 FWD SIDE LOT: 7531258; PO:813150/1 IAW SRM 51-40-02; SRM 51-10-02 PARAGRAPH AND DWG 143A7505 REV:A 59900U 10FEB21SDR SWAA2021031547259Angle · crackedCRACKED INTERCOSTAL ATTACH ANGLE AT FWD CARGO BAY BS500C FWD SIDE RBL25 WL155. / REMOVED AND REPLACED INTERCOSTAL ATTACH ANGLE AT FWD CARGO BAY B/S 500C RBL25 WL155 IAW SRM 51-40-02 AND DWG 147A7505 REV:A 59899U 18FEB21.SDR SWAA2021031547263Gusset · crackedFWD CARGO BAY AFT BULKHEAD SUPPORT GUSSET IS CRACKED BS500D S-19L WL193. MARKED / REMOVED AND REPLACED BULKHEAD SUPPORT GUSSET AT BS500D S-19L WL193 IAW SRM 51-40-02 AND DWG 143A7902 REV.E 57049U 16FEB21SDR SWAA2021031547265Gusset · crackedFWD CARGO BAY AFT BULKHEAD SUPPORT GUSSET IS CRACKED BS500D S-21L WL177. MARKED / REMOVED AND REPLACED BULKHEAD SUPPORT GUSSET AT BS500D S-21L WL-177 IAW SRM 51-40-02 AND DWG 143A7902 REV.E 57049U 16FEB21SDR SWAA2021031547264Gusset · crackedFWD CARGO BAY AFT BULKHEAD SUPPORT GUSSET IS CRACKED BS500D S-19R WL193. MARKED / REMOVED AND REPLACED BULKHEAD SUPPORT GUSSET AT BS500D S-19R WL193 IAW SRM 51-40-02 AND DWG143A7902 REV.E 57049U 16FEB21SDR SWAA2021031547279Bracket · crackedAFT CARGO BAY SUPPORT BRACKET CRACKED BS 947 LBL 10 WL 179 / REMOVED DAMAGED ACB SUPPORT BRACKET 56639C 15FEB2021 PROCURED; LOCATED DRILLED AND DEBURRED NEW BRACKET PN 149A8113-6 P.O# 787165/3 PER SRM 51-40-05 AND DWG# 149A8103 REV:- OK TO INSTALL 56639C 15FEBSDR SWAA2021031547281Seat Track · corrodedCORROSION AND ABRASION ON SEAT TRACK AT PASSENGER CABIN BS370 - BS480 LBL45 WL208. MARKED / REMOVED AND REPLACED PASSENGER CABIN SEAT TRACK AT BS370-BS380 WL208 LBL45 IAW SRM 53-00-52-1A-1; SRM 51-40-04; DWG 141A5300; AND DWG 143A5300 WELL 2.0' X .5' X .050 FOSDR SWAA2021031547283Seat Track · corrodedCORROSION AND ABRASION ON SEAT TRACK AT PASSENGER CABIN BS480 - BS520 LBL25 WL208. MARKED / REMOVED DAMAGE ON SEAT TRACK B.S 520; LBL 25 .030 DEPTH OF DAMAGE FOUND TO BE OUT OF LIMITS PER SRM 53-00-52-1A-1; REMOVED AND REPLACED SEAT TRACK B.S 480-520; LBL25 PESDR SWAA2021031547286Seat Track · corrodedCORROSION AND ABRASION ON SEAT TRACK AT PASSENGER CABIN BS727B - BS887 LBL45 WL208. MARKED / EVALUATED CORROSION AND ABRASION ON SEAT TRACK B.S.727B-887 LBL45 AND FOUND IT TO BE OUT OF LIMITS. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-40-02-0G-0 AND DWG 146A5SDR SWAA2021031547289Seat Track · corrodedCORROSION AND ABRASION ON SEAT TRACK AT PASSENGER CABIN BS727B - BS887 RBL45 WL208. MARKED / REMOVED DAMAGE FROM SEAT TRACK RBL45 BS767 L=3.0' X W=0.50' X D=0.025' FOUND TO BE OUT OF LIMITS PER B737 SRM 53-00-52-1A-1. FABRICATED NEW SEAT TRACK IAW BOEING DWG# SDR SWAA2021030948399Web · crackedCRACK WEB - INTERCOSTAL LOCATED BETWEEN BS494 TO BS500A AT LEVEL STR26 R FWD CARGO COMPARTMENT / REPLACED WEB-INTERCOSTAL LCOATED BETWEEN BS 494 TO BW 500A AT LEVEL STR 26R FWD CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 SRM 51-10-02 ITEM (9) AND DRAWING #143ASDR SWAA2021030948840Support · crackedCRACK ANGLE - SUPPORT LOCATED BS440 AFT FACE AT LEVEL STR26L FWD CARGO COMPARTMENT / REPLACED ANGLE-SUPPORT LOCATED BS440 AFT FACE AT LEVEL STR 26L FWD CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 AND DWG 143A7505; SHEET 82 REV.- REPLACED DUE TO NOT FOUND ALLOWSDR SWAA2021030948838Angle · crackedCRACK ANGLE - SUPPORT LOCATED BS500C FWD FACE AT LEVEL STR26R FWD CARGO COMPARTMENT / REPLACED ANGLE (CLIP ASSY) LOCATED BS 500C FWD FACE AT LEVEL STR 26R FWD CARGO COMPARTMENT IAW SRM B737-700 51-10-02 ITEM 9 AND DRAWING #143A- 7505 REV- PART USED:CLIP P/N:14SDR SWAA2021030948565Gusset · crackedCRACK GUSSET LOCATED BS500D AT LEVEL STR19L FWD CARGO COMPARTMENT / REPLACED GUSSET PN 143A9481-6 LOCATED BS500D AT LEVEL STR19L FWD CARGO COMPARTMENT IAW B737-700 SRM 51-10-02 ITEM 9 AND DWG #143A7902 REV ESDR SWAA2021030847010Support · corrodedCORROSION ON FLOOR TO SIDEWALL SUPPORT AT FWD CARGO BAY BS500 - BS500C LBL23 WL157. / REMOVED DAMAGED FLOOR TO SIDEWALL SUPPORT; FWD CARGO BAY BS480+10' - 500D LBL23 W/L 157. FABRICATED SPLICE AND REPAIR SECTION INSTALLED SPLICE AND REPAIR SECTION BS480+10' - SDR SWIA202156489Angle · corrodedNESTING ANGLE ON LOWER FRAME AT FS879 HAS CORROSION (C-CHECK) RO 2/28/2021 REMOVED OUT OF LIMITS NESTING ANGLE AND INSTALLED NEW SERVICEABLE NESTING ANGLE AT FS879.00 LOWER FRAME SECTOR BETWEEN STGR 20L AND STGR 20R REF CRJ700 SRM 51-42-06-001-001-A01, CRSDR IPXA2021022666121Stiffener · crackedINSPECTION TYPE:C3RH MLG W/W 3RD VERTICAL STIFFENER CRACK AT LWR END.REMOVED AND REPLACED CRACKED VERTICAL STIFFENER IAW SRM 51-33-02 AND SRM 51-35-01 (MINOR).SDR IPXA2021022366009Stiffener · crackedINSPECTION TYPE: 3CLT MLG W/W O/B AFT 3RD VERTICAL STIFFENER FROM FWD IS CRACKED. REMOVED AND REPLACED CRACKED LT MLG W/W O/B AFT 3RD VERTICAL STIFFENER FROM FWD IAW MD-11 SRM 51-35-01. (MINOR)SDR R61A2021022100178Floor Support · corrodedCFIII, FLOOR STRUCTURE, CORROSION FOUND ON RH OUTBD FLOOR SUPPORT AT FR 84. CFIII, FLOOR STRUCTURE, RH OUTBD FLOOR SUPPORT AT FR 84 CORRODEDE PANEL REMOVED AND REPLACED IAW EMBRAER SRM 51-41-01, 51-41-2, AND 51-43-02.SDR R61A2021022100177Floor Support · corrodedCFIII, FLOOR STRUCTURE, CORROSION FOUND ON INTERCOSTAL SPLICE AT FR 84 RH SIDE. FLOOR STRUCTURE, INTERCOSTAL SPLICE @FR 84 RH SIDE REPLACED IAW EMB SRM 51-43-03SDR R61A2021021900172Gusset · corrodedCFIII FLOOR STRUCTURE, CORROSION FOUND ON RT GUSSET PLATE AT FR 90, REPLACED IAW EMB SRM 51-41-02.
Back to JASC 5320