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 DALA1204479020Frame · corrodedAFT CARGO FRAME STA 1287 FRAME DOUBLER FROM 26R TO 26L CORROSION.SDR ASOA201200216Frame · corrodedAFT FACE OF FRAME, UNDER AVIONICS FLOORBOARD AT FS 319.70 APPEARS TO HAVE CORROSION UNDER PAINT.SDR ASOA201200210Frame · corrodedFWD FACE OF FRAME, UNDER AVIONICS FLOORBOARD AT FS 349.0. APPEARS TO HAVE CORROSION UNDER PAINT. (CLOSED)SDR ASOA201200194Frame · corrodedCORROSION FOUND ON FRAME AT FS 310 FROM S25R - 25L. REPAIRED IAW REO 670-53-21-790.SDR ASOA201200192Frame · corrodedMAIN AVIONICS COMPARTMENT FRAME BS 333 BETWEEN S25 AND 26R CORRODED. REMOVED CORROSION IAW SRM 51-21-06-001-001-A01. NO DAMAGE ALLOWED IAW SRM FIG 53-21-06-991-840 AND 53-21-06-991-841. REPAIRED IAW REO 670-53-21-800.SDR SWAA120416Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 727E, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA120397Angle · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME INNER CHORD ANGLE CRACKED AT BS 639, LBL 64. REPAIRED CHORD IAW EA.SDR FDEA201201180235Frame · damagedCABIN BS 1540, STR 3L TO STR 4L ELONGATED HOLE IN FRAME. FRAME R & R IAW SRM 53-00-07, REPAIR 3 FIG 201, REV 105. REPAIR IS CLASSIFIED AS MAJOR.SDR FDEA201201180234Frame · chafedAFT LWR CARGO BAY FRAME AT BS 1320, HAS CHAFE MARK ON UPPER FLANGE BETWEEN STRINGERS 26--27L. REPAIRED IAW EA F-5310-153473, PART 1. REPAIR IS CLASSIFIED AS MAJOR.SDR FDEA201201180233Frame · gougedAFT LWR CARGO COMP, FRAME AT STA 1480, HAS 1 EA GOUGE MARK ON FRAME UPPER SURFACE BETWEEN STRINGERS S25 & 26R. REPAIRED IAW EA F-5310-153498. REPAIR IS CLASSIFIED AS MAJOR.SDR CALA2012011800033Frame · crackedREF EA 5310-04716 REV C BRACKET AT FRAME 727B RIGHT INBD RIVET HOLE CRACKED. STA 727 RIGHT FRAME BETWEEN STR 8 AND 9 R HAS BEEN REPAIRED PER EA 5310-04716 REV C FIG 3.SDR CALA2012011800032Frame · crackedSUPPORT TASK REF ES 5310-04716 BRACKET AT FRAME 480R INBOARD RIVET HOLE CRACKED. INSTALLED REPAIR AT FRAME 480R BETWEEN STR 8 & 9 IAW EA 5310-04 716 SEE ATTACHED FORM 44.0008 FOR ALL WORK PERFORMED.SDR DALA13070055643Frame · corrodedDURING CHECK, CORROSION WAS FOUND COMMON TO BS 1380 FRAME WEB AT STRINGER 25R. CORRODED FRAME WEB WAS REPAIRED IAW SECTION I OF ER/A 499039-14.SDR A6WA201240308Frame · gougedFRAME FS 499 HAS GOUGES AT STR 5 RT. HAND BLENDED GOUGES AT FS 499 AT STR 5R FOUND TO BE WITHIN LIMITS ORIGINAL .050 REMOVED, .004 REMAINING .0146 USING THICKNESS TESTER IAW SRM 51-12-00, 53-41-15, 51-21-11 AND 51-25-06.SDR A6WA201240069Frame · dentedFRAME FS 672.20 DENTED. REPAIRED DENT ON FRAME FS 672.20 IAW REO 601R-53-61-4353.SDR UALA2012011800370Frame · corrodedAFT PIT FRAME HAS CORROSION BS 1500, STR 30 & STR 29L. MAJOR REPAIR ACCOMPLISHED. RMV'D CORROSION ON FAIL SAFE & FOUND MATERIAL REMAINING AFTER BLEND-OUT TO BE .071\ FROM AN ORIGINAL .080\. RMV'D FAILSAFE CHORD, AND SPLICED IN REPAIR WITH 2 NEWLY FABRICATEDSDR AALA20120117TUL08Frame · crackedTHE 1418 FRAME CRACKED AT LONGERON 2 LEFT. INSTALLED REPAIR DOUBLERS PER SRM 53-03-0.SDR SWAA120386Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 947.5, STR 19L. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA120385Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 188, STR 17L. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA120382Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 747, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME IAW SRM EA.SDR DALA1204610696Frame · dentedIN FWD CARGO COMPT FRAME DENTED STA 540 AT 24L. DAMAGED OUT OF LIMITS, RECIEVED PRI 498896-14.SDR FDEA201201160201Floor Support · corrodedFWD FUSELAGE UPPER DECK FRAME 12A 18" LEFT OF CENTERLINE, FLOOR SUPPORT HAS 2 SQ" OF CORROSION. AFTER REMOVAL OF LEVEL 1 COROSION FLOOR SUPPORT WAS FOUND TO BE OUT OF LIMITS IAW SRM 53-12-15. REMOVED AND REPLACED FLOOR SUPPORT IAW SRM 51-72-10 AND REPROTECTEDSDR ASAA12410967Frame · crackedFRAME AT 500E RIGHT IS CRACKED AT WIRE PENETRATION HOLE I/B SIDE. REPAIRED FRAME IAW 737 400 SRM 53 00 07 REP 13.SDR ASAA12410966Frame · crackedFRAME AT 500E IS CRACKED AT WIRE PENETRATION HOLE I/B SIDE. REPAIRED FRAME IAW 737 400 SRM 53 00 07 REP 13.SDR ASAA12410965Frame · crackedFRAME AT 500B LEFT IS CRACKED AT WIRE PENETRATION HOLE I/B SIDE. REPAIRED FRAME IAW B737 400 SRM 53 00 07 REP 13.SDR USAA2012012000006Strap · crackedC3 CHECK - CRACK IN FAIL SAFE STABILIZER STRAP AT BS 365.25, LBL 20. REPAIRED FAIL SAFE STABILIZER STRAP AT BS 365.25, LBL 20 IAW EA 103639.SDR ASOA201200171Frame · corrodedFWD FACE OF FRAME UNDER AVIONICS FLOORBOARD AT FS 349.00, APPEARS TO HAVE CORROSION UNDER PAINT.SDR IPXA2571165Frame · dentedINSPECTION TYPE:C-CK, AFT CARGO COMPARTMENT FRAME AT BS 1260 STR 26R IS DENTED. FABRICATED AND INSTALLED REINFORCING REPAIR IAW EA 120010 AND EO B757- 5310-45584-A FROM 7075 T6 .080" MATERIAL.SDR SWAA120367Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER EA.SDR SWAA120354Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER EA.SDR SWAA120345Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND STUB FRAME CRACKED AT BS 296, STR 17R. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA120337Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 16R. REPAIRED FRAME IAW SRM.SDR SWAA120315Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 727E, STR 23L. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR CALA2012011700028Frame · crackedFRAME BETWEEN S8-L AND S9- AT STA 440 L I/B RIVET CRACKED. C/W REPAIR PER EA 5310-04716.SDR CALA2012011700027Frame · crackedCABIN AREA BETWEEN S9 AND S8 CRACK FOUND AT FRAME LOCATION STA 380 RT SIDE. PER EA 5310-04716 REV C MFEC. REPAIRED FRAME W/REF TO EA 5310-04716 REV D.SDR AALA20120116TUL05Frame · damagedSTATION 986.5 FRAME DAMAGED AT TIE IN TO 986.5 FLOORBEAM. ACCOMPLISHED NESTED ANGEL REPAIR PER EA B737-53-021120.SDR DALA1215839202Frame · corrodedFOUND CORROSION AT AFT CARGO FRAME STA 1364 BETWEEN L30 AND L29R. REMOVED CORROSION AND OUT OF LIMITS PER MD 90 SRM 53-00-01. REMOVED DAMAGED AREA AND REPAIRED PER MD 90 SRM 53-10-02 VOL I.SDR SWAA120308Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO COMPARTMENT FRAME CORRODED AT BS 727B, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME IAW ER.SDR SWAA120306Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 520, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME IAW ER.SDR SWAA120295Angle · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT FRAME ANGLE CORRODED AT BS 767, BETWEEN STR 27L TO STR 26R. REPAIRED ANGLE IAW EO.SDR SWAA120291Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 482, BETWEEN STR 19L TO STR 23L. REPAIRED FRAME IAW EA.SDR SWAA120289Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 767, STR 23L. REMOVED AND REPLACED FRAME IAW EA AND ER.SDR SWAA120279Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 993.5, RBL 54. REPAIRED FRAME IAW EA AND ER.SDR ZZDA2012089Frame · corrodedFWD CARGO COMPARTMENT FRAME, STA 484, LONG 29L TO 29R, CORROSION. ACCOMPLISHED FRAME DOUBLER REPAIR PER B717 SRM 53-20-07.SDR UIEA2012012000020Frame · dentedDURING A D2/C1/A3 INSPECTION, DETECTED A MAJOR DENT ON THE FUSELAGE FRAME AT BS 1840, S-11R; CUT OUT THE DAMAGED PORTION OF THE FRAME, PERFORMED HFEC INSPECTION, FABRICATED REPAIR FRAME SEGMENT, HEAT TREATED TO T62 AFTER FORMING; FABRICATED OTHER REPAIR PARSDR DALA1201840192Strap · crackedFAIL SAFE STRAP-INSP (OPN 8701AD) ULTRASONIC INSP CARRIED OUT ON STA 955 FAIL SAFE STRAP (LT SIDE) & FOUND CRACK INDICATION NRC # 0015 RAISED TO REMOVED AFFECTED FASTENER & CONFIRM CRACK INDICATION AT 2 O`CLOCK & 8 O`CLOCK POSITION. BS 955 REAR SPAR BULKHEAD SDR ASOA20120114002Frame · corrodedFRAME 65 CORRODED UNDERNEATH CARGO DOOR LOWER SILL. REMOVED PREVIOUS "L" SHAPED DOUBLER. APPLIED FILL RESIN TO AREA. FABRICATED "L" SHAPED DOUBLER, DRILLED, ALODINED, PRIMED, & PAINTED INSTALLED REPAIR DOUBLER IAW EC5320-01494.SDR ASOA20120114001Frame · crackedFRAME 66 CRACKED AT LOWER CARGO DOOR CUTOUT. REMOVED CRACKED PORTION OF THE FRAME, FABRICATED NEW SPLICE REPAIR. DRILLED SPLICE REPAIR AND NEW PORTION OF OLD FRAME. ALODINED, PRIMED AND PAINTED. ACFT STILL IN C-CHECK.SDR DALA1204600696Frame · dentedAFT CARGO FRAME DENTED AND CORRODED STA 1500 LBL 10-13. FOUND DAMAGE TO BE OUT OF LIMITS PER B757 SRM 53-00-07. COMPLIED WITH ER/A 499653-14 REV ORIGINAL.SDR DALA1207590696Frame · dentedAFT CARGO FRAME DENTED STA 1420 ABOVE STR 25L & 26L, FOUND DAMAGE TO FLANGE OUT OF LIMITS. REMOVED DAMAGE, FABRICATED REPAIR AND INSTALLED IAW B757 SRM 53-00-07 DURING HMV.
Back to JASC 5311