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 SWIA202055166Floor Support · corrodedLEFT SIDE FLOOR ANGLE BETWEEN APPROXIMATELY FS 797 TO FS 813 HAS CORROSION, MARKED. C-CHECK RO 1/5/2021. REMOVED CORROSION ON LT SIDE FLOOR ANGLE BETWEEN APPROXIMATELY FS 797 TO FS 813, REF CRJ700 SRM 51-21-06-001-001-A01. FOUND TO BE OUT OF LIMITS. RECEIVSDR SWIA202055165Floor Support · corrodedLEFT SIDE FLOOR ANGLE BETWEEN APPROXIMATELY FS 761 TO FS 785 HAS CORROSION, MARKED. C-CHECK RO 1/5/2021. REMOVED 2 EA HI-LITES ON LT SIDE FLOOR ANGLE BETWEEN APPROXIMATELY FS 761 TO FS 785 TO FOM, REF CRJ700 SRM 51-42-21-001-001-A01. INSTALLED 2 EA FASTENERSDR SWIA202055164Floor Support · corrodedRIGHT SIDE FLOOR ANGLE BETWEEN APPROXIMATELY FS 797 TO FS 813 HAS CORROSION, MARKED. C-CHECK RO 1/5/2021. REMOVED CORROSION ON RT SIDE FLOOR ANGLE BETWEEN APPROXIMATELY FS 797 TO FS 813, REF CRJ700 SRM 51-21-06-001-001-A01. FOUND TO BE OUT OF LIMITS. RECEISDR SWIA202055163Floor Support · corrodedRIGHT SIDE FLOOR ANGLE BETWEEN APPROXIMATELY FS 761 TO FS 785 HAS CORROSION, MARKED. C-CHECK RO 1/5/2021. REMOVED CORROSION ON RT SIDE FLOOR ANGLE BETWEEN APPROXIMATELY FS 761 TO FS 785, REF CRJ700 SRM 51-21-06-001-001-A01. FOUND TO BE WITHIN LIMITS, REF. MSDR SWIA202054538Floor Support · damagedRT FLOOR SILL INTERCOSTAL FROM FS 559.00-FS 559+16 HAS 100% MATERIAL LOSS AND REQUIRES REPLACEMENT. C-CHECK RO 12/05/2020. REMOVED RT FLOOR SILL INTERCOSTAL AND 3 EA ATTACHING ANGLES FROM FS 559.00-FS 559.00+16, REF CRJ200 SRM. INSTALLED NEW RT FLOOR SILL ISDR SWAA2020113027673Floor Support · crackedCRACKED INTERCOSTAL AT BS 277-294.5 RBL 1 WL 208.1. FOUND DAMAGE TO BE OUT OF LIMITS, IAW SRM CH 53-10-51-1A-1. REMOVED INTERCOSTAL AT BS 277-294.5 RBL 1. LOCATED AND DRILLED NEW INTERCOSTAL, IAW SRM CH 51-40-05 AND INSTALLED INTERCOSTAL IAW SRM CH 51-40-0SDR AALA202011239011Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE. FOUND L=1.110 INCHES CRACK ON SHEAR PLATE AT FR 69 TO FR 70 AND STR 23R. REPLACED SHEAR PLATE AT AFT GALLEY AREA, IAW SRM A319 51-72-11-911-001, 51-42-11-801 AND DRAWING D53474180.SDR SWAA2020111727594Floor 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 AND DWG 141A5400.SDR AALA202011179017Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE. FOUND L=0.150 INCHES CRACK ON SHEAR PLATE LOCATED ON STR 23L BETWEEN FR 69 TO FR 70 AT AFT GALLEY AREA. REPLACED SHEAR PLATE, IAW A319 SRM 51-72-11-911-001, SRM 51-42-11-801 AND DRAWING D53474180.SDR IPXA2020111662434Stiffener · crackedINSPECTION TYPE: 2C LT MLG WHEEL WELL 3RD VERTICAL STIFFNER AT OUTBOARD END IS CRACKED. REMOVED AND REPLACED STIFFNER, IAW SRM 51-35-01. (MINOR)SDR IPXA2020111662429Intercostal · crackedINSPECTION TYPE: 2C LT MLG KEEL BEAM BULKHEAD INTERCOSTAL IS CRACKED JUST FWD OF HYD SERVICING CONTAINER. REMOVED, FABRICATED, AND REPLACED INTERCOSTAL, IAW DWG AEA7094 AND SRM 51-35-01. (MINOR)SDR REXA2020111600769Floor Support · corrodedCARGO BAY FLOOR SUPPORT LBL 27 AT FS 1031 IS CORRODED. FABRICATED & INSTALLED NEW FLOOR SUPPORT & SPLICES AT LBL 27 BETWEEN FS 977 AND FS 1038, IAW CRJ 900 SRM 53-00-41-201-001-A03.SDR DALA2020110403582Web · corrodedCORROSION WEB FRAME 20 RT SIDE AT FWD GALLEY AREA. CORRECTIVE ACTION: REPLACED WEB LOCATED BETWEEN FR 20 TO FR 24 RT SIDE AT LEVEL STR 23R ON FWD GALLEY AREA, AS PER A319 SRM 51-72-11 AND 51-42-11 AND DRAWING D53112783, RELEASE DATE:28-MAY-98, ISSUE F00.SDR DALA2020110403581Web · corrodedCORROSION WEB FRAME 16 RT SIDE AT FWD GALLEY AREA. CORRECTIVE ACTION: REPLACED WEB LOCATED BETWEEN FR 12 TO FR 16 RT SIDE AT LEVEL STR 23R AT FWD GALLEY AREA, AS PER A319 SRM 51-72-11 AND 51-42-11 AND D53114332, RELEASE DATE:12-DEC-07, ISSUE B00.SDR DALA2020110403580Floor Support · corrodedCORROSION FLOOR BEAM -Y1225 LOCATED BETWEEN FR 66 TO FR 68 AT AFT GALLEY AREA. CORRECTIVE ACTION: REPLACED FLOOR BEAR -Y1225 LOCATED BETWEEN FRAME 66 TO FRAME 68 AT AFT GALLEY AREA ASPER A320 SRM 51-72-11 AND DWG D53472780 ISSUE K.SDR DALA2020110403579Floor Support · corrodedCORROSION FLOOR BEAM -Y1162.5 LOCATED AT LEVEL FR 68 AND STR 23R AT AFT GALLEY AREA. CORRECTIVE ACTION: REPLACED FLOOR BEAM -Y1162.5 LOCATED AT LEVEL FR 68 TO FR 69 ON STR 23R AT AFT GALLEY AREA, AS PER A320 SRM 51-72-11 AND DWG D53472780 ISSUE: K, RELEASE DASDR KCSA202011021161Stiffener · crackedCRACK NOTED ON STIFFENER ON TOP OF NWW AT APPROXIMATELY STA 310 RBL 10.SDR KCSA202011021160Stiffener · crackedCRACKS NOTED ON STIFFENER ON NWW TOP AT APPROXIMATELY STA 310 LBL 10.SDR SWAA2021082527507Strip · corroded** CORROSION ** FWD CARGO COMPMT. FLOOR PANELS CAP STRIPS L /H SIDE STA 500 TO STA 500D / REPLACED FLOOR PANELS CAP STRIP LT SIDE FROM STA 500 TO 500D AT FWD CARGO COMPARTMENT IAW B737-700 SRM 53-00-53-1A-2 AND SRM 51-10-02-0G-0 (ON PARTS RACK)SDR SWAA2021082527509Strip · corroded** CORROSION ** FWD CARGO COMPMT. FLOOR PANELS CAP STRIPS R/H SIDE STA 500 TO 500D MKD DOT 60-036 / REPLACED FLOOR PANELS CAP STRIP RT SIDE FORM STA 500 TO STA 500D AT FWD CARGO COMPARTMENT IAW B737-700 SRM 53-00-53-1A-2 AND SRM 51-10-02-0G-0 (ON PARTS RACK)SDR SWAA2021080927707Strap · damagedSTRAP ON TOP OF BS 794 FRAME IS DAMAGED ON UPPER SURFACE; RBL 18; WL 154 / REMOVED AND INSTALLED NEW STRAP ON ACB BS 794 STR 18R TO STR 25R ITEM 7531466 PO # 752858 IAW SRM 51-40-02; SRM 53-60-15-1A-1 DWG 146A8200; DWG 146A7500 AND DWG 146A8120; SRM 51-40-05 8SDR SWAA2021062127403Scuff Plate · crackedAFT CARGO COMPARTMENT AFT CORNER SCUFF PLATE CASTING CRACKED / ACCOMPLISHED WELD REPAIR PER B737-700 SRM 53-60-15-2R-1 BY OUTSIDE VENDOR P.O 1694981SDR SWIA202054572Cover Plate · corrodedSERVICE DOOR SILL COVER PLATE HAS CORROSION. C-CHECK RO 12/05/2020. REPLACED DOOR SILL PLATE P/N 601R38957-31. LOCATED NEW HOLES, INSTALLED 6 NEW 8-32 DOME NUTS, IAW CRJ200 DWG 601R38957 REV F CRJ200 SRM SOLID RIVETS AND CRJ200 SRM HOLE PREPERATION.SDR SWIA202054537Intercostal · corrodedINTERCOSTAL BETWEEN FS 295.00 AND FS 310.00, BETWEEN STGR 17L AND 18L CORRODED. C-CHECK RO 12/05/2020. REMOVED CORRODE INTERCOSTAL AND INSTALLED A NEW INTERCOSTAL AT FS 295 TO FS 310 AT SRINGER 17L AND 18L, REF CRJ 200 SRM AND DRAWING. PRESSURE CHECKS AND OSDR FDEA202011012739Web · crackedMAIN DECK FR47 Y953~Y1456 UNDERFLOOR WEB CRACKED REPAIRED THE MAIN DECK FR47 Y953~Y1456 UNDERFLOOR CRACKED WEB PER A300-600 SRM53- 15-15 FIG201 SHEET 2 , THIS IS CATEGORY B REPAIR AND IT MUST BE INSPECTED AT DEFINED INTERVALS PER A300-600 SRI 53-15-15-2-0SDR FDEA202011012738Web · crackedMAIN DECK FR47 Y0~Y450 UNDERFLOOR WEB CRACKED FABRICATED THE REPAIR PART PER DWG: A53832100 AND PART MARKED AS FXA5383210020800 PER GMM7-0-1001. REPLACED THE MAIN DECK FR47 Y0~Y450 UNDERFLOOR CRACKED WEB PER A300-600 SRM51-40-21. THIS IS CATEGORY A REPASDR REXA2020113000796Bracket · corrodedFWD BAGGAGE BAY DOOR SURROUND STRUCTURE MACHINED BRACKET CORRODED AT APPROX FS 565.00 AND LBL 24.0. REMOVED MACHINED BRACKET AT FS 565 STR LBL 24, IAW CRJ 900 SRM 51-42-22-001-001-A01 AND 51-42-21-001-001-A01. LOCATED AND DRILLED SERVICEABLE MACHINED BRACKETSDR REXA2020113000793Plate · corrodedFWD BAGGAGE BAY DOOR PLATE CORRODED AT FS 557 AND LBL 3.4. REPLACED FWD BAGGAGE BAY DOOR PLATE, IAW CRJ900 SRM 51-42-06-001-001-A01 & 51-42-21-001-001-A01.SDR R61A2020112200805Gusset · corrodedWHILE A/C WAS IN FOR HEAVY CHECK FOUND CORROSION ON FLOOR STRUCTURE AT FR 90 GUSSET PN 170-60257-001 AT LBL 16 GUSSET. REPLACED IAW EMB SRM 51-41-02.SDR R61A2020111900787Gusset · corrodedWHILE A/C WAS IN FOR HEAVY CHECK FOUND CORROSION FOUND ON FLOOR SUPPORT STRUCTURE AT FR 90 GUSSETS AT RBL 16. REPLACED GUSSET PN 170-60257-001, IAW EMB SRM 51-41-01. SEE AAR NRC NR 4500797-2000-0098 FOR WORK PERFORMED. A/C REMAINS IN YQG FOR COMPLETION.SDR R61A2020111900786Shear Panel · corrodedWHILE A/C WAS IN FOR HEAVY CHECK FOUND CF3 FLOOR SUPPORT STRUCTURE RT SHEAR PANEL BETWEEN FR 87-88 HAS CORROSION. SHEAR PANEL PN 170-91919-001 REPLACED, IAW EMB SRM 51-42-01, 51-42-02. SEE AAR NRC NR 4500797-2000-0096. A/C REMAINS IN YQG FOR COMPLETION.SDR SCNA20201116253Support · corrodedCORROSION ON AFT CABIN WALL SUPPORT STA 986.5+7, RBL 33-45, WL 208. AFT CABIN WALL SUPPORT BS 986.5+7 RBL 33-45 FOUND TO BE OUT OF LIMITS, IAW B737-800 SRM NO ALLOWABLE LIMITS. REMOVED AND REPLACED WALL SUPPORT, IAW B737-800 SRM 51-40-02-0G-0 AND BOEING DRAWSDR SCNA20201116243Channel · corrodedCORROSION ON L2 DOOR MOP SILL, STA 947.5+7 TO 986.5+7, LBL 54, WL 208 MULTIPLE AREAS. L2 DOOR MOP SILL BS 947.5+7-986.5+7 LBL 54 FOUND TO BE OUT OF LIMITS, IAW B737-800 SRM 53-70-15-1A-1 FIG 103 DETAIL D. REMOVED AND REPLACED MOP SILL, IAW B737-800 SRM 51-40SDR SCNA20201116240Channel · corrodedCORROSION ON R2 DOOR MOP SILL, STA 967+4 TO 967+25, RBL 46, WL 208 MULTIPLE AREA'S. R2 DOOR MOP SILL BS 967+4-967+25 RBL 46 FOUND TO BE OUT OF LIMITS, IAW B737-800 SRM 53-70-15-1A-1 FIG 103 DETAIL D. REMOVED AND REPLACED MOP SILL, IAW B737-800 SRM 51-40-02-0SDR SCNA20201116239Web · corrodedCORROSION ON AFT CABIN FLOOR SHEAR WEB, STA 986.5 TO 986.5+6, RBL 33 TO RBL 44, WL 208 MULTIPLE AREA'S. AFT CABIN FLOOR SHEAR WEB BS 986.5-986.5+6 RBL 33-44 FOUND TO BE OUT OF LIMITS, IAW B737-800 SRM NO ALLOWABLE LIMITS. REMOVED AND REPLACED SHEAR WEB, IAW SDR SCNA20201116231Shear Web · corrodedCORROSION ON AFT CABIN FLOOR SHEAR WEB INBOARD OF GALLEY FITTING, STA1016, LBL 31, WL 208. AFT CABIN FLOOR SHEAR WEB AT BS 1016 LBL 31 FOUND TO BE OUT OF LIMITS, IAW B737-800 SRM NO ALLOWABLE LIMITS. REMOVED AND REPLACED SHEAR WEB, IAW B737-800 SRM 51-40-02-SDR IPXA2020111162267Intercostal · crackedINSPECTION TYPE: 2C TAILCONE PATIO DECK RT LOWER INTERCOSTAL CRACK AT FWD END. REMOVED AND REPLACED TAILCONE PATIO DECK INTERCOSTAL AT FWD END, IAW SRM 51-35-01 AND 51-33-01. (MINOR)SDR DALA2020110303561Plate · corrodedDURING INSPECTION FOUND CORROSION ON LT SIDE PLATE BETWEEN STATION 727 AND STA 797 AND LBL 021 AT AFT CARGO COMPARTMENT. SIDE PLATE BETWEEN STA 727 AND STA 797 AND LBL 021 AT AFT CARGO COMPARTMENT WAS REPLACED, PER B737-800 SRM 51-40-02.SDR DALA2020110203554Floor Support · corrodedDURING INITIAL INSPECTION FOUND CORROSION LEVEL 2 ON FLLOR STRINGER STA 1470 RBL 10 AT AFT CARGO COMPARTMENT (CCT). STRINGER REPAIRED, PER SRM.SDR DALA2020110203553Floor Support · corrodedDURING INITIAL INSEPCTION FOUND CORROSION LEVEL 2 ON FLOOR STRINGER LBL 2 STA.1510 AT AFT CARGO COMPARTMENT (CCT). STRINGER REPAIRED, PER SRM.SDR SWAA2021062127402Scuff Plate · crackedFWD CARGO AFT CORNER SCUFF PLATE CASTING CRACKED / ACCOMPLISHED WELD REPAIR PER B737-700 SRM 53-30-15-2R-1 BY OUTSIDE VENDER P.O 1694981SDR SWAA2021021127292Shield · corroded***CORROSION*** FWD CARGO STA497 TO 500A; RBL26; WL157; FLOOR TO SIDEWALL SHIELD IS CORRODED.MARKED / REMOVED AND REPLACED FLOOR TO SIDEWALL SHIELD FWD CARGO STA497 TO 500A RBL26 WL 157 IAW SRM 51-40-02 SRM 51-10-02 PARAGRAPH 9 AND DWG 143A0080 REV:- 59900U 03SDR SWIA202054970Floor Support · corrodedCARGO FLOOR SILL IS CORRODED BETWEEN FS 559+116 AND FS 621.00. C-CHECK RO 12/30/2020. REMOVED AND REPLACED CARGO DOOR FLOOR SILL, IAW REO. COMPLETED TASK CARD AND ATTACHED COMPLETED FORM 337. NO WEIGHT CHANGE NOTED.SDR R61A2020111800779Floor Support · crackedDURING HEAVY CHECK MAINTENANCE FOUND CRACK FOUND ON FLOOR SUPPORT CLIP AT FR 12, BL 0. FLOOR SUPPORT CLIP AT FR 12, BL 0 REPLACED, IAW EMB SRM 51-41-01. A/C REMAINS IN CHECK.SDR AALA202011179009Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE. FOUND THREE INCH AREA OF CORROSION AT FR 66 AND STR 23R ON R4 DOOR SILL. REMOVED CORROSION, REPLACED PREVIOUS REPAIR ANGLES AND REINSTALLED REPAIR WITH NEW ANGLES, REF SRM 53-41-14-300-001.SDR AALA202011099027Plate · corrodedAIRCRAFT IN BASE MAINTENANCE. FOUND CORRODED AREA MEASURING 1.25 INCH BY 1.0 INCH ON L4 DOOR SILL PLATE PREVIOUS REPAIR. REMOVED PREVIOUS CORRODED REPAIR OF DOOR SILL. INSTALLED NEW REINFORCING REPAIR, REF SRM 53-41-14-300-001.SDR AALA202011099020Support · corrodedAIRCRAFT IN BASE MAINTENANCE. FOUND CORRODED AREA ON LOWER SILL BETWEEN FR 67 AND FR 68 AT STR 23L IN AFT GALLEY AREA, MEASURING L=1.005 INCH W=0.914 INCH D=0.040 INCH. PERFORMED PERMANENT REPAIR ON LOWER SILL, IAW A321 SRM 53-41-14-300-001 FIGURE 001, REPAISDR DALA2020110403578Support · corrodedCORROSION LOWER SILL LOCATED FR 20 AT LEVEL STR 23R AT FWD GALLEY AREA. CORRECTIVE ACTION: REPAIRED LOWER SILL LOCATED BETWEEN FR 16 TO FR 20 AT LEVEL STRINGER 23R AT FWD GALLEY AREA, AS PER A319 SRM 51-72-11 AND DRAWING D53110339 ISSUE G00.SDR SWAA2021072727353Support · crackedCRACKED FWD BULKHEAD PANEL SUPPORT AT AFT CARGO BAY BS727 RBL3 WL163. / A.C.B. AT BS727; RBL3; WL163. REMOVED BULKHEAD PANEL SUPPORT PER SRM 51-40-02. LOCATED AND DRILLED NEW SUPPORT ITEM 7531203 PER SRM 51-40-05. OK TO INSTALL 89021C 03NOV20 INSP 33 03NOV20. SDR SWAA2021021127342Support · corroded***CORROSION*** ON FLOOR TO SIDEWALL SUPPORT AT AFT CARGO BAY BS727 - BS807 LBL22 WL156. / REMOVED CORROSION ON FLOOR TO SIDEWALL SUPPORT AT AFT CARGO BAY BS 727 - BS 807 LBL 22; WL 156; MAX MATERIAL REMOVED IN AREA 1.7' X 1.1' X MORE THAN 50% MATERIAL LOSS. F
Back to JASC 5320