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 2001F00431Seat Track · damagedMAIN CABIN FLOOR SEAT TRACK DAMAGED AT BS 640, RBL 24. REMOVED AND REPLACED SECTION OF SEAT TRACK IN MAIN CABIN FROM BS 600 TO BS 740 RBL 24 IAW B727 SRM 53-10-8 AND 51-30-2. (M)SDR AALA20011617Seat Track · corrodedTUL - FOUND CORROSION ON SEAT TRACK NR 3 AT 1302-1303. FABRICATED AND INSTALLED NEW TRACK STATION 1260-1309 PER SRM 53-05. (M)SDR QXEA0101373Seat Track · corrodedPDX-RIGHT HAND OUTBOARD SEAT TRACK HAS LIGHT CORROSION AND RAISED METAL AT STATION X265-268. REPAIRED IAW DHC-8 RD8-53-1342, SRM 51-20-16 AND SRM 51-20-26.SDR QXEA0101370Seat Track · corrodedPDX-PITTING CORROSION IN CENTER OF SEAT TRACK LEFT HAND INBOARD FORWARD OF STATION X545.0. REPAIRED IAW DHC-8 RD8-53-1339, SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0101318Seat Track · corrodedPDX - PITTING CORROSION IN CENTER OF LEFT-HAND SEAT TRACK FORWARD OF STATION X545.0., REPAIRED IAW DHC-8 SRM 51-20-16, SECTION C 1-9 AND SRM 51-20-36.SDR QXEA0101330Seat Track · corrodedPDX - RIGHT-HAND OUTBOARD SEAT TRACK HAS LIGHT CORROSION AND RAISED METAL AT STATION 265 TO 268. REPAIRED IAW DHC-8 RD 8-53-1342, SRM 51-20-16 AND SRM 51-20-26.SDR SIMA200121904Seat Track · corrodedDURING CPCP-2 INSPECTION, FOUND CORROSION ON FOUR SEAT TRACKS, LEFT AFT OUTBOARD, LEFT AFT INBOARD, LAVATORY WALL TRACK, AND RIGHT AFT CARGO FLOOR TRACK. ALL SEAT TRACKS WERE REMOVED AND REPLACED IAW AE EO E2-53MR-115. AIRCRAFT WAS THEN RETURNED TO SERVICE. SDR QXEA0101289Seat Track · corrodedPDX - RIGHT-HAND OUTBOARD SEAT TRACK HAS LIGHT CORROSION AND SOME RAISED METAL AT STATION 542 TO 545. REPAIRED IAW DHC-8 RD 8-53-3644, SRM 51-20-11, SRM 51-20-16 AND SRM 51-20-26.SDR QXEA0101290Seat Track · corrodedPDX - RIGHT-HAND INBOARD SEAT TRACK HAS LIGHT SURFACE CORROSION AND SOME RAISED METAL AT STATION 541 TO 548. REPAIRED IAW RD 8-53-784 , DHC-8 SRM 51-20-11, SRM 51-20-16 AND SRM 51-20-26.SDR MWEA011082Cargo Track · corrodedGILL LINER SUPPORT BRACKET CORRODED BETWEEN LONGERONS 28 RIGHT TO 27 RIGHT FROM STATION 522-636 IN MID PIT AREA. BLENDED CORROSION, REMOVED CARGO TIE RAIL, FABRICATED NEW TRACK, INSTALLED GILL LINER SUPPORT AND NEW ANGLES.SDR CALA0100715Seat Track · corrodedINSPECTION FOUND R/H I/B SEAT TRACK CORRODED AT FS 845-1032. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS INSTALLED WITH SPLICES IAW SRM 53-05, FIGURE 4F AND 51-10-3.SDR CALA0100713Seat Track · corrodedINSPECTION FOUND CABIN L/H CENTER SEAT TRACK CORRODED AT FS 1032-1309. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS INSTALLED IAW SRM 51-30-1, 51-30-2, 51-30-5, 51-10-4, 51-10-3, AND 53-05, FIGURE 4F.SDR CALA0100710Seat Track · corrodedINSPECTION FOUND L/H O/B SEAT TRACK CORRODED AT FS 1174-1309. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS INSTALLED IAW SRM 51-30-1 AND 51-10-3.SDR PCAA0108098Seat Track · corrodedMDT- DURING C-CHECK INSPECTION INBOARD LEFT FORWARD SEAT RAIL FOUND CORRODED. REPLACED WORN LT INBOARD CABIN SEAT RAIL SECTION, P/N 85320490-127, BETWEEN STATION X182.0 AND X424.0 IN ACCORDANCE WITH DHC ASSEMBLY DRAWING 85320019 AND DHC REPAIR DRAWINGS 8-53-6SDR 01FDEA00614Seat Track · crackedMAIN CABIN SEAT TRACK IS SPLIT AND CRACKED AT O/B CLIP LUG. *S/D* REMOVED AND REPLACED TRACK PER SRM 53-60-01 FIG 1, 55-31-01.SDR CALA0100702Seat Track · corrodedINSPECTION FOUND L/H SEAT TRACK CORRODED AT STA 1108-1309. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK AND SPLICE WERE INSTALLED IAW SRM 51-30-1.SDR AWXA0002088Seat TrackD: Seat track @ RBL 24-75 STA 360-947 Nicked at Various Locations.C: Track blended at various locations and Assessed Per SRM 53-10-1 Pg 18. Track repaired per SRM 51-30-2 PG 8, SRM 53-10-5 pg 2, SRM 53-10-1 pg 8, SRM 53-10-5 PG 8SDR AWXA0002087Seat Track · nickedD: Seat track RBL 45-50 STA 360-947 is nicked @ various locations.C: Track blended and protected per SRM 53-10-1 pg 18. STA 520-540 track replaced per SRM 51-30-2 Pg * STA 827 track repaired per SRM 53-10-5 pg 3, and SRM 51-30-2 PG 8SDR CALA0100699Seat Track · corrodedINSPECTION FOUND CABIN SEAT TRACK CORRODED AT STA 798-1108. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS INSTALLED IAW SRM 51-30-1.SDR AALA20011523Cargo Track · corrodedTUL - FOUND CORROSION UNDER CARGO TRACK RIGHT CLIP NUT HOLES BETWEEN STATION 1231-1250. REPLACED RIGHT AFT CARGO TRACK STATION 1212 TO 1327 WITH NEW TRACK PER SRM 53-05. (M)SDR USAA010930Seat Track · corrodedCLT - FOUND SEAT TRACK CORRODED 1 INCH BY 1 INCH AREA, BS 660, RBL 45. REMOVED AND REPLACED SEAT TRACK SECTION PER SRM 53-00-52. (M)SDR CALA0100692Seat Track · corrodedINSPECTION FOUND R/H CENTER SEAT TRACK CORRODED AT FS 798-874. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS INSTALLED IAW SRM 51-30-2, 51-30-5, AND 51-30-3.SDR AWXA0002085Seat Track · nickedD: Various nicks found along seat track LBL 45-50 STA 360-947C: Nicks dressed and assessed per SRM 51-10-1 Pg 18 STA 540-564 track repaired per SRM 53-10-5 Fig 2 Pg 2-5SDR MWEA011071Cargo Track · corrodedAFT CARGO COMPARTMENT RIGHT CARGO TRACK FROM STATION 1212 TO 1322 HAS AREAS OF LIGHT TO MODERATE CORROSION.SDR MWEA011070Cargo Track · corrodedAFT CARGO COMPARTMENT NUMEROUS AREAS OF LIGHT TO MODERATE CORROSION ON LEFT CARGO TRACK FROM STATION 1003 TO 1322.SDR MWEA011069Seat Track · corrodedMODERATE CORROSION IN NR 3 SEAT TRACK FORWARD OF GALLEY MOUNT AT STATION 237.SDR QXEA0101219Seat Track · corrodedPDX-REPLACE RIGHT HAND INBOARD AFT SEAT TRACK STATION 551.5 - 600.0 NR 9 DUE TO CORROSION. REPLACED IAW DHC-8 RD8-53-4472 AND SRM 51-40-00.SDR QXEA0101218Seat Track · corrodedPDX-REPLACE NR 7 SEAT TRACK DUE TO CORROSION. REPLACED IAW DHC-8 SRM 51-40-11 AND SRM 51-40-00.SDR ZW0A0105707Cargo Track · corrodedDURING CHECK-C MAINT AT STA 1145 TO 1221, LBL 16 IN, THE LT TIE DOWN TRACK WAS CORRODED IN NUMEROUS LOCATIONS ALONG TRACK. INSTALLED TIE DOWN TRACK STA 1150 TO 1320. HI-LOK ATTACHED PER SRM 51-30-4, AND RIVETS PER SRM 51-30-02.SDR MWEA011065Seat Track · corrodedEXFOLIATION CORROSION IN NR 2 SEAT TRACK AT FASTENER HOLE AT STATION 1268.SDR MWEA011061Seat Track · corrodedMODERATE CORROSION IN NR 4 SEAT TRACK FORWARD OF GALLEY MOUNT AT STATION 237.SDR QXEA0101211Seat Track · corrodedPDX-SEAT TRACK NR 9 HAS SPOTS OF CORROSION ON INSIDE OF TRACK AT FRAME 597.5. REPAIRED IAW DHC-8 RD8-53-784.SDR QXEA0101210Seat Track · gougedPDX-SEAT TRACK NR 9 HAS GOUGE JUST FORWARD OF STATION 545. REPAIRED IAW DHC-8 SRM 51-00-06 AND RD8-53-784.SDR ZW0A0105705Cargo Track · corrodedDURING CHECK-C MAINT IN THE AFT CARGO COMPT FROM STA 1041 TO 1145, AT LBL 16, THE LT TIE DOWN TRACK WAS CORRODED IN NUMEROUS LOCATIONS ALONG THE TRACK.SDR USAA010925Track · corrodedPIT - FOUND TIE DOWN RAIL CORRODED .25 INCH BY .5 INCH, TIE DOWN RAIL STATION 787-927. DEFECTIVE PART REPLACED WITH IDENTICAL PART PER 51-20-05, 07, 51-40-02, 03. (M)SDR USAA010924Track · corrodedPIT - FOUND TIE DOWN RAIL.25 INCH BY .5 INCH, TIE DOWN RAIL RIGHT STATION 787-927. CORROSION LEVEL 1. DEFECTIVE PART REPLACED WITH IDENTICAL PART PER 51-20-05, 07, 51-40-02, 03. (M)SDR SIMA200120012Seat Track · corrodedCABIN SEAT TRACK AT STATION BL 18.3 LEFT IS CORRODED ON THE UPPER FLANGE IN THE CARGO AREA. PERFORMED SPLICE PROCEDURE IAW SAAB SRM 53-70-60. (M)SDR SIMA200120011Seat Track · corrodedSBP - FOUND CABIN SEAT TRACK AT STATION BL 18.3 LEFT IS CORRODED ON THE LOWER FLANGE FORWARD END. PERFORMED SPLICE PROCEDURE IAW SAAB SRM 53-70-60. (M)SDR QXEA0101213Seat Track · corrodedPDX-SEAT TRACK NR 4 HAS CORROSION ON OUTBOARD FLANGE AT ZUES FASTENER FRAME 252.7. REPAIRED IAW DHC-8 SRM 51-40-11 AND SRM 51-40-00.SDR QXEA0101212Seat Track · corrodedPDX-SEAT TRACK NR 4 HAS CORROSION ON OUTBOARD FLANGE AT STATION 234.5. REPAIRED IAW DHC-8 RD8-53-1539.SDR QXEA0101206Seat Track · corrodedPDX-SEAT TRACK NR 7 HAS CORROSION AND A SCRATCH AT STATION 244. REPAIRED IAW DHC-8 SRM 51-40-11 AND SRM 51-40-00.SDR QXEA0101207Seat Track · corrodedPDX-SEAT TRACK NR 7 HAS CORROSION ON OUTBOARD FLANGE BY ZUES FASTENER HOLE AT STATION 245. REPAIRED IAW DHC-8 SRM 51/40/11 AND SRM 51/40/00.SDR QXEA011206Seat Track · corrodedPDX-SEAT TRACK NR 7 HAS CORROSION AND A SCRATCH AT STATION 244. REPAIRED IAW DHC-8 SRM 51-40-11 AND SRM 51-40-00.SDR AWXA0002084Seat Track · nickedD: Nicks on LBL 24.75 seat track at various locations from STA 360-947C: Nicks blended and assessed per SRM 53-10-1 pg 18 STA 520-540 track replaced per SRM 51-30-2 pg 8SDR SIMA200120703Seat Track · corrodedDURING CPCP2 INSPECTION, FOUND CORROSION ON SEAT TRACKS, LEFT AFT OUTBOARD AND RIGHT AFT INBOARD. THE SEAT TRACKS WERE REMOVED AND REPLACED IAW AMERICAN EAGLE AIRLINES ENGINEERING ORDER E2-53MR-115. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR SIMA200121201Seat Track · corrodedSAW - DURING CPCP2 INSPECTION, FOUND CORROSION ON SEAT TRACKS, LEFT AFT OUTBOARD AND RIGHT AFT INBOARD. THE SEAT TRACKS WERE REMOVED AND REPLACED IAW AMERICAN EAGLE AIRLINES ENGINEERING ORDER E2-53MR-115. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR QXEA0101217Seat Track · corrodedPDX-SEAT TRACK NR 6 HAS SEVERAL SPOTS OF CORROSION AT STATION 597.5. REPAIRED IAW DHC-8 RD8-53-1339. AND RD8-53-4936.SDR QXEA0101216Seat Track · gougedPDX-SEAT TRACK NR 3 HAS GOUGE ON INSIDE OF TRACK AT FRAME 531.5. REPAIRED IAW DHC-8 RD8-53-3644.SDR QXEA0101214Seat Track · corrodedPDX- SEAT TRACK NR 6 HAS SPOTS OF CORROSION ON INSIDE OF TRACK AT STATION 547.5. REPAIRED IAW DHC-8 RD8-53-1339.SDR QXEA0101209Seat Track · corrodedPDX-SEAT TRACK NR 8 HAS CORROSION INSIDE TRACK AT STATION 500. REPAIRED IAW DHC-8 SRM 51-20-26 AND RD8-53-1339.
Back to JASC 5347