N960TW, cancelled Jan 3, 2006
Service difficulty reports · 31
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. 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 n_number = 'N960TW' AND deregistration_id = 'N960TW-2006-01-03' 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 n_number = 'N960TW' AND deregistration_id = 'N960TW-2006-01-03' 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 ZW0A0301504Connector · disconnectedTHE EGRESS EMERGENCY EXIT LIGHT STRIP AT THE AFT GALLEY DOOR EXIT WAS INOPERATIVE. RECONNECTED CONNECTOR ON TERMINAL STRIP.SDR ZW0A0301503Wire Harness · disconnectedTHE FIRST CLASS EGRESS LIGHTING WAS INOPERATIVE. RECONNECTED FEEDER CABLE.SDR ZW0A0300302ABattery Pack · dischargedAN EMERGENCY CEILING LIGHT AT ROW 11, ROW 27 TO AFT CABIN CEILING LIGHTS, AND BOTH AFT OVERWING EMERGENCY EXIT SIGNS WERE ALL INOPERATIVE. REPLACED THE LAMP AT ROW 11, AND REPLACED THE BATTERY PACK FOR THE AFT CABIN CEILING LIGHTS, AND FOR THE AFT OVERWING EXSDR ZW0A0300302Light · inoperativeAN EMERGENCY CEILING LIGHT AT ROW 11, ROW 27 TO AFT CABIN CEILING LIGHTS, AND BOTH AFT OVERWING EMERGENCY EXIT SIGNS WERE ALL INOPERATIVE. REPLACED THE LAMP AT ROW 11, AND REPLACED THE BATTERY PACK FOR THE AFT CABIN CEILING LIGHTS, AND FOR THE AFT OVERWING EXSDR ZW0A0209401Battery · dischargedBOTH COCKPIT EMERGENCY LIGHTS AT TOP OF OVERHEAD PANEL WERE INOPERATIVE. REPLACED BATTERIES IN POWER SUPPLY B5-23.SDR ZW0A0207401Power Supply · inoperativeTHE EMERGENCY LIGHTS IN THE COCKPIT AND ENTRY DOOR OVERHEAD, AND THE EGRESS LIGHTS IN THE FIRST CLASS SECTION, WERE INOPERATIVE. REPLACED THE POWER SUPPLY FOR THE EMERGENCY LIGHT MALFUNCTION, AND THE AIRCRAFT MAINTENANCE FERRIED TO STL FOR CORRECTION OF THE ESDR ZW0A0206801Transmitter · false indicationDURING THE CLIMB STAGE OF FLIGHT, RH BRAKE PRESSURE GAUGE INDICATES 500 PSI WITH NO VISIBLE FLUID LOST. GAUGE STILL FAILS TO CORRECTLY REGISTER WITH PUMPS PLACED TO THE "HI" POSITION. REMOVED AND REPLACED RH BRAKE SYSTEM TRANSMITTER (293-0061), OPERATIONAL CHESDR ZW0A0110401Control Cable · brokenCREW REPORTED FLAP SPLIT INDICATION ACCOMPANIED WITH ROLL TENDENCY. FOUND T/E FLAP BUS CABLE BROKEN DUE TO CORROSION AND FATIGUE. CHANGED CABLE RUNS 33A AND B, AND 34A AND B. CHANGED CABLES PART NUMBERS C04564-2, C04564-1, 3922841-527, AND 3922841-531.SDR ZW0A0102305Skin · crackedDURING CHECK-C MAINT FUSELAGE STA 1380, LONGERON 14L, HAD .25 INCH INCH CRACK AFT OF RIVET. REPAIRED PER SRM 53-04, FIG 18, AND 51-30-2.SDR TWAA0012901Battery Pack · dischargedTHE COCKPIT AND FWD CABIN AISLE EMERGENCY LIGHTS CAME ON WITH POWER OFF, AND THE OVERWING EMERGENCY LIGHTS CAME ON AND WOULD NOT CYCLE OFF. CLEANED THE BATTERY CONNECTOR FOR THE FWD CABIN MALFUNCTION, AND REPLACED THE BATTERY PACK FOR THE OVERWING LIGHT MALFUSDR TWAA0012403Battery Pack · dischargedTHE EGRESS LIGHTING AT SEAT 24C WAS FLASHING INTERMITTENTLY. REPLACED THE BATTERY PACK. CHECK-C 6-19-00 STL.SDR TWAA0007801Battery Pack · inoperativeTHE FLOOR EGRESS LIGHTS AT ROWS 31 TO 33 WERE INOPERATIVE. REPLACED THE BATTERY PACK. CHECK-C 6-10-99 MCI.SDR TWAA9907905Frame · corrodedDURING CHECK-C MAINT, FOUND LOWER CHORD ATTACH BOLTS TO STRINGER 30 AND 29L WERE RUSTY AND CORRODED, STA 1060 FRAME. INSTALLED NEW FRAME AT STA 1060 PER SPM 6-70-01.SDR TWAA9907602Longeron · crackedDURING CHECK-C MAINT, FOUND FUSELAGE LONGERON 20R CRACKED AT FASTENER, UPPER O/B CORNER OF THE WHEEL WELL AT STA 1003. STOP DRILLED CRACK PER SRM 51-00-03 AND REPAIRED PER ARA 16170.SDR TWAA9907507Support · corrodedDURING CHECK-C MAINT, FOUND MATERIAL REMOVED BEYOND LIMITS FOR CORROSION REMOVAL ON FLOOR SUPPORT, STA 188 TO 193, RBL 44. REPLACED FLOOR SUPPORT AT STA 160 TO 200, RBL 44.SDR TWAA9907508Angle · crackedDURING CHECK-C MAINT, FOUND CABIN FRONT SPAR UPPER CAP TIE ANGLE WAS CRACKED APPROX 6 INCHES LONG, STA 826, RBL 58 INCHES. REPLACED TIE ANGLE WITH NEW PART PER SRM 6-70-01.SDR TWAA9907103Angle · crackedDURING CHECK-C MAINT, FOUND LOWER RT VERTICAL STABILIZER MOUNT ANGLE CRACKED 2 PLACES AFT END BELOW RUDDER. ACCOMP NDT HFEC FOR CRACK CONTAINMENT AFTER SECTION CUT OUT. TRIMMED OUT CRACK PER SRM 53-05.SDR TWAA9807014Floor · corrodedMCI - DURING OP 15 MAINTENANCE CHECK, FOUND LIGHT CORROSION AROUND SCREW HOLES IN FLOOR MEMBRANE AT FS 1250, LBL 47 TO LBL 53. REMOVED CORROSION PER SRM 51-10-3. REPAIRED PER SRM 53-10 FIG 2. (X)SDR TWAA9807005Frame · crackedMCI - DURING OP 15 MAINTENANCE CHECK FOUND IN LT GEAR WHEEL WELL, FS 940 LBL 4, FRAME WEB CRACKED AND U-CHANNEL AFT SIDE OF WEB CRACKED IN 2 PLACES. INSTALLED REPAIR PER SRM 53-01 PAGE 9. (X)SDR TWAA9807004Support · crackedMCI- DURING OP 15 MAINTENANCE CHECK, FOUND FORWARD INBOARD CORNER OF LT WHEEL WELL FAIRING SUPPORT STRUCTURE CRACKED, FWD AND AFT SIDES, LBL 6. INSTALLED REPAIR PER SRM 53-01. (X)SDR TWAA9807003Angle · crackedMCI - DURING OP 15 MAINTENANCE CHECK, FOUND T-ANGLES FOR FILLET FAIRING ATTACH STRUCTURE CRACKED AT CENTERLINE, STA 864, 875, AND 886. THREE CRACKS. REPLACED T-ANGLES PER SRM 51-01, PAGE 1 ITEM C, AND STANDARD PRACTICES. (X)SDR TWAA9809402Stiffener · crackedMCI - DURING OP 15 MAINTENANCE CHECK, FOUND VERTICAL STIFFENER BELOW FLOOR AT STA 927, LBL 44, CRACKED. REPAIRED PER SRM 51-01. INSTALLED NEW CASTING. (X)SDR TWAA9807007Angle · crackedMCI - DURING OP 15 MAINTENANCE CHECK, FOUND ANGLE BRACE CRACKED AND DOUBLER BELOW ALSO CRACKED, JUST INBD OF NR 2 LE SLAT INBD TRACK. MANUFACTURED ANGLE BRACE AND DOUBLER AND INSTALLED PER SRM 51-01, PAGE 1 ITEM C, AND STANDARD PRACTICES. (X)SDR TWAA9806917Frame · crackedMCI - DURING OP 15 MAINTENANCE CHECK, FOUND RT MLG WHEEL WELL FS 940, RBL 4, FRAME WEB CRACKED AND U-CHANNEL CRACKED AFT SIDE OF WEB. REPLACED U-CHANNEL AND FASTENER IN WEB PER SRM 51-01. (M)SDR TWAA9806916Floor · corrodedMCI - DURING OP 15 MAINTENANCE CHECK, FOUND HOLD CORRODED THROUGH CABIN FLOOR MEMBRANE AT STATION 172, RBL 52. REPAIRED PER SRM 53-01, FIG 4 AND TWA STD PRACTICES. (M)SDR TWAA9807008Floorbeam · corrodedMCI - DURING OP 15 MAINTENANCE CHECK, FOUND CORROSION ON FLOORBEAM FS 200, RBL 58 IN. REMOVED FLOOR SUPPORT BEAM AND INSTALLED NEW BEAM PER SRM 51-01 AND TWA STANDARD PRACTICES. (X)SDR TWAA9806918Floor Track · corrodedMCI - DURING OP 15 MAINTENANCE CHECK, FOUND CORROSION ON RT FLOOR TRACK FROM FS 1212 TO 1322. REMOVED AND REPLACED TRACK PER SRM 51-01, PAGE 2 ITEM C, AND TWA STD PRACTICES. (M)SDR TWAA9806919Floorbeam · corrodedMCI - DURING OP15 MAINTENANCE CHECK, FOUND CORROSION ON FLOORBEAM AT FS 197, LBL 6 INCH. REPLACED BEAM PER SRM 51-01, AND STD PRACTICES. (M)SDR TWAA9807006Floorbeam · corrodedMCI - DURING OP 15 MAINTENANCE CHECK, FOUND CORROSION ON FLOORBEAM CAP, FS 200, LBL 12 IN. REPLACED CAP PER SRM 51-01. (X)SDR TWAA9806920Floorbeam · corrodedMCI - DURING OP15 MAINTENANCE CHECK, FOUND CORROSION ON FLOORBEAM AT FS 180, RBL 20 INCH TO 43 INCH. REMOVED AND INSTALLED NEW FLOORBEAM PER SRM 51-01. (M)SDR TWAA9758001Stator Support · crackedIAD - FLT 341 - DURING CLIMB, A LOUD BANG WAS HEARD ACCOMPANIED BY A RISE IN EGT ON NR 2 ENGINE, SN 1227. ENGINE WAS SHUT DOWN IN-FLIGHT. ENGINE TOTAL TIME: 26,295 HOURS; 17,232 CYCLES. CHECK C - 2-24-97 - JFK. INVESTIGATION OF THE RISE IN EGT IN THE NR 2
Back to N960TW, cancelled Jan 3, 2006