JASC 5347
Service difficulty reports · 66,435
Reports filed under 5347 · Fuselage, Seat/Cargo Attach Fittings, 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 = '5347' 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 = '5347' 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 QXEA2009080700597Seat Track · corrodedPDX - 8 YR TASK - AFT CABIN LT INBOARD SEAT TRACK HAS CORROSION CHANNEL AND ON TOP OF LUGS AT FS 967. REMOVED CORROSION ON TRACK CHANNEL AND TOP AT FS 967 LT INBOARD. MAX AMOUNT OF MATERIAL REMOVED WAS .003. BLENDED AREA IS IN LIMITS, IAW BOMBARDIER REO 6SDR QXEA2009080700596Seat Track · corrodedPDX - 8 YR TASK - AFT CABIN LT INBOARD SEAT TRACK HAS CORROSION IN CHANNEL AND ON TOP OF LUGS AT FS 954. REMOVED CORROSION ON TRACK CHANNEL AND TOP AT FS 954 LT INBOARD. MAX AMOUNT OF MATERIAL REMOVED WAS .011. BLENDED AREA IS IN LIMITS, IAW BOMBARDIER REO SDR QXEA2009080700595Seat Track · corrodedPDX - 8 YR TASK - AFT CABIN LT INBOARD SEAT TRACK HAS CORROSION IN CHANNEL AND ON TOP OF LUGS AT FS 927. REMOVED CORROSION ON TRACK CHANNEL AND TOP AT FS 927 LT INBOARD. MAX AMOUNT OF MATERIAL REMOVED WAS .018. BLENDED AREA IS IN LIMITS, IAW BOMBARDIER REOSDR QXEA2009080700594Seat Track · corrodedPDX - 8 YR TASK - AFT CABIN LT INBOARD SEAT TRACK HAS CORROSION CHANNEL AND ON TOP OF LUGS AT FS 913. REMOVED CORROSION ON TRACK CHANNEL AND TOP AT FS 913 LT INBOARD. MAX AMOUNT OF MATERIAL REMOVED WAS .003. BLENDED AREA IS IN LIMITS, IAW BOMBARDIER REO 6SDR QXEA2009080700593Seat Track · corrodedPDX - 8 YR TASK - AFT CABIN LT INBOARD SEAT TRACK HAS CORROSION CHANNEL AND ON TOP OF LUGS AT FS 897. REMOVED CORROSION ON TRACK CHANNEL AND TOP AT FS 897 LT INBOARD. MAX AMOUNT OF MATERIAL REMOVED WAS .012. BLENDED AREA IS IN LIMITS, IAW BOMBARDIER REO 670SDR QXEA2009080700592Seat Track · corrodedPDX - 8 YR TASK - RT INBOARD SEAT TRACKS BETWEEN FS 469.00 - 533.00, FS 534.00 - 597.00, FS 598.00 - 677.00, FS 678.00 - 693.00 SHOW SIGNS OF CORROSION IN MULTIPLE PLACES ON THE CLAW AND CHANNEL AREAS. BLENDED DEEPEST AREA OF DAMAGE AND FOUND BLENDS TO BE OUTSDR FDEA200908062928Seat Track · gougedMAIN DECK AT STA 865, RBL 45, SEAT TRACK WORN / GOUGE. REMOVED SEAT TRACK , FABRICATED NEW SEAT TRACK FROM MAT- BAC1520-792, IAW SRM 51-10-02. INSTALLED SEAT TRACK STA 780- 879, RBL 45", IAW SRM 51-40-02. CATEGORY "A", MAJOR REPAIR.SDR FDEA200908062927Seat Track · gougedSEAT TRACK HAS GOUGE ON CROWN AREA AT STA 1064, LBL 24. REMOVED SEAT TRACK, FABRICATED NEW SEAT TRACK ON MAE TRAV T9/799981, INSTALLED SEAT TRACK AND PLATES IAW SRM 53-00-52. REPAIR 4, CATEGORY "A", MAJOR REPAIR.SDR UALA2009080702399Seat Track · corrodedMAIN CABIN SEAT TRACK IS CORRODED AT BS 346, RBL 84. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGED SEAT TRACK STA 364 TO 412. FABRICATED & INSTALLED NEW SEAT TRACK.SDR UALA2009080602378Seat Track · corrodedMAIN CABIN SEAT TRACK IS CORRODED AT BS 323, RBL 11.5. REMOVED DAMAGED SEAT TRACK STA 323 TO 422, RBL 11.5, INSTALLED NEW TRACK P/N 141T5121-108.SDR UALA2009080602377Seat Track · corrodedMAIN CABIN SEAT TRACK IS CORRODED AT BS 323, LBL 11.5. INSTALLED NEW SEAT TRACK SECTION, P/N 141T5121-109. TRACK SECTION STA 323 TO 422, LBL 11.5 REPLACED.SDR QXEA2009080600589Seat Track · corrodedPDX - 8 YR TASK - RT OUTBOARD SEAT TRACK FROM STA FS 853 TO 857 HAS LITE CORROSION ON THE TOP OF THE TRACK AND IN THE CHANNEL. BLENDED CORROSION ON RT OUTBOARD SEAT TRACK FROM FS 853 - FS 857 TO A MAX DEPTH OF .007 INCH IN SEAT TRACK CHANNEL AND .002 INCH ON SDR QXEA2009080600588Seat Track · corrodedPDX - 8 YR TASK - RT OUTBOARD SEAT TRACK FROM STA FS 813 TO 826 HAS LITE CORROSION ON THE TOP OF THE TRACK. BLENDED CORROSION ON RT OUTBOARD SEAT TRACK FROM FS 813 - FS 826 TO A MAX DEPTH OF .002 INCH ON TOP OF SEAT TRACK LIP. ORIGINAL MATERIAL THICKNESS OF SDR QXEA2009080500585Seat Track · corrodedPDX - 8YR TASK - LT OUTBOARD SEAT TRACK AT FS 810.00 HAS CORROSION ON THE TOP OF THE TRACK AND IN THE CHANNEL. BLENDED CORROSION ON LT OUTBOARD SEAT TRACK FS 810, MAX MATERIAL REMOVED IS .010 FOUND TO BE SERVICEABLE IAW 670-53-00-013. COMPLETED REPAIR ON SEASDR QXEA2009080500584Seat Track · corrodedPDX - 8YR TASK - LT OUTBOARD SEAT TRACK AT FS 796.00 HAS CORROSION ON THE TOP OF THE TRACK. BLENDED CORROSION ON LT OUTBOARD SEAT TRACK FS 796, MAX MATERIAL REMOVED .015 ON SURFACE FOUND TO BE SERVICEABLE IAW REO 670-53-00-013. COMPLETED REPAIR ON SEAT TRACKSDR QXEA2009080500583Seat Track · corrodedPDX - 8YR TASK - LT OUTBOARD SEAT TRACK FROM FS 752.00 TO FS 757.00 HAS CORROSION ON THE TOP OF THE TRACK AND IN THE CHANNEL. BLENDED CORROSION ON LT OUTBOARD SEAT TRACK FS 752 TO 757 IS SERVICEABLE IAW REO 670-53-00-013 NOTE 1. MAX MATERIAL REMOVED ON SURFASDR QXEA2009080500582Seat Track · corrodedPDX - 8YR TASK - LT OUTBOARD SEAT TRACK FROM FS 735.00 TO FS 740.00 HAS CORROSION ON THE TOP OF THE TRACK AND IN THE CHANNEL. BLENDED CORROSION ON LT OUTBOARD SEAT TRACK FS 735 TO 740 IS SERVICEABLE IAW REO 670-53-00-013 NOTE 1. MAX MATERIAL REMOVED ON SURFASDR QXEA2009080500581Seat Track · corrodedPDX - 8YR TASK - LT OUTBOARD SEAT TRACK FROM STA FS 699.00 TO FS 708.00 HAS CORROSION ON THE TOP OF THE TRACK AND IN THE CHANNEL. BLENDED CORROSION ON LT OUTBOARD SEAT TRACK FS 699 TO 708, FOUND TO BE SERVICEABLE IAW REO 670-53-00-013 NOTE 1. MAX MATERIAL RESDR QXEA2009080500580Seat Track · corrodedPDX - 8YR TASK - ON THE LT OUTBOARD SEAT TRACK AT FS 643.00 TO FS 663.00 THERE ARE AREAS OF CORROSION. BLENDED CORROSION ON LT O/B SEAT TRACK FS 643 TO 663 FOUND TO BE SERVICEABLE IAW REO 670-53-00-013 NOTE 1. MAX MATERIAL REMOVED ON SURFACE IS .016. COMPLESDR QXEA2009080500579Seat Track · corrodedPDX - 8YR TASK - ON THE LT OUTBOARD SEAT TRACK AT FS 610.00 TO FS 632.00 THERE ARE AREAS OF CORROSION. BLENDED CORROSION ON LT OUTBOARD SEAT TRACK FS 610 TO 632 IS SERVICEABLE IAW REO 670-53-00-013 NOTE 1. MAX MATERIAL REMOVED ON SURFACE IS .015. COMPLETED SDR QXEASeat Track · corrodedPDX - 8YR TASK - ON THE LT OUTBOARD SEAT TRACK AT FS 581.00 TO FS 600.00 THERE ARE AREAS OF CORROSION. BLENDED OUT DAMAGE IAW REO 670-53-00-013 NOTES 1 AND 2. MEASURED AREA, FOUND TO BE WITHIN LIMITS PER REO 670-53-00-013. MAX MATERIAL REMOVED .006. COMPLETSDR QXEA2009080500577Seat Track · corrodedPDX - 8YR TASK - ON THE LT OUTBOARD SEAT TRACK AT FS 557.00 TO FS 568.00 THERE ARE AREAS OF CORROSION. BLENDED OUT DAMAGE IAW REO 670-53-00-013 NOTES 1 AND 2. MEASURED AREA, FOUND TO BE WITHIN LIMITS PER REO 670-53-00-013. MAX MATERIAL REMOVED .006. COMPLESDR QXEA2009080500576Seat Track · corrodedPDX - 8YR TASK - ON THE LT OUTBOARD SEAT TRACK AT FS 522.00 TO FS 536.00 THE SEAT TRACK HAS A GOUGE AND AREAS OF CORROSION. BLENDED OUT DAMAGE IAW REO 670-53-00-013 NOTES 1 AND 2. MEASURED AREA, FOUND TO BE WITHIN LIMITS PER REO 670-53-00-013. MAX MATERIAL SDR QXEA2009080500575Seat Track · corrodedPDX - 8YR TASK - ON THE LT OUTBOARD SEAT TRACK AT FS 490.00 TO FS 501.00 THE SEAT TRACK IS GOUGED AND CORRODED. BLENDED OUT DAMAGE IAW REO 670-53-00-013 NOTES 1 AND 2. MEASURED AREA, FOUND TO BE WITHIN LIMITS PER REO 670-53-00-013. MAX MATERIAL REMOVED .005SDR QXEA2009080500574Seat Track · corrodedPDX - 8YR TASK - LT OUTBOARD SEAT RAIL STA 459.00 TO FS 468.00 HAS LITE CORROSION ON THE TOP OF THE RAIL. BLENDED OUT DAMAGE IAW REO 670-53-00-013 NOTES 1 AND 2. MEASURED AREA, FOUND TO BE WITHIN LIMITS PER REO 670-53-00-013. MAX MATERIAL REMOVED .003. COMSDR QXEA2009080500573Seat Track · corrodedPDX - 8YR TASK - LEFT FWD SEAT RAIL HAS MULTIPLE SPOTS OF CORROSION FROM STA 379.00 TO FS 457.00. BLENDED OUT DAMAGE IAW REO 670-53-00-013 NOTES 1 AND 2. MEASURED AREA, FOUND TO BE WITHIN LIMITS PER REO 670-53-00-013. MAX MATERIAL REMOVED .006. COMPLETED RSDR KCSA091076Seat Track · corrodedMAIN DECK SEAT TRACK CORRODED AT BS 1760 LBL 61.SDR KCSA091075Seat Track · corrodedMAIN DECK SEAT TRACK CORRODED AT BS 1776 RBL 11.SDR KCSA091074Seat Track · corrodedMAIN DECK SEAT TRACK CORRODED AT BS 1720 LBL 99.SDR KCSA091073Seat Track · corrodedMAIN DECK SEAT TRACK CORRODED AT BS 1500, LBL 99.SDR KCSA091072Seat Track · corrodedMAIN DECK SEAT TRACK CORRODED AT BS 460, LBL 66.SDR KCSA091071Seat Track · corrodedMAIN DECK SEAT TRACK CORRODED AT BS 448, LBL 86.SDR WX0A070372Cargo Track · corrodedWHILE IN WORK AT MAINTENANCE BASE; BOW1C/3C/51/54, FOUND LT TIE DOWN TRACK CORRODED BEYOND LIMITS IN AFT CARGO STA 1270-1309, ADDRESSED AS REQUIRED.SDR AALA20090806TUL20Cargo Track · corrodedAFT CARGO LEFT AFT TIE DOWN TRACK CORRODED. INSTALLED NEW LEFT TIE DOWN TRACK STATION 1079-1320 UNDER SRM 51-30-01.SDR AALA20090806TUL09Track · corrodedCORROSION OUT OF LIMITS RIGHT HAND TIE DOWN TRACK. INSTALLED NEW TIE DOWN TRACK FROM 1212 TO 1322 UNDER SRM 53-01.SDR FDEA200907312853Cargo Track · corrodedMAIN DECK CARGO COMPARTMENT FLOOR TRACK X= -75.25 FLANGE FOUND CORRODED BETWEEN STA 1189 TO STA 1209. CORROSION REMOVED AS PER SRM 51-21-01 VOL. 2 REV. 40, MATERIAL REMOVED 0.042", ORIGINAL THICKNESS 0.080", REMAINED THICKNESS 0.038", AND FOUND EXCEEDED LIMISDR FDEA200907312852Cargo Track · corrodedMAIN DECK CARGO COMPARTMENT FLOOR TRACK X=-75.25 FLANGE FOUND CORRODED BETWEEN STA 1285 AND 1305. CORROSION REMOVED AS PER SRM 51-21-01 VOL. 2 REV. 40, MATERIAL REMOVED 0.045", ORIGINAL THICKNESS 0.080", REMAINED THICKNESS 0.035" AND FOUND EXCEEDED LIMIT ASDR FDEA200907312849Cargo Track · corrodedMAIN DECK CARGO COMPARTMENT FLOOR TRACK X=-75.25 FLANGE FOUND CORRODED AT BS 1371. CORROSION REMOVED AS PER SRM 51-21-01 VOL. 2 REV. 40. FOUND TO EXCEEDED LIMITS AS PER SRM 53-70-00 FIG. 3 VOL. 1 REV. 40. REPAIR CARRIED OUT AS PER SRM 53-00-52 FIG 201 REPAIRSDR AALA20090805TUL03Cargo Track · corrodedCORROSION ON LEFT TIE DOWN TRACK, AFT CARGO STATION 1231-1322. REPLACED TIE DOWN TRACK UNDER SRM 51-30-01.SDR AALA20090805TUL02Cargo Track · corrodedCORROSION ON RIGHT TIE DOWN TRACK, AFT CARGO STATION 1212-1309. REPLACED TIE DOWN TRACK STATION 1212-1309 UNDER SRM 53-05-00.SDR ASAA0976310Seat Track · corrodedCORROSION ON SEAT TRACK MAIN CABIN AT BS 380 LBL 23 WL 208. REPAIRED SEAT TRACK.SDR FDEA200907282800Seat Track · corrodedMAIN DECK CARGO - SEAT TRACK FLANGE FROM STA 900 TO STA 935, X = -8.5 FOUND WITH MULTIPLE SURFACE CORROSION. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT AS PER SRM 53-70-00 FIGURE 1 VOLUME I, REVISION 40. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100, REVISDR FDEA200907282798Seat Track · corrodedMAIN DECK CARGO - SEAT TRACK FLANGE FROM STA 1851 TO STA 1891, X = 8.5 FOUND WITH MULTIPLE SURFACE CORROSION. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT AS PER SRM 53-70-00 FIGURE 1 VOLUME I, REVISION 40. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100, REVISDR FDEA200907282797Seat Track · corrodedMAIN DECK CARGO - SEAT TRACK FLANGE AT STA 1890, X = -27.5 FOUND WITH SURFACE CORROSION. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT AS PER SRM 53-70-00 FIGURE 1 VOLUME I, REVISION 40. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100, REVISION 107.SDR FDEA200907282796Seat Track · corrodedMAIN DECK CARGO - SEAT TRACK FLANGE AT STA 1845, X = 27.5 FOUND WITH SURFACE CORROSION. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT AS PER SRM 53-70-00 FIGURE 1 VOLUME I, REVISION 40. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100, REVISION 107.SDR FDEA200907282795Seat Track · corrodedMAIN DECK CARGO - SEAT TRACK FLANGE FROM STA 1851 TO STA 1891, X = 27.5 FOUND WITH MULTIPLE SURFACE CORROSION. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT AS PER SRM 53-70-00 FIGURE 1 VOLUME I, REVISION 40. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100, RESDR A6WA200940462Seat Track · corrodedLT FLOOR SEAT RAIL CORRODED BTW FS 349.00 AND FS 409.00, LBL 9.0 LT FLOOR RAIL REPLACED BTW FS 349.00 AND FS 409.00, LBL 9.00 IAW AMM TASK 53-01-400-802. (K)SDR USAA2009081792150Seat Track · crackedSAL - Q6 - MAJOR REPAIR - CRACK ON SEAT TRACK AT BS 914, RBL 47. REPAIRED SEAT TRACK AT BS 914, RBL 47 IAW B737 SRM 53-00-52.SDR WX0A070363Support Angle · crackedWHILE IN WORK AT MAINTENANCE BASE; BOW 1C/3C/51/54 SEAT TRACK SUPPORT ANGLE FOR NR 2 TRACK AT STA 927 WAS FOUND CRACKED. ADDRESSED AS REQUIRED.SDR ASAA0976263Cargo Track · corrodedCORROSION ON CARGO TRACK. REMOVED AND REPLACED CARGO TRACK BS 767 887 RBL 13.8.
Back to JASC 5347