# Service difficulty reports: N727AA, cancelled Apr 4, 2017

A list on [N727AA, cancelled Apr 4, 2017](https://openairdocs.org/deregistered/N727AA-2017-04-04.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 · 77 reports

- [SDR AALA20010760](https://openairdocs.org/sdr/AALA20010760.md): Battery · discharged · Apr 9, 2001 · N727AA · Boeing 727227 · Emergency Lighting
  > DFW - DURING OVERNIGHT MAINTENANCE, FOUND COCKPIT EMERGENCY EXIT LIGHT DIM. REPLACED EMERGENCY EXIT LIGHT BATTERY MODULE. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)
- [SDR AALA20010758](https://openairdocs.org/sdr/AALA20010758.md): Battery Pack · loose · Apr 9, 2001 · N727AA · Boeing 727227 · Emergency Lighting
  > DFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT LIGHT AT AFT AIRSTAIR DIM. TIGHTENED EMERGENCY EXIT LIGHT BATTERY PACK AT AFT AIRSTAIR. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)
- [SDR AALA20010759](https://openairdocs.org/sdr/AALA20010759.md): Module · inoperative · Apr 9, 2001 · N727AA · Boeing 727227 · Emergency Lighting
  > DFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT LIGHT AT L2 DOOR DIM. REPLACED EMERGENCY EXIT LIGHT BATTERY MODULE. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)
- [SDR AALA20010587](https://openairdocs.org/sdr/AALA20010587.md): Module · defective · Mar 26, 2001 · N727AA · Boeing 727227 · Emergency Lighting
  > IAD - DURING OVERNIGHT MAINTENANCE, OVERWING EMERGENCY EXIT LIGHT DIM. REPLACED EMERGENCY EXIT LIGHT MODULE. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)
- [SDR AALA20010200](https://openairdocs.org/sdr/AALA20010200.md): Strap · cracked · Feb 1, 2001 · N727AA · Boeing 727227 · Fuselage Miscellaneous Structure
  > TUL - FOUND THE STRAP ON VERTICAL STIFFENER RBL 26.83 WL 273 AT 1183 BULKHEAD WAS GOUGED UPON REMOVAL OF STRAP FASTENER HOLE AND FOUND CRACKED FROM HOLE. STRAP WAS REMOVED AND NEW STRAP INSTALLED SRM 51-10-1 DOUBLERS ON BOTH SIDE OF VERTICAL STIFFENER WERE IN
- [SDR AALA20010198](https://openairdocs.org/sdr/AALA20010198.md): Floorbeam · cracked · Feb 1, 2001 · N727AA · Boeing 727227 · Fuselage Main, Floor Beam
  > TUL - FOUND FS 825.95 FLOOR FRAME WEB IS CRACKED THROUGH BOTH SIDES OF LIGHTENING HOLE NEXT TO BL 48 RT SEAT TRACK. STOP DRILLED CRACKS. INSTALLED DOUBLER PER SRM 51-402. (M)
- [SDR AALA20010199](https://openairdocs.org/sdr/AALA20010199.md): Stringer · corroded · Jan 31, 2001 · N727AA · Boeing 727227 · Wing, Longeron/Stringer
  > TUL - FOUND LIGHT TO MODERATE CORROSION ON BOTTOM OF STRINGER, ABOVE LEFT PRIMARY HEAT EXCHANGER AFT INBOARD SECTION. INSTALLED REPAIR PER SRM 57-30-3 FIG 9. (M)
- [SDR AALA20010197](https://openairdocs.org/sdr/AALA20010197.md): Floorbeam · corroded · Jan 30, 2001 · N727AA · Boeing 727227 · Fuselage Main, Floor Beam
  > TUL - FOUND CABIN FLOOR BEAM CORRODED BOTTOM FLANGE PLATE HOLES, STATION 1130. REPAIRED PER ESO11697 DATED 1/30/01. (M)
- [SDR AALA20010196](https://openairdocs.org/sdr/AALA20010196.md): Door Frame · cracked · Jan 30, 2001 · N727AA · Boeing 727227 · Fuselage Main, Structure
  > TUL - FOUND LOWER AFT CORNER OF FORWARD GALLEY DOOR HAS TWO SKIN CRACKS DOOR CUTOUT. STRIPED PAINT INSTALLED DOUBLER PER SERVICE BULLETIN 727-53-0188. (M)
- [SDR AALA20000947](https://openairdocs.org/sdr/AALA20000947.md): Landing Gear · lack of lube · Jun 7, 2000 · N727AA · Boeing 727227 · Landing Gear Retraction/Extension System
  > MCI - FLT 1379 - DURING LANDING MCI, NOSE GEAR LANDING GEAR FAILED TO FULLY EXTEND. RECYCLED GEAR AND GEAR EXTENDED NORMALLY. LANDED MCI WITHOUT INCIDENT. LUBED NOSE LANDING GEAR, SWUNG NOSE GEAR SEVERAL TIMES. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)
- [SDR AALA20000722](https://openairdocs.org/sdr/AALA20000722.md): Floorbeam · corroded · Apr 28, 2000 · N727AA · Boeing 727227 · Fuselage Main, Floor Beam
  > TUL - CORROSION ON STA 1070 FLOORBEAM LOWER FLANGE AROUND 2 NDT PLATES, RBL 10 AND LBL 10. INSTALLED DOUBLER REPAIR PER ESO 11697 DATED 4-21-00. (X)
- [SDR AALA991931](https://openairdocs.org/sdr/AALA991931.md): Skin · dented · Dec 13, 1999 · N727AA · Boeing 727227 · Vertical Stabilizer, Plate/Skin
  > TUL - VERTICAL STABILIZER DENT IN SKIN 34 INCHES AFT OF RIGHT AMERICAN FLAG IN SKIN STA 1223 WITH CRACK IN DENT. INSTALLED DOUBLER PER SRM 54-10-3. TST: 72,089.43 HOURS. CYCLES: 46,585. (X)
- [SDR AALA991929](https://openairdocs.org/sdr/AALA991929.md): Shear Tie · corroded · Dec 13, 1999 · N727AA · Boeing 727227 · Fuselage Miscellaneous Structure
  > TUL - CORROSION ON SHEAR TIES BETWEEN BL ZERO AND STR 26L. INSTALLED REPAIRS BETWEEN STR 28L AND STR 27L PER SRM 53-10-4 FIG 15 SHEET 3 REPAIR 3. INSTALLED NEW SHEAR TIE BETWEEN STR 27L AND STR 26L PER SRM 51-10-1. TST: 72,089 HOURS. CYCLES: 46,585. (X)
- [SDR AALA991930](https://openairdocs.org/sdr/AALA991930.md): Frame · cracked · Dec 12, 1999 · N727AA · Boeing 727227 · Fuselage Main, Frame
  > TUL - CRACK IN FRAME AT STA 783 LEFT FRAME. INSTALLED REPAIR ANGLES PER DWG 65C36280 AND PER SB 727-53-0197. TST: 72,089.5 HOURS. CYCLES: 46,585. (X)
- [SDR AALA991927](https://openairdocs.org/sdr/AALA991927.md): Shear Tie · corroded · Dec 10, 1999 · N727AA · Boeing 727227 · Fuselage Miscellaneous Structure
  > TUL - SHEAR TIE IN FORWARD CARGO CORRODED STA 720 STR 28L TO STR 28R. REMOVED CORRODED SHEAR TIE AND FABRICATED AND INSTALLED NEW SHEAR TIE SRM 51-10-1. TST: 72,089.43 HOURS. CYCLES: 46,585. (X)
- [SDR AALA991793](https://openairdocs.org/sdr/AALA991793.md): Light · inoperative · Nov 25, 1999 · N727AA · Boeing 727227 · Emergency Lighting
  > DFW - DURING OVERNIGHT MAINTENANCE, PORTABLE EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED PORTABLE EMERGENCY EXIT LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)
- [SDR AALA991230](https://openairdocs.org/sdr/AALA991230.md): Connector · defective · Aug 19, 1999 · N727AA · Boeing 727227 · Emergency Lighting
  > BNA - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT FLOOR PATH LIGHT STRIPS FROM FRONT OF COACH TO FRONT OF FIRST CLASS INOPERATIVE. REPLACED CONNECTOR BETWEEN FIRST CLASS AND COACH EMERGENCY EXIT FLOOR PATH LIGHTS STRIPS. SYSTEM GROUND CHECKED NORMAL OPERATI
- [SDR AALA990904](https://openairdocs.org/sdr/AALA990904.md): Light · inoperative · May 13, 1999 · N727AA · Boeing 727227 · Emergency Lighting
  > MIA - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT FLOOR PATH LIGHTS BETWEEN SEATS 6D AND 28D INOPERATIVE. REPLACED EMERGENCY EXIT FLOOR PATH LIGHT STRIP. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)
- [SDR AALA990090](https://openairdocs.org/sdr/AALA990090.md): Bulkhead · cracked · Jan 15, 1999 · N727AA · Boeing 727227 · Fuselage Main, Bulkhead
  > TUL - 870 BULKHEAD CRACKED AT THE LOAD CONTROL VALVE CUT OUT, 5 O'CLOCK POSITION. STOP DRILLED CRACK TO.250 INCH FABRICATED AND INSTALLED DOUBLER AND TRIPLER AROUND CUT OUT PER SRM 53-10-2 PAG 26. (M)
- [SDR AALA990089](https://openairdocs.org/sdr/AALA990089.md): Bracket · corroded · Jan 13, 1999 · N727AA · Boeing 727227 · Wing Miscellaneous Structure
  > TUL - FOUND CORROSION ON INBOARD SIDE OF OUTBOARD MOUNT BRACKET FOR NR 3 LE SLAT ACTUATOR. INSTALLED NEW MOUNT BRACKET ON INBOARD SIDE OF OUTBOARD MOUNT BRACKET NR 3 SLAT ACTUATOR. (M)
- [SDR AALA980598](https://openairdocs.org/sdr/AALA980598.md): Light · defective · Mar 23, 1998 · N727AA · Boeing 727227 · Emergency Lighting
  > MIA - DURING OVERNIGHT MAINTENANCE CEHCK, EMERGENCY EXIT FLOOR PATH LIGHTS IN AFT COACH INOPERATIVE. REPAIRED EMERGENCY EXIT FLOOR PATH LIGHT STRIP IN AFT COACH CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)
- [SDR AALA980088](https://openairdocs.org/sdr/AALA980088.md): Web · cracked · Jan 16, 1998 · N727AA · Boeing 727227 · Vertical Stabilizer
  > TUL - APPROX.75 INCH CRACK IN WEB RADIUS AT UPPER CORNER ATTACH TO VERTICLE FIN RT SIDE STATION 1363. STOP DRILLED CRACK, INSTALLED WEB ANGLE DOUBLER REPAIR PER SRM 51-40-2 FIG 1. (M)
- [SDR AALA980084](https://openairdocs.org/sdr/AALA980084.md): Shear Tie · corroded · Jan 9, 1998 · N727AA · Boeing 727227 · Fuselage Miscellaneous Structure
  > TUL - FOUND CORROSION ON SHEAR TIE STRINGER 26R AT STATION 720. REMOVED AND REPLACED SHEAR TIE PER SRM 51-10-1. (M)
- [SDR AALA980059](https://openairdocs.org/sdr/AALA980059.md): Stringer · corroded · Jan 9, 1998 · N727AA · Boeing 727227 · Fuselage Main, Longeron/Stringer
  > TUL - CORROSION ON STR 27R STA 1030 - STA 1040 AND SKIN UNDER STRINGER. REMOVED CORROSION, REPAIRED PER SRM 53-30-3, FIG 3. TST: 67,236 HOURS. CYCLES: 44,034. (X)
- [SDR AALA980082](https://openairdocs.org/sdr/AALA980082.md): Floor Beam · corroded · Jan 7, 1998 · N727AA · Boeing 727227 · Fuselage Main, Floor Beam
  > TUL - APPROXIMATELY ONE-HALF DIAMETER OF DEEP CORROSION ON TOP OF FLOOR BEAM STA 1130 RBL 2411. REPAIRED AFFECTED AREA WITH STRAP DOUBLER PER ESO 11697 DATED 12-12-97. TST: 67,236 HOURS. CYCLES: 44,034. (X)
- [SDR AALA980066](https://openairdocs.org/sdr/AALA980066.md): Skin · corroded · Jan 7, 1998 · N727AA · Boeing 727227 · Wing, Plate/Skin
  > TUL - AREA OF BULGED AND DISTORTED SKIN UPPER FIXED LEADING EDGE JUST ABOVE INBOARD END OF FUELING PANEL, POSSIBLE CORROSION. REMOVED DAMAGED AREA, INSTALLED FLUSH REPAIR PER SRM 57-30-4. TST: 67,236 HOURS. CYCLES: 44,034. (X)
- [SDR AALA980056](https://openairdocs.org/sdr/AALA980056.md): Stringer · corroded · Jan 7, 1998 · N727AA · Boeing 727227 · Fuselage Main, Longeron/Stringer
  > TUL - CORROSION AT STR 23L, STA 720E TO 720F. REPAIRED STRINGER PER SRM 53-10-3, FIG 1, SHEET 4, DETAIL NR 1. TST: 67,236 HOURS. CYCLES: 44,034. (X)
- [SDR AALA980087](https://openairdocs.org/sdr/AALA980087.md): Beam · cracked · Jan 6, 1998 · N727AA · Boeing 727227 · Fuselage Miscellaneous Structure
  > TUL - FOUND CRACK RIGHT SIDE 1183 BEAM FORWARD SIDE 24 INCHES OUTBOARD FROM VAULT DOOR FRAME STRINGER 13 AREA. INSTALLED SERVICEABLE BEAM PREVENT MOD AND REPAIR PER BOEING BWG 65C34406 (S/B 727-53-0192). (M)
- [SDR AALA980086](https://openairdocs.org/sdr/AALA980086.md): Web · corroded · Jan 6, 1998 · N727AA · Boeing 727227 · Fuselage Miscellaneous Structure
  > TUL - RIGHT AFT LAV FLOOR WEB HAS SEVERAL AREAS OF CORROSION ON TOP SIDE. INSTALLED NEW FLOOR WEB PER SRM 51-10-1 PAGE 4. (M)
- [SDR AALA980085](https://openairdocs.org/sdr/AALA980085.md): Shear Tie · corroded · Jan 6, 1998 · N727AA · Boeing 727227 · Fuselage Miscellaneous Structure
  > TUL - FOUND CORROSION AT SHEAR TIE STATION 680 BETWEEN STRINGER 26L AND STRINGER 27L. REPLACED SHEAR TIE PER SRM 51-10-1. (M)
- [SDR AALA980083](https://openairdocs.org/sdr/AALA980083.md): Floorbeam · corroded · Jan 6, 1998 · N727AA · Boeing 727227 · Fuselage Main, Floor Beam
  > TUL - FOUND STATION 328, 52LBL FLOORBEAM CORROSION. INSTALLED DOUBLER ON FLOORBEAM PER SRM 53-10-08 PAGE 49-53. (M)
- [SDR AALA980081](https://openairdocs.org/sdr/AALA980081.md): Shear Tie · cracked · Jan 6, 1998 · N727AA · Boeing 727227 · Fuselage Miscellaneous Structure
  > TUL - STA 720, ABOVE STR 18L, BELT FRAME SHEAR TIE IS CRACKED. REPAIRED PER SRM 51-40-3. TST: 67,236 HOURS. CYCLES: 44,034. (X)
- [SDR AALA980080](https://openairdocs.org/sdr/AALA980080.md): Frame · cracked · Jan 6, 1998 · N727AA · Boeing 727227 · Fuselage Main, Frame
  > TUL - BELL FRAME CRACKED STA 277 AT STR 16 LEFT. STOP DRILLED CRACK AND INSTALLED DOUBLER PER SRM 51-40-2. TST: 67,236 HOURS. CYCLES: 44,034. (X)
- [SDR AALA980079](https://openairdocs.org/sdr/AALA980079.md): Beam · corroded · Jan 6, 1998 · N727AA · Boeing 727227 · Horizontal Stabilizer Structure
  > TUL - SEVERAL AREAS OF CORROSION ON AFT EDGE OF RT HORIZONTAL REAR UPPER CHORD. REPLACED RT AFT HORIZONTAL BEAM. TST: 67,236 HOURS. CYCLES: 44,034. (X)
- [SDR AALA980078](https://openairdocs.org/sdr/AALA980078.md): Skin · corroded · Jan 6, 1998 · N727AA · Boeing 727227 · Fuselage Main, Plate/Skin
  > TUL - CORROSION COMING OUT AROUND FASTENERS AND SKIN AND BETWEEN SKIN AND STRINGER. CUT OUT DAMAGE, INSTALLED DOUBLER PER SRM 53-30-3. TST: 67,236 HOURS. CYCLES: 44,034. (X)
- [SDR AALA980077](https://openairdocs.org/sdr/AALA980077.md): Skin · corroded · Jan 6, 1998 · N727AA · Boeing 727227 · Fuselage Main, Plate/Skin
  > TUL - CORROSION EMANATING FROM LONGITUDINAL SKIN LAP. INSTALLED EXTERNAL DOUBLER 11 INCHES BY 14 INCHES PER SRM 53-30-3 FIG 14 SHEETS 1 THROUGH 6. TST: 67,236 HOURS. CYCLES: 44,034. (X)
- [SDR AALA980076](https://openairdocs.org/sdr/AALA980076.md): Skin · corroded · Jan 6, 1998 · N727AA · Boeing 727227 · Fuselage Main, Plate/Skin
  > TUL - CORROSION UNDER STR 26R BETWEEN STA 720C TO STA 720D. INSTALLED EXTERNAL DOUBLER PER SRM 53-30-3. TST: 67,236 HOURS. CYCLES: 44,034. (X)
- [SDR AALA980075](https://openairdocs.org/sdr/AALA980075.md): Skin · corroded · Jan 6, 1998 · N727AA · Boeing 727227 · Fuselage Main, Plate/Skin
  > TUL - CORROSION UNDER STR 26R BETWEEN STA 720C TO STA 720D. INSTALLED EXTERNAL DOUBLER PER SRM 53-30-3. TST: 67,236 HOURS. CYCLES: 44,034. (X)
- [SDR AALA980074](https://openairdocs.org/sdr/AALA980074.md): Skin · corroded · Jan 6, 1998 · N727AA · Boeing 727227 · Fuselage Main, Plate/Skin
  > TUL - CORROSION IN SEALANT AT STR 10R STA 990 - STA 1010 AT SKIN LAP. REPAIRED PER SRM 53-30-3 FIG 5 PER ESO 11697 DATED 12-8-97. TST: 67,236 HOURS. CYCLES: 44,034. (X)
- [SDR AALA980073](https://openairdocs.org/sdr/AALA980073.md): Skin · corroded · Jan 6, 1998 · N727AA · Boeing 727227 · Fuselage Main, Plate/Skin
  > TUL - CORROSION UNDER STR 26R FROM STA 696 TO STA 715. REPAIRED PER SRM 53-30-3 FIG 14. TST: 67,236 HOURS. CYCLES: 44,034. (X)
- [SDR AALA980072](https://openairdocs.org/sdr/AALA980072.md): Skin · corroded · Jan 6, 1998 · N727AA · Boeing 727227 · Fuselage Main, Plate/Skin
  > TUL - SKIN BULGED OUT AT THE REPAIR STA 552, STR 28L. INSTALLED DOUBLER PER SRM 53-30-3, FIG 3. TST: 67,236 HOURS. CYCLES: 44,034. (X)
- [SDR AALA980071](https://openairdocs.org/sdr/AALA980071.md): Skin · dented · Jan 6, 1998 · N727AA · Boeing 727227 · Fuselage Main, Plate/Skin
  > TUL - 3 INCH DENT AND GOUGE BELOW STR 24R, STA 332. REPAIRED MINOR DENT IN SKIN PER SRM 53-30-3 PAGE 154 FIG 24 SHEET 4. TST: 67,236 HOURS. CYCLES: 44,034. (X)
- [SDR AALA980070](https://openairdocs.org/sdr/AALA980070.md): Skin · corroded · Jan 6, 1998 · N727AA · Boeing 727227 · Fuselage Main, Plate/Skin
  > TUL - FUSELAGE SKIN BULGED STA 681 BETWEEN STR 28L AND STR 28R. REPLACED DAMAGED SKIN PER SRM 53-30-3 FIG 3. TST: 67,236 HOURS. CYCLES: 44,034. (X)
- [SDR AALA980069](https://openairdocs.org/sdr/AALA980069.md): Skin · corroded · Jan 6, 1998 · N727AA · Boeing 727227 · Fuselage Main, Plate/Skin
  > TUL - SKIN BULGING AROUND FASTENER HOLE STA 708 OUTBOARD STR 26R. REPLACED DAMAGED SKIN PER SRM 53-30-3 FIG 3. TST: 67,236 HOURS. CYCLES: 44,034. (X)
- [SDR AALA980068](https://openairdocs.org/sdr/AALA980068.md): Skin · corroded · Jan 6, 1998 · N727AA · Boeing 727227 · Fuselage Main, Plate/Skin
  > TUL - LOWER SKIN BULGED AT STR 27R STA 500. INSTALLED EXTERNAL DOUBLER AT STR 27R STA 500 PER SRM 53-30-3. TST: 67,236 HOURS. CYCLES: 44,034. (X)
- [SDR AALA980067](https://openairdocs.org/sdr/AALA980067.md): Skin · corroded · Jan 6, 1998 · N727AA · Boeing 727227 · Fuselage Main, Plate/Skin
  > TUL - SKIN BULGED OUT AT THE FLUSH REPAIR STA 580, STR 28L. INSTALLED DOUBLER PER SRM 53-30-3, FIG 3. TST: 67,236 HOURS. CYCLES: 44,034. (X)
- [SDR AALA980065](https://openairdocs.org/sdr/AALA980065.md): Skin · corroded · Jan 6, 1998 · N727AA · Boeing 727227 · Fuselage Main, Plate/Skin
  > TUL - SKIN BULGED OUT AND FRONT BROKEN IN SKIN LAP AND DOUBLER, STR 26R, STA 700. DAMAGED AREA REPAIRED PER SRM 53-30-3, FIG 4. TST: 67,236 HOURS. CYCLES: 44,034. (X)
- [SDR AALA980064](https://openairdocs.org/sdr/AALA980064.md): Stringer · corroded · Jan 6, 1998 · N727AA · Boeing 727227 · Fuselage Main, Longeron/Stringer
  > TUL - CORROSION AT STR 23L STA 720E TO STA 720F. REPAIRED STRINGER PER SRM 53-10-3, FIG 1, SHEET 4, DETAIL NR 1. TST: 67,236 HOURS. CYCLES: 44,034. (X)
- [SDR AALA980063](https://openairdocs.org/sdr/AALA980063.md): Stringer · corroded · Jan 6, 1998 · N727AA · Boeing 727227 · Fuselage Main, Longeron/Stringer
  > TUL - STR 27L HAS CORROSION ON BOTTOM AT STA 552 TO STA 555. REPAIRED STR PER SRM 53-10-3 FIG 1. TST: 67,236 HOURS. CYCLES: 44,034. (X)
- [SDR AALA980062](https://openairdocs.org/sdr/AALA980062.md): Stringer · corroded · Jan 6, 1998 · N727AA · Boeing 727227 · Fuselage Main, Longeron/Stringer
  > TUL - CORROSION AT STR 26L BETWEEN STA 680 AND STA 700 (MKD). REPAIRED STRINGER PER SRM 53-10-3. TST: 67,236 HOURS. CYCLES: 44,034. (X)

Next page: https://openairdocs.org/deregistered/N727AA-2017-04-04/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 = 'N727AA' AND deregistration_id = 'N727AA-2017-04-04'
ORDER BY difficulty_date DESC
```

This list as a web page: https://openairdocs.org/deregistered/N727AA-2017-04-04/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, except the copies of manufacturers’ service documents, which belong to their rights holders.
