N797AN

Service difficulty reports · 267

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 = 'N797AN' 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.

SDR AALA20070963Lens · brokenJFK - EMERGENCY LIGHT AT SEAT 20C BROKEN. REPLACED LENS AND LAMP FOR EMERGENCY LIGHT AT SEAT ROW 20C. SYSTEM GROUND CHECKED NORMAL OPERATION.May 28, 2007 · N797AN · Boeing 777223 · Emergency LightingSDR AALA20070250Lens · missingDFW - FOUND EMERGENCY LIGHT AT SEAT 25C HAS MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 25C SYSTEM GROUND CHECKED NORMAL OPERATION.Feb 2, 2007 · N797AN · Boeing 777223 · Emergency LightingSDR AALA20070042Lens · missingDFW - EMERGENCY LIGHT AT FORWARD GALLEY RIGHT EXIT MARKER MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT FORWARD GALLEY RIGHT EXIT MARKER. SYSTEM GROUND CHECKED NORMAL OPERATION.Jan 9, 2007 · N797AN · Boeing 777223 · Emergency LightingSDR AALA20070041Lens · missingDFW - EMERGENCY LIGHT AT FORWARD GALLEY LEFT EXIT MARKER MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT FORWARD GALLEY LEFT EXIT MARKER. SYSTEM GROUND CHECKED NORMAL OPERATION.Jan 9, 2007 · N797AN · Boeing 777223 · Emergency LightingSDR AALA20060847Light · looseNRT - EMERGENCY LIGHT AT FIRST CLASS CLOSET LOOSE. SECURED EMERGENCY LIGHT IN FIRST CLASS CLOSET. SYSTEM GROUND CHECKED NORMAL OPERATION.Oct 10, 2006 · N797AN · Boeing 777223 · Emergency LightingSDR AALA20060755Lens · missingNRT - EMERGENCY LIGHT LENS AT FIRST CLASS CLOSET MISSING. INSTALLED EMERGENCY LIGHT LENS AT FIRST CLASS COAT CLOSET. SYSTEM GROUND CHECKED NORMAL OPERATION.Sep 29, 2006 · N797AN · Boeing 777223 · Emergency LightingSDR AALA20060535Socket · crackedORD - EMERGENCY LIGHT SOCKET AT FORWARD DOGHOUSE FORWARD GALLEY CRACKED. REPLACED FORWARD DOGHOUSE EMERGENCY LIGHT ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION.Aug 9, 2006 · N797AN · Boeing 777223 · Emergency LightingSDR AALA20060807Battery Pack · dischargedAFW - EMERGENCY LIGHTS FROM BUSINESS CLASS TO FIRST CLASS INCLUDING LEFT AND RIGHT NUMBER ONE AND TWO EXIT DOOR SIGNS FAILED FUNCTIONAL TEST. REPLACED BATTERIES AND CHARGERS FOR EMERGENCY LIGHTS FROM BUSINESS CLASS TO FIRST CLASS INCLUDING LEFT AND RIGHT HANDJun 29, 2006 · N797AN · Boeing 777223 · Emergency LightingSDR AALA20041162Battery Pack · inoperativeDFW - AFT CABIN SEAT MOUNTED EMERGENCY LIGHTS AT R3 INOPERATIVE. REPLACED BATTERY PACK FOR AFT CABIN SEAT MOUNTED EMERGENCY LIGHTS AT R3. SYSTEM GROUND CHECKED NORMAL OPERATION.Nov 23, 2004 · N797AN · Boeing 777223 · Emergency LightingSDR AALA20041163Battery Pack · inoperativeDFW - OVERHEAD EMERGENCY LIGHTS IN FIRST CLASS INOPERATIVE. REPLACED BATTERY PACK AT L1 FOR OVERHEAD EMERGENCY LIGHTS IN FIRST CLASS. SYSTEM GROUND CHECKED NORMAL OPERATION.Nov 23, 2004 · N797AN · Boeing 777223 · Emergency LightingSDR AALA20041051Battery Pack · inoperativeLAX - EMERGENCY ESCAPE PATH LIGHT AT ROWS 30 TO 44CEF INOPERATIVE. REPAIRED FAULTY WIRING AT CONNECTOR D3204J AND REPLACED BATTERY PACKS AT POSITIONS M33406 AND M33404 FOR EMERGENCY ESCAPE PATH LIGHTING AT ROWS 30 TO 44CEF. SYSTEM GROUND CHECKED NORMAL OPERAOct 15, 2004 · N797AN · Boeing 777223 · Emergency LightingSDR AALA20040958Battery Pack · inoperativeJFK - SEAT MOUNTED EMERGENCY LIGHTS ON SEATS 30 THROUGH 44 CENTER AISLE INOPERATIVE. REPLACED BATTERY PACK M33401 FOR SEAT MOUNTED EMERGENCY LIGHTS ON SEATS 30 THROUGH 44 CENTER AISLE. SYSTEM GROUND CHECKED NORMAL OPERATION.Sep 13, 2004 · N797AN · Boeing 777223 · Emergency LightingSDR AALA20040303Battery Pack · dischargedDFW - EMERGENCY ESCAPE PATH AISLE LIGHTING AT 3R DOOR BATTERY LOW. REPLACED BATTERY PACK FOR EMERGENCY ESCAPE PATH AISLE LIGHTING AT 3R DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.Mar 2, 2004 · N797AN · Boeing 777223 · Emergency LightingSDR AALA20030543Light · brokenDFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT LIGHT ON COAT CLOSET NEXT TO L1 DOOR BROKEN. REPLACED EMERGENCY EXIT LIGHT ON COAT CLOSET. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)May 6, 2003 · N797AN · Boeing 777223 · Emergency LightingSDR AALA20021843Module · inoperativeDFW - DURING OVERNIGHT MAINTENANCE, SEAT MOUNTED EMERGENCY EXIT LIGHTS IN COACH INOPERATIVE. REPLACED EMERGENCY EXIT LIGHT POWER PACK MODULE SYSTEM. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)Dec 18, 2002 · N797AN · Boeing 777223 · Emergency LightingSDR AALA20021296Idg · failedGRU - ON TAKEOFF AFTER FLAP RETRACTION, GOT ELEC GEN OFF R EICAS MESSAGE. RIGHT ENGINE GENERATOR PLACARDED INOPERATIVE AS PER MEL, MPM 24-3 ACCOMPLISHED, SERVICED BOTH IDG/S OIL LEVEL AS WELL APU, PLACARDED AND MIC ENTERED. ENGINES FAN COWLS CLOSED LATCHED OSep 4, 2002 · N797AN · Boeing 777223 · AC Generator-AlternatorSDR AALA20020567Wire · brokenMIA - DURING OVERNIGHT MAINTENANCE, FOUND EMERGENCY ESCAPE PATH LIGHTING AT SEAT 40C INOPERATIVE. REPAIRED BROKEN WIRE TO EMERGENCY ESCAPE PATH LIGHTING ON SEAT 40C. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)Apr 25, 2002 · N797AN · Boeing 777223 · Light System Wiring
Back to N797AN