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 QXEA0002655Seat Track · gougedPDX- LEFT HAND CABIN SEAT TRACK, INSIDE CHANNEL HAS 2 GOUGES WITH SOME PITTING CORROSION BETWEEN FRAME 9305C - 9805. REPAIRED IAW FOKKER 51-10-4, PAGE 9 AND SRM 53-40-01, PAGE 201-206.SDR QXEA0002654Seat Track · corrodedPDX- LEFT HAND INBOARD CABIN SEAT TRACK, INSIDE CHANNEL HAS A CORROSION PIT MARKED AT FRAME 9305C. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9, AND SRM 53-40-01, PAGE 201-206.SDR TWAA0015201Seat Track · corrodedDURING CHECK-C MAINT IN THE AFT CARGO COMPT, CORROSION WAS FOUND ON THE LOWER LIP OF CABIN CHAIR TRACK AT CLIP NUT AREA, STA 1224, LBL 23. REMOVED OLD CHAIR TRACK AND INSTALLED NEW TRACK FROM STA 1085 TO 1309, WITH SPLICE AT STA 1085, PER SRM 53-05, FIG 4F.SDR SIMA2626Seat Track · corrodedABI - FOUND SEAT TRACK BL 18.3L WAS FOUND TO BE BEYOND LIMITS AFTER REMOVAL OF CORROSION. MAINTENANCE REMOVED AND REPLACED THE AFT 67 INCHES OF SEAT TRACK BL 18.3L IAW SAAB REPAIR STATMENT 72SDS0795 AND SRM. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR SIMA2627Seat Track · corrodedABI - FOUND SEAT TRACK AT BL 18.3L WAS FOUND TO BE CORRODED BEYOND SRM LIMITS. MAINTENANCE REMOVED AND REPLACED THE EXISTING SEAT TRACK IAW SAAB SRM. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR 20001108SH038Pin · shearedTHE ROLL PIN THAT HOLDS THE LOCK MECHANISM FOR THE CARGO TIE-DOWN FITTING, PN 22555-71, SHEARED CAUSING THE CARGO STRAP TO COME LOOSE AND THE LOAD TO SHIFT. THE LOAD SHIFT CAUSED THE AIRCRAFT IN QUESTION TO FALL ONTO THE TAIL TIE-DOWN AFTER THE ENGINE WAS SHUSDR MALA000615Seat Track · corrodedFOUND DURING C-CHECK, SEAT TRACK AND FLOOR BOARD FLANGES HAVE CORROSION AT LBL 18 FROM STA 622 TO STA 589. REFER TO CELSIUS TASK CARD 1540 W/O18843 AND SAAB STATEMENT 340SDS000144. MAINTENANCE REMOVED CORROSION AS REQUIRED IAW SRM 51-70-40 MATERIALS ON FLANGSDR MALA000614Seat Track · corrodedFOUND DURING C-CHECK, SEAT TRACK AND FLOOR BOARD FLANGES HAVE CORROSION AT BL 0 FROM STA 622 TO STA 689. REFER TO CELSIUS TASK CARD 1541, W/O 18843 AND SAAB STATEMENT 340SDS000144. MAINTENANCE REMOVED CORROSION AS REQUIRED IAW 51-70-40 MATERIAL ON FLANGES OUSDR 00FDEA00664Seat Track · crackedMAIN DECK (BALL MAT AREA) - LEFT BS 635, LBL 8.K, SEAT TRACK FOUND CRACKED. *S/D* REMOVED AND REPLACED PER SRM 53-70-00 FIG 1, VOL I & 51-33-01 VOL II. FLOOR PANEL 233EF & 233FF REMOVED FOR ACCESS AND REINSTALLED PER 53-21-04-4.SDR TWAA0014808Seat Track · corrodedDURING CHECK-C MAINT, FOUND CORROSION ON O/B CHAIR TRACK, STA 746, RBL 44. REMOVED CORROSION PER SPM 6-80-01. TREATED METAL PER SRM 51-10-3.SDR TWAA0014807Seat Track · corrodedDURING CHECK-C MAINT, FOUND I/B FLANGE OF CHAIR TRACK WITH CORROSION AT CLIP NUT AREAS, STA 1195 TO 1305, LBL 22. INSTALLED NEW TRACK FROM STA 1088 TO 1309 PER SRM 53-05 AND 51-301.SDR TWAA0014805Seat Track · corrodedDURING CHECK-C MAINT FOUND CORROSION ON NUMBER 3 CHAIR TRACK BEYOND REPAIR AT LBL 22, STA 1088 TO 1309. INSTALLED NEW TRACK FROM STA 1088 TO 1309 PER SRM 53-05, FIG 4F AND 51-30-1.SDR QXEA0002646Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK INSIDE CHANNEL HAS 4 SPOTS OF CORROSION 3 INCHES TO 6 INCHES FORWARD OF FRAME 6805. REPAIRED IAW FOKKER SRM 51-10-04 PAGE 9 AND 53-40-01.SDR QXEA0002645Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK, INBOARD FLANGE HAS FRETTING CORROSION BETWEEN FRAMES 6305 AND 8305. REPAIRED IAW FOKKER SRM 51-10-04 PAGE 9 AND 53-40-01.SDR QXEA0002644Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK OUTBOARD FLANGE HAS FRETTING CORROSION 8 INCHES LONG, STARTING AT THE AFT SIDE OF FRAME 5805. REPAIRED IAW FOKKER SRM 51-10-04 PAGE 9 AND 53-40-01.SDR QXEA0002643Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK INSIDE CHANNEL HAS 2 INCH LONG GOUGE MARKS WITH PITTING CORROSION BETWEEN FRAME 5805 AND 6305. REPAIRED IAW FOKKER SRM 51-10-04 PAGE 9 AND 53-40-01.SDR QXEA0002642Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK INSIDE CHANNEL HAS 2 SPOTS OF CORROSION LOCATED 6 INCHES FORWARD OF STATION 5805. REPAIRED IAW FOKKER SRM 51-10-04 PAGE 9 AND 53-40-01.SDR QXEA0002683Seat Track · corrodedPDX- RIGHT HAND OUTBOARD SEAT TRACK HAS SCRATCHES AND CORROSION PITS INSIDE CHANNEL BETWEEN FRAME 11905 AND 13345. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9 AND SRM 53-40-10, PAGE 201-206.SDR QXEA0002679Seat Track · corrodedPDX- RIGHT HAND INBOARD SEAT TRACK HAS FRETTING CORROSION ON INBOARD FLANGE AT FRAME 11405. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9 AND SRM 53-40-10, PAGE 201-206.SDR QXEA0002678Seat Track · corrodedPDX- RIGHT HAND INBOARD SEAT TRACK, INSIDE CHANNEL HAS PITTING CORROSION AT FRAME 10966. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9 AND SRM 53-40-10, PAGE 201-206.SDR QXEA0002677Seat Track · corrodedPDX- RIGHT HAND INBOARD SEAT TRACK, INSIDE CHANNEL HAS GOUGES AND PITTING CORROSION BETWEEN FRAME 10346 AND 10790. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9 AND SRM 53-40-10, PAGE 201-206.SDR QXEA0002676Seat Track · corrodedPDX- RIGHT HAND INBOARD SEAT TRACK, INSIDE CHANNEL HAS PITTING CORROSION FORWARD OF FRAME 10346. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9 AND SRM 53-40-10, PAGE 201-206.SDR QXEA0002675Seat Track · corrodedPDX- RIGHT HAND INBOARD SEAT TRACK HAS FRETTING CORROSION ON INBOARD FLANGE BETWEEN FRAME 9805 AND 10346. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9, AND SRM 53-40-10, PAGE 201-206.SDR QXEA0002674Seat Track · corrodedPDX- RIGHT HAND INBOARD SEAT TRACK, INSIDE CHANNEL HAS PITTING CORROSION FROM FRAME 9305C TO SPLICE JUST FORWARD OF 9805. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9 AND SRM 53-40-10, PAGE 201-206.SDR QXEA0002673Seat Track · corrodedPDX- RIGHT HAND INBOARD SEAT TRACK HAS FRETTING CORROSION ON INBOARD FLANGE AT FRAME 9305C. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9 AND SRM 53-40-10, PAGE 201-206.SDR QXEA0002672Seat Track · corrodedPDX- RIGHT HAND INBOARD SEAT TRACK INSIDE CHANNEL HAS CORROSION AT INBOARD CORNER OF CHANNEL BETWEEN 8805 AND 9305 FRAME. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9 AND SRM 53-40-10, PAGE 201-206.SDR QXEA0002671Seat Track · corrodedPDX- RIGHT HAND INBOARD SEAT TRACK HAS FRETTING CORROSION ON INBOARD FLANGE AFT OF FRAME 8805. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9, AND SRM 53-40-10, PAGE 201-206.SDR QXEA0002670Seat Track · corrodedPDX- RIGHT HAND INBOARD SEAT TRACK INSIDE CHANNEL HAS CORROSION INBOARD CORNER OF CHANNEL AFT SIDE OF FRAME 6805. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9, AND SRM 53-40-10, PAGE 201-206.SDR QXEA0002669Seat Track · corrodedPDX- RIGHT HAND CABIN SEAT TRACK INSIDE CHANNEL HAS CORROSION PITS JUST FORWARD OF FRAME 6805. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9, AND SRM 53-40-10, PAGE 201-206.SDR QXEA0002662Seat Track · corrodedPDX- LEFT HAND CABIN SEAT TRACK HAS GOUGES WITH CORROSION AT FRAME 11905. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9, AND SRM 53-40-10, PAGE 201-206.SDR QXEA0002661Seat Track · corrodedPDX- LEFT HAND CABIN SEAT TRACK, INSIDE CHANNEL HAS GOUGES WITH SURFACE CORROSION BETWEEN FRAME 11905 TO 12405. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9, AND SRM 53-40-10, PAGE 201-206.SDR QXEA0002660Seat Track · gougedPDX- LEFT HAND CABIN SEAT TRACK HAS GOUGES INSIDE CHANNEL THAT HAVE CORROSION BETWEEN FRAME 10966 TO 11405. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9, AND SRM 53-40-10, PAGE 201-206.SDR QXEA0002659Seat Track · corrodedPDX- LEFT HAND CABIN SEAT TRACK HAS A GOUGE WITH CORROSION ON TOP SURFACE OF CHANNEL AT FRAME 10966. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9 AND SRM 53-40-01, PAGE 201-206.SDR TWAA0014910Seat Track · corrodedDURING OP 15 MAINT CHECK, FOUND CORROSION ON NUMBER 3 CHAIR TRACK, STA 925 TO 965. REPLACED TRACK AT STA 927 TO 965 PER SRM 53-05, FIG 4D. NAS 6203 BOLTS USED, REPLACEMENT FOR NAS 1103 BOLT PER SRM 51-60-0.SDR RAIA0009042Seat Track · corrodedMX-STL- DURING MAINTENANCE CHECK, FOUND LEFT INBOARD SEAT TRACK HAS CORROSION FROM FUSELAGE FRAME 33 TO 36. MAINTENANCE REPLACED LEFT INBOARD SEAT TRACK FROM FUSELAGE FRAME 33 TO 36 IAW ATR72 SRM.SDR RAIA0009038Seat Track · corrodedMX-STL- DURING MAINTENANCE CHECK, FOUND CORROSION AT RIGHT INBOARD SEAT TRACK FROM FUSELAGE FRAME 33 TO 36. MAINTENANCE REPAIRED RIGHT INBOARD SEAT TRACK FROM FUSELAGE FRAME 33 TO 36 IAW ATR72 SRM.SDR RAIA0009037Seat Track · corrodedMX-STL- DURING MAINTENANCE CHECK, FOUND CORROSION AT RIGHT OUTBOARD SEAT TRACK BETWEEN FUSELAGE FRAMES 33 TO 36. MAINTENANCE REPAIRED RIGHT OUTBOARD SEAT TRACK BETWEEN FUSELAGE FRAMES 33 TO 36 IAW ATR72 SRM.SDR ASAA0080605Cargo Track · corrodedPHX - DURING SCHEDULED C-CHECK, THE LEFT TIE-DOWN TRACK AT STA 1212 TO STA 1232 SCREW HOLES WERE FOUND CORRODED. REPAIRED PER SRM. (X)SDR F3LA00245Galley Track · corrodedDEN - DURING C-3 CHECK INSPECTION, REPORTED CORROSION ON NR 1 GALLEY OUTBOARD TRACK STATION 294, RBL 42. MAINTENANCE FABRICATED AND INSTALLED REPLACEMENT TRACK PER SRM 53-10-5, FIG 5. (M)SDR F3LA00244Galley Track · corrodedDEN - DURING C-3 CHECK INSPECTION, REPORTED CORROSION ON NR 1 GALLEY TRACK, HORIZONTAL FLANGE, STATION 290, BL 18R. MAINTENANCE REMOVED CORROSION PER SRM 53-10-1. FABRICATED NEW TRACK PER SRM 51-20-2, TREATED AND PRIMED PER SRM 51-10-2 AND INSTALLED PER SRM SDR QXEA0002639Seat Track · corrodedPDX- LEFT HAND OUTBOARD SEAT TRACK INSIDE CHANNEL HAS PITTING CORROSION AT FRAME 12405. REPAIRED IAW FOKKER SRM 51-10-4 PAGE 9 AND 53-40-01.SDR QXEA0002668Seat Track · corrodedPDX- RIGHT HAND INBOARD SEAT TRACK HAS FRETTING CORROSION ON INBOARD FLANGE AT FRAME 6305. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9, AND SRM 53-40-10, PAGE 201-206.SDR QXEA0002663Seat Track · corrodedPDX- LEFT HAND CABIN SEAT TRACK HAS FRETTING CORROSION ON BOTH FLANGE BETWEEN FRAME 11405 TO 12405. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9, AND SRM 53-40-10, PAGE 201-206.SDR QXEA0002826Seat Track · corrodedPDX- LEFT HAND OUTBOARD SEAT TRACK INSIDE CHANNEL HAS TWO LONG GOUGE MARKS WITH PITTING CORROSION FROM STATION 5805 - 6305. REPAIRED IAW FOKKER SRM 51-10-4 PAGE 9 AND 53-40-01.SDR QXEA0002744Seat Track · corrodedPDX- CORROSION ON FLOOR STRUCTURE BENEATH PILOTS OUTBOARD SEAT TRACK. REPAIRED IAW FOKKER SRM 51-10-4 PAGE 9.SDR QXEA0002640Seat Track · corrodedPDX- LEFT HAND OUTBOARD SEAT TRACK INSIDE CHANNEL HAS PITTING CORROSION 5 INCHES AFT OF FRAME 13345. REPAIRED IAW FOKKER SRM 51-10-04 PAGE 9 AND 53-40-01.SDR QXEA0002637Seat Track · corrodedPDX- LEFT HAND OUTBOARD SEAT TRACK HAS FRETTING CORROSION AROUND A CAMLOCK RECEPTICLE ON THE INBOARD FLANGE AT STATION 12531. REPAIRED IAW FOKKER SRM 51-10-04 PAGE 9 AND 53-40-01.SDR QXEA0002634Seat Track · gougedPDX- LEFT HAND OUTBOARD SEAT TRACK INSIDE CHANNEL HAS TWO 10 INCH LONG GOUGES AT STATION 7805. REPAIRED IAW FOKKER SRM 51-10-04 PAGE 9 AND 53-40-01.SDR QXEA0002692Seat Track · corrodedPDX- RIGHT HAND OUTBOARD SEAT TRACK, INSIDE CHANNEL HAS PITTING CORROSION AT FRAME 7805 AND FORWARD OF 7805. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9 AND SRM 53-40-10, PAGE 201-206.SDR QXEA0002691Seat Track · corrodedPDX- RIGHT HAND OUTBOARD SEAT TRACK, INSIDE CHANNEL HAS PITTING CORROSION AFT OF FRAME 7305. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9 AND SRM 53-40-10, PAGE 201-206.
Back to JASC 5347