N457AA, cancelled Jan 16, 2023
Service difficulty reports · 41
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.
Query with SQL
duckdb -csv -c "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 = 'N457AA' AND deregistration_id = 'N457AA-2023-01-16' ORDER BY difficulty_date DESC"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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 = 'N457AA' AND deregistration_id = 'N457AA-2023-01-16' ORDER BY difficulty_date DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
SDR AALA20140924009Cusp Web · corrodedCORROSION ON UNDERSIDE OF LT CUSP AROUND HOLE STATION 1200. REMOVED CORROSION & INSTALLED REPAIR DOUBLER IAW 53-20-00-16.SDR AALA20100725DFW08Trim Motor · inoperativeDFW - PRIMARY LONGITUDINAL TRIM INOPERATIVE AFTER TAKEOFF. ALTERNATE TRIM WORKED AND PRIMARY TRIM DID NOT WORK USING NOSE DOWN. EMERGENCY DECLARED LANDED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED PRIMARY STAB TRIM MOTOR AND CAPTAINS PRISDR AALA20090902TUL18Battery Pack · dischargedEMERGENCY LIGHT BATTERY IS DEAD. REPLACED UNDER MM 33-60-98-4.SDR AALA20090902TUL17Battery Pack · dischargedDEAD BATTERY. REPLACED PER MM 33-60-98-4.SDR AALA20090902TUL16Battery Pack · activatedEMERGENCY LIGHT BATTERY PACK IS WEAK. REPLACED UNDER MM 33-60-98-4.SDR AALA20090902TUL15Module · defectiveEMERGENCY LIGHT BATTERY PACK MODULE INTERMITTENT. INSTALLED SERVICEABLE MODULE PER MM 33-60-98-4.SDR AALA20090902TUL11Portable Light · inoperativeEMERGENCY PORTABLE LIGHT AT EXTERNAL POWER CONTACTOR INOPERATIVE. REPLACED LIGHT, OPS CHECK GOOD.SDR AALA20090827TUL01Vane · wornWORN AREA ON OUTBOARD FLAP VANE NEXT TO FLEX JOINT. INSTALLED HOT-BOND DOUBLER PER SRM-51-70-02.SDR AALA20090826TUL09Vane · wornWORN AREA ON LEADING EDGE OF INBOARD FLAP VANE AT INBOARD AREA. INSTALLED HOT BOND DOUBLER UNDER SRM-51-70-02.SDR AALA200800708Battery Pack · inoperativeLGA - EMERGENCY LIGHT AT FIRST CLASS GALLEY EXIT SIGN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT FIRST CLASS GALLEY EXIT SIGN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070221Bulb · missingORD - FOUND EMERGENCY LIGHT AT SEAT 24D HAS MISSING LAMP. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 24D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070220Lens · missingORD - FOUND EMERGENCY LIGHT AT SEAT 24D HAS MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 24D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070219Shield · missingORD - FOUND EMERGENCY LIGHT AT SEAT 24D HAS MISSING SHIELD. REPLACED SHIELD FOR EMERGENCY LIGHT AT SEAT 24D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070218Bulb · missingORD EMERGENCY LIGHT AT SEAT 19D HAS MISSING LAMP. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 19D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070217Lens · missingORD - FOUND EMERGENCY LIGHT AT SEAT 19D HAS MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 19D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070216Shield · missingORD - FOUND EMERGENCY LIGHT AT SEAT 19D HAS MISSING SHIELD. REPLACED SHIELD FOR EMERGENCY LIGHT AT SEAT 19D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050839Piston · inoperativeORD - UNABLE TO RAISE LANDING GEAR AFTER TAKEOFF. NOSE WHEEL STEERING INDEX CENTERED BUT NOSE WHEEL WOULD NOT TURN. RETURNED TO ORD AND LANDED WITHOUT INCIDENT. REPLACED NOSE LANDING GEAR STRUT PISTON. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050794Handle · inoperativeAFTER TAKEOFF, LANDING GEAR WOULD NOT RETRACT. HANDLE WOULD NOT COME UP. FOLLOWED QRH. NOSE WHEEL WAS STEERABLE. LANDED ORD WITHOUT INCIDENT. ACCOMPLISHED WORK CARD 32-96-14. NO DEFECTS NOTED. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040595Battery Pack · dischargedDFW - EMERGENCY LIGHTS IN CEILING AT ROW 8 ARE INOPERATIVE. REPLACED BATTERY PACK AND CHARGER FOR EMERGENCY LIGHTS IN CEILING AT ROW 8. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040450Slide · failedDFW - AFT LEFT HAND GALLEY DOOR IN ARMED POSITION AND WHEN DOOR OPENED BY CABIN SERVICES SLIDE PARTIALLY DEPLOYED AND CAME OUT OF SLIDE CASE BUT DID NOT INFLATE. REPLACED SLIDE FOR AFT LEFT HAND GALLEY DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040407Pin · detachedDFW - AIRSTAIR EMERGENCY CEILING LIGHT INOPERATIVE. REINSTALLED PIN AND QUICK DISCONNECT ON WIRE FOR AIRSTAIR EMERGENCY CEILING LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20030968Wire · brokenDFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT LIGHTS WERE INOPERATIVE AT SEAT 26G. REPAIRED BROKEN WIRE AT CONNECTOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20021642Frame · wornTUL - FOUND FRAME LANDING IS WORN FROM CONTACT WITH APU ACCESS DOOR STATION 1380 AT LONGERON 28L. INSTALLED DOUBLER PER AARD 53-10-00-34. (M)SDR AALA20021647Frame · wornTUL - FOUND FRAME LANDING IS WORN FROM CONTACT WITH APU ACCESS DOOR STATION 1380 AT LONGERON 28R. INSTALLED DOUBLER PER AARD 53-10-00-34. (M)SDR AALA20021637Web · corrodedTUL - FOUND CUSP CRACKED AT EDGE OF 2ND LIGHTENING HOLE FORWARD OF 1309 BULKHEAD LEFT. FOUND CORROSION ALONG CUSP ATTACH FASTENERS. FOUND CORROSION 4 INCHES FORWARD OF 1309. INSTALLED NEW CUSP LEFT STATION 1250 TO 1309 REF SRM 53-00-00 FIG 97 SHEET 1. (M)SDR AAL2003F00015Web · crackedSUBFLOOR WEB CRACKED UNDER NR 5 SEAT TRACK, STA 216. 4 INCH X 4 INCH AREA 1 INCH LENGTH. FABRICATED DOUBLER OUT OF 7075-T6 AND INSTALLED IAW AARD.SDR AALA20021636Longeron · crackedTUL - FOUND CRACKED LONGERON AT FASTENER HOLES, TO RADIUS AND ALONG RADIUS, APPROX .5 INCH BOTH SIDES. PREVIOUS REPAIR NO RADIUS BLOCKS USED, OR SHIMS. APPROXIMATELY 2 FEET OF FORWARD END OF NR 3L LONGERON REMOVED AND NEW PIECE REPLACED WITH SPLICE AND RADIUSDR AALA20021635Door Frame · corrodedTUL - FOUND SEVERAL CORRODED AREAS ON LOWER DOOR BEAM. INSTALLED DOUBLER ON DOOR BEAM PER SRM 53-10-00-03. (M)SDR AALA20021640Longeron · crackedTUL - FOUND CRACK IN RADIUS OF LONGERON, AT AREA OF FASTENER TO FRAME. APPROX 2 FEET REMOVED FORWARD END AND NEW PIECE INSTALLED WITH SPLICE REPAIR. (M)SDR AALA20021639Seat Track · corrodedTUL - FOUND NR 3 SEAT TRACK HAS PITTING AT STATION 673. INSTALLED SEAT TRACK PLUG PER AARD 53-20-00-10. (M)SDR AALA20021638Seat Track · corrodedTUL - FOUND CORROSION NR 3 SEAT TRACK. INSTALLED SEAT TRACK PLUG PER AARD 53-20-00-10 REPAIR NR 10. (M)SDR AALA20011690Battery Pack · dischargedDFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY CEILING LIGHTS OVER ROW 14 DIM. REPLACED BATTERY PACK. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20011692Battery Pack · inoperativeDFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY LIGHTS OVER AFT STAIRS DIMS. REPLACED BATTERY PACK. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20002054Connector · damagedDFW - DURING OVERNIGHT MAINTENANCE, TAILCONE EMERGENCY EXIT LIGHT AT SIDE WALL INOPERATIVE. REPAIRED TAILCONE EMERGENCY EXIT WIRE AT SIDE WALL. REPLACED TAILCONE EMERGENCY EXIT LIGHT CONNECTOR AT SIDE WALL. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA991120Longeron · crackedTUL - NR 3 LONG LEFT CRACKED AT STATION 160. REMOVED DAMAGED LONG NR 3 SECTION. INSTALLED LONG SPLICE FITTING PER SRM 53-02 FIG 18. (M)SDR AALA991119Seat Track · corrodedTUL - NR 2 CABIN SEAT TRACK CORRODED IN CTR AND AROUND LUGS AT STATION 1201. ROUTED OUT CORRODED AREA OF TRACK. INSTALLED REPAIR PLUG PER SRM 53-05 FIG 4B. (M)SDR AALA991118Seat Track · gougedTUL - NR 1 SEAT TRACK GOUGED IN CENTER TOP SURFACES AT STATION 486. ROUTED OUT DAMAGED AREA. INSTALLED REPAIR PLUG PER SRM 53-05 FIG 4B. (M)SDR AALA991117Seat Track · gougedTUL - NR 1 SEAT TRACK GOUGED IN CENTER TOP SURFACE AT STATION 703. ROUTED OUT DAMAGED AREA OF TRACK. INSTALLED REPAIR PLUG PER SRM 53-05 FIG 4B. (M)SDR AALA980930Lights · defectiveDFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT FLOOR PATH LGIHT STRIP AT SEAT 26D INOPERATIVE. REPLACED EMERGENCY EXIT FLOOR PATH LIGHT STRIP. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA960151Piston · defectiveDFW - FLT 1116 - AFTER TAKEOFF DFW WHEN LANDING GEAR RETRACTED, NLG FAILED TO RETRACT. AIRCRAFT RETURNED TO DFW AND LANDED WITHOUT INCIDENT. REPLACED NLG STRUT INNER CYLINDER. ALSO, REPLACED NLG RETRACTION ACTUATOR. SERVICED NLG STRUT WITH OIL AND NITROGENSDR AALA960143Strut · req'd serviceDFW - FLT NR 1067 - AFTER TAKEOFF DFW WHEN LANDING GEAR RETRACTED, NOSE LANDING GEAR FAILED TO RETRACT. RECYCLED LANDING GEAR WITH SAME RESULT. AIRCRAFT RETURNED TO DFW AND LANDED WITHOUT INCIDENT. SERVICED NOSE LANDING GEAR STRUT WITH OIL AND NITROGEN. AC
Back to N457AA, cancelled Jan 16, 2023