N14065, cancelled Jan 11, 2018
Service difficulty reports · 64
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 = 'N14065' AND deregistration_id = 'N14065-2018-01-11' 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 = 'N14065' AND deregistration_id = 'N14065-2018-01-11' 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 AALA20090818SJU02Battery Pack · dischargedEMERGENCY LIGHT FROM RIGHT SEAT 29 TO AFT RIGHT DOOR NUMBER 4 INOPERATIVE. REPLACED EMERGENCY LIGHT BATTERY PACK FOR RIGHT SEAT 29 TO AFT DOOR NUMBER 4.SDR AALA20090818SJU01Battery Pack · dischargedEMERGENCY LIGHT FROM RIGHT SEAT 19 TO 28 INOPERATIVE. REPLACED EMERGENCY LIGHT BATTERY PACK, OPS CHECKED NORMAL.SDR AALA20090731SJU01Battery · dischargedSJU - EMERGENCY LIGHT INOPERATIVE 1G TO 5G. REMOVED AND REPLACED BATTERY AT FORWARD GALLEY RIGHT SIDE OF EMERGENCY LIGHTS.SDR AALA2009061500011O-Ring · failedMIA - THE BLUE HYDRAULIC SYSTEM FAILED. EMERGENCY DECLARED RETURNED MIA WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED O-RING FOR BLUE SYSTEM FLUID SAMPLING VALVE. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA2009051300927Pin · backed outMIA EMERGENCY LIGHT AT SEAT 8C INOPERATIVE. REINSERTED AND LOCKED PIN FOR EMERGENCY LIGHT AT SEAT 8C.SDR AALA2009030600555Battery Pack · dischargedJFK - SEAT MOUNTED LIGHTS AT ROWS 1D TO 18C AT LEFT AND RIGHT NUMBER ONE DOOR AND ROWS 5 TO 18 INOPERATIVE. REPLACED BATTERY PACK AT LEFT NUMBER 1 GALLEY.SDR AALA2009030400554Light · brokenJFK - LIGHT ASSEMBLY AT FIRST CLASS SEAT D1 BROKEN. REPLACED LIGHT ASSEMBLY AT FIRST CLASS SEAT D1.SDR AALA2009012700376Lamp · burned outMIA - EMERGENCY LIGHTS AT SEAT 30C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 30C.SDR AALA2009012700375Lamp · burned outMIA - EMERGENCY LIGHTS AT SEAT 16C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 16C.SDR AALA2009012700374Lamp · burned outMIA - EMERGENCY LIGHTS AT SEAT 11C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 11C.SDR AALA2009011100290Power Supply · dischargedMIA- EMERGENCY LIGHTS AT LEFT NUMBER ONE AND TWO DOOR DIM. REPLACED POWER SUPPLY AT LEFT NUMBER ONE DOOR.SDR AALA2009011100289Battery Pack · dischargedMIA- EMERGENCY LIGHTS AT LEFT NUMBER ONE AND TWO DOOR DIM. REPLACED BATTERY PACK AT LEFT NUMBER ONE DOOR.SDR AALA200802470ALight · brokenJFK - EMERGENCY LIGHT ASSEMBLY AT SEAT 12G BROKEN. REPLACED LIGHT ASSEMBLY AT SEAT 12G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802469ALight · brokenJFK - EMERGENCY LIGHT ASSEMBLY AT SEAT 9G BROKEN. REPLACED LIGHT ASSEMBLY AT SEAT 9G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802468ALight · brokenJFK - EMERGENCY LIGHT ASSEMBLY AT SEAT 9C BROKEN. REPLACED LIGHT ASSEMBLY AT SEAT 9C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802467ALight · brokenJFK - EMERGENCY LIGHT ASSEMBLY AT SEAT 7C BROKEN. REPLACED LIGHT ASSEMBLY AT SEAT 7C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802433ACharger · inoperativeJFK - EMERGENCY LIGHTS IN FIRST CLASS RIGHT SIDE INOPERATIVE. REPLACED BATTERY PACK AND CHARGER UNIT OVERHEAD NUMBER ONE RIGHT DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802368ABattery Pack · dischargedMIA - EMERGENCY LIGHTS AT SEATS 1G TO 5G INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT SEATS 1G TO 5G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802367ABattery Pack · dischargedMIA - EMERGENCY LIGHTS AT SEATS 19C TO 28C INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT SEATS 19C TO 28C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200801600Lens · missingJFK - EMERGENCY LIGHT AT SEAT 24C MISSING LENS. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT SEAT 24C. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200800928Power Supply · inoperativeJFK - EMERGENCY LIGHT AT OVERHEAD LEFT NUMBER TWO DOOR INOPERATIVE. REPLACED POWER SUPPLY UNIT FOR EMERGENCY LIGHT AT OVERHEAD LEFT NUMBER TWO DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060961Engine · malfunctionedJFK INFLIGHT T837/30 OCT - AFTER TAKEOFF THE AFT LAVATORY FIRE SMOKE ALARM WENT OFF. FLIGHT ATTENDANT REPORTED SOMETHING BURNING IN AFT LAVATORY. ALSO REPORTED A GRINDING MOTOR SOUND WHEN THE SMOKE DISSIPATED. RETURNED TO JFK AND LANDED WITHOUT INCIDENT. SDR AALA20060865Battery Pack · inoperativeMIA - EMERGENCY LIGHTS ON SEATS 19G TO 28G INOPERATIVE. REPLACED BATTERY PACK FOR INOPERATIVE EMERGENCY LIGHTS ON SEATS 19G TO 28G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060606Slide · malfunctionedSAL - RIGHT NUMBER ONE DOOR SLIDE INADVERTENTLY AND UNSUCCESSFULLY DEPLOYED. DOOR WAS NOT OPENED FULLY. AIRCRAFT TAKEN OUT OF SERVICE FOR REPAIRS. REPLACED SLIDE FOR RIGHT NUMBER ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060164Battery Pack · inoperativeJFK - RIGHT HAND AFT MOUNTED EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR RIGHT HAND AFT MOUNTED EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060015Computer · inoperativeMIA - ON CLIMB GOT LEFT HAND ENGINE LOOP-A FIRE DETECTION AND AFT CARGO FIRE WARNING. DISCHARGED AFT CARGO BOTTLE. RETURNED TO MIA AND LANDED WITHOUT INCIDENT. FOUND NO EVIDENCE OF FIRE. REPLACED NUMBER ONE AND TWO FLIGHT WARNING COMPUTERS AND CARGO SMOKE SDR AALA20050469Light · inoperativeJFK - EMERGENCY LIGHT AT SEAT 14G AND 28G INOPERATIVE. REPLACED EMERGENCY LIGHT ASSEMBLY AT SEATS 14G AND 28G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050413Battery Pack · inoperativeJFK - EMERGENCY LIGHT AT SECTION 4 LEFT HAND SIDE INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT SECTION 4 LEFT HAND SIDE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040536Wheel · separatedJFK T896/06 UPON LANDING AT JFK NR 1 MAIN LANDING GEAR WHEEL SEPARATED FROM AXLE AND DEPARTED AIRCRAFT. TAXIED UNEVENTFULLY TO GATE. AIRCRAFT OUT OF SERVICE FOR DAMAGE ASSESSMENT.--OPEN--SDR AALA20040170Battery Pack · inoperativeMIA EMERGENCY LIGHTS AT ROWS 19G TO 28G INOPERATIVE. REPLACED BATTERY PACK ASSEMBLY FOR EMERGENCY LIGHTS AT ROWS 19G TO 28G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20031461Circuit Breaker · faultySJU T1218/21 EN ROUTE SJU-JFK GOT AC BUS ONE OFF LIGHT ON OVERHEAD ELECTRICAL PANEL AND LOSS OF ASSOCIATED AIRCRAFT ELECTRICAL SYSTEMS. RETURNED SJU AND LANDED WITHOUT INCIDENT. REPLACED CIRCUIT BREAKER 5XN FOR NORMAL BUS ONE SUPPLY. SYSTEM GROUND CHECKEDSDR AALA20030633Actuator · malfunctionedWHEN YAW DAMP NR 1 IS ENGAGED, RUDDER MOVES RAPIDLY TO THE LT AND REMAINS IN THAT POSITION UNTIL ITS DISARM/DISENGAGED. REPLACED YAW DAMP NR 1 ACTUATOR AND LEAK, OPERATIONAL CHECKED GOOD. (M)SDR AALA20030605Beam · defectiveLANDING GEAR WOULD NOT RETRACT ON TAKEOFF. WOULD NOT GO PASS MID-POSITION. LANDING RETRACTION INOPERATIVE MESSAGE ON ECAM. LANDED TULE WITHOUT INCIDENT. REPLACED LEFT MAIN LANDING GEAR BOGIE BEAM. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20012160Valve · failedLHR - AFTER TAKEOFF YELLOW SYSTEM HYDRAULIC RESERVOIR AIR LIGHT ILLUMINATE FOLLOWED BY LOSS OF YELLOW SYSTEM PRESS REPEAT OF PIREP N074. REPLACED YELLOW SYSTEM NON-RETURN VALVE FOR HEAD PRESSURE LEAK CHECK AND OPS CHECK NORMAL. (M)SDR AALA20010570Oven · dirtyLHR - FLT 0092 - EN ROUTE EWR-LHR, DETECTED SMOKE AT BUSINESS CLASS OVEN. TURNED OFF OVEN. LANDED LHR WITHOUT FURTHER INCIDENT. CLEANED BUSINESS CLASS OVEN. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20002139Oven · dirtyLHR - FLT 156 - DURING FLIGHT, AFT GALLEY LEFT OVEN SMOKES. CONTINUED FLIGHT WITHOUT INCIDENT. CLEANED OVEN. SYSTEM GROUND CHECK NORMAL OPERATION. (M)SDR AALA20001735Connector · brokenSFO - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT LIGHT AT 38A AND 38B INOPERATIVE. REPAIRED EMERGENCY EXIT LIGHT CONNECTOR AT 38A AND 38B. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20001276Autopilot Sys · malfunctionedLHT - FLT 0131 - ON CLIMB-OUT AT APPROXIMATELY FL 220 WITH AUTOPILOT OFF, FLAPS AND SLATS UP, PITCH TRIM 1 AND 2 ON YAW DAMPER 1 AND 2 ON. UNCOMMANDED FLIGHT CONTROL INPUT KICKED AIRPLANE FROM SIDE TO SIDE (SUSPECT RUDDER), DEFINITELY NOT ROLLING MOMENT, ACCOSDR AALA20000851Wire · chafedJFK - FLT 116 - DURING FLIGHT, ENGINE NR 1 AGENT NR 2 DISHCH LIGHT ILLUMINATED AT FL330. RETURNED AND LANDED JFK WITHOUT INCIDENT. REPLACED NR 1 ENGINE FIRE BOTTLE NR 2. REPAIRED FIRE BOTTLE NR 2 CHAFED WIRING IN PYLON AT ENGINE NR 1. SYSTEM GROUND CHECKED SDR AALA991985Light · inoperativeJFK - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT SEAT PATH LIGHT AT SEAT 20G INOPERATIVE. REPLACED EMERGENCY EXIT SEAT PATH LIGHT AT SEAT 20G. SYSTEM GROUND CHECKED, NORMAL OPERATION. (X)SDR AALA991624Wire · brokenJFK - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT FLOOR PATH LIGHT AT 34G INOPERATIVE. REPAIRED WIRE FOR EMERGENCY EXIT FLOOR PATH LIGHT AT 34G. SYSTEM GROUND CHECKED, NORMAL OPERATION. (X)SDR AALA980953Strip · corrodedTUL - FOUND CORROSION ALONG ENTIRE LENGTH OF RUDDER T/E RT AND LT SIDES. REPLACED APEX STRIP RT AND LT SIDES PER 55-41-12-2 AND ESO 30595, DATED 4/13/98. (M)SDR AALA980913Shear Tie · corrodedTUL - FOUND CORROSION ON SHEAR TIE AT LONGER 45R FRAME 26. INSTALLED NEW SHEAR TIE PER SRM 51-22-10. (M)SDR AALA980910Stringer · corrodedTUL - FOUND CORROSION ON STRINGER 56 LEFT BETWEEN FRAME 59 AND 60. REMOVED CORRODED STRINGER AND INSTALLED NEW STRINGER AND SPLICE AS EPR SRM 53-10-14-2. (M)SDR AALA980883Seat Track · corrodedTUL - TOP OF NR 7 SEAT TRACK FLANGE CORRODED STATION 1231 TO 1238. REPLACED UPPER HALF OF TRACK NR 7 FROM STATION 1231 TO 1238 PER SRM 51-72-10-0. (M)SDR AALA980882Support · corrodedTUL - FOUND CORROSION ON FLOOR SUPPORT AT FRAME 60 BETWEEN ROLLER TRAY AND 1 AND 2 AND 4. INSTALLED NEW FLOORBEAM SUPPORT PER SRM 53-10-15. (M)SDR AALA980911Support · corrodedTUL - FOUND CORROSION ON FLOOR SUPPORT AT R1 DOOR. REMOVED AND REPLACED UPPER T-ANGLE PER SRM 51-72-10-0. (M)SDR AALA980909Fitting · corrodedTUL - FOUND STRINGER SPLICE FITTING CORRODED AT STRINGER 45R, FRAME 26. INSTALLED NEW SPLICE FITTING PER SRM 51-22-10. (M)SDR AALA980887Splice · corrodedTUL - FOUND CORROSION ON HORIZONTAL SURFACE OF STRINGER SPLICE. REPLACED STRINGER SPLICE PER SRM 51-72-10.SDR AALA980885Support · corrodedTUL - FOUND CORROSION ON FLOOR SUPPORT BETWEEN ROLLER TRACK 1 AND 2. INSTALLED DOUBLER AND FILLER PER SRM 53-10-15. (M)
Back to N14065, cancelled Jan 11, 2018