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 SWIA200211386Galley Track · corrodedGALLEY, FORWARD INBOARD LOWER ATTACH POINT TRACK ON FLOOR, HAS CORROSION. FOUND DURING C CHECK INSPECTION. REPLACED FLOOR TRACK THAT SERVES AS FORWARD LOWER INBOARD ATTACHMENT POINT FOR GALLEY.SDR SWIA200211385Seat Track · corrodedFORWARD LEFT FLOOR SEAT TRACK FOUND CORRODED. FOUND DURING C CHECK INSPECTION. REMOVED AND REPLACED LEFT FORWARD SEAT TRACK.SDR AALA20021492Cargo Track · corrodedTUL - FOUND CORROSION AROUND TIEDOWN TRACK ATTACH SCREWS AND CLIPNUT HOLES LEFT SIDE. INSTALLED SERVICEABLE LEFT TIEDOWN TRACK AFT CARGO BETWEEN STATION 1220-1309, PER SRM 51-10. (M)SDR 02FDEA00726Seat Track · corrodedCORROSION ON SEAT TRACK I/B FLANGE UPR SURFACE AROUND NUTPLATE HOLES AT BS 760-848, LBL 24, WL 208. R&R SEAT TRACK PER SRM 51-30-2.SDR QXEA0201658Seat Track · gougedPDX - GOUGE IN NEW NR 9 SEAT TRACK AT APPROXIMATELY STATION X598.0. REPAIRED IAW DHC-8 SRM 51-20-80, PAGES 1-2 AND PSM 1, CHAPTER 5.SDR QXEA0201652Seat Track · corrodedPDX - RT INBOARD SEAT TRACK HAS NUMEROUS DISCREPANCIES. REPLACED NR 9 SEAT TRACK IAW DHC-8 SRM 51-40-11 AND RD 8-53-4472.SDR QXEA0201648Seat Track · chafedPDX - RT INBOARD SEAT TRACK NR 8 INBOARD FLANGE CHAFED AT APPROXIMATELY X462.00. REPAIRED IAW DHC-8 SRM 51-20-36, PAGES 1-10.SDR QXEA0201647Seat Track · chafedPDX - RT INBOARD SEAT TRACK NR 8 BOTTOM CHAFING BY FLOOR TRIM AT APPROXIMATELY X445.00. REPAIRED IAW DHC-8 SRM 51-20-36, PAGES 1-10.SDR QXEA0201646Seat Track · gougedPDX - RT INBOARD SEAT TRACK NR 8 BOTTOM GOUGES IN SEAT ATTACH AREA AT APPROXIMATELY X438.00. REPAIRED IAW DHC-8 SRM 51-20-36, PAGES 1-10.SDR QXEA0201643Seat Track · chafedPDX - RIGHT HAND INBOARD SEAT TRACK NR 8 BOTTOM CHAFED BY TRACK COVER AT APPROXIMATELY X510.00. REPAIRED IAW DHC-8 SRM 51-20-36, PAGES 1-10.SDR QXEA0201642Seat Track · corrodedPDX - RT INBOARD SEAT TRACK NR 8 BOTTOM CORROSION IN SEAT ATTACH AREA AT APPROXIMATELY X500.00. REPAIRED IAW DHC-8 SRM 51-20-36, PAGES 1-10.SDR QXEA0201641Seat Track · corrodedPDX - RT INBOARD SEAT TRACK NR 8 TOP CORROSION IN SEAT ATTACH AREA AT APPROXIMATELY X487.00.. REPAIRED IAW DHC-8 SRM 51-20-36, PAGES 1-10.SDR QXEA0201640Seat Track · chafedPDX - RT INBOARD SEAT TRACK NR 8 CHAFED 12 INCHES BY TRACK COVER AT APPROXIMATELY X475.00. REPAIRED IAW DHC-8 SRM 51-20-36. PAGES 1-10.SDR QXEA0201639Seat Track · corrodedPDX - RT INBOARD SEAT TRACK NR 8 TOP AND BOTTOM HAS CORROSION IN SEAT ATTACH AREA AT APPROXIMATELY X469.00. REPAIRED IAW DHC-8 SRM 51-20-36, PAGES 1-10.SDR QXEA0201627Seat Track · corrodedPDX - CORROSION AROUND TWO RIVETS BETWEEN SEAT RAILS AFT RT FLOOR SUPPORT CLOSING ANGLE AT APPROXIMATELY X597.00. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36, PAGES 1-10.SDR QXEA0201626Seat Track · corrodedPDX - RT OUTBOARD SEAT TRACK NR 12, TOP AND BOTTOM HAS CORROSION IN SEAT ATTACH AREA AT APPROXIMATELY X541.00. REPAIRED IAW RD 8-53-3644 AND SRM 51-20-36, PAGES 1-10.SDR QXEA0201625Seat Track · gougedPDX - RT OUTBOARD SEAT TRACK NR 12, TOP, GOUGES IN SEAT ATTACH AREA AT APPROXIMATELY X531.00. REPAIRED IAW DHC-8 SRM 51-00-06 AND SRM 51-20-36 PAGES 1-10.SDR QXEA0201624Seat Track · gougedPDX - RIGHT HAND OUTBOARD SEAT TRACK NR 12 TOP AND BOTTOM GOUGES IN SEAT ATTACH AREA AT X518.00. REPAIRED IAW DHC-8 RD 8-53-3644, SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0201623Seat Track · corrodedPDX - RIGHT HAND OUTBOARD SEAT TRACK NR 11 TOP AND BOTTOM CORROSION IN SEAT ATTACH AREA AT X500.00. REPAIRED IAW DHC-8 RD 8-53-1342, SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0201622Seat Track · corrodedPDX - RIGHT HAND OUTBOARD SEAT TRACK NR 11 TOP AND BOTTOM CORROSION IN SEAT ATTACH AREA AT X487.00. REPAIRED IAW DHC-8 RD 8-53-1342, SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0201621Seat Track · corrodedPDX - RIGHT HAND OUTBOARD SEAT TRACK NR 11 TOP AND BOTTOM CORROSION IN SEAT ATTACH AREA AT X469.00. REPAIRED IAW DHC-8 RD 8-53-1352, SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0201620Seat Track · corrodedPDX - RIGHT HAND OUTBOARD SEAT TRACK NR 11 TOP AND BOTTOM CORROSION IN SEAT ATTACH AREA AT X455.00. REPAIRED IAW DHC-8 RD 8-53-1342, SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0201619Seat Track · corrodedPDX - RIGHT HAND OUTBOARD SEAT TRACK NR 11 TOP AND BOTTOM CORROSION IN SEAT ATTACH AREA AT X438.00. REPAIRED IAW DHC-8 RD 8-53-1342, SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0201613Seat Track · chafedPDX - LEFT HAND OUTBOARD SEAT TRACK NR 3 BOTTOM CHAFED IN SEAT ATTACH AREA AT X541.00. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0201612Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK NR 3 TOP CORROSION IN SEAT ATTACH AREA AT X531.00. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0201611Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK NR 3 TOP CORROSION IN SEAT ATTACH AREA AT X518.00. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0201610Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK NR 2 TOP CORROSION IN SEAT ATTACH AREA AT X500.00. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0201609Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK NR 2 TOP CORROSION IN THE SEAT ATTACH AREA AT X487.00. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0201608Seat Track · gougedPDX - LEFT HAND OUTBOARD SEAT TRACK NR 2 GOUGES TOP AND BOTTOM IN SEAT ATTACH AREA AT X469.00. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0201607Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK NR 2 TOP CORROSION IN SEAT ATTACH AREA AT X455.00. REPAIRED IAW DHC-8 SRM 51-20-16, AND SRM 51-20-36.SDR QXEA0201606Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK NR 2 TOP AND BOTTOM CORROSION IN SEAT ATTACH AREA AT X438.00. REPAIRED IAW DHC-8 SRM 51-20-16, AND SRM 51-20-36.SDR ASAA0280354Seat Track · corrodedOKC - FOUND DURING 30K CHECK, SEAT TRACK CORRODED BEYOND LIMITS AT LBL 44 FROM FS 1176-1211. REPLACED SEAT TRACK FROM FS 1155-1231 PER SRM 53-05, FIG 4F. (M)SDR ASAA0280355Seat Track · corrodedOKC - FOUND 30K CHECK, FOUND SEAT TRACK CORRODED BEYOND LIMITS AT LBL 22 FROM FS 1122 AND AT 1229. REPLACED SEAT TRACK FROM FS 1085-1310 PER SRM 53-05, FIG 4F. (M)SDR AALA20021496Seat Track · corrodedTUL - FOUND NR 6 SEAT TRACK HAS CORROSION, SEVERAL AREA'S OUT OF LIMITS STATION 275-791. NEW SEAT TRACK INSTALLED/AMM 53-40-01,01-02. (M)SDR QXEA0201666Seat Track · corrodedPDX - SEAT TRACK NR 1 HAS NUMEROUS DISCREPANCIES. REPLACED NR 1 SEAT TRACK IAW DHC-8 SRM 51-40-00.SDR QXEA0201665Seat Track · corrodedPDX - SEAT TRACK NR 4 HAS NUMEROUS DISCREPANCIES. REPLACED NR 4 SEAT TRACK IAW DHC-8 SRM 51-40-11 AND RD 8-53-1102.SDR F3LA200200350Cargo Track · corrodedDURING C 4 CHECK, CORROSION WAS FOUND ON CARGO TRACK AT BS 947, RBL 14 AT THE TIE DOWN SOCKET. CARGO TRACK SECTION WAS REPLACED IN ACCORDANCE WITH SRM 53-00-53, FROM BS 867 TO BS 947.SDR F3LA200200324Cargo Track · corrodedDURING C-4 CHECK, INSPECTION REPORTED AFT CARGO COMPARTMENT FLOOR STRINGER CORRODED AT BS 771, RBL 14. REPLACED FLOOR STRINGER TIE DOWN TRACK PER SRM 51-10-02 AND 51-40-02.SDR F3LA200200323Cargo Track · corrodedDURING C-4 CHECK, INSPECTION REPORTED AFT CARGO COMPARTMENT FLOOR STRINGER CORRODED AT SCREW HOLES FROM BS 847 TO BS 787, RBL 16. REPLACED STRINGER TIE DOWN TRACK PER SRM 57-10-02 AND 51-40-02.SDR AALA20021524Seat Track · crackedTUL - FOUND NR 4 SEAT TRACK, LUG CRACKED AT STATION 270. INSTALLED REPAIR PLUG PER AARD 53-20-00-10. (M)SDR SIMA200230333Seat Track · corrodedABI - THIS IS A LEVEL 2 FINDING, LEFT FORWARD INBOARD SEAT TRACK HAS CORROSION. REMOVED AND INSTALLED SERVICEABLE SEAT TRACK IAW EMB 145 AMM 53-01-06. (M)SDR ASAA0280338Cargo Track · corrodedOAK - FOUND DURING C-CHECK, LEFT FORWARD TIEDOWN TRACK IN AFT CARGO BAY CORRODED ON OUTBOARD SIDE. REPLACED SECTION OF TRACK FROM STATION 1007-1193 PER SRM 51-30-5, PAGE 1-14 AND 51-30-2. (M)SDR QXEA0201664Seat Track · corrodedPDX - SEAT TRACK NR 7 HAS NUMEROUS DISCREPANCIES. REPLACED NR 7 SEAT TRACK IAW DHC-8 SRM 51-40-11.SDR QXEA0201637Seat Track · corrodedPDX - SEAT TRACK NR 10 CORRODED. REPLACED NR 10 SEAT TRACK IAW DHC-8 SRM 51-40-00 AND SRM 51-40-11.SDR QXEA0201636Seat Track · corrodedPDX - SEAT TRACK NR 6 CORRODED. REPLACED SEAT TRACK IAW DHC-8 SRM 51-40-00 AND SRM 51-40-11.SDR AALA20021510Seat Track · corrodedTUL - FOUND CORROSION ON SEAT TRACK NR 6 STATION 1212-1213. REMOVED CORROSION PER SRM 51-10-03 BEYOND SRM LIMITS. REMOVED DAMAGE AND INSTALLED PLUG PER SRM 53-05 FIG 4A. (M)SDR CALA0200479Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED BETWEEN STA 270 AND 294.5, RBL 43 UNDER G-1 GALLEY. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-00-52 AND 51-10-02.SDR UPS02839569Seat Track · damagedINSPECTION TYPE:C1 HOLES FOR LOCK PINS WORN OUT OF ACCEPTABLE LIMITS IAW DC8 SRM 53-2-3 HOLES FOUND TO BE ELONGATED BEYOND LIMITS OF DC8 SRM 53-2-3 REMOVED WORN SEAT TRACK IAW DC8 SRM 51-3-0 DRILLED NEW SEAT TRACK IAW DC8 SR M 51-1-24 INSTALLED NEW SEAT TRSDR QXEA0201562Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK NR 1 TOP CORROSION IN SEAT ATTACH AREA AT X298.00. REPLACED NR 1 SEAT TRACK.SDR QXEA0201561Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK NR 1 TOP CORROSION IN SEAT ATTACH AREA AT X280.00. REPLACED NR 1 SEAT TRACK.
Back to JASC 5347