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 AT9900282Cargo Track · corrodedSCHEDULED INSPECTION AT AERO CORP, FL. FOUND THE FORWARD PIT TRACK CORRODED ON THE BOTTOM SIDE. FABRICATED, LOCATED, DRILLED, DEBURRED, COUNTERSUNK, PRIMED, TREATED, AND INSTALLED IAW DC9 SRM 53-05 FIG 4C, 51-10-3 AND 51-10-4.SDR AT9900277Track · corrodedSCHEDULED INSPECTION AT AERO CORP, FL. FOUND THE AFT PIT RIGHT SIDE FLOOR TRACK CORRODED ON BOTTOM FULL LENGTH. FABRICATED, DRILLED, DEBURRED, PRIMED, AND TREATED IAW DC9 SRM 53-05 FIG 4C, 51-10-4, AND 51-10-3.SDR AT9900276Track · corrodedSCHEDULED INSPECTION AT AERO CORP, FL. FOUND THE FORWARD PIT RIGHT HAND TRACK BOTTOM SIDE CORRODED THROUGHOUT. REMOVED CORROSION, LOCATED NEW TRACK, DRILLED, COUNTERSUNK, DEBURRED, TREATED, AND PRIMED IAW DC9 SRM 53-05 FIG 4C, 51-10-4, AND 51-10-3.SDR AWXA9900066Seat Track · corrodedIN MAINTENANCE, NUMBER 3 SEAT TRACK CORRODED OUT OF LIMITS AT FR20-24. SEAT TRACK FABRICATED PER DWG D5311209220500 AND SPLICED INTO EXISTING TRACK. REF SRM 51-72-11.SDR AWXA9900065Seat Track · corrodedIN MAINTENANCE, NUMBER 4 SEAT TRACK CORRODED OUT OF LIMITS AT FR20. SEAT TRACK FABRICATED PER DWG D531120922600 AND SPLICED INTO EXISTING TRACK. REF SRM 51-71-11.SDR P5CA9900394Seat Track · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 817 LBL 87 SEAT TRACK FLANGE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900356Seat Track · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 1800 RBL 75 SEAT TRACK FLANGE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900334Seat Track · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 240 TO 260 RBL 36 SEAT TRACK CROWN SURFACE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR UPS99829136Seat Track · corrodedINSPECTION TYPE-C2, FS 740 TO 880, RBL 60 THE SEAT TRACK IS CORRODED BEYOND LIMITS. REMOVED SEAT TRACK FROM FS 710 TO 910, RBL 60, FABRICATED & REPLACED THE SEAT TRACK IAW SRM 53-2-3 FIG 2.SDR AT9900281Seat Track · corrodedSCHEDULED INSPECTION AT AERO CORP, FL. FOUND THE FORWARD CABIN SEAT TRACK AT BS 200 TO 279 RBL 22 CORRODED. REMOVED FLOOR PANELS, FABRICATED NEW SEAT TRACK AND SPLICE, LOCATED, DRILLED, ALODINED, PRIMED AND INSTALLED IAW DC9 SRM 53-05 FIG 4, 51-10-3, 51-30-1, SDR AALA990365Seat Track · corrodedTUL - FOUND CORROSION ON RIGHT OUTBOARD SEAT TRACK STATION 480 INBOARD, OUTBOARD LEGS AT FASTENER HOLES. REMOVED CORRODED SECTION OF SEAT TRACK. SPLICED IN NEW SECTION PER SRM 53-10-5 FROM STATION 480-560 RIGHT. (M)SDR DHL9974142CSeat Track · corrodedAT C CHECK, NR 1,2,3,4, AND 5 SEAT TRACKS GALLED AT STA 438. SEAT TRACKS BURNISHED, NR 5 OUT OF LIMITS PER SRM. CUT OUT DAMAGED SEAT TRACK AT STA 420 TO 480 AND REPLACED PER SRM 51-30-2, N/R 5719.SDR DHL9974141CSeat Track · corrodedAT C CHECK, NR 1, 2, 3, 4 AND 5 SEAT TRACKS HAS CORRSION AND GALLED AT STA 950D. CUT OUT DAMAGED SECTION OF SEAT TRACK NR 1 FROM 950C TO 950E AND INSTALLED NEW PER SRM 53-10-5, 40 N/R 5727.SDR DHL9974133CSeat Track · damagedAT C CHECK, NR 1 SEAT TRACK HAS LUGS BROKEN OFF GALLED AND CORRODED AT STA 852. REMOVED TRACK AND INSTALLED NEW TRACK PER SRM 51-30-2, N/R 5723.SDR DHL9974132CSeat Track · galledAT C CHECK, STA 1088 NR 1 SEAT TRACK GALLED OUT OF LIMITS. REMOVED AND REPLACED SEAT TRACK PER SRM 53-10-5, N/R 5729.SDR AT9900175Seat Track · corrodedSCHEDULED INSPECTION AT AERO CORP, FL. FOUND SEAT TRACK SCRATCHED AND CORRODED AT BS 559 TO 727. REMOVED AND REPLACED A 16 FT 3.75 SECTION OF SEAT TRACK IAW B737 SRM 53-10-5 FIG 1 AND 51-30-2.SDR UPS99829107Seat Track · corrodedINSPECTION TYPE:C3 MAIN CABIN SEAT TRACK AT FS 1140 TO 1100, BL 0, IS CORRODED BEYOND LIMITS. CUT OUT DAMAGED SECTION, FABRICATED, AND REPLACED SEAT TRACK FS 1070 TO 1150, BL 0, IAW SRM 53-2-3.SDR MWEA99078Seat Track · wornMKE - FOUND ELONGATED HOLES ON CAPTAIN'S RIGHT AFT SEAT TRACK. MTC FABRICATED AND INSTALLED NEW SEAT TRACK. (X)SDR CALA9900191Seat Track · corrodedINSPECTION FOUND RT INBOARD SEAT TRACK CORRODED AT STA 226 TO 232. THE CORRODED SEAT TRACK SECTION WAS REMOVED AND REPLACED IAW SRM 53-05.SDR AT9900184Track · corrodedSCHEDULED INSPECTION AT AERO CORP, FL. FOUND THE AFT PIT TIEDOWN TRACK CORRODED ON BOTH SIDE AT BS 332 TO 465. REMOVED AND REPLACED TIEDOWN TRACK IAW DC9 SRM 51-10-3.SDR AT9900157Seat Track · corrodedSCHEDULED INSPECTION AT AERO CORP, FL. FOUND CORRODED SEAT TRACK AT BS 827-927 LBL 24. REMOVED CORROSION OUT OF LIMITS, FABRICATED REPAIR SEAT TRACK, TREATED, PRIMED AND INSTALLED IAW B737 SRM 51-10-2, AND 51-30-2.SDR 99ZZZX1002Seat Track · misinstalledNEW CESSNA WITH 50.0 HOURS, WHILE ACCOMPLISHING A PHASE 1 INSPECTION, THE COPILOT'S INBOARD SEAT RAIL HAD ONE OF THE EIGHT BOLTS MOUNTING THE SEAT RAIL TO THE FLOOR CROSS THREADED INTO ITS NUTPLATE AND THE BOLT HEAD LACKED .1250 INCH FROM BEING SEATED.SDR UPS99829108Seat Track · corrodedINSPECTION TYPE:C3 FS 1306, BL 0, THE MAIN CABIN SEAT TRACK HAS HEAVY CORROSION. CUT OUT DAMAGED SECTION, FABRICATED, AND REPLACED SEAT TRACK FS 1290-1430, BL0 IAW SRM 53-2-3.SDR UPS99829071Seat Track · corrodedINSPECTION TYPE-C123, STA 1480 AT BL 0, THE SEAT TRACK HAS HEAVY CORROSION. REPAIRED AREA IAW SRM 53-2-3 FIG 8A.SDR UPS99829063Seat Track · corrodedINSPECTION TYPE-C123, STA 1036 RBL 24, THE SEAT TRACK HAS HEAVY CORROSION, ALSO AT STA 990. REMOVED AND REPLACED SEAT TRACK FROM STA 990 TO 1050 IAW SRM 53-2-3 FIG 8A.SDR AT9900156Seat Track · corrodedSCHEDULED INSPECTION AT AERO CORP, FL. FOUND CORRODED SEAT TRACK AT BS 947-967 RBL 48. REMOVED AND REPLACED SEAT TRACK IAW B737 SRM 53-10-1, AND 51-10-5.SDR UPS99829102Seat Track · corrodedINSPECTION TYPE:C3 SEAT TRACK HAS HEAVY CORROSION AT FS 500 LBL 50. CUT OUT DAMAGED SECTION, FABRICATED, AND REPLACED SEAT TRACK IAW SRM 52-2-3 FS 490 TO 580.SDR TWAA9902802Seat Track · corrodedDURING OP 16 MAINT CHECK, FOUND CORROSION ON SEAT TRACK, LT I/B AT STA 200 TO 237. INSTALLED NEW TRACK PER SPM 6-80-01. SPLICED PER SRM 53-05, FIG 4F, PG 10G.SDR SIMA990521Seat Track · corrodedSAW - DURING CPCP-1 INSPECTION, FOUND THE LEFT AND RIGHT FORWARD INBOARD, THE LEFT FORWARD OUTBOARD, THE LEFT AND RIGHT MIDDLE INBOARD, AND THE LEFT AND RIGHT MIDDLE OUTBOARD SEAT TRACKS CORRODED. (M)SDR AT9900342Tie Down · corrodedSCHEDULED INSPECTION AT AERO CORP, FL, FOUND THE G-2 GALLEY FLOOR MOUNTED TIE DOWNS AT BS 980 CORRODED. REMOVED AND REPLACED THE G-2 GALLEY FLOOR MOUNTS TIE DOWNS (4 EA) IAW DC9 MM 25-32-0.SDR 99ZZZM200Seat Track · corrodedSAW - DURING CPCP-1 INSPECTION, FOUND THE LEFT AND RIGHT FORWARD INBOARD, THE LEFT FORWARD OUTBOARD, THE LEFT AND RIGHT MIDDLE INBOARD, AND THE LEFT AND RIGHT MIDDLE OUTBOARD SEAT TRACKS CORRODED. (M)SDR 99ZZZM199Seat Track · corrodedSAW - DURING CPCP-1 INSPECTION, FOUND THE LEFT AND RIGHT FORWARD INBOARD, THE LEFT FORWARD OUTBOARD, THE LEFT AND RIGHT MIDDLE INBOARD, AND THE LEFT AND RIGHT MIDDLE OUTBOARD SEAT TRACKS CORRODED. (M)SDR 99ZZZM198Seat Track · corrodedSAW - DURING CPCP-1 INSPECTION, FOUND THE LEFT AND RIGHT FORWARD INBOARD, THE LEFT FORWARD OUTBOARD, THE LEFT AND RIGHT MIDDLE INBOARD, AND THE LEFT AND RIGHT MIDDLE OUTBOARD SEAT TRACKS CORRODED. (M)SDR 99ZZZM197Seat Track · corrodedSAW - DURING CPCP-1 INSPECTION, FOUND THE LEFT AND RIGHT FORWARD INBOARD, THE LEFT FORWARD OUTBOARD, THE LEFT AND RIGHT MIDDLE INBOARD, AND THE LEFT AND RIGHT MIDDLE OUTBOARD SEAT TRACKS CORRODED. (M)SDR AALA990271Seat Track · corrodedTUL - FOUND NR 6 SEAT TRACK CORRODED AT STATION 483 AND 516. INSTALLED SEAT TRACK PLUGS AT STATION 483 AND 516 PER SRM 53-05 PAGE 8C. (M)SDR AALA990270Seat Track · corrodedTUL - FOUND NR 2 SEAT TRACK HAS CORROSION AT STATION 1193. INSTALLED SEAT TRACK PLUG PER SRM 53-05 PAGE 8C. (M)SDR AALA990269Seat Track · corrodedTUL - FOUND NR 1 SEAT TRACK HAS CORROSION AT STATION 731. INSTALLED SEAT TRACK PLUG PER 53-05 SRM. (M)SDR AALA990268Seat Track · corrodedTUL - FOUND NR 3 SEAT TRACK CORRODED AT STATION 229. INSTALLED SEAT TRACK PLUG REPAIR AT STATION 229 NR 3 TRACK PER SRM 53-05-8C. (M)SDR UPS99829005Seat Track · gougedINSPECTION TYPE-C2, STA 1040 TRACK G SCALLOPS GOUGED. REMOVED DAMAGED SEAT TRACK, FAB SEAT TRACK AND SPLICES IAW DC8 SRM 5 3-2-3. ALODINED AND PRIMED IAW SRM DC8 51-1-8, INSTALLED SEAT TRACK IAW DC8 SRM 51-3-0.SDR QXEA9900520Seat Track · corrodedYXX - LEFT-HAND INBOARD SEAT TRACK HAS CORROSION. REPAIRED IAW DHC-8 RD 53-1339, STEP 1, SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9900519Seat Track · corrodedYXX - MINOR CORROSION FOUND ON RIGHT-HAND INBOARD SEAT TRACK. REPAIRED IAW DHC-8 RD 53-1339, STEP 1, SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9900518Seat Track · corrodedYXX - RIGHT-HAND OUTBOARD SEAT TRACK HAS MINOR CORROSION. REPAIRED IAW DHC-8 SRM 51-20-16 AND 51-20-30.SDR QXEA9900511Seat Track · corrodedYXX - SEAT TRACK CORROSION RIGHT SIDE CENTER AT STATION 600. REPAIRED IAW DHC-8 SRM 51-40-00 AND SRM 51-20-26.SDR HNAA9900031Seat Track · corrodedLEFT FORWARD INBOARD SEAT TRACK HAS CORROSION BEYOND LIMITS. REPLACED SEAT TRACK.SDR AT9900158Seat Track · corrodedSCHEDULED INSPECTION AT AERO CORP, FL. FOUND CORRODED SEAT TRACK AT BS 344 TO 360 LBL 24.75. REMOVED CORRODED SECTION OF SEAT TRACK, FABRICATED AND INSTALLED NEW TRACK IAW B737 SRM 53-10-1, AND 53-10-5.SDR UPS99828999Seat Track · gougedINSPECTION TYPE-C2, STA 940 TRACK HAS A SCALLOP GOUGED AND TANG BROKEN OFF. REMOVED SEAT TRACK FROM SPLICE TO SPLICE. LOCATED AND DRILLED NEW SEAT TRACK (2 EA) AND SPLICE IAW DC8 SRM 51-1-24. ALODINED AND PRIMED IAW DC8 SRM 51-1-8. INSTALLED IAW DC8 SRM 51-SDR UPS99828810Seat Track · corrodedINSPECTION TYPE-C1, FS 55 TO 70, RBL 45, THE DOUBLE TRACK IS CORRODED OUT OF LIMITS. REMOVED AND REPLACED SEAT TRACK FS 55 TO 130, RBL 45 IAW SRM 51-1-3.SDR RRXA991165Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO FLOOR PANEL AND SEAT TRACK BETWEEN STA 250 TO STA 300 AND BL 44 LEFT, DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGE AND TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED NEW FLOOR PANEL IAW SDR P2EA99895Cargo Track · corrodedSJO - DURING Q-CHECK, THE FORWARD CARGO COMPARTMENT CARGO TRACK AT BS 468, RBL 14, WAS FOUND WITH CORROSION. THE TRACK WAS REPAIRED AS PER SRM 53-10-5 FIG 5. (M)SDR AT9900187Tie Down · corrodedSCHEDULED INSPECTION AT AERO CORP, FL. FOUND THE FORWARD CARGO PIT TIEDOWN TRACK AT BS 427-503 RIGHT SIDE CORRODED. ORDERED A NEW SECTION OF TRACK AND INSTALLED IAW DC9 SRM 51-10-4, AND 53-05 PG 1014.
Back to JASC 5347