JASC 5310
Service difficulty reports · 38,573
Reports filed under 5310 · Fuselage Main, 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 = '5310' 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 = '5310' 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 2001UALA01209Shear Tie · corrodedBS 566-567 STR 38L-39L SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED SHEAR TIE REPAIR IN ACCORDANCE WITH BAC DWG 140T2102 AND 143T1205 N-R. MAJOR REPAIR.SDR 2001UALA01207Shear Tie · corrodedBS 1285 STR 39L-39L SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED SHEAR TIE REPAIR IN ACCORDANCE WITH BAC DWG 140T2102-520 AND 146T1210 N-R. MAJOR REPAIR.SDR 2001UALA01205Shear Tie · corrodedBS 432-434 STR 35R SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED SHEAR TIE REPAIR IN ACCORDANCE WITH BAC DWG 140T2102 AND 143T1001 N-R. MAJOR REPAIR.SDR 2001UALA01183Stop Fitting · crackedAFT GALLEY DOORWAY STOP FITTING, 2 LOWER AFT FASTENER HOLES OF DOOR ASSIST HANDLE HAVE CRACKS. ACCOMPLISHED FRAME SPLICE STRAP REPAIR. MAJOR REPAIR ACCOMPLISHED.SDR 01FDEA00496Frame · corrodedNR 613 CORROSION (C53-113-01(2)) ON SHEAR TIE BS 970, LBL 10, WL 138.5. ** S/D ** COMINGSDR ASAA0110435Shear Tie · crackedPHX - DURING SCHEDULED D-CHECK, FOUND SHEAR TIE AT BS 440, LBL 69 CRACKED. REPAIRED PER SRM. (M)SDR ASAA0110429Shear Tie · crackedPHX - DURING SCHEDULED D-CHECK, FOUND SHEAR TIE AT BS 480, LBL 69 CRACKED. REPAIRED PER SRM. (M)SDR RRXA11374Doubler · corrodedDURING A MAINTENANCE VISIT FOUND FUSELAGE BULGED, POSSIBLE INTERNAL CORROSION @ L21R STA 25 - 8. *** CORRECTIVE ACTION *** REMOVED FASTENER, REMOVED CORRODED DOUBLER. FABRICATED AND INSTALLED REPLACEMENT PART IAW DWG 561386-5613861 AND SRM 51-1-21-1 AND 51-SDR 2001UALA01253Shear Tie · corrodedBS 632 STR 36L-37L SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED SHEAR TIE REPAIR IN ACCORDANCE WITH BAC DWG 140T2102 AND 143T1209 N-R. MAJOR REPAIR.SDR 2001UALA01250Shear Tie · corrodedBS 500 STR 36L-37L SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED SHEAR TIE REPAIR IN ACCORDANCE WITH BAC DWG 140T2102 AND 143T1203 N-R. MAJOR REPAIR.SDR 2001UALA01248Shear Tie · corrodedBS 368 STR 38R-39R SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED SHEAR TIE REPAIR IN ACCORDANCE WITH BAC DWG 141T1222 N-R. MAJOR REPAIR.SDR 2001UALA01247Shear Tie · corrodedBS 1285 STR 37L-38L SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED SHEAR TIE REPAIR IN ACCORDANCE WITH BAC DWG 140T2102-511 AND 146T1210 N-R. MAJOR REPAIR.SDR 2001UALA01245Shear Tie · corrodedBS 1197 STR 37L-38L SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED SHEAR TIE REPAIR IN ACCORDANCE WITH BAC DWG 140T2102-626 N-R. MAJOR REPAIR.SDR 2001UALA01244Shear Tie · corrodedBS 1153 STR 39L-39R SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED SHEAR TIE REPAIR IN ACCORDANCE WITH BAC DWG 140T2102-451 AND 146T1204 N-R. MAJOR REPAIR.SDR 2001UALA01243Shear Tie · corrodedBS 1263 STR 39L-39R SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED SHEAR TIE REPAIR IN ACCORDANCE WITH BAC DWG 140T2102-596 AND 146T1209 N-R. MAJOR REPAIR.SDR 2001UALA01242Shear Tie · corrodedBS 1241 STR 39L-39R SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED IN ACCORDANCE WITH BAC DWG 140T2102-451 AND 146T1208 N-R. MAJOR REPAIR.SDR 2001UALA01241Shear Tie · corrodedBS 1263 STR 38L-39L SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED SHEAR TIE REPAIR IN ACCORDANCE WITH BAC DWG 146T1209 AND SRM 51-40-02 N-R. MAJOR REPAIR.SDR 2001UALA01240Shear Tie · corrodedBS 610 STR 39L-39R SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED SHEAR TIE REPAIR IN ACCORDANCE WITH BAC DWG 140T2102 AND 143T1208 N-R. MAJOR REPAIR.SDR 2001UALA01239Shear Tie · corrodedBS 1219 STR 39L-39R SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED SHEAR TIE REPAIR IN ACCORDANCE WITH BAC DWG 140T2102-451 AND 146T1207 N-R. MAJOR REPAIR.SDR 2001UALA01237Shear Tie · corrodedBS 347 STR 36R-38R SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED SHEAR TIE REPAIR IN ACCORDANCE WITH BAC DWG 141T1221 N-R. MAJOR REPAIR.SDR 2001UALA01235Shear Tie · corrodedBS 500-501 STR 39L-39R SHEAR TIE CORRODED. SUPPLEMENTAL DATA UPDATE FABRICATED AND INSTALLED SHEAR TIE REPAIR IN ACCORDANCE WITH BAC DWG 140T2102 AND 143T1203 N-R. MAJOR REPAIRSDR 2001UALA01232Shear Tie · corrodedBS 742 STR 39L-39R SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED SHEAR TIE REPAIR IN ACCORDANCE WITH BAC DWG 140T2102 AND 143T1214 N-R. MAJOR REPAIR.SDR 2001UALA01231Shear Tie · corrodedBS 1329 STR 38L-39L SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED SHEAR TIE REPAIR IN ACCORDANCE WITH BAC DWG 140T2102-548 AND 146T1212 N-R. MAJOR REPAIR.SDR 2001UALA01230Shear Tie · corrodedBS 566-567 STR 39L-39R SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED SHEAR TIE REPAIR IN ACCORDANCE WITH BAC DWG 140T2102 AND 143T1206 N-R. MAJOR REPAIR.SDR 2001UALA01229Shear Tie · corrodedBS 764 STR 39L-39R SHEAR TIE CORRODED. *S/D* INSTALLED NEW SHEAR TIE IN ACCORDANCE WITH BAC DWG 143T1214 N-R. MAJOR REPAIR.SDR 2001UALA01224Shear Tie · corrodedBS 698 STR 39L-39R SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED SHEAR TIE REPAIR IN ACCORDANCE WITH BAC DWG 143T1212 N-R. MAJOR REPAIR.SDR 2001UALA01222Shear Tie · corrodedBS 610 STR 33L-34L SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED SHEAR TIE REPAIR IN ACCORDANCE WITH BAC DWG 140T2102 AND 143T1208 N-R. MAJOR REPAIR.SDR 2001UALA01221Shear Tie · corrodedBS 610 STR 37L-38L SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED SHEAR TIE REPAIR IN ACCORDANCE WITH BAC DWG 140T2102 AND 143T1208 N-R. MAJOR REPAIR.SDR USAA010813Angle · corrodedPIT - FOUND ANGLE CORRODED 1 INCH BY 30 INCH AREA, BETWEEN SERVICE DOOR FRAME THRESHOLD SUPPORT. REPLACED CORRODED SUPPORT ANGLE PER SRM 53-10-15AS. (M)SDR RRXA11320Angle · crackedDURING A MAINTENANCE VISIT FOUND CRACK DAMAGE TO ANGLE AT D-PIT DOOR JAMB LOWER SEAL DEPRESSOR, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED PART AND INSTALLED IAW DC-8 SRM 5SDR SWAA011842Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, FOUND BULKHEAD CRACKED AT BS 178, RBL 0.5 & WL 207. REPAIRED BULKHEAD PER SRM.SDR RRXA11372Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION ON SEAT TRACK MAIN CABIN STA 550-590 LBL48 - LBL63. *** CORRECTIVE ACTION *** REMOVED AND REPLACED CORRODED FASTENER IAW SRM51-3-0. SPLICED CORRODED SEAT TRACK IAW SRM 53-2-3 FIG 8A AND 51-3-0.SDR RRXA11371Rib · crackedDURING A MAINTENANCE VISIT FOUND L/H CENTER L/E @ XS461 RIB IS CRACKED AT UPPER SKIN END. *** CORRECTIVE ACTION *** STOP DRILLED CRACK PER SRM 57-2-0 FIG 2. NDT CRACK TERMINATED PER SPM 06-10-01.001. FABRICATED AND INSTALLED REPAIR PARTS PER SRM 57-2-0 FIGSDR 2001UALA01131Shear Tie · crackedSHEAR TIE CRACKED AT BS 1040, BETWEEN STR 2L AND STR 3L. REPLACED SHEAR TIE. MAJOR REPAIR ACCOMPLISHED.SDR ASAA0110413Shear Tie · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND SHEAR TIE AT BS 927, STRINGER 27L-27R CORRODED. REPAIRED PER SRM. (M)SDR CA010711014Window Post · corroded(CAN) L/H AND R/H FLIGHT COMPARTMENT WINDSHIELD FRAMS P/N 85310776-111 AND P/N 85310776-112 ARE CORRODED AT THE BOTTM OF THE FRAMES. THIS CORROSION WAS FOUND DURING THE SCHEDULED MAINTENANCE GROUND RUNS, PRESSURIZATION LEAK CHECK. A STREAM OF WATER SPOUTED FROSDR 0104309751Former · crackedDuring Inspection in CMH a crack was found in the -45 former. The crack extended from the O/B most fastener hole. Repaired per EA 97-181291.SDR AALA20011377Door Frame · crackedTUL - FOUND WEB EAR CRACKED AFT OF FORWARD ENTRY DOOR AT STATION 208, LONGERON L15 DOOR JAMB. REPAIRED WITH REPAIR STRAP PER AARD 53-10-00-11. (REPAIR 11- PAX DOOR JAMB INNER SKIN REPAIR - MAJOR)SDR RRXA11325Fitting · crackedDURING A MAINTENANCE VISIT FOUND CRACK DAMAGE TO FITTING AT STA.270 AND L30R, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED PART AND INSTALLED IAW DC-8 SRM 51-1-21, 51-1-20D.SDR QXEA0101085Structure · corrodedPDX - 261NT HAS MINOR FRETTING CORROSION. REPAIRED IAW RD 8-53-3366.SDR 2001UALA01160Shear Tie · corrodedSHEAR TIE CORRODED BS 532 STRINGER 38L-39L. *S/D* FABRICATED AND INSTALLED SHEAR TIE IN ACCORDANCE WITH BAC DWG 140T2102 AND SRM 51-40-02 N-R. MAJOR REPAIR.SDR 2001UALA01158Shear Tie · corrodedSHEAR TIE CORRODED BS 434 STR 39L-39R. *S/D* FABRICATED AND INSTALLED SHEAR TIE IN ACCORDANCE WITH BAC DWG 140T2102 AND SRM 51-40-02 N-R. MAJOR REPAIR.SDR 2001UALA01156Shear Tie · corrodedBS 632 STR 39R-39L SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DWG 140T2102-267 AND SRM 51-40-02 N-R. MAJOR REPAIR.SDR 2001UALA01155Shear Tie · corrodedBS 346 STR 37L-39L SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DWG 141T1221-67 AND SRM 51-40-02 N-R. MAJOR REPAIR.SDR 2001UALA01153Shear Tie · corrodedBS 368 STR 37L-38L SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DWG 140T2102 AND SRM 51-40-02 N-R. MAJOR REPAIR.SDR 2001UALA01152Shear Tie · corrodedBS 720 STR 38R SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DWG 140T2102-264 AND SRM 51-40-02 N-R. MAJOR REPAIR.SDR 2001UALA01151Shear Tie · corrodedBS 346 STR 39L-39R SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DWG 141T1221-13 AND SRM 51-40-02 N-R. MAJOR REPAIR.SDR 2001UALA01150Shear Tie · corrodedBS 720 STR 38L SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DWG 140T2102-263 AND SRM 51-40-02 N-R. MAJOR REPAIR.SDR 2001UALA01149Shear Tie · corrodedBS 676 STR 36L-37L SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DWG 140T2102 AND SRM 51-40-02 N-R. MAJOR REPAIR.SDR 2001UALA01148Shear Tie · corrodedBS 566 STR 37L-38L SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DWG 140T2102-221 AND SRM 51-40-02 N-R. MAJOR REPAIR.
Back to JASC 5310