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 QXEA0101409Door Frame · tool damagePDX - TOOL MARKS ON UPPER AFT CORNER OF AFT CARGO DOOR FRAME 597.0. APPROXIMATELY 6 INCHES DOWN FROM TOP OF DOOR. REPAIRED IAW HORIZON AIR EA 2-52-108.SDR 0104119868Bracket · crackedDuring MCK in ATL found crack .5" long at sta 69 bracket. .063 7075-t6. Repaired per EA 98-185053SDR 2001UALA01825Shear Tie · corrodedBODY STATION 478 STRINGER 35R-36R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01824Shear Tie · corrodedBODY STATION 1219-1241 STRINGER 38L-37L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01822Shear Tie · corrodedBODY STATION 1153 STRINGER 38L-39L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01821Shear Tie · corrodedBODY STATION 1373 STRINGER 36L-37L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01820Shear Tie · corrodedBODY STATION 1373 STRINGER 37L-38L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01819Shear Tie · corrodedBODY STATION 1395 STRINGER 36R-37R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01818Shear Tie · corrodedBODY STATION 1307 STRINGER 37L-38L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01816Shear Tie · corrodedBODY STATION 434 STRINGER 33L-34L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER REPAIR.SDR 2001UALA01815Shear Tie · corrodedBODY STATION 1285 STRINGER 37L-38L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01812Shear Tie · corrodedBODY STATION 610 STRINGER 37L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01810Shear Tie · corrodedBODY STATION 588 STRINGER 33L-34L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01807Shear Tie · corrodedBODY STATION 1285 STRINGER 38R-39R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01804Shear Tie · corrodedBODY STATION 1175-1197 STRINGER 39R-38R SHEAR TIE CORRODED. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01803Shear Tie · corrodedBODY STATION 1153 STRINGER 39L-39R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01796Shear Tie · corrodedBODY STATION 1241-1263 STR 37R-38R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR SWAA012390Clip · crackedDURING SCHEDULED D CHECK, FOUND STR CLIP CRACKED AT BS 616, STR 7L. R&R STR CLIP PER SRM.SDR AALA20011673Door Frame · corrodedTUL - FOUND CORROSION AT AFT LOWER DOOR FRAME CUT OUT. INSTALLED TRACK SPLICE PER SRM 53-10-15. (M)SDR DHL2001727602Stringer · corrodedON "C" CHECK DISCREPANCY----- AFT. CARGO COMPARTMENT HAS CORROSION AT STRINGER L29 AND F/STATION 990 TO 1010.SDR DL73K011382Frame · corrodedCORROSION WAS FOUND ON THE FS 947.5 FRAME AT STR 17R. THE CORROSION WAS CUT OUT AND A REPAIR ANGLE INSTALLED. THE DAMAGE WAS FOUND AT HMV.SDR DL73K011381Web · corrodedTHE R1 DOOR SILL WEB WAS FOUND CRACKED AT FS 297. THE DAMAGED SECTION OF WEB WAS CUT OUT AND A NEW SECTION SPLICEDIN. THE DAMAGE WAS FOUND DURING HMV.SDR SWAA012380Stringer · crackedDURING SCHEDULED D CHECK, FOUND STR 5R LWR CHORD CRACKED BETWEEN BS 1138-1145, . R&R STR SECTION PER SRM.SDR SWAA012391Frame · crackedDURING SCHEDULED D CHECK, FOUND FRAME CRACKED AT BS 616, STR 7L. REPAIRED FRAME PER SRM.SDR MWEA011131Door Frame · crackedAFT VENTRAL DOOR JAMB PAN HAS A CRACK NEAR TOP RIGHT CORNER. REMOVED AND REPLACED DOOR JAMB SECTION. MAINTENANCE FOUND STRICKER PAN DAMAGED BEYOND LIMITS. REMOVED AND REPLACED NEW STRICKER PAN. FABRICATED AND INSTALLED REPAIR SPLICE.SDR AWXA0002191Skin · crackedD: L1 door fuselage cutout lower aft corner cracked 1/4" out of fastener hole BS338.C: Repaired skin at L1 door cutout lower aft corner IAW AWA ER 03-5330-01234-DD1SDR 2001UALA01788Shear Tie · corrodedBODY STATION 1153 STRINGER 39R-38R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR IN ACCORDANCE WITH BAC DWG 140T2102 AND SRM 51-40-02.SDR 2001UALA01785Shear Tie · corrodedBODY STATION 1307 STR 35L-36L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR IN ACCORDANCE WITH BAC DWG 140T2102 AND SRM 51-40-02.SDR 2001UALA01784Shear Tie · corrodedBODY STATION 1417 STRINGER 38R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR IN ACCORDANCE WITH BAC DWG 140T2102 AND SRM 51-40-02.SDR 2001UALA01781Shear Tie · corrodedBODY STATION 1219 STRINGER 35L-36L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR IN ACCORDANCE WITH BAC DWG 140T2102 AND SRM 51-40-02.SDR MWEA011132Former · crackedAPB FORWARD SIDE, TOP LEFT SUPPROT HAS A CRACK LOCATED ON INBOARD END. -- FABRICATED AND INSTALLED SUPPORT.SDR 0104109868Bulkhead · crackedDuring Mck in ATL, crack was found at the outboard end of the apb stiffener at Z=24 lh and rh. The crack is removed and the stiffener is repaired per EA 98-185074. Material 0.040" 2024-t42SDR 0104089868Support · crackedDuring MCK in ATL, A 1" long crack was found on the right nose landing gear support beam at sta 46. Repaired per EA. 98-185066. 0.050 2024-t42SDR MALA010671Beam · corrodedDuring 4K-check in CWA, LH Beam between Frame Sta 272 and 288 has heavy corrosion. Maintenance replaced LH Beam PN 7253720-325 between Frame Sta 272 and 288 IAW Saab SRM 51.SDR MALA010670Angle · corrodedDuring 4K-check in CWA, Angle on Frame 272 is corroded between RH Galley Seat Track and RH Fwd Emergency Exit. Maintenance replaced Angle PN 7253721-471 on Frame 272 RH Galley Seat Track and RH Fwd Emergency Exit IAW Saab SRM 51.SDR 2001UALA01765Frame · crackedRIB INTERCOSTAL STATION 360 IS CRACKED LENGTHWISE, AND STRINGER SUPPORT UNDER INTERCOSTAL IS BENT. SUPPLEMENTAL DATA UPDATE REPAIRED FRAME AT BS 380 BETWEEN STRINGERS S15 AND S16 AT THE ASSOCIATED SKIN ATTACHMENT.MAJOR REPAIR ACCOMPLISHEDSDR SWAA012370Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BULKHEAD WEB CRACKED ( 2 EA ) 1 INCH LONG, AT BS 178, WL 188, BLO. REPAIRED WEB PER SRM.SDR SWAA012369Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BULKHEAD WEB CRACKED AT BS 178 UPPER CORNER. R&R WEB PER SWA ACO.SDR SWAA012357Post · crackedDURING SCHEDULED 1/4D CHECK, FOUND CAPTAINS WINDOW POST CRACKED .2 INCHES LONG AT UPPER INBD CORNER. REPAIRED POST PER SRM.SDR CA011017011Window · punctured(CAN) IN CRUISE CABIN WINDOW AT SEAT ROW 12A, C OUTER PLY PUNCTURED. PUNCTURE OR HOLE ONE INCH LONG BY 3/8 INCH WIDE. PUNCTURE CAUSED BY NR 1 PROP SPINNER RETAINING SCREW BETWEEN BLADES 4&5.AFTER A/C LANDED, MAINTENANCE FOUND THAT ONE OF PROP SPINNER RETAININGSDR CA010912007Crossbeam · cracked(CAN) IT WAS FOUND THAT AN INDIVIDUAL HAD REMOVED MATERIAL FROM THE DOUBLER & CROSS-TIE IN AN EFFORT TO ELIMINATE CONTACT WITH THE EMERGENCY EXCAPE HATCH.CRACKS WERE FOUND PROPAGATING FROM THE SHARP CORNER OF THIS RADIUS. WE ALSO DISCOVERED DURING THE REMOVAL SDR ABXA010486Frame · crackedMAIN FRAME AT STATION 718L WAS CRACKED BETWEEN "Z" ANGLE FASTENERS. MAINTENANCE REPAIRED THE FRAME IAW ABX EA 53400210-001-1.SDR USAA011110Frame · crackedCLT - FOUND FRAME CRACKED .75 INCH, INBOARD RIVET BETWEEN STRINGER 8-9 AT BS 907L. INSTALLED DOUBLER PER TR 53-10-14. (M)SDR SWAA012396Clip · crackedDURING SCHEDULED D CHECK, FOUND STR CLIPS CRACKED AT BS 787, STR 7R, BS 807, STR 10L, BS 847, STR 4L. R&R STR CLIPS PER SRM.SDR SWAA012394Clip · crackedDURING SCHEDULED D CHECK, FOUND ( 2 EA ) STR CLIPS CRACKED AT BS 747, STR 6R, & 7R. R&R STR CLIPS PER SRM.SDR SWAA012414Web · crackedDURING SCHEDULED 1/4D CHECK AT DALFORT, FOUND BULKHEAD WEB CRACKED ( 4 EA ) AT BS 178, LBL 5, WL198.5, WL 183.5, WL 201, & RBL 5, WL 201.SDR 2001UALA01743Door Frame · crackedBS 294.5 AT RT CREASE BEAM, FLOOR LEVEL, DOOR CUTOUT FRAME HAS CRACK ON INNER FLANGE. MAJOR REPAIR ACCOMPLISHED. DAMAGE WAS REMOVED AND ANGLE DOUBLER INSTALLED.SDR 01FDEA00751Crease Beam · corrodedCORROSION ON UNDERSIDE OF CREASE BEAM WEB BS 344 LBL 65 WL 208. REMOVED AND REPLACED CREASE BEAM WEB PER SRM 51-40-2 FIG 1.SDR SWAA012359Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND VERTICAL BEAM WEBS CRACKED ( 2 EA ) AT BS 178, WL 232, RBL 17.1 & LBL 17.1. R&R WEBS PER SRM.SDR MALA010661Seat Track · corrodedDuring 4K-check in CWA, LH Center Aisle Seat Track LBL18.3 has out of limits of pitting corrosion approximately Sta 649-686.88. Maintenance replaced Seat Track section between Sta 618.88 to 686.88 IAW EO#S53060.
Back to JASC 5310