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 UPS01435423Seat Track · crackedINSPECTION TYPE:C6 M/D - BS 2240 - 2280 LBL 11 SEAT FLANGE FOUND CHIPPED & CRACKED AS MARKED. SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 14.SDR QXEA0100276Seat Track · groovedPDX-12 INCH GROOVE WORN ON RIGHT HAND INBOARD SEAT TRACK STATION 450. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36, AND RD-8-53-1339.SDR QXEA0100275Seat Track · groovedPDX-15 INCH GROOVE ON RIGHT HAND INBOARD SEAT TRACK BETWEEN STATION 467 - 488. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36, AND RD-8-53-1339.SDR QXEA0100274Seat Track · groovedPDX-12 INCH GROOVE ON RIGHT HAND INBOARD SEAT TRACK STATION 510. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36, AND RD-8-53-1339.SDR QXEA0100273Seat Track · corrodedPDX-FRETTING CORROSION ON LEFT HAND INBOARD SEAT TRACK STATION 545. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36, AND RD-8-53-3644.SDR AALA20010440Seat Track · corrodedTUL - FOUND NR 2 SEAT TRACK CORRODED 1 INCH BY 92 INCHES, LEFT SIDE OF MOUNTING FLANGE AND TOP OF TRACK, STATION 1214 TO 1306. INSTALLED NEW NR 2 SEAT TRACK FROM STATION 1174 TO 1309 IAW SRM 53-05 PART 1 FIG 4F, SHEET 1. (M)SDR QXEA0100435Seat Track · corrodedPDX-CORROSION ON OUTBOARD FLANGE OF RIGHT HAND INBOARD SEAT TRACK, STATION 580-600 (CARGO PIT). REPAIRED IAW DHC-8 SRM 51-20-16, SRM 51-20-36, AND RD-8-53-784.SDR MALA010327Seat Track · corrodedFOUND DURING C-CHECK, CORROSION ON IB FLOOR SUPPORT FLANGE, SEAT TRACK LBL 18.3 FROM FS 465 THRU FS 630. MAINTENANCE REMOVED CORROSION FROM STA 465-630 AS WORKED IAW 51-70-40. MATERIAL REMOVED IS WITHIN LIMITS IAW SRM 53-70-60. ALODINED, PRIMED AND TOPCOATED ASDR QXEA0100280Seat Track · corrodedPDX-LIGHT CORROSION ON LEFT HAND OUTBOARD SEAT TRACK STATION 501. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36, AND RD-8-53-1342.SDR QXEA0100279Seat Track · corrodedPDX-LIGHT CORROSION ON LEFT HAND OUTBOARD SEAT TRACK STATION 465. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36, AND RD-8-53-1342.SDR QXEA0100278Seat Track · corrodedPDX-LIGHT CORROSION ON LEFT HAND SEAT TRACK STATION 456. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36, AND RD-8-53-1342.SDR QXEA0100277Seat Track · groovedPDX-LIGHT CORROSION ON LEFT HAND OUTBOARD SEAT TRACK STATION 436. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36, AND RD-8-53-1342.SDR QXEA0100272Seat Track · corrodedPDX-LIGHT CORROSION ON RIGHT HAND OUTBOARD SEAT TRACK STATION 440. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36, AND RD-8-53-1242.SDR UPS01435429Seat Track · corrodedINSPECTION TYPE:C6 CABIN - M/D FLOOR TIE DOWN TRACK (BS 1920-1940, LBL 97) CORRODED. SEAT TRACK REPLACED AS PER SRM 53-10-05 FIG 1A. BLEND OUT CORROSION DEPTH 0.038 INCH , WIDTH 1 INCH , LENGTH 3 INCHES.SDR UPS01435360Seat Track · corrodedINSPECTION TYPE:C6 M/D - BS 320-340 RBL 11 SEAT TRACK FLANGE FOUND CORRODED. SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A.SDR DHL2001747528Seat Track · corrodedD-CHECK, SEAT TRACK SECTION STA 851.95 TO 870 RBL 45.5 HAS CORROSION ON INBOARD SECTION OF FLANGE AROUND FASTENER HEADS.SDR ABXA010152Seat Track · corrodedTHE SEAT TRACK AT FUSELAGE STATION 920 HAD A CORRODED FASTENER HOLE. MAINTENANCE INSPECTED AND INSTALLED A NEW SEAT TRACK AT STATION 870 - 940 IAW DC-8 SRM 51-3-0 AND 51-1-21.SDR AALA20010439Cargo Track · corrodedTUL - FOUND RIGHT TIEDOWN TRACK HAS SEVERAL AREAS WITH LIGHT CORROSION AFT CARGO STATION 1231-1322. INSTALLED RIGHT AFT TIEDOWN TRACK FROM 1212 TO 1338, SRM 51-01. (M)SDR MWEA010284Seat Track · damagedONE AREA OF NR 4 SEAT TRACK IS BLENDED BEYOND LIMITS STATION 673. REMOVED DAMAGED AREA, LOCATED, DRILLED AND INSTALLED PLUG AND CHANNEL.SDR DHL2001747526Seat Track · corrodedD-CHECK, SEAT TRACK SECTION STA 950A-870 RBL 45.5 HAS SURFACE CORROSION. REMOVED CORROSION AT SEAT TRACK RBL 45.5 STA 870-950A.SDR ZW0A0100110Seat Track · corrodedDURING CHECK-C MAINT AT CABIN STA 1129 TO 1309, FLOOR TRACK AT LBL 42 IN, FOUND INBD AND OTBD FLANGES HAD CORROSION. REMOVED TRACK NUMBER 2 AT STA 1309 TO 1129. REPLACED TRACK WITH NEW. DRILLED HOLES PER SRM 51-10-4. INSTALLED PER SRM 51-30-1. PRIMED PER SDR AALA20010443Seat Track · corrodedTUL - FOUND CORROSION 2 INCHES BY 19 INCHES INSIDE SEAT TRACK NR 6 FROM STATION 237-256. INSTALLED NEW SECTION OF SEAT TRACK FROM STATION 215-302 PER SRM 53-05 FIG 4F. (M)SDR MALA010286Seat Track · corrodedFOUND DURING C-CHECK, NR 4 SEAT RAIL HAS EVIDENCE OF CORROSION BETWEEN FRAM 18 AND 4.0 INCHES PAST FRAME 20. NR 4 SEAT RAIL WAS REMOVED AND REPLACED BETWEEN THOSE LOCATIONS PER EO A53026 AND SRM 53-00-21-201. REPAIR ACCOMPLISHED DURING C-CHECK.SDR MWEA010256Seat Track · corrodedNR 4 SEAT TRACK BETWEEN STATION 237 - 251 HAS LIGHT CORROSION PRESENT UNDER CLIP NUTS TOP OR BOTTOM SIDE. BLENDED CORROSION, REMOVED DAMAGED SEAT TRACK, LOCATED, DRILLED AND INSTALLED SEAT TRACK.SDR MWEA010255Seat Track · corrodedSTATION 642 TO 661, NR 3 FLOOR TRACK HAS CORROSION IN SEAT TRACK. REMOVED CORROSION, FABRICATED, LOCATED AND INSTALLED SEAT TRACK AND SPLICE.SDR MWEA010239Seat Track · corrodedCORROSION ON TOP OF NR 3 SEAT TRACK, ALSO AROUND FASTENER HOLES ON BOTTOM OF SEAT TRACK SEEN WITH MIRROR TAGGED FROM STATION 200 TO 237. REMOVED SEAT TRACK SECTION, FABRICATED AND INSTALLED REPAIR PARTS AND SEAT TRACK.SDR MWEA020228Seat Track · gougedNR 2 SEAT TRACK IS SCRATCHED AT STATION 620, ALSO A DEEP GOUGE IN OUTBOARD FLANGE. BLENDED SCRATCHES, TRIMMED OUT NR 2 SEAT TRACK, LOCATED HOLE AND INSTALLED PLUG AND CHANNEL.SDR EISA20010071Seat Track · crackedDURING ROUTINE B-CHECK INSPECTION FOUND CRACK IN SEAT TRACK BETWEEN BS 520 AND BS 540 AT LBL 45. FABRICATED AND INSTALLED SEAT TRACK SPLICE, ALODINED AND PRIMED IAW SRM 51-10-2, 53-10-5 FIG 1, AND SOPM 20-50-01.SDR USAA010269Seat Track · corrodedCLT - FOUND SEAT TRACK CORRODED 1 INCH BY 1 INCH, INBOARD FLANGE RBL 24 STATION 1320. INSTALLED NEW SEAT TRACK AND DOUBLER. (M)SDR DHL2001747515Seat Track · corrodedD-CHECK - SEAT TRACK SECTION STA 970-870 HAS AREAS OF LIGHT CORROSION RBL 22.45. REMOVED CORROSION IAW SRM 53-10-1 0.005. MATERIAL LOSS FOUND TO BE WITHIN LIMITS IAW SRM 53-10-01 FIG 3 SHT 5. ALODINED SEAT TRACK IAW SRM 51-10-2, PRIMED IAW SRM 51-40-5.SDR DHL2001747510Seat Track · corrodedD-CHECK, SEAT TRACK SECTION BETWEEN STA 1030-970 LBL 45.0 HAS AREAS OF SURFACE CORROSION 69-46, 47. REMOVED CORROSION IAW SRM 53-10-1 0.005 MATERIAL LOSS FOUND TO BE WITHIN LIMITS IAW SRM 53-10-01 FIG 3 SHT 5. ALODINED SEAT TRACK IAW SRM 51-10-2. PRIMED IAWSDR QXEA0100327Seat Track · corrodedYYC-CABIN SEAT RAIL LEFT HAND HAS MINOR CORROSION. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 7 AND SRM 51-10-04, PAGE 9.SDR QXEA0100326Seat Track · corrodedYYC-CABIN SEAT RAIL RIGHT HAND INBOARD HAS MINOR CORROSION. REPAIRED IAW FOKKER SRM 51-10-01, PAGE 7.SDR DHL2001747524Seat Track · corrodedD-CHECK, SEAT TRACK STA 720D-700 RBL 45.5 HAS CORROSION.SDR MALA010317Seat Track · corrodedFOUND DURING C-CHECK, IN NASHVILLE, TN. IB FLANGE CORRODED ON SEAT TRACK AT LBL 18.3 FROM FUSELAGE STA 294-560. MAINTENANCE REMOVED CORROSION, TRATED WITH ALODINE 1200, MATERIAL REMAINING OUT OF ALLOWABLE LIMITS REF SRM 53-70-60, 51-10-10. PRIMED, PAINTED SEASDR MALA010315Seat Track · corrodedFOUND DURING C-CHECK, IN NASHVILLE, TN. LT FLANGE CORRODED ON SEAT TRACK AT BL.0 FROM FUSELAGE STA 294 TO STA 500. MAINTENANCE REMOVED CORROSION, TREATED WITH AOLDINE 1200, MATERIAL REMAINING WITHIN ALLOWABLE LIMITS. ALODINED, PRIMED AND PAINTED APPLIED AV100 SDR MALA010309Seat Track · corrodedFOUND DURING C-CHECK, IN NASHVILLE, TN. GALLEY SEAT TRACK HAS SEVERAL AREAS OF CORROSION. SEAT TRACK AND PROFILE CORRODED BEYOND LIMITS. LOCATED AND DRILLED NDW SEAT TRACK, ALODINED, PRIMED AND TOPCOATED, INSTALLED SEAT TRACK AND PROFILE IAW SRM 51-40-21,22 ASDR CALA0100183Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 900 - 927, RBL 45. THE CORRODED SECTION OF SEAT TRACK WAS REMOVED AND A REPAIR SECTION OF SEAT TRACK WAS INSTALLED IAW SRM 51-10-02 AND 53-00-52.SDR EIA2001095Cargo Track · corrodedMZJ-EAC - FOUND FORWARD PIT FS 441 TO FS 467 LBL 27 SEAT TRACK UPPER CHORD CORRODED. REPAIRED SEAT TRACK PER ECRA 933-53-097-2. (M)SDR AALA20010465Seat Track · corrodedTUL - FOUND CORROSION ON SEAT TRACK NR 7 AT STATION 1199, 1203. REMOVED CORROSION AND REPLACED CORRODED SEAT TRACK PLUG PER SRM 53-05. (M)SDR AALA20010452Seat Track · corrodedTUL - FOUND NR 1 SEAT TRACK HAS CORROSION 1.5 INCH BY .5 INCH BY .050 AT STATION 1235 TO 1236. BLENDED OUT CORROSION, INSTALLED SEAT TRACK PLUG PER AARD 53-20-00-10. (M)SDR UPS01835332Seat Track · corrodedINSPECTION TYPE, C2, 3, STA 585 - 595 LBL 60 SEAT TRACK IS CORRODED BEYOND LIMITS. REPAIRED SEAT TRACK.SDR 20010425AP030Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION MAINTENANCE REPORTED THE LEFT FORWARD INBOARD, LEFT MIDDLE OUTBOARD, LEFT AFT OUTBOARD, LEFT AFT INBOARD, LEFT FLIGHT ATTENDANT, RIGHT FLIGHT ATTENDANT, RIGHT AFT INBOARD, RIGHT AFT OUTBOARD, AND RIGHT FORWARD INBOARD SEAT TRACKSSDR 20010425AP029Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION MAINTENANCE REPORTED THE LEFT FORWARD INBOARD, LEFT MIDDLE OUTBOARD, LEFT AFT OUTBOARD, LEFT AFT INBOARD, LEFT FLIGHT ATTENDANT, RIGHT FLIGHT ATTENDANT, RIGHT AFT INBOARD, RIGHT AFT OUTBOARD, AND RIGHT FORWARD INBOARD SEAT TRACKSSDR 20010425AP028Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION MAINTENANCE REPORTED THE LEFT FORWARD INBOARD, LEFT MIDDLE OUTBOARD, LEFT AFT OUTBOARD, LEFT AFT INBOARD, LEFT FLIGHT ATTENDANT, RIGHT FLIGHT ATTENDANT, RIGHT AFT INBOARD, RIGHT AFT OUTBOARD, AND RIGHT FORWARD INBOARD SEAT TRACKSSDR 20010425AP027Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION MAINTENANCE REPORTED THE LEFT FORWARD INBOARD, LEFT MIDDLE OUTBOARD, LEFT AFT OUTBOARD, LEFT AFT INBOARD, LEFT FLIGHT ATTENDANT, RIGHT FLIGHT ATTENDANT, RIGHT AFT INBOARD, RIGHT AFT OUTBOARD, AND RIGHT FORWARD INBOARD SEAT TRACKSSDR 20010425AP026Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION MAINTENANCE REPORTED THE LEFT FORWARD INBOARD, LEFT MIDDLE OUTBOARD, LEFT AFT OUTBOARD, LEFT AFT INBOARD, LEFT FLIGHT ATTENDANT, RIGHT FLIGHT ATTENDANT, RIGHT AFT INBOARD, RIGHT AFT OUTBOARD, AND RIGHT FORWARD INBOARD SEAT TRACKSSDR 20010425AP025Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION MAINTENANCE REPORTED THE LEFT FORWARD INBOARD, LEFT MIDDLE OUTBOARD, LEFT AFT OUTBOARD, LEFT AFT INBOARD, LEFT FLIGHT ATTENDANT, RIGHT FLIGHT ATTENDANT, RIGHT AFT INBOARD, RIGHT AFT OUTBOARD, AND RIGHT FORWARD INBOARD SEAT TRACKSSDR 20010425AP024Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION MAINTENANCE REPORTED THE LEFT FORWARD INBOARD, LEFT MIDDLE OUTBOARD, LEFT AFT OUTBOARD, LEFT AFT INBOARD, LEFT FLIGHT ATTENDANT, RIGHT FLIGHT ATTENDANT, RIGHT AFT INBOARD, RIGHT AFT OUTBOARD, AND RIGHT FORWARD INBOARD SEAT TRACKSSDR 20010425AP023Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION MAINTENANCE REPORTED THE LEFT FORWARD INBOARD, LEFT MIDDLE OUTBOARD, LEFT AFT OUTBOARD, LEFT AFT INBOARD, LEFT FLIGHT ATTENDANT, RIGHT FLIGHT ATTENDANT, RIGHT AFT INBOARD, RIGHT AFT OUTBOARD, AND RIGHT FORWARD INBOARD SEAT TRACKS
Back to JASC 5347