JASC 5311
Service difficulty reports · 61,554
Reports filed under 5311 · Fuselage Main, Frame, 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 = '5311' 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 = '5311' 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 FDEA201005291730Frame · damagedCOMPLY WITH T CARD REPAIR IAW EA T 6-5310-113006 PART 2,WRI 53102241. ACCOMPLISHED REPAIR ON FUSELAGE FRAME 46 IAW EA 6-5310-113006C PART 2 - FUSELAGE - AD2009-18-16 - EO 6-5310-7-5020. FRAMES 44 TO 46 FOOT FITTINGS CRACKS -REPAIR.SDR SWAA103121Frame · corrodedDURING SCHEDULED OTS CHECK, FOUND FRAME CORRODED AT BS 967, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME PER ER.SDR SWAA103101Frame · crackedDURING SCHEDULED MV2 CHECK, FOUND FRAME CRACKED AT BS 827, STR 25L. REPAIRED FRAME PER SRM.SDR UALA2010052701823Failsafe · crackedCRACK-FRAME ATTACH FAIL SAFE CHORD HOLE AT STA 1140 RT. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGED CHORD. HFEC-NO CRACKS. FABRICATED AND INSTALLED REPAIR PARTS.SDR AALA20100527TUL19Frame · crackedFRAME CRACKED AT INBOARD FASTENER AT AIR CONDITIONING BRACKET STATION 727B RIGHT. INSTALLED REPAIR PER ECO J1159AC.SDR AALA20100527TUL18Frame · crackedFRAME CRACKED AT INBOARD FASTENER AT AIR CONDITIONING BRACKET STATION 500A RIGHT. INSTALLED REPAIR PER ECO J1159AC.SDR AALA20100527TUL17Frame · crackedFRAME CRACKED AT INBOARD FASTENER OF AIR CONDITIONING BRACKET STATION 480 RIGHT. INSTALLED REPAIR PER ECO J1159AC.SDR AALA20100527TUL16Frame · crackedFRAME CRACKED AT INBOARD FASTENER OF AIR CONDITIONING BRACKET STATION 400 RIGHT. INSTALLED REPAIR PER ECO J1159AC.SDR AALA20100527TUL15Frame · crackedFRAME CRACKED AT INBOARD FASTENER OF AIR CONDITIONING SUPPORT BRACKET STATION 400 LEFT. INSTALLED FRAME REPAIR PER ECO J1159AC.SDR AALA20100527TUL14Frame · crackedFRAME CRACKED AT INBOARD FASTENER OF AIR CONDITIONING BRACKET STATION 500C RIGHT. INSTALLED FRAME REPAIR PER ECO J1159AC.SDR AALA20100527TUL13Frame · crackedFRAME CRACKED AT INBOARD FASTENER OF AIR CONDITIONING SUPPORT BRACKET STATION 500C LEFT SIDE. INSTALLED FRAME REPAIR PER ECO J1159AC.SDR IPXA10560733Frame · gougedINSPECTION TYPE:C3, GOUGE IN FRAME AT BS 1620 AT STR 13-14 LT IS IN THE RADIUS AND CAN NOT BE CLEANED UP IAW THE SRM. REPAIRED IAW ATS ER 10-2946.SDR FDEA201005261664Frame · damagedFRAME AT BS 1600, S26L, IS DAMAGED. (IN-PROCESS; AWF FOR REPAIR PARTS) DAMAGED FRAME STA 1600 STR 26L FOUND OUT OF LIMITS IAW SRM 53-00-07 PG-103 FIG. 101 DET. II. ORIG. MAT. .063" MAT. REMAIN .053" MAT. LOSS .010" L=1.0" W=2.0" FABBRICATED & INSTALLED J-SSDR COEA2010052609917Frame · damagedHEAVY CK COE: MAJOR REPAIR: WHILE WORKING LT CREASE BEAM AT FRAME 17 FOUND PREVIOUS TOOLING DAMAGE ON TOP SURFACE OF INNER FLANGE FR17 AT STRINGER 14 LT. BLEND OUT DAMAGE ON INNER FLANGE OF FRAME 17 AT LEVEL OF CARGO DOOR THRESHOLD PER SRM. TOOLING MARKS TSDR FDEA201005261695Frame · crackedLT SIDE FR 40 CTR WING JOINT - MIDDLE HOLE HAS 2 CRACK INDICATIONS, BEGINNING APPROX .25 IN. FROM INBD FACE OF FR 40 TO APPROX .5 IN. INSIDE HOLE. APPEARS INDICATIONS ARE CONFINED TO FR 40 LAYER ONLY. INDICATIONS APPROX 8-9 O-CLOCK AS VIEWED FACING OTBD FRSDR FDEA201005261663Frame · corrodedFRAME AT BS 1380, S26L-S27L, IS EXFOLIATED. (IN-PROCESS; REMOVING FRAME, AWP 146N8511-34 AND AWE).SDR CALA2010052700226Beltframe · crackedCABIN BELTFRAME CRACKED AT LT SIDE STA 1580 BETWEEN STRINGERS 8LT AND 9LT INSTALLED REPAIR AT STA 1580 LT SIDE BETWEEN STRINGER 8LT AND 9LT. ISSUED DIP 05262 TO PERFORM DETAILED VISUAL INSP AT 12,000 FLIGHT CYCLES OR 50,000 AIRFRAME FLIGHT CYCLES WHICHEVER COSDR CALA2010052700225Beltframe · crackedCABIN BELTFRAME CRACKED AT RT SIDE STA 1580 BETWEEN STRINGERS 8RT AND 9RT. INSTALLED REPAIR AT STA 1580 RT SIDE BETWEEN STRINGER 8RT AND 9RT. ISSUED DIP TO PERFORM DETAILED VISUAL INSP AT 12,000 FLIGHT CYCLES OR 50,000 AIRFRAME FLIGHT CYCLES WHICHEVER COMES SDR DALA1019569008Frame · unknownFUSELAGE OVERWING FRAME REPAIRED IAW EO 09-460094-12, ME 03.SDR ASOA201000823Frame · corrodedCORROSION FOUND AT FS 333 BETWEEN STR 26L AND 27 FOUND ON FRAME. REMOVED CORROSION FROM FRAME BETWEEN STR 26L AND 26R IAW SRM 51-21-06. AT FS 333. PERFORMED THICKNESS INSPECTION OF BLEND AREA ON ANGLE AT FS 333.00 BETWEEN S26 AND S27L IAW MAC NDT INSP PROCSDR CALA2010052700224Beltframe · crackedCABIN BELTFRAME CRACKED AT STA 760 RT SIDE BETWEEN STRINGERS 8RT AND 9RT. INSTALLED REPAIR AT STA 760 BELTFRAME STRINGER BETWEEN 8RT AND 9RT REF SRM 53-00-07 REPAIR 1.SDR ASOA201000814Frame · noneMAIN AVIONICS COMPARTMENT FS 319.70 BETWEEN S26L & S27 FRAME AFT SIDE HAS CORROSION. AFTER FURTHER INVESTIGATION FOUND TO BE MISSING PAINT AND DIRT. CLEANED AREA NO CORROSION FOUND. ALODINED PRIMED AND PAINTED IAW SRM CH 51-25-00-001-001-A01.SDR DALA1011106301Doubler · damagedDURING L-CHECK FOUND OVERSIZED HOLES ON FRAME DOUBLER AT OTBD BS 1265 BELOW FLOOR. REPAIRED IAW SRM 51-10-02 & DWG 624U0060.SDR DALA1011096301Frame · damagedDURING L-CHECK FOUND OVERSIZED FASTENER HOLE IN RT BS 1265 OTBD FRAME WEB JUST BELOW S27R OTBD CHORD AREA. REPAIRED IAW ERA 480443-14AD SECTION I. SECTION II REQUIRES PERMANENT REPAIR IN 24 MONTHS OR 2000 CYCLES AFTER 19 MAY 2010 WHICHEVER COMES FIRST.SDR SWAA103077Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 328, STR 26R TO STR 27R. REPAIRED FRAME PER SRM.SDR CALA2010052700222Frame · crackedMAIN FRAME CRACKED AT STA 616 BELOW STR 17 RT. INSTALLED REPAIR PER ECRA 5311-01158.SDR DALA1010906301Attach Angle · crackedDURING L-CHECK FOUND FRAME ATTACH ANGLE CRACKED AT BS 480 S16R. FABRICATED ATTACH ANGLE AS IAW DWG65B08301 AND INSTALLED IAW SRM 51-10-02.SDR SWAA103066Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER EA.SDR DALA1010866301Frame · crackedDURING L-CHECK FOUND CRACK IN RT FRAME WEB AT BS 1265. REPAIR ACCOMPLISHED IAW ERA 480450-14AD SECTION I TIME LIMITED REPAIR. SECTION II OF ERA 480450-14AD TO BE ACCOMPLISHED WITHIN 22,000 TOTAL AIRFRAME FLIGHT CYCLES.SDR DALA1010539857Frame · damagedDURING LINE CHECK FOUND DAMAGE TO FRAME AT BS1190 RT SIDE BELOW AUG VALVE. REPAIRED IAW ERA 482388-14, SRM 51-20-03.SDR DL76L101281Frame · damagedDURING ACCOMPLISHMENT OF EA 01-455913-03AD ME-01. FOUND THE FRAME MISDRILLED AT FS 303 AT OTBD FASTERENER COMMON TO PN 287N4648-72 BRACKET. THE SUBJECT HOLE HAS EDGE DAMAGE AND IS NEAR THE RADIUS AND 2 REMAINING HOLES HAVE A LOOSE FIT WHEN THEY SHOULD BE TRSDR IPXA0560629Frame · chafedINSPECTION TYPE:C3, FRAME CHAFED AT BS377.7 RT BETWEEN STRINGER 22R AND 23R. REPAIRING FRAME IAW ER 10-2942.SDR SWAA103043Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 328, STR 20R TO STR 21R. REPAIRED FRAME PER EO.SDR SWAA103040Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 14R. REPAIRED FRAME PER SRM.SDR SWAA103039Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA103029Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER EA.SDR SWAA103028Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER EA.SDR SIMA201014401Frame · damagedDURING MAINTENANCE BASE VISIT FOUND THE RIGHT CARGO WALL FRAME 64 HAS TOOLING DAMAGE. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED FRAME 64 IAW EO-EM-53MR-1557. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR DALA1010926301Frame · crackedDURING L-CHECK AND INSP IAW EA 63-206038 ADDITIONAL CRACKS WERE FOUND COMMON TO THE LT BS 1265 FRAME WEB. REPAIRED IAW ERA 480444-14AD SECTION I. SECTION II OF ERA 480444-14AD REQUIRES REPETITIVE INSP EVERY 1,000 FLIGHT CYCLES UNTIL PERMANENT REPAIR IS ACCOMPLSDR IPXA10560749Frame · gougedINSPECTION TYPE:C3, MAIN CARGO BAY FRAME INNER FLANGE HAS A SCREW GOUGE BS 1500, STR 15R. REPAIR IAW SRM 53-00-07 AND ER NR10-2964.SDR IPXA10560748Frame · gougedINSPECTION TYPE:C3, MAIN CARGO BAY FRAME INNER FLANGE HAS A SCREW GOUGE BS 1340 STR 15R. REPAIR IAW SRM 53-00-07 AND ER NR10-2964.SDR IPXA10560732Frame · damagedINSPECTION TYPE:C3, SCREW DAMAGE ON INBD SURFACE OF FRAME STA 480 AT STR 5R AND 15R. REPAIRED IAW ATS ER 10-2928.SDR IPXA10560731Frame · damagedINSPECTION TYPE:C3, SCREW DAMAGE ON INBD SURFACE OF FRAME STA 780 AT STR 5R AND 15R. REPAIRED PER ATS ER 10-2928.SDR IPXA10560730Frame · damagedINSPECTION TYPE:C3, SCREW DAMAGE ON INBD SURFACE OF FRAME STA 540 AT STR 5R. REPAIR IAW ATS ER 10-2928.SDR IPXA10560699Frame · damagedINSPECTION TYPE:C3, SCREW DAMAGE ON INBD SURFACE OF FRAME STA 860 AT STR 5L AND 15L. REPAIRED IAW ATS ER NR 10-2966, DATED 17 JUNE 2010.SDR IPXA0560628Frame · gougedINSPECTION TYPE:C3, MAIN CARGO BAY FRAME INNER FLANGE IS GOUGED BS1681, STR15L. REPAIR FRAME IAW ER 10-2962.SDR IPXA0560617Frame · gougedINSPECTION TYPE:C3, MAIN CARGO BAY FRAME INNER FLANGE HAS A SCREW GOUGE, BS 1220 STR 15L. REPAIR IAW ATS ER 10-2937.SDR IPXA10560505Frame · gougedINSPECTION TYPE:C3, FRAME AT BS 1060 BETWEEN STR 15L-16L HAS SCREW START. REMOVED DAMAGE AND TAPERED AREA IAW B757-53-10-38-185-A.SDR IPXA10560439Frame · gougedINSPECTION TYPE:C3, FRAME AT BS 1140 BETWEEN STR 15R TO STR 16R HAS SCREW START GOUGE FOUND TO BE OUT OF LIMITS. BLENDED AREA AND TAPERED IAW EO B757-5310-38191-A.SDR GLBA20100521FFrame · crackedDURING ROUTINE SCHEDULED MX, A CRACK AT FRAME FS 288 AND STR 4C CUTOUT CRACKED .35" IN LENGTH. MAINTENANCE REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS I.A.W. EO 10-1900-53-020. MATERIALS UTILIZED ARE INCLUDED IN THE ENGINEERING ORDER
Back to JASC 5311