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 QXEA200601410Seat Track · corrodedPDX C4 LEFT HAND INBOARD SEAT TRACK AT STATION 597.500 (FORWARD CARGO BAY) HAS CORROSION INSIDE CHANNEL AND ON TOP SURFACE. REPAIRED IAW DHC-8-200 SRM 51-40-00 AND 51-40-11.SDR ASAA0670661Seat Track · wornCAPTAINS AFT I/B SEAT TRACK WORN TO LOCK PIN HOLES. REMOVED AND REPLACED IAW MM 25-11-11.SDR 06FDEA2179Seat Track · corrodedFOUND MAIN CARGO DECK SEAT TRACK CORRODED AT FRAME 28 LBL97 AFT OF CARGO DOOR.SDR 06FDEA2139Seat Track · corrodedNR 5 LT SEAT TRACK AT FS 43 TO 44 AND 41 TO 42 HAS CORROSION 2 LOCATIONS REF N00427. REMOVED AND REPLACED SEAT TRACK IAW A300-600 SRM 51-40-21 AND 53-10-16.SDR 06FDEA2138Seat Track · corrodedMDCC ZN 240 NR 3 LT SEAT TRACK HAS CORROSION AT FS 44.5 AND 40.5, 2 LOCATION REF N00420. REPAIRED SEAT TRACK IAW A300-600 SRM 53-10-16 FIG 201.SDR 06FDEA2137Seat Track · corrodedMDCC ZN 240 LT NR 2 SEAT TRACK FS 42 TO FS 44 HAS CORROSION 2 LOCATION REF N00417. REMOVED AND REPLACED LT NR 2 SEAT TRACK IAW AT FS 42 TO 44 IAW A300-600 SRM 51-72-10 AND 53-10-16 AND 51-40-21.SDR 06FDEA2136Seat Track · corrodedMDCC ZN 240 - RT NR 2 SEAT TRACK AT FS 54.3 HAS CORROSION REF N00406. REMOVED AND REPLACED SEAT TRACK IAW A300-600 SRM 53-10-16.SDR 06FDEA2135Seat Track · corrodedMDCC ZN 240 RT NR 3 SEAT TRACK HAS CORROSION AT FR'S 40, 41, 42 AND 43REF N00403. REMOVED AND REPLACED SEAT TRACK IAW A300-600 SRM 53-10-16 AND 51-72-10.SDR 06FDEA2134Seat Track · corrodedMDCC ZN 240 RT NR 3 SEAT TRACK HAS CORROSION AT FS'S 40,41, 42 AND 43 REF N00403. REMOVED AND REPLACED SEAT TRACK IAW A300-600 SRM 53-10-16 AND 51-72-10.SDR 06FDEA2131Seat Track · corrodedMDCC ZONE 240 NR 4 LT SEAT TRACK AT FS 44.5, 43 TO 44 AND FS 40 TO 41 HAS CORROSION 4 LOCATION REF N00423. REMOVED AND REPLACED SEAT TRACK IAW A300-600 SRM 51-40-21 AND 53-10-16.SDR 06FDEA2129Seat Track · corrodedMDCC ZONE 240 RT NR 3 SEAT TRACK HAS CORROSION AT FR 45.5, 47.5, 48.5, 49.5, 50.5 AND 51.5 REF N00535. REPAIRED SEAT TRACK IAW A300-600 SRM 53-10-16.SDR 06FDEA2127Seat Track · corrodedMDCC SEAT TRACK RT NR 1AT FR 71 TO 73 HAS CORROSION REF N00527. REMOVED AND REPLACED DAMAGED SECTION OF TRACK IAW A300-600 SRM 53-10-16.SDR 06FDEA2126Seat Track · corrodedMDCC SEAT TRACK RT NR 3 AT FR 55 TO FR 57.1 HAS CORROSION ON 3 AREAS AND AT 54.3 AND 55 REF, N00483. REMOVED AND REPLACED SEAT TRACK SECTION IAW A300-600 SRM 53-10-16.SDR 06FDEA2125Seat Track · corrodedMDCC ZN 240 CLS ADAPTER AT FR 36 BETWEEN LT NR 2 AND NR 3 SEAT TRACK HAS CORROSION REF N00448. REMOVED AND REPLACED CLS ADAPTER IAW A300-600 SRM 51-72-10.SDR 06FDEA2123Seat Track · corrodedMDCC ZONE 240 CLS ADAPTER AT FR 37 BETWEEN LT NR 2 AND NR 3 SEAT TRACK HAS CORROSION REF N00447. REMOVED AND REPLACED CLS ADAPTER IAW A300-600 SRM A300-600 SRM 51-72-10.SDR 06FDEA2104Seat Track · corrodedFOUND SEAT TRACK 3L AT FS 17 - FS 18 SCALLOP HAS CORROSION REF N00580. REMOVED AND REPLACED SEAT TRACK IAW A300-600 SRM 51-72-10 AND 53-10-16.SDR 06FDEA2103Seat Track · corrodedMDCC SEAT TRACK RT NR 2 AT FS 64 TO 65 HAS CORROSION REF N00507. REPAIRED SEAT TRACK IAW A300-600 SRM 53-10-16.SDR 06FDEA2102Seat Track · corrodedMDCC SEAT TRACK AT FS 76-79 LT 3 HAS CORROSION REF N00602. REPAIRED SEAT TRACK IAW A300-600 SRM 53-10-16.SDR 06FDEA2101Seat Track · corrodedNR 5 LT SEAT TRACK AT FS 38,36,34 AND 30.5 HAS CORROSION REF N00428. REMOVED CORROSION IAW A300-600 SRM 51-74-10 AND FOUND TO BE WITHIN LIMITS IAW A300-600 SRM 53-16-10.SDR 06FDEA2099Seat Track · corrodedMDCC - SEAT TRACK LT NR 4 AT FS 57.1 TO 57.2 HAS CORROSION REF N00488. REPAIRED SEAT TRACK IAW A300-600 SRM 53-10-16 AND 51-74-10.SDR 06FDEA2110Seat Track · corrodedMDCC SEAT TRACK MIDDLE SECTION AT FS 69 TO FS 71 HAS CORROSION REF N00519. REPAIRED SEAT TRACK IAW A300-600 SRM 53-10-16.SDR 06FDEA2109Seat Track · corrodedMDCC SEAT TRACK RT NR 1 AT FS 66 TO FS 69 HAS CORROSION REF N00516. REMOVED AND REPLACED DAMAGED SECTION OF SEAT TRACK IAW A300-600 SRM 53-10-16 AND 51-74-10.SDR 06FDEA2108Seat Track · corrodedMDCC SEAT TRACK NR 1 LT AT FS 57.1 TO 57.2 HAS CORROSION REF N00492. REMOVED AND REPLACED SEAT TRACK IAW A300-600 SRM 53-10-16, 51-74-10 AND 51-40-21.SDR 06FDEA2098Seat Track · corrodedMDCC SEAT TRACK AT FS 75.5 RT NR 3 HAS CORROSION REF N00603. REMOVED AND REPLACED SEAT TRACK IAW A300-600 SRM 53-10-16,53-20-16 AND 51-40-21.SDR 06FDEA2107Seat Track · corrodedFOUND SEAT TRACK 3R FROM FS 19 TO FS 15 HAS CORROSION 3 AREAS REF N00531. REPLACED SEAT TRACK IAW A300-600 SRM 51-74-10 AND 53-10-16.SDR 06FDEA2096Seat Track · corrodedMDCC SEAT TRACK RT NR 2 AT FS 71-72 HAS CORROSION REF N00526. REPAIRED SEAT TRACK IAW A300-600 SRM'S 51-40-21, 51-31-00, 53-18-16 FIG 1, 51-23-10 AND 51-23-10.SDR 06FDEA2106Seat Track · corrodedSEAT TRACK NR 2R FR 19 TO FR 15 HAS 4 AREAS OF CORROSION REF N00530. REPLACED SEAT TRACK IAW A300-600 SRM 51-74-10 AND 53-10-16.SDR 06FDEA2105Seat Track · corrodedMDCC SEAT TRACK MIDDLE SECTION HAS CORROSION AT FR 71-73 REF N00524. REPAIRED SEAT TRACK IAW A300-600 SRM 53-10-16 AND 51-74-10.SDR 06FDEA2092Seat Track · corrodedRIGHT CABIN SEAT TRACK AT APPROX STA Y= 1561 AND 1861, X= -75.25 SUPPORT FLANGE FOUND CORRODED. CARRIED OUT REPAIR AS PER SRM 53-70-00 FIGURE 15 VOLUME I. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR 06FDEA2091Seat Track · damagedRIGHT CABIN SEAT TRACK AT APPROX STA Y= 950 TO 970 AND X= -47.50 FOUND WITH NUT CHANNEL EDGE CHIPPED OFF AT FEW PLACES. CARRIED OUT REPAIR AS PER SRM 53-70-00 FIGURE 1 VOLUME I. REPAIR IS CLASSIFIED MAJOR PER GMM 6-2-100.SDR 06FDEA2090Seat Track · corrodedFOUND CABIN, RT SEAT TRACK X=-75.25 FOUND WITH CORROSION AROUND STA 1345. FOUND OUT OF LIMITS AND TRIMMED OFF FROM STA 1286-1371 CARRIED OUT REPIAR AS PER SRM 53-70-00 FIG 1 VOL I FABRICATED NEW SEAT TRACK, SPLICE HAT AND SPLICE PLATE AS PER SRM 53-70SDR 06FDEA2089Seat Track · corrodedFOUND CABIN, RT SEAT TRACK X=-27.5 FOUND WITH CORROSION AT STA 899. CORRODED FOUND OUT OF LIMITS TRIMMED OFF FROM STA 869-969 CARRIED OUT, REPAIR BY FRABRICATED NEW SEAT TRACK, SPLICE HAT AND SPLICE PLATE AS PER SRM 53-70-00 FIG 1 VOL I. MINOR REPAIRSDR 06FDEA2088Seat Track · corrodedFOUND CABIN, LT SEAT TRACK X= 27.5 CORROSION AROUND STA 900 AND STA 959. CORROSION FOUND OUT OF LIMITS AT LH SEAT TRACK X= 27.5 AROUND STA 900 AND 959, CARRIED OUT REPAIR AS PER SRM 53-70-00 FIG 1 VOL I. FABRICATED NEW SEAT TRACK SPLICE HAT AND SPLICESDR QXEA200601485Seat Track · corrodedPDX: RT OUTBOARD SEAT TRACK NR 19 HAS CORROSION AT STA X540 AND X556. MAINTENANCE REPAIRED IAW RD 8/4-53-884, NDTM PART 6, 51-00-01-250-801, AND Q400 SRM PSM 1-84-3 CHAPTER 51-21-10.SDR QXEA200601484Seat Track · corrodedPDX: LT OUTBOARD CENTER SEAT TRACK NR 2 IS CORRODED AT STA X324. MAINTENACE REPAIRED IAW RD 8/4-53-884, NDTM PART 6, 51-00-01-250-801 AND Q400 SRM PSM 1-84-3 CHAPTER 51-21-10.SDR QXEA200601483Seat Track · corrodedPDX: RT OUTBOARD CENTER SEAT TRACK NR 19 HAS CORROSION AT STA X279, X292 AND X324. MAINTENANCE REPAIRED IAW RD 8/4-53-884, NDTM PART 6 51-00-01-250-801, AND Q400 SRM PSM 1-84-3 CHAPTER 51-21-10.SDR QXEA200601482Seat Track · corrodedPDX: RT OUTBOARD FWD SEAT TRACK NR 18 HAS MULTIPLE SPOTS OF CORROSION AT STA X95, X109, X138, X158, X167, X190, X207, X217 AND X225. MAINTENANCE REPAIRED IAW RD 8/4-53-884, NDTM PART 6, 51-00-01-250-801, AND Q400 SRM PSM 1-84-3 CHAPTER 51-21-10.SDR QXEA200601480Seat Track · corrodedPDX: LT CENTER SEAT TRACK NR 9 IS CORRODED AT STA 391 AND FROM STA X475 TO X490. MAINTENANCE REPAIRED IAW NDTM PART 6, 51-00-01-250-801 AND Q400 SRM PSM 1-84-3 CHAPTER 51-21-10.SDR QXEA200601479Seat Track · corrodedPDX: RT CENTER SEAT TRACK NR 13 HAS CORROSION AT STA X290, X357 AND X457. MAINTENANCE REPAIRED IAW RD 8/4-53-884, NDTM PART 6, 51-00-01-250-801 AND Q400 SRM PSM 1-84-3 CHAPTER 51-21-10.SDR MALA060352Seat Track · corrodedDURING 4K CHECK IN BNA FOUND SEAT TRACK AT LBL 18.3 BETWEEN FS 294 AND 300 IS CORRODED OUT OF LIMITS. THE DAMAGE HAS BEEN REPAIRED IAW MESABA EOS53342.SDR MALA060351Seat Track · corrodedDURING 4K CHECK IN BNA FOUND SEAT TRACK AT BL 0, BETWEEN FS 294 AND 300 IS CORRODED OUT OF LIMITS. THE DAMAGE HAS BEEN REPAIRED IAW MESABA EOS53342.SDR 06FDEA2065Seat Track · corrodedCABIN: LT SEAT TRACK X= 107.5 FOUND CORROSION AROUND STA 859 AND 899. REPAIRED AS PER SRM 53-70-00 FIG 1 VOL II. CLASSIFIED MAJOR REPAIR PER GMM 6-2-100.SDR 06FDEA2063Seat Track · corrodedLT SEAT TRACK X= 75.25 FOUND CORROSION AROUND STA 889, 939-959 AND 979. CORROSION FOUND OUT OF LIMITS. TRIMMED OFF FROM STA 869-979 CARRIED OUT, REPAIR BY FABRICATED NEW SEAT TRACK, SPLICE HAT AND SPLICE PLATE AS PER SRM 53-70-00 FIG 1 VOL I. MAJOR RESDR AWXA200600895Seat Track · corrodedMCN - MAJOR REPAIR - NR 5923039 - DURING BC4 CHECK DISCOVERED LEVEL 2 GALVANIC CORROSION ON SEAT RAIL BEAM AT FR 66 AND Y-1292. CORROSION WAS FOUND TO BE OUT OF LIMITS IAW AIRBUS 319 SRM 53-00-14 FIG 102. MAINTENANCE REMOVED AND INSTALLED NEW RAIL BEAM AT FRSDR QXEA200601439Seat Track · corrodedPDX - C4 LEFT OUTBOARD SEAT TRACK NR 1 CORROSION IN SEAT ATTACH AREA APPROXIMATELY X280, PIT IN BOTTOM. REPAIRED IAW RD 8-53-1342, DHC-8-200 SRM 51-40-00, 51-40-11.SDR GTIA200600055Seat Track · corrodedMAIN CABIN CORROSION SEAT TRACK FRAME 20 LBL 40. REPLACED DAMAGED AREA.SDR GTIA200600054Seat Track · corrodedMAIN CABIN CORROSION ON SEAT TRACK RBL 20 FR 20. REPLACED DAMAGE SECTION.SDR 06FDEA2026Seat Track · corrodedMAIN CARGO DECK SEAT TRACK CORRODED BETWEEN FRAME 50-51, BL 0.SDR 06FDEA2033Seat Track · corrodedMDCC L2 SEAT TRACK AT FS 70 AND FS 72 HAS CORROSION REF N00587. REMOVED AND REPLACED SEAT TRACK IAW A310 SRM 51-40-21.SDR 06FDEA2034Seat Track · corrodedMDCC L3 SEAT TRACK AT FR 65.5 TO 67.5 AND AT FR 71.5 HAS 5 AREAS OF CORROSION REF N00588. REMOVED CORROSION IAW A310 SRM 51-74-10 4 1 AREA OUT OF LIMITS IAW A310 SRM 53-10-16 FIG 101. REPLACED OUT OF LIMIT PRODUCTION SPLICE IAW A310 SRM 51-40-21.
Back to JASC 5347