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 SCNA20201201369Channel · corrodedCORROSION ON R2 DOOR MOP SILL STA 947 TO STA 986 WL 208. CORROSION ON AFT SERVICE DOOR LOWER MAIN SILL INNER CHORD STA 947-986 WL 208. FOUND TO BE OUT OF LIMITS, IAW SRM 53-70-51-1A-1 FIG 103 DETAIL D. REMOVED AND REPLACED DAMAGED INNER CHORD, IAW SRM 51-40SDR SCNA20201201367Shear Web · corrodedCORROSION ON AFT CABIN FLOOR SHEAR WEB STA 1016 RBL 24 WL 208. CORROSION ON AFT CABIN FLOOR SHEAR WEB STA 1016, RBL 24, WL 208. FOUND TO BE OUT OF LIMITS DUE TO NO LIMITS, IAW SRM 53-70-51-1A-1. REMOVED AND REPLACED DAMAGED SHEAR WEB, IAW SRM 51-40-02-0G-SDR AALA202011249007Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE. FOUND L=0.999 INCH CRACK ON SHEAR PLATE AT FR 69 PLUS 3.89 INCHES AND STR 23R AT AFT GALLEY AREA. REPLACED SHEAR PLATE, IAW A319 SRM 51-72-11-911-001, SRM 51-42-11-801 & DWG D55474180.SDR DALA2020112403863Floor Support · corrodedDURING INSPECTION MAINTENANCE FOUND CORROSION LEVEL 2 ON STRINGERS BETWEEN FS STA 780+140-780+160, LBL 10.45, LBL 16.1 AT FWD CARGO COMPARTMENT. REPLACED STRINGERS PER ERA.SDR N6WA2020112304Intercostal · corrodedRT INTERCOSTAL BETWEEN FS 349 AND FS 364 AT STR 27 HAS LEVEL 2 CORROSION. REMOVED AND INSTALLED OF THE RT INTERCOSTAL BETWEEN FS 349 AND FS 364 AT STR 27, IAW CRJ 700 SRM 51-42-06 AND 51-42-22.SDR VNAA202011239993Door Sill · corrodedSERVICE DOOR SILL BETWEEN FS 319.70-349.00 IS CORRODED.SDR VNAA202011239992Intercostal · corrodedINTERCOSTAL BETWEEN FS 349.00-364.00 AND STRINGERS 27-26R IS CORRODED.SDR SWAA2021021136804Angle · corrodedFWD. CARGO COMP. L/H TRANSITION ANGLE HAS CORROSION AROUND 4 EA. FASTENER HOLES BETWEEN STA. 500 AND 500D. / REMOVED AND REPLACED FWD CARGO L/H TRANSITION ANGLE 480+9 TO 500D IAW SRM 51-40-02SDR SWIA202055333Door Sill · corrodedPASSENGER DOOR LOWER SILL ANGLE IS CORRODED BETWEEN FS 310.00 AND FS 349.00. C-CHECK RO 1/6/2021. REMOVED AND REPLACED PASSENGER DOOR LOWER SILL ANGLE BETWEEN FS 310.00 AND FS 349.00, IAW CRJ 700 SRM 51-42-06-001-001-A01. SEE ATTACHED CONTINUATION CARD FOR SDR SWIA202055330Support · corrodedBACKUP, SILL STGR 21L, FS 310.00 TO FS 333.00 CORROSION REQUIRES REPLACEMENT. C-CHECK RO 1/6/2021. REMOVED AND REPLACED BACKUP, SILL STGR 21L, FS 310.00 TO FS 333.00, AS REQUIRED IAW CRJ 700 SRM 51-42-06-001-001-A01. SEE ATTACHED CONTINUATION CARD FOR WORK SDR SWIA202055324Support · corrodedBACKUP, SILL (STGR 21L, FS 333.00 TO FS 349.00) CORROSION REQUIRES REPLACEMENT. C-CHECK RO 1/6/2021. REMOVED REPLACED BACKUP SILL, IAW CRJ 700 SRM 51-42-06 AND 51-42-06-001-001 (A01). NO LEAKS AT REPAIR AREA. SEE CONTINUE CARD FOR MAINTENANCE PERFORMED.SDR SWIA202055321Floor Support · corrodedRT CABIN FLOOR SILL JUST AFT OF FS 349.00 RBL 36 IS CORRODED. C-CHECK RO 1/6/2021. C/W REO 670-53-21-1898 REV- DATE 2020-12-08. MAJOR REPAIR TASK 51-900-1002-SKY & FORM M-337 COMPLETED AND ATTACHED. NEGALABLE WEIGHT CHANGE. REFERENCE CONTINUE CARD FOR DETSDR R61A2020122100930Web · corrodedCORROSION ON RT SILL WEB AT FR 12-13 Y+40. R & R SILL WEB IAW SRM 51-40-08.SDR SCNA20201201393Shear Web · corrodedCORROSION ON SHEAR WEB AT STA 986, RBL 43, WL 208. REMOVED DAMAGED SHEAR WEB AT STA 986 RBL 43 WL 208 AN INSTALLED NEW SHEAR WEB P/N 147A5712-11 PO NR 808105, IAW SRM 51-40-02, DWG 147A5300.SDR SWIA202055585Support Angle · corrodedAVIONICS COMPARTMENT CRAWLWAY SUPPORT ANGLE AT FS 280 HAS CORROSION, MARKED. C-CHECK RO 1/17/2021. REMOVED CORROSION FROM AVIONICS COMPARTMENT CRAWLWAY SUPPORT ANGLE AT FS 280 REF CRJ 700 SRM 51-21-06-001-001-A01. ORIGINAL MATERIAL THICKNESS .050" MATERIAL SDR SWIA202055555Floor Support · corrodedCABIN RT FLOOR SILL FS 517/533 DECOMPRESSION PANEL AND HARDWARE CORRODED. C-CHECK RO 1/17/2021. REMOVED AND REPLACED RT FLOOR SILL FS 517/533 DECOMPRESSION PANEL AND HARDWARE, IAW CRJ 700 AMM 21-35-01-000-801-A01 AND 21-35-01-400-801-A01.SDR SWIA202055554Door Sill · corrodedAFT BAGGAGE BAY DOOR SILL HAS AREAS OF CORROSION, FRETTING, A DENT, AND SOME GOUGES, MARKED. C-CHECK RO 1/17/2021. BLENDED DAMAGE ON THE AFT BAGGAGE BAY DOOR SILL "OUT OF LIMITS", REF CRJ700 SRM 51-21-06-001-001-A01, SRM 53-61-23-001-001-A01. REMOVED AND RESDR SWIA202055553Floor Support · corrodedRIGHT SIDE FLOOR SILL BETWEEN FS 280 AND FS 319 HAS CORROSION, SCRATCHES, AND A CRACK, MARKED. C-CHECK RO 1/17/2021. REMOVED CORROSION ON THE RT FLOOR SILL FS 280-FS 319, "OUT OF LIMITS." REMOVED AND REPLACED THE RT FLOOR SILL BETWEEN FS 280-FS 319, REF DRASDR SWIA202055547Angle · corrodedPAX DOOR SURROUND STRUCTURE, LOWER KICKPLATE ANGLE IS CORRODED AROUND THE NUTPLATE ON THE INBOARD SIDE, MARKED. C-CHECK RO 1/17/2021. FOUND PAX DOOR SURROUND KICKPLATE TO BE 100% EXFOLIATED "OUT OF LIMITS." REMOVED AND REPLACED THE PAX DOOR SURROUND STRUCTUSDR SWIA202055544Intercostal · corrodedINTERCOSTAL STGR 20R BETWEEN FS 319 TO FS 333 IS CORRODED, MARKED. C-CHECK RO 1/17/2021. REMOVED AND INSTALLED NEW INTERCOSTAL P/N SH670-32004-3, REF CRJ700 SRM 51-42-06-001-001-A01 AND CRJ700 SRM 51-42-21-001-001-A01 AND DRAWING SH670-31950 REV Y. COMPLIEDSDR SWIA202055359Plate · corrodedFWD BAGGAGE BAY DOOR SURROUND STRUCTURE, PLATE CORRODED AT FS 557 AND LBL 3.4. C-CHECK RO 1/6/2021. PLATE FOUND TO BE OUT OF LIMITS, IAW CRJ700 SRM 53-32-58-101-001-A01. REMOVED CORRODED PLATE FROM FWD BAGGAGE BAY AT FS 557 AND LBL 3.4. INSTALLED NEW PLATESDR SWIA202055358Bracket · corrodedFWD CARGO BAY DOOR SURROUND STRUCTURE, MACHINED BRACKET CORRODED AT FS 533 AND LBL 2.6. C-CHECK RO 1/6/2021. REMOVED BRACKET LOCATED DRILLED AND INSTALLED NEW BRACKET AT FS 533 LBL 2.6, IAW DWG SH670-336000 REV-Y. SEE CONTINUE CARD FOR MAINTENANCE PERFORMEDSDR SWIA202054928Door Sill · corrodedSERVICE DOOR LOWER SILL CORRODED. C-CHECK RO 12/28/2020. REMOVED & REPLACED LOWER SILL ANGLE PN SH670-31986-1 WITH NEW, REF CRJ700 SRM AND DRAWING. COMPLIED WITH ST CARD, SEE CONTINUE CARD FOR DETAILS.SDR SWIA202054821Floor Support · corrodedAFT CARGO DOOR FLOOR SILL, AFT INNER CHORD, HAS EXFOLIATED CORROSION. C-CHECK RO 12/26/2020. CORROSION DAMAGE FOUND TO BE OUT OF LIMITS, REF CRJ900 SRM. REMOVED AND INSTALLED NEW AFT INNER CHORD, REF CRJ900 SRM AND DWG.SDR SWIA202054820Floor Support · corrodedAFT CARGO DOOR FLOOR SILL, MID INNER CHORD, HAS EXFOLIATED CORROSION. C-CHECK RO 12/26/2020. REMOVED AND INSTALLED NEW AFT CARGO DOOR FLOOR SILL, MID INNER CHORD, REF CRJ 900 SRM AND DWG. COMPLETED FORM M-337. SEE CONTINUATION CARD FOR DETAILS.SDR SWIA202054819Floor Support · corrodedAFT CARGO DOOR FLOOR SILL, FWD INNER CHORD, HAS EXFOLIATED CORROSION. C-CHECK RO 12/26/2020. DAMAGE FOUND TO BE OUT OF LIMITS CRJ900 SRM. INSTALLED NEW FWD INNER CHORD ON CARGO DOOR SILL, REF DWG, CRJ900 SRM, AND CRJ900 SRM.SDR REXA2020120700808Angle · corrodedGALLEY SERVICE DOOR SILL ANGLE HAS MINOR CORROSION. REMOVED AND REPLACED GALLEY SERVICE DOOR SILL ANGLE, IAW CRJ 900 SRM 51-42-21-001-001-A01.SDR SCNA20201201372Floor Support · corrodedCORROSION ON AFT CABIN FLOOR SUPPORT STA 947 TO STA 967 RBL 48 WL 208. REMOVED DAMAGED FLOOR SUPPORT (INTERCOSTAL) FROM AFT CABIN STA 947 TO 967 RBL 48 RBL 48 WL 208, PER SRM 51-40-02-0G-0. LOCATED AND DRILLED NEW INTERCOSTAL ITEM NO 147A5660U22 PO NO 807575SDR SCNA20201201371Floor Support · corrodedCORROSION ON AFT CABIN FLOOR SUPPORT STA 947 TO STA 967 LBL 48 WL 208. REMOVED DAMAGED FLOOR SUPPORT (INTERCOSTAL) FROM AFT CABIN BS 947 TO BS 967 LBL 48 WL 208, PER SRM 51-40-02-0G-0. LOCATED, DRILLED NEW INTERCOSTAL ITEM NO 147A5660U22 PO NR 807575 AND INSSDR ASAA2020112133586Web · corrodedAFT CARGO DOOR SILL WEB IS CORRODED. GROUNDED-YES. REMOVED CORROSION ON SILL WEB AND FOUND TO BE OUT OF LIMITS, IAW 737-700 SRM 53-60-15-1A-1. REPLACED WEB WITH NEW WEB, IAW 737-700 SRM 51-40-02-0G-0 5. AND 51-40-05-0G-0 TABLE A FIG 3, W 2" O .045 R .039 LSDR SWAA2021060136211Angle · corrodedFWD CARGO COMPARTMENT RT FLOOR TO SIDEWALL TRANSITION ANGLE HAS AREAS OF CORROSION FROM STA 500 TO 500A TO STA / REPLACED TRANSITION ANGLE PER SRM 51-40-02.PART NUMBER 146A8125-53.SDR SWIA202055357Channel · corrodedTCAS LOWER CHANNEL CORRODED BETWEEN FS 295 AND FS 310 AT STGR 27. C-CHECK RO 1/6/2021. LOCATED, DRILLED AND INSTALLED DOUBLER, IAW CRJ 700 SRM 51-40-11-001-001 (A01)/51-42-06-001-001 (A01)/51-45-00-001-001 (A01). SEE CONTINUE CARD FOR MAINTENANCE PERFORMED.SDR SWIA202055329Intercostal · corrodedPAX DOOR DD2 INTERCOSTAL CORRODED BETWEEN FS 320 & 332. C-CHECK RO 1/6/2021. REMOVED AND REPLACED PAX DOOR DD2 INTERCOSTAL P/N 601R318053-3, IAW CRJ 700 SRM 51-40-11-001-001-A01, 51-42-06-001-001-A01 AND 51-42-21-001-001-A01 REV 38 7-25-20. PRESSURE CHECK SDR SWIA202055326Intercostal · corrodedAVIONICS BAY DOOR SURROUND STRUCTURE, INTERCOSTAL CORRODED AT STGR 27R BETWEEN FS 349 AND FS 364. C-CHECK RO 1/6/2021. REMOVED AND REPLACED LATCH PIN INTERCOSTALS AT STR 27 BETWEEN FS 349-FS 364, IAW CRJ 700 SRM 51-42-06-001-001 (A01) 51-42-21-001-001 (A01).SDR SWIA202055200Stiffener · crackedPAX DOOR POWER ASSIST MOTOR MOUNTING STIFFENER IS CRACKED AT LOWER RADIUS. C-CHECK RO 1/5/2021. REMOVED CRACKED PAX DOOR POWER ASSIST MOTOR MOUNTING STIFFENER, REF CRJ700 SRM 51-42-06-001-001-A01 AND INSTALLED REPLACEMENT STIFFENER, REF CRJ700 SRM 51-42-06-0SDR R61A2020122100935Doubler · corrodedCORROSION ON FLOOR DOUBLER AT FR 16 Y-14. R & R DOUBLER IAW SRM 51-40-08.SDR R61A2020122100932Web · corrodedCORROSION ON SILL RIGHT WEB AT FR 19 Y+49. R & R SILL WEB IAW SRM 51-40-08.SDR R61A2020122100931Splice · corrodedCORROSION ON FLOOR SPLICE AT FR 18 Y+24 . R & R FLOOR SPLICE IAW SRM 51-40-08.SDR R61A2020122100925Gusset · corrodedCORROSION ON GUSSET PLATE LOCATED AT FR 90 Y+22. R & R GUSSET PLATE AT FR 90 Y-22, PER SRM 51-41-02.SDR R61A2020122100924Gusset · corrodedCORROSION ON SPLICE LOCATED AT FR 90, Y+11. R & R SPLICE AT FR 90 Y+11, IAW SRM 51-41-02.SDR R61A2020122100923Upper Sheet · corrodedCORROSION ON UPPERSHEET LOCATED AT FR 85 +12 Y+11. R & R UPPER SHEET AT FRAME 85 +12 Y+11, IAW SRM 51-41-01 AND SRM 51-43-01.SDR R61A2020122100922Splice · corrodedCORROSION LOCATED AT SPLICE FR 84 Y +15. REPLACED SPLICE PER EMB SRM 51-40-08.SDR R61A2020122100927Floor Support · corrodedCORROSION ON PANEL SUPPORT LOCATED AT FR 89, Y+35 AND FR 90 Y +34. R & R PANEL SUPPORT, IAW SRM 51-40-08.SDR R61A2020122100921Splice Plate · corrodedCORROSION LOCATED ON SPLICE AT FR 90 Y - 11. R & R SPLICE PLATE IAW EMB SRM 51-41-02.SDR R61A2020122100920Shear Panel · corrodedCORROSION ON SHEAR PANEL LOCATED AT FR 87 Y-19 Y-28 Y-37 AND Y-40. R & R SHEAR PANEL, IAW SRM 51-75-16.SDR R61A2020122100919Shear Panel · corrodedCORROSION ON PANEL SHEAR LOCATED AT FR 87-Y -3 AND Y -6. R & R SHEAR PANEL BETWEEN FR 86 AND FR 87 Y-3 AND Y-6, IAW EMB SRM 51-42-03.SDR AALA202012099023Coupling · crackedAIRCRAFT IN BASE MAINTENANCE. FOUND D=0.081 INCHES CRACK ON FOOT COUPLING ON FR 43 LEFT SIDE BETWEEN STR 21 AND STR 22. PERFORMED PERMANENT REPAIR ON FOOT COUPLING, IAW EA NR 310017.SDR SWIA202054416Floor Support · corrodedCABIN FLOOR BEAM BETWEEN FS 473-FS 484, RBL 9 INBOARD FLANGE HAS CORROSION ON UPPER SURFACE. C-CHECK RO 11/24/2020. REPAIRED CABIN FLOOR BEAM BETWEEN FS 473-FS 484 RBL 9 INBOARD FLANGE CORROSION, IAW MHIRJ REO SKY CARD. W&B PROVIDED, FORM 337 IS ATTACHED. SDR SCNA20201201394Web · corrodedCORROSION ON AFT ENTRY DOOR SUB THRESHOLD WEB ON UPPER AND LOWER SURFACES IN MULTIPLE AREAS STA 954-988, LBL 50-53, WL 208. CORROSION FOUND ON AFT ENTRY DOOR SUB THRESHOLD WEB FOUND TO BE OUT OF LIMITS, DUE TO DAMAGE BEING WITHIN 20X OF FASTENER HOLE, IAW SRMSDR SCNA20201201379Web · corrodedAFT CARGO COMPARTMENT AREAS OF CORROSION ON LOWER MAIN SILL WEB STA 787+7 TO 848, RBL 24, WL 160. REMOVED DAMAGED AFT CARGO LOWER MAIN THRESHOLD SILL WEB + REPLACED WITH NEW P/N 146A8123U25, IAW SRM 51-40-02-0G-0 + BOEING DWG 146A8340.
Back to JASC 5320