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 QXEA0201015Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK HAS CORROSION PITS IN ITS CHANNEL AT X467. REPAIRED IAW DHC-8-200 SRM 51-20-16 AND SRM 51-20-41.SDR QXEA0201014Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK AT X438 HAS LIGHT CORROSION IN THE CHANNEL. REPAIRED IAW DHC-8-200 SRM 51-20-16 AND SRM 51-20-41.SDR QXEA0201013Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK HAS LIGHT SURFACE CORROSION IN CHANNEL AT X424. REPAIRED IAW DHC-8-200 SRM 51-20-16 AND SRM 51-20-41.SDR QXEA0201012Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK X375 HAS LIGHT SURFACE CORROSION. REPAIRED IAW DHC-8-200 SRM 51-20-16 AND SRM 51-20-41.SDR QXEA0201011Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK X391.45 HAS LIGHT SURFACE CORROSION. REPAIRED IAW DHC-8200 SRM 51-20-16 AND SRM 51-20-41.SDR QXEA0201010Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK LIGHT CORROSION FROM X332 TO X334. REPAIRED IAW DHC-8-200 SRM 51-20-16 AND SRM 51-20-41.SDR QXEA0201009Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK X317 HAS LIGHT SURFACE CORROSION. REPAIRED IAW DHC-8-200 SRM 51-20-16 AND SRM 51-20-41.SDR QXEA0200986Seat Track · gougedPDX - LT OUTBOARD SEAT TRACK X546 HAS TWO GOUGES IN CHANNEL AND SEVERAL ON TOP FLANGE. REPAIRED IAW DHC-8-202 SRM 51-20-16 AND SRM 51-20-41.SDR SWIA200211091Seat Track · corrodedRIGHT SIDE LOWER FORWARD SEAT TRACK HAS CORROSION. REPLACED RIGHT SIDE LOWER FORWARD SEAT TRACK IAW 53-01-05.SDR QXEA0200991Seat Track · corrodedPDX - LEFT HAND INBOARD SEAT TRACK X438.5 HAS A CORROSION PIT IN THE CHANNEL. REPAIRED IAW RD 8-53-4472, RD 8-53-4473, RD 8-53-1102 AND DHC-8 SRM 51-40-11.SDR QXEA0201024Seat Track · corrodedPDX - PITTING CORROSION ON RIGHT OUTBOARD SEAT TRACK AT STATION 309-312. REPAIRED IAW DHC-8-200 SRM 51-40-11.SDR AALA20021038Seat Track · gougedTUL - FOUND GOUGE IN NR 2 SEAT TRACK APPROX STATION 1250. INSTALLED NEW SECTION OF SEAT TRACK FROM STATION 1240-1309 PER SRM 51-01. (M)SDR AAL2002F00005Seat Track · corrodedSEAT TRACK, CORROSION IN NR 2 SEAT TRACK AT STATION 1200. CUT OUT CORROSION, INSTALLED SEAT TRACK PLUG PER SRM. (2002-1090/ AMC 4)SDR QXEA0201002Seat Track · corrodedPDX - PITTING CORROSION ON RIGHT HAND INBOARD SEAT TRACK NR 8 AT STATION 500. REPAIRED IAW DHC-8 SRM 51-40-00 AND 51-40-11.SDR CALA0200394Cargo Track · corrodedINSPECTION FOUND AFT BAGGAGE BIN RT TIE DOWN TRACK CORRODED AT STA 1211-1231. THE TIE DOWN TRACK WAS REMOVED AND REPLACED IAW SRM 53-05.SDR AALA20020976Seat Track · corrodedCORROSION ON SEAT NR 1. REMOVED SEAT TRACK NR 1 FROM STA 1174 TO 1307 AN INSTALLED NEW SEAT TRACK SRM.SDR AALA20020981Seat Track · corrodedCORROSION ON SEAT TRACK FLANGE. CABIN SEAT TRACK NR 5. INSTALLED REPAIR STRAP TO SEAT TRACK NR 5 AT STA 200 IAW AARD.SDR QXEA0200987Seat Track · corrodedPDX - LT INBOARD SEAT TRACK X230 TO X235 HAS CORROSION PITS IN RADIUS OF OUTBOARD FLANGE. REPAIRED IAW DHC-8-202 SRM 51-40-11 AND SRM 51-40-16.SDR MALA020417Seat Track · corrodedDURING 4K-CHECK IN CWA, AISLE SEAT TRACK HAS LIGHT CORROSION TO STA 535.0. MAINTENANCE REMOVED CORROSION IAW SRM 51-70-40. REFER TO 409 109839, RELEASED DATE 7/17/02.SDR SIMA200219129Cargo Track · corrodedABI - CARGO AREA SEAT TRACK AT BL 0 HAS AREAS MEASURED BELOW LIMITS. SEAT TRACK ACCEPTED AS IS IAW SAAB 340 STATEMENT 340SDS004141, PARA 6. (M)SDR MALA020457Seat Track · corrodedDURING C-CHECK IN CVG, LEFT I/B SEAT RAIL NR 2, HAS 12 AREAS OF CORROSION. SEAT RAIL REPAIRED IAW EO A53026.SDR MALA020456Seat Track · corrodedDURING C-CHECK IN CVG, RIGHT I/B SEAT RAIL NR 3, HAS 7 AREAS OF CORROSION. SEAT RAIL REPAIRED IAW EO A53026.SDR MALA020455Seat Track · corrodedDURING C-CHECK IN CVG, RIGHT O/B SEAT RAIL HAS 6 AREAS OF CORROSION. SEAT RAIL REPAIRED IAW EO A53026.SDR SIMA200219130Cargo Track · corrodedDISC-CARGO AREA SEAT TRACK AT 18.3L HAS AREA CORROSION MEASURED BELOW LIMITS. REMOVED SECTION AND INSTALLED REPAIR EXTRUSION IAW SRM.SDR QXEA0201033Seat Track · corrodedPDX - LIGHT CORROSION ON RIGHT HAND INBOARD SEAT TRACK NR 9 AT STATION 531. REPAIRED IAW DHC-8-200 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0201029Seat Track · scratchedPDX - SCRATCH ON RIGHT HAND OUTBOARD SEAT TRACK NR 11 AT STATION 490. REPAIRED IAW RD 8-53-1342, DHC-8-200 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0201028Seat Track · corrodedPDX - LIGHT CORROSION ON RIGHT HAND OUTBOARD SEAT TRACK NR 11 AT STATION 485. REPAIRED IAW RD 8-53-1342, DHC-8-200 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0201027Seat Track · scratchedPDX - SCRATCH ON RIGHT HAND OUTBOARD SEAT TRACK NR 11 AT STATION 470. REPAIRED IAW DHC-8-200 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0201026Seat Track · scratchedPDX - SCRATCH ON RIGHT HAND OUTBOARD SEAT TRACK NR 11 AT STATION 450. REPAIRED IAW DHC-8-200 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0201025Seat Track · corrodedPDX - LIGHT CORROSION ON RIGHT OUTBOARD SEAT TRACK (NR 11) AT STATION 438. REPAIRED IAW DHC-8-202 SRM 51-20-16 AND SRM 51-20-36.SDR F3LA200200188Seat Track · corrodedDURING C-2 CHECK, INSPECTION REPORTED CORROSION ON TWO SEAT TRACKS BETWEEN BS 947 AND BS 967, RBL 11.50. FABRICATED AND INSTALLED REPLACEMENT SEAT TRACK PER SRM 51-30-02.SDR CALA0200392Seat Track · corrodedINSPECTION FOUND R/H CENTER SEAT TRACK CORRODED FROM FS 200-300. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-04, FIGURE 4.SDR AALA20020973Seat Track · corrodedTUL - FOUND NR 2 TRACK HAS CORROSION AT STATION 1200. REMOVED AND REPLACED SEAT TRACK NR 2 FROM STATION 1180-1309 PER SRM 53-05, PAGE 10G, FIG 4F. (M)SDR F3LA200200187Seat Track · corrodedDURING C-2 CHECK, INSPECTION REPORTED CORROSION ON TOP OF SEAT TRACK BETWEEN BS 947 AND BS 967, RBL 36.5. FABRICATED AND INSTALLED REPLACEMENT SEAT TRACK PER SRM 51-30-2.SDR MALA020392Seat Track · corrodedLT O/B CARGO SEAT TRACK AND ANGLE FROM STA 630.112 TO 686.888 HAS CORROSION. REMOVED CORROSION IAW 51-70-40.SDR UPS02838901Seat Track · wornINSPECTION TYPE:C2 CABIN STA 70 SEAT TRACK-E IS WORN. BLEND GOUGE IAW SRM 53-2-0 FIG 14. FOUND OUT OF LIMITS IAW 53-2-3. REMOVED DAMAGED SECTION AND FABBED NEW SEAT TRACK IAW DC8 SRM 53-2-3. INSTALLED NEW SEAT TRACK IAW DC8 SRM 53-2-3.SDR UPS02838900Seat Track · damagedINSPECTION TYPE:C2 ACP SRM REPAIR TO SEAT TRACK AT POS 2L/3L SUPERLOCK INSTALLED IAW EO M-2550-4101. CUT OUT DAMAGED SEAT TRACK SECTION, FABBED AND DRILLED NEW SEAT TRACK SECTION AND 2 SPLICES IAW DC8 SRM 53-2-3. INSTALLED NEW SEAT TRACK SECTION, SPLICES IAWSDR F3LA200200185Seat Track · corrodedDURING C-2 CHECK, INSPECTION REPORTED CORROSION ON CARGO FLOOR TRACK, STA 797 TO 809, RBL 14. REPLACED CARGO FLOOR TRACK PER SRM 51-30-02.SDR CALA0200387Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT FS 200-236, LBL 44. A NEW SEAT TRACK AND SPLICE WERE INSTALLED IAW SRM 51-30-5.SDR CALA0200379Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 200-220, RBL 24. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-10-4 AND 53-05, FIGURE 4.SDR UPS02M39031Seat Track · corrodedINSPECTION TYPE:C, AFT CARGO CORROSION ON SEAT TRACK BETWEEN STA 1841 - 1887 LBL 20. CORROSION FOUND EXCEEDING LIMIT PER SRM 53-70-00 FIG 3 VOL I REV 31. SEAT TRACK REMOVED, REWORKED IAW DWG AGA3855 AND INSTALLED AS PER SRM 51-31-01 VOL II REV 31.SDR SWIA200211059Seat Track · corrodedLEFT CABIN FLOOR SEAT TRACK CORRODED FORWARD AND AFT. REMOVED AND REPLACED LEFT CABIN FLOOR SEAT TRACKS IAW EMB120 MM 53-01-05.SDR MALA020377Seat Track · corrodedAISLE SEAT TRACK ANGLE FROM STA 339 TO STA 622 HAS LIGHT CORROSION.REMOOVED CORROSION IAW SRM 53-70-60.SDR MALA020376Galley Track · corrodedRT I/B GALLEY SEAT TRACK HAS LIGHT CORROSION. REMOVED CORROSION IAW SRM 53-70-40.SDR CALA0200374Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 225, LBL 24. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-5 AND 51-30-1.SDR GTIA020825Seat Track · corrodedFTW - PASSENGER CABIN RIGHT SEAT TRACK, RBL 44, STATION 1146 HAS CORROSION, SCRATCHES AND GOUGES. REMOVED DAMAGE AREA OF SEAT TRACK FROM STATION 1126 TO 1147. DRILLED AND LOCATED HOLES IN NEW SEAT TRACK AND SPLICES. FABRICATED SEAT TRACK. INSTALLED NEW SEASDR USAA020275Seat Track · corrodedPIT - FOUND SEAT TRACK CORRODED, STATION 907 AND 908 WBL 208. REMOVED CORROSION PER SRM 53-60-51. (M)SDR AALA20021048Seat Track · corrodedTUL - FOUND NR 5 SEAT TRACK CORRODED FROM STATION 200-218, AND STATION 235-238. INSTALLED NEW NR 5 SEAT TRACK FROM STATION 200-240 PER SRM 53-05 FIG 4. (M)SDR USAA020272Seat Track · corrodedPIT - FOUND SEAT TRACK CORRODED 2 INCH BY 2 INCH CORROSION, STATION 907 RT WBL 208 RBL 51. REMOVED CORROSION. (M)SDR AWXA200200608Cargo Track · corrodedDURING C-11 CHECK CORROSION WAS FOUND ON THE FORWARD CARGO COMPARTMENT RT LOADING JACK SCREW TRACK BS 691 TO BS 696, RBL 4. MAINTENANCE REMOVED DAMAGED SECTION OF FLOOR TRACK, FABRICATED A NEW SECTION OF TRACK AND 2 EACH REPAIR DOUBLERS; INSTALLED REPAIR PARTS
Back to JASC 5347