# Service difficulty reports: N80057, cancelled Oct 21, 2009 A list on [N80057, cancelled Oct 21, 2009](https://openairdocs.org/deregistered/N80057-2009-10-21.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 · 72 reports - [SDR AALA200801554](https://openairdocs.org/sdr/AALA200801554.md): Lamp · inoperative · Jun 6, 2008 · N80057 · Airbus A300B4605R · Emergency Lighting > JFK - EMERGENCY EXIT SIGN LIGHT AT LT NR FOUR DOOR INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT LT NR FOUR DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (A) - [SDR AALA200801553](https://openairdocs.org/sdr/AALA200801553.md): Light · inoperative · Jun 6, 2008 · N80057 · Airbus A300B4605R · Emergency Lighting > JFK - EMERGENCY EXIT SIGN LIGHT AT RT NR THREE DOOR INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT RT NR THREE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (A) - [SDR AALA200801552](https://openairdocs.org/sdr/AALA200801552.md): Lamp · inoperative · Jun 6, 2008 · N80057 · Airbus A300B4605R · Emergency Lighting > JFK - EMERGENCY EXIT SIGN LIGHT AT RT NR TWO DOOR INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT RT NR TWO DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (A) - [SDR AALA200801551](https://openairdocs.org/sdr/AALA200801551.md): Lamp · inoperative · Jun 6, 2008 · N80057 · Airbus A300B4605R · Emergency Lighting > JFK - EMERGENCY EXIT SIGN LIGHT AT LT NR TWO DOOR INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT LT NR TWO DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (A) - [SDR AALA200801550](https://openairdocs.org/sdr/AALA200801550.md): Lamp · inoperative · Jun 6, 2008 · N80057 · Airbus A300B4605R · Emergency Lighting > JFK - EMERGENCY EXIT SIGN LIGHT AT RT NUMBER ONE DOOR INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT RT NUMBER ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (A) - [SDR AALA200801549](https://openairdocs.org/sdr/AALA200801549.md): Lamp · inoperative · Jun 6, 2008 · N80057 · Airbus A300B4605R · Emergency Lighting > JFK - EMERGENCY EXIT LIGHT AT LT NR ONE DOOR AISLE INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT LT NR ONE DOOR AISLE. SYSTEM GROUND CHECKED NORMAL OPERATION. (A) - [SDR AALA200801548](https://openairdocs.org/sdr/AALA200801548.md): Lamp · inoperative · Jun 6, 2008 · N80057 · Airbus A300B4605R · Emergency Lighting > JFK - EMERGENCY EXIT SIGN LIGHT AT LT NUMBER ONE DOOR INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT LT NUMBER ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (A) - [SDR AALA200801379](https://openairdocs.org/sdr/AALA200801379.md): Battery Pack · inoperative · May 24, 2008 · N80057 · Airbus A300B4605R · Emergency Lighting > SJU - EMERGENCY LIGHT AT LT SEAT ROWS 19 TO 28 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT LT SEAT ROWS 19 TO 28. SYSTEM GROUND CHECKED NORMAL OPERATION. (A) - [SDR AALA200800949](https://openairdocs.org/sdr/AALA200800949.md): Battery Pack · inoperative · Apr 13, 2008 · N80057 · Airbus A300B4605R · Emergency Lighting > MIA - EMERGENCY LIGHTS AT SEAT ROWS 7C TO 18C INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT SEAT ROWS 7C TO 18C. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA200800948](https://openairdocs.org/sdr/AALA200800948.md): Connector · loose · Apr 13, 2008 · N80057 · Airbus A300B4605R · Light System Wiring > MIA - EMERGENCY LIGHT AT SEAT 31G INOPERATIVE. RESEATED CONNECTOR FOR EMERGENCY LIGHT AT SEAT 31G. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20072239](https://openairdocs.org/sdr/AALA20072239.md): Light · inoperative · Nov 17, 2007 · N80057 · Airbus A300B4605R · Emergency Lighting > JFK - EMERGENCY EXIT SIGN LIGHT AT OVERHEAD LEFT NUMBER TWO DOOR LENS INOPERATIVE. REPLACED LENS FOR EMERGENCY LIGHT AT OVERHEAD LEFT NUMBER TWO DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20072238](https://openairdocs.org/sdr/AALA20072238.md): Light · inoperative · Nov 17, 2007 · N80057 · Airbus A300B4605R · Emergency Lighting > JFK - EMERGENCY EXIT SIGN LIGHT AT OVERHEAD LEFT NUMBER TWO DOOR INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT OVERHEAD LEFT NUMBER TWO DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20072220](https://openairdocs.org/sdr/AALA20072220.md): Light · inoperative · Nov 15, 2007 · N80057 · Airbus A300B4605R · Emergency Lighting > JFK - EMERGENCY LIGHT AT LEFT NUMBER ONE DOOR INOPERATIVE. REPLACED LAMPS FOR EMERGENCY LIGHT AT LEFT NUMBER ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20072219](https://openairdocs.org/sdr/AALA20072219.md): Light · inoperative · Nov 15, 2007 · N80057 · Airbus A300B4605R · Emergency Lighting > JFK - EMERGENCY LIGHT AT LEFT NUMBER FOUR DOOR INOPERATIVE. REPLACED LAMPS FOR EMERGENCY LIGHT AT LEFT NUMBER FOUR DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20072218](https://openairdocs.org/sdr/AALA20072218.md): Light · inoperative · Nov 15, 2007 · N80057 · Airbus A300B4605R · Emergency Lighting > JFK - EMERGENCY LIGHT AT RIGHT NUMBER FOUR DOOR INOPERATIVE. REPLACED LAMPS FOR EMERGENCY LIGHT AT RIGHT NUMBER FOUR DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20072222](https://openairdocs.org/sdr/AALA20072222.md): Light · inoperative · Nov 15, 2007 · N80057 · Airbus A300B4605R · Emergency Lighting > JFK - EMERGENCY LIGHT AT LEFT NUMBER TWO DOOR INOPERATIVE. REPLACED LAMPS FOR EMERGENCY LIGHT AT LEFT NUMBER TWO DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20072221](https://openairdocs.org/sdr/AALA20072221.md): Light · inoperative · Nov 15, 2007 · N80057 · Airbus A300B4605R · Emergency Lighting > JFK - EMERGENCY LIGHT AT RIGHT NUMBER TWO DOOR INOPERATIVE. REPLACED LAMPS FOR EMERGENCY LIGHT AT RIGHT NUMBER TWO DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20072223](https://openairdocs.org/sdr/AALA20072223.md): Light · inoperative · Nov 15, 2007 · N80057 · Airbus A300B4605R · Emergency Lighting > JFK - EMERGENCY LIGHT AT RIGHT NUMBER ONE DOOR INOPERATIVE. REPLACED LAMPS FOR EMERGENCY LIGHT AT RIGHT NUMBER ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20071722](https://openairdocs.org/sdr/AALA20071722.md): Battery Pack · inoperative · Sep 10, 2007 · N80057 · Airbus A300B4605R · Emergency Lighting > JFK - EMERGENCY LIGHT AT AFT CABIN RIGHT SIDE INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT AFT CABIN RIGHT SIDE. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20071614](https://openairdocs.org/sdr/AALA20071614.md): Servo Valve · inoperative · Aug 24, 2007 · N80057 · Airbus A300B4605R · Drag Control System > MIA INFLIGHT T1075/24AUG MCO - SJU EXPERIENCED VIBRATIONS AND FOUND THE NUMBER FIVE SPOILER WAS FLOATING. TURNED OFF YELLOW SERVO CONTROLLER AND VIBRATIONS STOPPED BUT NUMBER THREE SPOILLER POPPED. DECLARED AN EMERGENCY AND DIVERTED IN MIA. LANDED WITHOUT - [SDR AALA20070517](https://openairdocs.org/sdr/AALA20070517.md): Light · missing · Mar 19, 2007 · N80057 · Airbus A300B4605R · Emergency Lighting > MIA - EMERGENCY LIGHT AT SEAT 3G MISSING. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT SEAT 3G. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20061386](https://openairdocs.org/sdr/AALA20061386.md): Light · inoperative · Dec 26, 2006 · N80057 · Airbus A300B4605R · Emergency Lighting > MIA - EMERGENCY LIGHT AT SEAT 14C INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 14C. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20061387](https://openairdocs.org/sdr/AALA20061387.md): Connector · loose · Dec 26, 2006 · N80057 · Airbus A300B4605R · Light System Wiring > MIA - EMERGENCY LIGHT AT SEAT 7G INOPERATIVE. SECURED CONNECTOR FOR EMERGENCY LIGHT AT SEAT 7G. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20060220](https://openairdocs.org/sdr/AALA20060220.md): Elbow · leaking · Apr 9, 2006 · N80057 · Airbus A300B4605R · Hydraulic System, Main > JFK - INFLIGHT AFTER TWO HOURS GREEN HYDRAULIC QUANTITY WENT TO ZERO. MANUALLY LOWERED LANDING GEAR. AFTER GEAR EXTENSION GREEN HYDRAULIC QUANTITY WENT UP BUT STILL BELOW MINIMUM. HYDRAULIC PRESSURE NORMAL. LANDED JFK WITHOUT INCIDENT. AIRCRAFT OUT OF SER - [SDR AALA20060123](https://openairdocs.org/sdr/AALA20060123.md): Pump · inoperative · Feb 25, 2006 · N80057 · Airbus A300B4605R · Hydraulic Pump (Electric/Engine), Main > YELLOW HYDRAULIC SYSTEM RESEVOIR OVERHEAD ILLUMINATED FOLLOWED BY ECAM INDICATION. OVERHEAT WENT OUT TEN MINUTES AFTER PUMP WAS TURNED OFF. LANDED MIA WITHOUT INCIDENT. REPLACED PUMP AND FILTER ELEMENTS. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20040729](https://openairdocs.org/sdr/AALA20040729.md): Battery Pack · inoperative · Jul 16, 2004 · N80057 · Airbus A300B4605R · Emergency Lighting > EMERGENCY EXIT LIGHT DID NOT TEST. REPLACED EMERGENCY LIGHT BATTERY PACK FOR EMERGENCY EXIT LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20040503](https://openairdocs.org/sdr/AALA20040503.md): Skin · corroded · Apr 28, 2004 · N80057 · Airbus A300B4605R · Wing, Plate/Skin > TUL LEFT HAND UPPER WING SKIN PANEL NUMBER 2 HAS A CRACK FROM FASTNER AT RIB 4, INBOARD FASTNER THIRD ROW AFT OF JOINT. CRACK LENGTH IS 0.821 AND 0.255 AT A DEPTH OF 0.167. INSTALLED DOUBLER PER AIR BUS DRAWING R57340132. CRACK REPAIRED PER ESO 30595 DATED 0 - [SDR AALA20040502](https://openairdocs.org/sdr/AALA20040502.md): Battery Box · corroded · Apr 26, 2004 · N80057 · Airbus A300B4605R · Battery Box Structure > TUL CORROSION FOUND ON FORWARD SIDE OF AIRCRAFT EXTERNAL POWER BOX CENTERLINE BETWEEN FRAME 18 AND FRAME 19 AT STATION 1340. REPAIRED POWER BOX PER ESO 30595 DATED 4/26/04. (CLOSED) - [SDR AALA20040433](https://openairdocs.org/sdr/AALA20040433.md): Shear Tie · corroded · Apr 2, 2004 · N80057 · Airbus A300B4605R · Fuselage Main, Structure > TUL - SHEAR TIE ON FRAME 18 AT STATION 1340 HAS 2 INCH BY 2 INCH SECTION OF CORROSION. REPAIRED FRAME 18 AT SECTION 1340 PER SRM 53-10-13. - [SDR AALA20040432](https://openairdocs.org/sdr/AALA20040432.md): Frame · corroded · Apr 2, 2004 · N80057 · Airbus A300B4605R · Fuselage Main, Frame > TUL - SHEAR TIE ON FRAME 18 AT STATION 1340 HAS A 2 INCH BY 2 INCH SECTION OF CORROSION. REPAIRED FRAME 18 AT STATION 1340 PER SRM 53-10-13. - [SDR AALA20031219](https://openairdocs.org/sdr/AALA20031219.md): Battery Pack · inoperative · Nov 5, 2003 · N80057 · Airbus A300B4605R · Emergency Lighting > JFK - DURING OVERNIGHT MAINTENANCE, FOUND EMERGENCY LIGHTS AT DOOR 2R AND RIGHT FIRST CLASS SEAT LIGHTS INOPERATIVE. REPLACED DOOR 2R AND RIGHT FIRST CLASS SEAT LIGHT BATTERY PACK. SYSTEM GROUND CHECKED NORMAL OPERATION. (M) - [SDR AALA20030829](https://openairdocs.org/sdr/AALA20030829.md): Computer · failed · Aug 3, 2003 · N80057 · Airbus A300B4605R · Fuel Quantity Sensor > EN ROUTE ALL FUEL QUANTITY INDICATIONS FAILED. AIRCRAFT DIVERTED MIA AND LANDED WITHOUT INCIDENT. REPLACED FUEL QTY PROCESSOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (M) - [SDR AALA20020917](https://openairdocs.org/sdr/AALA20020917.md): Switch · intermittent · Jun 18, 2002 · N80057 · Airbus A300B4605R · Emergency Lighting > MIA - TOILET EMERGENCY LIGHT CIRCUIT BREAKER POPPED. TROUBLESHOT FAULT TO AN EMERGENCY LIGHT SWITCH INTERMITTENT FAULT. REPLACED SWITCH ASSEMBLY. SYSTEM GROUND CHECK NORMAL OPERATION. (M) - [SDR AALA20020202](https://openairdocs.org/sdr/AALA20020202.md): Ballast · defective · Mar 1, 2002 · N80057 · Airbus A300B4605R · Passenger Compartment Lighting > MIA - FLT 915 - EN ROUTE MIA-BOG - DETECTED SMOKE IN CABIN. RETURNED MIA AND LANDED WITHOUT FURTHER INCIDENT. REPLACED BALLAST NR 5, 6, AND 7. PERFORMED INSPECTION OF AFT GALLEY OVERHEAD PANEL. NO DEFECTS NOTED. SYSTEM GROUND CHECKED NORMAL OPERATION. (M - [SDR AALA991812](https://openairdocs.org/sdr/AALA991812.md): Roller Tray · corroded · Nov 29, 1999 · N80057 · Airbus A300B4605R · Fuselage, Seat/Cargo Attach Fittings > TUL - FOUND CORROSION ON BOTTOM OF NR 1 ROLLER TRAY AT FRAME 58 IN AFT CARGO COMPARTMENT. REMOVED CORRODED ROLLER TRAY AND INSTALLED NEW ROLLER TRAY FROM FRAME 58 TO FRAME 63 IAW SRM 51-72-10. (M) - [SDR AALA991811](https://openairdocs.org/sdr/AALA991811.md): Roller Tray · corroded · Nov 29, 1999 · N80057 · Airbus A300B4605R · Fuselage, Seat/Cargo Attach Fittings > TUL - FOUND CORROSION ON BOTTOM OF NR 3 ROLLER TRAY AT FRAME 58. REMOVED AND REPLACED NR 3 ROLLER TRAY FROM FRAME 58 TO FRAME 63 IAW SRM 51-72-10. (M) - [SDR AALA991810](https://openairdocs.org/sdr/AALA991810.md): Roller Tray · corroded · Nov 29, 1999 · N80057 · Airbus A300B4605R · Fuselage, Seat/Cargo Attach Fittings > TUL - CORROSION ON BOTTOM NR 5 ROLLER TRAY FRAMES 56 AND 58. REMOVED AND REPLACED NR 5 ROLLER TRAY FROM FRAME 56 TO FRAME 63 IAW SRM 57-72-10. (M) - [SDR AALA991809](https://openairdocs.org/sdr/AALA991809.md): Stiffener · cracked · Nov 29, 1999 · N80057 · Airbus A300B4605R · Fuselage Miscellaneous Structure > TUL - VERTICAL STIFFENERS IS CRACKED ON RIGHT CONNECTING FITTING IN NLG BAY BET FRAME 13A AND FRAME 14. BLENDED CRACK WITHIN MAX BLEND DEPTH OF.314, RESULTANT BLEND IS ACCEPTALE FOR AN ADDITIONAL 3.300 FC BEFORE PERMANENT REPAIRS ARE REQ IAW S/B 53-6102 AND - [SDR AALA991786](https://openairdocs.org/sdr/AALA991786.md): Roller Tray · corroded · Nov 26, 1999 · N80057 · Airbus A300B4605R · Fuselage, Seat/Cargo Attach Fittings > TUL - FOUND CORROSION ON BOTTOM AND TOP OUTBOARD AFT CORNER OF NR 5 ROLLER TRAY AT FRAME 58. REMOVED CORROSION AND SPLICED IN NEW SECTION OF ROLLER TRAY IAW 51-74-01 AND 53-10-15-2 BOTH OF THE SRM. (M) - [SDR AALA991807](https://openairdocs.org/sdr/AALA991807.md): Stringer · corroded · Nov 23, 1999 · N80057 · Airbus A300B4605R · Fuselage Main, Longeron/Stringer > TUL - STRINGER 50R IS CORRODED FROM FRAME 60 TO FRAME 62. REMOVED CORROSION AND INSTALLED REPAIR ANGLE PER SRM 53-10-14 AND ESO30595 DATED 11-22-99. (M) - [SDR AALA991806](https://openairdocs.org/sdr/AALA991806.md): Sill · corroded · Nov 23, 1999 · N80057 · Airbus A300B4605R · Fuselage Miscellaneous Structure > TUL - FOUND CORROSION ON AFT CX DOOR JAMB LOWER SILL BEAM FROM FRAME 59 TO FRAME 63. REMOVED CORROSION INSTALLED SILL BEAM REPAIR AT FRAME 60 IAW SRM 53-17-18 AND ESO 30595 DATED 11-17-99 AND DATED 11-22-99, OTHER BLENDOUTS THAT WERE OUT OF LIMITS PER SRM ARE - [SDR AALA991808](https://openairdocs.org/sdr/AALA991808.md): Floorbeam · corroded · Nov 22, 1999 · N80057 · Airbus A300B4605R · Fuselage Main, Floor Beam > TUL - FOUND CORROSION ON AFT SIDE OF FLOORBEAM AT FRAME 38.2 BETWEEN NR 4 AND NR 5 ROLLER TRAYS. REMOVED AND REPLACED FLOORBEAM AT FRAME 38.2 PER SRM 51-72-10. (M) - [SDR AALA991760](https://openairdocs.org/sdr/AALA991760.md): Stringer · corroded · Nov 21, 1999 · N80057 · Airbus A300B4605R · Fuselage Main, Longeron/Stringer > TUL - FOUND CORROSION ON STRINGER 52L AT FRAME 62. INSTALLED NEW REPAIR STRINGER ON 52L AT FRAME 62 PER ESO 30595, DATED 11-19-99. (M) - [SDR AALA991763](https://openairdocs.org/sdr/AALA991763.md): Stringer · corroded · Nov 19, 1999 · N80057 · Airbus A300B4605R · Fuselage Main, Longeron/Stringer > TUL - FOUND STRINGER 52L IS CORRODED BELOW FRAME 64. REMOVED CORROSION AND INSTALLED REPAIR SPLICE IAW SRM 53-10-14. (M) - [SDR AALA991753](https://openairdocs.org/sdr/AALA991753.md): Splice · corroded · Nov 18, 1999 · N80057 · Airbus A300B4605R · Fuselage Miscellaneous Structure > TUL - FOUND CORROSION ON STRINGER SPLICES AT STRINGER 45L, 46L, AND 47L IN AREA OF FRAME 72. REMOVED AND REPLACED STRINGER SPLICES AT STRINGER 45L, 46L, AND 47L AT FRAME 72. (M) - [SDR AALA991698](https://openairdocs.org/sdr/AALA991698.md): Stringer · corroded · Nov 12, 1999 · N80057 · Airbus A300B4605R · Fuselage Main, Longeron/Stringer > TUL - LEVEL 2 CORROSION BEYOND LIMITS. REMOVED AND REPLACED STRINGER SECTION FROM STATION 54.1 TO 54.3 AS PER SRM 53-10-14. (M) - [SDR AALA991686](https://openairdocs.org/sdr/AALA991686.md): Frame · corroded · Nov 10, 1999 · N80057 · Airbus A300B4605R · Fuselage Main, Frame > TUL - LEVEL 2 CORROSION BEYOND LIMITS. COMPLETED A STRINGER SPLICE IAW SRM 53-10-14-2. (M) - [SDR AALA991680](https://openairdocs.org/sdr/AALA991680.md): Fitting · corroded · Nov 9, 1999 · N80057 · Airbus A300B4605R · Fuselage Miscellaneous Structure > TUL - LEVEL 2 WIDESPREAD CORROSION ON FITTING AND FRAME. REMOVED AND REPLACED FITTING PER 51-72-10. (M) - [SDR AALA991679](https://openairdocs.org/sdr/AALA991679.md): Frame · corroded · Nov 9, 1999 · N80057 · Airbus A300B4605R · Fuselage Main, Frame > TUL - LEVEL 2 WIDESPREAD CORROSION ON FITTING AND FRAME. REMOVED AND REPLACED FITTING PER 51-72-10. (M) - [SDR AALA990644](https://openairdocs.org/sdr/AALA990644.md): Connector · loose · May 2, 1999 · N80057 · Airbus A300B4605R · Emergency Lighting > SJU - EMERGENCY EXIT SIGN AT 2L DOOR INOPERATIVE. MAINTENANCE FOUND CANNON PLUG LOOSE AT BATTERY PACK. RESEAT CANNON PLUG AT BATTERY PACK. SYSTEM GROUND CHECKED NORMAL OPERATION. (M) Next page: https://openairdocs.org/deregistered/N80057-2009-10-21/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 = 'N80057' AND deregistration_id = 'N80057-2009-10-21' ORDER BY difficulty_date DESC ``` This list as a web page: https://openairdocs.org/deregistered/N80057-2009-10-21/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.