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 QXEA0200251Seat Track · gougedPDX - LT OUTBOARD SEAT TRACK AT STATION 307.290 TOP LUGS HAVE GOUGES.SDR QXEA0200250Seat Track · corrodedPDX - LT OUTBOARD SEAT TRACK AT STATION 287.605 HAS A 3 INCH AREA IN THE CHANNEL THAT HAS CORROSION.SDR QXEA0200211Seat Track · corrodedPDX- RIGHT HAND INBOARD SEAT TRACK FROM FRAME 10346, FORWARD ABOUT THREE INCHES ON MATTING FLANGE THERE IS CORROSION. REPAIRED IAW FOKKER SRM 53-01-01 PAGE 8, 53-40-01 PAGE 206 AND 51-10-04 PAGE 9.SDR MALA020162Seat Track · corrodedDURING C2-CHECK IN CVG, CORROSION DISCOVERED ON NR 4 SEAT RAIL BETWEEN FRAMES 18 & 20 THAT EXCEEDED SRM LIMITS. SEAT RAIL REMOVED BETWEEN FRAMES 18 & 20 AND REPLACED IAW SRM 53-00-32, BARA/AVR/5765/02 DC AND EO 53026 DURING C-CHECK INTERVAL.SDR MALA020161Seat Track · corrodedDURING C2-CHECK IN CVG, CORROSION DISCOVERED ON NR 3 SEAT RAIL BETWEEN FRAMES 18 & 20 THAT EXCEEDED SRM LIMITS. SEAT RAIL REMOVED BETWEEN FRAMES 18 AND 20, REPLACED IAW SRM 53-00-32, BARA/AVR 5765/02-DC AND EO 53026 DURING C-CHECK INTERVAL.SDR TSAA0253048Seat Track · damagedCUT AND REMOVED THE DAMAGED PORTION OF THE TRACK AT BS 420 TO 480. FABRICATED NEW SEAT TRACK. INSTALLED THE REPAIR PARTS IAW SRM 53-10-5, FIGURE 7. AIRCRAFT RETURNED TO SERVICE. (M)SDR AALA20020184Seat Track · corrodedTUL - FOUND CORROSION ON NR 1 SEAT TRACK AROUND LUG HOLE. INSTALLED SEAT TRACK LUG REPAIR SRM 53-05-00 FIG 4A. (M)SDR ASAA0280020Seat Track · corrodedPAE - DURING 30K CHECK, FOUND CORROSION ON SEAT TRACK AT FUSELAGE STATIONS, 1118, 1152, AND 1160, AT BUTTOCK STATION X PLUS 54, AND WATERLINE 2-2. REPAIRED SEAT TRACK PER SRM 53-05, FIG 4F. (M)SDR ZW0A0201803Cargo Track · corrodedDURING CHECK-C MAINT IN THE AFT CARGO COMPARTMENT FOUND CORROSION ON FLOOR TRACK AT STA 1211 TO 1320, RT TRACK. REPLACED TRACK PER SPM 6-70-01-4B, AND SRM 51-30-01.SDR ZW0A0201802Cargo Track · corrodedDURING CHECK-C MAINT IN THE AFT CARGO COMPARTMENT FOUND CORROSION ON THE LT TIE DOWN TRACK FROM STA 1003 TO 1231. INSTALLED NEW TIE DOWN TRACK PER SPM 6-70-01-4B, AND SRM 51-30-01.SDR UPS02437584Seat Track · corrodedINSPECTION TYPE:C M/D - BS 500 RBL 97 SEAT TRACK FLANGE FOUND CORROSION DAMAGED. SEAT TRACK REPLACED AS PER SRM 51-10-01.SDR CALA0200065Seat Track · crackedINSPECTION FOUND A 1/2" CRACK IN R/H O/B SEAT TRACK AT STA 727B, RBL 45.57. A DOUBLER REPAIR WAS INSTALLED IAW ECRA 5321-01123.SDR CALA0200062Seat Track · corrodedINSPECTION FOUND L/H O/B SEAT TRACK CORRODED AT STA 380-540. THE CORROSION WAS REMOVED IAW SRM 53-00-52. THE AREA AT STA 410 WAS BEYOND ALLOWABLE LIMITS. THE SEAT TRACK WAS REMOVED AND REPLACED FROM STA 380-480 IAW SRM 53-00-52. THE SEAT TRACK WAS TREATED AND SDR ASOA02088Seat Track · corrodedDURING C-CHECK INSPECTION IN BNA, THE RIGHT FLOOR SEAT TRACK WAS FOUND CORRODED ON THE FORWARD SECTION BETWEEN FRAMES 15 AND 22 AND 31. MAINTENANCE FABRICATED AND DRILLED NEW SEAT TRACKS IAW SRM 51-25-00. THE OLD SEAT TRACKS WERE REMOVED AND THE NEW ONES INSSDR ASOA02087Seat Track · corrodedDURING C-CHECK INSPECTION IN BNA, THE LEFT FLOOR SEAT TRACK, MID SECTION, WAS FOUND CORRODED BETWEEN FRAMES 22 AND 32. CORROSION WAS ALSO FOUND ON THE LEFT SEAT TRACK, FORWARD SECTION, BETWEEN FRAMES 17 AND 22 AS WELL AS THE AFT SECTION FROM FRAME 32 AND 39. SDR QXEA0200220Seat Track · gougedPDX- RT INBOARD SEAT TRACK FROM FRAME 15635 TO FRAME 12405 HAS GOUGED LUGS. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 206.SDR AALA20020221Seat Track · corrodedTUL - FOUND CORROSION IN NR 4 SEAT TIE-DOWN TRACK AT STATION 237. REMOVED CORRODED TRACK SECTION. SPLICED IN NEW TRACK SECTION, STATION 200 TO 265, PER SRM 53-05-00. (M)SDR C1HA200282007Seat Track · corrodedSEAT TRACK CHANNEL AT RBL 54 STA. 344 CORRODED (C CHECK FINDING) REPLACED SEAT TRACK SECTION PER SRM.SDR 02FDEA00130Cargo Track · crackedSTA 959 UPPER CARGO SEAT TRACK HAS 10 INCH CRACK C/T RADIUS AT SPLICE X-27.SDR MALA020159Seat Track · corrodedDURING C2-CHECK IN CVG, CORROSION DISCOVERED ON NR 1 SEAT RAIL TOP FLANGES AT FRAMES 18 & 20 THAT EXCEEDED SRM LIMITS. AC REWORKED (CORROSION REMOVED) AND APPROVED FOR RETURN TO SERVICE IAW BARA/AVR5752/02-DC.SDR UPS02437592Seat Track · corrodedINSPECTION TYPE:C M/D - BS 218 RBL 45 SEAT TRACK FLANGE CORRODED. SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A.SDR UPS02437582Seat Track · corrodedINSPECTION TYPE:C M/D - SEAT TRACK FOUND CORROSION AT BS 2225 RBL 75 AFTER FLOOR PANEL REMOVED. SEAT TRACK REPLACED AS PER SRM 51-10-01.SDR UPS02437599Seat Track · corrodedINSPECTION TYPE:C M/D - BS 2196 RBL 11 SEAT TRACK CROWN FOUND CORRODED. BS 2190 - 2250 RBL 11 SEAT TRACK REPLACED PER SRM 51-10-01.SDR CALA0200057Seat Track · crackedINSPECTION FOUND FOUR 1/2 INCH CRACKS IN SEAT TRACK FRAME AT STA 727B. A STRAP REPAIR WAS INSTALLED AT EACH LOCATION IAW ECRA 5321-01122.SDR UPS02437630Cargo Track · corrodedINSPECTION TYPE:C AFT CARGO COMPT - RBL 46 BS 1860 - 1900 TIE DOWN TRACK CORRODED. TIE DOWN TRACK REPAIRED AS PER SRM 53-10-05 FIG 5.SDR UPS02437629Cargo Track · corrodedINSPECTION TYPE:C AFT CARGO COMPT - RBL 25 BS 1870 TIE DOWN TRACK CORRODED DAMAGED. TIE DOWN TRACK REPAIRED AS PER SRM 53-10-05 FIG 5.SDR SWIA200210669Seat Track · corrodedRIGHT SIDE UPPER SEAT TRACK HAS SIGN OF CORROSION AT SCREW HOLES AND NEEDS REPLACED. REMOVED AND REPLACED RIGHT SIDE UPPER SEAT TRACK WITH NEW AS REQUIRED IAW EMB120 MM 53-01-04.SDR ZW0A0201304Cargo Track · corrodedDURING CHECK-C MAINT IN THE AFT CARGO COMPARTMENT LT SIDE, TIE DOWN TRACK FROM STATION 1220 TO 1308 IS CORRODED BEYOND LIMITS. NEW SECTION OF TRACK WAS INSTALLED PER SRM 51-30-01.SDR ZW0A0201303Cargo Track · corrodedDURING CHECK-C MAINT IN THE AFT CARGO COMPARTMENT, RT SIDE AT STATION 1212 TO 1308, FOUND RT TIE DOWN TRACK CORRODED BEYOND LIMITS. INSTALLED NEW SECTION OF TRACK FROM STATION 1202 TO 1322, PER SPM 6-70-01 PAGES 1-3.SDR QXEA0200127Seat Track · corrodedPDX - LT OUTBOARD SEAT TRACK HAS PITTING CORROSION INSIDE CHANNEL AT STATION X405.737. REPAIRED IAW RD 8-53-1352 AND DHC-8 SRM 51-40-00.SDR QXEA0200125Seat Track · corrodedPDX - LT OUTBOARD SEAT TRACK HAS PITTING CORROSION INSIDE CHANNEL AT STATION X456.500. REPAIRED IAW RD 8-53-1342, DHC-8 SRM 51-40-11 AND SRM 51-40-00.SDR QXEA0200124Seat Track · corrodedPDX - LT OUTBOARD SEAT TRACK HAS TOP SURFACE CORROSION AT STATION X516.000. REPAIRED IAW RD 8-53-3644, STEP 4, PAGE 3.SDR QXEA0200123Seat Track · corrodedPDX - LT OUTBOARD SEAT TRACK HAS SCRATCHES AND LIGHT PITTING CORROSION INSIDE CHANNEL AT STATION X545.000. REPAIRED IAW RD 8-53-3644, STEP 4, PAGE 3.SDR UPS02437593Seat Track · corrodedINSPECTION TYPE:C M/D BS 1900 RBL 97 SEAT TRACK CROWN CORROSION FOUND. SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A.SDR UPS02437575Seat Track · corrodedINSPECTION TYPE:C M/D - BS 1780 RBL 95 SEAT TRACK CROWN FOUND CORRODED. SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A.SDR UPS02437637Seat Track · corrodedINSPECTION TYPE:C M/D - BS 1820 RBL 97 SEAT TRACK CROWN FOUND CORRODED. SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A.SDR UPS02437636Seat Track · corrodedINSPECTION TYPE:C M/D - BS 1740 RBL 97 SEAT TRACK CROWN FOUND CORRODED. SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A.SDR UPS02437635Seat Track · corrodedINSPECTION TYPE:C M/D - BS 1860 RBL 97 SEAT TRACK CROWN FOUND CORRODED. SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A.SDR ZW0A0201306Cargo Track · corrodedDURING CHECK-C MAINT IN THE AFT CARGO COMPARTMENT RT SIDE, TIE DOWN TRACK FROM STATION 1212 TO 1322 WAS FOUND CORRODED BEYOND LIMITS. NEW SECTION OF TRACK WAS INSTALLED FROM STATION 1212 TO 1322 PER SRM 51-30-02/05.SDR ZW0A0201305Cargo Track · corrodedDURING CHECK-C MAINT IN THE AFT CARGO COMPARTMENT AT STATION 1079 TO 1155 RT SIDE, TIE DOWN TRACK WAS FOUND CORRODED BEYOND LIMITS. NEW SECTION OF TRACK WAS INSTALLED FROM STATION 1079 TO 1155 PER SRM 53-05 PG 10.SDR GTIA020223Seat Track · gougedFTW - FOUND RIGHT OUTBOARD SEAT TRACK HAS GOUGES AT STATIONS 655, 687, 716. REMOVED GOUGES AT STATION 716. REMOVED TRACK SECTION FROM 702-722. LOCATED AND DRILLED AND COUNTERSINKING. INSTALLED SEAT TRACK AND SPLICE IAW MD80 SRM 51-30-5. (M)SDR UPS02437663Seat Track · corrodedINSPECTION TYPE:C M/D - BS 423 LBL 10 SEAT TRACK FLANGE CORRODED. SEAT TRACK REPLACED PER SRM 51-10-01 PG 8.SDR UPS02437601Seat Track · corrodedINSPECTION TYPE:C M/D - BS 260 - 280 LBL 33 SEAT TRACK FLANGE CORRODED. SEAT TRACK REPAIRED AS PER SRM 51-10-05 FIG 1A.SDR AALA20020130Seat Track · corrodedTUL - FOUND SEVERAL AREAS OF CORROSION ON NR 6 SEAT TRACK STATION 1031-1309. REPLACED NR 6 SEAT TRACK FROM STATION 1031-1309 PER SRM 51-01. (M)SDR 2002F00153Seat Track · corrodedDURING CPCP2 AND 4 INSPECTIONS, CORROSION WAS FOUND ON 4 CABIN SEAT TRACKS, LEFT INBOARD MIDDLE, LEFT FLIGHT ATTENDANT, RIGHT MIDDLE INBOARD, RIGHT AFT INBOARD. THE SEAT TRACKS WERE REMOVED AND REPLACED IAW AE EO E2-53MR-115R1. THE AIRCRAFT WAS RETURNED TO SSDR 2002F00152Seat Track · corrodedDURING CPCP2 AND 4 INSPECTIONS, CORROSION WAS FOUND ON 4 CABIN SEAT TRACKS, LEFT INBOARD MIDDLE, LEFT FLIGHT ATTENDANT, RIGHT MIDDLE INBOARD, RIGHT AFT INBOARD. THE SEAT TRACKS WERE REMOVED AND REPLACED IAW AE EO E2-53MR-115R1. THE AIRCRAFT WAS RETURNED TO SSDR 2002F00151Seat Track · corrodedDURING CPCP2 AND 4 INSPECTIONS, CORROSION WAS FOUND ON 4 CABIN SEAT TRACKS, LEFT INBOARD MIDDLE, LEFT FLIGHT ATTENDANT, RIGHT MIDDLE INBOARD, RIGHT AFT INBOARD. THE SEAT TRACKS WERE REMOVED AND REPLACED IAW AE EO E2-53MR-115R1. THE AIRCRAFT WAS RETURNED TO SSDR SIMA200202805Seat Track · corrodedDURING CPCP2 AND 4 INSPECTIONS, CORROSION WAS FOUND ON 4 CABIN SEAT TRACKS, LEFT INBOARD MIDDLE, LEFT FLIGHT ATTENDANT, RIGHT MIDDLE INBOARD, RIGHT AFT INBOARD. THE SEAT TRACKS WERE REMOVED AND REPLACED IAW AE EO E2-53MR-115R1. THE AIRCRAFT WAS RETURNED TO SSDR QXEA0200143Seat Track · corrodedPDX - RT INBOARD NR 7 SEAT TRACK HAS PITTING CORROSION IN BOTTOM OF CHANNEL AND ON TOP RAILS BETWEEN STATION X281 AND X284. REPAIRED IAW DHC-8 RD 8-53-1339, RD 8-53-2295 AND SRM 51-40-11.SDR QXEA0200142Seat Track · corrodedPDX - RT INBOARD NR 8 SEAT TRACK HAS CORROSION BELOW OUTBOARD LUG IN CHANNEL AT STATION X440. REPAIRED IAW DHC-8 RD 8-53-1339, SRM 51-20-16 AND SRM 51-20-56.
Back to JASC 5347