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 SIMA20121029008Frame · corrodedIN FWD AVIONICS COMPARTMENT, CORROSION WAS FOUND AT FS 319 ON THE FLANGE BETWEEN S26 - 27L. REPAIRED IAW EO CR-53MR-303.SDR GLBA2012102900091Structure · crackedMAJOR REPAIR - DURING A SCHEDULED ROUTINE INSP FOUND CRACK AT A PREVIOUS REPAIR AT FS 163.97 AND STRINGER 9AR FRAME PROTRUDING OUT OF A STOP DRILL, .25" IN LENGTH. REPAIRED IAW EO 12-1900-53-060.SDR UALA2012102906209Frame · damagedBS 1265 RIGHT FRAME INNER CHORD AND WEB INTERCOSTALS SPLICE ANGLES REPAIRED IAW ECRA 5312-01051. REPAIRS ACP PER ECRA.SDR UALA2012102906208Frame · crackedWHILE PERFORMING ROUTINE TASK CARD 824003015 TENSION TIE INSPECTION FOUND ONE FASTENER HOLE CRACKED AT STA 1160 RIGHT SIDE. CRACK REPAIRED BY REPLACING FRAME PER 51-40-02 REV 83.SDR UALA2012102906206Frame · crackedPERFORMED J-C 824003015 TENSION TIES INSPECT FOUND STA 1160 LEFT FRAME ONE FASTENER HOLE CRACK. MAJOR REPAIR ACCOMPLISHED: REMOVED AND REPLACED FRAME PER SRM 51-40-02 GEN REV 83.SDR UALA2012102906204Frame · crackedPERFORM J-C 824003015 TENSION TIES INSPECT FOUND STA 1120 RT FRAME TWO FASTENERS HOLES CRACK. REMOVED AND REPLACED FRAME PER SRM.SDR UALA2012102906203Frame · crackedPERFORM J-C 824003015 TENSION TIES INSPECT FOUND ONE FASTENER HOLE CRACK ON STA 1120 LEFT FRAME. REMOVED AND REPLACED FRAME PER SRM.SDR UALA2012102906202Frame · crackedPERFORMED J-C 824003015 TENSION TIES INSPECTED FOUND STA 1200 RT FRAME TWO FASTENER HOLES CRACKED. REMOVED AND REPLACED NEW FRAME PER SRM 51-40-02 GEN REV 83.SDR UALA2012102906200Failsafe · crackedPER ROUTINE TASK CARD 82400315, FOUND STA 1200 FAIL SAFE CHORD FASTENER HOLE CRACKED. CHORD REPAIRED PER SRM 51-71-11 REV 83 AND 53-10-99 PG 201 REV 156.SDR CALA2012110900790Frame · damagedFRAME HAS TWO MISDRILLED HOLES AT 727D STR 2R AND 3R. REPAIRED IAW ECRA 5310-05529.SDR AALA20121029027Frame · crackedCRACK INDICATION AT INBOARD FASTENER FOR AIR CONDITIONING RAIL FRAME STATION 887 RIGHT. ACCOMPLISHED NESTED ANGLE REPAIR PER J1159AD CARD 0007 AND EA B737-53-026794.SDR AALA20121029021Frame · dentedAFT CARGO COMPARTMENT FRAME HAS DENT AT BODY STATION 1480, STRINGERS 26 TO 27 LEFT. REMOVED AND RE-INSTALLED TRANSITION PANEL, INTERCOSTAL CLIPS AND TIE DOWN FITTING PER SRM 51-40-02.SDR WVER2012102950501Frame · bentFS 193 FRAME P/N CC670-34201-1 IS BENT DUE TO BIRD STRIKE BETWEEN STR 14L AND 16L. REPAIRED IAW CRJ 700 SRM 51-42-06-001-001-A01, 51-42-21-001-001-A01, AND BOMBARDIER REO 670-53-11-762.SDR SWAA2012110609113Frame · crackedFRAME CRACKED AT BS 847, BETWEEN STR 24R TO STR 23R. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR FDEA201210283765Frame · crackedDURING THE INSPECTION OF EO 8-5100-7-5001, PT 2, FOUND FUSELAGE FRAME BS 1159 LT CRACKED ON THE LOWER INBD LEG. REPAIRED CRACKED FRAME IAW SRM 53-30-00, FIG 7, SHEETS 1-6, MAJOR REPAIR.SDR USAA2012111900019Frame · corroded2S CHECK - CORROSION ON FRAME AT FR68, S23L. REPAIRED FRAME AT FR68, S23L IAW A319 SRM 53-41-12.SDR ASAA2012102793220Frame · crackedRIGHT FRAME BS 520 HAS A CRACK AT THE ONE WIRE FEED THRU HOLE APPROXIMATELY .3750 LONG, REPAIRED RT FRAME IAW SRM 53 00 07, REPAIR 13 DETAIL.SDR AALA20121029008Frame · crackedLEFT FRAME CRACKED AT AIR CONDITIONING RAIL SUPPORT BRACKET STATION 727B. INSTALLED REPAIR ANGLE PER ECO J1159AE.SDR AALA20121029007Frame · crackedRIGHT FRAME CRACKED AT AIR CONDITIONING RAIL SUPPORT BRACKET STATION 500F. INSTALLED REPAIR ANGLE PER ECO J1159AE.SDR AALA20121029006Frame · crackedRIGHT FRAME CRACKED AT AIR CONDITIONING RAIL SUPPORT BRACKET STATION 480. INSTALLED REPAIR ANGLE PER ECO J1159AE.SDR AALA20121029005Frame · crackedLEFT FRAME CRACKED AT AIR CONDITIONING RAIL SUPPORT BRACKET STATION727B. INSTALLED REPAIR DOUBLER AND REPAIR ANGLE PER ECO J1159AE.SDR AALA20121029004Frame · crackedLEFT FRAME CRACKED AT AIR CONDITIONING RAIL SUPPORT BRACKET STATION 500F. INSTALLED REPAIR DOUBLER AND REPAIR ANGLE PER ECO J1159AE.SDR AALA20121027003Frame · crackedRIGHT FRAME CRACKED AT AIR CONDITIONING RAIL SUPPORT BRACKET STATION 440. INSTALLED REPAIR ANGLE PER ECO J1159AE.SDR AALA20121027002Frame · crackedLEFT FRAME CRACKED AT AIR CONDITIONING RAIL SUPPORT BRACKET STATION 480. INSTALLED REPAIR DOUBLER AND REPAIR ANGLE PER ECO J1159AE.SDR DALA1254833737Frame · crackedCABIN FRAME AT BS 727B IS CRACKED LOCATED AT STRINGER 8L. REPAIRED IAW ERA 507346-14 AD ORIG.SDR DALA1254823737Frame · crackedCABIN FRAME AT BS 400 IS CRACKED AT STRINGER 8L. REPAIRED IAW ERA 507346-14 AD ORIG.SDR DALA1254813737Frame · crackedCABIN FRAME AT BS 440 IS CRACKED AT STRINGER 8R. REPAIRED IAW ERA 507346-14 AD ORIG.SDR SWAA2012111309297Frame · crackedFRAME CRACKED AT BS 951, BETWEEN STR 11L TO STR 7L. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA2012111209224Frame · corrodedFRAME CORRODED AT BS 889, BETWEEN STR 30L TO STR 29L. REPAIRED FRAME IAW SRM.SDR SWAA2012111209223Frame · corrodedFRAME CORRODED AT BS 870, BETWEEN STR 30L TO STR 29L. REPAIRED FRAME IAW SRM.SDR USAA2012110900003Cleat · corroded2S CHECK. FUSELAGE FRAME CLEAT CORRODED AT FR 34 BETWEEN S41R & S42R. REMOVED AND REPLACED CLEAT IAW A319 SRM 51-72-11 AND AIRBUS DRAWINGS D53230813 & D53233211.SDR SWAA2012110909203Frame · crackedFRAME CRACKED AT BS 1144, STR 1. REPAIRED SPLICE IAW SRM.SDR FDEA201210253747Frame · damagedFRAME HAS SHORT EDGE MARGIN CONDITION AT STA 680 , S-4L AND S-4R. COMPLIED WITH EA F-5310-162557.SDR DALA12011140984Frame · corrodedAFT CARGO FRAME WEB LWR CORD CORROSION. STA 1309 LBL 12 TO RBL 12 AFT SIDE OF FRAME. BLENDED AREAS OF CORROSION. UT OF BLENDED AREAS IAW 04-00-07, FIG 3. FOUND .042 REMAINING MATERIAL AT BL-0, OUT OF LIMITS IAW SRM 53-01. CORROSION CONTAINED. PERFORMED REPASDR SWAA2012112901023Frame · corrodedINNER CHORD SMALL HOLES AROUND INSTALLED FASTENER STATION 460, RIGHT Z-ANGLE DOT 2. REMOVED AND REPLACED CHORD IAW SRM.SDR SWAA2012112609782Frame · crackedINNER CHORD CRACKED, STATION 440, FASTENER HOLE LEFT Z-ANGLE LBL 21. REMOVED AND REPLACED FRAME IAW SRM BOEING DWG.SDR ASOA2012112602513Frame · crackedFWD FUSELAGE FS 597.4 FRAME UNDER FAIRING CLIP CRACKED. COMPLIED WITH REO 670-53-82-438.SDR SWAA2012111909616Frame · crackedCRACKED, INNER CHORD, STA 420, LBL 21, FASTENER HOLE LEFT Z-ANGLE. REMOVED AND REPLACED FRAME IAW EA.SDR FDEA201210243732Frame · crackedFOUND A CRACK 6MM IN LENGTH AT RT SIDE FRAME 40 LOWER OTBD RADIUS AREA. COMPLIED WITH EA 6-5710-163147.SDR SWAA2012111309291Frame · crackedFRAME CRACKED AT BS 492, STR 24R. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA2012110909188Frame · crackedSTUB FRAME CRACKED AT BS 947.5+14, STR 17R. REPAIRED STUB FRAME IAW EO AND EA.SDR SWAA2012110509088Frame · crackedFRAME INNER CHORD CRACKED AT BS 343, STR 22L. REPAIRED CHORD IAW SRM AND EA.SDR AALA20121024012Frame · damagedSTATION 420 LEFT FRAME WEB DAMAGED AT STANDOFF HOLE ABOVE LONGERON 13 LEFT. INSTALLED DOUBLER REPAIR PER SRM 51-70-11-2R.SDR ERAA20120088Frame · corrodedCORROSION FOUND ON FRAME UNDER LAVATORY AT STA X202.75 BETWEEN STR 28 & 29.SDR DALA2014092905314Frame · crackedDURING INSPECTION OF PASSENGER CABIN, FOUND STRINGER 8 FRAMES CRACKED. MAINTENANCE REPAIRED IAW ERA 506383.SDR DALA2014062503776Frame · crackedDURING INSPECTION, FOUND STRINGER 8R FRAMES CRACKED. MAINTENANCE REPAIRED IAW ERA 504524.SDR DALA14032823728Frame · crackedDURING INSPECTION, FOUND STRINGER 8 FRAME CRACKED. MAINTENANCE REPAIRED IAW ERA 502904.SDR DALA14023593724Frame · crackedDURING INSPECTION FOUND FRAME CRACKED. MAINTENANCE REPAIRED IAW ERA 502901.SDR SWAA2012112609780Frame · crackedAFT OF AFT CARGO PIT, BS 947, STR 19R, FRAME IS CRACKED FROM STRINGER CUTOUT HOLE. REMOVED AND REPLACED FRAME PER SRM AND BC DWG.SDR SWAA2012111209261Frame · crackedFRAME CRACKED AT BS 947.5, STR 19R. REMOVED AND REPLACED FRAME IAW SRM AND DWG.
Back to JASC 5311