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 QXEA20060099Seat Track · corrodedPDX: PITTING CORROSION, LT OUTBOARD SEAT TRACK, STA X76.0 - 84.0, SEAT TRACK 1. MAINTENANCE REPAIRED IAW RD 8/4-53-884 AND NDTM PART 6, 51-00-01.SDR QXEA20060098Seat Track · corrodedPDX: PITTING CORROSION, LT OUTBOARD SEAT TRACK, STA X67.9, SEAT TRACK 1. MAINTENANCE REPAIRED IAW RD 8/4-53-884 AND NDTM PART 6, 51-00-01.SDR QXEA20060097Seat Track · corrodedPDX: PITTING/SCRAPES, LT INBOARD SEAT TRACK AT STA X112.0 - X124.0 TRACK 6. MAINTENANCE REPAIRED IAW RD 8/4-53-884 AND NDTM PART 6, 51-00-01.SDR QXEA20060096Seat Track · corrodedPDX: PITTING/SCRAPES, LT INBOARD SEAT TRACK AT STA X82.0 - 92.0 TRACK 5. MAINTENANCE REPAIRED IAW RD 8/4-53-884 AND NDTM PART 6, 51-00-01.SDR QXEA20060095Seat Track · corrodedPDX: PITTING/SCRAPES, RT INBOARD SEAT TRACK AT STA X604.5 - X619.5 TRACK 14 AND 14A. MAINTENANCE REPAIRED IAW RD 8/4-53-884 AND NDTM PART 6, 51-00-01.SDR QXEA20060094Seat Track · corrodedPDX: PITTING/SCRAPES RT INBOARD SEAT TRACK STA X574.0 - X586.0. TRACK 14. MAINTENANCE REPAIRED IAW RD 8/4-53-884 AND NDTM PART 6, 51-00-01.SDR QXEA200600093Seat Track · corrodedPDX: PITTING/SCRAPES RT INBOARD SEAT TRACK STA X547.0 - X557.0, SEAT TRACK 13. MAINTENANCE REPAIRED IAW RD 8/4-53-884 AND NDTM PART 6, 51-00-01.SDR QXEA200600092Seat Track · corrodedPDX: PITTING/SCRAPES ON RT INBOARD SEAT TRACK, STA X439.5 - 463.5, SEAT TRACK 13. MAINTENANCE REPAIRED IAW RD 8/4-53-884, ADN NDTM PART 6, 51-00-01.SDR QXEA200600091Seat Track · corrodedPDX: PITTING/SCRAPES IN RT INBOARD SEAT TRACK, STA X413 - 423.0, SEAT TRACK 13. MAINTENANCE REPAIRED IAW RD 8/4-53-884 AND NDTM PART 6, 51-00-01.SDR QXEA200600090Seat Track · corrodedPDX: PITTING CORROSION, RT OUTBOARD SEAT TRACK, STA X410.0, SEAT TRACK 18. MAINTENANCE REPAIRED IAW RD 8/4-53-884 AND NDTM PART 6, 51-00-01.SDR QXEA200600089Seat Track · corrodedPDX: PITTING CORROSION, RT OUTBOARD SEAT TRACK, APPROX STA X335.0 - 375.0, SEAT TRACK 18. MAINTENANCE REPAIRED IAW RD 8/4-53-884 AND NDTM PART 6, 51-00-01.SDR QXEA200600088Seat Track · corrodedPDX: PITTING CORROSION, RT OUTBOARD SEAT TRACK, APPROX STA X333.0-340.0, SEAT TRACK 18. MAINTENANCE REPAIRED IAW RD 8/4-53-884 AND NDTM PART 6, 51-00-01.SDR QXEA200600087Seat Track · corrodedPDX: PITTING CORROSION, RT OUTBOARD SEAT TRACK, STA 321.0, SEAT TRACK 18. MAINTENANCE REPAIRED IAW RD 8/4-53-883 AND Q400 NDTM, PART 6, 51-00-01.SDR QXEA200600086Seat Track · corrodedPDX: TWO AREAS OF PITTING CORROSION, RT OUTBOARD SEAT TRACK APPROX STA 223.0, SEAT TRACK 17. MAINTENANCE REPAIRED IAW RD 8/4-53-884 AND NDTM, PART 6, 51-00-01.SDR QXEA200600072Seat Track · corrodedPDX: LT IB SHORT SEAT TRACK HAS PITTING CORROSION INSIDE CHANNEL AT FSX 715 AND Y13 LT. MAINTENANCE REPAIRED IAW RD 8-53-884, SRM 51-40-00 AND SRM 51-42-05.SDR MWEA060004Seat Track · wornFIRST OFFICERS OUTBOARD AFT SEAT TRACK IS WORN. REMOVED TOP OF SEAT TRACK AND INSTALLED FACTORY REPAIR SECTION.SDR ASOA06057Seat Track · corrodedDURING A C-CHECK IN MCN, THE SEAT TRACK, AT FS 361-394, LBL 9, WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK, AT FS 361-394, LBL 9, IAW CRJ SRM 51-41-00. (M)SDR ASOA06058Seat Track · corrodedDURING A C-CHECK IN MCN, THE SEAT TRACK, AT FS 394-409 PLUS 128, RBL 9, WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK, AT FS 394-409 PLUS 128, RBL 9, IAW CRJ AMM 53-01-11. (M)SDR ASOA06059Seat Track · corrodedDURING A C-CHECK IN MCN, THE SEAT TRACK, AT FS 361-394, RBL 9, WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK, AT FS 361-394, RBL 9, IAW CRJ AMM 53-01-11. (M)SDR ASOA06060Seat Track · corrodedDURING A C-CHECK IN MCN, THE LEFT SIDEWALL SEAT TRACK, AT FS 361-409 PLUS 16, WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LEFT SIDEWALL SEAT TRACK, AT FS 361-409 PLUS 16, IAW CRJ AMM 53-00-47. (M)SDR ASOA06061Seat Track · corrodedDURING A C-CHECK IN MCN, THE LEFT SIDEWALL SEAT TRACK, AT FS 409 PLUS 16 - 409 PLUS 112, WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LEFT SIDEWALL SEAT TRACK, AT FS 409 PLUS 16 - 409 PLUS 112, IAW CRJ AMM 53-00-47. (M)SDR ASOA06062Seat Track · corrodedDURING A C-CHECK IN MCN, THE LEFT AND RIGHT SIDEWALL SEAT TRACKS, AT FS 449-499, WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LEFT AND RIGHT SIDEWALL SEATS TRACKS, AT FS 449-499, IAW CRJ AMM 53-00-47. (M)SDR ASOA06063Seat Track · corrodedDURING A C-CHECK IN MCN, THE LEFT AND RIGHT SIDEWALL SEAT TRACKS, AT FS 500-547, WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LEFT AND RIGHT SIDEWALL SEAT TRACKS, AT FS 500-547, IAW CRJ AMM 53-00-47. (M)SDR ASOA06064Seat Track · corrodedDURING A C-CHECK IN MCN, THE LEFT SIDEWALL SEAT TRACK, AT FS 546-559 PLUS 80, WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LEFT SIDEWALL SEAT TRACK, AT FS 546-559 PLUS 80, IAW CRJ AMM 53-00-47. (M)SDR ASOA06065Seat Track · corrodedDURING A C-CHECK IN MCN, FOUND CORROSION ON THE RIGHT SIDEWALL SEAT TRACK AT FS 409 PLUS 16-409 PLUS 112. (M) MAINTENANCE REMOVED AND REPLACED THE RT SIDEWALL SEAT TRACK AT FS409+16-409+112, IAW SRM. (K)SDR ASOA06066Seat Track · corrodedDURING A C-CHECK IN MCN, FOUND CORROSION ON RIGHT SIDEWALL SEAT TRACK AT FS 409 PLUS 112-424. (M) MAINTENANCE REMOVED AND REPLACED THE RT SIDEWALL SEAT TRACK IAW SRM. (K)SDR USAA060003Cargo Track · corrodedFOUND TIE DOWN FITTING CORRODED STA 1200-1640, AFT CARGO RT FLOOR. REMOVED CORROSION, INSPECTED, REPLACED OUT OF LIMIT TIE DOWN FITTINGS PER SRM 51-40-02, EA 97241, DEFECT SIZE: 2"L BY 1"W.SDR USAA060004Cargo Track · corrodedTIE DOWN FITTING CORRODED STA 1200-1640 AFT CARGO LT FLOOR TIE DOWN FITTINGS. REMOVED CORROSION, INSPECTED PER SRM 51-10-02, EA 97241, DEFECT SIZE: 2"L BY 1"W.SDR USAA063Cargo Track · corrodedSTA 1200-1640, AFT CARGO RT FLOOR TIE DOWN FITTINGS CORRODED. REMOVED CORROSION, INSPECTED, REPLACED OUT OF LIMIT TIE DOWN FITTINGS PER SRM 51-40-02, EA 97241, DEFECT SIZE: 2"L X 1"W.SDR USAA064Cargo Track · corrodedSTA 1200-1640 AFT CARGO LEFT FLOOR TIE DOWN FITTINGS CORRODED. REMOVED CORROSION, INSPECTED PER SRM 51-10-02, EA 97241, DEFECT SIZE: 2"L X 1"W.SDR USAA053Fitting · corrodedSTA 1200-1640, AFT CARGO RT FLOOR TIE DOWN FITTINGS CORRODED. REMOVED CORROSION, INSPECTED, REPLACED OUT OF LIMIT TIE DOWN FITTINGS IAW SRM 51-40-02, EA 97241, DEFECT SIZE: 2 INCH L X 1INCH W.SDR USAA054Fitting · corrodedSTA 1200-1640 AFT CARGO LT FLOOR TIE DOWN FITTINGS CORRODED. REMOVED CORROSION, INSPECTED PER SRM 51-10-02, EA 97241, DEFECT SIZE: 2 INCHES L X 1INCH W.SDR 06FDEA0065Seat Track · gougedGOUGED SEAT TRACK LBL 77 FR 20 TO FR 23 {2 PLACES}. REPAIRED SEAT TRACK SECTION IAW FED-EX EA 6-5310--92609. REMOVED DAMAGED SECTION OF SEAT TRACK, REPAIR SPLICES AND SEAT TRACK SECTION REQUIRED MACHINING. LOCATED AND DRILLED REPAIR PARTS AND INSTALLED REPASDR ASAA0640058Cargo Track · corrodedSEA - FOUND AFT CARGO PIT TIE DOWN TRACK CORRODED AT THRESHOLD AREA. REMOVED AND REPLACED AFT CARGO PIT RT TIE DOWN TRACK IAW B737-400 SRM 53-00-53, FIG 201. (M)SDR 06FDEA00027Seat Track · corrodedCORROSION ON SEAT TRACK AT MAIN CARGO DECK, LBL 97, FR20 TO FR27, SEVERAL PLACES LOCALIZED. REMOVED DAMAGED SEAT TRACK SECTION SECTION FR18 TO FR20 10IN IAW A300-600 SRM 53- 10-16, FABRICATED AND INSTALLED SEAT TRACK REPAIR IAW EA 6-5310-92608, FUSELAGSDR SWIA200616368Seat Track · wornPILOTS SEAT RAILS ARE WORN. ITEM FOUND AT C-CHECK INSPECTION. INSTALLED PILOT SEAT TRACK IAW AMM 53-01-05-400-801.SDR QXEA200600024Seat Track · corrodedPDX - RIGHT FORWARD INBOARD SEAT TRACK HAS CORROSION AT STATION 252. REPAIRED IAW DHC-8 SRM 51-40-00 AND SRM 51-40-11, RD 8-53-1103 AND RD 8-53-4473.SDR QXEA200600023Seat Track · corrodedPDX - LEFT FORWARD INBOARD SEAT TRACK HAS MULTIPLE AREAS OF CORROSION BETWEEN STATIONS 222 TO 252. REPAIRED IAW RD 8-53-1339 AND CHC-8 SRM 51-40-00 AND 51-40-11.SDR QXEA200600025Seat Track · corrodedPDX - RIGHT FORWARD OUTBOARD SEAT TRACK HAS CORROSION AT STATION 342. REPAIRED IAW DHC -8-200 SRM 51-40-11.SDR COMA0560788Seat Track · corrodedRT SIDE SEAT RAIL FROM FS 535.02 TO 559.79. REPAIRED RT SIDE SEAT RAIL FROM FS 535.02 TO 559.79 BY REMOVING AND REPLACING SEAT RAIL IAW MFG EO 601R-53-7965A.SDR COMA0560787Seat Track · corrodedRIGHT FLOOR SEAT RAIL CORRODED FROM FS 559+16 TO 559+96. REPAIRED RIGHT FLOOR SEAT RAIL FROM FS 559+16 TO 559+96 BY REMOVING AND REPLACING SEAT RAIL IAW BOMBARDIER EO 601R-53-7965A.SDR COMA0560786Seat Track · corrodedLEFT FLOOR SEAT RAIL CORRODED FROM FS 559+16 TO FS 559+98. REPAIRED LEFT FLOOR SEAT RAIL FROM FS 559+16 TO FS 559+98 BY BLENDING SEAT RAIL IAW CRJ SRM 53-51-49.SDR COMA0560785Seat Track · corrodedFLOOR SEAT RAILS CORRODED AT FS 559+96 RBL 9, LBL 9 AND LBL 27. REPAIRED FLOOR SEAT RAILS AT FS 559+96 RBL 9, LBL 9 AND LBL 27 BY REMOVING AND REPLACING SEAT RAIL IAW BOMBARDIER EO 601R-53-7965A.SDR COMA0560784Seat Track · corrodedLEFT FLOOR SEAT RAIL CORRODED FROM FS 409+126 TO FS 559+16. REPAIRED LEFT FLOOR SEAT RAIL FROM FS 409+126 TO FS 559+16 BY REMOVING AND REPLACING SEAT RAIL IAW BOMBARDIER EO 601R-53-796A.SDR COMA0560783Seat Track · corrodedRIGHT SIDE SEAT RAIL CORRODED FROM FS 495.98 TO FS 535.02. REPAIRED RT SIDE SEAT RAIL FROM FS 495.98 TO FS 535.02 BY REMOVING AND REPLACING SEAT RAIL IAW BOMBARDIER EO 601R-53-7965A.SDR COMA0560782Seat Track · corrodedLEFT SIDE SEAT RAIL CORRODED FROM FS 495.98 TO FS 535.02. REPAIRED LEFT SIDE SEAT RAIL FROM FS 495.98 TO FS 535.02 BY REMOVING AND REPLACING SIDE SEAT RAIL IAW BOMBARDIER EO 601R-53-7976A.SDR COMA0560781Seat Track · corrodedRIGHT SIDE SEAT RAIL CORRODED FROM FS 409+111.02 TO FS 444.02. REPAIRED RIGHT SIDE SEAT RAIL FROM FS 409+111.02 TO FS 444.02 BY REMOVING AND REPLACING SEAT RAIL IAW BOMBARDIER EO 601R-53-7965A.SDR COMA0560780Seat Track · corrodedLEFT SIDE SEAT RAIL CORRODED FROM FS 409+111.02 TO FS 444.02. REPAIRED LEFT SIDE SEAT RAIL FROM FS 409+111.02 TO FS 444.02 BY REMOVING AND REPLACING SEAT RAIL IAW BOMBARDIER EO 601R-53-7695A.SDR COMA0560779Seat Track · corrodedRIGHT SIDE SEAT RAIL CORRODED FROM FS 444.02 TO FS 495.98. REPAIRED RIGHT SIDE SEAT RAIL FROM FS 444.02 TO FS 495.98 BY REMOVING AND REPLACING SEAT RAIL IAW BOMBARDIER EO 601R-53-7965A.SDR COMA0560778Seat Track · corrodedLEFT SIDE SEAT RAIL CORRODED FROM FS 444.02 TO FS 495.98. REPAIRED THE LEFT SIDE SEAT RAIL FROM FS 444.02 TO FS 495.98 BY REMOVING AND REPLACING SEAT RAIL IAW BOMBARDIER EO 601R-53-7965A.
Back to JASC 5347