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 HALA0800163Seat Track · corrodedLEVEL 1 CORROSION SECTION 46, SEAT TRACKS AT RBL 88.5, STA 1403. REWORKED IAW SRM 53-00-52/101. REPLACED SEAT TRACKS IAW SRM WHERE DAMAGE WAS OUT OF LIMITS.SDR HALA0800162Seat Track · corrodedLEVEL 1 CORROSION SECTION 46, SEAT TRACKS, AT RBL 88.5, STA 1414. REWORKED IAW SRM 53-00-52/101 AND REPLACED SEAT TRACK IAW SRM WHERE DAMAGE WAS OUTSIDE LIMITS.SDR HALA0800161Seat Track · corrodedLEVEL 1 CORROSION SECTION 46, SEAT TRACKS AT RBL 46, STA 1433. REWORKED IAW SRM 53-00-52/101. REPLACED SEAT TRACK IAW SRM WHERE OUT OF LIMITS.SDR HALA0800160Seat Track · corrodedLEVEL 1 CORROSION SECTION 46, SEAT TRACKS AT RBL 88.5, STA 1437. REWORKED IAW SRM 53-00-52/101, AND REPLACED SEAT TRACK IAW SRM WHERE DAMAGE WAS OUT OF LIMITS.SDR HALA0800159Seat Track · corrodedLEVEL 2 CORROSION SECTION 46, SEAT TRACKS AT RBL 11, STA 1447. REWORKED IAW SRM 53-00-52/101.SDR HALA0800158Seat Track · corrodedLEVEL 2 CORROSION SECTION 46, SEAT TRACKS AT RBL 11, STA 1432. REWORKED IAW SRM 53-00-52/101.SDR HALA0800157Seat Track · corrodedLEVEL 2 CORROSION SECTION 46, SEAT TRACKS AT RBL 11, STA 1417. REWORKED IAW SRM 53-00-52/101.SDR HALA0800156Seat Track · corrodedLEVEL 2 CORROSION SECTION 46, SEAT TRACKS AT RBL 11, STA1400. REWORKED IAW SRM 53-00-52/101.SDR HALA0800155Seat Track · corrodedLEVEL 2 CORROSION, SECTION 46, SEAT TRACKS AT RBL 11, STA 1387. REWORKED IAW SRM 53-00-52/101.SDR HALA0800154Seat Track · corrodedLEVEL 2 CORROSION SECTION 46, SEAT TRACKS AT RBL 11, STA 1373. REWORKED IAW SRM 53-00-52/101.SDR HALA0800153Seat Track · corrodedLEVEL 2 CORROSION SECTION 46, SEAT TRACKS AT RBL 11, STA 1339. REWORKED IAW SRM 53-00-52/101.SDR HALA0800152Seat Track · corrodedLEVEL 2 CORROSION SECTION 46, SEAT TRACKS AT RBL 11, STA 1280. REWORKED IAW SRM 53-0052/101.SDR HALA0800151Seat Track · corrodedLEVEL 2 CORROSION SECTION 46, SEAT TRACKS AT RBL 11, STA 1235. REWORKED IAW SRM 53-00-52/101.SDR HALA0800150Seat Track · corrodedLEVEL 2 CORROSION SECTION 46, SEAT TRACKS AT RBL 11, STA1197+137. REWORKED IAW SRM 53-00-52/101.SDR HALA0800149Seat Track · corrodedLEVEL 2 CORROSION SECTION 46, SEAT TRACKS AT RBL 11, STA 1197+122. REWORKED IAW SRM 53-00-52/101.SDR HALA0800148Seat Track · corrodedLEVEL 2 CORROSION SECTION 46 SEAT TRACK AT RBL 11, STA 1197+108. REWORK IAW SRM 53-00-52/101.SDR DLM90080196Seat Track · gougedCABIN SEAT TRACK GOUGED OUT OF LIMITS, FS 439-519 RBL 54. FABBED NEW SEAT TRACK AND INSTALLED, IAW MD90 SRM 53-40-01 VOL I.SDR HALA00800146Seat Track · corrodedLEVEL 2 CORROSION ON SEAT TRACKS AT SECTION 45,RBL 11, STA 1197+75. REWORKED AREA IAW SRM 53-00-52/101.SDR HALA0800145Seat Track · corrodedLEVEL 2 CORROSION ON SEAT TRACKS, SECTION 46, RBL 11, STA 1197+32. REWORKED IAW SRM 53-00-52/101.SDR HALA0800144Seat Track · corrodedLEVEL 2 CORROSION SEAT TRACK SECTION 46, RBL 11, STA 1180. REWORKED IAW SRM 53-00-52/101.SDR USAA920080466Seat Track · corrodedSAL - MAJOR REPAIR - C7 CHECK - CORROSION ON CABIN RAIL SEAT BEAM, BS 3043/FR 64 - BS 3158 FR 66, -Y765. REPLACED CABIN RAIL SEAT BEAM, BS 3043/FR 64 - BS 3158/FR 66, -Y765 IAW A320 SRM 51-72-11.SDR USAA920080422Seat Track · corrodedBFM - MAJOR REPAIR - C2 CHECK - CORROSION ON CABIN SEAT TRACK, BS 5478 / FR 70, +Y450. REPLACED CABIN SEAT TRACK, BS 5478 / FR 70, +Y450 IAW A330 SRM 51-42-00.SDR USAA920080421Seat Track · corrodedBFM - MAJOR REPAIR - C2 CHECK - CORROSION ON CABIN SEAT TRACK, BS 4523 / FR 56, +Y450. REPLACED CABIN SEAT TRACK, BS 4523 / FR 56, +Y450 IAW A330 SRM 51-42-00.SDR 08FDEA00376Seat Track · crackedMAIN DECK, AFTER FLOOR PANEL REMOVAL FOR WIRING MOD, FOUND SEAT TRACK UNDER FLOOR PANEL AT STA 635, X = 55 CRACKED. SEAT TRACK REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT PER SRM 53-70-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR QXEA200800224Seat Track · corrodedPDX - C4 CHECK - LEFT EQUIPMENT TRACK, STATION 709-714 HAS BUBBLED PAINT SUSPECT CORROSION. REPAIRED IAW Q400 RD 8/4-53-884, RD 8/4-53-2260, AND NDTM PART 6 51-00-01.SDR QXEA200800223Seat Track · corrodedPDX - C4 CHECK - SEAT TRACK 2 STATION 379-382 HAS CORROSION ON CENTER OF TRACK. REMOVED SEAT TRACK AND INSTALLED NEW SEAT TRACK IAW Q400 RD 8/4-53-884, SRM 51-42-05, 51-40-15 AND 51-40-45.SDR QXEA200800214Seat Track · corrodedPDX - C4 CHECK - SUSPECT CORROSION ON RIGHT INBOARD SEAT TRACK TOP SIDE AT APPROXIMATELY STATION X669.0. REMOVED SEAT TRACK AND INSTALLED NEW TRACK IAW Q400 RD8/4-53-884, Q400 SRM 51-42-05.SDR QXEA200800213Seat Track · corrodedPDX - C4 CHECK - SUSPECT CORROSION ON RIGHT INBOARD SEAT TRACK, TOP OUTBOARD SIDE AT APPROXIMATELY STATION X682. REMOVED SEAT TRACK AND INSTALLED NEW SEAT TRACK IAW Q400 RD 8/4-53-884, AND Q400 SRM 51-42-05, 51-40-15.SDR QXEA200800212Seat Track · corrodedPDX - C4 CHECK - NR 19 SEAT TRACK HAS CORROSION INSIDE TRACK AT STATION X261.000. REPAIRED IAW Q400 RD8/4-53-2211, NDTM PART 6 51-00-01 AND RD8/4-53-884.SDR QXEA200800211Seat Track · corrodedPDX - C4 CHECK - SEAT TRACK 5, STATION 21.5 HAS BUBBLED PAINT AND SIGNS OF CORROSION. REPAIRED IAW Q400 RD8/4-53-884, RD 8/4-53-2260, AND NDTM PT-6 51-00-01SDR QXEA200800199Seat Track · gougedPDX - C4 CHECK - LIGHT SURFACE GOUGES ON LEFT INBOARD SEAT TRACK, TOP SIDE AT APPROXIMATELY STATION X706. REMOVED OLD SEAT TRACK AND INSTALLED NEW SEAT TRACK IAW Q-400 SRM 51-40-15 AND 51-42-05.SDR QXEA200800198Seat Track · corrodedPDX - C4 CHECK - SUSPECT CORROSION ON LEFT INBOARD SEAT TRACK, TOP OUTBOARD SIDE AT APPROXIMATELY STATION X669 TO X675. REPAIRED IAW Q400 RD 8/4-53-884, SRM 51-40-10, 51-21-10, 51-25-10 AND 51-25-00.SDR QXEA200800197Seat Track · corrodedPDX - C4 CHECK - NR 18 SEAT TRACK HAS AN AREA OF CORROSION INSIDE TRACK AT STATION X200.000. REMOVED SEAT TRACK AND INSTALLED NEW SEAT TRACK IAW Q400 SRM 51-40-15, 51-40-07, 51-42-05, AND 51-42-45.SDR QXEA200800196Seat Track · corrodedPDX - C4 CHECK - NR 18 SEAT TRACK HAS CORROSION INSIDE TRACK AT STATION X136.000. REMOVED SEAT TRACK AND INSTALLED NEW SEAT TRACK IAW Q400 SRM 51-40-15, 51-40-07, 51-42-45 AND 51-42-05.SDR QXEA200800194Seat Track · corrodedPDX - C4 CHECK - NR 11 SEAT TRACK HAS AN AREA OF CORROSION AT STATION X21.500. REMOVED SEAT TRACK AND INSTALLED NEW SEAT TRACK IAW Q400 SRM 51-40-15 AND 51-42-05.SDR QXEA200800195Seat Track · corrodedPDX - C4 CHECK - NR 17 SEAT TRACK HAS AN AREA OF CORROSION AT STATION X36.000. REMOVED SEAT TRACK AND INSTALLED NEW SEAT TRACK IAW Q400 SRM 51-40-15 AND 51-42-05SDR QXEA200800193Seat Track · corrodedPDX - C4 CHECK - NR 10 SEAT TRACK AT STATION X1.500 HAS AN AREA OF CORROSION AROUND NUTPLATE HOLE. REMOVED SEAT TRACK AND INSTALLED NEW SEAT TRACK IAW Q400 SRM 51-40-15 AND 51-42-05.SDR 08FDEA00371Seat Track · crackedMAIN DECK, AFTER FLOOR PANEL REMOVAL TO FACILITATE SEAT TRACK REPAIR, FOUND SEAT TRACK UNDER FLOOR PANEL AT STA 635, X = -11 CRACKED. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT PER SRM 53-70-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2SDR 08FDEA00370Seat Track · crackedMAIN DECK, AFTER FLOOR PANEL REMOVAL TO FACILITATE SEAT TRACK REPAIR, FOUND SEAT TRACK UNDER FLOOR PANEL AT STA 635, X = 11 CRACKED. SEAT TRACK REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT PER SRM 53-70-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR PER GMSDR 08FDEA00369Seat Track · crackedMAIN DECK, AFTER FLOOR PANEL REMOVAL TO FACILITATE SEAT TRACK REPAIR, FOUND SEAT TRACK UNDER FLOOR PANEL AT STA 635, X = 33 CRACKED. SEAT TRACK REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT FROM STA 625 TO STA 665, X = 33" PER SRM 53-70-00 FIGURE 1 VOLUME I. SDR A6WA200840081Cargo Track · corrodedAT FS 559.96 WL 73.50 CARGO TRACK LT AND RT SIDE INNER, OUTER SURFACE CORRODED. (K) BLENDED CARGO TRACKS IAW SRM 51-12-00. (M)SDR A6WA200840080Cargo Track · corrodedAT FS 574.00, WL 73.50 CARGO TRACKS LT AND RT SIDE INNER OUTER SURFACE CORRODED. (K) BLENDED CARGO TRACKS IAW SRM 51-12-00. (M)SDR DLM90080202Seat Track · gougedCABIN SEAT TRACK GOUGED AND CORRODED OUT OF LIMITS FS 674-798 RBL 22. REMOVED AND REPLACED DAMAGED SEAT TRACK, IAW MD90 SRM 53-40-01FIG 6 VOL I.SDR G60A200800002Seat Track · corrodedFOUND CORROSION ON SEAT TRACK IN FRONT OF AFT CARGO DOOR.SDR 08FDEA00367Seat Track · wornMAIN CARGO DECK NR 1 SEAT TRACK BETWEEN FR 41 AND FR 45N HAS SEVERAL SCALLOPS WORN REMOVED AND REPLACED SEAT TRACK IAW A300-600 SRM 51-72-10.SDR 08FDEA00366Seat Track · damagedMDCC SEAT TRACK NR 1 BETWEEN FR 57 AND FR 57.1 HAS 2 SCALLOPS BROKEN. REMOVED DAMAGED SECTION OF TRACK AND INSTALLED SEAT TRACK REPAIR IAW A300-600 SRM 53-10-16, FIG 201.SDR 08FDEA00365Seat Track · wornSEAT TRACK AT FR 57.1, 2 LT HAS 2 EA SCALLOPS WORN REMOVED DAMAGED SEAT TRACK SECTION AND INSTALLED SEAT TRACK REPAIR IAW A300-600 SRM 53-10-16, FIG 201.SDR DLM90080200Seat Track · corrodedCABIN SEAT TRACK GOUGED AND CORRODED OUT OF LIMITS FS 486-551 RBL.22, .058" REMAINING MATERIAL. REMOVED AND REPLACED SEAT TRACK FS 486-551 RBL 22, IAW MD90 SRM 51-30-01 AND SRM 53-40-01 FIG 6.SDR 08FDEA00361Seat Track · wornMCD SEAT TRACK AT BS 650-730 LBL 107 IS WORN. REMOVED AND REPLACED SEAT TRACK IAW SRM 53-70-00 FIG 1 VOL 1.SDR TRAX200800196Seat Track · corrodedRIGHT SIDEWALL SEAT RAIL FS 708.0 TO FS 761.85 HAS CORROSION DAMAGE. REMOVED AND REPLACED RT SIDEWALL SEAT RAIL FS 708.0 TO 761.85 IAW CRJ 700 AMM 53-00-49. TO7011593 02/12/08. SUPPLEMENTAL SDR CLOSED 2/14/08.
Back to JASC 5347