N14821, cancelled Nov 4, 2005
Service difficulty reports · 57
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 = 'N14821' AND deregistration_id = 'N14821-2005-11-04' 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 = 'N14821' AND deregistration_id = 'N14821-2005-11-04' 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 C2XA02IA158Proximity Switch · malfunctionedIAH- THE CREW NOTED THAT THE LANDING GEAR MASTER WARNING DISAGREE ILLUMINATED AND RETURNED TO IAH WITHOUT INCIDENT. MAINTENANCE REMOVED AND REPLACED THE RIGHT INBOARD WEIGHT ON WHEELS PROX SWITCH, PERFORMED A OPERATIONAL CHECK OF THE LANDING GEAR SYSTEM, NO SDR C2XA02IA149Light · out of positionIAH- WHILE PERFORMING A 3A CHECK IT WAS NOTED THAT THE EMERGENCY LIGHT FLOOR STRIP HAS A LIGHT OUT AT SEAT 3AB. MAINTENANCE REPOSITIONED THE CABIN FLOOR EMERGENCY LIGHT STRIP, PERFORMED A OPERATIONAL CHECK OF THE EMERGENCY LIGHTING SYSTEM, NO DEFECTS NOTED. SDR C2XA02IA101Uplock · lack of lubeBPT- DURING FLIGHT 3640 FROM IAH TO BPT, THE CREW NOTED THAT THE LANDING GEAR WAS HAVING PROBLEMS RETRACTING, STICKING, MAKING LOUD BANGING NOISES AND TAKING EXCESSIVE TIME TO RETRACT. MAINTENANCE SERVICED BOTH FREE FALL ASSISTERS, CLEANED AND LUBED THE NOSESDR C2XA02IA100Landing Gear · malfunctionedBPT- DURING FLIGHT 3640 FROM IAH TO BPT, THE CREW NOTED THAT THE LANDING GEAR WAS HAVING PROBLEMS RETRACTING, STICKING, MAKING LOUD BANGING NOISES, AND, TAKING EXCESSIVE TIME TO RETRACT. MAINTENANCE SERVICED BOTH MLG FREE FALL ASSISTERS, CLEANED AND LUBED NOSDR C2XA02IA077Battery · dischargedIAH- DURING POST FLIGHT INSPECTION THE CREW NOTED THAT THE EMERGENCY LIGHTING IN MID CABIN FLOOR INOP.. IAH- MAINTENANCE REMOVED AND REPLACED THE POWER SUPPLY BATTERY, PERFORMED A OPERATIONAL CHECK OF THE EMERGENCY LIGHTING SYSTEM, NO DEFECTS NOTED, AND, THSDR C2XA01CL207Uplock · failedCLE FLT 3189 CREW REPORTED A LANDING GEAR UNSAFE INDICATION (RIGHT MAIN GEAR) DURING FLIGHT. AIRCRAFT LANDED WITHOUT INCIDENT. MAINTENANCE REMOVED AND REPLACED UNLOCK BOX ASSEMBLY. OPERATIONAL CHECKED GOOD. AIRCRAFT WAS RELEASED BACK TO SERVICE.SDR C2XA01CL151Switch · defectiveCLE FLIGHT#3040 THE CREW REPORTED THE #2 GEAR SYSTEM GEAR UNLOCK LIGHT STAYS ILLUMINATED WHEN THE GEAR IS UP.THE AIRCRAFT LANDED WITHOUT INCIDENT.MAINTENANCE REPLACED THE # 2 GEAR UNLOCK SWITCH.OPERATIONAL CHECKS WERE GOOD.THE AIRCRAFT WAS RELEASED FOR SERVICESDR C2XA01BT082Warning Light · illuminatedEWR---CO3228, CREW REPORTED RT MLG UNLOCK LIGHT CAME ON INFLIGHT. AIRCRAFT LANDED UNEVENTFULLY, MAINTENANCE TROUBLESHOOTING. AIRCRAFT RETURNED TO SERVICE WITH SYSTEM PLACARD IAW MEL.SDR C2XA01CL088Wire · brokenCLE FLIGHT 3109 THE CREW REPORTED EMERGENCY LIGHTS IN CABIN ILLUMINATE WITH MAIN CABIN DOOR OPEN. MAINTENANCE REPARIED WIRE BEHIND FLIGHT ATTENDANTS CONTROL PANEL. OPERATIONAL CHECKS WERE GOOD. THE AIRCRAFT WAS RELEASED FOR SERVICE.SDR C2XA01BT058Proximity Switch · faultyEWR CO3433 CREW REPORTED LEFT UNLOCK LIGHT ILLUMINATED WITH GEAR RETRACTED ON SYSTEM NR 2 (NO DOWNLOCK INDICATION WITH GEAR EXTENDED). MAINTENANCE REMOVED AND REPLACED LEFT DOWNLOCK PROXIMITY SWITCH IAW ATR42 MM 32-61-00. OPS CHECKED GOOD. AIRCRAFT RETURNESDR C2XA00BT076Bulb · inoperativeEWR - FLT 3388 - CREW REPORTED, EMERGENCY LIGHTS ON CABIN DOOR STEPS OUT. MAINTENANCE RELAMPED DOOR LIGHT BULB IAW 33-51-24. OPS CHECKED GOOD. (M)SDR C2XA99IA419Light · inoperableEFD - DURING MAINTENANCE INSPECTION, THE PASSENGER DOOR EMERGENCY EXIT LIGHT WAS FOUND INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE AFFECTED LIGHT ASSEMBLY IAW ATR 42320 MM 33-51-24, AND THE AIRCRAFT WAS APPROVD FOR RETURN TO SERVICE. (X)SDR C2XA99IA298Battery Pack · dischargedEFD - DURING MAINTENANCE INSPECTION, THE MIDDLE EMERGENCY LIGHTS WERE FOUND TO BE INOPERATIVE AT THE CENTER CABIN. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BATTERY PACK IAW ATR42-320 JIC 33-51-21, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA99IA252Bulb · failedIAH - DURING 'A' CHECK INSPECTION, THE EMERGENCY AISLE PATH LIGHTS AT SEATS 3A/4A WRE FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE AFFECTED LIGHT BULBS AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA98IA521Pin · failedIAH - DURING C-CHECK INSPECTION, THE SERVICE DOOR EMERGENCY EXIT LIGHT WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED A WIRE PIN AT THE 28WL LIGHT LOCATION. THE AIRCRAFT WAS THEN APPROVED FOR RETURN TO SERVICE (M)SDR C2XA98IA520Light · inoperativeIAH - DURING C-CHECK INSPECTION, THE LEFT EXTERNAL EMERGENCY EXIT LIGHT WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE AFFECTED EMERGENCY LIGHT. THE AIRCRAFT WAS THEN APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA98IA519Fitting · wornIAH - DURING C-CHECK INSPECTION, THE RIGHT WING SPAR LOWR FITTING AT RIB 18 WAS FOUND TO HAVE AN ELONGATED FLAP PANEL MOUNT HOLE. MAINTENANCE REMOVED AND REPLACED THE AFFECTED FITTING IAW THE ATR 42-320 SRM 51-25-02. THE AIRCRAFT WAS THEN APPROVED FOR RETURNSDR C2XA98IA518Angle · crackedIAH - DURING C-CHECK INSPECTION, THE FAIL/SAFE ANGLE FOR FRAME 27A WAS FOUND CRACKED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED ANGLE IAW THE ATR 42-320 SRM 51-25-02. THE AIRCRAFT WAS THEN APPROVE FOR RETURN TO SERVICE. (M)SDR C2XA98IA517Jamb · corrodedIAH - DURING C-CHECK INSPECTION, THE SERVICE DOOR THRESHOLD WAS FOUND CORRODED. MAINTENANCE REMOVED AND REPLACED THE THRESHOLD IAW THE ATR 42-320 SRM 51-21-42. THE AIRCRAFT WAS THEN APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA98IA516Jamb · corrodedIAH - DURING C-CHECK INSPECTION, THE PASSENGER DOOR THRESHOLD WAS FOUND CORRODED. MAINTENANCE REMOVED AND REPLACED THE THRESHOLD IAW THE ATR 42-320 SRM 51-21-42. THE AIRCRAFT WAS THEN APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA98IA515Frame · corrodedIAH - DURING C-CHECK INSPECTION, FRAME 37R WAS FOUND CORRODED AT FLOOR LEVEL. MAINTENANCE REPAIRED THE AFFECTED FRAME IAW CONTINETAL EXPRESS ENGINEERING CHANGE AUTHORIZATION EX 5310-01013. THE AIRCRAFT WAS THEN APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA98IA514Stringer · corrodedIAH - DURING C-CHECK INSPECTION, STRINGER 17R WAS FOUND CORRODED AT FRAME 39. MAINTENANCE REMOVED AND REPLACED THE AFFECTED STRINGER IAW THE ATR 42-320 SRM 51-21-28 AND 51-25-02. THE AIRCRAFT WAS THEN APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA98IA513Bracket · crackedIAH - DURING C-CHECK INSPECTION, THE ATTACH BRACKET FOR PANEL 292 CR WAS FOUND CRACKED. MAINTENANCE REMOVED AND REPLACED THE BRACKET IAW THE ATR 42-320 SRM 53-91-42. THE AIRCRAFT WAS THEN APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA98IA512Fitting · corrodedIAH - DURING C-CHECK INSPECTION, THE CO-PILOTS SEAT ATTACH FITTING WAS FOUND CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED FITTING IAW THE ATR 42-320 SRM 51-25-02. THE AIRCRAFT WAS THEN APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA98IA511Fitting · corrodedIAH - DURING C-CHECK INSPECTION, THE PILOTS SEAT ATTACH FITTING WAS FOUND CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED FITTING IAW THE ATR 42-320 SRM 51-25-02. THE AIRCRAFT WAS THEN APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA98IA510Support · crackedIAH - DURING C-CHECK INSPECTION, THE VERTICAL SUPPORT AT FRAME 27A FOUND CRACKED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SUPPORT IAW THE ATR 42-320 SRM 51-25-02. THE AIRCRAFT WAS THEN APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA98IA509Intercostal · crackedIAH - DURING C-CHECK INSPECTION, THE INTERCOSTAL BETWEEN FRAMES 27A AND 28 WAS FOUND CRACKED. MAINTENANCE REPAIRED THE AFFECTED INTERCOSTAL IAW THE ATR 42-320 SRM 51-70-00. THE AIRCRAFT WAS THEN APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA98IA508Clip · corrodedIAH - DURING C-CHECK INSPECTION, THE STRINGER CLIP AT FRAME 30 STRINGER 18 WAS FOUND CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED CLIP IAW THE ATR 42-320 SRM 51-25-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA98IA507Clip · corrodedIAH - DURING C-CHECK INSPECTION, THE STRINGER CLIP AT FRAME 30 STRINGER 17 WAS FOUND CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED CLIP IAW THE ATR 42-320 SRM 51-25-02. THE AIRCRAFT WAS THEN APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA98IA506Clip · corrodedIAH - DURING C-CHECK INSPECTION, THE STRINGER CLIP AT FRAME 30 STRINGER 16 WAS FOUND CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED CLIP IAW THE ATR 42-320 SRM 51-25-02. THE AIRCRAFT WAS THEN APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA98IA505Stringer · corrodedIAH - DURING C-CHECK INSPECTION, STRINGER 17R WAS FOUND CORRODED FROM FRAME 30 TO FRAME 31. MAINTENANCE REMOVED AND REPLACED THE AFFECTED STRINGER IAW THE ATR 42-320 SRM 51-25-02. THE AIRCRAFT WAS THEN APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA98IA504Stringer · corrodedIAH - DURING C-CHECK INSPECTION, STRINGER 18R WAS FOUND CORRODED FROM FRAME 27 TO FRAME 29. MAINTENANCE REMOVED AND REPLACED THE AFFECTED STRINGER IAW THE ATR 42-320 SRM 51-25-02. THE AIRCRAFT WAS THEN APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA98IA503Stringer · corrodedIAH - DURING C-CHECK INSPECTION, STRINGER 16R WAS FOUND CORRODED FROM FRAME 27 TO FRAME 29. MAINTENANCE REMOVED AND REPLACED THE AFFECTED STRINGER IAW THE ATR 42-320 SRM 51-25-02. THE AIRCRAFT WAS THEN APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA98IA502Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT OUTBOARD SEAT TRACK WAS FOUND CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SEAT TRACK IAW THE ATR 42-320 SRM 51-25-02. THE AIRCRAFT WAS THEN APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA98IA501Frame · corrodedIAH - DURING C-CHECK INSPECTION, FRAME 34 WAS FOUND CORRODED. MAINTENANCE REPAIRED THE AFFECTED FRAME IAW THE ATR 42-320 SRM 53-61-40, 51-21-28. THE AIRCRAFT WAS THEN APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA98IA500Stringer · corrodedIAH - DURING C-CHECK INSPECTION, STRINGER 15R WAS FOUND CORRODED AT FRAME 40. MAINTENANCE REPAIRED THE AFFECTED STRINGER USING A SPLICE REPAIR IAW THE ATR 42-320 SRM 51-24-01, 53-00-00. THE AIRCRAFT WAS THEN APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA98IA499Frame · corrodedIAH - DURING C-CHECK INSPECTION, FRAME 36 WAS FOUND CORRODED. MAINTENANCE REPAIRED THE AFFECTED FRAME USING A DOUBLER REPAIR IAW THE ATR 42-320 SRM 53-61-40, 53-21-42, AND 51-25-02. THE AIRCRAFT WAS THEN APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA98IA498Floorbeam · corrodedIAH - DURING C-CHECK INSPECTION, THE FLOORBEAM AT FRAME 39 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED FLOORBEAM IAW THE ATR 42-320 SRM 53-61-40. THE AIRCRAFT WAS THEN APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA98IA497Angle · crackedIAH - DURING C-CHECK INSPECTION, THE CARGO DOOR WAS FOUND TO HAVE A CRACKED HINGE FITTING ATTACH ANGLE. THE AFFECTED ANGLE WAS REMOVED AND REPLACED IAW THE ATR 42-320 SRM 51-25-02. THE AIRCRAFT WAS THEN APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA98IA496Frame · crackedIAH - DURING C-CHECK INSPECTION, THE CARGO DOOR WAS FOUND TO HAVE A CRACKED FRAME. THE AFFECTED FRAME WAS REPAIRED USING A DOUBLER REPAIR IAW THE ATR 42-320 SRM 51-25-04, 51-21-28, AND 51-70-00. THE AIRCRAFT WAS THEN APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA98IA428Fan · frozenHRL - DURING CLIMB-OUT ON FLIGHT 3968, THE CREW REPORTED A STRONG ODOR OF ELECTRICAL SMOKE IN THE COCKPIT AND CABIN. THE AIRCRAFT RETURNED TO HRL AND LANDED WITHOUT INCIDENT WHERE MAINTENANCE INSPECTED THE AIRCRAFT AND FOUND THE VENT FAN MOTOR TO BE FROZEN. SDR C2XA98BT038Prop Brake · burnedEWR - NR 2 ENGINE PROP BRAKE FIRE DISCHARGED BOTH AGENTS INTO NR 2 ENGINE. PERFORMED DVI OF NR 2 ENGINE IAW ATR MM 05-50-00 SECTION X. NO DISCREPANCIES. NO FURTHER DAMAGE. REMOVED AND REPLACED NR 1 AND NR 2 ENGINE FIRE BOTTLES. AIRCRAFT RELEASED UNDER MELSDR C2XA98BT014Power Supply · inoperativeBTV - DURING 4A INSPECTION, FOUND MAIN CABIN EMERGENCY EXIT SIGN OVER FLIGHT ATTENDANTS SEAT INOPERATIVE. REPLACED POWER SUPPLY AND OPERATIONALLY CHECKED ITEM GOOD. (M)SDR C2XA97IA195Frame · crackedIAH - DURING C-CHECK INSPECTION, THE SECOND FRAME FROM THE FORWARD SIDE OF THE CARGO DOOR WAS FOUND TO BE CRACKED AT THE TOP. MAINTENANCE REPAIRED THE FRAME USING A DOUBLER, ALL WORK ACCOMPLISHED IAW CONTINENTAL EXPERSS ENGINEERING CHANGE/REPAIR AUTHORIZATIONSDR C2XA97IA194Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT INBOARD SEAT TRACK WAS FOUND TO BE CORRODED FROM FRAMES 34-36. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SECTION OF SEAT TRACK IAW ATR SRM 53-00-00 AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA97IA193Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT OUTBOARD SEAT TRACK WAS FOUND TO BE CORRODED FROM FRAMES 32-35. MAINTENANCE REMOVED AND REPLACED THE AFFECTED PORTION OF SEAT TRACK IAW ATR SRM 53-00-00 AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA97IA192Fitting · crackedIAH - DURING C-CHECK INSPECTION, THE AFT ROLLER FITTING FOR THE CARGO DOOR WAS FOUND TO BE CRACKED. MAINTENANCE REMOVED AND REPLACED THE FITTING AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA97BT019Bulb · failedBTV - DURING 1A INSPECTION, FOUND PAX DOOR STAIRWAY EMERGENCY LIGHT INOP. MAINTENANCE REMOVED AND REPLACED LAMP OPERATIONALLY CHECKED GOOD. (M)SDR C2XA96IA103Stringer · corrodedDURING C-CHECK INSPECTION, STR 17RT BETWEEN FRAMES NR 33 AND NR 35 WAS FOUND CORRODED. MAINTENANCE REMOVED THE CORROSION AND PERFORMED A STRINGER REPAIR PER ATR-42 SRM 51-21-42 AND SRM 53-00-00. AIRCRAFT TOTAL TIME, 13,896.1 HOURS. TOTAL CYCLES, 17,612. (XSDR C2XA96IA102Seat Track · corrodedDURING C-CHECK INSPECTION, THE RIGHT OUTBOARD SEAT TRACK AT FRAME 36 WAS FOUND CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK AND THE AIRCRAFT WAS RETURNED TO SERVICE. AIRCRAFT TOTAL TIME, 13,896.1 HOURS. TOTAL CYCLES, 17,612. (X)
Back to N14821, cancelled Nov 4, 2005