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 SWAA112203Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 26L TO STR 27L. REMOVED AND REPLACED FRAME PER SRM AND BAC DWG.SDR SWAA112202Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 27L TO STR 27R. REMOVED AND REPLACED FRAME PER SRM AND BAC DWG.SDR SWAA112201Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 747, BETWEEN STR 26R TO STR 27R. REMOVED AND REPLACED FRAME PER SRM AND BAC DWG.SDR SWAA112200Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 727E, BETWEEN STR 27R TO STR 27L. REMOVED AND REPLACED FRAME PER SRM AND BAC DWG.SDR SWAA112190Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO FRAME CORRODED AT BS 747, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME PER SRM AND BAC DWG.SDR SWAA112188Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO FRAME CORRODED AT BS 727E, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME PER SRM AND BAC DWG.SDR SWAA112176Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER EA.SDR SWAA112175Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER EA.SDR SWAA112168Frame · corrodedDURING SCHEDULED 22Y CHECK, FOUND FRAME CORRODED AT BS 807, STR 25L. REPAIRED FRAME PER EO.SDR SWAA112167Frame · corrodedDURING SCHEDULED 22Y CHECK, FOUND FRAME CORRODED AT BS 947.5, BETWEEN STR 25R TO STR 24R. REPAIRED FRAME PER EO.SDR SWAA112166Frame · corrodedDURING SCHEDULED 22Y CHECK, FOUND FRAME CORRODED AT BS 807, BETWEEN STR 25L TO STR 26L. REPAIRED FRAME PER EO.SDR CNMA20110015Frame · corrodedRIGHT FS 1270 FRAME CORRODED AT BASE. REMOVED CORROSION BLENDED AREA BEYOND LIMITS IAW SRM 53-00-15, FIG 101, PG 113, DETAIL XII. INSPECTED AREA IAW NDT PART 4 51-00-10, FOUND THICKNESS AROUND BLEND TO BE .175 . REPAIRED AREA IAW EO B7653-04.SDR DALA1124469224Frame · crackedHMV2 LT MLG W/W CUTOUT FWD FRAME I/B CORNER CORRODED AND CRACKED. REPLACED FRAME PER SRM 51-30-05.SDR SWAA112331Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER EA.SDR DALA1122489878Frame · gougedAFT ACCESSORY CANTED FRAME STA 1339 LOWER AFT SIDE GOUGED. EVALUATED GOUGE ON LT CANTED FRAME. FOUND TO BE OUT OF LIMITS IAW DC9 SRM 53-01 PG 8. GAINED ACCESS, REMOVED & REPLACED LT CANTED FRAME IAW DC9 SRM 51-30-2 & 51-30-05. NEW FRAME PT 9911843-6.SDR DALA1122469878Frame · gougedAFT ACCESSORY RT SIDE CANTED FRAME STA 1339 GOUGED AT LOWER AFT SIDE. EVALUATED GOUGE RT CANTED FRAME. FOUND TO BE OUT OF LIMITS IAW DC9 SRM 53-01 PG 8. GAINED ACCESS. REMOVED AND REPLACED RT CANTED FRAME IAW DC9 SRM 51-30-02, 51-30-5. NEW FRAME PT 99118SDR CALA2011032800202Frame · crackedSUPPORT TASK - CABIN AREA FRAME AT RT STA 480 CRACK INDICATION NOTED AROUND INBD FASTENER AND BETWEEN STR 8 AND STR 9. REPAIRED DAMAGE IAW EA 5310-04716 REV B OP 2.SDR UIEA2011032500165Frame · crackedDURING D INSPECTION OF DATUM ACFT IAW EO 4453A197, CRACK WAS FOUND ON FRAME AT BS 1160 (RT AT STR 9). (THE DAMAGED FRAME WAS REPAIRED IAW PART 5 OF EO 4453A197, REV D (SRM 53-40-07, REPAIR 3). IAW PART 5 OF EO, THE FRAME CRACKS THAT CANNOT BE REMOVED BY DOINSDR CALA2011032500184Frame · crackedSUPPORT TASK FRAME CRACKED STA 500E LT STR 8- STR 9. REPAIRED FRAME IAW EA 5310-04716 REV B OP 2 AND FIG 3.SDR CALA2011032500183Frame · crackedSUPPORT TASK REF STEP 6 EA 5310-04716 REV B OP 2 STA 500F LT FRAME CRACKED AT A/C BRACKET BETWEEN STR 8 AND 9. REPAIRED FRAME PER EA 5310-04716 REV B OP 2 AND STEP 9 W/ FIG 3.SDR DALA1130880623Frame · dentedFWD CARGO FRAME DENTED STA 580 BETWEEN STR 24 & 25L / ACCOMPLISHED ERA PER SRM 53-00-07 REPAIR 5 FIG 201 TABLE II.SDR DALA1130870623Frame · damagedFWD CARGO FRAME UPPER FLANGE DENTED AND BENT STA 600 BETWEEN STR 23 & 24L / ACCOMPLISHED ERA PER SRM 53-00-07 REPAIR 5 FIG 201 TABLE II.SDR ASOA201100602Frame · corrodedFWD SIDE FRAME 319.00 CORRODED ON VERTICAL AND HORIZ LEGS ON STR 26R. OUT OF LIMITS IAW 53-21-06-101-002-A01. CORROSION PENETRATED 100 PERCENT OF THICKNESS REMOVED AND REPLACED FRAME IAW REO 670-53-21-671.SDR ASOA201100601Frame · corrodedFRAME AT 295 CORRODED ON AFT SIDE ON VERT AND HORIZ LEGS AT STR 27. OUT OF LIMITS IAW SRM 53-21-06-101-002-A01. REMOVED CORROSION IAW SRM 51-21-06-001-001-A01.SDR ASOA201100600Frame · corrodedFRAME AT 333 BETWEEN STRINGERS 27 AND 26L CORRODED ON BOTH SIDES VERTICAL LEG AND ON HORIZ LEG.SDR ASOA201100599Frame · corrodedFRAME AT 333 BETWEEN STR 27 AND 26L CORRODED ON BOTH SIDES VERTICAL LEG AND ON HORIZONTAL LEG. FOUND OUT OF LIMITS IAW SRM 53-21-06-101-002-A01. REMOVED CORROSION IAW SRM 51-21-06-01-01.SDR ASOA201100592Frame · corrodedFS 349.00 FRAME CORRODED AT STR 27. REMOVED CORROSION IAW SRM 51-21-06. FOUND TO BE WITHIN LIMITS IAW SRM 51-21-06.SDR ASOA201100589Frame · corrodedFS 319.00 FRAME CORRODED BETWEEN STR 26L & 27. REMOVED CORROSION IAW SRM 51-21-06 WITHIN LIMITS IAW SRM 53-00-00.SDR ASOA201100584Frame · corrodedFS 295.00 FRAME CORRODED FROM OTBD SIDE OF STR 26L TO STR 27. REMOVED CORRSION IAW SRM 51-21-06. FOUND TO BE WITHIN LIMITS IAW SRM 51-21-06.SDR ASOA201100583Frame · corrodedFS 310.00 FRAME CORRODED FROM OTBD SIDE OF S25L TO JUST RT OF S27. REMOVED CORROSION IAW SRM 51-21-06 WITHIN LIMITS IAW SRM 53-00-00.SDR CALA2011032500187Frame · crackedSUPPORT TASK REF STEP 6 EA 5310-04716 REV B STATION 500 F RIGHT FRAME CRACKED AT AC BRACKET BETWEEN STR 8 AND 9. REPAIRED FRAME REF E/A 5310-04716 REV B STEP 9.0 AND FIG 3.SDR CALA2011032500186Frame · crackedSUPPORT TASK REF STEP 6 EA 5310-04716 REV B STATION 827 RIGHT FRAME CRACKED AT A/C BRACKET BETWEEN STRINGER 8-9. REPAIRED FRAME IAW EA 5310 04716 REV B STEP 9 AND FIG 3.SDR SWAA112130Frame · crackedDURING SCHEDULED OTS CHECK, FOUND FRAME WEB CRACKED AT BS 500D, RBL 7. REPAIRED FRAME PER EA.SDR SWAA112113Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500A, BETWEEN STR 28L TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA112112Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500B, BETWEEN STR 28R TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA112111Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500B, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME PER SRM.SDR SWAA112109Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 807, BETWEEN STR 25L TO STR 26L. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA112107Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 727E, BETWEEN STR 26L TO STR 27L. REMOVED AND REPLACED FRAME PER SRM AND BAC DWG.SDR SWAA112106Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 767, BETWEEN STR 27R TO STR 27L. REMOVED AND REPLACED FRAME PER SRM AND BAC DWG.SDR SWAA112105Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 767, BETWEEN STR 26L TO STR 27L. REMOVED AND REPLACED FRAME PER SRM AND BAC DWG.SDR AALA20110324TUL03Frame · corrodedCARGO AFT CORROSION FRAME 1271 AFT SIDE LONGERON 29 RIGHT TO LONGERON 28 LEFT. INSTALLED NEW "J" ANGLE REPAIR DOUBLER PER AARD 53-10-00-14.SDR CALA2011032400166Frame · crackedSUPPORT TASK CABIN AREA FRAME AT RT STA 500A CRACK INDICATION NOTED AROUND INBOARD FASTENER AND BETWEEN STR 8 TO STR 9. REPAIRED FRAME IAW EA 5310-04716 REV B OP 2 STEPS 9.0 AND FIG 3.SDR FDEA201103231182Frame · gougedMDC FRAME AT STA.310.5 AND STRINGER 4L, GOUGED. MAIN CARGO DECK FRAME AT STA 310.5 S-4L WAS REPAIRED IAW EA F-5310-146268. MAJOR REPAIRSDR FDEA201103231282Frame · damagedAFT CARGO COMPT FRAME HAS 2 DRILLED HOLES ON UPPER CHORD BEND RADIUS AT STA 1520, STR 26R. FUSELAGE STA 1520 LOWER LOBE FRAME REPAIR, REPAIRED ON EA F-5310-146389. MAJOR REPAIR.SDR FDEA201103231232Frame · misrepairedAFT CARGO COMPT FRAME HAS A IMPROPER REPAIR AT STA 1520, STR 26-L. REMOVED IMPROPER SPLICE ON STA 1520, S-26L IAW SRM 51-40-02, FABRICATED NEW SPLICE ON STAM TRAVELER NR T10/863349, LOCATED & DRILLED NEW SPLICE IAW SRM -53-00-07-3, INSTALLED NEW SPLICE IAW SSDR FDEA201103231504Frame · damagedFRAME STA 1640, RBL 63, WL 208 HAS INCOMING DAMAGE, 2 EA AREAS ON INBD J ANGLE, 2 EA GOUGES AND THE WEB HAS CUT. FRAME REPAIREDSDR FDEA201103231283Frame · gougedFRAME STA 1640, RBL63, WL208 HAS 2 EA AREAS OF DAMAGE INBD JANGLE HAS EEA GOUGES AND THE AFT FRAME WEB HAS CUT (INCOMING DAMAGE FOUND AFTER FLOORBEAM REMOVAL) THIS SDR WAS GENERATED IN ERROR. THE ABOVE DISCREPANCY IS CAPTURED ON THE FAA FORM 337, WHICH IS ISSUSDR USAA2011033191299Frame · crackedCLT - Q5/QX6 - CRACK ON FRAME WEB AT BS 291, S10L. REPAIRED FRAME WEB AT BS 291, S10L IAW EA 102738.SDR AALA20110323TUL09Frame · crackedTHE 1497 FRAME CRACKED BELOW LOUVER BOX. INSTALLED DOUBLER PER EA MD-80-53-015963.SDR AALA20110323TUL07Frame · crackedFRAME 1510 CRACKED AT LOCATION BELOW MAINTENANCE LIGHT SWITCH. INSTALLED DOUBLER PER SRM 53-03-00.
Back to JASC 5311