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 FDEA201004121142Frame · dentedCABIN - LT STA 1741, LONGERON 12 FRAME FOUND DENT. FRAME REPAIR IAW SRM 53-00-07, FIG 201, REPAIR 2, REV 43 (MAJOR REPAIR).SDR FDEA201004121141Frame · dentedCABIN - LT STA 1721 LONGERON 12 FRAME FOUND DENTED. FRAME REPAIR IAW SRM 53-00-07, FIG 201, REPAIR 2, REV 43 (MAJOR REPAIR).SDR FDEA201004121140Frame · dentedCABIN - LT STA 1701 LONGERON 12 FRAME FOUND DENT. FRAME REPAIR AS PER SRM 53-00-07 FIG 201 REPAIR 2 REV 43 (MAJOR REPAIR).SDR FDEA201004121139Frame · dentedCABIN - LT STA 1681, LONGERON 12, FRAME FOUND DENTED. FRAME REPAIR IAW SRM 53-00-07, FIG 201, REPAIR 2, REV 43 (MAJOR REPAIR).SDR FDEA201004121138Frame · dentedCABIN - RT STA 1721, LONGERON 12 FRAME FOUND DENTED. FRAME REPAIR IAW SRM 53-00-07, FIG 201. REPAIR 2 REV 43 (MAJOR REPAIR).SDR FDEA201004121137Frame · dentedCABIN - RT STA 1701, LONGERON 12 FRAME FOUND DENTED. FRAME REPAIR IAW SRM 53-00-07, FIG 201, REPAIR 2, REV 43 (MAJOR REPAIR).SDR FDEA201004121136Frame · dentedCABIN - RT STA 1681 LONGERON 12 FRAME FOUND DENTED. FRAME REPAIR IAW SRM 53-00-07, FIG 201, REPAIR 2, REV 43 (MAJOR REPAIR).SDR IPXA10559321Frame · gougedINSPECTION TYPE:C1 FRAME AT BS 393 HAS 2 EA GOUGED AREAS BETWEEN S-15R AND S-16R. REPAIRED GOUGED FRAME AT BS 393 IAW B757-5310-19952-D.SDR ASOA201000546Frame · corrodedFS 333 LOWER BELLY SECTION IS CORRODED. REMOVED BOTTOM FRAME SECTION AT FS 333 BETWEEN STR 23L AND 23R IAW SRM 51-42-06 AND 51-42-21. TEMPORARILY INSTALLED NEW FRAME SECTOR, LOCATED AND DRILLED, REMOVED AND DEBURRED IAW SRM 51-42-06. INSTALLED BOTTOM FRAME SSDR SWAA102127Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, BETWEEN STR 19R & 20R. REPAIRED FRAME PER SRM & EO.SDR SWAA102114Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE STUB FRAME CRACKED AT BS 277 RT SIDE. REPAIRED FRAME PER EO.SDR ASAA1047674Frame · corrodedR2 DOOR CUTOUT AFT JAMB LOWER FRAME CORRODED AT CREASE BEAM. CUT OUT DAMAGED SECTION OF FRAME AND SPLICED IN NEW.SDR AALA20100411TUL01Frame · wornFUSELAGE FRAME AT STATION 1041 RIGHT HAS DEEP WEAR 7 INCHES ABOVE CUSP AT FRAME FITTING. REPAIR WAS COMPLETED PER EAMD80-53-010080 AND SRM 51-70.SDR SWAA102075Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 500C, BETWEEN STR 19L TO STR 22L. REPAIRED FRAME PER SRM.SDR DL75E101264Frame · corrodedAFT CARGO FRAME CORRODED ON ALL SURFACED STA 1520, STR 26L TO 26R. COMPLIED WITH ER/A 482134-14, REF NON ROUTINE 153632.SDR DL75E101251Frame · corrodedAFT CARGO FRAME REPAIR CAP CORRODED STA 1600, STR 26R-24R. REPLACED FRAME REPAIR, REF NON ROUTINE 153612.SDR DLM88101135Frame · corrodedHMV3 AFT CARGO FLOOR FRAME STA 1268 L30 CORRODED. REPAIRED FRAME PER MD88 SRM 53-03 FIG 2A SHEET 1.SDR DALA107499867Frame · crackedDURING H-CHECK FOUND CRACK IN CANTED FRAME IN AFT ACCY AT BS 1339 JUST ABOVE LT LOWER TAIL CONE LATCH FRAME. REPAIRED IAW SRM 51-30-2, 51-30-5.SDR ASOA201000538Frame · corrodedAVIONICS COMPARTMENT FS 333.00 FRAME HAS CORROSION. REMOVED CORRODED FRAME AND LT VERTICAL POST AT FS 333.00, LOCATED FASTENER HOLES IN NEW FRAME IAW SRM 51-42-06, 51-42-21 AND 51-40-11. INSTALLED FRAME AT FS 333.00 FROM STR 23L - 23R AND VERTICAL POST AT STSDR EE4Y1004055Frame · damagedDURING THE INSPECTION UPPER FUSELAGE, CARGO CABIN, AT Y STA 332 BETWEEN LONG 6R AND LONG 7R COOPESA FOUND BENT AND DOUBLE HOLES.SDR AALA20100408TUL20Frame · crackedFRAME 440 LEFT CRACKED AT AIR CONDITIONING RAIL BRACKET INBOARD FASTENER HOLE. REPAIRED PER ECO J1159AC.SDR CALA2010041200129Beltframe · wornCABIN INTERIOR, BELT FRAME AT STA 1681 S11R HAS WEAR MARK FROM SIDEWALL PANEL ATTACH BRACKET. BLENDED OUT DAMAGE, INSTALLED A REPAIR DOUBLER AND INITIATED A DIP (53-DIP CONTROL NUMBER 004497) TO ACCOMPLISH A PERMANENT REPAIR WITHIN 24 MONTHS FROM APRIL 07 - 2SDR FDEA201004081110Frame · dentedMAIN DECK CARGO - RT STA 1741 LONGERON 12 RT, FRAME FOUND DENT. FRAME REPAIRED IAW SRM 53-00-07 FIG 201 REPAIR 2, REVISION 43. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV 110.SDR FDEA201004081109Frame · dentedMAIN DECK CARGO - RT STA 1701 LONGERON 12 RT, FRAME FOUND DENT. FRAME REPAIRED IAW SRM 53-00-07 FIG 201 REPAIR 2, REVISION 43. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV 110.SDR SWAA102034Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME CRACKED AT BS 482B, STR 1. REPAIRED FRAME PER SRM.SDR SWAA102010Frame · crackedDURING SCHEDULED OTS CHECK, FOUND FRAME CRACKED AT BS 1006, STR 22R. REPAIRED FRAME PER SRM.SDR SWAA101999Frame · crackedDURING SCHEDULED OTS CHECK, FOUND FRAME CRACKED AT BS 550D, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER ER.SDR SWAA101998Frame · crackedDURING SCHEDULED OTS CHECK, FOUND FRAME CRACKED AT BS 550B, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER ER.SDR SWAA101997Frame · crackedDURING SCHEDULED OTS CHECK, FOUND FRAME CRACKED AT BS 550D, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER ER.SDR SWAA101996Frame · crackedDURING SCHEDULED OTS CHECK, FOUND FRAME CRACKED AT BS 550C, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER ER.SDR SWAA101995Frame · crackedDURING SCHEDULED OTS CHECK, FOUND FRAME CRACKED AT BS 550B, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER ER.SDR SWAA101970Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 10R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA101969Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 296, STR 17R. REPAIRED FRAME PER SRM.SDR EE4Y1004054Frame · damagedDURING THE INSPECTION MAIN CARGO CABIN AT STA 256 BETWEEN LONG 11L AND LONG 15L FOUND FRAME WITH DOUBLE HOLES.SDR EE4Y1004053Frame · damagedDURING THE INSPECTION MAIN CARGO CABIN AT STA 427 BETWEEN LONG 4R AND LONG 14R COOPESA FOUND FRAME WITH DOUBLE HOLES IN SEVERAL PLACES.SDR EE4Y1004052Frame · damagedDURING THE INSPECTION MAIN CARGO CABIN AT STA 237 LONG 6R. FOUND FRAME WITH DOUBLE HOLE.SDR EE4Y1004051Frame · damagedDURING THE INSPECTION MAIN CARGO CABIN AT STA 218 BETWEEN LONG 7R AND LONG 8R COOPESA FOUND FRAME WITH DOUBLE HOLES.SDR EE4Y1004050Frame · damagedDURING THE INSPECTION MAIN CARGO CABIN AT STA 389 BETWEEN LONG 7R AND LONG 15R COOPESA FOUND FRAME WITH DOUBLE HOLES IN SEVERAL PLACES.SDR EE4Y1004049Frame · damagedDURING THE INSPECTION CARGO CABIN AT STA 408 BETWEEN LONG 6R AND LONG 8R COOPESA FOUND FRAME WITH DOUBLE HOLES.SDR EE4Y1004048Frame · damagedDURING THE INSPECTION CARGO CABIN AT STA 465, BETWEEN LONG 4L AND 5L COOPESA FOUND FRAME I/B FLANGE WITH DOUBLE HOLES.SDR EE4Y1004047Frame · damagedDURING THE INSPECTION UPPER PAX CABIN, AT Y STA 256, LEVEL LONG 5R COOPESA FOUND FRAME WITH DOUBLE HOLES.SDR EE4Y1004045AFrame · damagedDURING THE INSPECTION UPPER PAX CABIN, AT Y STA 256, LEVEL LONG 5R FOUND FRAME WITH DOUBLE HOLES.SDR AALA20100407TUL18Frame · crackedSTATION 480 FRAME CRACKED AT AIR CONDITIONING RAIL BRACKET ATTACHMENT INBOARD FASTENER HOLE. REPAIRED PER ECO J1159AC.SDR AALA20100407TUL17Frame · crackedSTATION 380 LEFT FRAME CRACKED AT AIR CONDITIONING RAIL BRACKET. ACCOMPLISHED DOUBLER REPAIR PER ECO J1159AC.SDR AALA20100407TUL04Frame · crackedSTATION 1418 FRAME CRACKED AT LONGERON 2 RIGHT. REPAIRED FRAME PER EA MD-80-53-010008 AT LONGERON 2 RIGHT.SDR DL757100976Frame · corrodedAFT CARGO BEAM PREVIOUS REPAIR ON CHORD HAS CORROSION ON UPPER SURFACE STA 1640, LBL 12. C/W ERA 480627, REV ORIG DURING HMV AT SAA IN SAT.SDR SWAA102033Frame · crackedDURING SCHEDULED MV1 CHECK, FOUND FRAME CRACKED AT BS 520, STR 14R. REPAIRED FRAME PER EA.SDR QXEA2010040900237Frame · corrodedC-CHECK - CORROSION FOUND ON FWD WEB SIDE OF FRAME 295.00 AROUND STGR 26R CUTOUT. REMOVED CORROSION IAW SRM 51-21-06-001-001-A01, BLENDS WITHIN LIMITS IAW SRM 53-21-06-101-002-A01. TREATED, PRIMED AND PAINTED IAW SRM 51-21-11-001-001-A01, 51-21-06-001-001-ASDR SWAA101952Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER EA.SDR SWAA101951Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER EA.
Back to JASC 5311