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 SWAA2013061817256Frame · crackedOVERWING FRAME CRACKED AT BS 715, BETWEEN LONG 9L TO LONG 18L. R&R LONGERON IAW MM.SDR DALA1314170682Frame · dentedAFT CARGO FRAME, BS 1340 S25-S26R, DENTED. REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 5, DETAIL 1.SDR USAA2013053100010Support · corrodedSY-6 CHECK-LEVEL 2 EXFOLIATION CORROSION ON FRAME SUPPORT BETWEEN FR69 TO FR70, S23R. REPLACED FRAME SUPPORT BETWEEN FR69 TO FR70, S23R IAW SRM 53-73-11 & 51-42-11.SDR DALA13026540991Frame · corrodedDURING SCHEDULED MX, CORROSION WAS FOUND IN THE AFT CARGO BAY ON FRAME AT BS 1271 FROM LONGERON 28L TO 28R. REPAIRED IAW SRM 53-03 FIG 2A.SDR FDEA201305291111Frame · chafedBS 1280, STR 11-12R FRAME INBD EDGE FOUND CHAFED. REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 3 REV 108. REPAIR IS CAT B MAJOR.SDR DALA1315270682Frame · dentedAFT CARGO FRAME BS 1520, S26L IS DENTED. REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 5.SDR DALA1315250682Frame · misrepairedAFT CARGO FRAME REPAIR BS 1400, STR 24-26L MISREPAIRED. REPLACED REPAIR ANGLE IAW SRM 53-00-07, FIG 201, REPAIR 5, DETAIL III.SDR SWAA2013061217082Frame · crackedOVERWING MAIN FRAME CRACKED AT BS 715, RBL 65. R & R FRAME IAW SRM AND DWG.SDR DALA1314360682Frame · dentedAFT CARGO FRAME, BS 1520, S26L, DENTED. REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 5.SDR DALA13026061402Frame · crackedBS 1809, BULKHEAD RT FWD OUTER CHORD CRACKED AT STR 7-8R, REPAIRED IAW SRM 53-80-08, REPAIR 9.SDR DALA13026051402Frame · crackedDURING HFEC INSPECTION ON BS 1809 BULKHEAD LT FWD OUTER CHORD AT STR 6L TO 7L FOUND CRACKED. REPAIRED SRM 53-80-08, REPAIR 9, REV 92.00.SDR AALA20130528014Frame · crackedLOWER RT TAILCONE CANT FRAME AT STA 1510 CRACKED AROUND ALIGNMENT PIN. INSTALLED DOUBLER IAW SRM 53-01-00 AND SRM 51-30-05.SDR GLBA2013052800253Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION, FOUND A CRACK IN THE FUSELAGE FRAME AT FS 177.35 IN THE BEND RADIUS, 1" LENGTH. REPAIRED IAW EO 13-1900-53-043. MAJOR REPAIR.SDR GLBA2013052800252Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION, FOUND 2 CRACKS AT THE CARGO DOOR FUSELAGE FRAME AT FS 509 BETWEEN STRINGER 4L & 5L, LOCATED IN THE BEND RADIUS OF THE FRAME, 1" IN LENGTH. REPAIRED IAW EO 13-1900-53-042. MAJOR REPAIR.SDR SWAA2013070817999Frame · crackedFRAME CRACKED AT BS 947.5, BETWEEN STRINGER 24R & STRINGER 25R. REPAIRED FRAME IAW EO & EA.SDR DALA13026350126Frame · crackedFRAME CRACKED. REPAIRED IAW ER/A 513104-14AD, REV ORIG.SDR DALA13026340126Frame · crackedBS 859.5 FRAME CRACKED. REPAIR ACCOMPLISHED IAW ER/A 513105-14AD, REV ORIG.SDR AALA20130527013Frame · crackedFRAME HAS CRACK INDICATION AT AIR CONDITIONING RAIL BRACKET INBD FASTENER HOLE AT STA 827 RIGHT. ACCOMPLISHED NESTED ANGLE REPAIR IAW ECO J1159 AE CARD 00007.SDR AALA20130527012Frame · crackedFRAME HAS CRACK INDICATION AT AIR CONDITIONING RAIL BRACKET INBD FASTENER HOLE AT STA 500A RIGHT. ACCOMPLISHED NESTED ANGLE REPAIR IAW ECO J1159AE, CARD 00007.SDR AALA20130527011Frame · crackedFRAME HAS CRACK INDICATION AT THE AIR CONDITIONING RAIL BRACKET AT STA. 440 RT. ACCOMPLISHED NESTED ANGLE REPAIR IAW ECO J1159AE, CARD 00007.SDR AALA20130527010Frame · crackedFRAME HAS CRACK INDICATION AT AIR CONDITIONING RAIL BRACKET AT INBD FASTENER AT STA 480 LT. ACCOMPLISHED NESTED ANGLE REPAIR IAW ECO J1159AE, CARD 00006.SDR SWAA2013062517593Frame · crackedFRAME CRACKED AT BS 380, BETWEEN STRINGER 11R & STRINGER 13R. REPAIRED FRAME IAW SRM.SDR REXA2013052900676Frame · corrodedLOWE FS333, FRAME CORRODED BETWEEN S-26L AND S-26R. REPAIRED IAW SRM 51-21-06.SDR COEA2013071018900Frame · crackedDURING HEAVY CHECK, LEFT FRAME 26 IS CRACKED AT STRINGER 13. REPLACED FRAME 26 SEGMENT IAW SRM 51-25-01, REV 99.SDR UALA2013052803652Frame · damagedBS 1681, FRAME SECTION REMOVED AND FOUND OTBD ANGLE BETWEEN STRINGS 17 AND 18R TO HAVE THREE HOLES WITH PREVIOUS COUNTER BORES. REMOVED DAMAGED SECTION OF THE OTBD ANGLE, FABRICATED REPLACEMENT AND SPLICE ANGLE. INSTALLED REPLACEMENT ANGLE IAW EA 130464IR & SDR SWAA2013062517526Frame · corrodedFWD CARGO COMPARTMENT FRAME CORRODED AT BS 500C, BETWEEN STRINGER 27L - STRINGER 28L. REPAIRED FRAME IAW SRM.SDR SWAA2013062517525Frame · corrodedFWD CARGO COMPARTMENT FRAME CORRODED AT BS 500C, BETWEEN STRINGER 27L - STRINGER 28L. REPAIRED FRAME IAW SRM.SDR SWAA2013061016987Former · crackedFRAME CRACKED AT STA 1133, LONG 26L. R & R FORMER IAW SRM & DWG.SDR DALA13026300126Frame · crackedBS 859.5, RBL 89 BELOW WL 200 FRAME TRANSITION RADIUS FOUND CRACK ABOUT 0.8" RUNNING UP. REPAIR ACCOMPLISHED IAW ER/A 513105-14AD REV ORIG SECTION I.SDR DALA13026290126Frame · crackedBS 883.5, RBL 89 BELOW WL 200 FRAME TRANSITION RADIUS FOUND CRACK ABOUT 0.4" RUNNING UP AS MARKED. REPAIR ACCOMPLISHED ER/A 513104-14AD REV ORIG SECTIONSDR COEA2013071019900Frame · corrodedDURING HEAVY CHECK, FOUND CORROSION ON FRAME 27A, LOWER FLANGE FWD SIDE JUST INBD OF PANEL 194DR. (LOWER STRAP) FABRICATE NEW STRAP IAW SRM 51-25-01.SDR SWAA2013070317883Frame · corrodedFRAME LOWER FLANGE CORRODED AT BS 907, BETWEEN STRINGER 27R & STRINGER 27L. REPAIRED FLANGE IAW SRM & DRAWING.SDR WX0A071596Frame · corrodedAFT CARGO FRAME AT STATION 1309 CORRODED BETWEEN LONGERON L24R TO 24L. REPAIRED FRAME.SDR SWAA2013052916581Frame · corrodedSHEAR TIE CORRODED AT BS 344, STR 26R. REPAIRED FRAME IAW SRM.SDR DALA13025229201Frame · corrodedAFT CARGO COMPARTMENT BILGE, BS 1364, LONGERON 26R - 26L, FRAME IS CORRODED IN SEVERAL PLACES. TASK 53-302-07. REMOVED CORROSION. FOUND TO BE WITHIN LIMITS. REPLACED L29R FRAME IAW SRM 53-10-02 FIG 2.SDR AALA20130524010Frame · cracked1485 CANT FRAME CRACKED BELOW STAIR RETENTION ACTUATOR. INSTALLED DOUBLER IAW AARD 53-10-00-33.SDR ASOA2013070908579Frame · corrodedIN THE MAIN AVIONICS COMPARTMENT WHILE PERFORMING AN INTERNAL ZONE INSPECTION, CORROSION WAS FOUND ON THE FWD SIDE OF FRAME 319.7 BETWEEN S26-27L. REMOVED CORROSION IAW SRM 51-21-06-001-001-A01. REPAIR CLASSIFIED AS MAJOR.SDR SWAA2013070317881Frame · corrodedFRAME LOWER FLANGE CORRODED AT BS 727E, BETWEEN STRINGER 27L & STRINGER 27R. REPAIRED FLANGE IAW SRM.SDR SWAA2013070317880Frame · corrodedFRAME LOWER FLANGE CORRODED AT BS 727D, BETWEEN STRINGER 25L & STRINGER 26L. REPAIRED FLANGE IAW SRM.SDR SWAA2013070317882Frame · corrodedFRAME LOWER FLANGE CORRODED AT BS 807, BETWEEN STRINGER 27L & STRINGER 27R. REPAIRED FRAME IAW SRM.SDR SWAA2013070217848Frame · corrodedLOWER FLANGE OF FRAME CORRODED AT BS 747, BETWEEN STRINGER 25L - STRINGER 26L. REPAIRED FRAME IAW SRM.SDR SWAA2013070217847Frame · corrodedLOWER FLANGE OF FRAME CORRODED AT BS 747, BETWEEN STRINGER 25L - STRINGER 26L. REPAIRED FRAME IAW SRM.SDR SWAA2013070117781Frame · corrodedFRAME LOWER FLANGE CORRODED AT BS 787, BETWEEN STRINGER 26R & STRINGER 27R. REPAIRED FRAME IAW SRM.SDR SWAA2013070117809Frame · corrodedFRAME LOWER FLANGE CORRODED AT BS 787, BETWEEN STR 27L AND STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA2013062717666Frame · corrodedFRAME LOWER FLANGE CORRODED AT BS 747, BETWEEN STRINGER 26L - STRINGER 27L. REPAIRED FRAME IAW SRM.SDR SWAA2013062517588Frame · corrodedAFT CARGO COMPARTMENT LOWER FRAME CORRODED AT BS 787, BETWEEN STRINGER 25L - STRINGER 26L. REPAIRED FRAME IAW SRM.SDR DALA1314330682Frame · dentedFWD CARGO FRAME, BS 580, STR 23-25L, DENTED. REPAIRED IAW SRM 53-00-07, FIG 201.SDR QXEA2013052301027Frame · corrodedFRAME 564.5, FLANGE AND WEB ARE CORRODED STR 31P-30P. REMOVED STRINGER 31P FITTING AND RIVETS ON X564.2 FOR ACCESS, BLENDED CORROSION ON FRAME 564.5 BETWEEN STR 31P-30P IAW SRM REV 12 51-42-05-02-01, 51-40-15-02-01, AND 51-21-00-00-02. CONFIRMED AREA CRACK FSDR DALA13024449201Frame · corrodedAFT CARGO COMPARTMENT BS 1379, LONGERON 27R FRAME HAS CORROSION. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. REPAIRED DAMAGE IAW SRM 53-10-02, SRM 51-10-03.SDR CALA2013052300339Frame · crackedFRAME BS 500A BETWEEN S8-9R CRACKED AT INBD FASTENER OF AIR CONDITIONING OUTLET EXTRUSION. BRACKET CRACK NOTED DURING VISUAL AND MFEC INSP REF EA 5310-04716 REV E AND NDT 6-53-30-00, PROCEDURE 7, REPAIRED IAW ECRA 5310-05747.
Back to JASC 5311