JASC 5313
Service difficulty reports · 36,303
Reports filed under 5313 · Fuselage Main, Longeron/Stringer, 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 = '5313' 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 = '5313' 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 P5CA2021041900104Stringer · crackedCRACK DAMAGE ON THE STRINGER S-9R BETWEEN STA 870 AND STA 910.(<P>ACCOMPLISHED EI NO T2021A53M-873 REV 1 AND ITS ATTACHING WITH WO 5671454 (372). CONDITION CHECK NORMAL AND JOB COMPLETED.</P>)SDR P5CA2021041900105Stringer · crackedCRACK DAMAGE ON THE STRINGER S-9R BETWEEN STA 930 AND 950(<P>ACCOMPLISHED EI NO T2021A53M-873 REV 1. CONDITION CHECK NORMAL AND JOB COMPLETED.</P>)SDR P5CA2021041900106Stringer · crackedCRACK DAMAGE ON THE STRINGER S-10R BETWEEN STA 870 AND STA 890(<P>ACCOMPLISHED EI NO T2021A53M-875 REV 1. CONDITION CHECK NORMAL AND JOB COMPLETED.</P>)SDR P5CA2021041900107Stringer · crackedCRACK DAMAGE ON THE STRINGER S-8R BETWEEN STA 790 AND STA 810(<P>ACCOMPLISHED EI NO T2021A53M-871 REV 1. CONDITION CHECK NORMAL AND JOB COMPLETED.</P>)SDR P5CA2021041900108Stringer · crackedCRACK DAMAGE ON THE STRINGER S-8R BETWEEN STA 930 AND STA 980+30(<P>ACCOMPLISHED EI NO T2021A53M-871 REV 1 AND ITS ATTACHING WITH WO 5672202. CONDITION CHECK NORMAL AND JOB COMPLETED.</P>)SDR P5CA2021041900109Stringer · crackedCRACK DAMAGE ON THE STRINGER S-8R BETWEEN STA 830 AND STA 910.(<P>ACCOMPLISHED EI NO T2021A53M-871 REV 1 AND ITS ATTACHING WITH WO 5672202. CONDITION CHECK NORMAL AND JOB COMPLETED.</P>)SDR P5CA2021041900110Stringer · crackedCRACK DAMAGE ON THE STRINGER S-18R, AT FWD SIDE OF STA 1740(<P>REPAIRED DAMAGED AREA IAW EI NO T2021A53M-914 REV 1. REINSTALL FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U1741 SHEET 325, REV - AND DWG NO 146U11620, SH80 REV B. CONDITION CHECK NORMAL AND JOSDR P5CA2021041900111Stringer · crackedCRACK DAMAGE ON THE STRINGER S-12L, AT AFT SIDE OF STA 2180.(<P>REMOVED AFFECTED FASTENER TO GET ACCESS IAW SRM 51-40-02 REV 33. ACCOMPLISHED EI NO T2021A53M-936 REV 1. REINSTALLED FASTENER IAW SRM 51-40-02 REV 33 AND DWG NO 146U1312 SHEET 113 REV - . JOB COMPSDR P5CA2021042000112Stringer · crackedCRACK - STRINGER, FWD UPPER FUSELAGE INTERNAL STRUCTURE STA 870 - STA 890, S-8L(<P>REPAIR DAMAGE AREA IAW EI NO T2021A53M-870 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.</P>)SDR P5CA2021042000113Stringer · crackedCRACK - STRINGER, FWD UPPER FUSELAGE INTERNAL STRUCTURE STA 930 - STA 970, S-8L(<P>ACCOMPLISHED EI NO T2021A53M-870, REV 1 AND EI ATTACHING WITH WO NO. 5670088 (365). JOB COMPLETED AND CONDITION CHECK NORMAL.</P>)SDR P5CA2021042000114Stringer · crackedCRACK - STRINGER, FWD UPPER FUSELAGE INTERNAL STRUCTURE STA 870 - STA 910, S-11L(<P>REPAIR DAMAGE AREA IAW EI NO T2021A53M-876, REV 1. JOB COMPLETED AND CONDITION CHK NORMAL.</P>)SDR P5CA2021042000115Stringer · crackedCRACK - STRINGER, FWD UPPER FUSELAGE INTERNAL STRUCTURE STA 850 - STA 890, S-10L(<P>REPAIR DAMAGED AREA IAW EI NO T2021A53M-874, REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.</P>)SDR P5CA2021042000116Stringer · crackedCRACK - STRINGER, FWD UPPER FUSELAGE INTERNAL STRUCTURE STA 870 - STA 890, S-7L(<P>REPAIR DAMAGED AREA IAW EI NO T2021A53M-867, REV 1. JOB COMPLETED AND CONDITION CHK NORMAL.</P>)SDR P5CA2021042000117Stringer · crackedCRACK DAMAGE ON STRINGER S-17L, AT FWD SIDE OF STA 1960(<P>REMOVED AFFECTED FASTENER TO GET ACCESS IAW SRM 51-40-02 REV 22. ACCOMPLISHED EI NO T2021A53M-928 REV 1. REINSTALLED FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U1940 SHEET 206 REV -. JOB COMPLETD SDR P5CA2021042000118Stringer · crackedCRACK DAMAGE ON STRINGER, S-22L, AT FWD SIDE OF STA 1960.(<P>REMOVED AFFECTED FASTENER TO GET ACCESS IAW SRM 51-40-02 REV 33. ACCOMPLISHED EI NO T2021A53M-932 REV 1. REINSTALLED FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U1961 SHEET 470 REV A AND 146U1961SDR P5CA2021042000119Stringer · crackedCRACK DAMAGE ON THE STRINGER S-23L, AT FWD SIDE OF STA 2180.(<P>REMOVED AFFECTED FASTENER TO GET ACCESS IAW SRM 51-40-02 REV 22. ACCOMPLISHED EI NO T2021A53M-940 REV 1. REINSTALLED FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U2160 SHEET 158 REV C. JOB COMPSDR P5CA2021042000120Stringer · crackedCRACK DAMAGE ON THE STRINGER S-12L, AT FWD SIDE OF STA 1960.(<P>REMOVED AFFECTED FASTENER TO GET ACCESS IAW SRM 51-40-02 REV 33. ACCOMPLISHED EI NO T2021A53M-927 REV 1. REINSTALLED FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U1940 SHEET 206 REV -. JOB COMPSDR P5CA2021042000121Stringer · crackedCRACK DAMAGE ON THE STRINGER S-10L, AT FWD SIDE OF STA 1960.(<P>REMOVED AFFECTED FASTENER TO GET ACCESS IAW SRM 51-40-02 REV 33. ACCOMPLISHED EI NO T2021A53M-926 REV 1. REINSTALLED FASTENER IAW SRM 51-40-02 REV 33 AND DWG NO 146U1940 SHEET 206 REV -. JOB COMPLSDR P5CA2021042000122Stringer · crackedCRACK DAMAGE ON STRINGER S-21L AT FWD SIDE OF STA 1960.(<P>REMOVED AFFECTED FASTENER TO GET ACCESS IAW SRM 51-40-02 REV 33. ACCOMPLISHED EI NO T2021A53M-931 REV 1. REINSTALL FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U1365 SHEET 20 REV A AND 146U1365 SHEESDR P5CA2021042000123Stringer · crackedCRACK DAMAGE ON THE STRINGER AT S-46L, STA 2604(<P>REPAIR DAMAGE AREA IAW EI NO T2021A53M-1014 REV 1. JOB COMPLETED AND CONDITION CHK NORMAL.</P>)SDR P5CA2021042000124Stringer · crackedCRACK DAMAGES ON THE STRINGER S-42R NEAR STA 2605.(<P>REPAIR DAMAGE AREA IAW EI NO T2021A53M-1015, REV 1. JOB COMPLETED AND CONDITION CHK NORMAL.</P>)SDR P5CA2021042000125Stringer · crackedCRACK DAMAGES ON THE STRINGER S-42L NEAR STA 2606.(<P>REPAIR DAMAGE AREA IAW EI NO 52021A53M-1013 REV 1. JOB COMPLETED AND CONDITION CHK NORMAL.</P>)SDR P5CA2021042000126Stringer · crackedCRACK DAMAGES ON THE STRINGER AT S-46R STA 2604(<P>REPAIR DAMAGE AREA IAW EI NO T2021A53M-1016 REV 1. JOB COMPLETED AND CONDITION CHK NORMAL.</P>)SDR P5CA2021042000127Stringer · crackedCRACK - STRINGER, FWD UPPER FUSELAGE INTERNAL STRUCTURE STA 950 - STA 980+30, S-9L(<P>ACCOMPLISHED EI NO T2021A53M-872, REV 1 AND EI ATTACH TO WO NO 5670098 (367). JOB COMPLETED AND CONDITION CHK NORMAL.</P>)SDR P5CA2021042000128Stringer · crackedCRACK - STRINGER, FWD UPPER FUSELAGE INTERNAL STRUCTURE STA 930 - STA 950, S-9L(<P>REPAIR DAMAGE AREA IAW EI NO T2021A53M-872, REV 1. JOB COMPLETED AND CONDITION CHK NORMAL.</P>)SDR P5CA2021042000129Stringer · crackedCRACK DAMAGE ON THE STRINGER S-11R, AT FWD SIDE OF STA 1960(<P>REPAIRED DAMAGE AREA IAW EI NO T2021A53M-921 REV 1. REINSTALL FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U1961 SH511, 513, REV B AND 146U1961 SH465 REV B. CONDITION CHK NORMAL AND JOB COMPLETESDR P5CA2021042000130Stringer · crackedCRACK DAMGE ON THE STRINGER S-21L, AT AFT SIDE OF STA 2180(<P>REMOVED AFFECTED FASTENER TO GET ACCESS IAW SRM 51-40-02 REV 33. ACCOMPLISHED EI NO T2021A53M-939 REV 1. REINSTALLED FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U2200 SHEET 153 REV -. JOB COMPLESDR P5CA2021042000131Stringer · crackedCRACK DAMAGE ON STRINGER S-20L, AT FWD SIDE OF STA 1960.(<P>REMOVED AFFECTED FASTENER TO GET ACCESS IAW SRM 51-40-02 REV 33. ACCOMPLISHED EI NO T2021A53M-930 REV 1. REINSTALLED FASTENER IAW SRM 51-40-02 REV 33 AND DWG NO 146U1940 SHEET 206 REV -. JOB COMPLETEDSDR P5CA2021042000132Stringer · crackedCRACK DAMAGE ON THE STRINGER S-23L, AT FWD SIDE OF STA 1960.(<P>REMOVED AFFECTED FASTENER TO GET ACCESS IAW SRM 51-40-02 REV 33. ACCOMPLISHED EI NO T2021A53M-933 REV 1. REINSTALLED FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U1365 SHEET 20 REV A AND 146U13SDR P5CA2021042000133Stringer · crackedCRACK DAMAGE ON THE STRINGER S-17L, AT AFT SIDE OF STA 2180.(<P>REMOVED AFFECTED FASTENER TO GET ACCESS IAW SRM 51-40-02 REV 33. ACCOMPLISHED EI NO T2021A53M-938, REV 1. REINSTALLED FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U2200 SHEET 154 REV -. JOB COMSDR P5CA2021042000134Stringer · crackedCRACK DAMAGE ON THE STRINGER S-13L, AT AFT SIDE OF STA 2180(<P>REMOVED AFFECTED FASTENER TO GET ACCESS IAW SRM 51-40-02 REV 33. ACCOMPLISHED EI NO T2021A53M-937 REV 1. REINSTALLED FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U2181 SHEET 368 REV C. JOB COMPLSDR P5CA2021042000135Stringer · crackedCRACK DAMAGE ON THE STRINGER S-19L, AT AFT SIDE OF STA 1960.(<P>REMOVED AFFECTED FASTENER TO GET ACCESS IAW SRM 51-40-02 REV 33, ACCOMPLISHED EI NO T2021A53M-929 REV 1. REINSTALLED FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U1980, SHEET 86 REV B. JOB COMPSDR P5CA2021042100137Stringer · crackedCRACK DAMAGE ON THE STRINGER 2-9R, AT FWD SIDE OF STA 1960(<P>REPAIRED DAMAGED AREA IAW EI NO T2021A53M-920 REV 1. INSTALLED FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U1961 SHEET 511 513 REV B, 146U1940 SHEET 173 REV -. CONDITION CHECK NORMAL AND JOB COMSDR P5CA2021042100138Stringer · crackedCRACK DAMAGE ON THE STRINGER S-23R, AT FWD SIDE OF STA 1740.(<P>REPAIRED DAMAGED AREA IAW EI NO T2021A53M-918 REV 1. INSTALLED FASTENERS IAW SRM 51-40-02, REV 33 AND DWG NO 146U1741 SH 324, 325 REV - AND DWG NO 146U1720 SH 79 REV B. CONDITION CHK NORMAL AND JOSDR P5CA2021042100139Stringer · crackedCRACK DAMAGE ON THE STRINGER S-22R, AT FWD SIDE OF STA 1740(<P>REPAIRED DAMAGED AREA IAW EI NO T2021A53M-917 REV 1. REINSTALLED FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U1741 SH 324, 325 REV -, 146U1720 SH 79 REV B. CONDITION CHECK NORMAL AND JOB COMPLESDR P5CA2021042100140Stringer · crackedCRACK DAMAGE ON THE STRINGER S-15R AT AFT SIDE OF STA 740.(<P>ACCOMPLISHED EI NO T2021A53M-879 REV 1. INSTALLED FASTENERS IAW SRM 51-40-02 REV 33 AND BOEING DWG NO 142U3736 SHEET 24 REV -. CONDITION CK NORMAL AND JOB COMPLETED.</P>)SDR P5CA2021042100141Stringer · crackedCRACK DAMAGE ON THE STRINGER S-13R, AT AFT SIDE OF STA 740.(<P>ACCOMPLISHED EI NO T2021A53M-878 REV 1. INSTALL FASTENERS IAW SRM 51-40-02 REV 33 AND BOEING DWG NO 142U0741 SHEET 423 REV - AND BOEING DWG NO 142U1312 SHEET 1 REV A. CONDITION CHK NORMAL AND JOB CSDR P5CA2021042100142Stringer · crackedCRACK DAMAGE ON STRINGER S-25R, AT FWD AND AFT SIDE OF STA 1740(<P>REPAIRED DAMAGE AREA IAW EI NO T2021A53M-919 REV 1. REINSTALL FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U1741 SHEET 327 REV A. CONDITION CHECK NORMAL AND JOB COMPLETED.</P>)SDR P5CA2021042100143Stringer · crackedCRACK DAMAGE ON THE STRINGER S-21R, AT FWD AND AFT SIDE OF STA 1740(<P>REPAIRED DAMAGED AREA IAW EI NO T2021A53M-916 REV 1. REINSTALLED FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U1741 SH 324 REV -. CONDITION CHECK NORMAL AND JOB COMPLETED.</P>)SDR P5CA2021042100144Stringer · crackedCRACK DAMAGE ON THE STRINGER S-20R, AT FWD AND AFT SIDE OF THE STA 1740(<P>REPAIRED DAMAGED AREA IAW EI NO T2021A53M-915 REV 1. REINSTALL FASTENER IAW SRM 51-40-02 REV 33 AND DWG NO 146U1741 SH 324, 325, 326 REV -, 146U1720 SH 80 REV B AND 146U1323 SH 96 REV -SDR P5CA2021042100145Stringer · crackedCRACK DAMAGE ON THE STRINGER S-23R, AT FWD SIDE OF STA 1960.(<P>REPAIRED DAMAGED AREA IAW EI NO T2021A53M-925 REV 1. REINSTALL FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U1323 SH 105 REV - AND 146U1961 SH 484 REV -. CONDITION CHK NORMAL AND JOB COMPLETED.SDR P5CA2021042100146Stringer · crackedCRACK DAMAGE ON THE STRINGER -19R, AT FWD SIDE OF STA 1960.(<P>REPAIR DAMAGE AREA IAW EI NO T2021A53M-923 REV 1. REINSTALL THE FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U3732 SH 36 REV A, 146U1961 SH 614 REV -, 146U1961 SH 615 REV - 146U1940 SH 179 REV -SDR P5CA2021042100147Stringer · crackedCRACK DAMAGE ON THE STRINGERS S-9R, AT AFT SIDE OF STA 2180(<P>REPAIRED DAMAGED AREA IAW EI NO T2021A53M-934 REV 1. REINSTALLED FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U3481 SH63 REV -, 146U3922 SH 21 REV - AND 146U2200 SH 120 REV C. CONDITION CHK NORMSDR P5CA2021042100148Stringer · crackedCRACK DAMAGE ON THE STRINGER S-22R, AT FWD SIDE OF STA 1960(<P>REPAIRED DAMAGED AREA IAW EI NO T2021A53M-924 REV 1. REINSTALL FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U1323 SH 105 REV -, AND 146U1961 SH 615, 614 - . CONDITION CHECK NORMAL AND JOB COMPLESDR P5CA2021042100149Stringer · damagedCRACK ADAMAGE ON THE STRINGER S-12R, AT FWD SIDE OF STA 1960(<P>REPAIRED DAMAGED AREA IAW EI NO T2021A53M-922 REV 1. REINSTALL FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U1961 SHEET 465 REV B AND 146U1312 SH 123 REV -. CONDITION CHECK NORMAL AND JOB COMPLSDR P5CA2021042100150Stringer · damagedCRACK DAMAGE ON THE STRINGER S-20R, AT AFT SIDE OF STA 2180(<P>REPAIRED DAMAGED AREA IAW EI NO T2021A53M-935 REV 1. REINSTALLED FASTENERS IAW SRM 51-40-02 REV 33 AND DWG NO 146U2181 SH 392 REV A AND 146U2200 SH 164 REV -. CONDITION CHECK NORMAL AND JOB COMPLETSDR SWIA2021072259676Stringer · gouged*STGR 7R HAS WEAR /GOUGE BETWEEN FS 1144.00 - 1162.00 IN AFT EQUIPMENT BAY (C-CHECK RO 7/20/2021) REPAIRED STGR 7R HAS WEAR /GOUGE BETWEEN FS 1144.00 - 1162.00 IN AFT EQUIPMENT BAY REF CRJ-700 SRM 53-00-03-201-004-A01.OP'S TEST & LEAK CHECK A/C DISTRIBUSDR SWIA2021062859101Stringer · corrodedMAIN AVIONICS BAY STR 20L HAS MULTIPLE SPOTS OF CORROSION BETWEEN FS349.00 AND FS379.00 (C-CHECK RO 6/22/2021) REMOVED AND REPLACED CORRODED STRINGER 20L BETWEEN FS349 - FS379. REF CRJ900 SRM 51-42-06-001-001-A01, REF CRJ900 SRM 51-42-21-001-001-A01, RESDR SWIA2021062859100Stringer · corrodedMAIN AVIONICS BAY STR 21L BACK-UP SILL BETWEEN FS333.00 AND FS349.00 CORRODED (C-CHECK RO 6/22/2021) REMOVED AND REPLACED MAIN AVIONICS BAY STR 21L BACK-UP SILL BETWEEN FS333.00 AND FS349.00 REF. DRWG SH670-31810 REV. AE AND CRJ 900 SRM 51-42-06-001-001SDR SWIA2021062859099Stringer · corrodedMAIN AVIONICS BAY STR 21L BACK-UP SILL BETWEEN FS310.00 AND FS333.00 CORRODED (C-CHECK RO 6/22/2021) REMOVED AND REPLACED MAIN AVIONICS BAY STR 21L BACK-UP SILL BETWEEN FS310.00 AND FS333.00 REF. DRWG SH670-31810 REV. AE AND CRJ 900 SRM 51-42-06-001-001
Back to JASC 5313