# Service difficulty reports: N245AA, cancelled Feb 12, 2018

A list on [N245AA, cancelled Feb 12, 2018](https://openairdocs.org/deregistered/N245AA-2018-02-12.md).

Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.

- [SDR AALA200801402](https://openairdocs.org/sdr/AALA200801402.md): Battery Pack · inoperative · May 26, 2008 · N245AA · Doug DC982 · Emergency Lighting
  > LGA - EMERGENCY LIGHT AT MID CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT MID CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)
- [SDR AALA200801401](https://openairdocs.org/sdr/AALA200801401.md): Battery Pack · inoperative · May 26, 2008 · N245AA · Doug DC982 · Emergency Lighting
  > LGA - EMERGENCY LIGHT AT FORWARD CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT FORWARD CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)
- [SDR AALA20072541](https://openairdocs.org/sdr/AALA20072541.md): Battery Pack · inoperative · Dec 28, 2007 · N245AA · Doug DC982 · Emergency Lighting
  > LGA - EMERGENCY LIGHTS AT SEAT ROWS 20DEF TO 22DEF INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT SEAT ROWS 20DEF TO 22DEF. SYSTEM GROUND CHECKED NORMAL OPERATION.
- [SDR AALA20071009](https://openairdocs.org/sdr/AALA20071009.md): Light · missing · Jun 1, 2007 · N245AA · Doug DC982 · Emergency Lighting
  > TPA - EMERGENCY EXIT LIGHT ARROW MISSING AT AFT RIGHT CABIN. REPLACED EMERGENCY EXIT LIGHT ARROW AT AFT RIGHT CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.
- [SDR AALA20070462](https://openairdocs.org/sdr/AALA20070462.md): Gearbox · leaking · Mar 9, 2007 · N245AA · Doug DC982 · Turbine Engine Reduction Gear
  > DFW TO GDL, DURING CRUISE RIGHT ENGINE OIL QUANTITY WENT FROM 12 QUARTS TO 4 QUARTS IN TWO HOURS. OIL PRESSURE AND TEMPERATURE NORMAL. CREW SHUTDOWN RIGHT ENGINE AND LANDED MTY WITHOUT INCIDENT. FOUND NUMBER TWO GEARBOX LEAKING OIL. REPLACED NUMBER TWO GEA
- [SDR AALA20041181](https://openairdocs.org/sdr/AALA20041181.md): Battery Pack · inoperative · Dec 2, 2004 · N245AA · Doug DC982 · Emergency Lighting
  > MSP - OVERHEAD EMERGENCY LIGHT AT ROW 9DEF INOPERATIVE. REPLACED BATTERY PACK FOR OVERHEAD EMERGENCY LIGHT AT ROW 9DEF. SYSTEM GROUND CHECKED NORMAL OPERATION.
- [SDR AALA20040986](https://openairdocs.org/sdr/AALA20040986.md): Battery Pack · inoperative · Sep 23, 2004 · N245AA · Doug DC982 · Emergency Lighting
  > MID CABIN EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACKS AT POSITION AB51 AND AB52 FOR MID CABIN EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.
- [SDR AALA20040854](https://openairdocs.org/sdr/AALA20040854.md): Battery Pack · inoperative · Aug 17, 2004 · N245AA · Doug DC982 · Emergency Lighting
  > EMERGENCY LIGHTS AT SEAT 8 AB AND AFT GALLEY OVERHEAD INOPERATIVE. REPLACED BATTERY PACKS FOR EMERGENCY LIGHTS AT SEAT 8 AB AND AFT GALLEY OVERHEAD. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)
- [SDR AALA20040309](https://openairdocs.org/sdr/AALA20040309.md): Terminal · loose · Mar 4, 2004 · N245AA · Doug DC982 · Light System Wiring
  > SFO - EMERGENCY LIGHT AT SEATS 23D AND 26D INOPERATIVE. FOUND LOOSE TERMINAL LUG AT BATTERY PACK. TIGHTENED TERMINAL LUG AT BATTERY PACK FOR EMERGENCY LIGHTS AT 23D AND 26D. SYSTEM GROUND CHECKED NORMAL OPERATION.
- [SDR AALA20030486](https://openairdocs.org/sdr/AALA20030486.md): A/C Pack · dirty · Apr 22, 2003 · N245AA · Doug DC982 · Cabin Cooling System
  > ORD - FLT 386 - EN ROUTE ORD-LGA, A THICK HAZE/SMOKE IN CABIN AND COCKPIT WAS NOTED. PASSENGERS COMPLAINED ABOUT BEING ILL FROM SMOKE, RAN CHECKLIST. RETURNED ORD AND LANDED WITHOUT INCIDENT. ACCOMPLISHED PACK BURN OUT, TEST NORMAL DURING CHECK. SYSTEM GRO
- [SDR AALA20030406](https://openairdocs.org/sdr/AALA20030406.md): Relief Valve · defective · Apr 3, 2003 · N245AA · Doug DC982 · Pressure Regulator/Outflow Valve
  > DFW - FLT 1713 - EN ROUTE PHL-DFW, LEFT PACK QUIT AT 31,000. COULD NOT HOLD CABIN PRESSURE OR FIX PROBLEM WITH CHECKLIST. DID EMERGENCY DESCENT, DEPLOYED 02 MASKS. LANDED DFW WITHOUT INCIDENT. REPLACED FORWARD OVER-PRESSURE RELIEF VALVE. ACCOMPLISHED LEAK
- [SDR AALA20030279](https://openairdocs.org/sdr/AALA20030279.md): Frame · cracked · Feb 27, 2003 · N245AA · Doug DC982 · Fuselage Main, Frame
  > TUL - FOUND FRAME WEB IS CRACKED AT STATION 1463, RIGHT SIDE, INBOARD EDGE, APPROX 1:30 POSITION. INSTALLED DOUBLER ON FRAME WEB PER SRM 51-70-04 FIG 2 SH 2. (M)
- [SDR AALA20020884](https://openairdocs.org/sdr/AALA20020884.md): Contactor · dirty · Jun 16, 2002 · N245AA · Doug DC982 · Emergency Lighting
  > DFW - FOUND DURING MAINTENANCE, OVERHEAD EMERGENCY EXIT LIGHTS AT ROW 23-26 DIM. CLEANED EMERGENCY EXIT LIGHT BATTERY CONTACTORS. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)
- [SDR AALA20020763](https://openairdocs.org/sdr/AALA20020763.md): Connecting Rod · disconnected · May 28, 2002 · N245AA · Doug DC982 · Emergency Lighting
  > DURING OVERNIGHT MAINTENANCE FLOOR LEVEL FORWARD GALLEY OUTBOARD EMERGENCY EXIT LIGHTS INOPERATIVE. RECONNECTED EMERGENCY EXIT LIGHT CONNECTOR FOR FLOOR LEVEL FORWARD GALLEY LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.
- [SDR AALA20020367](https://openairdocs.org/sdr/AALA20020367.md): Light · broken · Mar 27, 2002 · N245AA · Doug DC982 · Emergency Lighting
  > DFW - DURING OVERNIGHT MAINTENANCE, AFT STAIRWAY EMERGENCY EXIT FLOODLIGHT BROKEN. REPLACED AFT STAIRWAY EMERGENCY EXIT FLOODLIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION. 9M)
- [SDR AALA20011450](https://openairdocs.org/sdr/AALA20011450.md): Terminal · inoperative · Jul 19, 2001 · N245AA · Doug DC982 · Emergency Lighting
  > DFW - DURING OVERNIGHT MAINTENANCE, FIRST CLASS OVERHEAD EMERGENCY EXIT ESCAPE PATH LIGHTING INOPERATIVE. REPLACED TERMINAL ON BATTERY PACK TO FIRST CLASS EMERGENCY EXIT LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)
- [SDR AALA991202](https://openairdocs.org/sdr/AALA991202.md): Light · broken · Aug 18, 1999 · N245AA · Doug DC982 · Emergency Lighting
  > DFW - FLT 521 - AFTER ARRIVAL DFW FROM MCI, EMERGENCY EXIT FLOOR PATH LIGHT STRIP AT SEAT 21D BROKEN. REPLACED EMERGENCY EXIT FLOOR PATH LIGHT STRIP AT SEAT 21D. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)
- [SDR AALA991000](https://openairdocs.org/sdr/AALA991000.md): Wire · broken · Jul 7, 1999 · N245AA · Doug DC982 · Light System Wiring
  > DFW - DURING OVERNIGHT MAINTENANCE, GALLEY EMERGENCY EXIT SIGN INOPERATIVE. REPAIRED WIRE ON GALLEY EMERGENCY EXIT SIGN. SYSTEM GROUND CHECKED, NORMAL OPERATION. (X)
- [SDR AALA971850](https://openairdocs.org/sdr/AALA971850.md): Air Distribution · odor · Sep 29, 1997 · N245AA · Doug DC982 · Air Distribution System
  > DTW - FLT 1589 - EN ROUTE PIT/DFW DURING CRUISE, NOXIOUS FUMES NOTED THORUGHOUT AIRCRAFT BELIEVED TO BE FROM SPRAY LUBRICANT USED ON FIRST CLASS CABIN COAT CLOSET DOOR. AIRCRAFT DIVERTED TO DTW AND LANDED WITHOUT INCIDENT. CLEANED LUBRICANT RESIDUE FROM FIRS
- [SDR AALA970890](https://openairdocs.org/sdr/AALA970890.md): Actuator · leaking · May 10, 1997 · N245AA · Doug DC982 · Entrance Stairs
  > LAX - FLT 473 - EN ROUTE ORD/LAX, DURING CRUISE, RT HYDRAULIC QTY INDICATED 2 QTS AND RT PRESS INDICATED 1500 PSI WITH ENG PUMP IN LOW. ACCOMP ABNORMAL PROCEDURE FOR RT HYD SYSTEM AND DURING THIS TIME, PRESSURE DROPPED TO ZERO WITH QTY REMAINING AT 2 QTS. A/
- [SDR AALA960177](https://openairdocs.org/sdr/AALA960177.md): Flat Conductor · defective · Feb 4, 1996 · N245AA · Doug DC982 · Emergency Lighting
  > SFO - DURING OVERNIGHT CHECK, EMERGENCY FLOOR LIGHT NEXT TO FIRST CLASS LAVATORY FOUND INOPERATIVE. REPLACED EMERGENCY FLOOR LIGHT FLAT CONDUCTOR BY FIRST CLASS LAVATORY. SYSTEM GROUND CHECKED, NORMAL OPERATION. (X)

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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 = 'N245AA' AND deregistration_id = 'N245AA-2018-02-12'
ORDER BY difficulty_date DESC
```

This list as a web page: https://openairdocs.org/deregistered/N245AA-2018-02-12/reports

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.
