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 05FDEA01085Seat Track · gougedCLS ADAPTER AT FR 37 TRACK L3 IS GOUGED. REMOVED AND REPLACED CLS ADAPTER AT FR 37 TRACK L4, L3 MDC IAW A310-200 SRM 53-10- 16.SDR UIEA200500062Seat Track · damagedMAIN DECK SEAT TRACK DAMAGED AT SAT 1810 NEXT TO SIDE CARGO DOOR. SEAT TRACK REPAIRED IAW SRM. (K)SDR MALA050381Seat Track · corrodedDURING 4Y/2Y CHECK IN BNA FOUND SEAT TRACKS AT LBL 18.3 AND BL 0 ARE CORRODED AND HAVE BEEN REPAIRED IAW MESABA EO S53060 AT LBL 18.3 BETWEEN FS 297 AND 319 AND IAW SRM 53-70-60 AT BL 0 BETWEEN FS 297 AND FS 310.SDR 05FDEA01060Seat Track · damagedSEAT TRACK, STA 344 - 480 HAS EXISTING BLEND REPAIRS AND REQUIRES REPLACEMENT PER 7-5340-7-5002, LBL 45. REMOVED SEAT TRACK STA 344 - 480 LBL 45 IAW SRM 51-30-2. FABRICATED NEW SEAT TRACK PER TRAVELER NR T5/510063, BATCH NR 888841, PO NR MST0017183. LOCATESDR 05FDEA01059Seat Track · damagedSEAT TRACK, STA 344, LBL 24 HAS EXISTING BLEND REPAIRS AND REQUIRES REPLACEMENT PER 7-5340-7-5002. REMOVED SEAT TRACK STA 344 - 480 IAW SRM 51-30-2. FABRICATED NEW SEAT TRACK PER TRAVELER NRT5/510064, BATCH NR 888841, P.O. NR MST0017183. LOCATED AND DRILLEDSDR 05FDEA01057Seat Track · corrodedMAIN DECK, UPON REMOVAL OF FLOOR PANEL 291GF FOR SHEETMETAL ACCESS AT STA 1887 LBL 60 INCH SEAT TRACK FOUND CORRODED. CORROSION ON SEAT TRACK REMOVED & FOUND EXCEED LIMIT AS PER SRM 53-70-00 FIG 3 VOL I. SEAT TRACK REWORKED AS PER SRM 53-70-00 FIG.1 VOL I.SDR USAA050630Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED 1.5 INCH BY 1.4 INCH WIDE BY .080 INCH DEEP, FRAME 73 AND 74 Y=-450. CORROSION LEVEL 2, TASK C534159-01. REMOVED AND REPLACED SEAT TRACK PER SRM 53-00-15, 51-42-11. (M)SDR DHL2005807514Cargo Track · deterioratedMAIN CARGO COMPT NR 2 TRACK LUGS DETERIORATED, STA 1210.000. CUT OUT NR 2 TRACK DAMAGED SECTION IAW SRM 53-2-3 PG 17 FIG 6D. CLEANED AND TREATED AREA IAW SRM 51-1-8B. INSTALLED NEW CHANNEL AND PLUG IAW SRM 53-2-3, SRM 51-3-0 PG 1. TORQUED IAW SRM 51-3-1.SDR DHL2005807513Cargo Track · deterioratedMAIN CARGO COMPT NR 3 TRACK LUGS DETERIORATED, STA 863.000. CUT OUT NR 3 TRACK DAMAGED SECTION IAW SRM 53-2-3 PG 17 FIG 6D. CLEANED AND TREATED AREA IAW SRM 51-1-8B. INSTALLED NEW CHANNEL AND PLUG IAW SRM 53-2-3, SRM 51-3-0 PG 1. TORQUED IAW SRM 51-3-1.SDR DHL2005807512Cargo Track · wornMAIN CARGO COMPT NR 2 TRACK LUG WORN, STA 689.000. CUT OUT NR 2 TRACK DAMAGED SECTION, STA 689.000 IAW SRM 53-2-3 PG 17 FIG 6D. CLEANED AND TREATED AREA IAW SRM 51-1-8B. INSTALLED NEW CHANNEL AND PLUG IAW SRM 53-2-3 SRM 51-3-0 PG 1. TORQUED IAW SRM 51-3-1.SDR USAA050551Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED 10 INCHES BY 3 INCHES, STATION 871 RBL 54.81. INSTALLED REPAIR AND SPLICES PER SRM 53-00-51 FIG 203 AND 51-40-02. (M)SDR USAA050540Seat Track · gougedBFM - FOUND SEAT TRACK WITH NICKS AND GOUGES, .90 INCH BY .2 INCH BY .022 INCH AND .40 INCH BY .10 INCH BY .025 INCH, MCD FROM STATION 480-520. FABRICATED NEW SEAT TRACK, REMOVED AND REPLACED PER SRM 53-00-52, SRM 51-40-02. (M)SDR MALA050376Seat Track · corrodedDURING C2 INSPECTION, FOUND SEAT RAIL BETWEEN FRAMES 18 & 19 AT LBL 39 CORRODED.SDR ASAA0570018Seat Track · wornPAE - DURING CHECK FOUND FLIGHT DECK F/O`S INBOARD AFT SEAT TRACK IS WORN. REPAIRED IAW MM 25-11-11. (M)SDR QXEA200500824Seat Track · gougedYYC - FUSELAGE INTERIOR LEFT FLOOR SEAT RAIL AT STATION 399.0 IS GOUGED. REPAIRED IAW REO 670-53-00-013.SDR MALA050372Seat Track · corrodedGALLEY SEAT TRACK P/N 7253721-459, IS CORRODED AND HAS BEEN REPLACED IAW SRM 51-40-27.SDR USAA050519Seat Track · corrodedPIT - FOUND SEAT TRACK CORRODED .25 INCH DIAMETER SPOT, RT OUTBOARD SEAT TRACK, FRAME 66. DEFECTIVE PART REPLACED WITH IDENT PART PER SRM 51-72-11. CORROSION LEVEL 1, TASK NR JA-260-53500. (M)SDR USAA050521Seat Track · corrodedPIT - FOUND SEAT TRACK CORRODED, RT INBOARD SEAT TRACK AT FRAME 20. DEFECTIVE PART REPLACED WITH IDENT PART PER SRM 51-72-11. CORROSION LEVEL 1, TASK JA-220-53500. (M)SDR MALA050364Seat Track · corrodedDURING C2 INSPECTION FOUND AFT RIGHT OUTBOARD SEAT RAIL BETWEEN FRAME 43-44 CORRODED.SDR QXEA200500689Seat Track · corrodedPDX - LEFTHAND INBOARD SEAT TRACK HAS SURFACE CORROSION BETWEEN STATION 222.7 AND STATION 240.0 IN FIVE LOCATIONS. REPAIRED IAW DHC-8 200 SRM 51-40-11 AND RD 8-53-4473.SDR QXEA200500688Seat Track · corrodedPDX - RIGHTHAND INBOARD SEAT TRACK IS CORRODED IN NUMEROUS LOCATION ON TOP BETWEEN X201 AND X222.7. REPAIRED IAW DHC-8 200 SRM 51-40-11 AND RD 8-53-4473.SDR USAA050523Seat Track · corrodedPIT - FOUND SEAT TRACK BEAM CORRODED .25 INCH BY 1.5 INCH AREA, FRAME 66-68. DEFECTIVE PART REPLACED WITH IDENT PART NUMBER. (M)SDR ASOA05338Seat Track · crackedDURING A C-CHECK IN MCN, THE SEAT TRACK AT FS 559 PLUS 78 TO PLUS 88, RBL 9 WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE IS REMOVING AND REPLACING THE SEAT TRACK AT FS 559 PLUS 78 TO PLUS 88, RBL 9. (M)SDR USAA050498Seat Track · corrodedPIT - FOUND SEAT TRACK CORRODED 1 FT BY 1.5 INCH FRAME 20. DEFECTIVE PART REPLACED WITH IDENT PART. (M)SDR MALA050354Seat Track · corrodedDURING C2 INSPECTION FOUND SEAT RAILS BETWEEN FRAMES 18-19 AT RBL 39 CORRODED.SDR MALA050340Seat Track · corrodedDURING 4Y/2Y CHECK IN BNA FOUND GALLEY SEAT TRACK P/N 7253721-459 IS CORRODED AND WILL BE REPLACED IAW SRM 51-40-27.SDR MALA050435Seat Track · corrodedDURING 4Y/2Y CHECK IN BNA FOUND SEAT TRACK AT LBL 18.3 IS CORRODED ON VERTICAL WEB AND FLOOR PANEL FLANGE, BETWEEN FS 294 AND 319. DAMAGE HAS BEEN REPAIRED IAW SRM 53-70-60.SDR MALA050353Seat Track · corrodedDURING C2 INSPECTION FOUND SEAT RAILS BETWEEN FRAMES 18-19 AT RBL 18 CORRODED.SDR MALA050342Seat Track · corrodedDURING 4Y/2Y CHECK IN BNA FOUND SEAT TRACK AT BL 0 IS CORRODED ON VERTICAL WEB AND FLOOR PANEL FLANGE BETWEEN FS 294 AND FS 319. DAMAGE HAS BEEN REPAIRED IAW SRM 53-70-60.SDR MALA050331Seat Track · corrodedDURING 4Y/2Y CHECK IN BNA FOUND GALLEY SEAT TRACK P/N 7253721-459 AND PROFILE P/N 7253721-495 ARE CORRODED AND HAVE BEEN REPLACED IAW SRM 51-40-21/22.SDR MALA050335Seat Track · corrodedDURING 4Y/2Y CHECK IN BNA FOUND SEAT TRACK AT BL 0 IS CORRODED ON VERTICAL WEB AND FLOOR SUPPORT FLANGE AND HAS BEEN REPAIRED FROM FS 297 TO FS 312 IAW SRM 53-70-60.SDR DHL2005367504Seat Track · corrodedDURING C-CHECK, CABIN SEAT TRACK AT FS 18 THRU FS 21A AT BL 18L HAS CORROSION ( MKD). REPLACED SECTION OF SEAT TRACK FROM FR 19 TO FR 21A AT BL 18L P/N TMS 60-22457 ABOUT 40 INCH LONG AS PER A-300 51-10-40 PO NR 2113624, SPLICE ANGLES P/N TMS 60-3032 LOT NR 1SDR QXEA200500666Seat Track · corrodedPDX - CORROSION IN AND AROUND SCREW HOLES ON NR 6 SEAT TRACK INBOARD FLANGE AT STATION X264 AND X580. REPAIRED IAW DHC-8 200 SRM 51-40-11 AND RD 8-53-784.SDR XEA200500648Seat Track · corrodedPDX - LEFT OUTBOARD SEAT TRACK NR 1 HAS CORROSION ON TOP OF LUGS AT X296. REPAIRED IAW RD 8-53-1342.SDR QXEA200500647Seat Track · corrodedPDX - LEFT OUTBOARD SEAT TRACK NR 1 HAS LIGHT CORROSION IN BOTTOM OF CHANNEL AT X278 TO X285. REPAIRED IAW RD 8-53-1342.SDR QXEA200500645Seat Track · corrodedPDX - LEFT OUTBOARD NR 1 SEAT TRACK HAS CORROSION ON TOP OF LUGS AT STATION X264 TO X265. REPAIRED IAW RD8-53-1342.SDR QXEA200500644Seat Track · corrodedPDX - LEFT OUTBOARD SEAT TRACK NR 1 HAS LIGHT CORROSION ON SCRATCH IN BOTTOM OF CHANNEL, FORWARD OF X262. REPAIRED IAW DHC-8 200 NDTM PART 1, 51-00-06 AND RD 8-53-1342.SDR QXEA200500655Seat Track · damagedPDX - LEFT OUTBOARD SEAT TRACK NR 1 HAS DAMAGE ON TOP OF LUGS AT X376. REPAIRED IAW RD 8-53-1342.SDR QXEA200500660Seat Track · gougedPDX - GOUGE IN RIGHT OUTBOARD SEAT TRACK AT STATION X468.0. REPAIRED IAW RD 8-53-1342.SDR QXEA200500656Seat Track · corrodedPDX - LEFT OUTBOARD SEAT TRACK NR 1 HAS CORROSION ON TOP OF LUGS AT X421. REPAIRED IAW RD 8-53-1342.SDR QXEA200500652Seat Track · corrodedPDX - LEFT OUTBOARD SEAT TRACK NR 1 HAS CORROSION ON TOP OF LUGS AT X345 - 346. REPAIRED IAW RD 8-53-1342.SDR QXEA200500651Seat Track · corrodedPDX - LEFT OUTBOARD SEAT TRACK NR 1 HAS CORROSION ON TOP OF LUGS AT X330. REPAIRED IAW RD 8-53-1342.SDR QXEA200500654Seat Track · corrodedPDX - LEFT OUTBOARD SEAT TRACK NR 1 HAS CORROSION ON TOP OF LUGS AT X345. REPAIRED IAW RD 8-53-1342.SDR QXEA200500653Seat Track · corrodedPDX - LEFT OUTBOARD SEAT TRACK NR 1 HAS CORROSION ON BOTTOM OF CHANNEL AT X345. REPAIRED IAW RD 8-53-1342.SDR QXEA200500659Seat Track · corrodedPDX - CORROISON IN CENTER OF RIGHT OUTBOARD SEAT TRACK AT STATION X489.0. REPAIRED IAW RD 8-53-1342.SDR QXEA200500658Seat Track · gougedPDX - GOUGE IN RIGHT OUTBOARD SEAT TRACK AT STATION 310.0. REPAIRED IAW RD 8-53-1342.SDR QXEA200500661Seat Track · corrodedPDX - CORROSION IN CENTER OF RIGHT OUTBOARD SEAT TRACK AT STATION X502.0. REPAIRED IAW RD 8-53-1342.SDR QXEA200500657Seat Track · gougedPDX - GOUGE IN CENTER OF RIGHTHAND OUTBOARD SEAT TRACK AT STATION X282.0. REPAIRED IAW RD 8-53-1342.SDR QXEA200500650Seat Track · corrodedPDX - LEFT OUTBOARD SEAT TRACK NR 1 HAS CORROSION IN BOTTOM OF CHANNEL AT X312 TO X314. REPAIRED IAW RD 8-53-1342.SDR QXEA200500646Seat Track · damagedPDX - LEFT OUTBOARD SEAT TRACK NR 1 HAS DAMAGE ON TOP OF LUGS AT X278. REPAIRED IAW RD 8-53-1342.
Back to JASC 5347