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 FDEA201204211518Structure · bentMAIN DECK CARGO FR 21, STR 8 AND 9R BENT DEFECT MEASURES INCHES AT SPLICE REPAIR. REMOVED AND RE-INSTALLED NEW FABRICATED SPLICE REPAIR AT FR 21 BETWEEN STR'S 8R AND 9R IAW SRM 51-40-21, PG 7, PAR 6.SDR CA120420002Door Frame · cracked(CAN) CRACK FOUND ON CABIN DOOR FRAME CENTER LOCATION. THIS AREA IS NOT SPECIFIED TO INSPECT IN THE MFG INSPECTION PROGRAM. THIS LOCATION CAN BE SEEN WITH THE USE OF A BORESCOPE.SDR SWAA2012051403981Web · corrodedWEB CORRODED BETWEEN BS 767 TO BS 787, STR 17R. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR AALA20120420007Reveal · crackedFORWARD CARGO DOOR FORWARD REVEAL HAS 1 INCH CRACK APPROXIMATELY 10 INCHES FROM BOTTOM. INSTALLED REPAIR ON REVEAL PER SRM 51-70-13-2R.SDR EE4Y2012051700172Support Beam · corrodedPAX CABIN BETWEEN FR 66 - 67, -Y50 FLOOR SUPPORT BEAM WITH CORROSION. DAMAGED PART WAS REPLACED IAW THE SRM 51-72-11, PARAGRAPH 4 AND 6.SDR SWAA2012051003871Door Frame · crackedR1 DOOR CUTOUT FRAME CRACKED AT BS 297, STR 7R. REPAIRED FRAME PER EA.SDR AALA20120419014Door Frame · gougedGOUGE IN AFT CARGO DOOR JAMB FORWARD FRAME. INSTALLED EXTERNAL DOUBLER AND TRIPLER PER EA 737-53-023144.SDR SWAA2012042703499Crease Beam · crackedLT CREASE BEAM WEB CRACKED AT BS 616. REMOVED AND REPLACED WEB IAW SRM & DWG.SDR SWAA2012050803803Door Frame · crackedL2 DOOR FORWARD EDGE FRAME BS 959.6 CRACKED AT FWD LOWER CORNER EDGE. REPAIRED FRAME IAW SRM.SDR UIEA2012050700194Fastener · missingFOUND A MISSING FASTENER AT BS 2598, WL 320, LBL 37. ACCOMPLISHED EI T2012A53B-850.SDR USAA2012041900002Beam · crackedVERTICAL WEB AT RBL 17 HAS 2 CRACKS IN BEAM WEB BELOW WL 234 AT BS 179.25. CUT OUT DOUBLER AND REPLACED DOUBLER AT BS179.25, RBL17 IAW SRM 53-10-08-2RSDR KCSA201204171060Reveal · crackedR-5 DOOR OPENING REVEAL CRACKED AT BS 2231 BETWEEN STR 16R AND 17R.SDR DALA1231940675Crease Beam · corrodedCREASE BEAM EXFOLIATED AT BS 1400-1420 RBL 70.5. REMOVED DAMAGE FOUND TO BE OUT OF LIMITS. REMOVED AND REPLACED CREASE BEAM WEB REF SRM 51-40-02 PG 2.SDR DALA1231930675Crease Beam · corrodedCREASEBEAM WEB CORRODED AT BS 1440-1460 RBL 70.5. BLENDED CORROSION ON CREASEBEAM WEB BS. FOUND TO BE OUT OF LIMITS IAW SRM 53-60-13 PG 103 DETAIL III. REMOVED CREASEBEAM WEB IAW SRM 51-40-02 PG31 DETAIL I. INSTALLED CREASEBEAM WEB IAW SRM 51-40-02 PG21 FSDR DALA1231900675Crease Beam · corrodedCORRODED CREASE BEAM BS 1380-1400 RBL 70.5. REMOVED CORROSION ON CREASEBEAM WEB. FOUND TO BE OUT OF LIMITS IAW SRM 53-60-13 PG1 3 DETAIL III. REMOVED CREASEBEAM IAW 51-40-02 PG31 FIG 8. INSTALLED CREASEBEAM WEB IAW SRM 51-40-02 PG7 AND PG21 FIG 4.SDR DALA1229940675Crease Beam · corrodedCORRODED CREASEBEAM AT FS 996-1020 RBL 70.5, BLENDED CORROSION, FOUND TO BE OUT OF LIMITS. LOCATED AND DRILLED NEW CREASEBEAM WEB AND INSTALLED IAW B757 SRM 51-40-02 DURING HMV AT ST AEROSPACE SAN ANTONIO.SDR UALA2012041702294Window · arcedNR 1 ON WINDOW HEAT INTERMITTENTLY INOPERATIVE, FOUND EVIDENCE OF DISCOLORATION AND ARCHING ON LOWER LT SIDE OF F/O'S FORWARD WINDSHIELD. REPLACED RT NR 1 WINDOW AND ACP COA 507402.SDR AALA20120416004Crease Beam · damagedCREASE BEAM WEB STATIONS 1620 TO 1640 RIGHT HAS DAMAGED FASTENER HOLES. INSTALLED NEW WEB AND WEB SUPPORT BRACKET PER AARD 51-00-05-1.SDR ASOA20120417059Door Frame · corrodedCORROSION ON LWR AFT FRAME STRUCTURE OF SERVICE DOOR FRAME 22. CUT OUT DAMAGED AREA, DRILLED AND INSTALLED REPAIR DOUBLER.SDR SWAA2012050903834Window Frame · crackedCAPTAINS NR 1 WINDOW EXTERNAL FRAME O/B POST CRACKED AT THE UPPER CORNER. REMOVED AND REPLACED FRAME PER SRM.SDR DALA1224186818Crease Beam · corrodedCHORD - CONDITION: CORROSION LOCATION: INNER UPPER CREASE BEAM CHORD BETWEEN STA 729 - STA 740 APPROX LBL 64 POS: MID REMOVED DAMAGED CHORD AND DRILLED UP NEW PART PER BAC DWG 143N8322 (955289) INSTALLED NEW CHORD ANGLE REF BAC DWG 143N8322.SDR V2JA201201060009Antenna · leakingCABIN WAS OPERATING NORMALLY IN MANUAL UNTIL 20,000 FT AND THEN BEGAN AN UNCONTROLLED RISE. DESPITE OUR MANUAL IMPUTS TO DRIVE CABIN DOWN IT DID NOT RESPOND. WE THEN REQUESTED A TURN BACK AND A DESCENT. WITH ATC COORDINATION WE WERE ABLE TO GET CONTROL OF TSDR SWAA2012041303088Crease Beam · corrodedLT CREASE BEAM CORRODED BETWEEN BS 967 TO BS 986. REPAIRED BEAM PER SRM.SDR TRBA20120210001Structure · damagedTHE CREW REPORTED THAT ON CLIMBOUT, AFTER TAKEOFF THERE WAS A BIG BIRD STRIKE ON NOSE OF ACFT. THE CREW ELECTED TO RETURN TO DEPARTURE AND LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. REPAIRED DAMAGE IAW EO E2-53MR-312 AND EO E2-53MR-313. ACFT RETUSDR ASOA20120427068TCrossbeam · corrodedCROSSBEAM AT FRAME 20 HAS AREAS OF CORROSION. BLENDED AND FOUND TO BE WITHIN LIMITS. PERFORMED EDDY CURRENT, NO DEFECTS NOTED, ALODINED, PRIMED AND PAINTED.SDR DALA1221451404Failsafe · crackedRIGHT FUSELAGE STATION 955 REAR SPAR BULKHEAD FAILSAFE STRAP FASTENER HOLE CRACKED.SDR DALA1221431404Failsafe · crackedLEFT FUSELAGE STATION 955 REAR SPAR BULKHEAD FAIL SAFE STRAP FASTENER HOLE FOUND CORROSION AND CRACKED.SDR FDEA201204101339Longeron · corrodedCENTER CARGO COMPARTMENT, BILGE AREA BS 1646 LONGERON 50 LT FOUND WITH SURFACE CORROSION. REPAIR CARRIED OUT AT CENTER CARGO COMPARTMENT BILGE AREA STA 1646, LONGERON 50L IAW EA 1-5310-159838. REPAIR CLASSIFIED MAJOR IAW GMM 6-2-100, REV 114.SDR FDEA201204101338Longeron · corrodedCENTER CARGO COMPARTMENT BS 1676 LONGERON 51 LT FOUND WITH SURFACE CORROSION. REPAIRED IAW SRM 53-00-05, FIG 201, REPAIR 1, REV 49. REPAIR CLASSIFIED MAJOR IAW GMM 6-2-100, REV 114.SDR GLBA2012041001Door Frame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUTINE INSPECTION, FOUND A CRACK ON THE AIR STAIR DOOR ENTRANCE LWR FRAME AT THE LWR AFT CORNER, FS 173, 1.3" IN LENGTH. REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSP IAW EO 12-1900-53-020. MAJOR REPAIR.SDR IPXA2673132Failsafe · crackedINSPECTION TYPE: 8C, FUSELAGE BS 955 S22AR CRACK WAS FOUND AT RT SIDE FAIL SAFE STRAP AT 9 O/C POSITION 0937" APPROX. FUSELAGE RT BS 955 REAR SPAR BULKHEAD SIDE FTG FAIL SAFE STRAP IS REPAIRED IAW EO B767-5350-17922-J APPX 'D', ORIGINAL MATERIAL IS 2024T351-0SDR IPXA2673127Failsafe · crackedINSPECTION TYPE: 8C, FUSELAGE BS 955, S22LA CRACK WAS FOUND AT LT SIDE FAILSAFE STRAP AT 8 O`CLOCK POSITION .0937" APPROX. FUSELAGE LT BS 955 REAR SPAR BULKHEAD SIDE FTG FAIL SAFE STRAP IS REPAIRED IAW EO B767-5350-17922-J, APPROX C, ORIGINAL MATERIAL IS 2024SDR USAA2012041200007Beam · crackedA 5.5 INCH LONG CRACK IN AFT CARGO DOOR ACTUATOR BEAM ASSEMBLY BETWEEN FR62 TO FR63, -Y1727. REPLACED AFT CARGO DOOR ACTUATOR BEAM ASSEMBLY IAW EA 134646 & SRM 51-42-11.SDR FDEA201204091330Crossbeam · corrodedON REMOVAL OF SEAT TRACK 3L AT FR 26 TO 35, FOUND CORROSION ON FR 32 CROSSBEAM, EXTENDING UNDER CLEVIS ADAPTER. AFTER REMOVAL OF LEVEL 1 CORROSION ON UPPER SURFACE OF CROSSBEAM AT FR 32, IAW SRM 51-74-10, IT WAS FOUND TO BE OUT OF LIMITS IAW SRM 53-10-15, FIGSDR FDEA201204081290Door Frame · crackedCENTER CARGO - DOOR CUT-OUT UPPER DOOR FRAME AROUND ACTUATOR LINK ARM FITTING FOUND CRACKED. REPAIRED IAW EA 1-5310-159832. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100 REVISION 114.SDR IPXA2M73326Door Frame · damagedINSPECTION TYPE:4C, R-1 DOOR JAMB HAS DRILL START IN RADIUS OF CHANNEL INSIDE UPPER AFT LIGHTNING HOLE AT FS450.182. REPAIRED R-1 DOOR JAMB UPPER HEADER BEAM AT STA FS450.182 REF STA-SA, EA 011-5310-47035-A REV I/R AND EO MD11-5310-47035-A.SDR AALA20120407002Door Frame · damagedRIGHT FORWARD SERVICE DOOR CUTOUT, FORWARD JAMB WEB CRACKED AT STATION 296 AND RIGHT BUTTLINE 56, .5 INCHES ABOVE FLOOR. DAMAGE CUT OUT AND FILLER AND DOUBLER REPAIR INSTALLED PER EA B737-53-022811.SDR IPXA2M73163Web · crackedINSPECTION TYPE: 4C, L3 DOOR FRAME LOWER FWD LIGHTENING HOLE CRACKED IN WEB. REPAIRED WEB REF SRM 53-40-15 , REPAIR 3, FIG 201, REV 49.SDR FDEA201204061280Crease Beam · corrodedMAIN DECK LEFT CREASE BEAM BS 900 TO 1040 HAS SURFACE CORROSION. CLEANED IAW SRM 51-10-02 & CHECKED LIMITS IAW SRM 53-40-13, FIG 101, ORIGINAL MATERIAL THICKNESS .063", AFTER REWORK .018", REMAINING MATERIAL THICKNESS .045", FOUND TO BE OUT OF LIMISDR IPXA2M72907Web · crackedINSPECTION TYPE: 4C, R3 DOOR JAMB AFT LOWER LIGHTNING HOLE HAS A CRACK IN WEB. REPAIRED R-3 DOOR JAMB AFT LOWER LIGHTENING HOLE REF SRM 53-40-15, REPAIR 3, FIG 201.SDR USAA2012040900006Door Frame · crackedBC7 CHECK - 15 CRACKS IN FORWARD FRAME SEGMENT ON RIGHT FORWARD EMERGENCY EXIT DOOR 843. REPLACED FRAME SEGMENT ON RIGHT FORWARD EMERGENCY EXIT DOOR 843 IAW EO 5210Y228.SDR DALA1221011501Failsafe · crackedFOUND FAILSAFE CRACKED THROUGH THICKNESS AT LT BS 955 REAR SPAR BULKHEAD FITTING AREA.SDR DALA1221001501Failsafe · crackedFS 955 RT FAILSAFE FOUND CRACKS RUNNING FROM 5 O'CLOCK POSITION AND FROM 11 O'CLOCK POSITION.SDR DALA1228641501Failsafe · crackedBS 955 RT FAILSAFE STRAP FOUND CRACKED FROM 5O/C AND 11 O/C. REPAIRED PER ERA 501533-14AD REV ORIG.SDR LR7A2012040500373Beam · corrodedDURING SCHEDULED C-10 CHECK, FOUND RT MAIN WHEEL WELL BOW BEAM OUTBD CAP CORROSION AT FS557, WL150, RBL64 / REPAIRED BY REPLACEMENT IAW LOCKHEED SMP583 CHAPTER 51-60 & 51-70.SDR LR7A2012040500372Beam · crackedDURING SCHEDULED C-10 CHECK, FOUND LT BEAM ASSY OTBD CAP CRACKED AT FS 517, LBL 64, WL 256. REPAIRED IAW LAC MEA 382-53-12-033.SDR LR7A2012040500367Window Frame · crackedDURING SCHEDULED C-10 CHECK, FOUND RT SIDE WINDOW AFT FRAME LOWER CORNER CRACKED AT FS 156, WL 225, RBL 62. REPAIRED IAW SMP583, FIG 53-30-32.SDR LR7A2012040500357Post · crackedDURING SCHEDULED C-10 CHECK, FOUND LT WINDOW POST CRACKED AT FS 134, WL 251, LBL 62. REPAIRED IAW LAC MEA 382-53-12-015.SDR LR7A2012040500355Beam · corrodedDURING SCHEDULED C-10 CHECK, UNDER JOB CARD HC5324, FOUND MLG WHEEL WELL BEAM CORROSION UNDER REIMFORCEMENT PLATE AT FS577, WL160-163, RBL61. REPAIRED IAW LAC MEA 382-53-12-017.SDR USAA2012040900004Door Frame · crackedBC7 CHECK - 13 CRACKS IN FORWARD FRAME SEGMENT ON LEFT FORWARD EMERGENCY EXIT DOOR 833. REPLACED FRAME SEGMENT ON LEFT FORWARD EMERGENCY EXIT DOOR 833 IAW AIRWAYS EO 5210Y228.
Back to JASC 5310