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 ASAA0945731Frame · dentedFRAME DENTED ON INBD CROWN FLANGE. REMOVED DENT FROM FRAME FABRICATED REPAIR PARTS AND INSTALLED.SDR UALA2009052701520Failsafe · corrodedAFT CARGO PIT STATION 1562 FAIL SAFE CHORD CORRODED AT BL 0. MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGED SECTION OF FAIL SAFE CORD. FABRICATED & INSTALLED REPAIR ANGLE DOUBLER AND FILLER.SDR SWAA093410Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 360, STR 20R. R&R CLIP PER SRM.SDR SWAA093406Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 360, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA093402Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500B, STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA093407Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 597, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA093408Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 767, STR 8R. REPAIRED FRAME PER SWA EA.SDR AALA20090605TUL16Frame · crackedTHE 1510 CANT FRAME CRACKED AT LOWER RIGHT HAND TAIL CONE ALIGNMENT. INSTALLED DOUBLER PER SRM 53-01-00 FIG 2 SHEET 3.SDR ASAA0995759Structure · corrodedBS 270 FRAME LOWER FLANGE HAS CORROSION. REMOVED AND REPLACED FRAME PER SRM.SDR ZZDA2009163Frame · damagedEO 17-5310-2937 AFT LEFT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 2 CONDITION 5. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, LEFT SIDE IAW AIRTRAN TASK CARD 17-5310-2980.SDR ZZDA2009162Frame · damagedEO 17-5310-2895 AFT RIGHT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 2 CONDITION 5. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, RIGHT SIDE IAW AIRTRAN TASK CARD 17-5310-2990.SDR C2XA09SH169Frame · damagedSHV - DURING C-CHECK FRAME 10 JUST ABOVE STRINGER 10L WAS CRACKED AND PIECE MISSING. MAINTENANCE REMOVED AND REPLACED FRAME 10 STRINGER 10L IAW SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA09SH168Frame · damagedSHV - DURING C-CHECK RT CARGO FRAME 64 HAD A DAMAGED RIVET BETWEEN STRINGER 8R-9R. MAINTENANCE REPAIRED FRAME 64 STRINGER 8R-9R WITH REPAIR IAW IC2009-145/03545. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR ZZDA2009161Frame · damagedEO 17-5310-2937 AFT LEFT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 1 CONDITION 1. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, LEFT SIDE IAW AIRTRAN TASK CARD 17-5310-2973.SDR ZZDA2009160Frame · damagedEO 17-5310-2895 AFT RIGHT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 2 CONDITION 2. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, RIGHT SIDE IAW AIRTRAN TASK CARD 17-5310-2987.SDR FDEA200905221772Frame · dentedAFT CARGO COMPARTMENT FRAME IS DENTED IN UPPER FLANGE AT BS 950C ABOVE STR 26R. REWORKED DENTED AREA TO ORIGINAL CONTOUR. ABOVE STR 26R IAW DWG SR 27-53-139. NDT INSPECTED AREA WITH NO DEFECTED NOTED. FRAME THICKNESS FOUND TO BE .071 IAW SRM 53-10-2 FIG 5.SDR FDEA200905221771Frame · dentedAFT CARGO COMPARTMENT FRAME IS DENTED IN UPPER FLANGE RADIUS AT BS 990 ABOVE STR. 26L. REWORKED DENTED AREA TO ORIGINAL CONTOUR AT BS 990 STR 26L IAW DWG SR 27-53-139. NDT INSPECTED AREA WITH NO DEFECT NOTED IAW NDTM 51-00-00 FIG 23 PART 6. FRAME THICKNESS FSDR USAA2009060191370Frame · crackedCLT - C4 - MAJOR REPAIR - NR 19T25053012/004 - CRACK ON FUSELAGE FRAME AT BS1580 BETWEEN S26R TO S27R. REPAIRED FUSELAGE FRAME AT BS1580 BETWEEN S26R TO S27R IAW US AIRWAYS EA 101150 & BOEING DRAWING 146N454.SDR ASAA0995710Frame · damagedELONGATED HOLE BS 500L LBL21 TOP OF FRAME. REPAIRED FRAME.SDR SWAA093357Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED BS 500C, STR 13R. REPAIRED FRAME PER SWA EA.SDR FDEA200905211769Frame · crackedBS 377 STR 2R FRAME CRACKED, REMOVED DAMAGED FRAME IAW SRM 51-40-02. FABRICATED NEW FRAME AND INSTALLED IAW SRM 51-40-20 AND SRM 53-00-07, FIG 201. CAT."A", MAJOR REPAIR.SDR SWAA093341Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 559, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER EA.SDR SWAA093304Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 559, STR 13R. REPAIRED FRAME PER AAR EA.SDR SWAA093301Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 727, BETWEEN STR 13L TO STR 14L. REPAIRED FRAME PER AAR EA.SDR 2PSASDR7670901Failsafe · crackedON 5-13-09 AT 1600 HRS. NOTIFIED THAT WHILE COMPLYING WITH SB 767-53A0100 IAW AD 2004-19-06: ULTRASONIC TESTING OF THE LT AND RT STA 955 REAR BULKHEAD SIDE FITTING FAIL-SAFE STRAPS SHOWED POSSIBLE CRACKING OF BOTH FAIL-SAFE STRAPS AND RECEIVING THE NDT REPORT SDR AALA20090521TUL26Frame · crackedCABIN, HHEC INDICATED CRACK AT STATION 400 RIGHT FRAME RAIL SUPPORT. INSTALLED FRAME REPAIR PER ECO J1159ABSDR SWAA093285Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 294.5, STR 14R. REPAIRED FRAME PER SRM.SDR SWAA093261Frame Splice · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME SPLICE CRACKED AT BS 727E, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SWA EA.SDR SWAA093260Frame Splice · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME SPLICE CRACKED AT BS 520, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SWA EA.SDR SWAA093259Frame Splice · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME SPLICE CRACKED AT BS 500B, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SWA EA.SDR SWAA093251Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 827, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA093246Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 303.9, STR 16L. REPAIRED FRAME PER ACO.SDR DL75E090887Frame · dentedAFT CARGO COMPT FRAME BS 1440 AT S26L DENTED/ C/W AT SAA - SAT ON N/R 107901 JOB 82841160001.SDR IPXA09556067Frame · damagedINSPECTION TYPE:C3 FRAME HAS SCREW STRIKE, BS 860, STR 5L AND 15L. REPAIRED FRAME PER SRM ADDENDUM B757-5310-19952-C APPENDIX A.SDR IPXA09556066Frame · damagedINSPECTION TYPE:C3 FRAME HAS SCREW STRIKE, BS 820, STR 5L AND 15L. REPAIRED FRAME PER SRM ADDENDUM B757-5310-19952-C APPENDIX A.SDR IPXA09556064Frame · damagedINSPECTION TYPE:C3 FRAME HAS SCREW STRIKE, BS 740, STR 5L AND 15L. REPAIRED FRAME PER SRM ADDENDUM B757-5310-19952-C APPENDIX A.SDR ASAA0945678Frame · crackedFRAME AT 727D STR 8R CRACKED AT FASTENER HOLE. REPAIRED FRAME.SDR ASAA0945647Frame · misrepairedFRAME AT 727D STR 8L HAS PREVIOUS REPAIR WITH DEVIATIONS. REMOVED EXISTING REPAIR, FABRICATED NEW REPAIR PARTS AND INSTALLED.SDR ASAA0945646Frame · misrepairedFRAME BS 727F STR 8R PREVIOUS REPAIR HAS DEVIATION. REMOVED PREVIOUS REPAIR PARTS AND INSTALLED.SDR IPXA09155912Frame · gougedGOUGE AT RT FUSELAGE FRAME 57.2 BELOW STR 36R. REPAIRED IAW EOA300-5330-33509-A.SDR DLM88090882Frame · crackedFRAME 1174 CRACKED AT LONGERON 5L. REPAIRED IAW 53-03D FIGURE 4.SDR ASOA200900569Frame · damagedWHILE PERFORMING EC/TC AWL2 53-41-201 FS 559.00, RECEIVED A SUSPECT INDICATION UNDER BEAM AT LBL 18 FRAME CAP ANGLE RADIUS. PERFORMED EDDY CURRENT INSPECTION OF INDICATION AT 559 UNDER BEAM AT LBL 18 IAW NDTM 51-20-06. REMOVED AND REINSTALLED REQUIRED COMPONESDR ASAA0995664Frame · damagedFRAME BS 500K LT HAS OVERSIZED HOLE AT CARGO FLOOR TO SIDEWALL. REPAIRED FRAME.SDR ASAA0995663Frame · damagedBS 500F FRAME RT HAS AN OVERSIZED HOLE AT CARGO FLOOR TO SIDEWALL. REPAIRED FRAME.SDR ASAA0995662Frame · damagedBS 500D FRAME RT HAS OVERSIZED HOLE AT CARGO FLOOR TO SIDEWALL. REPAIRED FRAME.SDR ASAA0995660Frame · damagedBS 500C RT FUSE FRAME HAS OVERSIZED HOLE AT FLOOR TO SIDEWALL SUPPORT. REPAIRED FRAME.SDR ASAA0995659Frame · damagedBS 500B RT FUSE FRAME HAS OVERSIZED HOLE AT FLOOR TO SIDEWALL SUPPORT. REPAIRED FRAME.SDR ASAA0945642Frame · crackedFRAME CRACKED AT INBD FASTENER HOLE STA 400 BETWEEN STR 8R AND 9R. REPAIRED PER SRM.SDR KCSA091044Frame · bentSTA 1120 FUSELAGE FRAME OUTER FLANGE IS BENT BETWEEN STR 3R AND 4R.SDR FDEA200905151672Frame · damagedFRAME 47 NDT INSPECTION REVEALS INDICATION AT HOLE " S " LT SIDE. REAMED HOLE " S ", TO A FINAL SIZE OF.6532 " AND INSTALLED FASTENER . IAW EA 6-5710-127960.
Back to JASC 5311