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 98ZZZX3504Seat Track · corrodedDURING C-CHECK, CORROSION WAS NOTED FORWARD LAVATORY/GALLEY AREA SEAT TRACK RBL 24 - FS 420 - FS 460.SDR 98ZZZM710Seat Tracks · corrodedDURING CPCP-2 INSPECTION, FOUND THR RIGHT FORWARD OUTBOARD, THE RIGHT AFT OUTBOARD AND INBOARD, AND THE RIGHT AND LEFT FLIGHT ATTENDANT SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM709Seat Tracks · corrodedDURING CPCP-2 INSPECTION, FOUND THR RIGHT FORWARD OUTBOARD, THE RIGHT AFT OUTBOARD AND INBOARD, AND THE RIGHT AND LEFT FLIGHT ATTENDANT SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM708Seat Tracks · corrodedDURING CPCP-2 INSPECTION, FOUND THR RIGHT FORWARD OUTBOARD, THE RIGHT AFT OUTBOARD AND INBOARD, AND THE RIGHT AND LEFT FLIGHT ATTENDANT SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM707Seat Tracks · corrodedDURING CPCP-2 INSPECTION, FOUND THR RIGHT FORWARD OUTBOARD, THE RIGHT AFT OUTBOARD AND INBOARD, AND THE RIGHT AND LEFT FLIGHT ATTENDANT SEAT TRACKS CORRODED. REMOVED AND REPLACED THE SEAT TRACKS. AIRCRAFT RETURNED TO SERVICE. (M)SDR GAIA9882Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS AND WORN AREAS ON THE FLOOR SEAT TRACKS AT STATION BS 342 LBL 44.5. (M)SDR 98ZZZM770Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS AND WORN AREAS ON THE FLOOR SEAT TRACKS AT STATION BS 718 RBL 44.5. (M)SDR 98ZZZM769Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS AND WORN AREAS ON THE FLOOR SEAT TRACKS AT STATION BS 699 RBL 44.5. (M)SDR 98ZZZM768Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS AND WORN AREAS ON THE FLOOR SEAT TRACKS AT STATION BS 680 RBL 44.5. (M)SDR 98ZZZM767Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS AND WORN AREAS ON THE FLOOR SEAT TRACKS AT STATION BS 661 RBL 44.5. (M)SDR 98ZZZM766Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS AND WORN AREAS ON THE FLOOR SEAT TRACKS AT STATION BS 525 RBL 44.5. (M)SDR 98ZZZM765Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS AND WORN AREAS ON THE FLOOR SEAT TRACKS AT STATION BS 503 RBL 44.5. (M)SDR 98ZZZM764Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS AND WORN AREAS ON THE FLOOR SEAT TRACKS AT STATION BS 256 RBL 44.5. (M)SDR 98ZZZM763Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS AND WORN AREAS ON THE FLOOR SEAT TRACKS AT STATION BS 237 RBL 44.5. (M)SDR 98ZZZM762Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS AND WORN AREAS ON THE FLOOR SEAT TRACKS AT STATION BS 699 RBL 22. (M)SDR 98ZZZM761Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS AND WORN AREAS ON THE FLOOR SEAT TRACKS AT STATION BS 680 RBL 22. (M)SDR 98ZZZM760Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS AND WORN AREAS ON THE FLOOR SEAT TRACKS AT STATION BS 604 RBL 22. (M)SDR 98ZZZM759Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS AND WORN AREAS ON THE FLOOR SEAT TRACKS AT STATION BS 566 RBL 22. (M)SDR 98ZZZM758Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS AND WORN AREAS ON THE FLOOR SEAT TRACKS AT STATION BS 332 RBL 22. (M)SDR 98ZZZM757Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS AND WORN AREAS ON THE FLOOR SEAT TRACKS AT STATION BS 256 RBL 22. (M)SDR 98ZZZM756Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS AND WORN AREAS ON THE FLOOR SEAT TRACKS AT STATION BS 237 RBL 22. (M)SDR 98ZZZM755Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS AND WORN AREAS ON THE FLOOR SEAT TRACKS AT STATION BS 566 LBL 22. (M)SDR 98ZZZM754Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS AND WORN AREAS ON THE FLOOR SEAT TRACKS AT STATION BS 544 LBL 22. (M)SDR 98ZZZM753Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS AND WORN AREAS ON THE FLOOR SEAT TRACKS AT STATION BS 525 LBL 22. (M)SDR 98ZZZM752Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS AND WORN AREAS ON THE FLOOR SEAT TRACKS AT STATION BS 699 LBL 22 . (M)SDR 98ZZZM751Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS AND WORN AREAS ON THE FLOOR SEAT TRACKS AT STATION BS 680 LBL 22. (M)SDR 98ZZZM750Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS AND WORN AREAS ON THE FLOOR SEAT TRACKS AT STATION BS 604 LBL 22. (M)SDR 98ZZZM749Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS AND WORN AREAS ON THE FLOOR SEAT TRACKS AT STATION BS 514 LBL 22. (M)SDR 98ZZZM748Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS AND WORN AREAS ON THE FLOOR SEAT TRACKS AT STATION BS 503 LBL 22. (M)SDR 98ZZZM747Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS AND WORN AREAS ON THE FLOOR SEAT TRACKS AT STATION BS 256 LBL 22. (M)SDR 98ZZZM746Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS AND WORN AREAS ON THE FLOOR SEAT TRACKS AT STATION BS 237 LBL 22. (M)SDR 98ZZZM745Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS AND WORN AREAS ON THE FLOOR SEAT TRACKS AT STATION BS 427 LBL 44.5. (M)SDR 98ZZZM744Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS AND WORN AREAS ON THE FLOOR SEAT TRACKS AT STATION BS 758 LBL 44.5. (M)SDR 98ZZZM743Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS AND WORN AREAS ON THE FLOOR SEAT TRACKS AT STATION BS 737 LBL 44.5. (M)SDR 98ZZZM742Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS AND WORN AREAS ON THE FLOOR SEAT TRACKS AT STATION BS 699 LBL 44.5. (M)SDR 98ZZZM741Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS AND WORN AREAS ON THE FLOOR SEAT TRACKS AT STATION BS 609 LBL 44.5. (M)SDR 98ZZZM740Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS AND WORN AREAS ON THE FLOOR SEAT TRACKS AT STATION BS 514 LBL 44.5. (M)SDR 98ZZZM739Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS AND WORN AREAS ON THE FLOOR SEAT TRACKS AT STATION BS 408 LBL 44.5. (M)SDR 98ZZZM738Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS AND WORN AREAS ON THE FLOOR SEAT TRACKS AT STATION BS 395 LBL 44.5. (M)SDR SIMA982371Seat Track · corrodedABI - SEAT TRACK AT FUSELAGE STATION 297 BL 18.31 CORRODED. CUT OUT AND REPLACED 11 INCH SECTION OF SEAT TRACK. AIRCRAFT RETURNED TO SERVICE. (M)SDR CALA9801527Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 460 TO 480, RBL 45. THE SEAT TRACK WAS REMOVED AND A NEW TRACK WAS INSTALLED IAW SRM 53-10-5, FIGURE 1, 51-10-2, AND MM 51-20-12.SDR CALA9801517Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 410 TO 430, RBL 24. THE SEAT TRACK WAS REPLACED IAW SRM 53-10-5, FIGURE 7.SDR UPS98227567Seat Track · corrosionINSPECTION TYPE:SI CORROSION BETWEEN SEAT TRACK AND EXPANSION LINK FLANGES BS 850 LBL 45 WO L208. REPLACED SEAT TRACK ON EXPANSION LINK PER 727 SRM 51-30-2, 51-20-151 51-30-5, 51-10-1.SDR ORJA98246Seat Track · corrodedLEVEL 3 CORROSION ON SEAT TRACK, STATION 1211, 1231, 1271, 1309 LBL 22. REMOVED AND REPLACED SECTION FROM 1164 TO 1309 IAW DC9 SRM 53-05 FIG 4F. (M)SDR AALA981584Tray · corrodedTUL - FOUND CORROSION ALONG NR 1 ROLLER TRAY TOP AND BOTTOM. INSTALLED NEW/FABRICATED TRACK STATION 1541 TO 1701 IAW AARD 51-10-05. (M)SDR SIMA982344Seat Track · corrodedSAW - DURNIG CPCP-4 INSPECTION, FOUND THE LEFT FORWARD INBOARD AND OUTBOARD, LEFT MIDDLE INBOARD AND OUTBOARD, LEFT AFT INBOARD AND OUTBOARD, LEFT AND RIGHT AFT FLIGHT ATTENDANT, RIGHT AFT CARGO, RIGHT AFT INBOARD, RIGHT MIDDLE INBOARD AND OUTBOARD, RIGHT FORWSDR RAIA980818Seat Track · corrodedSTL - DURING MAINTENANCE CHECK, FOUND CORROSION AT RIGHT INBOARD SEAT TRACK. MAINTENANCE REPAIRED RIGHT INBOARD SEAT TRACK IAW ATR72 SRM. (M)SDR RAIA980817Seat Track · corrodedSTL - DURING MAINTENANCE CHECK, FOUND CORROSION AT FLIGHT ATTENDANT SEAT TRACKS. MAINTENANCE REPLACED FLIGHT ATTENDANT SEAT TRACKS IAW ATR72 SRM. (M)SDR ORJA98251Seat Track · corrodedLEVEL 3 CORROSION ON SEAT TRACK STATION 1309 LBL 44. CUT OUT DAMAGED SECTION OF SEAT TRACK AND SPLICED IN NEW SECTION IAW DC-9 SRM 53-05. (M)SDR AALA981582Tie Down · corrodedTUL - CORROSION ON AFT ARGO TIE DOWN TRACK FROM STA 1025 TO STA 1155. CORROSION REMOVAL EXCEEDED MAXIMUM ALLOWABLE AT STA 1057. INSTALLED REPAIR STRAP PER AARD 53-20-00-13 AT THIS LOCATION. TST: 23,605 HOURS. CYCLES: 12,312. (X)
Back to JASC 5347