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 QXEA0200430Seat Track · corrodedPDX - RT INBOARD SEAT TRACK FROM FRAME 9305 FORWARD 9 X 2 INCHES LONG INSIDE CHANNEL HAS PITTING AND CORROSION. REPAIRED IAW FOKKER SRM 53-01-01, PAGE 8, PARAGRAPH 4C AND SRM 51-31-01.SDR AALA20020231Seat Track · wornTUL - FOUND WEAR ON SEAT TRACK NR 3 AT STATION 300 OUT OF LIMITS. INSTALLED PLUG IN SEAT TRACK NR 3 AT STATION 300 PER SRM 53-05 FIG 4A. (M)SDR AALA20020230Seat Track · corrodedTUL - FOUND NR 4 SEAT TRACK INBOARD FLOORBOARD SUPPORT FLANGE HAS CORROSION FROM STATION 210 TO 248. INSTALLED SEAT TRACK SECTION STATION 200 TO 274 PER SRM 53-05 FIG 4F SHEET 2. (M)SDR QXEA0200446Seat Track · chafedPDX - LT INBOARD SEAT TRACK, INBOARD FLANGE HAS CHAFE FROM FLOORBOARD JUST FORWARD OF CAMLOCK RECEPTACLE AT FRAME 14755. REPAIRED IAW FOKKER MM 53-40-01, PAGE 206, FIGURE 205 AND SRM 51-10-4, PAGE 9.SDR USAA020079Seat Track · corrodedCLT - FOUND SEAT TRACK CORRODED 1 INCH BY 3 INCHES, STATION 377 LBL 45. CORROSION LEVEL 1, TASK NR C53-221-03. FABRICATED AND INSTALLED SEAT TRACK SECTION LBL 45 BETWEEN STATION 377 AND 440 PER SRM 53-00-52. (M)SDR SIMA200205101Seat Track · corrodedSAW - DURING CPCP4 INSPECTION, CORROSION WAS FOUND ON THE FOLLOWING SEAT TRACKS, LEFT FORWARD OUTBOARD, LEFT AFT OUTBOARD, AND LEFT AFT INBOARD. THE SEAT TRACKS WERE REMOVED AND REPLACED (P/N S53375001214, S53678001244-245, S53678001246) IAW WITH AE EO E2-53MSDR QXEA0200363Seat Track · corrodedPDX - RT OUTBOARD SEAT TRACK FORWARD OF FRAME 5305 ON INBOARD FLANGE THERE IS PITTING AND CORROSION. REPAIRED IAW FOKKER SRM.SDR QXEA0200384Seat Track · corrodedPDX - RT INBOARD SEAT TRACK AFT OF FRAME 13815A INSIDE CHANNEL HAS PITTING AND CORROSION. REPAIRED IAW FOKKER SRM.SDR QXEA0200383Seat Track · corrodedPDX - RT INBOARD SEAT TRACK AT FRAME 13815 AFT OUTBOARD FLANGE THERE IS CORROSION. REPAIRED IAW FOKKER SRM.SDR QXEA0200451Seat Track · corrodedPDX - RT OUTBOARD SEAT TRACK FROM FRAME 8805 FORWARD ABOUT 12 INCHES INBOARD FLANGE HAS PITTING AND CORROSION. REPAIRED IAW HORIZON AIR EA 4-53-1569.SDR QXEA0200433Seat Track · corrodedPDX - CORROSION ON RT OUTBOARD SEAT TRACK AT FRAME 5805 FORWARD ABOUT 5.5 X 3 INCHES LONG ON INBOARD FLANGE. REPAIRED IAW FOKKER SRM 51-10-04.SDR QXEA0200432Seat Track · corrodedPDX - RT OUTBOARD SEAT TRACK AT FRAME 6305 FORWARD ABOUT 5 INCHES LONG ON INBOARD FLANGE THERE IS CORROSION. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 8, PARAGRAPH 4C, STEP 1.SDR QXEA0200431Seat Track · corrodedPDX - RT INBOARD SEAT TRACK FROM FRAME 8805 FORWARD ABOUT 7 X 6 INCHES LONG INSIDE CHANNEL THERE IS CORROSION. REPAIRED IAW FOKKER SRM 53-01-01, PAGE 8, PARAGRAPH 4C, STEP1.SDR QXEA0200428Seat Track · corrodedPDX - LT INBOARD SEAT TRACK AT STATION 191.929 MOST FORWARD END OF TRACK HAS CORROSION ON LUGS. ALSO, IN CHANNEL AND ON FLANGES. REPAIRED IAW FOKKER SRM 53-01-01, PAGE 8, PARAGRAPH 4C, SRM 51-10-4 AND SRM 51-31-01.SDR QXEA0200422Seat Track · gougedPDX - LT INBOARD SEAT TRACK AT STATION 506.028 TOP LUGS HAVE GOUGES. REPAIRED IAW FOKKER MM 53-40-01, PAGE 205, FIGURE 204.SDR QXEA0200421Seat Track · gougedPDX - LT INBOARD SEAT TRACK AT STATION 525-709 TOP LUGS HAVE GOUGES. REPAIRED IAW FOKKER MM 53-40-01, PAGE 205, FIGURE 204.SDR QXEA0200390Seat Track · corrodedPDX - RT OUTBOARD SEAT TRACK FORWARD OF FRAME 15635 CORROSION ON INSIDE LUGS. REPAIRED IAW FOKKER SRM 53-01-01, PAGE 8, PARAGRAPH 4C, STEP 1 AND SRM 51-10-04, PAGE 8.SDR QXEA0200389Seat Track · gougedPDX - RT OUTBOARD SEAT TRACK FROM FRAME 15635 TO FRAME 12405 THE LUGS ARE GOUGED. REPAIRED IAW FOKKER MM AND SRM.SDR QXEA0200388Seat Track · corrodedPDX - RT OUTBOARD SEAT TRACK AFT OF FRAME 14755 INSIDE TUNNEL THERE IS PITTING AND CORROSION. REPAIRED IAW FOKKER SRM AND MM.SDR QXEA0200387Seat Track · corrodedPDX - RT OUTBOARD SEAT TRACK AT STATION 667.906 TO STATION 667.901 INSIDE LUGS THERE IS CORROSION. REPAIRED IAW FOKKER MM AND SRM.SDR QXEA0200386Seat Track · corrodedPDX - RT OUTBOARD SEAT TRACK AT STATION 667.906 TO STATION 667.901 INSIDE TUNNEL HAS PITTING AND CORROSION. REPAIRED IAW FOKKER SRM.SDR QXEA0200385Seat Track · corrodedPDX - RT OUTBOARD SEAT TRACK FORWARD OF FRAME 13815B INSIDE THE TUNNEL HAS PITTING AND CORROSION. REPAIRED IAW FOKKER SRM.SDR QXEA0200382Seat Track · corrodedPDX - RT OUTBOARD SEAT TRACK AT FRAME 13815 AFT INSIDE TUNNEL HAS PITTING AND CORROSION. REPAIRED IAW FOKKER SRM.SDR QXEA0200380Seat Track · corrodedPDX - RT OUTBOARD SEAT TRACK FROM FRAME 12405 INSIDE TUNNEL THERE IS PITTING AND CORROSION. REPAIRED IAW FOKKER SRM.SDR QXEA0200379Seat Track · gougedPDX - RT INBOARD SEAT TRACK FROM FRAME 12405 TO FRAME 9305B WHERE SEAT ATTACHES TO TRACK LUGS HAVE GOUGES. REPAIRED IAW FOKKER MM AND SRM.SDR QXEA0200378Seat Track · corrodedPDX - RT OUTBOARD SEAT TRACK FRAME 9305B INSIDE CHANNEL THERE IS CORROSION. REPAIRED IAW FOKKER MM AND SRM.SDR QXEA0200376Seat Track · corrodedPDX - RT OUTBOARD SEAT TRACK INBOARD FLANGE AROUND RECEPTACLE HOLE JUST FORWARD OF FRAME 9305B HAS CORROSION. REPAIRED IAW FOKKER SRM.SDR QXEA0200375Seat Track · corrodedPDX - RT OUTBOARD SEAT TRACK AT FRAME 9035A INBOARD FLANGE HAS CORROSION. REPAIRED IAW FOKKER SRM.SDR QXEA0200374Seat Track · corrodedPDX - RT OUTBOARD SEAT TRACK AT FRAME 9035A FORWARD ALONG INBOARD FLANGE HAS PITTING AND CORROSION. REPAIRED IAW FOKKER SRM.SDR QXEA0200373Seat Track · corrodedPDX - RT OUTBOARD SEAT TRACK FROM FRAME 8805 ALONG OUTBOARD FLANGE HAS PITTING AND CORROSION. REPAIRED IAW FOKKER SRM.SDR QXEA0200372Seat Track · corrodedPDX - RT OUTBOARD SEAT TRACK AT FRAME 8305 FORWARD OUTBOARD FLANGE HAS PITTING AND CORROSION. REPAIRED IAW FOKKER SRM.SDR QXEA0200371Seat Track · gougedPDX - RT OUTBOARD SEAT TRACK FROM FRAME 9305B TO FRAME 6805 LUGS HAVE GOUGES AT SEAT TIE DOWN. REPAIRED IAW FOKKER MM 53-40-01, PAGE 206, FIGURE 205 AND SRM 51-10-04.SDR QXEA0200370Seat Track · gougedPDX - RT INBOARD SEAT TRACK FROM FRAME 9305B TO FRAME 6805 LUGS AT SEAT TIE DOWN HAVE GOUGES. REPAIRED IAW FOKKER MM 53-40-01, PAGE 206, FIGURE 205.SDR QXEA0200369Seat Track · corrodedPDX - RT INBOARD SEAT TRACK AT FRAME 9305B FORWARD INSIDE CHANNEL HAS PITTING AND CORROSION. REPAIRED IAW FOKKER SRM.SDR QXEA0200368Seat Track · corrodedPDX - RT INBOARD SEAT TRACK AT FRAME 9305B FORWARD TO FRAME 6805 INBOARD FLANGE HAS PITTING AND LIGHT CORROSION. REPAIRED IAW FOKKER SRM AND MM.SDR QXEA0200367Seat Track · corrodedPDX - RT INBOARD SEAT TRACK FROM FRAME 7805 FORWARD AND INSIDE THE CHANNEL HAS CORROSION. REPAIRED IAW FOKKER SRM.SDR QXEA0200366Seat Track · corrodedPDX - RT INBOARD SEAT TRACK FROM FRAME 7805 INSIDE THE CHANNEL HAS PITTING AND CORROSION. REPAIRED IAW FOKKER SRM.SDR QXEA0200365Seat Track · corrodedPDX - RT INBOARD SEAT TRACK FRAME 6805 AFT INSIDE CHANNEL THERE IS CORROSION. REPAIRED IAW FOKKER SRM.SDR QXEA0200364Seat Track · gougedPDX - RT INBOARD SEAT TRACK FROM FRAME 6305 TO FRAME 4610 LUGS AT SEAT ATTACH POINTS HAVE GOUGES. REPAIRED IAW FOKKER MM.SDR QXEA0200362Seat Track · corrodedPDX - RT INBOARD SEAT TRACK FRAME 5805 FORWARD 4 INCHES INSIDE THE CHANNEL HAS CORROSION. REPAIRED IAW FOKKER SRM.SDR QXEA0200361Seat Track · corrodedPDX - RT INBOARD SEAT TRACK FRAME 5305 TOP LUG AREA HAS CORROSION. REPAIRED IAW FOKKER SRM.SDR QXEA0200360Seat Track · corrodedPDX - RT INBOARD SEAT TRACK AFT OF FRAME 4900 ON OUTBOARD FLANGE THERE IS CORROSION. REPAIRED IAW FOKKER SRM.SDR QXEA0200359Seat Track · corrodedPDX - RT INBOARD SEAT TRACK AT FRAME 4610, FORWARD END OF TRACK, INBOARD FLANGE HAS CORROSION. REPAIRED IAW FOKKER SRM 53-01-01.SDR QXEA0200358Seat Track · corrodedPDX - RT INBOARD SEAT TRACK AT FRAME 4610 FORWARD OF TRACK AFT ABOUT 4 INCHES ON INBOARD FLANGE HAS CORROSION. REPAIRED IAW FOKKER SRM 53-40-01.SDR AALA20020238Seat Track · corrodedTUL - FOUND CORROSION ON NR 1 SEAT TRACK BETWEEN STATION 1174 AND STATION 1309. INSTALLED NEW NR 1 SEAT TRACK BETWEEN STATION 1174 TO STATION 1309. (M)SDR CALA0200075Track · corrodedINSPECTION FOUND CABIN FLOOR R/H FORWARD GALLEY ATTACH TRACK CORRODED AT STA 280-294, RBL43. THE TRACK WAS REMOVED AND REPLACED IAW SRM 51-10-02.SDR QXEA0200316Seat Track · gougedPDX - RT OUTBOARD SEAT TRACK GOUGES 9 INCHES FORWARD OF FRAME 11905. REPAIRED IAW FOKKER MM AND SRM.SDR QXEA0200314Seat Track · corrodedPDX - RT OUTBOARD SEAT TRACK FROM FRAME 12875 AFT ABOUT 8 INCHES, INSIDE TUNNEL THERE IS PITTING AND CORROSION. REPAIRED IAW FOKKER MM AND SRM.SDR QXEA0200313Seat Track · corrodedPDX - RT OUTBOARD SEAT TRACK AT FRAME 12875 FORWARD LUGS HAVE CORROSION. REPAIRED IAW FOKKER MM AND SRM.SDR QXEA0200311Seat Track · gougedPDX - RT OUTBOARD SEAT TRACK FROM FRAME 12405 TO FRAME 9305B ON ATTACH POINTS, LUGS HAVE GOUGES. REPAIRED IAW FOKKER SRM.
Back to JASC 5347