N969TW
Service difficulty reports · 125
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 = 'N969TW' 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 = 'N969TW' 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 AALA20110606TUL08Cusp Web · corrodedLEFT CUSP STATION 605 CORROSION AROUND LIGHTNING HOLE. INSTALLED DOUBLER FOR LEFT CUSP AT STATION 605 PER AARD 53-20-00-16.SDR AALA20110605TUL01Membrane · crackedSUBFLOOR CRACKED AT STATION 218 RIGHT BUTTLINE 24. CUT OUT CRACKED AREA AND INSTALLED DOUBLERS PER AARD 53-20-00-16.SDR AALA20110603TUL05Gusset · damagedGUSSET CRACKED STATION 209 LONGERON 15 LEFT. INSTALLED DOUBLER PER AARD 53-10-00-11.SDR AALA20110521DFW01Shutoff Valve · inoperativeDFW - CREW REPORTED ELECTRICAL ODOR IN COCKPIT DURING CLIMBOUT. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LEFT PRESSURE REGULATOR SHUT-OFF VALVE. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20100211TUL14Frame · crackedTHE 1418 FRAME IS CRACKED ON AFT SIDE OF FRAME AT LONGERON 2 LEFT AND 2 RIGHT. REPAIRED PER SRM 53-03 FIGURE 31A.SDR AALA200802712Light · inoperativeSFO SEAT MOUNTED EMERGENCY LIGHT AT SEAT 32D INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR SEAT MOUNTED EMERGENCY LIGHT AT SEAT 32D. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR AALA200802711Wire Harness · damagedSFO EMERGENCY SEAT MOUNTED LIGHTS AT SEAT ROW 29D INOPERATIVE. REPAIRED WIRING AT SEAT ROW 29D FOR EMERGENCY SEAT MOUNTED LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR AALA200800344Battery · looseSFO - EMERGENCY EXIT LIGHTS AT OVERHEAD RIGHT AND LEFT OVERWING EXIT DOORS INOPERATIVE. RESEATED BATTERIES IN BATTERY PACK FOR EMERGENCY EXIT LIGHTS AT OVERHEAD RIGHT AND LEFT OVERWING EXIT DOORS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072360Connector · disconnectedLGA - EMERGENCY LIGHT AT SEAT ROW 12DEF INOPERATIVE. SECURED CONNECTOR FOR EMERGENCY LIGHT AT SEAT ROW 12DEF. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050611Compressor · stalledDFW INFLIGHT DURING CLIMBOUT LEFT HAND ENGINE COMPRESSOR STALLED. ENGINE PRESSURE RATIO WENT BACK TO 1.73. ALL INDICATIONS NORMAL AFTER BRINGING FLIGHT TO IDLE. RETURNED TO DFW AND LANDED WITHOUT INCIDENT. FOUND METAL IN TAILPIPE. REPLACED LEFT HAND ENGISDR AALA20050523Battery Pack · inoperativeLGA - EMERGENCY LIGHT MID BATTERY CHARGER INOPERATIVE. REPLACED BATTERY PACK. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040804Battery Pack · inoperativeSEA - EMERGENCY CEILING LIGHTS AT ROWS 28 AND 29 AFT GALLEY INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY CEILING LIGHTS AT ROWS 28 AND D29 AFT GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040765Battery Pack · inoperativeDFW - EMERGENCY CEILING LIGHT AT ROW 28 AND AT AFT SERVICE DOOR INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY CEILING LIGHT AT ROW 28 AND AT AFT SERVICE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040166Battery Pack · dirtyDFW EMERGENCY CEILING LIGHTS AT ROWS 4, 5 AND 7 ARE INOPERATIVE. CLEANED CONTACTS FOR EMERGENCY CEILING LIGHTS BATTERY PACK B5-100 FOR ROWS 4, 5 AND 7. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20031454Wire · looseFORWARD EMERGENCY PATH AISLE LIGHT IN AFT ACCESSORY RAMP AREA INOPERATIVE. RECONNECTED LOOSE WIRES TO FORWARD EMERGENCY PATH AISLE LIGHT IN AFT ACCESSORY RAMP AREA. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20031453Wire · looseAFT ACCESSORY RAMP AREA EMERGENCY PATH AISLE LIGHT INOPERATIVE. CONNECTED LOOSE WIRES TO AFT ACCESSORY RAMP AREA EMERGENCY PATH AISLE LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20031452Battery Pack · dischargedDFW OVERHEAD EMERGENCY PATH AISLE LIGHTS AFT OF ACCESSORY RAMP AREA INOPERATIVE. REPLACED BATTERY PACK FOR OVERHEAD EMERGENCY PATH AISLE LIGHTS AFT OF ACCESSORY RAMP AREA. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR ZW0A0206904CellTHE FIRST CLASS CABIN EGRESS LIGHTS WERE INOPERATIVE. REPLACED THE BATTERIES IN THE POWER SUPPLY. CHECK-C 6-2-01 STL. --CLOSED--SDR ZW0A0102001Light · inoperativeTHE FORWARD ENTRY DOOR PORTABLE EMERGENCY LIGHT WAS INOPERATIVE. REPLACED THE LIGHT ASSEMBLY. CHECK-C 7-28-00 JFK.SDR TWAA0106303Power Supply · dischargedTHE EGRESS LIGHTS WERE INOPERATIVE IN FIRST CLASS AND AT ROW 12 TO 24, AND THE OVERHEAD EMERGENCY LIGHTS WERE INOPERATIVE AT ROW 15 TO 22. REPLACED LIGHT MODULE P/N 0105606-003 IN FIRST CLASS. FOR THE EGRESS LIGHTS AT ROW 12 TO 24 AND THE OVERHEAD EMERGENCY SDR TWAA0104801Light · disconnectedTHE EGRESS LIGHT WAS EXPOSED AND INOPERATIVE AT ROW 10 AND 17. RE-CONNECTED LIGHT STRIP AT ROW 17 AND REPLACED LIGHT COVER AT ROW 10 DEFERRED CORRECTIONS. THE NEXT STATION REPLACED THE COVER, (P/N 0105601-001), AND RE-CONNECTED THE LIGHT STRIP AT ROW 17. CHSDR TWAA0104102Connector · disconnectedTHE EGRESS LIGHT STRIP AT ROW 15 TO 20, AND ROW 24 TO 28 WERE INOPERATIVE. RECONNECTED EGRESS LIGHT POWER FEEDER TO THE STRIP. CHECK-C 7-28-00 JFK.SDR TWAA0102706Lens · out of positionTHE EGRESS LIGHTING FROM ROW 12 TO 16 WERE INOPERATIVE, AND A RED EGRESS LENS WAS LOCATED WHERE A WHITE LENS WAS REQUIRED. RE-ATTACHED THE EGRESS LIGHT CONNECTOR AT ROW 16, AND INSTALLED A WHITE LENS. CHECK-C 7-28-00 JFK.SDR TWAA0017501Ecu · wornMID CARGO SMOKE DETECTION ACTIVATED, BOTH SYSTEMS. CREW FIRED BOTH FIRE EXTINGUISHING BOTTLES AND MADE AN UNSCHEDULED LANDING AT IND. THERE WAS NO SMOKE OR FIRE. PLACARD MID CARGO SMOKE DETECTION AND FIRE EXTINGUISHING SYSTEMS PER MEL. THE MID CARGO COMPARSDR TWAA9914301Light · inopTHE EGRESS LIGHTS WERE INOPERATIVE AT ROWS 3 TO 8 AND AT ROW 11. THE AFT EMERGENCY PATHWAY LIGHTS AND TWO TAIL CONE LIGHTS WERE INOPERATIVE. REPLACED THE ELBOW ASSEMBLY (P/N 0105614-001), FOR ROWS 3 TO 8. REPLACED THE BULB, (P/N 7732) AT ROW 11 AND REPLACED
Back to N969TW