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 USAA2009042290955Shim · corrodedBFM - C1 - MAJOR REPAIR - CORROSION ON LEFT REAR SPAR FAIL-SAFE STRAP SHIM AT BS 955. REPAIRED LEFT REAR SPAR FAIL-SAFE STRAP SHIM AT BS 955 IAW US AIRWAYS EA 134094.SDR SWAA092566Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FRAME CRACKED AT BS 847, BETWEEN STR 1R TO STR 2R. REPAIRED FRAME PER SRM.SDR SWAA092564Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 787, BETWEEN STR 13R TO STR 14R, WL 233.5. REPAIRED FRAME PER SWA EA.SDR FDEA200904211372Frame · corrodedNOSE WHEEL WELL STA 294.5, RBL 18 FRAME IS CORRODED AT LOWER FLANGE REMOVED CORROSION AND FOUND OUT OF LIMITS IAW SRM 53-10-1 FIG 1. REMOVED DAMAGED FRAME AND FABRICATED NEW FRAME IAW DRW NR 65-16312. HEAT TREATED TO T6 PER ER 2-37153-801 REV "A" ATTACHED. SDR FDEA200904211370Frame · damagedFRAME AT BS 1460, S-3L - S-3R, HAS MISDRILLED HOLES. CUTOUT BS 1460 FRAME FROM S-5L - S-5R, IAW SRM 51-10-02/SRM 53-00-07. RECEIVED NEW FRAME ON MAE TRAVELER NR T9/787915 AND 2 CHANNELS ON MAE TRAVELER NR'S T9/787899 AND T9/787890. LOCATED AND DRILLED REPAISDR SWIA200921868Frame · crackedRIGHT EXTERNAL FRAME 24 UPPER CORNER CRACKED. (C CHECK) REPAIRED PER SRM.SDR AALA20090422TUL15Frame · crackedFRAME CRACKED AT ALIGNMENT PIN HOLES FOR TAIL CONE AT STATION 1510. STOP DRILLED CRACK AND INSTALLED DOUBLER PER AARD 53-01-00.SDR USAA2009042490970Door Frame · crackedCLT - C1 - MAJOR REPAIR - CRACK AT L-2 DOOR GUSLOCK CUTOUT. REPAIRED L-2 DOOR GUSLOCK CUTOUT ON DOOR FRAME IAW US AIRWAYS EA 101105.SDR SWAA092552Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 3L. REPAIRED FRAME PER SWA EA.SDR SWAA092536Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 827, STR 13L. REPAIRED FRAME PER AAR EA.SDR SWAA092535Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 360, BETWEEN STR 13R TO STR 14R, WL 235. REPAIRED FRAME PER AAR EA.SDR FDEA200904201362Frame · damaged3 MISDRILLED HOLES AT S-2R, BS 1360, ON FRAME. CUTOUT DAMAGED FRAME SECTION AT BS 1360, S5L-5R, IAW SRM 53-00-07, FIG 201, REPAIR NR 1. FABRICATED FRAME SECTION ON MAE TRAVELER NR T9/787917, FABRICATED CHANNEL NR 1 ON MAE TRAVELER NR T9/787881, FABRICATED CHSDR FDEA200904201361Frame · damagedFRAME, BS 1340, S-3L - S-3R, HAS MISDRILLED HOLES. CUTOUT DAMAGED FRAME SECTION, FROM BS 1340, S-5L - S-5R, IAW SRM 53-00-07, FIG 201. REPAIR NR 1, LOCATED AND DRILLED ALL REPAIR PARTS IAW SRM 51-40-02. TREATED AND PRIMED ALL REPAIR PARTS IAW SRM 51-20-01.SDR FDEA200904201360Frame · damagedFRAME AT BS 1000, FROM S-3L - S-3R, HAS MISDRILLED HOLES. CUTOUT DAMAGED AREA OF FRAME, BS 1000, BETWEEN S-4R - S-4L, IAW SRM 53-00-07. REMOVED STRINGER CLIPS ON S-4L AND S-4R IAW SRM 51-40-02. RECEIVED NEW FRAME ON MAE TRAVELER NR T9/787787 AND CHANNEL 1 ASDR SWAA092497Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 16L. REPAIRED FRAME PER SRM.SDR FDEA200904171573Frame · damagedAFT CARGO COMPARTMENT, EXISTING HOLES WRONGLY DRILLED AT FR 63A, STGR 27 RT. THE FRAME WAS REPAIRED AS PER SRM 53-17-13 FIG 203.SDR DL75E090684Frame · dentedAFT CARGO FS 1480 S26L-25L FRAME UPPER FLANGE DENTED AT SAA - SAT ON N/R 129452 JOB 8259850001.SDR DL75E090683Frame · bentFRAME BENT DENTED IN AFT CARGO AT STA 1400 ABOVE STR 26L AT SAA - SAT ON N/R 126358 JOB 8259770001.SDR DL75E090681Frame · dentedAFT CARGO FS 1440 S26L FRAME UPPER FLANGE DENTED. C/W AT SAA, SAT ON N/R 129450 JOB 82598480001.SDR DLM88090678Frame · corrodedLOWER HORIZONTAL FACING FLANGE OF FRAME AT STATION 1060 AND LONGERON 30R WAS FOUND CORRODED. TEMPORARY REPAIR INSTALLED PER ERA 473482-14 DUE TO NO AVAIL OF PART. PART WAS BLENDED AND HFEC INSPECTED, TREATED AND FRAME TO LONGERON FASTENERS REINSTALLED ON AARSDR QXEA2009042000270Frame · corrodedCORROSION ON FRAME AT FS 310.00 AROUND MULTIPLE RIVETS BETWEEN STRINGERS 27 AND 26R. REMOVED 7 SOLID RIVETS AT FS 310.00 BETWEEN STRINGERS 27 AND 26R TO GAIN ACCESS TO CORROSION. REMOVED MODERATE CORROSION REF SRM 51-21-06 PG 4 PARA 3D(1) AND (2). UT THICKNSDR GLBA20090420GFrame · crackedDURING A SCHEDULED STRUCTURAL CHECK, MX DISCOVERED A CRACK ON THE RT HEAVY ANGLE AT FA 288.0. LENGTH OF CRACK APPROX 1.5 INCH LONG.
MX REPAIRED THE RT HEAVY ANGLE AT FA 288.0. IAW. EO-09-1900-53-003. REPAIR AREA APPROXIMATELY 13.5 INCH LONG OUT OF PN 114-430SDR SWAA092479Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 616, RBL 64 BETWEEN WL 210 TO WL 202. REPAIRED FRAME PER ER.SDR SWAA092470Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME WEB CRACKED AT BS 303, STR 16L. REPAIRED WEB PER ACO.SDR ASAA0945432Frame · crackedL2 DOOR STUB FRAME CRACKED AT STA 954 FOUND DURING OPEN UP FOR SKIN REPAIR. REMOVED DAMAGED SECTION OF FRAME, FABRICATED, LOCATED, DRILLED, INSTALLED REPAIR ANGLE IAW B737 400 SRM 51 40 02.SDR AALA20090424TUL48Frame · crackedOVERWING FRAME CRACKED RIGHT SIDE AT STATION 886. REPLACED FRAME PER DRAWING SRO9530282.SDR UALA2009041601099Failsafe · corrodedAFT PIT BS 1562 FAIL SAFE CHORD CORRODED AT BL 0. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED AREA AND INSTALLED DOUBLER AND FILLER REPAIR.SDR ASAA0995128Frame · corrodedAFT CARGO FRAME CORROSION BS 727H RBL 20 22 WL 156. REPAIRED PER ATS ER 09 2320.SDR ASAA0995127Frame · corrodedAFT CARGO FRAME CORROSION BS 727G RBL 20 22 WL 156. REPAIRED PER ATS ER 09 2320.SDR ASAA0995126Frame · corrodedAFT CARGO FRAME CORROSION BS 727E RBL 20 22 WL 156. REPAIRED PER ATS ER 09 2320.SDR ASAA0995125Frame · corrodedAFT CARGO FRAME CORROSION BS 727F RBL 20 22 WL 156. REPAIRED PER ATS ER 09 2320.SDR ASAA0995124Frame · corrodedAFT CARGO FRAME CORROSION BS 747 RBL 20 22 WL 156. REPAIRED PER ATS ER 09 2320.SDR ASAA0995123Frame · corrodedAFT CARGO FRAME CORROSION BS 727K RBL 20 22 WL 156. REPAIRED PER ATS ER 09 2320.SDR ASAA0995122Frame · corrodedAFT CARGO FRAME CORROSION BS 727L RBL 20 22 WL 156. REPAIRED PER ATS ER 09 2320.SDR AALA20090415TUL04Frame · crackedSTATION 1485 CANTED FRAME WEB IS CRACKED AT UPPER HI-LOK IN THE LOUVER BOX ANGLE JUST OUTBOARD OF THE EMERGENCY LIGHT ASSEMBLY. INSTALLED DOUBLER PER AARD 53-10-00-32.SDR AALA20090427TUL09Frame · crackedCABIN FRAME CRACKED AT AIR CONDITIONING BRACKET ATTACH FITTING AT STATION 500 RIGHT AT INNER FASTENER. INSTALLED REPAIR DOUBLER PER J1159AB.SDR AALA20090427TUL08Frame · crackedCABIN FRAME CRACKED AT AIR CONDITIONING BRACKET ATTACH FITTING AT STATION 480R AT INNER FASTENER. INSTALLED REPAIR DOUBLER PER J1159AB.SDR AALA20090427TUL07Frame · crackedCABIN FRAME CRACKED AT AIR CONDITIONING BRACKET ATTACH FITTING AT STATION 440 RIGHT AT INNER FASTENER. INSTALLED REPAIR DOUBLER PER J1159AB.SDR AALA20090427TUL06Frame · crackedCABIN FRAME CRACKED AT AIR CONDITIONING RAIL BRACKET ATTACHMENT INBOARD FASTENER AT STATION 500C LEFT SIDE. INSTALLED REPAIR DOUBLER PER J1159AB.SDR AALA20090427TUL05Frame · crackedCABIN FRAME CRACKED IN AIR CONDITIONING RAIL ATTACHMENT INBOARD FASTENER STATION 440 LEFT. INSTALLED REPAIR DOUBLER PER J1159AB.SDR NWAA091299995Doubler · crackedFLIGHT ATTENDANT LOG BOOK INDICATED LEFT OVERWING EXIT HANDLE SLOWLY POPS OUT. MAINTENANCE REMOVED LEFT OVERWING EXIT DOOR AND FOUND LOWER AIRCRAFT FRAME ASSEMBLY DOUBLER CRACKED AND WORN. ALSO, FOUND UPPER AIRCRAFT FRAME AND RECESSED RIVET HEAD WORN AT THE SDR UALA2009041501090Frame · corrodedAFT CARGO COMPARTMENT FRAME T-CAP, LOWER SURFACE CORRODED AT NUT PLATE, BS 1197+132, RBL 45, S-33R. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGED T-CAP. INSTALLED NEW T-CAP.SDR SWAA092441Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA092440Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 360, STR 8L. REPAIRED FRAME PER SWA EA.SDR FDEA200904141298Frame · dentedCABIN, RT STA 735 LONGERON, 12 FRAME FOUND DENT. REPAIRED AS PER SRM 53-30-00 FIG. I VOL I REV 40. REPETITIVE INSPECTION REQUIRED, INITIAL AT 14,500 CYCLES AND REPETITIVE INSPECTION AT 9,500 CYCLES TO BE CARRIED OUT AS PER SRM 53-30-00 FIG I VOL I REV 40. RSDR FDEA200904141289Frame · crackedFUSELAGE LOWER LOBE FRAME AT BS 231.25, BL 0 GOUGED. GOUGE FOUND TO BE CRACKED AND OUT OF LIMITS IAW SRM 53-00-07. REMOVED DAMAGE SECTION FOR REPAIR IAW SRM 51-40-02. INSTALLED NEW REPAIR PARTS IAW SRM 51-70-11. CLASSIFIED AS CATEGORY "A" MAJOR REPAIR.SDR IPXA09555727Frame · dentedINSPECTION TYPE:C4 AFT CARGO COMPARTMENT RT FRAME IS DENTED AT BS 1280 RBL 32 WL 150. INSTALLED REPAIR DOUBLER IAW EO B757-5310-33317A.SDR IPXA09555726Frame · dentedINSPECTION TYPE:C4 AFT CARGO COMPARTMENT RT FRAME IS DENTED AT BS 1300 RBL 34 WL 149. INSTALLED REPAIR DOUBLER IAW EO B757-5310-33307A.SDR IPXA09555693Frame · dentedINSPECTION TYPE:C4 BULK CARGO COMPARTMENT LT FRAME IS DENTED AT BS 1480 LBL 35 WL 153. REPAIRED FRAME PER SRM 53-00-07-2R5.SDR ASAA0995108Frame · corrodedFOUND CORROSION ON AFT FACE OF FRAME AT BS 500I STR 25L. CUT OUT DAMAGED AREA AND REPAIRED.
Back to JASC 5311