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 AT9900149Seat Track · corrodedSCHEDULED INSPECTION AT AERO CORP, FL. FOUND CORROSION ON SEAT TRACKS AND AROUND FASTENER HOLES AT THREE DIFFERENT LOCATIONS. THE LOCATIONS ARE AS FOLLOWS: STA 267-294.5 RBL 41.8, STA 460-480 RBL 48, STA 827-927 LBL 48. MECHANICALLY REMOVED CORROSION, REMSDR AT9900161Seat Track · corrodedSCHEDULED INSPECTION AT AERO CORP, FL. FOUND CORRODED SEAT TRACK AT BS 312 TO 360 RBL 50.5. REMOVED CORRODED SECTION OF SEAT TRACK, FABRICATED REPAIR SECTION, TREATED, PRIMED AND INSTALLED IAW B737 SRM 53-10-5, 51-10-2, AND 51-30-2.SDR AT9900160Seat Track · corrodedSCHEDULED INSPECTION AT AERO CORP, FL. FOUND CORRODED SEAT TRACK AT BS 312 TO 480 RBL 24. REMOVED CORRODED SECTION OF TRACK, FABRICATED REPAIR SECTION, TREATED, PRIMED AND INSTALLED IAW B737 SRM 51-10-2, 51-30-2, 53-10-5 FIG 2.SDR AT9900159Seat Track · corrodedSCHEDULED INSPECTION AT AERO CORP, FL. FOUND CORRODED SEAT TRACK AT BS 312 TO 360 RBL 41.8. REMOVED CORRODED SECTION OF TRACK, FABRICATED NEW REPAIR SECTION, TREATED, PRIMED, AND INSTALLED IAW B737 SRM 53-10-5, 51-10-2, AND 51-30-2.SDR TWAA9902705Seat Track · corrodedDURING OP 16 MAINT CHECK, FOUND IN CABIN THE LT O/B SEAT TRACK WITH CORROSION, STA 200 TO 207. REPAIRED PER SRM 53-05, FIG 4F, SHEET 6. REPLACED TRACK.SDR QXEA9900449Seat Track · damagedPDX - PILOTS SEAT TRACKS HAVE LOOSE OR MISSING REPAIR BUSHINGS. REPLACED BUSHINGS IAW RD 8-53-219.SDR SIMA990441Seat Track · corrodedABI - DURING AN MBV INSPECTION, SEAT TRACK 18.3L WAS FOUND CORRODED FROM STA 297.0 - STA 308.0. CUT OUT A 11 INCH SECTION OF SEAT TRACK, DEBURRED, ALODINED, PRIMERED, AND PAINTED EDGES. FABRICATED A 15 INCH LONG U-BEAM OF PLAL 7075-T76511 EXTRUDED MATERIAL. SDR CALA9900152Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED BETWEEN STA 277 TO 294. THE SEAT TRACK WAS REMOVED AND A NEW TRACK WAS INSTALLED IAW SRM 53-00-02, FIGURE 202.SDR USAA990079Cargo Track · corrodedCLT - DURING Q-5 CHECK VISUAL INSPECTION, FOUND 2 INCH BY 16 INCH AREA OF CORROSION BS 767-867 RBL 14.5 CARGO TRACK TIE DOWN CHANNEL. CORROSION TASK NR C53-202-01. SPLICED IN NEW TRACK SECTION PER SRM 53-00-53. (M)SDR USAA990078Cargo Track · corrodedCLT - DURING Q-5 CHECK VISUAL INSPECTION, FOUND A 1 INCH BY 3 INCH AREA OF CORROSION BS 947.5 LBL 14.5 AFT CORNER CARGO TRACK TIE DOWN CHANNEL. CORROSION TASK NR C53-202-01. SPLICED IN DOUBLER PER SRM 53-00-53. (M)SDR QXEA9900355Seat Track · brokenPDX - RIGHT-HAND INBOARD SEAT TRACK CAMLOC RECEPTACLE BROKEN AT FRAME 9305B. REPLACED RECEPTACLE PER FOKKER SRM 51-31-01.SDR CALA9900146Seat Track · corrodedINSPECTION FOUND LT O/B SEAT TRACK CORRODED AT STA 344 TO 360. THE SEAT TRACK WAS REPAIRED IAW SRM 53-00-52.SDR ASAA9940037Seat Track · corrodedPHX - DURING SCHEDULED SI, FOUND CORROSION ON THE RIGHT OUTBOARD SEAT TRACK AT STATION 480-500A. REPLACED SEAT TRACK PER SRM 53-30-52. (M)SDR ASAA9940029Seat Track · corrodedPHX - DURING SCHEDULED SI, THE RIGHT INBOARD SEAT TRACK FROM STATION 360-500E WAS FOUND TO BE CORRODED. REPLACED SEAT TRACK PER SRM 53-00-52. (M)SDR 99ZZZX1308Seat Track · corrodedDURING A C-CHECK, CORROSION NOTED ON SEAT TRACK STA 1130 LBL 24.75.SDR 99ZZZX1307Seat Track · corrodedDURING A C-CHECK, CORROSION NOTED ON SEAT TRACK STA 1070 - STA 1110, LBL 45.5SDR 99ZZZX1305Seat Track · corrodedDURING A C-CHECK, CORROSION NOTED ON SEAT TRACK STA 1050 - STA 1070, LBL 45.5.SDR 99ZZZX1302Seat Track · corrodedDURING A C-CHECK, CORROSION NOTED ON SEAT TRACK AT STA 997, APPROXIMATELY 44.5 LBL.SDR 9900981161Seat Track · corrodedDURING M-CHECK, FOUND GOUGING AND CORROSION ON THE OUTBOARD AFT CABIN SEAT TRACK LBL 108 AT FS 1661 TO 1700. REPAIRED PER EA 11-164769.SDR QXEA9900388Seat Track · damagedPDX - LEFT-HAND OUTBOARD SEAT TRACK SCORING ON TRACK BOTTOM BETWEEN FRAMES 13345 AND 13815. BURNISHED SEAT TRACK TO REMOVE DAMAGE. REMOVED APPROXIMATELY .002 MATERIAL. REF FOKKER SRM 53-01-01.SDR QXEA9900387Seat Track · damagedPDX - LEFT-HAND OUTBOARD SEAT TRACK AREAS OF LIGHT SCORING IN TRACK BOTTOM BETWEEN FRAME 9805C AND 10966. BURNISHED SEAT TRACK TO REMOVE CORROSION. REMOVED APPROXIMATELY .004 MATERIAL. REF FOKKER SRM 53-01-01.SDR QXEA9900386Seat Track · damagedPDX - LEFT-HAND OUTBOARD SEAT TRACK SCORING IN BOTTOM OF SEAT TRACK BETWEEN FRAME 8805 AND 9305A. BURNISHED SEAT TRACK TO REMOVE DAMAGE. REMOVED APPROXIMATELY .005 MATERIAL. REF FOKKER SRM 53-01-01.SDR QXEA9900385Seat Track · damagedPDX - LEFT-HAND OUTBOARD SEAT TRACK SCORING IN BOTTOM OF SEAT TRACK BETWEEN FRAMED 7305 AND 8805. BURNISHED SEAT TRACK TO REMOVE DAMAGE. REMOVED APPROXIMATELY .003 MATERIAL. REF FOKKER SRM 53-01-01.SDR QXEA9900384Seat Track · gougedPDX - LEFT-HAND OUTBOARD SEAT TRACK MINOR NICKS AND GOUGES AROUND TRACK HOLES 3 FORWARD OF FRAME 6305. BURNISHED SEAT TRACKS TO REMOVE DAMAGE. REMOVED APPROXIMATELY .004 MATERIAL. REF FOKKER SRM 53-01-01.SDR QXEA9900383Seat Track · damagedPDX - LEFT-HAND OUTBOARD SEAT TRACK MINOR SCORING IN BOTTOM OF SEAT TRACK BETWEEN FRAMES 6805 AND 7305. BURNISHED SEAT TRACK TO REMOVE DAMAGE. REMOVED APPROXIMATELY .003 MATERIAL. REF FOKKER SRM 53-01-01.SDR QXEA9900382Seat Track · damagedPDX - RIGHT-HAND OUTBOARD SEAT TRACK MINOR SCORING IN BOTTOM OF TRACK BETWEEN FRAMES 10966 AND 15205. BURNISHED SEAT TRACK TO REMOVE DAMAGE. REMOVED APPROXIMATELY .008 MATERIAL. REF FOKKER SRM 53-01-01.SDR QXEA9900381Seat Track · damagedPDX - RIGHT-HAND OUTBOARD SEAT TRACK MINOR NICKS AND GOUGES AROUND SEVERAL TRACK HOLES BETWEEN FRAMED 10966 AND 12405. BURNISHED SEAT TRACK TO REMOVED DAMAGE. REMOVED APPROXIMATELY .009 MATERIAL. REF FOKKER SRM 53-01-01.SDR QXEA9900354Seat Track · damagedPDX - RIGHT-HAND INBOARD SEAT TRACK GOUGES AND SCORING AROUND TRACK HOLES BETWEEN FRAMES 8305 AND 9305B. BURNISHED SEAT TRACK TO REMOVE DAMAGE. REMOVED APPROXIMATELY .006 MATERIAL, REF FOKKER SRM 53-01-01.SDR QXEA9900353Seat Track · damagedPDX - RIGHT-HAND INBOARD SEAT TRACK LIGHT SCORING IN BOTTOM OF SEAT TRACK BETWEEN FRAMES 8305 AND 9305B. BURNISHED SEAT TRACK TO REMOVE DAMAGE. REMOVED APPROXIMATELY .010 MATERIAL, REF FOKKER SRM 53-01-01.SDR QXEA9900352Seat Track · damagedPDX - RIGHT-HAND INBOARD SEAT TRACK LIGHT SCORING IN BOTTOM OF TRACK BETWEEN FRAMES 7805 AND 8305. BURNISHED SEAT TRACK TO REMOVED DAMAGE. REMOVED APPROXIMATELY .004 MATERIAL, REF FOKKER SRM 53-01-01.SDR QXEA9900351Seat Track · damagedPDX - RIGHT-HAND INBOARD SEAT TRACK LIGHT SCORING IN BOTTOM OF SEAT TRACK BETWEEN FRAMES 6805 AND 7305. BURNISHED SEAT TRACK TO REMOVE DAMAGE. REMOVED APPROXIMATELY .007 MATERIAL, REF FOKKER SRM 53-01-01.SDR QXEA9900350Seat Track · chafedPDX - RIGHT-HAND INBOARD SEAT TRACK LIGHT CHAFING ON INBOARD FLANGE BETWEEN FRAMES 5805 AND 6805. BURNISHED SEAT TRACK TO REMOVE DAMAGE. REMOVED APPROXIMATELY .009 MATERIAL, REF FOKKER SRM 53-01-01.SDR QXEA9900349Seat Track · damagedPDX - RIGHT-HAND INBOARD SEAT TRACK LIGHT SCORING ON TOP RAILS AT FRAME 6305. BURNISHED SEAT TRACK TO REMOVE DAMAGE. REMOVED APPROXIMATELY .006 MATERIAL, REF FOKKER SRM 53-01-01.SDR QXEA9900348Seat Track · damagedPDX - RIGHT-HAND INBOARD SEAT TRACK LIGHT SCORING IN BOTTOM OF TRACK BETWEEN FRAMES 5805 AND 6305. BURNISHED SEAT TRACKS TO REMOVE DAMAGE. REMOVED APPROXIMATELY .007 MATERIAL, REF FOKKER SRM 53-01-01.SDR GTIA9900917Seat Track · crackedMHV - SEAT TRACK RIGHT SIDE OUTBOARD AT STAITON 420 IS CRACKED EXTENDING .250 FROM ONE OF THE TOP SURFACE HOLES. REMOVED AND REPLACED OF SEAT TRACK FROM STATION 350 TO STATION 470 PER SRM 53-05 FIG 4F PAGE 10K. (M)SDR AT9900241Seat Track · corrodedSCHEDULED INSPECTION AT AERO CORP, FL. FOUND THE SEAT TRACK AT BS 312 TO 360 RBL 50.5 CORRODED. REMOVED CABIN SEAT TRACK, FABRICATED REPAIR, TREATED, PRIMED, AND INSTALLED IAW B737 SRM 53-10-5 FIG 2 AND 51-30-2.SDR 99ZZZX1289Seat Track · corrodedDURING A C-CHECK, CORROSION NOTED ON STA 848 - STA 740, LBL 45.5.SDR 99ZZZX1288Seat Track · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON SEAT TRACK STA 950A - STA 950B, LBL 45.5.SDR CALA9900122Seat Track · corrodedINSPECTION FOUND LT I/B SEAT TRACK CORRODED AT STA 344 TO 360. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS INSTALLED IAW SRM 53-00-52.SDR C2XA99IA141Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT HAND OUTBOARD SEAT TRACK WAS FOUND CORRODED FROM FRAMES 27 TO 33. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SEAT TRACK IAW ATR421-320 SRM 51-25-02, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. ACFT TT: SDR C2XA99IA140Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT HAND INBOARD SEAT TRACK WAS FOUND CORRODED FROM FRAMES 27 TO 33. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SEAT IAW ATR42-320 SRM 51-25-02, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. ACFT TT: 19,271.5SDR C2XA99IA136Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT HAND FLIGHT ATTENDANT SEAT TRACK WAS FOUND CORRODED FROM FRAMES 36 TO 40. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SEAT TRACK IAW ATR42-320 SRM 51-25-02, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. ACFTSDR C2XA99IA133Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT HAND FORWARD FLIGHT ATTENDANT SEAT TRACK WAS FOUND CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SEAT TRACK IAW ATR42-320 SRM 51-25-02, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. ACFT TT: 19,271SDR C2XA99IA132Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT HAND AFT FLIGHT ATTENDANT SEAT TRACK WAS FOUND CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SEAT TRACK IAW ATR42-320 SRM 51-25-02, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. ACFT TT: 19,271.5 HOSDR AT9900168Floor Track · corrodedSCHEDULED INSPECTION AT AERO CORP, FL, FOUND CARGO FLOOR TRACK AT BS 307-503 CORRODED. MECHANICALLY REMOVED CORROSION, REMOVED, REPLACED AND FABRICATED NEW TRACK SECTION, DRILLED, DEBURRED, ALODINED, PRIMED AND INSTALLED IAW DC9 SRM 51-10-4, 53-05 FIG 4C, ANDSDR SIMA990392Seat Track · corrodedABI - DURING AN MBV INSPECTION, SEAT TRACK BL ZERO AT STA 297 WAS FOUND CORRODED. CUT OUT 11 INCH SECTION OF SEAT TRACK. FABRICATED A 11 INCH LONG EXTRUSION OF 4650000-043 SHPAL 7075-T76511. FABRICATED A 15 INCH LONG U-BEAM OF PLAL 7075-T7351. POSITIONED USDR TWAA9902204Seat Track · corrodedDURING OP 15 MAINT CHECK, FOUND CHAIR TRACK AT STA 214, RBL 44 WITH CORROSION AND DEEP PITTING. INSTALLED NEW TRACK SECTION FROM STA 200 TO 265, INSTALLED (P/N C03580-4) PER DOUGLAS PRINT 5910820.SDR AT9900205Track · corrodedSCHEDULED INSPECTION AT AERO CORP, FL, FOUND THE FORWARD CARGO FLOOR TRACK AT BS 318 TO 370 RIGHT SIDE CORRODED. FABRICATED NEW SEAT TRACK, DRILLED, DEBURRED, ALODINED, PRIMED, AND INSTALLED IAW DC9 SRM 53-10-3, 51-10-4, AND 51-10-3.SDR AT9900204Track · corrodedSCHEDULED INSPECTION AT AERO CORP, FL, FOUND THE FORWARD CARGO DOOR TRACK AT BS 351 TO 370 LEFT HAND SIDE CORRODED. REMOVED CORROSION, LOCATED AND DRILLED NEW TRACK IAW DC9 SRM 53-10-3, 51-10-3, AND 53-20-0.SDR AT9900203Track · corrodedSCHEDULED INSPECTION AT AERO CORP, FL, FOUND THE FORWARD CARGO FLOOR TRACK AT BS 427 TO 503 CORRODED. REMOVED CORROSION, FABRICATED, DRILLED, DEBURRED, AND INSTALLED NEW SEAT TRACK IAW DC9 SRM 53-05 FIG 4C, 51-10-3, AND 51-10-4.
Back to JASC 5347