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 ASOA2013052903705Frame · corrodedCORROSION ON FRAME 319.70 FWD SIDE STR 26L. REPAIRED IAW SRM 51-21-06-001-001-A01 AND REO 670-53-21-948.SDR ASOA2013052903704Frame · corrodedCORROSION ON FRAME 295 FWD SIDE BETWEEN STR 26 & 27L. REPAIRED IAW SRM 51-21-06-001-001-A01 AND REO 670-53-21-950.SDR ASOA2013052903703Frame · corrodedCORROSION ON FRAME BS 310 STR 27. REPAIRED IAW SRM 51-21-06-001-001-A01 AND REO 670-53-21-949.SDR ASOA2013052903702Frame · corrodedCORROSION ON FRAME 310 FWD SIDE AT S27. REPAIRED IAW SRM 51-21-06-001-001-A01 AND REO 670-53-21-949.SDR ASOA2013052903701Frame · corrodedCORROSION ON FRAME 310 FWD SIDE AT STR 26R. REPAIRED IAW SRM 51-21-06-001-001-A01 AND REO 670-53-21-949.SDR ASOA2013052903699Frame · corrodedCORROSION ON FRAME AT FS 295 AFT SIDE BETWEEN STR 26L & 25R. REPAIRED IAW SRM 51-21-06-001-001-A01 AND REO 670-53-21-950.SDR ASOA2013052903698Frame · corrodedCIRCUMFERENTIAL JOINT AT FS 280 HAS CORROSION AT STR 27. REPAIRED IAW SRM 51-21-06-001-001-A01 AND REO 670-53-21-951.SDR ASOA2013052903692Frame · corrodedFRAME BS 349, CORROSION ON AFT SIDE FROM STR 26R-26L. R & R FRAME IAW SRM 51-42-06-001-001.SDR IPXA3M78542Frame · crackedINSPECTION TYPE:4C FRAME AT BS 427.668 APPX 11 O'CLOCK POS IS CRACKED. REPAIRED FUSELAGE DROP CEILING FRAME AT BS 427.668 AT 11:00 POS REF EA 011-5310-01-A4625. REV I/R, EO MD11-5310-50864-A.SDR QXEA2013050600961Frame · corrodedFOUND CORROSION ON FRAME X156.000, LOWER FLANGE BETWEEN STRINGERS 32S AND 33. FOUND CORROSION AT RIVET BUCKTAILS ON 4 EA RIVETS. REMOVED RIVETS 4 EA AT FRAME X156.000 LOWER FLANGE BETWEEN STRINGERS 32S AND 33 IAW SRM 51-40-07-02-01 REV 12. CLEAN CORROSION OSDR QXEA2013050600908Frame · corrodedFRAME X258.000, LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 27P AND 33. REMOVED CORROSION IAW SRM 51-42-05-02-01, SRM 51-21-00-00-02, REV 12 VERIFIED AFFECTED AREAS TO BE CRACK FREE, REF NDTM PART 1, TASK 51-00-06-910-801, REV 9. FOUND TO BE IN LIMITS ISDR QXEA2013050600907Frame · corrodedFRAME X116.000, LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 30S AND 32P. REMOVED CORROSION IAW SRM 53-00-00-02-09, REV 12. VERIFIED AFFECTED AREAS TO BE CRACK FREE USING HFEC NDTM PART 1 TASK 51-00-06-910-801, REV 9. FOUND TO BE IN LIMITS IAW SRM 53-00-SDR QXEA2013050600906Frame · corrodedFRAME X94.800, FLANGE HAS CORROSION BETWEEN STRINGERS 30S AND 31S. REMOVED CORROSION IAW SRM 53-00-00-02-09, REV 12. CONFIRMED CRACK FREE REF NTM 51-00-04-910-801, PT 1 AND 51-00-06-910-801 PT 1, REV 9. FOUND TO BE IN LIMITS IAW SRM 53-00-00-02-09, REV 12.SDR QXEA2013050600905Frame · corrodedFRAME X-18.250 CORRODED BETWEEN STRINGERS 29S AND 31S. REMOVED CORROSION IAW SRM 51-21-00-00-02, REV 12. CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-06-910-801, PT 1, REV 9. FOUND TO BE IN LIMITS IAW SRM 53-00-00-02-09 AND 53-20-15-00-01, REV 12,SDR QXEA2013050600903Frame · corrodedFRAME X-18.250 LT STACHION AT 31P HAS CORROSION ON AFT SURFACE JUST ABOVE TOP OF FRAME. REMOVED CROSS BRACE BOLT AT LOWER -18.25, AND END TIE BOLT IAW SRM 51-41-05-00-01 REV 12, REMOVED FWD END TIE FITTING IAW SRM 51-42-05-02-01, REV 12. REMOVED (STANCHION" SDR QXEA2013050600891Frame · corrodedFRAME 439.5, FLANGE IS CORRODED STR 31P-29P. REMOVED 12 RIVETS AND CORROSION FROM FRAME 439.5, FLANGE BETWEEN STR 31P-29P IAW SRM REV 12 53-00-00-02-09 MIN REMAINING THICKNESS NOTED 0.060" IAW NTM 51-00-04-910-801, PT 1, REV 9. CONFIRMED AFFECTED AREA CRACK SDR AALA20130506015Frame · crackedCABIN STATION 400, THE LEFT SIDE OVERHEAD BIN LOWER SIDE RAIL ATTACH SUPPORT AREA, OUTBOARD RIVET HOLE HAS A CRACK COMING OUT OF THE HOLE. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AE.SDR AALA20130506020Frame · wornCOCKPIT TEMPERATURE CONTROL VALVE WEARING INTO FRAME 1380. INSTALLED DOUBLER PER AARD 53-10-00-28, FIGURE 28.SDR AALA20130506016Frame · crackedCANT 1510 IS CRACKED AT THE TAIL CONE ALIGNMENT PIN AT THE 7 O` CLOCK POSITION. INSTALLED DOUBLER PER EA MD80-53-029565.SDR AALA20130506012Frame · crackedCANT FRAME 1510 IS CRACKED AT THE TAIL CONE ALIGNMENT PIN JUST LEFT OF THE SLIDE TRAY. INSTALLED 1510 CANT FRAME PIN DOUBLER PER EA MD80-53-029565.SDR AALA20130506014Frame · crackedSTATION 480L FRAME IS CRACKED AT THE SUPPORT BRACKET INBOARD FASTENER. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AE.SDR AALA20130506013Frame · crackedSTATION 400R FRAME IS CRACKED AT THE SUPPORT BRACKET INBOARD FASTENER. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AE.SDR SWAA2013052316407Frame · corrodedFRAME CORRODED AT STA 974, BETWEEN LONGERON 30L TO LONGERON 29L. R & R FRAME IAW SRM.SDR DALA1313226709Frame · gougedFUSELAGE FRAME AND SPLICE GOUGED AT BS 1520 BETWEEN S23-26R. REPAIRED FRAME IAW SRM 53-00-07, REPAIR 5.SDR QXEA2013050500885Frame · corrodedFRAME 71.2, FLANGE IS CORRODED STR 31P-32P. REMOVED CORROSION IAW SRM 51-42-05-02-01 & 53-00-00-02-09, REV 12. VERIFIED AFFECTED AREAS TO BE CRACK FREE REF NDTM PART 6, TASK 51-00-01-250-801, REV 9. FOUND TO BE WITHIN LIMITS IAW 53-00-00-02-09, REV 12.SDR QXEA2013050500882Frame · corrodedFRAME X71.200, LOWER FLANGES CORRODED BETWEEN STRINGERS 30P AND 32P. REMOVED CORROSION IAW SRM 51-21-00-00-02, REV 12. VERIFIED AFFECTED AREAS TO BE CRACK FREE, REF NDTM PART 6, TASK 51-00-01-250-801, REV 9. FOUND TO BE WITHIN LIMITS IAW SRM 53-00-00-02-SDR AALA20130505002Frame · corrodedCORROSION ON BS 847 PRIMARY STRUCTURE FRAME BETWEEN STRINGERS 24 AND 25 LEFT. INSTALLED DOUBLER PER EA B737-53-029674.SDR C77A20130505018Frame · damagedEVIDENCE OF DRILL MARKS AND DAMAGED RIVET VERIFIED ON LT AFT SIDE OF REAR PRESSURE BULKHEAD ON BULKHEAD ATTACH RING BETWEEN STRINGERS 12L AND 13L. R & R RIVET AND BLENDED OUT DRILL MARK IAW SRM PART II 51-40-01 AND 51-10-03.SDR DALA13024600857Frame · crackedAFT PRESSURE BULK HEAD FRAME CRACKED. APB FRAME REPLACED IAW EM 5310-01203-04E.SDR SWAA2013052316405Frame · crackedFRAME FLOORBEAM CRACKED AT STA 696, LBL 56. R & R FRAME IAW SRM AND DWG.SDR SWAA2013052316404Frame · crackedFRAME CRACKED AT STA 674, LBL 56. R & R FRAME IAW SRM AND DWG.SDR SWAA2013052116306Frame · corrodedFRAME CORRODED AT BS 908, LONG 29L TO LONG 30L. REPAIRED FRAME IAW SRM.SDR SWAA2013052116305Frame · corrodedFRAME CORRODED AT BS 889, BETWEEN LONG 28L TO LONG 30L. REPAIRED FRAME IAW SRM.SDR SWAA2013052116289Frame · corrodedAFT CARGO COMP FRAME CORRODED AT BS 927, BETWEEN LONGERON 30L TO LONGERON 29R. R & R FRAME IAW SRM.SDR SWAA2013051716187Frame · crackedFRAME CRACKED AT BS 674, RT SIDE. R & R FRAME IAW SRM & DWG.SDR SWAA2013051415999Frame · crackedFRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER EA.SDR SWAA2013051315889Frame · crackedFRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER EA.SDR SWAA2013051315888Frame · crackedFRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2013051315887Frame · crackedFRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2013051315892Frame · crackedFRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER EA.SDR SWAA2013051315890Frame · crackedFRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER EA.SDR FDEA201305040907Frame · chafedFRAME AT BS 1280 FOUND DAMAGED BETWEEN S14-15R. COMPLIED WITH EA F-5310-166066. REPAIR CLASSIFIED MAJOR IAW GMM 6-2-100.
SDR SWAA2013052316387Frame · corrodedFRAME CORRODED AT STA 974, BETWEEN LONG 30L TO LONG 29L. REPAIRED FRAME IAW SRM.SDR SWAA2013052116313Frame · corrodedFRAME CORRODED AT STA 889, BETWEEN LONG 28L TO LONG 30L. REPAIRED FRAME SECTION IAW SRM.SDR SWAA2013052116312Frame · corrodedAFT CARGO COMP FRAME CORRODED AT STA 908, BETWEEN LONG 29L TO LONG 30L. R & R FRAME SECTION IAW SRM.SDR SWAA2013052116304Frame · corrodedAFT CARGO COMP FRAME CORRODED AT STA 927, BETWEEN LONGERON 30R TO LONGERON 29R. R & R FRAME IAW SRM.SDR DALA13020999246Frame · corrodedAFT ACCESSORY COMPARTMENT CANTED FRAME BS 1473 L14R HAS LIGHT CORROSION. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. FABRICATED REPAIR PARTS IAW 53-10-02, FIG 11, PG 62, 51-10-03, PARA 27.SDR CALA2013050600274Frame · crackedFRAME CRACKED AT BS 867 BETWEEN STRINGERS 8 & 9R. REPAIRED IAW EA 5310-04716 REV.E STEPS 10, 11 & 13.SDR DALA13021009246Frame · damagedAFT ACCESSORY LOWER END OF CANTED FRAME CORRODED. REMOVED CORROSION. CUT OUT DAMAGED SECTION OF FRAME. FABRICATED NEW ANGLE FILLER. LOCATED AND DRILLED REPAIR PARTS.INSTALLED TRIPLER, AND DOUBLER IAW SRM 51-30-05, 51-10-03, 51-10-05.SDR SWAA2013052816527Frame · corrodedFRAME CORRODED AT STA 1022, BETWEEN LONG 29L & LONG 29R. REPAIRED FRAME IAW SRM.
Back to JASC 5311