N964TW
Service difficulty reports · 135
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 = 'N964TW' AND registry_match = 'registration' 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 = 'N964TW' AND registry_match = 'registration' 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 AALA20110802TUL05Door Frame · crackedWEB CRACKED AT AFT OF FORWARD ENTRY DOOR JAMB STATION 209 LONGERON 15 LEFT. INSTALLED DOUBLER PER AARD 53-10-00-11.SDR AALA20110801TUL04Skin · gougedDENT WITH DEEP GOUGES AT STATION 200, BETWEEN LONGERONS 4 AND 5 LEFT FUSELAGE SKIN. REPAIRED BY INSTALLING INTERNAL DOUBLER PER DWG SG09530001.SDR AALA20110731TUL09Rib · crackedRIGHT OUTBOARD SLAT OUTBOARD RIB IS CRACKED. REPLACED DAMAGED OUTBOARD RIB WITH NEW RIB PER ESO 80117 CHAPTER 27-80-1.SDR AALA20110730TUL04Pan · crackedLEFT STATION 1060 UPPER AFT WINDOW PAN EAR IS CRACKED. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20110730TUL03Pan · crackedRIGHT STATION 788 UPPER FORWARD WINDOW PAN EAR IS CRACKED. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20110730TUL02Pan · crackedRIGHT STATION 769 LOWER FORWARD WINDOW PAN EAR IS CRACKED. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20110725DWH02Skin · puncturedAIRCRAFT WAS STRUCK BY LAVATORY CART. FUSELAGE WAS DAMAGED BETWEEN STATIONS 120 AND 134. ACCOMPLISHED REPAIR PER SRM AND EA MD80-53-018224.SDR AALA20110725DWH01Frame · brokenAIRCRAFT STRUCK BY LAVATORY SERVICE CART. FRAME AND FORMERS WERE DAMAGED UNDER SKIN. REPAIRED FRAME AND FORMERS PER SRM AND EA MD-80-53-018225.SDR AALA20100906EWR01Computer · faultedEWR - CAPTAIN REPORTED SLAT DISAGREE LIGHT REMAINING ILLUMINATED AFTER SLAT RETRACTION. EMERGENCY DECLARED RETURNED EWR LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED DIRECT FLIGHT GUIDANCE COMPUTER NUMBER 2 THAT WAS AT FAULT. SYSTEM GROUSDR AALA20090724DFW05Iru · failedDFW - INERTIAL REFERENCE UNIT FAILED IN FLIGHT. RETURNED DFW WITHOUT INCIDENT. REPLACED INERTIAL REFERENCE UNIT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20090721DFW01Pump · failedDFW - ON DESCENT PASSING ABOUT FL310 RUDDER CONTROL MANUAL LIGHT ILLUMINATED FOLLOWED BY RIGHT HYDRAULIC PRESS LOW LIGHT. RIGHT HYDRAULIC PRESSURE INDICATED 500 PSI, FOLLOWED CHECKLIST RIGHT PRESS REMAINED AT 500 PSI, LEFT PRESS WAS NORMAL. AT APPROX 10,000 SDR AALA200802471ABattery Pack · dischargedLGA - EMERGENCY LIGHTS AT FORWARD CABIN INOPERATIVE. REPLACED BATTERY PACK FOR INOPERATIVE EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071975Cable · disconnectedMEM INFLIGHT T482/18OCT DFW TO IND, SMOKE REPORTED COMING FROM AREA BELOW SEATS 5EF AN 6EF. LANDED MEM WITHOUT INCIDENT. SMOKE DISSIPATED PRIOR TO ARRIVAL AT GATE. FOUND TWO WIRES TO SEAT 5EF POWERPORT DISCONNECTED BUT NO ARCING WAS EVIDENT. INSPECTED CARGSDR AALA20070449Pump · inoperativeSAN INFLIGHT - RIGHT HYDRAULIC PRESSURE WENT TO ZERO. USED ALTERNATE GEAR EXTENSION LEVER. LANDED SAN WITHOUT INCIDENT. REPLACED RIGHT ENGINE HYDRAULIC DRIVEN PUMP. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070118Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT FIRST CLASS CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT FIRST CLASS CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050526Battery Pack · inoperativeORD - EMERGENCY LIGHTS IN AISLE SEAT ROWS 22 TO 26 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS IN AISLE SEAT ROWS 22 TO 26. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050431Battery Pack · dischargedALL SEAT MOUNTED AND FIRST CLASS GALLEY EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK AT CONTROL MODULE AB5 1 AND AB5 3 FOR SEAT MOUNTED EMERGENCY LIGHTS. INSERTED LOOSE WIRES AT SEAT 17D AND CHARGED BATTERY FOR FIRST CLASS GALLEY EMERGENCY LIGHTS. SYSDR AALA20040214Wire · looseMIA EMERGENCY LIGHT AT SEAT 8D INOPERATIVE. FOUND LOOSE WIRING. SECURED WIRING FOR EMERGENCY LIGHT AT SEAT 8D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20031207Charger · inoperativeDFW - DURING OVERNIGHT MAINTENANCE, FOUND AFT RIGHT AND LEFT SIDE OVERWING DOOR EMERGENCY EXIT SIGNS INOPERATIVE. REPLACED BATTERY CHARGER ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20031208Charger · inoperativeDFW - DURING OVERNIGHT MAINTENANCE, FOUND FORWARD RIGHT AND LEFT OVERWING DOOR EMERGENCY EXIT SIGNS INOPERATIVE. REPLACED BATTERY CHARGER ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20031201Battery · dischargedDFW - DURING OVERNIGHT MAINTENANCE FOUND ALL SEAT EMERGENCY LIGHTS INOPERATIVE. REPLACED 4 STRIP LIGHT BATTERIES. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20031206Charger · inoperativeDFW - DURING OVERNIGHT MAINTENANCE, FOUND COCKPIT EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY CHARGER ASSEMBLY B5-23. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20031205Charger · inoperativeDFW - DURING OVERNIGHT MAINTENANCE, FOUND EMERGENCY LIGHTS IN TAILCONE INOPERATIVE. REPLACED BATTERY CHARGER ASSEMBLY B5-27 AND B5-28. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20030877Floor Support · corrodedMCI - FOUND CORROSION ON CARGO FLOOR SUPPORT AT STATION 1155 10 INCHES RBL TOPSIDE AND LOWER SIDE. CORRODED FLOOR SUPPORT WAS REPLACED WITH NEW MPH 5936660-63, PART WAS PRIMED, PAINTED WHITE AND HI-LOCKS WERE INSTALLED PER SRM 51-31-05. (M)SDR AALA20030876Floor Support · corrodedMCI - FOUND CORROSION ON CARGO FLOOR SUPPORT STATION 1155 TO 1212, 7 INCHES RBL TOP SIDE AND BOTTOM SIDE. REPLACED WITH NEW MPN 5936660-171, RIVETS WERE INSTALLED PER SRM 51-30-02. (M)SDR AALA20030875Floor Support · corrodedMCI - FOUND CORROSION ON CARGO FLOOR SUPPORT AT STATION 1212, 6 INCHES RBL TO 10 INCHES LBL TOP SIDE AND BOTTOM SIDE. REPLACED WITH NEW MPN 5936597-509, RIVETS WERE INSTALLED PER SRM 51-30-02. (M)SDR ZW0A0304002Light · inoperativeTHE EGRESS LIGHT WAS INOPERATIVE AT ROW 22. RESEATED THE LAMP. CHECK-C 5-25-2002.SDR ZW0A0302101Battery Pack · dischargedTHE EMERGENCY CEILING LIGHTS WERE INOPERATIVE AT ROWS 28 AND 29, AND THE EGRESS FLOOR LIGHT WAS INOPERATIVE AT ROW 21. REPLACED THE BATTERIES IN B5-107 BATTERY PACK, PN 408822-101, FOR THE CEILING LIGHTS, AND RESEATED THE LAMP INTO THE SOCKET FOR THE EGRESS LSDR ZW0A0300501LampTHE CABIN EGRESS LIGHTING WAS INOPERATIVE FROM ROW 26 TO 31. REPLACED LAMP AND SECURED LIGHTS. CHECK-C 5-25-02 STL. --CLOSED--SDR TWAA0105401Battery Pack · dischargedTHE EMERGENCY EXIT LIGHTS OVER THE LT AND RT FWD OVERWING EXIT DOORS WERE INOPERATIVE. REPLACED THE BATTERY PACK. CHECK-C 5-6-00 STL.SDR TWAA0102701Battery · dischargedTHE LIGHTS OVER LT FWD AND RT FWD OVERWING EMERGENCY EXITS WERE INOPERATIVE. REPLACED THE BATTERIES. CHECK-C 5-6-00 STL.SDR TWAA0100901Power Supply · dischargedTHE FWD LT AND RT OVERWING EMERGENCY EXIT SIGNS WERE INOPERATIVE. REPLACED THE POWER SUPPLY. CHECK-C 5-6-00 STL.SDR TWAA0016901Socket · wornTHE EGRESS LIGHTING AT ROW 30 AND 31 WERE INOPERATIVE. REPLACED THE LIGHT SOCKET AT ROW 31. CHECK-C 5-6-00 STL.SDR TWAA0013302Light · inoperativeTHE HAND HELD PORTABLE EMERGENCY LIGHT AT THE LEFT SIDE MOST FORWARD CABIN DOOR WAS INOPERATIVE. REPLACED THE LIGHT ASSEMBLY. CHECK-C 5-6-00 STL.SDR TWAA9913203Air Dist · smokingIN CRUISE CABIN GRADUALLY FILLED WITH BLUE SMOKE AND OIL SMELL. CABIN TEMP WAS TURNED DOWN AND ANTI ICE TURNED OFF. RT PACK PRESSURE WAS 10 PSI WHEN SMOKE APPEARED BUT RETURNED TO NORMAL WHEN ENG ANTI ICE TURNED OFF. BLUE SMOKE AND OIL SMELL GRADUALLY DISIP
Back to N964TW