# Service difficulty reports: N720AE, cancelled Sep 9, 2019

A list on [N720AE, cancelled Sep 9, 2019](https://openairdocs.org/deregistered/N720AE-2019-09-09.md).

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

- [SDR SIMA20131024007](https://openairdocs.org/sdr/SIMA20131024007.md): Panel · misinstalled · Oct 24, 2013 · N720AE · Emb EMB135LR · Fuselage Miscellaneous Structure
  > LEFT OVERWING EMERGENCY EXIT BINDING AND WILL NOT OPEN. ACFT REMOVED FOR SERVICE. REMOVED AND REINSTALLED SIDEWALL PANEL THAT SURROUNDS LT OVERWING EXIT CORRECTLY IAW AMM 25-23-01. OPS CHECKED GOOD.
- [SDR SIMA20131024006](https://openairdocs.org/sdr/SIMA20131024006.md): Light · inoperative · Oct 24, 2013 · N720AE · Emb EMB135LR · Emergency Lighting
  > MID CABIN EMERGENCY LIGHT ON CEILING IS INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT IAW AMM 33-50-13. OPS CHECKED GOOD. ACFT RETURNED TO SERVICE.
- [SDR SIMA20131005004](https://openairdocs.org/sdr/SIMA20131005004.md): Sign · inoperative · Oct 5, 2013 · N720AE · Emb EMB135LR · Emergency Lighting
  > OVERHEAD CEILING, AISLE, EMERGENCY LIGHT AT EMERGENCY EXIT ROW INOPERATIVE. R & R SIGN ASSY AT EMERGENCY ROW IAW MM 33-50-15, OPS CHECKED GOOD.
- [SDR SIMA20130924004](https://openairdocs.org/sdr/SIMA20130924004.md): Light · obstructed · Sep 24, 2013 · N720AE · Emb EMB135LR · Emergency Lighting
  > EMERGENCY FLOOR LIGHTS COVERED BY CARPET, ROWS 2-5. RELOCATED CENTER FLOOR COVERING IAW AMM 25-24-01. OPS CHECK GOOD.
- [SDR SIMA20130826004](https://openairdocs.org/sdr/SIMA20130826004.md): Engine · power loss · Aug 26, 2013 · N720AE · Emb EMB135LR · Engine (Turbine/Turboprop)
  > CREW REPORTED DURING CRUISE FLT, NR 1 ENGINE FUEL IMPELLER BYPASSED ILLUMINATED ON EICAS. NR 1 ENGINE WOULD NOT PRODUCE FULL POWER AND ENGINE WAS SPUTTERING LIKE IT WAS STARVED OF FUEL. DECLARED AN EMERGENCY AND DIVERTED. LANDED WITHOUT INCIDENT. ACFT RE
- [SDR SIMA20130625001](https://openairdocs.org/sdr/SIMA20130625001.md): Handle · detached · Jun 25, 2013 · N720AE · Emb EMB135LR · Passenger/Crew Doors
  > DURING MX INSPECTION, FOUND MAIN DOOR INSIDE HANDLE DETACHED. ACFT REMOVED FROM SERVICE. INSTALLED MAIN DOOR HANDLE IAW AMM 52-11-01. OPS CHECKED GOOD. ACFT RETURNED TO SERVICE.
- [SDR SIMA20130513001](https://openairdocs.org/sdr/SIMA20130513001.md): Dau · inoperative · May 12, 2013 · N720AE · Emb EMB135LR · Central Computers
  > ON FLIGHT 4471 THE CREW REPORTED THEY HAD ELECTRICAL PROBLEMS. THE CREW DECLARED AN EMERGENCY AND RETURNED TO LGA. THE AIRCRAFT LANDED WITHOUT INCIDENT. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED THE DATA ACQUISITION UNIT 1 IAW AMM 31-41-0
- [SDR SIMA20130509005](https://openairdocs.org/sdr/SIMA20130509005.md): Cradle · broken · May 9, 2013 · N720AE · Emb EMB135LR · Emergency Equipment
  > DURING MAINTENANCE INSPECTION FOUND THE FIRST OFFICER’S EMERGENCY FLASHLIGHT CRADLE BROKEN. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED THE FIRST OFFICER’S EMERGENCY FLASHLIGHT CRADLE IAW EMB MM 33-50-16. THE OPERATIONAL CHECK WAS GOOD. THE
- [SDR SIMA20130301003](https://openairdocs.org/sdr/SIMA20130301003.md): Cradle · defective · Mar 1, 2013 · N720AE · Emb EMB135LR · Emergency Equipment
  > ON FLIGHT 3337 THE CREW REPORTED THE EMERGENCY FLASHLIGHT CRADLE AFT-ON LAV WALL DOES NOT HOLD FLASHLIGHT IN PLACE. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED AFT FLASHLIGHT BASE PER AMM 33-50-16. THE OPERATIONAL CHECK WAS GOOD. THE AIRCRA
- [SDR SIMA20121121012](https://openairdocs.org/sdr/SIMA20121121012.md): Light · inoperative · Nov 21, 2012 · N720AE · Emb EMB135LR · Emergency Lighting
  > DURING B INSPECTION FOUND THE RIGHT AFT OVERWING EMERGENCY LIGHT INOPERABLE. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED THE RIGHT AFT OVERWING EMERGENCY LIGHT LAMP IAW EMB 135 AMM 33-50-07. THE OPERATIONAL CHECK WAS GOOD. THE AIRCRAFT WAS
- [SDR SIMA20120928007](https://openairdocs.org/sdr/SIMA20120928007.md): Cradle · broken · Sep 28, 2012 · N720AE · Emb EMB135LR · Emergency Equipment
  > DURING MAINTENANCE INSPECTION FOUND THE CAPTAIN’S EMERGENCY FLASHLIGHT BASE, (CRADLE) BROKEN. WILL NOT HOLD FLASHLIGHT FIRM IN BASE. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED THE CAPTAIN’S EMERGENCY FLASHLIGHT BASE, (CRADLE) IAW EMB 135 AM
- [SDR SIMA20120914001](https://openairdocs.org/sdr/SIMA20120914001.md): Roll Pin · unsecure · Sep 11, 2012 · N720AE · Emb EMB135LR · Flight Compartment Equipment
  > ON FLIGHT 2820 THE CREW REPORTED WHILE CLIMBING THROUGH 13,00 FEET THE CAPTAIN’S JUMP SEAT MALFUNCTIONED. THE SEAT WAS STUCK IN A 3/4 REAR POSITION, IT WOULD NOT MOVE FORWARD, AFT OR SIDEWAYS. IN THE INTEREST OF SAFETY THE CREW DECLARED AN EMERGENCY AND RETU
- [SDR SIMA20120821005](https://openairdocs.org/sdr/SIMA20120821005.md): Battery Pack · inoperative · Aug 21, 2012 · N720AE · Emb EMB135LR · Emergency Lighting
  > DURING MAINTENANCE INSPECTION, FOUND THE EMERGENCY LIGHT BATTERY PACK NR 3 INOPERABLE. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED THE NR 3 EMERGENCY LIGHT BATTERY PACK AND CHARGER ASSEMBLY IAW EMB 135 AMM 33-50-04. THE OPERATIONAL CHECK WAS
- [SDR SIMA20120510020](https://openairdocs.org/sdr/SIMA20120510020.md): Flashlight · intermittent · May 10, 2012 · N720AE · Emb EMB135LR · Emergency Equipment
  > ON FLIGHT 2772 THE FLIGHT ATTENDANT REPORTED THE ENTRY DOOR FLASHLIGHT INTERMITTENTLY WORKED--NOT INDICATING CHARGING. THE AIRCRAFT WAS REMOVED FROM SERVICE. PERFORMED OPERATIONAL CHECK IAW EMB 135 AMM 33-51-01 AND FOUND GOOD. NO PARTS REMOVED OR REPLACED.
- [SDR SIMA20120425013](https://openairdocs.org/sdr/SIMA20120425013.md): Flashlight Assy · broken · Apr 25, 2012 · N720AE · Emb EMB135LR · Emergency Equipment
  > FLIGHT 3228, CREW REPORTED THE FLIGHT ATTENDANT’S REAR CABIN FLASHLIGHT WILL NOT STAY IN THE HOLDER. FOUND AFT FLASHLIGHT HOLDER EAR BROKEN OFF. REMOVED AND REPLACED THE FLIGHT ATTENDANT AFT FLASHLIGHT ASSEMBLY IAW AMM 33-50-16. OPS CHECKED GOOD. AIRCRA
- [SDR SIMA20120401007](https://openairdocs.org/sdr/SIMA20120401007.md): Smoke Detector · inoperative · Apr 1, 2012 · N720AE · Emb EMB135LR · Smoke Detection
  > DURING MAINTENANCE INSPECTION FOUND THE FORWARD CARGO SMOKE DETECTOR INOPERABLE. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED THE RIGHT SMOKE DETECTOR & RELAY IAW EMB135 AMM 20-13-02. THE OPERATIONAL CHECK OF SMOKE DETECTOR WAS GOOD IAW EMB 1
- [SDR SIMA2012051016](https://openairdocs.org/sdr/SIMA2012051016.md): Inverter · inoperative · Feb 18, 2012 · N720AE · Emb EMB135LR · Emergency Lighting
  > DURING B-INSPECTION, FOUND THE EMERGENCY EXIT SIGN OVER THE SERVICE DOOR INOPERATIVE. AIRCRAFT REMOVED FROM SERVICE. REMOVED AND REPLACED THE NR 2 EMERGENCY LIGHT INVERTER IAW AMM 33-50-11. OPS CHECKED GOOD. AIRCRAFT RETURNED TO SERVICE.
- [SDR SIMA2012032001](https://openairdocs.org/sdr/SIMA2012032001.md): Light · inoperative · Jan 31, 2012 · N720AE · Emb EMB135LR · Emergency Lighting
  > DURING MAINTENANCE INSPECTION FOUND THE AILSE EMERGENCY LIGHT AT SEAT 9A INOPERABLE. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED THE AILSE EMERGENCY LAMP AT SEAT 9A IAW EMB 135 AMM 33-50-08. THE OPERATIONAL CHECK WAS GOOD. THE AIRCRAFT WAS
- [SDR SIMA2011301003](https://openairdocs.org/sdr/SIMA2011301003.md): Medical Kit · unserviceable · Oct 26, 2011 · N720AE · Emb EMB135LR · Emergency Equipment
  > DURING MAINTENANCE BASE VISIT FOUND THE MEDICAL KIT SEAL BROKEN. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED THE MEDICAL KIT IAW EMB-135 MM 25-60-00. THE AIRCRAFT WAS RETURNED TO SERVICE.
- [SDR SIMA201118903](https://openairdocs.org/sdr/SIMA201118903.md): Door · binding · Jul 6, 2011 · N720AE · Emb EMB135LR · Emergency Lighting
  > ON FLIGHT 3333 THE CREW REPORTED THE MAIN CABIN DOOR WAS HARD TO CLOSE. THE AIRCRAFT WAS REMOVED FROM SERVICE. INSPECTED MAIN CABIN DOOR FOR DEFECTS. MAINTENANCE OPENED AND CLOSED THE DOOR IAW EMB 135 AMM 52-18-00, NO DEFECTS WERE NOTED. NO PARTS REMOVED O
- [SDR SIMA201004610](https://openairdocs.org/sdr/SIMA201004610.md): Battery · discharged · Feb 14, 2010 · N720AE · Emb EMB135LR · Emergency Lighting
  > DURING MAINTENANCE CHECK FOUND THAT ALL OF THE FORWARD CABIN EMERGENCY LIGHTS FAILED TO ILLUMINATE. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED THE NUMBER 1 EMERGENCY BATTERY AND CHARGER ASSEMBLY IAW AEWC 33-700-19. THE AIRCRAFT WAS RETURNED
- [SDR SIMA200726802](https://openairdocs.org/sdr/SIMA200726802.md): Actuator · leaking · Sep 24, 2007 · N720AE · Emb EMB135LR · Rudder Control System
  > HYDRAULIC NR 1 LOW QUANTITY LEVEL WENT FROM TOP OF YELLOW TO BOTTOM OF YELLOW IN LESS THAN 40 MINUTES. DID NOT GET A HYDRAULIC FAIL MESSAGE. REMOVED AND REPLACED NR 1 RUDDER ACTUATOR AND COMPLETED RUDDER BACKLASH CHECK. ALL LEAK AND OPERATIONAL/FUNCTIONAL C
- [SDR SIAM200726003](https://openairdocs.org/sdr/SIAM200726003.md): Inverter · malfunctioned · Sep 16, 2007 · N720AE · Emb EMB135LR · AC Generation System
  > AS CREW SET THRUST 115V BUSS OFF LINE WITH ASSOCIATED MESSAGES. DID LOW SPEED ABORT AND RETURNED TO GATE. REMOVED AND REPLACED STATIC INVERTER IAW EMB135 AMM 24-20-01. OPS CHECK GOOD, AIRCRAFT RETURNED TO SERVICE.
- [SDR SIMA200722204](https://openairdocs.org/sdr/SIMA200722204.md): Ballast · burned · Aug 9, 2007 · N720AE · Emb EMB135LR · Passenger Compartment Lighting
  > ELECTRICAL ODOR IN CABIN AT SEAT 1A. FOUND BALLAST RT8425 AND RT8400 BURNED. REMOVED AND REPLACED BALLAST IAW EMB AMM 33-21-03. OPERATIONAL CHECK GOOD. RETURNED AIRCRAFT TO SERVICE.
- [SDR SIMA200721402](https://openairdocs.org/sdr/SIMA200721402.md): Control Module · burned · Jul 31, 2007 · N720AE · Emb EMB135LR · Passenger Compartment Lighting
  > BURNING ODOR FROM GALLEY AREA. REMOVED AND REPLACED LIGHT BALLAST IAW EMB AMM 33-21-05 AND REMOVED AND REPLACED CONTROL MODULE ASSEMBLY IAW EMB AMM 33-21-01, BOTH COMPONENTS OPERATIONAL CHECK GOOD. AIRCRAFT RETURNED TO SERVICE.
- [SDR SIMA200720428](https://openairdocs.org/sdr/SIMA200720428.md): Floor Support · corroded · Jun 22, 2007 · N720AE · Emb EMB135LR · Fuselage Main, Structure
  > RIGHT OMEGA BEAM CORRODED BETWEEN FRAMES 24 AND 25. REMOVED DAMAGED AREA, FABRICATED AND INSTALLED REPAIR PARTS IAW EMB SRM 53-00-10, FIGURE 203. RETURNED AIRCRAFT TO SERVICE.
- [SDR SIMA200720423](https://openairdocs.org/sdr/SIMA200720423.md): Floor Support · corroded · Jun 20, 2007 · N720AE · Emb EMB135LR · Fuselage Miscellaneous Structure
  > LEFT OMEGA BEAM CORRODED BETWEEN 24 AND 25. CUT OUT CORROSION, FABRICATED AND INSTALLED REPAIR PARTS IAW EMB SRM 53-00-10, FIGURE 202. RETURNED AIRCRAFT TO SERVICE.
- [SDR SIMA200720424](https://openairdocs.org/sdr/SIMA200720424.md): Sill · corroded · Jun 20, 2007 · N720AE · Emb EMB135LR · Fuselage Miscellaneous Structure
  > SERVICE DOOR SILL FOUND CORRODED. REMOVED AND REPLACED SILL IAW EMB SRM 51-40-02 AND 51-40-04. RETURNED AIRCRAFT TO SERVICE.
- [SDR SIMA200530105](https://openairdocs.org/sdr/SIMA200530105.md): Skin · peeling · Oct 25, 2005 · N720AE · Emb EMB135LR · Engine Thrust Reverser
  > DURING MBV INSPECTION, FOUND RIGHT THRUST REVERSER OUTBOARD MIDDLE SKIN PEELING BACK ON LEADING EDGE. INSTALLED NEW RIGHT THRUST REVERSER OUTBOARD MIDDLE SKIN IAW EMB SRM 51-40-02. AIRCRAFT WAS RETURNED TO SERVICE. (M)
- [SDR SIMA200530104](https://openairdocs.org/sdr/SIMA200530104.md): Doubler · corroded · Oct 25, 2005 · N720AE · Emb EMB135LR · Fuselage Miscellaneous Structure
  > DURING MBV INSPECTION, FOUND LEFT OMEGA RIGHT SIDE DOUBLER AT FRAME 20 IS CORRODED. INSTALLED NEW DOUBLER IAW SRM 53-00-10. AIRCRAFT WAS RETURNED TO SERVICE. (M)
- [SDR SIMA200530103](https://openairdocs.org/sdr/SIMA200530103.md): Profile · corroded · Oct 25, 2005 · N720AE · Emb EMB135LR · Fuselage Miscellaneous Structure
  > SAW - DURING MBV INSPECTION, FOUND PROFILE Z AT FRAME 22 IS CORRODED. INSTALLED NEW PROFILE Z IAW SRM 51-40-02. AIRCRAFT WAS RETURNED TO SERVICE. (M)
- [SDR SIMA200530102](https://openairdocs.org/sdr/SIMA200530102.md): Floor Support · corroded · Oct 25, 2005 · N720AE · Emb EMB135LR · Fuselage Miscellaneous Structure
  > SAW - DURING MBV INSPECTION, FOUND LEFT FLOOR SUPPORT RAMP BETWEEN FRAMES 19 AND 20 IS CORRODED. INSTALLED NEW FLOOR SUPPORT RAMP IAW EMB SRM 5-40-02. AIRCRAFT WAS RETURNED TO SERVICE. (M)
- [SDR SIMA200530101](https://openairdocs.org/sdr/SIMA200530101.md): Floor Support · corroded · Oct 25, 2005 · N720AE · Emb EMB135LR · Fuselage Miscellaneous Structure
  > SAW - DURING MBV INSPECTION, FOUND RIGHT FLOOR SUPPORT RAMP BETWEEN FRAMES 19 AND 20 IS CORRODED. INSTALLED NEW FLOOR SUPPORT RAMP IAW EMB SRM 51-40-02. AIRCRAFT WAS RETURNED TO SERVICE. (M)
- [SDR SIMA200412704](https://openairdocs.org/sdr/SIMA200412704.md): Odor · detected · May 1, 2004 · N720AE · Emb EMB135LR · Air Distribution System
  > JFK - FLT 4754 - DURING CLIMB, CREW REPORTED A STRONG BURNING ODOR IN COCKPIT. AIRCRAFT WAS RETURNED TO JFK AND LANDED WITH NO FURTHER INCIDENTS REPORTED. MAINTENANCE COULD NOT DUPLICATE DISCREPANCY. AN OPERATIONAL CHECK OF THE PACKS WAS GOOD AND AIRCRAFT W
- [SDR SIMA200408802](https://openairdocs.org/sdr/SIMA200408802.md): Control Unit · faulty · Mar 26, 2004 · N720AE · Emb EMB135LR · Stabilizer Control System
  > BNA- FLT 4856 - CREW REPORTED A DUAL PITCH TRIM FAIL ON DESCENT. AUTOPILOT WAS ON AND DID NOT TOUCH ANYTHING. RECEIVED FAILURE OF MAIN AND BACK UP PITCH TRIM AND 16000 FT. AFTER LANDING CYCLED C/B AND FAILURE WENT AWAY. MAINTENANCE REMOVED AND REPLACED THE
- [SDR SIMA200326506](https://openairdocs.org/sdr/SIMA200326506.md): Stringer · chafed · Sep 16, 2003 · N720AE · Emb EMB135LR · Fuselage Main, Longeron/Stringer
  > ABI - DURING AN IMBV INSPECTION, FOUND STRINGER 19R WAS FOUND TO BE CHAFED BEYOND SRM LIMITS AFT OF FRAME 52. COMPLETELY REMOVED CHAFED BY BLENDING AREA. PERFORMED AN EDDY CURRENT INSPECTION OF THE BLENDED AREA. NO DEFECTS NOTED. FABRICATED ON REPAIR ANGLE
- [SDR SIMA200326505](https://openairdocs.org/sdr/SIMA200326505.md): Floorbeam · corroded · Sep 12, 2003 · N720AE · Emb EMB135LR · Fuselage Main, Floor Beam
  > ABI - DURING AN IMBV INSPECTION, THE TOP OF THE CENTER OMEGA BEAM WAS FOUND TO BE CORRODED BELOW SRM LIMITS AT FRAME 20 REMOVED CORROSION BY CREATING A CUT OUT IN THE OTP OF THE CENTER OMEGA BEAM AT FRAME 20. FABRICATED A U-SHAPED EXTERNAL DOUBLER. REPAIR DO
- [SDR SIMA200226106](https://openairdocs.org/sdr/SIMA200226106.md): Windshield · malfunctioned · Sep 16, 2002 · N720AE · Emb EMB135LR · Windshield/Door Rain/Ice Removal
  > JFK - FLT 4548 - CREW REPORTED A NOTICEABLE BURNING SMELL IN THE COCKPIT STARTING DURING CLIMB-OUT. AT APPROXIMATELY 14,000 FEET THE SMELL VARIED FROM VERY STRONG TO BARELY NOTICEABLE WITH NO VISIBLE SMOKE SEEN. THE CREW DIVERTED TO JFK AND LANDED WITH NO FU
- [SDR SIMA200208304](https://openairdocs.org/sdr/SIMA200208304.md): Beam · corroded · Feb 25, 2002 · N720AE · Emb EMB135LR · Fuselage Miscellaneous Structure
  > ABI - THIS IS LEVEL 2 FINDING. CORROSION FOUND ON GALLEY RIGHT BEAM. RESTORED PROTECTIVE COATING, DAMAGE ACCEPTED AS IS IAW EMB GST-0636/02. (M)
- [SDR SIMA200208301](https://openairdocs.org/sdr/SIMA200208301.md): Floorbeam · corroded · Feb 25, 2002 · N720AE · Emb EMB135LR · Fuselage Main, Floor Beam
  > THIS IS A LEVEL 2 FINDING. CORROSION GALLEY FORWARD DIGITAL. RESTORED PROTECTIVE COATING, DAMAGE ACCEPTED AS IS IAW EMB GST-0634/02. (M)
- [SDR SIMA200208302](https://openairdocs.org/sdr/SIMA200208302.md): Gusset · corroded · Feb 25, 2002 · N720AE · Emb EMB135LR · Fuselage Miscellaneous Structure
  > ABI - THIS IS A LEVEL 2 FINDING. CORROSION GALLEY CENTER BEAM GUSSET. RESTORED PROTECTIVE COATING, DAMAGE ACCEPTED AS IS IAW EMB GST-0636/02. (M)
- [SDR SIMA20011041](https://openairdocs.org/sdr/SIMA20011041.md): Engine · overtemp · Apr 14, 2001 · N720AE · Emb EMB145LR · Engine (Turbine/Turboprop)
  > CHA - FLT 4418 - CREW REPORTED TO FIELD DUE TO NR 1 ENGINE TRYING TO OVERTEMP. AT CLIMB, NR 1 ENGINE WAS AT 800 DEGREES AND THE NR 2 AT 697 DEGREES. (M)
- [SDR SIMA2332](https://openairdocs.org/sdr/SIMA2332.md): Smoke Detector · inoperative · Aug 20, 2000 · N720AE · Emb EMB145LR · Smoke Detection
  > BOS - FLT 5056 - LAVATORY FIRE INDICATION ON F/A PANEL 5 MINUTES AFTER TAKEOFF. PUT ON MEL. MAINTENANCE REMOVED AND REPLACED LAVATORY SMOKE DETECTOR IAW EMB MM. OPERATIONAL CHECK WAS GOOD AND AIRCRAFT WAS RETURNED TO SERVICE. (M)

## 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 = 'N720AE' AND deregistration_id = 'N720AE-2019-09-09'
ORDER BY difficulty_date DESC
```

This list as a web page: https://openairdocs.org/deregistered/N720AE-2019-09-09/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.