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 QXEA0101454Seat Track · corrodedPDX - NR 7 SEAT TRACK IS CHAFED BETWEEN 213.00 AND 214.00. REPAIRED IAW DASH-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0101453Seat Track · corrodedPDX - NR 7 SEAT TRACK HAS CORROSION AT 207.00. REPAIRED IAW DASH-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0101445Seat Track · corrodedPDX - NR 11 SEAT TRACK HAS CORROSION BETWEEN 435.45 AND 439.45. REPAIRED IAW DASH-8 SRM 51-20-16 AND 51-20-36.SDR QXEA0101444Seat Track · chafedPDX - NR 8 SEAT TRACK IS CHAFED AT BOTTOM OF TRACK GROOVE BETWEEN 438.00 AND 460.00. REPAIRED IAW DASH-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0101443Seat Track · corrodedPDX - NR 8 SEAT TRACK HAS CORROSION AT 424.25. REPAIRED IAW DASH-8 SRM 51-20-16 AND SRM 51-2-36.SDR QXEA0101442Seat Track · corrodedPDX - NR 7 SEAT TRACK HAS CORROSION BETWEEN 396.00 AND 398.00. REPAIRED IAW DASH-8 SRM 61-20-16 AND SRM 61-20-36.SDR QXEA0101441Seat Track · corrodedPDX - NR 7 SEAT TRACK CAMLOCK RECEPTACLE CUTOUT HAS CORROSION AT 371.00. REPARIED IAW DASH-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0101440Seat Track · corrodedPDX - NR 7 SEAT TRACK HAS CORROSION BETWEEN 357.00 AND 358.00. REPAIRED IAW DASH-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0101439Seat Track · corrodedPDX - NR 7 SEAT TRACK HAS CORROSION BETWEEN 322.0 AND 323.0. REPAIRED IAW DASH-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0101438Seat Track · gougedPDX - NR 7 SEAT TRACK HAS TWO GOUGES AT 311.00. REPAIRED IAW DASH-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0101437Seat Track · gougedPDX - NR 9 SEAT TRACK IS GOUGED AT CAMLOCK RECETPACLE AT 622.50. REPAIRED IAW DASH-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0101436Seat Track · corrodedPDX - NR 9 SEAT TRACK HAS CORROSION AT 568.50. REPAIRED IAW DASH-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0101435Seat Track · corrodedPDX - NR 8 SEAT TRACK HAS CORROSION AT 517.12. REPAIRED IAW DASH-8 SRM 51-20-16 AND SRM 51-20-36.SDR MWEA011141Cargo Track · corrodedBARE METAL AND LIGHT CORROSION ON LEFT TIE DOWN RAIL STATION 370 -446 UPPER AND LOWER SURFACE. FABRICATED AND INSTALLED TIE DOWN RAIL AND SPLICES.SDR AALA20011772Seat Track · corrodedTUL - FOUND CORROSION ON SEAT TRACK NR 1. REMOVED DAMAGED AREA OF NR 1 SEAT TRACK STATION 1235 TO 1238. INSTALLED SEAT TRACK PLUG PER 53-05 FIG 4A. (M)SDR AALA20011753Seat Track · corrodedTUL - FOUND NR 1 SEAT TRACK CORRODED OUT OF LIMITS AT STATION 1237. INSTALLED SEAT TRACK PLUG REPAIR PER SRM 53-05 FIG 40. (M)SDR 2001F00295Seat Track · corrodedSAW - DURING CPCP4 INSPECTION, FOUND CORROSION ON THE LEFT AFT OUTBOARD, RT AFT OUTBOARD, LEFT F/A, RT F/A AND LT AFT CARGO SEAT TRACKS. THE SEAT TRACKS WERE REMOVED AND REPLACED IAW EO E2-53MR-115. THE AIRCRAFT WAS RETURNED TO SERVICE. REF SIMA200124207. SDR 2001F00294Seat Track · corrodedSAW - DURING CPCP4 INSPECTION, FOUND CORROSION ON THE LEFT AFT OUTBOARD, RT AFT OUTBOARD, LEFT F/A, RT F/A AND LT AFT CARGO SEAT TRACKS. THE SEAT TRACKS WERE REMOVED AND REPLACED IAW EO E2-53MR-115. THE AIRCRAFT WAS RETURNED TO SERVICE. REF SIMA200124207. SDR 2001F00293Seat Track · corrodedSAW - DURING CPCP4 INSPECTION, FOUND CORROSION ON THE LEFT AFT OUTBOARD, RIGHT AFT OUTBOARD, LT F/A, RT F/A AND LEFT AFT CARGO SEAT TRACKS. THE SEAT TRACKS WERE REMOVED AND REPLACED IAW EO E2-53MR-115. THE AIRCRAFT WAS RETURNED TO SERVICE. REF SIMA200124207SDR 2001F00292Seat Track · corrodedSAW - DURING CPCP4 INSPECTION, FOUND CORROSION ON THE LEFT AFT OUTBOARD, RT AFT OUTBOARD, LEFT F/A, RT F/A AND LT AFT CARGO SEAT TRACKS. THE SEAT TRACKS WERE REMOVED AND REPLACED IAW EO E2-53MR-115. THE AIRCRAFT WAS RETURNED TO SERVICE. REF SIMA200124207. SDR 2001F00279Seat Track · corrodedSAW - DURING CPCP4 INSPECTION, FOUND CORROSION ON THE LEFT AFT INBOARD, LEFT AFT OUTBOARD AND RIGHT FLIGHT ATTENDANT SEAT TRACKS. THE SEAT TRACKS WERE REMOVED AND REPLACED IAW EO E2-53-115R1. THE AIRCRAFT WAS RETURNED TO SERVICE. REF SIMA200124209. (M)SDR 2001F00278Seat Track · corrodedSAW - DURING CPCP4 INSPECTION, FOUND CORROSION ON THE LEFT AFT INBOARD, LEFT AFT OUTBOARD AND RIGHT FLIGHT ATTENDANT SEAT TRACKS. THE SEAT TRACKS WERE REMOVED AND REPLACED IAW EO E2-53-115R1. THE AIRCRAFT WAS RETURNED TO SERVICE. REF SIMA200124209. (M)SDR SIMA200124202Seat Track · corrodedSAW - DURING CPCP2 INSPECTION, FOUND CORROSION WAS FOUND ON 5 SEAT TRACKS, RIGHT AFT INBOARD, RIGHT AFT OUTBOARD, RIGHT AFT CARGO, RT F/A AND LT F/A. ALL SEAT TRACKS WERE REMOVED AND REPLACED IAW AMERICAN EAGLE ENGINEERING ORDER E9-5300-013. THE AIRCRAFT WASSDR QXEA0101452Seat Track · corrodedPDX - NR 12 SEAT TRACK HAS CORROSION BETWEEN 540.50 AND 541.00. REPAIRED IAW RD 8-53-3644.SDR QXEA0101451Seat Track · gougedPDX - NR 12 SEAT TRACK IS GOUGED BETWEEN 530.000 AND 532.50. REPAIRED IAW RD 8-53-3644.SDR QXEA0101450Seat Track · corrodedPDX - NR 12 SEAT TRACK HAS CORROSION BETWEEN 515.00 AND 517.00. REPAIRED IAW RD 8-53-3644.SDR QXEA0101449Seat Track · corrodedPDX - NR 11 SEAT TRACK HAS CORROSION BETWEEN 500.50 AND 501.50. REPAIRED IAW RD 8-53-1342.SDR QXEA0101448Seat Track · corrodedPDX - NR 11 SEAT TRACK HAS CORROSION BETWEEN 484.45 AND 486.00. REPAIRED IAW RD 8-53-1342.SDR QXEA0101447Seat Track · corrodedPDX - NR 11 SEAT TRACK HAS CORROSION BETWEEN 467.00 AND 470.50. REPAIRED IAW RD 8-53-1432.SDR QXEA0101446Seat Track · corrodedPDX - NR 11 SEAT TRACK HAS CORROSION BETWEEN 455.00 AND 461.00. REPAIRED IAW RD 8-53-1432.SDR QXEA0101467Seat Track · corrodedPDX - NR 10 SEAT TRACK HAS CORROSION BETWEEN 404.40 AND 409.40. REPAIRED IAW RD 8-53-1342.SDR QXEA0101466Seat Track · corrodedPDX - NR 10 SEAT TRACK HAS CORROSION BETWEEN 391.40 AND 394.0.REPAIRED IAW RD 8-53-1432.SDR QXEA0101465Seat Track · corrodedPDX - NR 10 SEAT TRACK HAS CORROSION BETWEEN 374.40 AND 378.40. REPAIRED IAW RD 8-53-1432.SDR QXEA0101464Seat Track · corrodedPDX - NR 10 SEAT TRACK HAS CORROSION BETWEEN 368.40 AND 369.40. REPAIRED IAW RD 8-53-1342.SDR QXEA0101463Seat Track · corrodedPDFX - NR 10 SEAT TRACK HAS CORROSION BETWEEN 361 AND 365.40. REPAIRED IAW RD 8-53-1432.SDR QXEA0101462Seat Track · corrodedPDX - NR 10 SEAT TRACK HAS CORROSION AT 356.40. REPAIRED IAW RD 8-53-1432.SDR QXEA0101461Seat Track · corrodedPDX - NR 10 SEAT TRACK HAS CORROSION BETWEEN 341.40 AND 344.40. REPAIRED IAW RD 8-53-1432.SDR QXEA0101460Seat Track · corrodedPDX - NR 10 SEAT TRACK HAS CORROSION BETWEEN 328.00 AND 328.50. REPAIRED IAW RD 8-53-1342.SDR QXEA0101459Seat Track · corrodedPDX - NR 10 SEAT TRACK HAS CORROSION BETWEEN 296.50 AND 298.0. REPAIRED IAW RD 8-53-1342.SDR QXEA0101458Seat Track · corrodedPDX - NR 10 SEAT TRACK HAS CORROSION BETWEEN 262.40 AND 267.00. REPAIRED IAW RD 8-53-1342.SDR MWEA011203Seat Track · chafedNR 4 SEAT TRACK CHAFFED AT STATION 590. REMOVED AND REPLACED WITH SEAT TRACK SPLICE REPAIR.SDR GTIA010955Seat Track · corrodedFTW - PASSENGER CABIN SEAT TRACK HAS CORROSION IN SEVERAL PLACES AT FS 503-674. REMOVED CORROSION. LOCATED AND DRILLED NEW SEAT TRACK IAW MD-80 SRM 51-10-04 AND 53-05. (M)SDR AALA20011754Seat Track · corrodedTUL - FOUND NR 1 SEAT TRACK HAS CORROSION AT AFT G-4 GALLEY MOUNT. INSTALLED SEAT TRACK PLUG REPAIR PER SRM 53-05 FIG 4A. (M)SDR AALA20011748Seat Track · corrodedTUL - FOUND NR 3 SEAT TRACK CORRODED STATION 1304. INSTALLED PLUG REPAIR PER SRM 53-05 FIG 4A. (M)SDR DHL2001727513Seat Track · corrodedCORROSION ON SEAT TRACK AT RBL 46 & STA 1020 TO 1030. REMOVED CABIN SEAT TRACK FROM STA 1020 TO 1070, CORROSION OUT OF LIMITS PER SRM 51-30-2 AND 53-10-5. INSTALLED NEW SEAT TRACK PER SRM 53-10-5 FIG 1. ALODINE AND PRIMED PER SRM 51-10-2.SDR QXEA0101456Seat Track · corrodedPDX - NR 10 SEAT TRACK HAS CORROSION BETWEEN 423.00 AND 425.00. REPAIRED IAW RD 8-53-1432.SDR CALA0100814Seat Track · corrodedINSPECTION FOUND MAIN DECK SEAT TRACK CORRODED AT Y = 1860, X = -60.00, JUST AFT OF R-4 ATTENDANT SEAT. THE CORRODED SECTION OF SEAT TRACK WAS CUT OUT AND A NEW SECTION OF SEAT TRACK WAS INSTALLED USING SPLICE HAT AND SPLICE PLATE IAW SRM 53-70-00, FIGURE 1.SDR 01FDEA00774Cargo Track · crackedMAIN CABIN CARGO TRACK CRACKED AT BS 615 BL 0. REMOVED AND REPLACED TRACK PER SRM 53-10-5.SDR MWEA011180Seat Track · crackedNR 4 SEAT TRACK ATTACHMENT FITTING IS CRACKED AT STATION 680. -- REMOVED AND REPLACED SEAT TRACK FITTING.SDR CALA0100812Seat Track · corrodedINSPECTION FOUND MAIN DECK R/H SEAT TRACK CORRODED AT FS 250-788. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS INSTALLED IAW SRM 51-30-5 AND 53-05, FIGURE 4F.
Back to JASC 5347