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 QXEA0000367Seat Track · corrodedPDX - RIGHT INBOARD SEAT TRACK FROM FRAME 6805 TO FRAME 7805 HAD SCRATCHES, CHAFING AND CORROSION IN PLACES. BLENDED AREAS IAW FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4A.SDR QXEA0000365Seat Track · gougedPDX - RIGHT INBOARD SEAT TRACK FROM FRAME 4905 TO FRAME 5805 HAD CORROSION AND GOUGES IN PLACES. BLENDED AREA IAW FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4A.SDR QXEA0000364Seat Track · gougedPDX - LEFT INBOARD SEAT TRACK FROM FRAME 9305C TO FRAME 10346 HAD CHAFING AND GOUGES. BLENDED IAW FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4A.SDR QXEA0000362Seat Track · chafedPDX - LEFT INBOARD SEAT TRACK FROM FRAME 8805 TO FRAME 9305A HAD CHAFING. BLENDED AREA IAW FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4A.SDR QXEA0000361Seat Track · gougedPDX - LEFT INBOARD SEAT TRACK FROM FRAME 7805 TO FRAME 8805 HAD CHAFING, GOUGES AND CORROSION. BLENDED AREA IAW FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4A.SDR QXEA0000360Seat Track · chafedPDX - LEFT INBOARD SEAT TRACK FROM FRAME 6805 TO FRAME 7805 HAD CHAFING. BLENDED AREA IAW FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4A.SDR QXEA0000359Seat Track · chafedPDX - LEFT INBOARD SEAT TRACK FROM FRAME 4905 TO FRAME 5805 HAD CHAFING. BLENDED AREAS IAW FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4A.SDR QXEA0000337Seat Track · gougedPDX - LEFT INBOARD SEAT TRACK FROM FRAME 14755 TO FRAME 15635 HAS CHAFING AND GOUGES. BLENDED AREAS IAW FOKKER SRM 53-40-01.SDR QXEA0000323Seat Track · chafedPDX - RIGHT INBOARD SEAT TRACK FROM FRAME 14755 TO FRAME 15635 HAS CHAFING AND BARE METAL. REPAIRED IAW FOKKER MM 53-40-01, PAGE 206, FIGURE 205.SDR QXEA0000322Seat Track · chafedPDX - RIGHT INBOARD SEAT TRACK FROM FRAME 13815B TO FRAME 14755 HAS CHAFING AND BARE METAL. REPAIRED IAW FOKKER MM 53-40-01, PAGE 206, FIGURE 205.SDR QXEA0000321Seat Track · corrodedPDX - RIGHT INBOARD SEAT TRACK FROM FRAME 13815 TO FRAME 13815B HAS CHAFING, SCRAPES AND CORROSION. REPAIRED IAW FOKKER MM 53-40-01, PAGE 206, FIGURE 205.SDR QXEA0000320Seat Track · chafedPDX - RIGHT-HAND INBOARD SEAT TRACK FROM FRAME 12875 TO FRAME 13815 HAS CHAFING. REPAIRED IAW FOKKER SRM 51-10-04.SDR QXEA0000317Seat Track · corrodedPDX - RIGHT-HAND INBOARD SEAT TRACK FROM FRAME 10346 TO FRAME 10966 HAS SCRAPES, CHAFING AND CORROSION. REPAIRED IAW FOKKER SRM 51-10-04.SDR QXEA0000294Seat Track · chafedPDX - LEFT INBOARD SEAT TRACK FROM FRAME 5805 TO FRAME 6805 HAS CHAFING. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4A.SDR QXEA0000279Seat Track · corrodedPDX - RIGHT INBOARD SEAT TRACK FROM FRAME 7805 TO FRAME 8805 HAS CHAFING, SCRATCHES AND CORROSION IN PLACES. REPAIRED IAW FOKKER MM 53-40-1, PAGE 206, FIGURE 205.SDR QXEA0000221Seat Track · chafedPDX - RIGHT OUTBOARD SEAT TRACK FROM FRAME 9305C TO FRAME 10346 HAS CHAFING IN PLACES. REPAIRED IAW FOKKER MM53-40-1, PAGE 206, FIGURE 205.SDR QXEA0000214Seat Track · chafedPDX - RIGHT INBOARD SEAT TRACK FROM FRAME 9305A TO 9305C HAS CHAFING IN PLACES. REPAIRED IAW FOKKER MM 53-40-1, PAGE 205-206.SDR QXEA0000213Seat Track · chafedPDX - RIGHT INBOARD SEAT TRACK FROM FRAME 8805 TO 9305A HAS CHAFING AND SCRATCHES. REPAIRED IAW FOKKER SRM 53-40-1, PAGE 206.SDR CALA0000080Seat Track · corrodedINSPECTION FOUND LEFT I/B SEAT TRACK CORRODED BETWEEN STA 1040 AND 1338. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-1 AND 51-30-5.SDR DHL2000803116Seat Track · deterioratedAT C-CHECK, MAIN CARGO NR 3 LT SEAT TRACK FLANGE DETERIORATED BETWEEN FS 640 AND FS 700. REMOVED AND REPLACED TRACK AND FLANGE IAW SRM 53-2-3 PG 49 & 50. REF: N/R 5195.SDR RRXA000150Seat Track · brokenDURING A MAINTENANCE VISIT FOUND BROKEN SEAT TRACK, C5-R4, FUSELAGE, CABIN UPPER CARGO COMPT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8.SDR RRXA000149Seat Track · misdrilledDURING A MAINTENANCE VISIT FOUND MISDRILLED HOLES, FUSELAGE, CABIN UPPER CARGO COMPT SEAT TRACK C1-R4. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8.SDR RRXA000148Seat Track · misdrilledDURING A MAINTENANCE VISIT FOUND MISDRILLED HOLES, FUSELAGE, CABIN UPPER CARGO COMPT SEAT RACK C2-R4. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8.SDR RRXA000147Seat Track · crackedDURING A MAINTENANCE VISIT FOUND BENT AND CRACKED SEAT TRACK C14, FUSELAGE, CABIN UPPER CARGO COMPT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8.SDR RRXA000146Seat Track · crackedDURING A MAINTENANCE VISIT FOUND CRACK, FUSELAGE, CABIN-UPPER CARGO COMPT SEAT TRACK C1-R3 CRACKED. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8.SDR RRXA000145Seat Track · damagedDURING A MAINTENANCE VISIT FOUND ELONGATED HOLES, FUSELAGE, CABIN-UPPER CARGO COMPT SEAT TRACK C-13 R3. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8.SDR RRXA000144Seat Track · damagedDURING A MAINTENANCE VISIT FOUND ELONGATED HOLES, FUSELAGE, CABIN UPPER CARGO COMPT SEAT TRACK C-10 R6. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8.SDR RRXA000143Seat Track · damagedDURING A MAINTENANCE VISIT FOUND ELONGATED HOLE, FUSELAGE, CABIN UPPER CARGO COMPT SEAT TRACK C-12 R3. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8.SDR RRXA000142Seat Track · damagedDURING A MAINTENANCE VISIT FOUND ELONGATED HOLES, FUSELAGE, CABIN UPPER CARGO COMPT SEAT TRACK C-10 R2. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8.SDR QXEA0000358Seat Track · gougedPDX - LEFT OUTBOARD SEAT TRACK FROM FRAME 9305C TO FRAME 10346 HAD CHAFING AND GOUGES. BLENDED IAW FOKKER SRM 51-10-04.SDR QXEA0000357Seat Track · gougedPDX - LEFT OUTBOARD SEAT TRACK FROM FRAME 9305A TO FRAME 9305C HAD CHAFING AND GOUGES. BLENDED IAW FOKKER SRM 51-10-04.SDR QXEA0000356Seat Track · gougedPDX - LEFT OUTBOARD SEAT TRACK FROM FRAME 8805 TO FRAME 9305A HAD CHAFING AND GOUGES. BLENDED AREA IAW FOKKER SRM 51-10-04.SDR QXEA0000355Seat Track · gougedPDX - LEFT OUTBOARD SEAT TRACK FROM FRAME 7805 TO FRAME 8805 HAD CHAFING, GOUGES AND CORROSION. BLENDED AREA IAW FOKKER SRM 51-10-04.SDR QXEA0000354Seat Track · gougedPDX - LEFT OUTBOARD SEAT TRACK FROM FRAME 6805 TO FRAME 7805 HAD CHAFING, GOUGES AND BARE METAL. BLENDED AREA IAW FOKKER SRM 51-100-04.SDR QXEA0000353Seat Track · gougedPDX - LEFT OUTBOARD SEAT TRACK FROM FRAME 5805 TO FRAME 6805 HAS CHAFING, GOUGES AND BARE METAL. BLENDED IAW FOKKER SRM 51-10-04.SDR QXEA0000352Seat Track · gougedPDX - LEFT OUTBOARD SEAT TRACK FROM FRAME 4905 TO FRAME 5805 HAD CHAFING, GOUGES AND BARE METAL. BLENDED AREAS IAW FOKKER SRM 51-10-4 AND MM 53-40-1, FIGURE 205.SDR QXEA0000339Seat Track · chafedPDX - RIGHT INBOARD SEAT TRACK FROM 9648 TO FRAME 10346 HAS CHAFING. BLENDED AREA IAW FOKKER SRM 51-10-04.SDR QXEA0000330Seat Track · gougedPDX - LEFT OUTBOARD SEAT TRACK FROM FRAME 14755 TO FRAME 15635 HAS CHAFING AND GOUGES. REPAIRED IAW FOKKER SRM 51-10-04.SDR QXEA0000329Seat Track · chafedPDX - LEFT OUTBOARD SEAT TRACK FROM FRAME 13815B TO 14755 HAS CHAFING AND SCRAPES. REPAIRED IAW FOKKER MM 53-40-01, PAGE 206, FIGURE 205.SDR QXEA0000328Seat Track · chafedPDX - LEFT OUTBOARD SEAT TRACK FROM FRAME 13815 T FRAME 13815B HAS CHAFING AND BARE METAL. REPAIRED IAW FOKKER MM 53-40-01 PAGE 206, FIGURE 205.SDR QXEA0000327Seat Track · corrodedPDX - LEFT OUTBOARD SEAT TRACK FROM FRAME 12875 TO FRAME 13815 HAS CHAFING, SCRAPES AND CORROSION. REPAIRED IAW FOKKER MM 53-40-01, PAGE 206, FIGURE 205.SDR QXEA0000326Seat Track · chafedPDX - LEFT OUTBOARD SEAT TRACK FROM FRAME 11905 TO FRAME 12875 HAS CHAFING AND SCRAPES. REPAIRED IAW FOKKER SRM 51-10-04.SDR QXEA0000325Seat Track · gougedPDX - LEFT OUTBOARD SEAT TRACK FROM FRAME 10966 TO FRAME 11905 HAS CHAFING AND GOUGES. REPAIRED IAW FOKKER MM 53-40-1, PAGE 206, FIGURE 205.SDR QXEA0000324Seat Track · gougedPDX - LEFT OUTBOARD SEAT TRACK FROM FRAME 10346 TO FRAME 10966 HAS CHAFING AND GOUGES. REPAIRED IAW FOKKER MM 53-40-01, PAGE 206, FIGURE 205.SDR QXEA0000316Seat Track · damagedPDX - RIGHT-HAND OUTBOARD SEAT TRACK FROM FRAME 14755 TO FRAME 15635 HAS SCRAPES AND BARE METAL. REPAIRED IAW FOKKER SRM 51-10-04.SDR QXEA0000315Seat Track · corrodedPDX - RIGHT-HAND OUTBOARD SEAT TRACK FROM FRAME 13815B TO FRAME 14755 HAS CHAFING, SCRAPES AND CORROSION. REPAIRED IAW FOKKER SRM 51-10-04.SDR QXEA0000314Seat Track · chafedPDX - RIGHT-HAND SEAT TRACK FROM FRAME 13815 TO FRAME 13815B HAS CHAFING. REPAIRED IAW FOKKER SRM 51-10-04.SDR QXEA0000313Seat Track · chafedPDX - RIGHT-HAND OUTBOARD SEAT TRACK FROM FRAME 12875 TO FRAME 13815 HAS CHAFING AND SCRAPES. REPAIRED IAW FOKKER SRM 51-10-04.SDR QXEA0000312Seat Track · corrodedPDX - RIGHT-HAND OUTBOARD SEAT TRACK FROM FRAME 11905 TO FRAME 12875 HAS CHAFING, SCRAPES, BARE METAL AND CORROSION. REPAIRED IAW FOKKER SRM 53-10-04.SDR QXEA0000311Seat Track · corrodedPDX - RIGHT-HAND OUTBOARD SEAT TRACK FROM FRAME 10966 TO FRAME 11905 HAS SCRATCHES, GOUGES AND CORROSION. REPAIRED IAW FOKKER SRM 51-10-04.
Back to JASC 5347