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 ASOA201102297Frame · corrodedDURING REPAIR, FOUND FS 333 LOWER FRAME IS CORRODED. REMOVED FRAME IAW SRM CH 51-42-06 & 51-42-21 & FOUND CORROSION TO BE OUT OF LIMITS. LOCATED & DRILLED NEW SERVICEABLE FRAME IAW SRM CH 51-40-11. INSTALLED FRAME IAW SRM 51-42-06 AND 51-42-21.SDR QXEA2011120201299Frame · corrodedDURING C CHECK, CORRODED RIVETS ON FRAME SPLICE AT X 32.40 Y 0.0.SDR SWAA118286Frame · corrodedDURING SCHEDULED 24Y CHECK FOUND FWD CARGO COMPARTMENT FRAME CORRODED AT BS 500C, BETWEEN STR 28R TO STR 28L. REPAIRED FRAME IAW SRM AND DWG.SDR JR2R2011120100607Frame · corrodedFRAME AT FS310 CORRODED BETWEEN STR 26L AND 25R. REPAIRED IAW RO CRJ9-53-0880.SDR K11A2012031216004Frame · corrodedLIGHT CORROSION ON FRAME (1 IN X 1 IN) CORROSION (N/R 21783).SDR K11A2012031216002Frame · corrodedFRAME CORRODED MAIN CARGO DECK 1 IN X 1 IN (N/R 21634).SDR QXEA2011120201275Frame · corrodedDURING C-CHECK, FOUND CORROSION ON FRAME ATTACH FLANGE AT STA X301 STR 32-33 RT. BLENDED OUT CORROSION IAW SRM 51-21-00-00-02, DAMAGE FOUND TO BE WITHIN LIMITS OF RD 8/4-53-2344. ALODINED, PRIMED AND PAINTED AREA IAW RD 8/4-53-2344.SDR QXEA2011120101255Frame · corrodedDURING C-CHECK, CORROSION FOUND AT BS 216, S32 & 33R. BLENDED SURFACE CORROSION AND FOUND TO BE IN LIMITS IAW RD 8/4-53-2344. PERFORMED FPI IAW CHAP 8, NO DEFECTS NOTED. COMPLETED REPAIR, TREATED AND PAINTED IAW RD 8/4-53-2344.SDR QXEA2011120101256Frame · corrodedACFT DOWN FOR C-CHECK. CORROSION FOUND ON FRAME FS 94.8 S31LT-32 RT. ACFT DOWN FOR C-CHECK.SDR AALA20111130TUL42Frame · crackedAFT ACCESS TAIL CONE MOUNT CRACKED AT 5:00 ALIGNMENT PIN MKD. STOP DRILLED CRACK AND INSTALLED DOUBLER REPAIR PER SRM 51-30-05 AND EA MD80-53-020473.SDR AALA20111130TUL38Frame · crackedAFT ACCESS TAIL CONE MOUNT CRACKED AT 7:00 ALIGNMENT PIN. STOP DRILLED CRACK AND INSTALLED DOUBLER REPAIR PER SRM 51-30-05 AND EA MD80-53-020473.SDR QXEA2011120101265Frame · corrodedCORROSION ON FASTENERS STA 18.250 STR 31 STBD. ACFT DOWN FOR C-CHECK.SDR QXEA2011120101264Frame · corrodedCORROSION ON FRAME FLANGE STA 18.250 BETWEEN STR 31 - STR 30 STBD. ACFT DOWN FOR C-CHECK.SDR QXEA2011120101263Frame · corrodedCORROSION ON FRAME FLANGE STA 18.250, BETWEEN STR 31 - STR 32 STBD. ACFT DOWN FOR C-CHECK.SDR QXEA2011120101262Frame · corrodedCORROSION ON FRAME FLANGE STA 18.250 BETWEEN STR 32 - STR 33 STBD. ACFT DOWN FOR C-CHECK.SDR QXEA2011120101261Frame · corrodedCORROSION ON FRAME FLANGE STA 18.250 BETWEEN STR 31 - STR 32 PORT. ACFT DOWN FOR C-CHECK.SDR QXEA2011120101260Frame · corrodedCORROSION ON FRAME FLANGE STA 18.250 BETWEEN STR 32-STR 33 PORT. ACFT DOWN FOR C-CHECK.SDR QXEA2011120101259Frame · corrodedCORROSION ON FRAME FLANGE STA 18.250, STR 31, STR 30 PORT. ACFT DOWN FOR C-CHECK.SDR SWAA118259Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 787, STR 25L. REMOVED AND REPLACED FRAME IAW EA.SDR CHQA201100463Frame · crackedDURING INSPECTION, A CRACK WAS FOUND ON FRAME 23 UNDER SILL NUMBER 1. MAINTENANCE REPAIRED THE RIGHT-HAND FRAME 23 UNDER SILL NUMBER 1 IN ACCORDANCE WITH ETD 2011-145-108720.SDR CHQA201100481Frame · crackedDURING INSPECTION, THE LEFT FRAME 10 WAS FOUND CRACKED INSIDE THE COCKPIT BELOW THE SIDE WINDOW. MAINTENANCE REPLACED THE LEFT FRAME 10 INSIDE THE COCKPIT BELOW THE SIDE WINDOW AND INSTALLED WITH SOLID RIVETS IN ACCORDANCE WITH SRM 51-40-02.SDR SIMA201133607Frame · damagedDURING MAINTENANCE BASE INSPECTION FOUND FRAME 2 DAMAGED. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED DAMAGED FRAME 2 WITH NEW IAW EO EM-53MR-1881. THE AIRCRAFT WAS RETURNED TO SERIVCE.SDR ASOA201102285Frame · corrodedUPON REMOVAL OF INTERCOSTALS BETWEEN STR 26L & 26R, FS STA 349 TO 364, FOUND FS 349 FRAME CORRODED. REMOVED FRAME SECTION IAW SRM 51-42-06 AND SRM 51-42-21. INSTALLED NEW LOWER FRAME SECTION IAW SRM 51-42-06 AND SRM 51-42-21.SDR UALA2011113006570Frame · corrodedCORROSION ON FRAME CAP AT STA 325 AT RBL 57. MAJOR REPAIR ACCOMPLISHED IN CONJUNCTION WITH PTT SEQ #3422104. ACCOMPLISHED A REPAIR TO THE FRAME CAP AT STA 325 FROM RBL 34 TO RBL 84 IAW B767-300 SRM.SDR UALA2011113006569Frame · corrodedCORROSION ON FRAME CAP AT STA 325 - RBL 69. MAJOR REPAIR ACCOMPLISHED TO THE FRAME CAP AT STA 325 FROM RBL 34 TO RBL 84 IAW B767-300 SRM 53-00-52 FIGURE 1 SHEETS 1-6, SRM 51-40-02, 51-21-04, 51-21-10.SDR SWAA118243Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME CRACKED AT BS 500C, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME IAW SRM.SDR SWAA118237Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME CORRODED AT BS 727E, BETWEEN STR 25L TO STR 26L. REPAIRED FRAME IAW ER.SDR NSVA2011314Frame · corrodedBOTTOM FRAME AT STA 225 HAS CORROSION. COMPLETED REPAIR IAW SAAB STATEMENT 340SDS023421 AND TD 340-53-11-81.SDR NSVA2011312Frame · damagedDENTS ON BOTTOM AFT FUSELAGE AND PREVIOUS REPAIR TO BOTTOM FRAME AT STA 718 LBL 4.5 TO LBL 13.7 NOT IN DAMAGE LOG. DENTS AND PREVIOUS REPAIR ACCEPTED AS IS PER SAAB STATEMENTS 340SDS009697 AND 340SDS023425. COMPLETED TD 340-53-11-86.SDR ASAA12410893Frame · crackedSTA 380 RT BETWEEN STRINGER 8R 9R IS CRACKED. REPAIRED STA 380 RT FRAME IAW EA AD20062609 400 53 128.SDR ASAA12410892Frame · crackedSTA 440 RT BETWEEN STRINGER 8R 9R IS CRACKED. REPAIRED STA 440 RT FRAME IAW EA AD20062609 400 53 128.SDR ASAA12410891Frame · crackedSTA 400 RT FRAME BETWEEN STRINGER 8R 9R IS CRACKED. REPAIRED STA 400 RT FRAME IAW EA AD20062609 400 53 128.SDR ASAA12410890Frame · crackedSTA 787 LT FRAME BETWEEN STRINGER 8L 9L IS CRACKED. REPAIRED STA 787 LT FRAME IAW EA AD 20062609 400 53 128.SDR ASAA12410889Frame · crackedSTA 867 LT FRAME BETWEEN STRINGER 8L 9L IS CRACKED. REPAIRED STA 867 LT FRAME IAW EA AD20062609 400 53 128.SDR ASAA12410888Frame · crackedSTA 480 RT FRAME BETWEEN STRINGER 8R 9R IS CRACKED. REPAIRED STA 480 RT FRAME IAW EA AD20062609 400 53 128.SDR ASAA12410886Frame · crackedSTA 360 LT FRAME BETWEEN STRINGER 8L 9L IS CRACKED. REPAIRED STA 360 LT FRAME IAW EA AD20062609 400 53 128.SDR ASAA12410885Frame · crackedSTA 747 RT FRAME BETWEEN STRINGER 8R 9R IS CRACKED. REPAIRED STA 747 RT FRAME IAW EA AD20062609 400 53 128.SDR ASAA12410884Frame · crackedSTA 907 RT FRAME BETWEEN STRINGER 8R 9R IS CRACKED. REPAIRED STA 907 RT FRAME IAW EA AD20062609 400 53 128.SDR ASAA1240883Frame · crackedSTA 480 FRAME LT BETWEEN STRINGER 8L 9L IS CRACKED. REPAIRED STA 480 LT FRAME IAW EA AD20062609 400 53 128.SDR NACA20110048Frame · crackedCRACK FOUND IN FWD CARGO BAY STRINGER 19 TO 21, FRAME 500C AT WIRE PENETRATION HOLE, RIGHT. REPAIRED FRAME 500C RIGHT IAW SB737-53A1279R1 PER SRM 53-00-07 REPAIR 13 AND AERONAUTICAL ENGINEERING EO 1563 DATED 3 DEC 2011.SDR EPUA20111201006Frame · crackedFUSELAGE FORMER AT STATION 385.6 HAS A CRACK 2" TO RT OF BOTTOM CENTER LINE.SDR USAA2011120200002Frame · crackedCDFI, FRAME CRACKED AT BS 500F BETWEEN S20L AND S21L. REPAIRED FRAME AT BS 500F BETWEEN S20L AND S21L IAW B737 SRM 53-00-07 REPAIR 13.SDR USAA2011120200001Frame · crackedCDFI, FRAME CRACKED AT BS 500E BETWEEN S20L AND S21L. REPAIRED FRAME AT BS 500E BETWEEN S20L AND S21L IAW B737 SRM 53-00-07 REPAIR 13.SDR USAA2011113000016Frame · crackedCDFI MAINTENANCE VISIT, FRAME CRACKED AT BS 500E BETWEEN S20R AND S21R. REPAIRED FRAME AT BS 500E, BETWEEN S20R AND S21R IAW B737 SRM 53-00-07, REPAIR 13.SDR ASOA201102276Frame · corrodedUPON REMOVAL OF INTERCOSTALS BETWEEN STR 26R & 26L BETWEEN FS 349 & 364, FOUND FS 349 CORROSION IN NUMEROUS AREAS BETWEEN STR 24L & 24R. REMOVED CORROSION IAW SRM.SDR ASOA201102268Frame · corrodedUPON REMOVAL OF INTERCOSTAL BETWEEN STR 26R AND 26L BETWEEN FS 349 AND 364, FOUND FS 349 CORRODED IN NUMEROUS AREAS BEWN STR 24L AND 24R. REPAIRED IAW SRM.SDR UALA2011112906547Failsafe · crackedSTA 1140 RT SIDE FAIL SAFE CHORD 2 EACH HOLES CRACKED. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGE. HFEC, NO CRACK. FABRICATED AND INSTALLED REPAIR PARTS IAW SRM 53-40-07 REPAIR 2 (EFS PG 24-32).SDR UALA2011112906530Failsafe · crackedSTA 1140 LT SIDE FAILSAFE CHORD 2 EACH HOLES CRACKED. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGE. HFEC, NO CRACK. FABRICATED AND INSTALLED REPAIR PARTS IAW SRM 53-40-07 REPAIR 2 (EFS PG 24-32).SDR SWAA118215Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FRAME CORRODED AT BS 259, BETWEEN LBL 10 TO RBL 11. REPAIRED FRAME IAW EA.SDR SWAA118212Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND LT FRAME CRACKED AT BS 616. REPAIRED FRAME IAW EA.
Back to JASC 5311