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 SWAA113543Crease Beam · crackedDURING SCHEDULED SPV CHECK FOUND, RT CREASE BEAM WEB INNER CHORD CRACKED AT BS 639. REPAIRED CHORD PER SRM.SDR SWAA113533Crease Beam · corrodedDURING SCHEDULED OTS CHECK FOUND, CREASE BEAM WEB CORRODED AT BS 450, LBL 65. REMOVED AND REPLACED WEB PER SRM.SDR SWAA113464Crease Beam · crackedDURING SCHEDULED SPV CHECK FOUND, RT CREASE BEAM INNER CHORD IS CRACKED AT BS 616 AND 639. REPAIRED CHORD PER SRM.SDR SWAA113462Crease Beam · corrodedDURING SCHEDULED 24Y CHECK FOUND, CREASE BEAM WEB CORRODED BETWEEN BS 907-927, STR 17L. REMOVED AND REPLACED WEB PER SRM.SDR A6WA201140550Post · crackedVERTICAL POST AT 409+128, RBL 18 OTBD IS CRACKED AT BOTTOM END. REPAIRED RBL 18, OTBD POST AT FS 469+128 IAW REO`S 601R-53-41-056, REV E, & REO 601R-53-41-1417.SDR COEA2011051811912Crease Beam · corrodedWO 101935 NR 100008 HEAVY CK COE / MAJOR REPAIR / LEVEL 2 CORROSION: LT CREASE BEAM WEB DOUBLER AFT OF FR 17 IS CORRODED (LENGTH 1.5", WIDTH 1.4", DEPTH .012"). REMOVED CORROSION, FABRICATED AND INSTALLED NEW CREASE BEAM WEB DOUBLER.SDR COEA2011051710912Crease Beam · corrodedWO 101935 NR 100042 HEAVY CK COE / MAJOR REPAIR / LEVEL 2 CORROSION: LT CREASE BEAM WEB BETWEEN FRAMES 13 & 14 HAS CORROSION ON TOP SURFACE (LENGTH .5", WIDTH .6", DEPTH .010"). REMOVED CORROSION, FABRICATED AND INSTALLED CREASE BEAM WEB.SDR COEA2011051709912Crease Beam · corrodedWO 101935 NR 100002 HEAVY CK COE / MAJOR REPAIR / LEVEL 2 CORROSION: LT CREASE BEAM INNER CHORD FR 17-18 HAS AREAS OF CORROSION (LENGTH 1.5", WIDTH 1.0", DEPTH .011"). REMOVED CORROSION AND REPAIR PER STRUCTURAL REPAIR MANUAL.SDR ZB0R201100001Fitting · corrodedDURING ANNUAL INSP, FOUND BOTH LT AND RT WINDOW FITTINGS RUSTED MORE THAN 50 PERCENT THROUGH. THIS IS ATTRIBUTED TO THE WINDOWS NOT BEING SEALED PROPERLY ALLOWING WATER TO GET IN AND CORRODE THE STEEL FITTINGS. BOTH FITTINGS WERE REPLACED WITH NEW. THERE WASSDR ASOA201100990Post · crackedFS 409+128 VERT POST BL 0 FAILS NDT WITH AN INDICATION IN LT AFT CHANNEL ON UPPER END. GREATER THAN 50 PERCENT SCREEN HEIGHT APPROX .1 LONG. REMOVED POST, LOCATED AND DRILLED NEW POST IAW SRM 51-42-06. INSTALLED POST IAW SRM 51-42-06 AND REO 601R-53-41889.SDR ASOA201100989Post · crackedFS 409+128 VERTICAL POST, RBL 18 FAILS NDT WITH AN INDICATION IN OTBD AFT CHANNEL ON UPPER END. GREATER THEN 50 PERCENT SCREEN HEIGHT APPROX 1" LONG. REMOVED POST IAW SRM 51-42-06 AND INSTALLED SERVICEABLE POST IAW SRM 51-42-06 AND 51-42-22 AND REO 601R-53-41SDR COEA2011051608912Crease Beam · corrodedWO 101935 NR 100053 HEAVY CK COE / MAJOR REPAIR / LEVEL 2 CORROSION: FOUND CORROSION ON FR 17 ON FWD SURFACE AND I/B FLANGE COMMMON TO CREASE BEAM INNER CHORD (DEPTH .01'). REPAIR PER STRUCTURAL REPAIR INSTRUCTIONS AND SRAS FROM ATR.SDR COEA2011051607912Crease Beam · corrodedWO 101935 NR 100014 HEAVY CK COE / MAJOR REPAIR / LEVEL 2 CORROSION: RT CREASE BEAM WEB FR 17-18 HAS CORROSION ON THE UPPER AND LOWER SURFACES (LENGTH .75", WIDTH .5", DEPTH .009"). REMOVED CORROSION, FABRICATED AND INSTALLED RT CREASE BEAM WEB.SDR COEA2011051606912Crease Beam · corrodedWO 101935 NR 100013 HEAVY CK COE / MAJOR REPAIR / LEVEL 2 CORROSION: RT CREASE BEAM WEB FR 18-19 HAS CORROSION ON UPPER AND LOWER SURFACES (LENGTH .5", WIDTH .5", DEPTH .009"). REMOVED CORROSION, FABRICATED AND INSTALLED NEW CREASE BEAM WEB.SDR COEA2011051605912Crease Beam · corrodedWO 101935 NR 100009 HEAVY CK COE / LEVEL 2 CORROSION: RT CREASE BEAM INNER CHORD IS CORRODED FR 17-23 (LENGTH 2.5", WIDTH 1.0", DEPTH 0.10"). REMOVED CORROSION, REMOVED AND REPLACED INNER CHORD WITH OEM PART.SDR HEEA131129Pan · crackedLT ENGINE PAN SKIN FOUND TO BE CRACKED. REPAIRED IAW THE FAA-APPROVED REPAIR DATA.SDR A6WA201140551Post · crackedVERTICAL POST AT FS 409.00+128, LBL 27.00 INBD IS CRACKED AT BOTTOM END. REPAIRED FS 409.00+128, LBL 27.00, INBD VERTICAL POST IAW REO 601R-53-41-056, REV E & REO 601R-53-41-1417.SDR UALA2011051602405Crease Beam · crackedMED R4 CREASE BEAM (HOCKEY STICK) CRACKED AT STA 1681 RBL. REMOVED DAMAGE AT BS1683 & BS 1639. ACP NDT OF CHORD & FASTENER HOLES REF NDT MANUAL, NO DEFECTS. FABRICATED & INSTALLED DOUBLER REPAIR AT BS 1683 & ANGLE REPAIR AT BS 1639 REF EA PD57- 53-118 & UA-SDR USAA2011052400001Door Frame · crackedA .5 INCH CRACK ON FORWARD SERVICE DOOR FRAME AT BS 318, S15L. REPAIRED FORWARD SERVICE DOOR FRAME AT BS 318, S15L IAW EA 102887.SDR ZZDA2011484Door Frame · crackedFORWARD ENTRY DOOR AFT FRAME, STA 210, LONG 15, CRACKED. ACCOMPLISHED DOOR AFT FRAME DOUBLER REPAIR PER B717 SRM 51-70-10.SDR DALA1134179863Door Frame · crackedFUSELAGE EXTERIOR FWD AIR STAIRS DOOR CUT OUT LOWER AFT CORNER PREVIOUS REPAIR CRACKED AT FASTENER. GAINED ACCESS CUT OUT AREAS OF DAMAGED SKIN, NDT VERIFIED ALL DAMAGE REMOVED PER NDT SPM 06-10-01. FABRICATED AND INSTALLED REPAIR IAW SRM 53-05 FIG 57A AND DSDR A6WA201140554Post · crackedVERTICAL POST AT FS 409.0+128, LBL 18.0 OTBD IS CRACKD AT BOTTOM END. REPAIRED VERTICAL POST AT FS 409.0+128, LBL 18.0 OTBD CRACK AT BOTTOM END BY FULLY INCORPORATING REPAIR SHOWN IN VIEW CC OF REO 601R-53-41-056, REV E 6/28/06 AND REO 601R-53-41-1417 REV - 5SDR AALA20110512TUL07Door Frame · crackedRIGHT NUMBER 2 DOOR ON FORWARD FRAME AT CUTOUT CRACKED. INSTALLED DOUBLER REPAIR PER EA COMP-52-016843.SDR VNAA2011051600007Structure · damagedWHILE DIVERTING DUE TO WEATHER, CREW REPORTED LIGHTNING STRIKE ON RT SIDE OF ACFT. CREW LANDED WITHOUT INCIDENT. MX INSPECTED ACFT, R & R GROUND SCREW ON TAIL CONE, REPLACED STATIC WICK ON LT HORIZ STAB TIP FAIRING, APPLIED TOPCOAT TO SEVERAL LOCATIONS ON RTSDR COEA2011051103912Crease Beam · corrodedWO 101935 NR 100006: HEAVY CK COE / MAJOR REPAIR / LEVEL 2 CORROSION: LT CREASE BEAM WEB FR 21-22 HAS CORROSION ON THE UPPER SURFACE (LENGTH .800", WIDTH .800", DEPTH .011"). REPAIR PER STRUCTURAL REPAIR INSTRUCTIONS FROM ATR.SDR COEA2011051002912Crease Beam · corrodedWO 101935 NR 100009 HEAVY CK COE / LEVEL 2 CORROSION: RT CREASE BEAM INNER CHORD IS CORRODED FR 17 - 23. REMOVED AND REPLACED CHORD WITH OEM PART.SDR C2XA11SH089Window Frame · crackedSHV - DURING C-CHECK RT FRAME 10 BELOW DV WINDOW CRACKED. MAINTENANCE REMOVED AND REPLACED RT FRAME 10 IAW EMB-145XR SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR DALA1400790965Beam · corrodedCORROSION WAS FOUND ON THE VERTICAL WEB OF THE AFT CARGO LOWER BEAM. REPAIR IAW ERA 492505-14.SDR DALA1132379866Window Frame · crackedMAIN CABIN BETWEEN STA 734 AND 753 RT WINDOW FRAME CRACKED AT FASTENER UPPER FWD END. FABRICATED, LOCATED, DRILLED DEBURRED AND INSTALLED DOUBLER AND FILLER AT MAIN CABIN IAW DC9-A-56-20-02-801-663A-A. MATERIAL VERIFICATION DOUBLER .063 7075-T6 LOT NR 113590SDR DALA1132369866Pan · crackedMAIN CABIN BETWEEN STA 1022 AND 1041 LEFT SIDE WINDOW PAN CRACKED ON TOP AND BOTTOM AFT CORNERS. REMOVED DAMAGED ANGLES IAW DC-9-A-56-20-02-801-663A-A. MATERIAL FABBED DOUBLER .063 PART NR 7075-T6 LOTNR 1135036, FILLER .040 2024-T3 IAW DC9 SRM 51-10-4 DC-9ASDR HYIA20110507001Window Frame · damagedDURING HEAVY CHECK INSP, FUSELAGE WINDSHIELD NODE 5 LT AND RT SILL FITTINGS AND WINDOW FRAME WERE FOUND DAMAGED AND CORRODED DURING ZONAL INSPECTIONS ZL-211-GVI-10000/10100/10020/10030. DAMAGE WAS OUT OF LIMITS AND SUBMITTED. DAMAGE WAS BLENDED OUT BY TECH SESDR AALA20110507TUL02Door Frame · corrodedAFT CARGO, DOOR JAMB WEB, CORROSION AT NUT PLATE HOLES, STATIONS 1214 TO 1217 BETWEEN LONGERON 28 AND 27 RIGHT. INSTALLED NEW WEB SPLICE PER AARD 53-10-00-24.SDR USAA2011052300003Door Frame · crackedA 0.600" LONG CRACK ON FORWARD CARGO DOOR BEAM NR 1 AT FR22A NEAR ACTUATOR FITTING. REPAIRED FORWARD CARGO DOOR BEAM NR 1 AT FR22A NEAR ACTUATOR FITTING IAW EA 134458.SDR IPXA11M66759Door Frame · crackedINSPECTION TYPE:4C, CRACK ON LOWER AFT SIDE OF L3 DOOR JAMB AT APPROX STA 1305. REPAIRED CRACK ON LOWER AFT SIDE OF L3 DOOR JAMB AT APPROX STA 1305 IAW SRM 53-40-15, REPAIR 3.SDR IPXA11M66758Door Frame · crackedINSPECTION TYPE:4C, CRACK ON LOWER FWD CORNER OF R3 DOOR JAMB AT APPROX STA 1305. REPAIRED LOWER FORWARD CORNER OF R3 DOOR JAMB AT APPROX STA 1305 IAW SRM 53-40-15, REPAIR 3.SDR FDEA201105061762Door Frame · corrodedUPON REMOVAL OF AFT LOWER RADIUS SEAL DEPRESSOR, FOUND C-2 DOOR SFT FRAME CORRODED AT LOWER STUB. CUTOUT DAMAGE ON C-2 DOOR LOWER AFT FRAME IAW FED EX B727 SRM REV 103, 51-10-1. FABRICATED AND INSTALLED DOUBLER AND FILLER IAW FED EX EA# 7-5230-136757 ANDSDR HNAA2011062400197Window Frame · corrodedRT NR 8 CABIN WINDOW AT X456.500 HAS CORROSION ON LOWER PORTION AT STR 168. REMOVED ALL CORROSION AT RT NR 8 CABIN WINDOW FRAME IAW -8,-100, RD8-53-623. PERFORMED HFEC INSPECTION IAW -8 -100 SERIES NTM 51-00-06. NO DEFECTS NOTED.SDR AALA20110504TUL04Door Frame · crackedCRACK ON LEFT FORWARD ENTRY DOOR JAM WEB AT STATION 206 LONGERON 15 LEFT. INSTALLED REPAIR STRAP PER AARD 53-10-00-11.SDR ASOA201100871Beam · crackedUPON REMOVAL OF INTERCOSTAL INBD BEAM, PN MM670-35326-003, FOUND CRACKED. R & R BEAM IAW SRM 51-42-06. FABRICATED, INSTALLED, SEALED, TREATED, PRIMED & PAINTED REPAIR PARTS IAW STEPS 3-6 PF STS EA 05-2011-224 AND SRM 51-42-21-001-001 & 51-42-06-001-001.SDR ZZDA2011448Doubler · corrodedLOWER AFT CARGO DOOR JAMB, CORROSION. ACCOMPLISHED DOOR JAMB DOUBLER REPAIR PER B717 SRM 53-20-15.SDR AALA20110503TUL04Door Frame · damagedCORROSION ON THE AFT DOOR FRAME WEB UPPER AND LOWER SIDES AT STATIONS 1212 TO 1218 BETWEEN LONGERONS 28 AND 29 RIGHT. INSTALLED NEW WEB AT STATIONS 1150 TO 1218 FROM LONGERONS 29 TO 26 RIGHT PER AARD 51-10-00-05, PER SRM 51-30-05 AND SRM 51-30-02.SDR AALA20110503TUL03Pan · crackedWINDOW RING PAN CRACKED, LOWER FORWARD CORNER, RIGHT STATION 984. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR UHLA2011050200159Door Frame · corrodedLEVEL 2 CORROSION FWD CARGO DOOR CUTOUT, AFT LWR CORNER SEAL REST. REPLACED CORRODED SEAL REST WITH NEW SEAL REST AND MATCH DRILLED IAW EMB 170 SRM 51-40-02.SDR UHLA2011050200158Door Frame · corrodedLEVEL 2 CORROSION FWD CARGO DOOR CUTOUT, FWD LWR CORNER SEAL REST. REPLACED CORRODED SEAL REST WITH NEW SEAL REST AND MATCH DRILLED IAW EMB 170 SRM 51-40-02.SDR SWAA113334Door Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FWD SERVICE DOOR CUTOUT FWD SUB FRAME CRACK AT BS 294.5 ABOVE STR 8R. REPAIRED PER DOC.SDR C2XA11TY054Door Frame · damagedSERVICE DOOR STRUCTURE FOR DOOR STOPS 3.9 AND 3.10 REQUIRE MOUNT HOLES TO BE REWORKED FOR SB145-53-0031. SERVICE DOOR FRAME STOP BACKUP STRUCTURE POSITION 3.9 AFT AND 3.10 AFT HOLE ELONGATED. REMOVED AND REPLACED DAMAGED SECTION OF FRAME 22 AND BACKUP STRUCTSDR TAMF201104300094Failsafe · corrodedDURING SC4 CHECK, FOUND CORROSION ON ONE HOLE SIDE FRAME FAILSAFE FITTING. REPAIR WAS PERFORMED WITH EWO 767-53-146.SDR TAMF201101300083Door Frame · scratchedDURING SC4 CK, FOUND SCRATCH ON FWD CARGO DOOR AFTER FRAME LOWER FITTING STA 614 AFT SIDE. REPAIR WAS PERFORMED WITH EWO 767-52-028.SDR A6WA201140451Beam · crackedRBL 27.00 INBD SIDE OF VERTICAL BEAM BOTTOM END CRACKED AT FS 409+128. REPAIRED RBL 27.00 INBD SIDE OF VERTICAL BEAM BOTTOM END IAW REO 601R-53-41-056.SDR ZZDA2011438Door Frame · corrodedINTERNAL AFT CORNER, FWD AIRSTAIR DOOR FRAME, CORROSION. ACCOMPLISHED FRAME REPLACEMENT PER B717 SRM 51-41-02.
Back to JASC 5310