# Service difficulty reports: N219AA, cancelled Jan 2, 2018

A list on [N219AA, cancelled Jan 2, 2018](https://openairdocs.org/deregistered/N219AA-2018-01-02.md).

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

- [SDR AALA2009010600270](https://openairdocs.org/sdr/AALA2009010600270.md): Battery Pack · discharged · Jan 6, 2009 · N219AA · Doug DC982 · Emergency Lighting
  > LGA- EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK.
- [SDR AALA20061173](https://openairdocs.org/sdr/AALA20061173.md): Battery Pack · inoperative · Dec 5, 2006 · N219AA · Doug DC982 · Emergency Lighting
  > LGA - EMERGENCY LIGHTS AT FORWARD CABIN DIM. REPLACED BATTERY PACK AT FORWARD ROW 20 FOR EMERGENCY LIGHTS IN FORWARD CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.
- [SDR AALA20061172](https://openairdocs.org/sdr/AALA20061172.md): Battery Pack · inoperative · Dec 5, 2006 · N219AA · Doug DC982 · Emergency Lighting
  > LGA - EMERGENCY LIGHTS IN AFT CABIN DIM. REPLACED BATTERY PACK AT SEAT ROW 28 FOR EMERGENCY LIGHTS IN AFT CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.
- [SDR AALA20050735](https://openairdocs.org/sdr/AALA20050735.md): Battery Pack · inoperative · Nov 11, 2005 · N219AA · Doug DC982 · Emergency Lighting
  > LGA - FOUND CEILING EMERGENCY EXIT LIGHTS ABOVE AFT STAIRS INOPERATIVE. FOUND AND REPAIRED BROKEN WIRE AT S3156. REPLACED BATTERY PACK AS PRECAUTION. SYSTEM GROUND CHECKED NORMAL OPERATION.
- [SDR AALA20050097](https://openairdocs.org/sdr/AALA20050097.md): Light · inoperative · Feb 7, 2005 · N219AA · Doug DC982 · Emergency Lighting
  > DFW - SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT AT SEAT 22D INOPERATIVE. REPLACED THE SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT ASSEMBLY AT SEAT 22D. SYSTEM GROUND CHECKED NORMAL OPERATION.
- [SDR AALA20040323](https://openairdocs.org/sdr/AALA20040323.md): Battery Pack · inoperative · Mar 6, 2004 · N219AA · Doug DC982 · Emergency Lighting
  > ORD - EMERGENCY CEILING LIGHTS BETWEEN ROWS 28 AND 30 INOPERATIVE. REPLACED BATTERY PACK AT B5-107 FOR EMERGENCY CEILING LIGHTS BETWEEN ROWS 28 AND 30. SYSTEM GROUND CHECKED NORMAL OPERATION.
- [SDR AALA20030962](https://openairdocs.org/sdr/AALA20030962.md): Battery Pack · discharged · Sep 4, 2003 · N219AA · Doug DC982 · Emergency Lighting
  > DFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT LIGHTS WERE INOPERATIVE AT ROWS 7 THROUGH 12. REPLACED BATTERY PACK B5-101. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)
- [SDR AALA20021438](https://openairdocs.org/sdr/AALA20021438.md): Skin · cracked · Oct 8, 2002 · N219AA · Doug DC982 · Fuselage Main, Plate/Skin
  > TUL - FOUND FUSELAGE SKIN CRACKED STATION 1380 ABOVE LONGERON 14R. INSTALLED DOUBLER PER SRM 53-01 AND AARD 53-30-00-02 REVISION 8/30/02. (M)
- [SDR AALA20021112](https://openairdocs.org/sdr/AALA20021112.md): Wire · loose · Jul 29, 2002 · N219AA · Doug DC982 · Light System Wiring
  > DFW - DURING OVERNIGHT MAINTENANCE, LEFT AISLE CEILING EMERGENCY EXIT FLOOD LIGHT DIM AT ROW 23. TIGHTENED SCREW ON GROUND WIRE FOR LEFT AISLE CEILING EMERGENCY EXIT FLOOR LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)
- [SDR AALA971336](https://openairdocs.org/sdr/AALA971336.md): Connector · broken · Jul 28, 1997 · N219AA · Doug DC982 · Emergency Lighting
  > DFW - DURING OVERNIGHT CHECK, EMERGENCY FLOOR LIGHT BY PAX SEAT ROW 6 INOPERATIVE. REPLACED BROKEN EMERGENCY FLOOR LIGHT STRIP CONNECTOR BY PAX SEAT ROW 6. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)
- [SDR AALA971312](https://openairdocs.org/sdr/AALA971312.md): Sensor · out of adjust · Jul 23, 1997 · N219AA · Doug DC982 · Landing Gear Position and Warning
  > ORD - FLT 1912 - EN ROUTE TUL/ORD DURING CRUISE, NOSE LANDING GEAR RED LIGHT ILLUMINATED INTERMITTENTLY WITH GEAR HANDLE UP. NO OTHER ABNORMAL INDICATIONS AND AIRCRAFT PROCEEDED TO ORD LANDING WITHOUT INCIDENT. UNABLE TO DUPLICATE FAULT ON GROUND. LANDING G
- [SDR AALA971311](https://openairdocs.org/sdr/AALA971311.md): Retract Mech · lack of lube · Jul 23, 1997 · N219AA · Doug DC982 · Landing Gear Retraction/Extension System
  > ORD - FLT 0305 - AFTER TAKEOFF LGA DURING CLIMB-OUT AND AGAIN DURING DESCENT INTO ORD, RED NOSE LANDING GEAR LIGHT ILLUMINATED BRIEFLY. NO OTHER ABNORMAL INDICATIONS AND AIRCRAFT LANDED ORD WITHOUT INCIDENT. CHECKED NLG WITH NO DEFECTS FOUND. CHECKED PROXIMI
- [SDR AALA970215](https://openairdocs.org/sdr/AALA970215.md): Strut · req'd service · Jan 27, 1997 · N219AA · Doug DC982 · Nose/Tail Landing Gear Strut/Axle
  > DFW - FLT 1796 - AFTER TAKEOFF DEN, NECESSARY TO USE OVERRIDE BUTTON TO MOVE LANDING GEAR LEVER OUT OF THE DOWN POSITION. LANDING GEAR RETRACTED AND AIRCRAFT PROCEEDED TO DFW, LANDING WITHOUT INCIDENT. CHECKED LANDING GEAR LEVER INTERLOCK RELEASE MECHANISM A
- [SDR AALA961834](https://openairdocs.org/sdr/AALA961834.md): Cusp · corroded · Dec 12, 1996 · N219AA · Doug DC982 · Fuselage Miscellaneous Structure
  > TUL - FOUND CORROSION TWO AREAS ON BOTTOM SURFACE OF CUSP. REPAIRED PER ESO 80559, DATED 12-12-96. (M)
- [SDR AALA961835](https://openairdocs.org/sdr/AALA961835.md): Frame · corroded · Dec 10, 1996 · N219AA · Doug DC982 · Fuselage Main, Frame
  > TUL - FOUND FRAME CORRODED BEYOND LIMITS. REPAIRED IAW SRM 53-10-00-14 NR 1 PAGE 2. (M)
- [SDR AALA961077](https://openairdocs.org/sdr/AALA961077.md): Clamp · disconnected · Jul 13, 1996 · N219AA · Doug DC982 · Cabin Cooling System
  > DEN - FLT 615 - WHILE EN ROUTE SLC TO ORD AT 31,000 FEET, THE FLIGHT ATTENDANTS REPORTED A BURNING SMELL IN BOTH AFT LAVATORIES. PULLED CIRCUIT BREAKERS TO LOCATE SOURCE WITH NO AVAIL. THEN SAW SMOKE IN THE RIGHT AFT LAVATORY. AIRCRAFT DIVERTED TO DEN. AT
- [SDR AALA960564](https://openairdocs.org/sdr/AALA960564.md): Connector · loose · Apr 6, 1996 · N219AA · Doug DC982 · Emergency Lighting
  > DFW - DURING OVERNIGHT CHECK, EMERGENCY FLOOR LIGHTS BY FORWARD GALLEY FOUND INOPERATIVE. RESECURED LOOSE EMERGENCY FLOOR LIGHT STRIP CONNECTOR BY FORWARD GALLEY. SYSTEM GROUND CHECKED, NORMAL OPERATION. (X)
- [SDR AALA950746](https://openairdocs.org/sdr/AALA950746.md): Eel Wire · corroded · Apr 26, 1995 · N219AA · Doug DC982 · Emergency Lighting
  > DFW - DURING OVERNIGHT CHECK, EMERGENCY FLOOR LIGHTS IN FIRST CLASS CABIN FOUND INOPERATIVE. REPAIRED EMERGENCY FLOOR LIGHT WIRING IN FIRST CLASS CABIN FOUND CORRODED. 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 = 'N219AA' AND deregistration_id = 'N219AA-2018-01-02'
ORDER BY difficulty_date DESC
```

This list as a web page: https://openairdocs.org/deregistered/N219AA-2018-01-02/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.
