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 SWAA012501Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND VERTICAL WEB CRACKED AT BS 180, LBL 5.7 & WL 183. REPAIRED WEB PER SWA RA 1-253-263 REV.1.SDR 0104159868Door Frame · corrodedDURING MCK IN ATL CORROSION FOUND AND A DOUBLE DRILLED HOLE WERE FOUND IN THE LOWER SECTION OF THE JAMB OF THE AFT VENTRAL DOOR. THE CORROSION WAS REMOVED BY CUTTING OUT THE JAMB. AFTER REMOVAL OF THE REPAIR, CORROSION WAS ALSO FOUND IN THE JAMB. REPAIRED PSDR MWEA011243Intercostal · crackedCABIN FLOOR, CENTERLINE INTERCOSTAL CRACKED AT STATION 446. -- REMOVED AND INSTALLED INTERCOSTAL.SDR MWEA011242Fitting · crackedFITTING CRACKED AT CENTER FUEL TANK FORWARD BULKHEAD ABOVE LONGERON 24 LEFT. -- FABRICATED AND INSTALLED FITTING.SDR SWAA012551Crease Beam · crackedDURING SCHEDULED D CHECK, FOUND CREASE BEAM CRACKED AT BS 189, STR 17L, WL 207. REPAIRED CREASE BEAM PER BFG ER.SDR SWAA012485Stringer · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CRACKED AT BS 312, STR 24R. REPAIRED STRINGER PER SRM.SDR SWAA012474Clip · crackedDURING SCHEDULED D CHECK, FOUND STR CLIPS CRACKED ( 4 EA ) AT BS 312, STR 24R, BS 663, STR 10L, BS 683, STR 4L, BS 1088, STR 17L. R&R STR CLIPS PER SRM.SDR 2001UALA01965Shear Tie · corrodedBODY STATION 1131 STRINGER 39L-39R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR MWEA011226Web · crackedAFT CARGO COMPARTMENT FLOOR WEB CRACKED BETWEEN STATION 1287 AND 1309 AT LONGERON 18 RIGHT. -- FABRICATED AND INSTALLED NEW WEB.SDR AWXA0002217Shear Tie · corrodedD: Fwd Cargo Compt. F/S 840 BL0 Fame Shear tie corroded.C: Removed Fwd Shear tie SRM 51-40-02, Fabricated new Shear tie in DRW. 140 N 2002 - 813 Sht. 7075-0-71 R 7028, install Shear tie IAW SRM 51-40-02SDR GTIA012073Structure · corrodedFTW - FOUND LOWER COMPARTMENT CARGO DOOR CUTOUTS FROM STATION 1155 THROUGH 1212 CORRODED. REMOVED CORROSION, REF N/R 18-N-00027. (M)SDR SWAA012457Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BULKHEAD WEBS CRACKED ( 9 EA ) AT BS 178, LBL 20-RBL 28. REPAIRED WEBS PER SRM.SDR SWAA012446Splice · crackedDURING SCHEDULED D CHECK, FOUND STR SPLICE CRACKED AT BS 365, STR 5L. R&R STR SPLICE PER SRM.SDR 2001UALA01997Pressure Panel · crackedNOSE LANDING GEAR WHEEL WELL TOP PRESSURE PANEL IS CRACKED AT FASTENER HOLES BS 275, RBL 13, AND BS 284, RBL 6. REPAIRED PRESSURE PANEL WEB. MAJOR REPAIR ACCOMPLISHED.SDR SWAA012453Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND VERTICAL BEAM WEBS CRACKED ( 2 EA ) AT BS 178, WL 230, RBL 17.1 & LBL 17.1. R&R VERTICAL BEAM WEBS PER SRM.SDR SWAA012447Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STR CLIP CRACKED AT BS 1137, LH APU TORQUE BOX. R&R STR CLIP PER SRM.SDR AALA20011750Shear Tie · crackedTUL - FOUND SHEAR TIE CRACKED AT STATION 1451 JUST INBOARD OF LONGERON 2L. REPLACED SHEAR TIE AT STATION 1451 INBOARD OF LONGERON 2L SRM 51-01. (M)SDR ABXA010487Frame · crackedMAIN FRAME AT STATION 737R WAS CRACKED BETWEEN "Z" ANGLE FASTENERS. MAINTENANCE REPAIRED THE FRAME IAW ABX EA 53400320-001-1.SDR 2001UALA01956Shear Tie · corrodedBODY STATION 1197 STRINGER 37L-38L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01955Shear Tie · corrodedBODY STATION 1395 STRINGER 37R-38R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01954Shear Tie · corrodedBODY STATION 1175 STRINGER 37L-38L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01953Shear Tie · corrodedBODY STATION 698 STRINGER 39R-39L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01952Shear Tie · corrodedBODY STATION 1395 STRINGER 37L-38L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01951Shear Tie · corrodedBODY STATION 1518 STRINGER 35R-36R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01941Shear Tie · corrodedBODY STATION 1175 STRINGER 37R-36R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01940Shear Tie · corrodedBODY STATION 1197 STRINGER 37R-36R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR GTIA010957Door Frame · corrodedFTW - CENTER LOWER CARGO COMPARTMENT CORRODED AT LOWER CUTOUT DOOR JAMB FROM STATION 635 TO STATION 693. REMOVED CORROSION ON JAMB. REMOVED JAMB BEAM. INSTALL NEW JAMB BEAM IAW MD-80 SRM 51-30-02. (M)SDR AWXA0002253Track · corrodedD: Seat track flange has corrosion at RBL 25 station 405 to C: Removed and replaced seat track from STA 377 to 410 IAW SRM 51-10-02,53-00-52 Pg 101-102SDR 2001UALA01913Shear Tie · corrodedBODY STATION 1562 STRINGER 38R-38L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01911Shear Tie · corrodedBODY STATION 1241 STRINGER 38R TO 39R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01910Shear Tie · corrodedBODY STATION 1197 STRINGER 35L-36L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01907Shear Tie · corrodedBODY STATION 1263 STRINGER 38L-39L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01906Shear Tie · corrodedBODY STATION 1263 STRINGER 36L-37L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01904Shear Tie · corrodedBODY STATION 1333 STRINGER 35R-36R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01901Shear Tie · corrodedBODY STATION 1439 STRINGER 39R-39L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01899Shear Tie · corrodedBODY STATION 1329 STRINGER 36L-37L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01897Shear Tie · corrodedBODY STATION 1329 STRINGER 39L-39R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR MWEA011217Longeron · crackedLONGERON 17 RIGHT AT STATION 965 CRACKED AT TOP BOLT. -- FABRICATED AND INSTALLED LONGERON SECTION AND STRINGER SPLICE SECTIONS.SDR MWEA011216Longeron · crackedLONGERON 13 LEFT AT STATION 965 CRACKED. -- FABRICATED AND INSTALLED LONGERON SECTION AND STRINGER SPLICE SECTIONS.SDR MWEA011215Longeron · crackedLONGERON 16 LEFT AT STATION 965 CRACKED. -- FABRICATED INSTALLED LONGERON SECTION AND SPLICES.SDR MWEA011214Longeron · crackedLONGERON 17 LEFT AT STATION 945 CRACKED IN 2 PLACES. -- FABRICATED AND INSTALLED LONGERON SECTION.SDR MWEA011213Fitting · crackedFRAME ATTACH FITTING AT STATION 69, 12 INCHES LEFT OF CENTER TOP SECTION OF FORWARD ACCESORY IS CRACKED. -- FABRICATED AND INSTALLED FRAME ATTACH FITTING.SDR MWEA011211Shear Tie · cracked1/4TH INCH IN THE BOTTOM OF A SHEAR CLIP IN THE CABIN AT STATION 275 LONGERON 17 LEFT, JUST ABOVE. -- FABRICATED AND INSTALLED SHEAR TIE SPLICE.SDR MWEA011210Shear Tie · crackedSTATION 832 SHEAR TIE JUST ABOVE THE CUSP LINE IS CRACKED. -- FABRICATED AND INSTALLED SHEAR TIE.SDR UPS01836740Shear Tie · crackedINSPECTION TYPE:C1,3 STA 640 SHEAR TIE IS CRACKED BETWEEN LONG 26L-27L. REPAIRED SHEAR TIE IAW SRM 53-2-0 FIG 2A AND 2B.SDR USAA011164Web · crackedCLT - FOUND WEB CRACKED FIVE PLACES .25 INCH EACH, BS 178, WL 234, LBL 10. INSTALLED DOUBLER ON WEB, CRACK CUT OUT OF WEB PER EO 5300V153 AND SRM 53-10-08 FIG 209. (M)SDR AWXA0002256Track · corrodedD: Seat track corroded at STA 405 RBL 45.0 beyond allowable limitsC: Removed and replaced seat track IAW SRM 51-10-02, 53-00-52 pg 101,102,12SDR QXEA0101482Shear Tie · damagedPDX - STRINGER TIE AT FRAME 2220 AND STRINGER 18 IS DAMAGED. REMOVED AND REPLACED STRINGER TIES IAW F28 SRM 53-02-05.SDR MWEA011194Door Frame · chafedAFT CARGO DOOR JAMB IS CHAFED ALONG FORWARD SIDE BETWEEN LONGERONS 24 TO 25 AT STATION 898. FABRICATED AND INSTALLED DOOR JAMB REPAIR.SDR MWEA011190Former · crackedON FORWARD SIDE OF AFT PRESSURE BULKHEAD, LEFT SIDE STATION 24 FORMER IS CRACKED ON OUTBOARD EDGE. -- FABRICATED AND INSTALLED FORMER
Back to JASC 5310