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 QXEA200301001Seat Track · corrodedPDX- NR 1 SEAT TRACK HAS TOP SURFACE CORROSION AT STATION X405.737. REPAIRED IAW DHC-8 RD 8-53-1342 AND SRM 51-00-06.SDR QXEA200301000Seat Track · corrodedPDX- NR 1 SEAT TRACK HAS TOP SURFACE CORROSION AT STATION X342.250. REPAIRED IAW DHC-8 RD 8-53-1342 AND SRM 51-00-06.SDR QXEA200300999Seat Track · corrodedPDX- NR 1 SEAT TRACK AT STATION X376.100 HAS TOP SURFACE CORROISON. REPAIRED IAW DHC-8 RD 8-53-1342.SDR QXEA200300998Seat Track · groovedPDX- NR 6 SEAT TRACK HAS A GROOVE IN THE LOWER TRACK SURFACE AT STATION 533.04. REPAIRED IAW DHC-8 RD 8-53-4936.SDR QXEA200300997Seat Track · groovedPDX- NR 5 SEAT TRACK HAS A GROOVE IN THE LOWER SURFACE AT STATION X520.000. REPAIRED IAW DHC-8 RD 8-53-1339.SDR QXEA200300996Seat Track · groovedPDX- NR 9 SEAT TRACK HAS A GROOVE IN THE LOWER SURFACE AT STATION X543.000. REPAIRED IAW DHC-8 RD 8-53-4936.SDR QXEA200300995Seat Track · groovedPDX- NR 4 SEAT TRACK HAS A GROOVE IN THE LOWER SURFACE AT STATION X531.00. REPAIRED IAW DHC-8 RD 8-53-4936.SDR QXEA200300994Seat Track · groovedPDX- NR 12 SEAT TRACK HAS A GROOVE IN THE LOWER SURFACE AT STATION X545.00. REPAIRED IAW DHC-8 RD 8-53-3644.SDR C2XA03TY127Seat Track · corrodedTYS DURING A SCHEDULED INSPECTION SEAT TRACK RW4 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW EMB MM 53-01-06. THE AIRCRAFT WILL BE RELEASED UPON COMPLETION OF INSPECTION.SDR C2XA03TY126Seat Track · corrodedTYS DURING A SCHEDULED INSPECTION SEAT TRACK LW6 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW EMB MM 53-01-06. THE AIRCRAFT WILL BE RELEASED UPON COMPLETION OF INSPECTION.SDR C2XA03TY125Seat Track · corrodedTYS DURING A SCHEDULED INSPECTION SEAT TRACK LF5 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW EMB MM 53-01-06. THE AIRCRAFT WILL BE RELEASED UPON COMPLETION OF INSPECTION.SDR C2XA03TY124Seat Track · corrodedTYS DURING A SCHEDULED INSPECTION SEAT TRACK LF6 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW EMB 53-01-06. THE AIRCRAFT WILL BE RELEASED UPON COMPLETION OF INSPECTION.SDR C2XA03TY123Seat Track · corrodedTYS DURING A SCHEDULED INSPECTION SEAT TRACK LF4 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW EMB MM 53-01-06. THE AIRCRAFT WILL BE RELEASED UPON COMPLETION OF INSPECTION.SDR C2XA03TY122Seat Track · corrodedTYS DURING A SCHEDULED INSPECTION SEAT TRACK RW3 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW EMB MM 53-01-06. AIRCRAFT WILL BE RELEASED UPON COMPLETION OF INSPECTION.SDR C2XA03TY121Seat Track · corrodedTYS DURING A SCHEDULED INSPECTION SEAT TRACK LF2 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW EMB MM 53-01-06.SDR QXEA200300988Seat Track · corrodedPDX- NR 4 SEAT TRACK HAS CORROSION ALONG RIVETS FOR ALUMINUM TRAY AT STATIONS X215.500 TO X222.00. REPAIRED IAW DHC-8 RD 8-55-1002, SRM 53-40-11, 51-20-16 AND 51-20-36.SDR QXEA200300987Seat Track · corrodedPDX- NR 7 SEAT TRACK HAS NUMEROUS AREAS OF PITTING CORROSION FROM STATIONS X215.500 TO X234.500. REPAIRED IAW DHC-8 RD 8-53-1102, SRM 51-40-00 AND 51-20-16.SDR 03FDEA01239Cargo Track · gougedMAIN CARGO DECK CARGO TRACK GOUGED STA 575-675 2C RBL 47.50. REMOVED AND REPLACED SEAT TRACK IAW SRM 53-70-00 26+51-33-01.SDR C1HA200381024Seat Track · crackedSEAT TRACK CRACKED AT BS 960 LBL 45.SDR UPS03841177Seat Track · corrodedINSPECTION TYPE: C1, OBSERVER SEAT TRACK FWD AND AFT IS CORRODED AT MOUNTING POINTS REMOVED AND REPLACED SEAT TRACK IAW DC8 SRM 51-3-0SDR C1HA200381023Seat Track · corrodedCORROSION ON SEAT TRACK FS 1000 / 1050 LBL 24.SDR C1HA200381022Seat Track · corrodedCORROSION ON SEAT TRACK FS 344 / 360 LBL 44.SDR C1HA200381021Seat Track · corrodedCORROSION ON SEAT TRACK FS 344 / 360 LBL 24.SDR C1HA200381019Seat Track · corrodedCORROSION ON SEAT TRACK LBL 45 BETWEEN FS 1010 AND 1110.SDR 0301623248Seat Track · corrodedDURING L CHECK FOUND CORROSION ON SEAT TRACKS Y-765 AND Y-1292 BETWEEN FRAMES 16-24. REPAIRED IAW EA 32-195649.SDR AWXA200300956Cargo Track · corrodedDURING C-04 CHECK GALVANIC CORROSION WAS FOUND ON UPPER SURFACE OF Y503 DUMMY RAIL BETWEEN FR 14 AND FR 16. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED Y503 DUMMY RAIL BETWEEN FR 14 AND FR 16; FABRICATED A NEW REPLACEMENTSDR C1HA200381017Seat Track · corrodedCORROSION ON SEAT TRACK LBL 24 IN NUMEROUS LOCATIONS BETWEEN FS 958 AND FS 1130.SDR CALA0300439Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT BS 1496-1580, LBL 75. THE SEAT TRACK WAS REPAIRED IAW SRM 53-00-52, REPAIR 3, FIGURE 202.SDR C2XA03TY120Seat Track · corrodedDURING A SCHEDULED 3C INSPECTION, SEAT TRACK RF3 IS CORRODED. MAINTENANCE REMOVED DAMAGED SEAT TRACK, CLEANED AREA, REINSTALLED SEAT TRACK, APPLIED CIC AND PLACED ON DMI FOR 200 FLIGHT CYCLES (REF M-602, 596609). WORK WAS IAW EMB 1C2003-145/2602 AND 53-10-06SDR DHL2003805510Cargo Track · wornMAIN CARGO COMPT NR 7 CARGO TRACK LUG WORN (STA 289.000 - 329.000). TRIMMED OUT DAMAGED CARGO TRACK SECTION IAW SRM 53-2-3 PG 49-50. FABRICATED SPLICES (7075-T6 AL0.100, 0.125, 0.160) IAW SRM 53-2-3 PG 49-50. CLEANED, TREATED AND PRIMED IAW SRM 51-1-8B. INSDR AWXA200300921Seat Track · corrodedDURING C-04 CHECK EXFOLIATION CORROSION WAS FOUND ON MAIN CABIN SEAT RAIL FR 64-66, Y1292, AT CLIP NUT HOLE JUST INBOARD OF R-2 DOOR GIRT BAR HOLD DOWN FITTING. MAINTENANCE REMOVED MAIN CABIN SEAT RAIL Y1292 BETWEEN FR 64 & FR 66; FABRICATED A NEW REPLACEMENT SDR ABXA030337Seat Track · corrodedCORROSION ON SEAT TRACK AT STA 275, 294, 320, 351, 380 AND 408. REPLACED CENTER SEAT TRACK STA 160 - 588 IAW DC-9 SRM 51-30-1 AND SSRM K05406.SDR C2XA03TY119Seat Track · corrodedDURING A SCHEDULED INSPECTION, SEAT TRACK LF4 WAS FOUND CORRODED. MAINTENANCE REMOVED THE TRACK, CLEANED THE CORROSION AND REINSTALLED IAW EC5340-01048.SDR C2XA03TY118Seat Track · corrodedDURING A SCHEDULED INSPECTION, SEAT TRACK LF5 WAS FOUND CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW EC5340-01048.SDR C2XA03TY117Seat Track · corrodedDURING A SCHEDULED INSPECTION, SEAT TRACK RW4 WAS FOUND CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW EC5340-01048.SDR C2XA03TY116Seat Track · corrodedDURING A SCHEDULED INSPECTION, SEAT TRACK LW6 WAS FOUND CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW EC5340-01048.SDR C2XA03TY115Seat Track · corrodedDURING A SCHEDULED INSPECTION SEAT TRACK LW4 WAS FOUND CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW EC5340-01048.SDR C2XA03TY114Seat Track · corrodedDURING A SCHEDULED INSPECTION SEAT TRACK LW5 WAS FOUND CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW EC5340-01048.SDR C2XA03TY113Seat Track · corrodedTYS- DURING A SCHEDULED INSPECTION, SEAT TRACK LF6 WAS FOUND CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW EC5340-01048.SDR C2XA03TY112Seat Track · corrodedTYS- DURING A SCHEDULED INSPECTION, SEAT TRACK RF5 WAS FOUND CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW EC5340-01048.SDR C2XA03TY111Seat Track · corrodedDURING A SCHEDULED INSPECTION, SEAT TRACK RF1 WAS FOUND CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW EC5340-01048.SDR C2XA03TY110Seat Track · corrodedTYS- DURING A SCHEDULED INSPECTION, SEAT TRACK RW 5 WAS FOUND CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW EC5340-01048.SDR C2XA03TY109Seat Track · corrodedDURING A SCHEDULED INSPECTION, SEAT TRACK LF2 WAS FOUND CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW EC5340-01048.SDR C2XA03TY108Seat Track · corrodedTYS- DURING A SCHEDULED INSPECTION, SEAT TRACK LW3 WAS FOUND CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW EC5340-01048.SDR C2XA03TY107Seat Track · corrodedDURING A SCHEDULED INSPECTION, SEAT TRACK LF3 WAS FOUND CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW EC5340-01048. SDR C2XA03TY106Seat Track · corrodedDURING A SCHEDULED INSPECTION SEAT TRACK RF2 WAS FOUND CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW-EC5340-01048.SDR 2003UALA00604Seat Track · crackedCRACK IN SEAT TRACK SUPPORT BEAM SUPPORT STRUCTURE AT BS 639 RIGHT BL 46. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW SUPPORT TRACK.SDR DHL2003805569Seat Track · wornMAIN CARGO COMPT NR 1 SEAT TRACK LUG WORN AT STA 327.000. TRIMMED OUT DAMAGED AREA IAW SRM 53-2-3 PG 17-18. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW CHANNEL AND PLUG IAW SRM 53-2-3 PG 17, 18, 19.SDR AWXA200300907Cargo Track · corrodedLCQ - MAJOR REPAIR - DURING C-17 CHECK EXFOLIATION CORROSION WAS FOUND ON AFT CARGO COMPARTMENT FLOOR TRACK TIE DOWN AT BS 787, RBL 15. MAINTENANCE CUTOUT DAMAGED SECTION FLOOR TRACK TIE DOWN AT BS 787, RBL 15; FABRICATED 2 EACH REPAIR ANGLES, AN EXTRUSION, ANSDR CALA0300427Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT BS 1513, RBL 74. THE SEAT TRACK WAS REPIARED IAW SRM 53-00-52, REPAIR 3.
Back to JASC 5347