N965TW
Service difficulty reports · 117
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 = 'N965TW' 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 = 'N965TW' 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 AALA2009062300003Battery Pack · dischargedMCI - AFT EMERGENCY LIGHTS AT STATION 1296 AT RIGHT LAVATORY AND ENTRY AREA INOPERATIVE. REPLACED BATTERY PACK FOR AFT EMERGENCY LIGHTS AT STATION 1296 AT RIGHT LAVATORY AND ENTRY AREA.SDR AALA200810190Web · crackedCANT FRAME 1485 UPPER LEFT WEB CRACKED AFT OF LEFT LOUVER BOX. INSTALLED DOUBLER PER AARD 53-10-00-32.SDR AALA20071940Blades · damagedDFW INFLIGHT T1157/15OCT - RIGHT ENGINE PRESSURE RATIO FLUCTUATION AND VIBRATION ON TAKEOFF ROLL ENGINE COMPRESSORS STALLED. RETURNED TO DFW AND LANDED WITHOUT INCIDENT. REPLACED NUMBER TWO ENGINE ON 16 OCT 2007 AT DFW DUE TO FAN FOD DAMAGE DURING TAKEOFF. SDR AALA20071923Bulb · brokenSFO - EMERGENCY LIGHT AT 10EG HAS BROKEN LAMP. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 10EG. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071922Lens · brokenSFO - EMERGENCY LIGHT AT 10EG HAS BROKEN LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 10EG. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071921Shroud · brokenSFO - EMERGENCY LIGHT AT 10EG HAS BROKEN SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT 10EG. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070193Bulb · burned outLGA - EMERGENCY SEAT MOUNTED LIGHT AT SEAT ROW 21 INOPERATIVE. RELAMPED EMERGENCY SEAT MOUNTED LIGHT AT SEAT ROW 21. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070192Bulb · burned outLGA - FOUND EMERGENCY SEAT MOUNTED LIGHT AT SEAT ROW 17 INOPERATIVE. RELAMPED EMERGENCY SEAT MOUNTED LIGHT AT SEAT ROW 17. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070191Bulb · burned outLGA - EMERGENCY SEAT MOUNTED LIGHT AT SEAT ROW 11 INOPERATIVE. RELAMPED EMERGENCY SEAT MOUNTED LIGHT AT SEAT ROW 11. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070190Bulb · burned outLGA - FOUND EMERGENCY SEAT MOUNTED LIGHTS AT SEAT ROW 7 INOPERATIVE. RELAMPED EMERGENCY SEAT MOUNTED LIGHTS AT SEAT ROW 7. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060147Battery Pack · inoperativeLGA - EMERGENCY LIGHTS IN FORWARD AND AFT CABIN INOPERATIVE. REPLACED TWO BATTERY PACKS AT AB52 AND AB53 FOR EMERGENCY LIGHTS IN FORWARD AND AFT CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050016Battery Pack · inoperativeDFW - CEILING EMERGENCY EXIT LIGHTS ABOVE FORWARD ENTRY AREA INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY EXIT LIGHTS ABOVE FORWARD ENTRY AREA. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040067Connector · looseDFW EMERGENCY PATH LIGHT AT ROW 12 INOPERATIVE. FOUND CONNECTOR LOOSE AT ROW 12 LIGHT ASSEMBLY. RESECURED CONNECTOR FOR EMERGENCY PATH LIGHT ASSEMBLY AT ROW 12. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20031361Control Unit · faultyPDX T1010/01 EN ROUTE PDX-DFW RIGHT HAND BUS FAULT AND POPPING CIRCUIT BREAKERS. RETURNED PDX AND LANDED WITHOUT INCIDENT. REMOVED AND REPLACED AIRCRAFT BUS CONTROL UNIT AND R2-36 RELAY SYSTEM PER MM 24-20-08-4. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20030646Cargo Track · corrodedFOUND AFT CARGO, LEFT TIE DOWN TRACK CORRODED FROM STATION 1220-1309. REMOVED AND REPLACD TRACK. (M)SDR ZW0A0102003Light · inoperativeTHE OVERWING EMERGENCY EXIT SIGN WAS MISSING AT SEAT 21A, THE FWD ENTRANCE DOOR PORTABLE EMERGENCY LIGHT WAS INOPERATIVE, AND THE THE RED EGRESS LIGHT WAS INOPERATIVE AT THE FWD GALLEY AND AFT LAVATORY. INSTALLED EXIT MARKER P/N 0105612-001, REPLACED 2 DISCHASDR TWAA0010403Audio Panel · failedCREW REPORTED A TOTAL RADIO COMMUNICATION FAILURE ENROUTE. FLIGHT RETURNED TO STL BUT WAS ABLE TO RE-ESTABLISH COMMUNICATION. REPLACED THE FIRST OFFICERS AUDIO SELECTOR PANEL. CHECK-C 6-1-00 STL. ---CLOSED---
Back to N965TW