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 QXEA200601803Seat Track · corrodedPDX - C4 SEAT TRACK NR 11 HAS LIGHT CORROSION ON SEAT ATTACH AREAS AT STATION X455 AND STATION X469. REPAIRED IAW RD 8-53-1342 AND DHC-8-200 SRM 51-20-16.SDR QXEA200601802Seat Track · corrodedPDX - C4 SEAT TRACK NR 11 HAS LIGHT CORROSION ON SEAT ATTACH AREAS AT STATION X438. REPAIRED IAW RD 8-53-1342 AND DHC-8-200 SRM 51-20-16.SDR QXEA200601796Seat Track · corrodedPDX - C4 SEAT TRACK NR 1 HAS LIGHT CORROSION ON SEAT ATTACH AREAS AT STATION X393 AND STATION X405. REPAIRED IAW RD 8-53-1342.SDR QXEA200601801Seat Track · corrodedPDX - C4 SEAT TRACK NR 3 HAS LIGHT CORROSION ON SEAT ATTACH AREAS AT STATION X518 AND STATION X531. REPAIRED IAW RD 8-53-3644.SDR QXEA200601795Seat Track · corrodedPDX - C4 SEAT TRACK NR 1 HAS LIGHT CORROSION ON SEAT ATTACH AREAS AT STATION X2363 AND STATION X376. REPAIRED IAW RD 8-53-1342.SDR QXEA200601794Seat Track · corrodedPDX - C4 SEAT TRACK NR 1 HAS LITE CORROSION ON SEAT ATTACH AREAS AT STATION X2328 AND X342. REPAIRED IAW RD 8-53-1342.SDR QXEA200601793Seat Track · corrodedPDX - C4 SEAT TRACK NR 1 HAS LIGHT CORROSION ON SEAT ATTACH AREAS AT STATION X298 AND STATION X312. REPAIRED IAW RD 8-53-1342.SDR QXEA200601792Seat Track · corrodedPDX - C4 SEAT TRACK NR 1 HAS LIGHT CORROSION ON SEAT ATTACH AREAS AT STATION X266 AND STATION X280. REPAIRED IAW RD 8-53-1342.SDR QXEA200601800Seat Track · corrodedPDX - C4 SEAT TRACK NR 2 HAS LIGHT CORROSION ON SEAT ATTACH AREAS AT STATION X487 AND STATION X500. REPAIRED IAW RD 8-53-1342.SDR QXEA200601799Seat Track · corrodedPDX - C4 SEAT TRACK NR 2 HAS LIGHT CORROSION ON SEAT ATTACH AREAS AT STATION X4455 AND STATION X469. REPAIRED IAW RD 8-53-1342.SDR QXEA200601798Seat Track · corrodedPDX - C4 SEAT TRACK NR 2 HAS LIGHT CORROSION ON SEAT ATTACH AREAS AT STATION X438. REPAIRED IAW RD 8-53-1342.SDR QXEA200601969Seat Track · corrodedPDX C3 RIGHT HAND OUTBOARD SEAT TRACK 18 HAS LIGHT CORROSION INSIDE CHANNEL BETWEEN FUSELAGE STATION X554 AND X569. REPAIRED IAW RD 8/4-53-884.SDR QXEA200601968Seat Track · corrodedPDX C3 RIGHT HAND OUTBOARD SEAT TRACK #18 HAS .011 DEEP CORROSION PIT INSIDE CHANNEL AT FUSELAGE STATION X541. REPAIRED IAW RD 8-4-53-884.SDR QXEA200601967Seat Track · damagedPDX C3 RIGHT HAND OUTBOARD SEAT TRACK 18 HAS SCRATCH MARKS INSIDE CHANNEL AT FUSELAGE STATION X523. REPAIRED IAW RD 8/4-53-884.SDR QXEA200601966Seat Track · corrodedPDX C3 RIGHT HAND OUTBOARD SEAT TRACK 18 HAS LIGHT CORROSION AND SCRATCH MARKS INSIDE CHANNEL BETWEEN FUSELAGE STATION X496 AND 509. REPAIRED IAW RD 8/4-53-884.SDR QXEA200601965Seat Track · corrodedPDX C3 RIGHT HAND OUTBOARD SEAT TRACK 18 HAS LIGHT CORROSION AND SCRATCH MARKS INSIDE CHANNEL BETWEEN FUSELAGE STATION X447 AND X489. REPAIRED IAW RD 8/4-53-884.SDR QXEA200601964Seat Track · corrodedPDX C3 RIGHT HAND OUTBOARD SEAT TRACK #18 HAS LIGHT CORROSION INSIDE AND ON TOP OF CHANNEL BETWEEN FUSELAGE STATION X449 AND X458. REPAIRED IAW RD 8/4-53-884.SDR QXEA200601963Seat Track · corrodedPDX C3 RIGHT HAND OUTBOARD SEAT TRACK NR 18 HAS LIGHT CORROSION INSIDE CHANNEL AT FUSELAGE STATION X388. REPAIRED IAW RD 8/4-53-884.SDR QXEA200601962Seat Track · corrodedPDX C3 RIGHT HAND OUTBOARD SEAT TRACK #18 HAS LIGHT CORROSION INSIDE CHANNEL BETWEEN FUSELAGE STATION X354 AND X373. REPAIRED IAW RD 8/4-53-884.SDR QXEA200601961Seat Track · corrodedPDX C3 - RIGHT OUTBOARD SEAT TRACK NR 18 HAS PITTTING CORROSION INSIDE CHANNEL BETWEEN FUSELAGE STATION X323 AND 341. REPAIRED IAW RD 8/4-53-884.SDR QXEA200601960Seat Track · corrodedPDX C3 - RIGHT OUTBOARD SEAT TRACK NR 18 HAS PITTTING CORROSION INSIDE CHANNEL AND ON TOP BETWEEN FUSELAGE STATION X281 AND 291. REPAIRED IAW RD 8/4-53-884.SDR QXEA200601959Seat Track · corrodedPDX C3 - RIGHT OUTBOARD SEAT TRACK NR 18 HAS PITTTING CORROSION INSIDE CHANNEL BETWEEN FUSELAGE STATION X249 AND X258. REPAIRED IAW RD 8/4-53-884.SDR QXEA200601958Seat Track · corrodedPDX C3 - RIGHT OUTBOARD SEAT TRACK NR 17 HAS PITTING CORROSION INSIDE CHANNEL BETWEEN FUSELAGE STATION X186 TO X192. REPAIRED IAW RD 8/4-536-884.SDR QXEA200601957Seat Track · corrodedPDX C3 - RIGHT OUTBOARD SEAT TRACK NR 17 HAS PITTING CORROSION INSIDE AND ON TOP OF CHANNEL FROM FUSELAGE STATION X156 TO X176. REPAIRED IAW RD 8/4-53-884.SDR QXEA200601956Seat Track · corrodedPDX C3- RIGHT OUT BOARD SEAT TRACK NR 17 HAS PITTING CORROSION INSIDE AND ON TOP OF CHANNEL AT FUSELAGE STATION X142. REPAIRED IAW RD 8/4-53-884.SDR QXEA200601955Seat Track · chafedPDX C3 - RIGHT SEAT TRACK HAS MINOR CHAFING AT BOTTOM OF CHANNEL AT STATION 574-638. REPAIRED IAW RD 8/4-53-884.SDR QXEA200601954Seat Track · chafedPDX C3 - RIGHT INBOARD SEAT TRACK HAS MINOR CHAFING AT BOTTOM OF CHANNEL AT STATION 442-567. REPAIRED IAW RD 8/4-53-884.SDR QXEA200601953Seat Track · chafedPDX C3 - LEFT INBOARD SEAT TRACK HAS MINOR CHAFING AT BOTTOM OF CHANNEL AT STATION 509 TO 529. REPAIRED IAW DHC-8-400 RD 8/4-53-884.SDR QXEA200601952Seat Track · chafedPDX C3 - RIGHT INBOARD SEAT TRACK HAS MINOR CHAFING IN BOTTOM OF CHANNEL AT STATION 327-434. REPAIRED IAW DHC-8-400 RD 8/4-53-884.SDR QXEA20061951Seat Track · chafedPDX C3 - LEFT INBOARD SEAT TRACK HAS MINOR CHAFING IN BOTTOM OF CHANNEL AT STATION 327-434. REPAIRED IAW DHC-8-400 RD 8/4-53-884.SDR QXEA200601950Seat Track · corrodedPDX C3 - LEFT INBOARD SEAT TRACK HAS MINOR CHAFING IN BOTTOM OF CHANNEL AT STATION 236-295. REPAIRED IAW RD 8/4-53-884.SDR QXEA200601949Seat Track · chafedPDX C3 RIGHT HAND INBOARD SEAT TRACK HAS MINOR CHAFING AT STATION 116 TO 132, STATION 146 TO 160, STATION 178 TO 194 AND STATION 210 TO 224. REPAIRED IAW RD 8/4-53-884.SDR QXEA200601948Seat Track · corrodedPDX C3 LEFT HAND INBOARD SEAT TRACK HAS MINOR CHAFING BETWEEN STATION 145 TO 160, STATION 180 TO 196 AND STATION 210 TO 224. REPAIRED IAW RD 8/4-53-884.SDR QXEA200601947Seat Track · chafedPDX C3 LEFT HAND INBOARD SEAT TRACK IS CHAFED ON TOP AND IN BOTTOM OF CHANNEL BETWEEN STATION 115 AND STATION 132. REPAIRED IAW RD 8/4-53-884.SDR QXEA200601946Seat Track · chafedPDX C3 LEFT HAND INBOARD SEAT TRACK IS CHAFED IN BOTTOM OF CHANNEL BETWEEN STATION 86 AND 96. REPAIRED IAW RD 8/4-53-884.SDR QXEA200601945Seat Track · chafedPDX C3 LEFT HAND INBOARD SEAT TRACK IS CHAFED ON TOP SURFACE BETWEEN STATION X63.0 AND X65.0. REPAIRED IAW RD 8/4-53-884.SDR QXEA200601944Seat Track · tool damagePDX C3 RIGHT HAND INBOARD SEAT TRACK HAS TOOLING MARKS AT X584.50. REPAIRED IAW RD 8/4-53-884.SDR QXEA200601816Seat Track · chafedPDX - C4 CHAFING ON INBOARD, LEFT HAND SEAT TRACK IN CENTER CHANNEL AT STATION X539.000. REPAIRED IAW RD 8-53-4936 AND DHC-8-200 SRM 51-20-16 AND SRM 51-20-36.SDR 06FDEA2484Seat Track · damagedMAIN DECK SEAT TRACK AT STA 1085 X = -47.5 FOUND WITH THE LOCK CROWN DAMAGED. REMOVED AS PER SRM 51-33-01 VOLUME II. NEW REPAIR SEAT TRACK FABRICATED AS PER SRM 53-70-00 FIGURE 1 VOLUME I AND INSTALLED AS PER SRM 51-33-01 VOLUME II. REPAIR CLASSIFIED SDR DHL2006762512Seat Track · corrodedFOUND CABIN SEAT TRACK RBL 24 HAS CORROSION AT BS 480-620. REMOVED FLOORBOARDS FROM BL 0 - RBL 24 STA 480-690 IAW B727 SRM 51-30-2. REMOVED SEAT TRACK AT RBL 24 STA 480-660 IAW B727 SRM 51-30-2. FAB NEW SEAT TRACK OF BAC1520-792 DIM 17.5' PO NR 9003095 IAW SDR DHL2006762510Seat Track · corrodedCABIN SEAT TRACK LBL 24 HAS CORROSION AT BS 480-620. REMOVED FLOORBOARDS FROM BL 0 TO LBL 45 FOR ACCESS IAW SRM 51-30-2, BS 480-690 SEAT TRACK CORROSION FOUND OUT OF LIMIT IAW SRM 51-10-1 & SRM 53-10-1 FIG. 4. REMOVED SEAT TRACK LBL24 BS 480-690 IAW SRM 51-30-SDR UPS06647298Seat Track · damagedSEAT TRACK DAMAGED AT POS 2R 3RD LOCK FOR -M- CONTAINERS. BLENDED SEAT TRACK PER SRM 53-00-52 DEFER FOR SEAT TRACK REPAIR DMI D-328864. REMOVED AND REPLACED POS 2R SEAT TRACK REF SRM 53-10-52-2R. THIS CLEARS THIS DEFERRAL.SDR QXEA200601764Seat Track · corrodedPDX C4 - NR 7 SEAT TRACK HAS CORROSION THAT IS OUT OF LIMITS. REPAIRED IAW RD 8-53-1102, RD8-53-4473 AND DHC-8-200 SRM 51-40-11.SDR QXEA200601763Seat Track · corrodedPDX C4 - NR 4 SEAT TRACK HAS CORROSION THAT IS OUT OF LIMITS. REPAIRED IAW DHC-8-200 SRM 51-40-11 AND RD 8/53*4473.SDR 06FDEA2483Seat Track · corrodedMAIN DECK SEAT TRACK AT STA 810 X = 27.50 FOUND WITH THE LOCK CROWN DAMAGED. REPAIRED AS PER SRM 53-70-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR HALA0600588Seat Track · corrodedCORROSION (767-3-249004) SEAT TRACK CORODDED STA 754 TO 808 RBL 88 WL 200. BS 754 TO 808 RBL WL 200, FABRICATED NEW SEAT TRACK PER SRM 53-00-52-2R-3 FIG 201. INSTALLED SEAT TRACK PER SRM 51-40-02-00-0. INSTALLED FASTENERS IN FWD SPLICE CHANNEL VERTICAL FLANSDR UPS06447515Cargo Track · corrodedINSPECTION TYPE:C AFT CARGO COMPT RT STA 1500-1520 I/B TIE DOWN TRACK FOUND CORROSION. CORROSION BLEND OUT 0.047" BY 1/2" BY 10". TIE DOWN REPLACED AS PER SRM 51-30-02 AND 51-10-01 PG 9.SDR UPS06247366Seat Track · corrodedINSPECTION TYPE-C AND SI CORROSION ON SEAT TRACK TOP CHORD BS 590-630 LBL 45.5 NEW SEAT TRACK FABRICATED, PAINT AND INSTALLED IAW MM 51-20-90, SRM 51- 30-2, 53-10-5SDR UPS06447490Cargo Track · corrodedINSPECTION TYPE:C FWD CARGO COMPT LT STA560 I/B TIE DOWN TRACK FOUND CORROSION. CORROSION BLEND OUT 0.055" BY 3/8" BY 1.5" EXCEED SRM LIMIT. FWD CARGO COMPT BS 510-570 LT I/B TIE DOWN TRACK REPAIRED AS PER SRM 53-10-05 FIG 5.SDR UPS06247464Seat Track · corrodedINSPECTION TYPE:C CORROSION ON SEAT TRACK TOP CHORD AT BS 950-962 RBL 62.5. CORROSION FOUND OUT OF LIMITS IAW SRM 53-10-01. SEAT TRACK REPLACED IAW SRM 51-30-02.
Back to JASC 5347