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 DHL200080534CCargo Track · crackedAT C-CHECK, MAIN CARGO COMPARTMENT- NR 6 TRACK DOUBLER CRACKED 5 INCHES AT STA 1600.000. REMOVED DAMAGED AREA IAW SRM 53-2-3 FIG 6B, CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B, PG 1-2, FABRICATED AND INSTALLED REINFORCING ANGLE IAW SRM 53-2-3, FIG 6B.SDR UPS00833617Seat Track · gougedINSPECTION TYPE:C2, 1ST OFFICERS SEAT BOTH LOWER AFT GUIDE RAILS GOUGED. REMOVED WORN GUIDE RAILS, INSTALLED RAILS P/N 4657562-501 AND 4657562- 502 WITH SCREWS AND NUTS IAW DC8 SRM 51-3-0.SDR CALA0001232Seat Track · corrodedINSPECTION FOUND RIGHT I/B SEAT TRACK CORRODED AT STA 236. THE CORRODED SECTION OF SEAT TRACK WAS REPLACED IAW SRM 53-05, FIGURE 4F.SDR CALA0001203Seat Track · corrodedINSPECTION FOUND CABIN SEAT TRACK CORRODED IN TRACK CHANNEL AT FS 1166 - 1169, RBL 24. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-1, 51-30-2, AND 53-05, FIGURE 4F.SDR CALA0001199Cargo Track · corrodedINSPECTION FOUND CORROSION AROUND SCREW HOLES ON TIE DOWN RAIL AT BS 727 - 947.5, RBL 13. REPAIRED IAW SRM 53-00-53, PAGE 205, FIGURE 205.SDR QXEA0002316Seat Track · corrodedYXX- LEFT HAND INBOARD FORWARD SEAT TRACK HAS EVIDENCE OF PITTING CORROSION AT SEAT ATTACH SPOTS. REPAIRED IAW DHC-8 AD 8-53-3074 AND 8-53-1339.SDR DHL200080505CCargo Track · crackedAT C-CHECK, FWD BAGGAGE COMPARTMENT-RT TRACK CRACKED .5 INCH AT STA 380.000. REMOVED DAMAGED TRACK IAW SRM 51-3-0 PG 2-3, CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B, PG 1-2, INSTALLED NEW TRACK IAW SRM 51-3-0 PG 2-3.SDR AALA20001394Seat Track · corrodedTUL - FOUND CORROSON UNDER DOUBLER AT FORWARD END NR 6 SEAT TRACK STATION 218. COMPLETED SEAT TRACK, SPLICE 218-313 STATION SRM 53-05 FIG 4. (M)SDR AALA20001293Track · corrodedTUL - FOUND LAV L TRACK C LEFT IS CORRODED ON TOP. REMOVED CORROSION PER SRM, BEYOND LIMITS. INSTALLED REPAIR STRAP PER AARD 53-20-00-2. (M)SDR AALA20001304Seat Track · corrodedTUL - FOUND CORROSION ON SEAT TRACK NR 1, STATION 1280. REMOVED CORRODED SECTION OF NR 1 SEAT TRACK, INSTALLED NEW SECTION OF NR 1 SEAT TRACK 1157 TO 1309 PER SRM 51-01. (M)SDR QXEA0002345Seat Track · corrodedYXX- SURFACE CORROSION ON RIGHT HAND INBOARD SEAT TRACK AT CARGO HOLD DOWN ATTACH POINT X597.500 AND 9.250. REPAIRED IAW DHC-8 SRM 51-20-00 PAGE 5 AND RD 8-53-4936.SDR QXEA0002320Seat Track · corrodedYXX- RIGHT HAND INBOARD AFT SEAT TRACK HAS CORROSION WHERE SEATS ATTACH. REPAIRED IAW DHC-8 AD 8-53-1339 AND DHC-8 SRM 51-00-06 AND 51-20-00 PAGE 5.SDR QXEA0002317Seat Track · corrodedYXX- LEFT HAND INBOARD AFT SEAT TRACK HAS PITTING CORROSION WHERE SEATS ATTACH TO TRACK. REPAIRED IAW DHC-8 AD 8-53-1339 AND DHC-8 SRM 51-20-00 PAGE 5.SDR QXEA0002314Seat Track · corrodedYXX- LEFT HAND OUTBOARD AFT SEAT TRACK HAS PITTING CORROSION. REPAIRED IAW DHC-8 SRM 51-20-00 PAGE 5.SDR QXEA0002309Seat Track · corrodedYXX- RIGHT HAND FORWARD CABIN SEAT TRACK CORRODED AT ALL SEAT TRACK ATTACHMENT POINTS. REPAIRED IAW DHC-8 AD 8-53-1342 AND DHC-8 SRM 51-40-00.SDR USAA001133Seat Track · corrodedCLT - FOUND SEAT TRACK CORRODED 2 INCHES, SEAT TRACK LBBL 25 INCHES STATION 377. REMOVED AND REPLACED PER SRM 51-10-00. (M)SDR USAA001134Seat Track · corrodedCLT - FOUND SEAT TRACK CORRODED 2 INCHES BY 16 INCHES, BS 1640, LBL 24.75. REPLACED SEAT TRACK PER SRM 53-00-04. (M)SDR USAA001135Seat Track · corrodedCLT - FOUND SEAT TRACK CRACKED 2 INCHES BY 20 INCHES, SEAT TRACK STATION 1640, LBL 45.5. REPLACED SEAT TRACK PER SRM 53-00-04. REPLACED SEAT TRACK PER SRM 53-00-04. (M)SDR DHL200080512CCargo Track · corrodedAT C-CHECK, MAIN CARGO COMPARTMENT FLOOR TRACK NR 4 SHOWS CORROSION BETWEEN STA 1010 AND STA 1050. CUT OUT DAMAGED AREA IAW SRM 53-2-3 PG 49-50, CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B, PG 1-2, INSTALLED NEW TRACK AND SPLICE IAW SRM 53-2-3, PG 49-50.SDR DHL200080510CCargo Track · wornAT C-CHECK, MAIN CARGO COMPARTMENT TRACK NR 3 LUG WORN FROM STA 1380.000 TO 1400.000. CUT OUT DAMAGED AREA IAW SRM 53-2-3, PG 49-50, CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B, PG 1-2, INSTALLED NEW TRACK AND SPLICE IAW SRM 53-2-3, PG 49-50.SDR L1GA200000239Seat Track · damagedSEVERAL ELONGATED HOLES IN TOP RAIL OF SEAT TRACK. R2 TOP RAIL PILOTS SEAT. REPLACED TOP RAIL DOUBLER.SDR L1GA200000238Seat Track · damagedSEVERAL ELONGATED .25 INCH HOLES IN CO-PILOTS SEAT TRACK O/B AFT SIDE. R2 TOP RAIL REPAIR DOUBLER.SDR L1GA200000237Seat Track · corrodedSEVERAL ELONGATED HOLES IN TOP RAIL ON CO-PILOTS SEAT TRACK. R2 TOP RAIL DOUBLER.SDR L1GA200000236Seat Track · corrodedA 19 X 1 INCH CORRODED AREA ON SEAT TRACK. SPLICED IN REPAIR.SDR L1GA200000235Seat Track · corrodedA 36 X 1 INCH CORRODED AREA ON SEAT TRACK. REMOVED AND REPLACED SEAT TRACK.SDR L1GA200000234Seat Track · corrodedA 24 X 1 INCH CORRODED AREA ON SEAT TRACK. SPLICED IN REPAIR.SDR L1GA200000233Seat Track · corrodedA 10 X 1 INCH CORRODED AREA ON SEAT TRACK. SPLICED IN NEW SECTION OF SEAT TRACK.SDR L1GA200000232Seat Track · corrodedA 21 X 1 INCH CORRODED AREA ON SEAT TRACK. INSTALLED SEAT TRACK SPLICE.SDR L1GA200000227Seat Track · corrodedA 20 X 1 INCH CORRODED AREA AT FS 542 - 562 BL 44 LT SEAT TRACK. INSTALLED SEAT TRACK PLUG.SDR USAA001197Seat Track · corrodedPIT - FOUND SEAT TRACK CORRODED 1 INCH BY 1 INCH AREA 6 PLACES AT ATTACH POINT, LEFT STATION 1174-1305 OUTBOARD SEAT TRACK. SPLICE DIN NEW SECTION PER SRM 53-05 FIG 4F SHT 2. TASK NR C53-53-300. (M)SDR DHL200080509CCargo Track · wornAT C-CHECK, MAIN CARGO COMPARTMENT-TRACK NR 3 LUGS WORN STA 952.00. CUT OUT DAMAGED AREA IAW SRM 53-2-3, PG 49-50. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B PG 1-2. INSTALLED NEW TRACK AND SPLICE IAW SRM 53-2-3 PG 49-50.SDR TWAA0013208Seat Track · corrodedDURING CHECK-C MAINT, IN THE COCKPIT THE AFT EXTENSION OF THE F/O SEAT O/B TRACK WAS CORRODED. REPLACED F/O SEAT TRACK AFT O/B PER DRAWING 9957871-535 AND LOCATED MOUNT HOLES. INSTALLED ON NON-ROUTINE.SDR CALA0001188Seat Track · corrodedINSPECTION FOUND CABIN SEAT TRACK CORRODED IN TRACK CHANNEL AT FS 439 - 443, LBL 56. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS INSTALLED WITH REPAIR STRAPS IAW SRM 51-30-7, 53-05, FIGURE 4F, 51-30-5, AND 51-30-1.SDR DHL200080554CCargo Track · deterioratedAT C-CHECK, MAIN CARGO- NR 3 TRACK SHOWS FLOOR SUPPORT HOLES DETERIORATED FROM STA 250.000 TO STA 130.000. CUT OUT DAMAGED AREA IAW SRM 53-2-3, PG 49-50, CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B, PG 1-2, INSTALLED NEW TRACK AND SPLICE IAW SRM 53-2-3, SDR DHL200080514CCargo Track · brokenAT C-CHECK, MAIN CARGO COMPARTMENT- TRACK NR 6 LUG BROKEN FROM STA 1580.000 TO 1600.000. CUT OUT DAMAGED AREA IAW SRM 53-2-3, PG 49-50, CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B, PG 1-2, INSTALLED NEW TRACK AND SPLICE IAW SRM 53-2-3, PG 49-50.SDR DHL200080513CCargo Track · wornAT C-CHECK, MAIN CARGO COMPARTMENT NR 2 TRACK LUGS WORN FROM STA 230.000 TO STA 62.000. CUT OUT DAMAGED AREA IAW SRM 53-2-3 PG 49-50, CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B, PG 1-2, INSTALLED NEW TRACK AND SPLICE IAW SRM 53-2-3, PG 49-50.SDR DHL200080508CCargo Track · wornAT C-CHECK, MAIN CARGO COMPARTMENT-TRACK NR 4 LUGS WORN STA 1135.00. CUT OUT DAMAGED AREA IAW SRM 53-2-3, PG 49-50, CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B, PG 1-2, INSTALLED NEW TRACK AND SPLICE IAW SRM 53-2-3, PG 49-50.SDR DHL200080518CCargo Track · wornAT C-CHECK, MAIN CARGO COMPARTMENT-TRACK NR 4 LUGS WORN STA 1135.00. CUT OUT DAMAGED AREA IAW SRM 53-2-3, PG 49-50, CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B, PG 1-2, INSTALLED NEW TRACK AND SPLICE IAW SRM 53-2-3, PG 49-50.SDR DHL200080516CCargo Track · brokenAT C-CHECK, MAIN CARGO COMPARTMENT-TRACK NR 6 LUG BROKEN FROM STA 1580.000 TO 1600.000. CUT OUT DAMAGED AREA IAW SRM 53-2-3, PG 49-50, CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B, PG 1-2, INSTALLED NEW TRACK AND SPLICE IAW SRM 53-2-3, PG 49-50.SDR DHL200080515CCargo Track · wornAT C-CHECK, MAIN CARGO COMPARTMENT NR 2 TRACK LUGS WORN FROM STA 230.000 TO STA 62.000. CUT OUT DAMAGED AREA IAW SRM 53-2-3 PG 49-50, CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B, PG 1-2, INSTALLED NEW TRACK AND SPLICE IAW SRM 53-2-3, PG 49-50.SDR TWAA0013205Seat Track · corrodedDURING CHECK-C MAINT, THE AFT EXTENSION OF THE F/O SEAT TRACK, O/B WAS CORRODED. REPLACED F/O SEAT TRACK AFT O/B PER DRAWING 9957871-503 AND LOCATED MOUNTING HOLES.SDR TWAA0013204Cargo Track · corrodedDURING CHECK-C MAINT IN AFT CARGO COMPT THE LT TIE DOWN TRACK WAS CORRODED AT STA 1155 TO 1320. MANUFACTURED AND DRILLED HOLES FOR NEW TIE DOWN TRACK SECTIONS MADE FROM P/N 1D0026B21700 AND S2922357-14400.SDR TWAA0013506Seat Track · corrodedDURING OP 15 MAINT CHECK, FOUND CORROSION ON FLOOR TRACK AT LBL 44 FROM STA 200 TO 229, BETWEEN FLOOR PANEL 15 AND 16. REMOVED DAMAGED TRACK AND REPLACED PER SRM 53-05 FIG 4F, AND INSTALLED PER SRM 51-30-01 AND SRM 51-30-05. SPLICED SRM 6-70-01.SDR DHL200080507CCargo Track · wornAT C-CHECK, MAIN CARGO COMPARTMENT TRACK NR 7 LUGS WORN AT STA 180.00. CUT OUT DAMAGED AREA IAW SRM 53-2-3 PG 49-50. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B, PG 1-2, INSTALLED NEW TRACK AND SPLICE IAW SRM 53-2-3 PG 49-50.SDR DHL200080517CCargo Track · wornAT C-CHECK, MAIN CARGO COMPARTMENT TRACK NR 7 LUGS WORN AT STA 180.00. CUT OUT DAMAGED AREA IAW SRM 53-2-3, PG 49-50, CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B, PG 1-2, INSTALLED NEW TRACK AND SPLICE IAW SRM 53-2-3, PG 49-50.SDR TWAA0013202Seat Track · corrodedDURING CHECK-C MAINT, CHAIR TRACK LBL 44 HAD CORROSION AT STA 1260 TO 1309. INSTALLED TRACK PER SRM 51-30-1 AND SRM 51-30-2. REPLACED TRACK PER SPM 6-70-01.SDR ASAA0080488Cargo Track · corrodedPHX - DURING 30K CHECK, THE AFT CARGO COMPARTMENT LEFT CARGO TRACK AT STATION 1220-1309, LONGERON 16L WAS FOUND TO BE EXFOLIATED. REPAIRED PER SRM 51-30-5. (M)SDR ASAA0080485Cargo Track · corrodedPHX - DURING 30K CHECK, THE AFT CARGO COMPARTMENT, RIGHT AFT CARGO TRACK WAS FOUND TO BE CORRODED AROUND THE FASTENER HOLES AT STATION 1212-1307, STRINGER 16R. REPAIRED PER SRM 51-30-0. (M)SDR SIMA2212Seat Track · corrodedSBP - DURING 500 HOUR INSPECTION, FOUND CORROSION ON FORWARD END OF 18.3 BL LEFT SEAT TRACK. CUT SEAT TRACK AT FS 325.8 AND INSTALLED NEW SECTION OF REPAIR TRACK AND U-BEAM IAW SAAB SRM 53-70-60. (M)SDR DHL200080557CCargo Track · wornAT C-CHECK, MAIN CARGO COMPARTMENT-TRACK NR 5 LUG WORN STA 1700.000. CUT OUT DAMAGED AREA IAW SRM 53-2-3, PG 49-50. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B, PG 1-2, INSTALLED NEW TRACK AND SPLICE IAW SRM 53-2-3, PG 49-50.
Back to JASC 5347