# Service difficulty reports: N291AA, cancelled Jan 14, 2015 A list on [N291AA, cancelled Jan 14, 2015](https://openairdocs.org/deregistered/N291AA-2015-01-14.md). Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first. Page 1 of 2 · 58 reports - [SDR AALA20100930DFW01](https://openairdocs.org/sdr/AALA20100930DFW01.md): Hydraulic System · low · Sep 30, 2010 · N291AA · Doug DC982 · Hydraulic System, Main > DFW - CREW REPORTED ON DESCENT LEFT HYDRAULIC QUANTITY DECREASED. EMERGENCY DECLARED LANDED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. SERVICED LEFT AND RIGHT HYDRAULIC SYSTEMS PER MM 12-13-01-3. SYSTEM GROUND CHECK NORMAL OPERATION. - [SDR AALA20090705EWR01](https://openairdocs.org/sdr/AALA20090705EWR01.md): Seal · failed · Jul 5, 2009 · N291AA · Doug DC982 · Nose/Tail Landing Gear Strut/Axle > DFW - AIRCRAFT UNABLE TO RETRACT NOSE LANDING GEAR. EMERGENCY DECLARED, RETURNED TO DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND METERING TUBE BAD AND NOSE STRUT FLAT. REPLACED NOSE LANDING GEAR SHOCK STRUT SEALS. SYSTEM GROUND CHECK NORMAL - [SDR AALA20090413TUL02](https://openairdocs.org/sdr/AALA20090413TUL02.md): Casting · cracked · Apr 9, 2009 · N291AA · Doug DC982 · Drag Control Actuator > RIGHT GROUND SPOILER ACTUATOR ATTACH FITTING CASTING IN TRAILING EDGE OF WING IS CRACKED IN RADIUS AT FORWARD OUTBOARD CORNER. INSTALLED NEW GROUND SPOILER CASTING PER SRM 51-30-00. - [SDR AALA20090413TUL01](https://openairdocs.org/sdr/AALA20090413TUL01.md): Casting · cracked · Apr 9, 2009 · N291AA · Doug DC982 · Fuselage Main, Attach Fittings > LEFT WHEEL WELL GEAR DOOR ACTUATOR UPPER CASTING IS CRACKED. STOP DRILLED CRACK AND INSTALLED DOUBLER PER AARD 53-10-00-38 REPAIR 38 AND ESO 80559 DATED 04/08/09. - [SDR AALA20090415TUL02](https://openairdocs.org/sdr/AALA20090415TUL02.md): Longeron · cracked · Apr 8, 2009 · N291AA · Doug DC982 · Fuselage Main, Longeron/Stringer > CRACK IN AFT END OF LONGERON 2R AT STATION 1418. REPAIRED PER AARD 53-30-00-2. - [SDR AALA2009021201024](https://openairdocs.org/sdr/AALA2009021201024.md): Apu · leaking · Feb 12, 2009 · N291AA · Doug DC982 · APU Oil System > DFW - INFLIGHT DFW-JAX - CREW REPORTED SMOKE VISIBLE IN THE BACK OF THE CABIN AFTER TAKEOFF. EMERGENCY DECLARED, LANDED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED APU DUE TO OIL LEAK. SYSTEM GROUND CHECK NORMAL OPERATION. - [SDR AALA2009012900247](https://openairdocs.org/sdr/AALA2009012900247.md): Actuator · failed · Jan 29, 2009 · N291AA · Doug DC982 · Landing Gear Actuator > JFK - INFLIGHT BWI TO DFW. AFTER TAKEOFF NOSE GEAR WOULD NOT RETRACT. LANDED JFK WITHOUT INCIDENT. REPLACED NOSE LANDING GEAR RETRACT ACTUATOR AND NOSE GEAR SHOCK SEAL. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA200802348](https://openairdocs.org/sdr/AALA200802348.md): Coalescer Bag · dirty · Oct 17, 2008 · N291AA · Doug DC982 · Humidity Control System > ATL INFLIGHT - DURING CLIMB-OUT BETWEEN 4000 AND 10000 FEET, FLIGHT ATTENDANT REPORTED WHITE SMOKE IN CABIN. ACCOMPLISHED CABIN SMOKE AND FIRE CHECKLIST AND SMOKE BEGAN TO DISSIPATE. RETURNED TO ATL AND LANDED WITHOUT INCIDENT. ACCOMPLISHED BURN OUT OF HIGH - [SDR AALA200801731](https://openairdocs.org/sdr/AALA200801731.md): Shroud · damaged · Jun 29, 2008 · N291AA · Doug DC982 · Emergency Lighting > DFW - EMERGENCY LIGHT AT SEAT 18D HAS DAMAGED SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT 18D. SYSTEM GROUND CHECKED NORMAL OPERATION. (S) - [SDR AALA200801179](https://openairdocs.org/sdr/AALA200801179.md): Relay · inoperative · May 2, 2008 · N291AA · Doug DC982 · Landing Gear Retraction/Extension System > LAX INFLIGHT T1716/02MAY - NOSE GEAR WOULD NOT RETRACT. NOSE GEAR UNSAFE INDICATION AFTER TAKEOFF AND CREW REPORTED NOISE. RETURNED TO LAX AND LANDED WITHOUT INCIDENT. REPLACED NOSE LANDING GEAR INTERIOR RELAY R 262. SYSTEM GROUND CHECKED NORMAL OPERATION - [SDR AALA20072506](https://openairdocs.org/sdr/AALA20072506.md): Battery Pack · dislodged · Dec 22, 2007 · N291AA · Doug DC982 · Emergency Lighting > LGA - EMERGENCY LIGHT AT EXTERIOR RIGHT INOPERATIVE. RESEATED BATTERY PACK FOR EMERGENCY LIGHT AT EXTERIOR RIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20072508](https://openairdocs.org/sdr/AALA20072508.md): Lens · broken · Dec 22, 2007 · N291AA · Doug DC982 · Emergency Lighting > LGA - EMERGENCY LIGHT AT SEAT 29D LENS BROKEN. REPLACED LENS ASSEMBLY FOR EMERGENCY LIGHT AT SEAT 29D. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20072507](https://openairdocs.org/sdr/AALA20072507.md): Battery Pack · dislodged · Dec 22, 2007 · N291AA · Doug DC982 · Emergency Lighting > LGA - EMERGENCY LIGHT AT EXTERIOR LEFT INOPERATIVE. RESEATED BATTERY PACK FOR EMERGENCY LIGHT AT EXTERIOR LEFT. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20070502](https://openairdocs.org/sdr/AALA20070502.md): Handle · pulled · Mar 15, 2007 · N291AA · Doug DC982 · Landing Gear Retraction/Extension System > MCO - LANDING GEAR WOULD NOT RETRACT. RETURNED TO MCO AND LANDED WITHOUT INCIDENT. FOUND MAIN LANDING GEAR DOOR BYPASS LEVER PULLED. STOWED HANDLE. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20060493](https://openairdocs.org/sdr/AALA20060493.md): Light · broken · Jul 24, 2006 · N291AA · Doug DC982 · Emergency Lighting > DFW - EMERGENCY ESCAPE PATH LIGHTING IN SEAT 10D BROKEN. REPLACED EMERGENCY ESCAPE PATH LIGHT ON SEAT 10D. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20041117](https://openairdocs.org/sdr/AALA20041117.md): Battery Pack · inoperative · Nov 10, 2004 · N291AA · Doug DC982 · Emergency Lighting > DFW - OVERHEAD EMERGENCY LIGHTS BETWEEN ROWS 23 AND 26 INOPERATIVE. REPLACED BATTERY PACK FOR OVERHEAD EMERGENCY LIGHTS BETWEEN ROWS 23 AND 26. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20040532](https://openairdocs.org/sdr/AALA20040532.md): Wire · broken · May 5, 2004 · N291AA · Doug DC982 · Emergency Lighting > ORD EMERGENCY FLOOR LIGHTING FLICKERING IN AFT CABIN. REPAIRED BROKEN WIRE IN AFT FUSELAGE AREA. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED) - [SDR AALA20040493](https://openairdocs.org/sdr/AALA20040493.md): Battery Pack · inoperative · Apr 27, 2004 · N291AA · Doug DC982 · Emergency Lighting > IAD - SEAT MOUNTED EMERGENCY LIGHTS FROM SEAT ROW 20 BACK TO REAR OF AIRCRAFT INOPERATIVE. REPLACED BATTERY PACKS FOR SEAT MOUNTED EMERGENCY LIGHTS FROM SEAT ROW 20 TO REAR OF AIRCRAFT. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20040487](https://openairdocs.org/sdr/AALA20040487.md): Module · inoperative · Apr 25, 2004 · N291AA · Doug DC982 · Emergency Lighting > DFW - SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHTS FOR AFT HALF OF COACH CABIN INOPERATIVE. REPLACED FORWARD BATTERY (DME CORP P4010049) AND AFT MODULE ASSEMBLY FOR SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHTS FOR AFT HALF OF COACH CABIN. SYSTEM GROUND CHECKED NOR - [SDR AALA20040431](https://openairdocs.org/sdr/AALA20040431.md): Wire · shorted · Apr 5, 2004 · N291AA · Doug DC982 · Light System Wiring > DFW - SEAT MOUNTED EMERGENCY LIGHTS AT ROWS 21 THROUGH 31 AND TAIL CONE SIDEWALL EMERGENCY LIGHTS INOPERATIVE. FOUND WIRES IN TAIL COMPARTMENT SHORTED. REPAIRED WIRES FOR SEAT MOUNTED EMERGENCY LIGHTS AT ROWS 21 THROUGH 31 AND TAIL CONE SIDEWALL EMERGENCY LI - [SDR AALA20040366](https://openairdocs.org/sdr/AALA20040366.md): Battery Pack · inoperative · Mar 20, 2004 · N291AA · Doug DC982 · Emergency Lighting > DFW - SEAT EMERGENCY ESCAPE PATH LIGHTS FROM ROW 20 AFT ARE INOPERATIVE. REPLACED TRACK LIGHT BATTERY PACK IN AFT GALLEY FOR IN SEAT EMERGENCY ESCAPE PATH LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20040322](https://openairdocs.org/sdr/AALA20040322.md): Battery Pack · inoperative · Mar 6, 2004 · N291AA · Doug DC982 · Emergency Lighting > BOTH AFT ACCESSORY WALL EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK ABOVE MID GALLEY FOR AFT ACCESSORY WALL EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20031471](https://openairdocs.org/sdr/AALA20031471.md): Wire · chafed · Dec 25, 2003 · N291AA · Doug DC982 · Light System Wiring > DFW SEAT MOUNTED EMERGENCY LIGHTS INOPERATIVE AT ROWS 20 TO 31. REPAIRED CHAFFED WIRE ON EMERGENCY LIGHTING FOR SEAT ROWS 20 TO 31. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20031470](https://openairdocs.org/sdr/AALA20031470.md): Battery Pack · discharged · Dec 25, 2003 · N291AA · Doug DC982 · Emergency Lighting > DFW OVERHEAD EMERGENCY LIGHT INOPERATIVE AT ROWS 23 TO 27. REPLACED BATTERY PACK FOR EMERGENCY LIGHTING AT SEAT ROWS 23 TO 27. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20031449](https://openairdocs.org/sdr/AALA20031449.md): Light · faulty · Dec 19, 2003 · N291AA · Doug DC982 · Emergency Lighting > FORWARD FLIGHT ATTENDANT EMERGENCY LIGHT WILL NOT EXTINGUISH WITH SWITCH IN OFF POSITION. REPLACED FORWARD FLIGHT ATTENDANT EMERGENCY LIGHT ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION.--CLOSED-- - [SDR AALA20030780](https://openairdocs.org/sdr/AALA20030780.md): Socket · inoperative · Jul 1, 2003 · N291AA · Doug DC982 · Emergency Lighting > DFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT LIGHT AT SEAT 14D INOPERATIVE. REPLACED EMERGENCY EXIT LIGHT SOCKET AT SEAT 14D. SYSTEM GROUND CHECKED NORMAL OPERATION. (M) - [SDR AALA20030387](https://openairdocs.org/sdr/AALA20030387.md): Contactor · inoperative · Mar 30, 2003 · N291AA · Doug DC982 · Light System Wiring > DFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT LIGHT BETWEEN AFT LAVATORIES INOPERATIVE. CLEANED BATTERY CONTACTS. SYSTEM GROUND CHECKED NORMAL OPERATION. (M) - [SDR AALA20030183](https://openairdocs.org/sdr/AALA20030183.md): Battery · not seated · Feb 9, 2003 · N291AA · Doug DC982 · Emergency Lighting > DFW - FOUND DURING OVERNIGHT MAINTENANCE, AFT CABIN AND FORWARD TAIL CONE SLIDE EMERGENCY EXIT LIGHT INOPERATIVE. RESEATED SLIDE EMERGENCY EXIT LIGHT BATTERY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M) - [SDR AALA20021437](https://openairdocs.org/sdr/AALA20021437.md): Shear Tie · cracked · Oct 8, 2002 · N291AA · Doug DC982 · Fuselage Main, Structure > TUL - FOUND SHEAR TIE CRACKED AFT SIDE OF FS 1451 FRAME AFT OF LONGERON 2R. REMOVED AND REPLACED CRACKED SHEAR TIE AT 2R AND 1451 PER SRM 53-01. (M) - [SDR AALA20021436](https://openairdocs.org/sdr/AALA20021436.md): Skin · cracked · Oct 8, 2002 · N291AA · Doug DC982 · Fuselage Main, Plate/Skin > TUL - FOUND FUSELAGE SKIN CRACKED AT FASTENER STATION 1380 LONGERON 14L RT. STOP DRILLED CRACK AND INSTALLED DOUBLER PER SRM 53-01-00. (M) - [SDR AALA20021435](https://openairdocs.org/sdr/AALA20021435.md): Skin · cracked · Oct 8, 2002 · N291AA · Doug DC982 · Fuselage Main, Plate/Skin > TUL - FOUND FUSELAGE SKIN CRACKED JUST ABOVE SKIN LAP AT STATION 1380 AT L11L LONGERON APPROX.25 INCH LONG CRACK. INSTALLED DOUBLER AFTER STOP DRILL OF CRACK PER SRM 53-01-00 AND AARD 53-30-00-02. (M) - [SDR AALA20020890](https://openairdocs.org/sdr/AALA20020890.md): Light · defective · Jun 12, 2002 · N291AA · Doug DC982 · Emergency Lighting > DFW - DURING OVERNIGHT MAINTENANCE, FOUND L1 ENTRY DOOR EMERGENCY EXIT CEILING LIGHT DIM. REPLACED L1 ENTRY DOOR EMERGENCY EXIT LIGHT ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M) - [SDR AALA20020547](https://openairdocs.org/sdr/AALA20020547.md): Wire · loose · Apr 25, 2002 · N291AA · Doug DC982 · Light System Wiring > DFW - DURING OVERNIGHT MAINTENANCE, TAIL CONE EMERGENCY EXIT LIGHT INOPERATIVE. TIGHTENED EMERGENCY EXIT LIGHT WIRE ON BATTERY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M) - [SDR AALA20020009](https://openairdocs.org/sdr/AALA20020009.md): Wire · broken · Jan 6, 2002 · N291AA · Doug DC982 · Light System Wiring > DFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT LIGHT INOPERATIVE. REPAIRED EMERGENCY EXIT LIGHT WIRES AT SIDE WALL. SYSTEM GROUND CHECK NORMAL OPERATION. (M) - [SDR AALA20011708](https://openairdocs.org/sdr/AALA20011708.md): Battery Pack · discharged · Aug 29, 2001 · N291AA · Doug DC982 · Emergency Lighting > DFW - DURING OVERNIGHT MAINTENANCE, OVERHEAD EMERGENCY LIGHTS AT ROWS 16 THROUGH 18 INOPERATIVE. REPLACED BATTERY PACK. SYSTEM GROUND CHECKED NORMAL OPERATION. (M) - [SDR AALA20000583](https://openairdocs.org/sdr/AALA20000583.md): Seat Track · corroded · Mar 29, 2000 · N291AA · Doug DC982 · Fuselage, Seat/Cargo Attach Fittings > TUL - FROM STATION 1174 TO 1309 SEAT TRACKS NR 1 AND NR 2 AND RELATED CUSPS CORRODED. SEAT TRACKS NR 1 AND NR 2 AND RELATED CUSPS REPLACED FROM STATION 1174 TO 1309 IAW AARD 53-00-00-02. (M) - [SDR AALA20000578](https://openairdocs.org/sdr/AALA20000578.md): Shear Tie · cracked · Mar 28, 2000 · N291AA · Doug DC982 · Fuselage Main, Structure > TUL - FOUND CRACK IN SHEAR TIE BETWEEN L613 AND L614 STATION 1380. STOP DRILLED CRACK. INSTALLED DOUBLER PER AARD 53-10-00-20. (M) - [SDR AALA20000584](https://openairdocs.org/sdr/AALA20000584.md): Frame · worn · Mar 27, 2000 · N291AA · Doug DC982 · Fuselage Main, Frame > TUL - WEAR MARK AT STATION 927 LONGERON 10 LEFT AT LIGHTENING HOLE. BLENDED AREA NOW BELOW LIMITS PER SRM. INSTALLED DOUBLER ON BLENDED AREA STATION 927 PER SRM 53-01 FIG 4. (M) - [SDR AALA20000582](https://openairdocs.org/sdr/AALA20000582.md): Floorbeam · damaged · Mar 27, 2000 · N291AA · Doug DC982 · Fuselage Main, Floor Beam > TUL - FOUND ELONGATED HOLE GOING THROUGH FLOORBEAM. INSTALLED DOUBLER PER SRM 53-05 PART 1 PAGE 31 AND 51-60-00-05. (M) - [SDR AALA20000579](https://openairdocs.org/sdr/AALA20000579.md): Floorbeam · cracked · Mar 25, 2000 · N291AA · Doug DC982 · Fuselage Main, Floor Beam > TUL - FOUND FLOORBEAM CRACKED ON FORWARD SIDE AT RIGHT OUTBOARD END AT STATION 927 FRAME ATTACHMENT. REMOVED AND REPLACED FLOORBEAM STATION 927 PER SRM 51-01. (M) - [SDR AALA20000587](https://openairdocs.org/sdr/AALA20000587.md): Longeron · cracked · Mar 24, 2000 · N291AA · Doug DC982 · Fuselage Structure (General) > TUL - FOUND LONGERON 4L CRACKED AT FUSELAGE STATION 160. INSTALLED NEW LONGERON SECTION AND SPLICE IAW SRM 53-02 FIG 18 (SHEETS 1-6). (M) - [SDR AALA20000580](https://openairdocs.org/sdr/AALA20000580.md): Web · cracked · Mar 22, 2000 · N291AA · Doug DC982 · Fuselage Miscellaneous Structure > TUL - FOUND CUSP HAS MULTIPLE CRACKS. REPLACED CUSP FROM STATION 1287-1305 RIGHT SIDE SRM 51-01. (M) - [SDR AALA20000590](https://openairdocs.org/sdr/AALA20000590.md): Skin · damaged · Mar 21, 2000 · N291AA · Doug DC982 · Trailing Edge Flaps > TUL - TEMP REPAIR ON INBOARD TIE FLAP. INSTALLED DOUBLER PER SRM 57-01 PAGE 8. (M) - [SDR AALA20000589](https://openairdocs.org/sdr/AALA20000589.md): Frame · cracked · Mar 21, 2000 · N291AA · Doug DC982 · Flight Compartment Windows > TUL - WINDOW FRAME CRACKED LEFT STATION 984 LOWER END. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25 REPAIR NR 25. (M) - [SDR AALA2000603](https://openairdocs.org/sdr/AALA2000603.md): Fitting · corroded · Mar 20, 2000 · N291AA · Doug DC982 · Fuselage Miscellaneous Structure > TUL - FOUND CORROSION ON LONGERON AND END FITTING STRINGER 23R STATION 435 AND 446. REMOVED CORROSION FROM LONGERON WITHIN LIMITS TREATED AND PRIMED. REPLACED END FITTING SRM 51-01. (M) - [SDR AALA20000586](https://openairdocs.org/sdr/AALA20000586.md): Web · cracked · Mar 20, 2000 · N291AA · Doug DC982 · Fuselage Miscellaneous Structure > TUL - FOUND LEFT CUSP WEB CRACKED STATION 676-677. INSTALLED DOUBLER PER SRM 53-01 PAGE 18. (M) - [SDR AALA20000585](https://openairdocs.org/sdr/AALA20000585.md): Seat Track · corroded · Mar 20, 2000 · N291AA · Doug DC982 · Fuselage, Seat/Cargo Attach Fittings > TUL - NR 6 SEAT TRACK CORRODED AT STATION 395. REMOVED DAMAGED AREA FINAL CUTOUT 3.5 INCH BY 1.25 INCH AND INSTALLED SEAT TRACK PLUG PER 53-05 PART 1. (M) - [SDR AALA20000591](https://openairdocs.org/sdr/AALA20000591.md): Bulkhead · cracked · Mar 18, 2000 · N291AA · Doug DC982 · Fuselage Main, Bulkhead > TUL - LEFT AFT LAV ENGINE PYLON SUPPORT BULKHEAD TO FUSELAGE SHEAR TIE CRACKED AT BTM BETWEEN L14 AND L16. REMOVED AND REPLACED SHEAR TIE PER AARD 53-10-00-20. (M) - [SDR AALA20000588](https://openairdocs.org/sdr/AALA20000588.md): Bulkhead · cracked · Mar 18, 2000 · N291AA · Doug DC982 · Fuselage Main, Bulkhead > TUL - FOUND RIGHT AFT LAV ENGINE PYLON SUPPORT BULKHEAD TO FUSE SHEAR TIE CRACKED BETWEEN R14 AND R16. REMOVED AND REPLACED RIGTH SHEAR TIE PER AARD 53-10-00-20. (M) - [SDR AALA20000581](https://openairdocs.org/sdr/AALA20000581.md): Shear Tie · cracked · Mar 17, 2000 · N291AA · Doug DC982 · Fuselage Main, Structure > TUL - FOUND SHEAR TIE CRACKED FORWARD SIDE OF STATION 1309 FRAME BETWEEN LONGERON 14R AND 15R. REMOVED AND REPLACED SHEAR TIE PER SRM 51-01. (M) Next page: https://openairdocs.org/deregistered/N291AA-2015-01-14/reports.md?page=2 ## 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 = 'N291AA' AND deregistration_id = 'N291AA-2015-01-14' ORDER BY difficulty_date DESC ``` This list as a web page: https://openairdocs.org/deregistered/N291AA-2015-01-14/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.