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 CALA2013022700134Frame · crackedCRACK INDICATION NOTED ON FRAME BS 706 BETWEEN STRINGER S8-S9L, FRAME HAS BEEN REPAIRED IAW EC/RA 5310-05641.SDR CALA2013022700133Frame · crackedCRACK INDICATION NOTED AT FRAME BS 907L BETWEEN STRINGER S8-9L. FRAME HAS BEEN REPAIRED IAW EC/RA 5310-05641.SDR CALA2013022700132Frame · crackedCRACK INDICATION NOTED AT FRAME BS 907, RT BETWEEN S8-9R. FRAME 907 REPAIRED IAW EC/RA 5310-05641.SDR QXEA2013022500471Frame · corrodedFRAME FLANGE AT FR 116 STR 32-30P HAS CORROSION. REMOVED CORROSION IAW SRM REV 12 53-00-00-02-09. CONFIRMED CRACK FREE CONDITION REF NTM 51-00-04-910-801, PT 1 AND 51-00-06-910-801 PT 1, REV 8. WITHIN LIMITS IAW SRM 53-00-00-02-09, REV 12.SDR GLBA2013022800189Frame · crackedFUSELAGE FRAME DOUBLER AT FS 177.25 & STRINGER 13L CRACKED 1.2" IN LENGTH IN FLANGE BEND RADIUS TO SECOND FASTENER FROM THE OTBD EDGE OF DOUBLER. REPAIRED IAW EO 13-1900-53-018. MAJOR REPAIR.SDR GLBA2013022600184Frame · crackedRIGHT SIDEWALL AT FS 107, FRAME CRACKED AT UPPER FASTENER AREA. LONGERON AT FS 107 CRACKED. REPAIRED IAW EO 13-1900-53-014. MAJOR REPAIR.SDR FDEA201302250445Frame · corrodedUPON REMOVAL OF THE FWD LAV DUCTS FOUND CORROSION ON THE FRAME UPPER FLANGE BS 418 LBL 10. REPAIRED IAW EA 757-5312-16-F4139, REV, DATED APRIL 9, 2013 AND NR 49658380001. REPAIR CLASSIFIED AS MAJOR.SDR FDEA201302250442Frame · damagedDURING ACCOMPLISHMENT OF EO 6-5310-7-5020, PART 1, FOUND EDGE DISTANCE FOR HOLES H23 AT FR 46 LT TO BE BELOW .472". FRAME 46 LT HOLE H23 COMPLIED WITH MOD TYPE T MOD NR 6-5315-T0300100, REV NO PS P1 STEPS 29 AND 30.SDR SWAA2013032013881Frame · crackedFRAME CRACKED AT BS 927 BETWEEN LONGERON 30R AND LONGERON 29R. REPAIRED FRAME PER SRM.SDR SWAA2013031913785Frame · corrodedFRAME CORRODED AT BS 500, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME IAW SRM.SDR REXA2013022500339Frame · corrodedFRAME AT FS 605 HAS CORROSION BETWEEN S-26L AND S-27. REPLACED IAW SRM 51-42-06 AND 51-42-21.SDR SWAA2013032614160Frame · crackedFRAME CRACKED AT BS 344, STR 17L. REMOVED AND REPLACED FRAME IAW SRM.SDR SWAA2013032214022Frame · crackedFRAME CRACKED AT BS 312, BETWEEN STR 4L TO STR 6L. REPAIRED FRAME IAW EA.SDR SWAA2013031413665Frame · crackedFUSELAGE FRAME CRACKED AT STA 400, BETWEEN STR 15L & STR 16L. REPAIRED FRAME PER SRM.SDR SWAA2013031413656Frame · crackedFUSELAGE FRAME AT BS 400 BETWEEN STR 15L AND STR 16L CRACKED. REMOVED AND REPLACED FRAME PER SRM.SDR QXEA2013022300493Frame · corrodedFRAME FLANGE AT FR 644.5 STR 32-31P HAS CORROSION. REMOVED CORROSION IAW SRM 53-00-00-02-09 REV 12. CONFIRMED CRACK FREE CONDITION REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1 REV 8. FOUND TO BE WITHIN LIMITS IAW SRM 53-40-15-00-01 AND 53-00-00-SDR QXEA2013022300490Frame · corrodedFRAME FLANGE AT FR 604.5 STR 32-31S HAS CORROSION. REMOVED CORROSION IAW SRM (R12) 53-00-00-02-09. CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-801, PT 1 & 51-00-00-910-801 PT 1, REV 8. FOUND WITHIN LIMITS IAW SRM 53-00-00-02-09, R12.SDR QXEA2013022300489Frame · corrodedFRAME FLANGE AT FR 604.5 STR 32-31P HAS CORROSION. REMOVED CORROSION IAW SRM (R12) 53-00-00-02-09. CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-045-910-801 PT 1 & 51-00-06-910-801, PT 1, REV 8. FOUND WITHIN LIMITS IAW SRM 53-00-00-02-09, REV 12.SDR QXEA2013022300488Frame · corrodedFRAME FLANGE AT FR 509 STR 32-31P HAS CORROSION. BLENDED CORROSION IAW SRM 53-00-00-02-09, REV 12. CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-801 PT 1 & 51-00-06-910-801, PT 1 REV 8. FOUND WITHIN LIMITS IAW SRM 53-00-00-02-09, REV 12.SDR QXEA2013022300487Frame · corrodedFRAME FLANGE AT FR 489.5 STR 32-31S HAS CORROSION. BLENDED CORROSION IAW SRM 53-00-00-02-09, REV 12. CONFIRMED CRACK FREE CONDITION REF NTM 51-00-04-910-801, PT1 & 51-00-06-910-801 PT 1 REV 8. FOUND TO BE WITHIN LIMITS IAW SRM 53-00-00-02-09, REV 12.SDR QXEA2013022300486Frame · corrodedFRAME FLANGE AT FR 489.5, STR 32-31P HAVE CORROSION. BLENDED CORROSION SRM 53-00-00-02-09, REV 12. CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-801 PT 1 & 51-00-06-02-09, PT 1, REV 8. FOUND TO BE WITHIN LIMITS IAW SRM 53-00-00-02-09, REV 12.SDR QXEA2013022300483Frame · corrodedFRAME FLANGES AT FR 301 STR 32-30P HAVE CORROSION. REMOVED CORROSION AND FOUND WITHIN LIMITS IAW SRM 53-00-00-02-09, REV 12. CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-801, PT 1 AND 51-00-06-910-801, PT 1, REV 8.SDR QXEA2013022300482Frame · corrodedFRAME FLANGES AT FR 301 STR 32-30S HAVE CORROSION. REMOVED CORROSION IAW SRM 53-00-00-02-09, REV 12. CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-801 PT 1 & 51-00-06-910-801, PT 1, REV 8. FOUND WITHIN LIMITS IAW SRM 53-00-00-02-09, REV 12.SDR QXEA2013022300481Frame · corrodedFRAME FLANGES AT FR 281 STR 32-30P HAVE CORROSION. REMOVED CORROSION IAW SRM 53-00-00-02-09 REV 12. CONFIRMED AREA CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801, PT 1, REV 8. FOUND TO BE WITHIN LIMITS IAW SRM 53-30-14-00-01, 53-00-00-02-0SDR QXEA2013022300480Frame · corrodedFRAME FLANGES AT FR 281 STR 32-30S HAVE CORROSION. REMOVED OF CORROSION IAW SRM 53-00-00-02-09, REV 12. CONFIRMED AREA CRACK FREE REF NTM 51-00-04-910-801 PT 1 & 51-00-06-910-801 PT 1 REV 8. FOUND TO BE WITHIN LIMITS IAW SRM 53-30-15-00-01, 53-00-00-02-09 SDR QXEA2013022300475Frame · corrodedFRAME FLANGES, FR 176 STR 32-30S HAVE CORROSION. REMOVED CORROSION, VERIFIED AFFECTED AREAS TO BE CRACK FREE REF NDTM PART 6 TASK 51-00-01-250-801 REV 8 MINIMUM THICKNESS REMAINING NOTED .044" REF NDTM PART 1 TASK 51-00-04-910-801 REV 8. NOMINAL THICKNESS .04SDR QXEA2013022300473Frame · corrodedFRAME FLANGE AT FR 136 STR 32-30S HAS CORROSION. REMOVED CORROSION IAW SRM 51-21-00-00-02, REV 12. CONFIRMED AREA CRACK FREE REF NTM 51-00-04-910-801, PT 1 AND 51-00-06-910-801, PT 1 REV 8. FOUND IN LIMITS IAW SRM 53-00-00-02-09, REV 12.SDR QXEA2013022300472Frame · corrodedFRAME FLANGE FR 136 STR 32-29P HAS CORROSION. FOUND CORROSION TO BE LIMITED TO FASTENERS AT FRM 136 STR 32P-31P, AND STR 30P-29P, REMOVED CORROSION IAW SRM 51-21-00-00-02, REV 12. CONFIRMED AREA CRACK FREE REF NTM 51-00-04-910-801, PT 1 AND 51-00-06-910-801SDR QXEA2013022300470Frame · corrodedFRAME FLANGE AT FR 49.5 STR 32-28S HAS CORROSION. BLENDED CORROSION ON FRAME FLANGE IAW SRM REV 12 51-21-00-00-02. CONFIRMED CRACK FREE CONDITION REF NTM 51-00-04-910-801 & 51-00-06-910-801 PT 1, REV 8. FLANGES IN LIMITS IAW SRM 53-00-00-02-09, REV 12.SDR QXEA2013022300468Frame · corrodedFRAME FLANGES AT FR 32.4, STR 32-29P HAVE CORROSION. BLENDED CORROSION IAW SRM REV 12 53-00-00-02-09. CONFIRED CRACK FREE CONDITION REF NTM 51-00-04-910-801, PT1 & 51-00-06-910-801 PT1, REV 8. FOUND WITHIN LIMITS SRM 53-00-00-02-09, REV 12. REMOVED FLANGE SDR QXEA2013022300451Frame · corrodedFRAME FLANGES AT FR 71.2 STR 33-28S HAVE CORROSION. REMOVED RIVETS FOR ACCESS FROM FR 71.2 STR 33-28S IAW SRM REV 12 51-42-05-02-01. BLENDED CORROSION IAW SRM REV 12 53-00-00-02-09. CLEANED BETWEEN STR 30-29S ON FRAME 71.2 IAW SRM REV 12 51-26-00-02-01, NO SDR QXEA2013022300450Frame · corrodedFRAME FLANGES AT FR 71.2 STR 32-29P HAVE CORROSION. REMOVED RIVETS FOR ACCESS IAW SRM 51-42-05-02-01, REV 12. BLENDED CORROSION IAW SRM 53-00-00-02-09, REV 12. CLEANED BETWEEN STR 30-29P ON FRAME FLANGE 71.2, NO CORROSION NOTED IAW SRM REV 12 51-26-00-02-01SDR QXEA2013022300449Frame · corrodedFRAME FLANGE AT FR 49.5 STR 32-31P HAS POSSIBLE CORROSION. REMOVED 1EA RIVET FROM 49.5 FRAME BETWEEN STR 32P-31P IAW SRM REV 12 51-42-05-02-01. BLENDED CORROSION ON FRAME 49.5 FLANGE BETWEEN 32P-31P STR IAW SRM REV 12 51-21-00-00-02 MIN THICKNESS NOTED .049"SDR QXEA2013022300448Frame · dentedFRAME 32.4, STANCHION AT STR 31P HAS A DENT. REMOVED BOLTS FROM CROSS BRACE TO FOM IAW SRM REV 12 51-41-00-00-01. REMOVED STANCHION FROM FRAME 32.4 AT STR 31P IAW SRM REV 12 51-42-05-02-01. STANTION FOUND TO BE OUT OF LIMITS IAW SRM 53-20-43-00-01, REV 12 MSDR QXEA2013022300442Frame · corrodedFRAME FLANGES AT FR 19.4 STR 31-29S HAVE CORROSION. REMOVED RIVETS TO FOM, REMOVED CORROSION IAW SRM 51-42-05-02-01 & 51-21-00-00-02 REV 12. NO CORROSION NOTED BETWEEN 31S-32S. MIN THICKNESS NOTED .036", CONFIRMED CRACK FREE CONDITION REF NTM 51-00-04-910-80SDR UALA2013022401088Frame · corrodedAFT PIT, STA 1380, RBL 10-13, FRAME UPPER FLANGE, AFT SIDE CORRODED. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGED FRAME SECTION AND INSTALLED NEW SECTION REF SRM 53-00-07, BOEING DWG 146N1028 -88, AND SRM 51-40-02.SDR DALA1306926706Frame · dentedAFT CARGO BS 1400 BETWEEN S25-26L, FRAME UPPER FLANGE IS DENTED. REPAIRED IAW SRM 53-00-07, REPAIR 5, FIG 201.SDR SWAA2013031913807Frame · corrodedFRAME CORRODED AT BS 727D, BETWEEN STR 27R AND STR 27L. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA2013031913806Frame · corrodedFRAME CORRODED AT BS 767, BETWEEN STR 27R AND STR 27L. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA2013031313578Frame · crackedFUSELAGE FRAME CRACKED AT STA 294, RBL 54, WL 208. REPAIRED FRAME PER EA.SDR FDEA201302220412Frame · dentedMAIN DECK FRAME AT BS 1741, LONGERON 12L, FOUND DENT. REPAIRED AS PER SRM 53-00-07, FIGURE 201, REPAIR 2, REVISION 51. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100, REVISION 116.SDR FDEA201302220411Frame · dentedMAIN DECK AT BS 1721 LONGERON 12L, FRAME FOUND DENTED. REPAIRED AS PER SRM 53-00-07 FIGURE 201 REPAIR 2 REVISION 51. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100 REVISION 116.SDR FDEA201302220410Frame · dentedMAIN DECK FRAME FOUND DENTED AT BS 1681, LONGERON 12L. REPAIRED AS PER SRM 53-00-07 FIGURE 201 REPAIR 2 REVISION 51. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100 REVISION 116.SDR QXEA2013022200505Frame · corrodedFRAME 19.400 HAS CORROSION BETWEEN STRINGERS 30-32P. REMOVED CORROSION IAW SRM 51-42-05-02-01 AND 51-21-00-00-02, REV 12. CONFIRMED CRACK FREE CONDITION REF NTM 51-00-04-910-801, PT 1 AND 51-00-06-910-801 PT 1, REV 8. BLENDS WITHIN LIMITS IAW SRM 53-00-00-SDR QXEA2013022200492Frame · corrodedFRAME FLANGES AT FR 624.5, STR 33-31P HAVE CORROSION. REMOVED CORROSION IAW SRM 51-21-00-00-02-09, REV 12. CONFIRMED CRACK FREE CONDITION REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1 REV 8. FOUND TO BE WITHIN LIMITS IAW SRM 53-40-15-00-01 AND 53-SDR QXEA2013022200491Frame · corrodedFRAME FLANGES AT FR 624.5, STR 33-31S HAVE CORROSION. REMOVED CORROSION IAW SRM 51-21-00-00-02, REV 12. CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1 REV 8. FOUND TO BE WITHIN LIMITS IAW SRM 53-40-15-00-01 AND 53-SDR QXEA2013022200478Frame · corrodedFRAME FLANGES AT FR 216 STR 32-29P HAVE CORROSION. REMOVED CORROSION IAW SRM 53-00-00-02-09, REV 12. VERIFIED AFFECTED AREAS CRACK FREE REF NDTM PART 6, TASK 51-00-01-250-801, REV 8. FOUND TO BE WITHIN LIMITS IAW SRM 53-00-00-02-09, REV 12.SDR QXEA2013022200477Frame · corrodedFRAME FLANGES AT FR 216 STR 32-29S HAVE CORROSION. REMOVED CORROSION IAW SRM 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 8. IAW SRM 53-20-15-00-01, REV 12 AND DWG 85328320 FRAME MEASURED ABOVSDR QXEA2013022200474Frame · corrodedFRAME FLANGE AT FR 156 STR 32-30S HAS CORROSION. VERIFIED AFFECTED AREAS TO BE CRACK FREE REF NDTM PART 6, TASK 51-00-01-250-801, REV 8. FRAME FLANGE FOUND TO BE WITHIN LIMITS IAW SRM 53-00-00-02-09 REV 12.SDR QXEA2013022200464Frame · corrodedFRAME FLANGE AT FR 19.4 STR 33-32S HAS CORROSION. REMOVED RIVETS TO FOM REMOVED CORROSION IAW SRM 51-42-05-02-01 AND 51-21-00-00-02, REV 12 MIN THICKNESS NOTED .038", CONFIRMED CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801, PT 1, REV 8. BLENDS
Back to JASC 5311