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 SWAA086297Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086296Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086295Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086294Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086291Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086290Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWIA200821021Frame · crackedC-CHECK, LEFT INBOARD FRAME 10 WEB CRACKED, LEFT WHEEL WELL. REPAIRED PER SRM.SDR USAA920082088Frame · crackedCLT Q2 MAJOR REPAIR NR 03C10753039/005 FRAME CRACKED AT PSU RAIL ATTACH POINT BS 500C, BETWEEN S8L AND S9L. REPAIRED FRAME AT PSU RAIL ATTACH POINT BS 500C, BETWEEN S8L AND S9L IAW TYPICAL REPAIR NR 53-10-20E.SDR USAA920082087Frame · crackedCLT Q2 MAJOR REPAIR NR 03C10753039/006 FRAME CRACKED AT PSU RAIL ATTACH POINT BS 727B, BETWEEN S8R AND S9R. REPAIRED FRAME AT PSU RAIL ATTACH POINT BS 727B, BETWEEN S8R AND S9R IAW TYPICAL REPAIR NR 53-10-20E..SDR USAA920082086Frame · crackedCLT Q2 MAJOR REPAIR NR 03C10753039/007 FRAME CRACKED AT PSU RAIL ATTACH POINT BS727D, BETWEEN S8R AND S9R. REPAIRED FRAME AT PSU RAIL ATTACH POINT BS727D, BETWEEN S8R AND S9R IAW TYPICAL REPAIR NR 53-10-20E.SDR AALA200810182Frame · crackedCANT FRAME CRACKED AT LOWER TAILCONE ALIGNMENT PIN, STATION 1510, LEFT. REPAIRED PER ESO80559 DATED 11-17-08.SDR DL757081582Frame · gougedDURING HMV, TWO GOUGES WERE FOUND IN THE WEB OF THE STA 395 FRAME BETWEEN S11L AND S13L. A NEW FRAME SECTION WAS SPLICED IN BETWEEN S10L AND S11L PER BOEING REPAIR INSTRUCTIONS.SDR SWAA086260Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 727A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086259Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 400, BETWEEN STR 9R TO STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086258Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 480, BETWEEN STR 9R TO STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086257Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 747, BETWEEN STR 9R TO STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086256Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 907, BETWEEN STR 9R TO STR 8R. REPAIRED FRAME PER SWA EA.SDR USAA920082079Frame · crackedCLT Q2 MAJOR REPAIR NR 03C10753039/004 FRAME CRACKED AT PSU RAIL ATTACH POINT AT BS727D, BETWEEN S8L AND S9L. REPAIRED FRAME AT PSU RAIL ATTACH POINT AT BS727D, BETWEEN S8L AND S9L IAW US AIRWAYS TYPICAL REPAIR NR 53-10-20E.SDR SWIA200820542Frame · crackedVISUALLY INSPECTED THE LEFT AND RIGHT SIDE FRAMES AS REQUIRED BY AD 2008-06-10/01. BOTH SIDE FRAME DOUBLERS AT FS 640 INDICATE CRACKS. (AD INSP) REPAIRED PER SB 601R-53-065 REV B.SDR KCSA081584Frame · crackedAFT PIT FLOORBEAM (FRAME) CRACKED AT CUTOUT AT BS 2080, LBL 24.SDR KCSA081583Frame · crackedAFT PIT FLOORBEAM (FRAME) CRACKED AT CUTOUT AT BS 1960, LBL 22.SDR AALA200810284Frame · corrodedCORROSION ON FRAME. INSTALLED FRAME SPLICE REPAIR PER SRM 53-03-00.SDR AALA200810180Frame · crackedFRAME AT STATION 1418 CRACKED AT LONGERON 2L. REPAIRED PER ESO80559 DATED 11-14-08.SDR COEA0803903Frame · corrodedMAJOR REPAIR & LEVEL 2 CORROSION. LT LOWER FRAME 24 SEGMENT IS CORRODED BELOW RECIRCULATION DUCT SUPPORT. S/D CUT THE FRAME ASSY WITH A STEPPED CUT FROM STRINGER 16L TO 16R AND FROM STRINGER 17L TO 17R. SPLICED IN NEW FRAME ASSEMBLY WITH SPLICES AT STRINGSDR AALA200810411Frame · crackedSTATION 500A LEFT, FRAME CRACKED AT AIR CONDITIONING RAIL ATTACH POINT. REPAIRED PER ECO J1159AA.SDR AALA200810410Frame · crackedSTATION 480 LEFT, FRAME CRACKED AT AIR CONDITIONING RAIL ATTACH POINT. REPAIRED PER ECO J1159AA.SDR AALA200810409Frame · crackedSTATION 500C LEFT, FRAME CRACKED AT AIRCONDITIONING RAIL ATTACH POINT. REPAIRED PER ECO J1159AA.SDR AALA200810408Frame · crackedSTATION 500A RIGHT, FRAME CRACKED AT AIRCONDITIONING RAIL ATTACH POINT. REPAIRED PER ECO J1159AA.SDR AALA200810406Frame · crackedSTATION 480 RIGHT, FRAME CRACKED AT AIRCONDITIONING RAIL ATTACH POINT. REPAIRED PER ECO J1159AA.SDR AALA200810405Frame · crackedSTATION 440 RIGHT, FRAME CRACKED AT AIRCONDITIONING RAIL ATTACH POINT. REPAIRED PER ECO J1159AA.SDR AALA200810404Frame · crackedSTATION 400 RIGHT, FRAME CRACKED AT AIRCONDITIONING RAIL ATTACH POINT. REPAIRED PER ECO J1159AA.SDR AALA200810176Frame · chafedAFT ACCESSORY AREA, FRAME 1361 HAS HOLE FROM BRAIDED LINE CHAFING AT LONGERON 19L. INSTALLED SPLICE REPAIR PER SRM 53-03-00.SDR UALA2008111706524Frame · damagedAFT PIT FRAME UPPER FLANGE DENTED BETWEEN STR 26L AND 25L AT STA 1460. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION OF PIT FRAME AND INSTALLED DOUBLER REPAIR. THIS ALSO INCLUDES DAMAGE NEAR STR 26L-25L. REPAIRED WITH SMC022.SDR UALA2008111706523Frame · dentedAFT PIT FRAME DENTED STA 1460, STR 25L TO 24L. MAJOR REPAIR ACCOMPLISHED. CUTOUT DAMAGED SECTION OF PIT FRAME AND INSTALLED DOUBLER REPAIR. THIS ALSO INCLUDES DAMAGE NEAR STR 26L-25L.SDR DHLA2008745690Frame · crackedFUSELAGE FRAME AT BS 188, OTBD CHORD CRACKED AT WL 208 AND LBL 36. REMOVED, FABRICATED, AND INSTALLED FRAME OTBD CHORD AND WEB SECTION PER SRM 51-10-1, 51-20-1, AND 51-30-2. DOCUMENTED ON N/R 2-387.SDR ASOA200801506Frame · crackedRT BS 210 FRAME CRACKED. REMOVE FRAME AND INSTALLED NEW FRAME P/N 600-34011-1 PER SRM 51-42-06.SDR CALA0801076Frame · crackedBS 360 LEFT SIDE FRAME CRACKED AT AIR CONDITIONING (AC) RAIL BRACKET BETWEEN STR 8L AND STR 9L. ACCOMPLISHED EA 5310-04498 ON BS 360 LEFT FRAME AT STR 8L AND STR 9L. ACCOMPLISHED EC/RA 5310-04867 ON CLIP REPLACEMENT AT BS 360 AT STR 8L.SDR AALA200810278Frame · wornWORN AREA ON FORWARD SIDE LEFT 1380 FRAME. REMOVED DAMAGE AND INSTALLED DOUBLER.SDR CALA0801074Frame · crackedR-1 DOOR STUB FRAME AT STATION 294.5 IS CRACKED JUST ABOVE CREASE BEAM WEB. REPAIRED CRACK PER ECRA 5311-01433.SDR 08FDEA04870Frame · corrodedFUSELAGE UPPER LOBE INTERIOR STRUCTURE CORROSION AT STA 600 RBL 51 "I" FRAME BOTTOM FLANGE. REPAIRED FRAME IAW EA 7-5310-123811 SEE JPF FOR PARTIAL WORK ACCOMPLISHED, REPAIR CLASSIFIED AS MAJOR.SDR SWAA086242Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, BETWEEN STR 9R TO STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086241Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, BETWEEN STR 9R TO STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086222Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086221Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086220Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086212Frame · crackedDURING SCHEDULED SPV CHECK, FOUND STUB FRAME CRACKED AT BS 639, LBL 45, WL, 206. REPAIRED STUB FRAME PER SRM.SDR DHLA2008743520Frame · damagedD-CHECK, WO NR 5740 NR 5740-2-299, UPPER FUSELAGE PAX CABIN AT BS 1010 BETWEEN STR 16R AND 17R FRAME WEB WITH DOUBLE HOLE. REPAIRED FUSELAGE FRAME SECTION AT BS 1010 BETWEEN STR 16R AND 17R DUE TO DOUBLE HOLE IAW SRM 51-40-3 FIG.1.SDR FDEA200811124867Frame · damagedAFTER REMOVAL OF DOUBLER FROM TV MONITOR SPT AT BS 395, S-3L - S-3R, FOUND SEVERAL HOLES ON FRAME. COMPLIED WITH EA 757-2550-16-F1312, REV E, FRAME ALTERATION BS 395, B/T S-3L - S-3R. REMOVED SHEAR TIES AND STRINGER CLIPS PER EA STEP 2A1. REMOVED DAMAGE PSDR AALA200810179Frame · crackedFRAME AT STATION 1418 AT 2R FORWARD SIDE CRACKED. REPAIRED PER ESO80559 DATED 11-11-08SDR AALA200810178Frame · crackedFRAME AT STATION 1418 AT LONGERON 2R AFT SIDE CRACKED. REPAIRED FRAME PER ESO80559 DATED 11-11-08.
Back to JASC 5311