N410AT, cancelled May 21, 2015
Service difficulty reports · 95
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 = 'N410AT' AND deregistration_id = 'N410AT-2015-05-21' 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 = 'N410AT' AND deregistration_id = 'N410AT-2015-05-21' 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 TRBA2007065Valve · failedON TAKEOFF, EXCESSIVE ROLL TO THE LEFT. REMOVED AND REPLACED LEFT WING SPOILER VALVE BLOCK AS PER M/M 27-64-72. OP AND LEAK CHECK SATISFACTORY.SDR TRBA2007002Engine · failedWHILE IN CLIMB AT 15,000 FT, LOST NR 2 ENGINE NP, TQ, ITT AND OIL PRESSURE. ENGINE WAS SHUT DOWN BY FLIGHT CREW IAW CHECKLIST. REMOVED AND REPLACED RT ENGINE IAW MTX WORK CARD ENGINE REMOVED AND REPLACED NR 055006-CS-20000-001R1. (K)SDR TRBA2006064Fire Detector · false activationWHILE IN TAXI, NR 2 ENGINE FIRE INDICATION. ENGINE WAS SHUTDOWN AS PRECAUTIONARY PROCEDURE. CREW STATED THAT TAIL WIND WAS HEAVY. A/C RETURNED TO GATE. PERFORMED NR 2 ENGINE RUN UP TO VERIFIED ENGINE TEMPERATURE, AS PER PW 05-00-00. FOUND ENGINE WORKING SSDR TRBA5006035Control Head · burnedDURING ENROUTE, SOME SMOKE WAS NOTED INT THE COCKPIT COMING FROM CENTER PEDESTAL. LOST TRANSPONDER. REPLACED TRANSPONDER CONTROL HEAD UNIT. (K)SDR SDR2006003Wire · damagedON APPROACH, THE LANDING GEARS WOULD NOT EXTEND NORMALLY. PERFORMED GRAVITY EXTENSION PROCEDURES AND ALL GEARS DOWN AND LOCKED. REPAIRED A WIRE AT CONNECTOR FIN NR 13CA. (K)SDR 2005F00019Odor · detectedON APPROACH TO STT AN ELECTRICAL BURNING SMELL WAS FELT ON THE AFT CABIN AREA. EMERGENCY LANDING WAS DECLARED. NO FIRE EXTINGUISHER WAS USED. OPERATIONAL CHECK OF THE AIR CONDITIONING UNITS AND LIGHTING SYSTEMS WERE CONDUCTED AND FOUND NO BURNING SMELL. (MSDR SIMA200123305Light · inoperativeDFW - FLT 3826 - CREW REPORTED THE FLOOR PROXIMITY LIGHTS AT ROWS 1 AND 3 TO BE INOPERATIVE. MAINTENANCE REPLACED THE BULBS, OPS CHECK WAS GOOD AND AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR SIMA20011081Light · inoperativeMIA - FLT 5318 - CREW REPORTED THE FORWARD FLOOR PROXIMITY EMERGENCY LIGHT TO BE INOPERATIVE. PUT ON MEL AT THIS TIME. (M)SDR SIMA0903Uplock Sensor · leakingDFW - FLT 3706 - UPON GEAR RETRACTION LEFT MAIN GEAR CYCLED BETWEEN LOCKED AND UNLOCKED POSITION APPROX 9 TIMES WITH LOUD BANGING NOISE ASSOCIATED WITH EACH CYCLED BEFORE LOCKING UP. REMOVED AND REPLACED UPLOCK BOX IAW MM 32-31-00 GEAR RETRACTION AND MEASUREMSDR SIMA3051Bulb · failedDFW - DURING PS-2 CHECK, FOUND EMERGENCY LIGHT INOP AT 17B. REMOVED AND REPLACED BULB AT 17B. OPS CHECK GOOD. (M)SDR SIMA2924Uplock Sensor · inoperativeDFW - FLT 3529 - AFTER TAKEOFF DURING RETRACTION OF THE GEAR CREW REPORTED A CLUNKING SOUND. MAINTENANCE REMOVED AND REPLACED THE LEFT MLG UPLOCK BOX IAW ATR MM 32-31-00. OPERATIONAL AND LEAK CHECK WAS SATISFACTORY AND AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR SIMA2634Light · inoperativeDFW - FLT 3585 - MAIN CABIN DOOR EXTERIOR EMERGENCY FLOOD LIGHT DOES NOT ILLUMINATE WHEN EMERGENCY LIGHTS ARE SELECTED ON. MAINTENANCE REMOVED AND REPLACED EMERGENCY LIGHT ASSEMBLY IN PASSENGER DOOR. OPERATIONAL CHECK WAS GOOD, AIRCRAFT RETURNED TO SERVICE. SDR SIMA2633Bulb · inoperativeDFW - FLT 3585 - SERVICE DOOR EXTERIOR EMERGENCY FLOOD LIGHT DOES NOT ILLUMINATE WHEN EMERGENCY LIGHTS SELECTED ON. MAINTENANCE REMOVED AND REPLACED BULB IN SERVICE DOOR FLOOD LIGHT. OPERATIONAL CHECK GOOD, AIRCRAFT RETURNED TO SERVICE. (X)SDR SIMA2402Switch · inoperativeMIA - FLT 5255 - EMERGENCY LIGHTS AND 2 MINUTE LIGHT CAME ON DURING TAXI INTO GATE. MAINTENANCE REMOVED AND REPLACED SWITCH 9LE IAW AWM 20-45-11. OPERATIONAL CHECK WAS GOOD AND AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR SIMA0822Light · inoperativeMIA - FLT 5293 - FOUND EMERGENCY LIGHTS FOR PASSENGER STAIR INOPERATIVE. REMOVED AND REPLACED LIGHT ASSEMBLY. OPS CHECK GOOD. (M)SDR SIMA0512Seat Track · corroodedSAW - DURING CPCP-2 INSPECTION, FOUND LEFT FORWARD, MIDDLE, AFT INBOARD SEAT TRACKS AND LEFT AFT OUTBOARD, RIGHT AFT INBOARD, RIGHT MIDDLE INBOARD AND RIGHT FORWARD OUTBOARD SEAT TRACKS CORRODED BEYOND LIMITS. REMOVED AND REPLACED CORRODED SEAT TRACKS IAW EO SDR 2000ZZZM268Seat Track · corroodedSAW - DURING CPCP-2 INSPECTION, FOUND LEFT FORWARD, MIDDLE, AFT INBOARD SEAT TRACKS AND LEFT AFT OUTBOARD, RIGHT AFT INBOARD, RIGHT MIDDLE INBOARD AND RIGHT FORWARD OUTBOARD SEAT TRACKS CORRODED BEYOND LIMITS. REMOVED AND REPLACED CORRODED SEAT TRACKS IAW EO SDR 2000ZZZM267Seat Track · corroodedSAW - DURING CPCP-2 INSPECTION, FOUND LEFT FORWARD, MIDDLE, AFT INBOARD SEAT TRACKS AND LEFT AFT OUTBOARD, RIGHT AFT INBOARD, RIGHT MIDDLE INBOARD AND RIGHT FORWARD OUTBOARD SEAT TRACKS CORRODED BEYOND LIMITS. REMOVED AND REPLACED CORRODED SEAT TRACKS IAW EO SDR 2000ZZZM266Seat Track · corroodedSAW - DURING CPCP-2 INSPECTION, FOUND LEFT FORWARD, MIDDLE, AFT INBOARD SEAT TRACKS AND LEFT AFT OUTBOARD, RIGHT AFT INBOARD, RIGHT MIDDLE INBOARD AND RIGHT FORWARD OUTBOARD SEAT TRACKS CORRODED BEYOND LIMITS. REMOVED AND REPLACED CORRODED SEAT TRACKS IAW EO SDR 2000ZZZM265Seat Track · corroodedSAW - DURING CPCP-2 INSPECTION, FOUND LEFT FORWARD, MIDDLE, AFT INBOARD SEAT TRACKS AND LEFT AFT OUTBOARD, RIGHT AFT INBOARD, RIGHT MIDDLE INBOARD AND RIGHT FORWARD OUTBOARD SEAT TRACKS CORRODED BEYOND LIMITS. REMOVED AND REPLACED CORRODED SEAT TRACKS IAW EO SDR 2000ZZZM264Seat Track · corroodedSAW - DURING CPCP-2 INSPECTION, FOUND LEFT FORWARD, MIDDLE, AFT INBOARD SEAT TRACKS AND LEFT AFT OUTBOARD, RIGHT AFT INBOARD, RIGHT MIDDLE INBOARD AND RIGHT FORWARD OUTBOARD SEAT TRACKS CORRODED BEYOND LIMITS. REMOVED AND REPLACED CORRODED SEAT TRACKS IAW EO SDR 2000ZZZM263Seat Track · corroodedSAW - DURING CPCP-2 INSPECTION, FOUND LEFT FORWARD, MIDDLE, AFT INBOARD SEAT TRACKS AND LEFT AFT OUTBOARD, RIGHT AFT INBOARD, RIGHT MIDDLE INBOARD AND RIGHT FORWARD OUTBOARD SEAT TRACKS CORRODED BEYOND LIMITS. REMOVED AND REPLACED CORRODED SEAT TRACKS IAW EO SDR SIMA991001Fan · smokedNAS - FLT 5775 - ROUTINE FLIGHT AT FL 150 APPROX 50 NM WEST OF NAS SMOKE WAS NOTICED IN THE MAIN CABIN AIR CONDITIONING SYSTEM. DECLARED EMERGENCY AND DESCENDED TO 5000 FT DIRECT TO NAS. FOLLOWED EMERGENCY PROCEDURES FOR COCKPIT AND ELECTRICAL SMOKE. ONCE TSDR SIMA982531Zee Member · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND RIGHT AFT ZEE MEMBER BETWEEN FRAMES 39 AND 41 CORRODED. REMOVED AND REPLACED ZEE MEMBER. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA982532Floorbeam · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND LEFT FLOORBEAM 36, 38, AND 39 CORRODED. REMOVED AND REPLACED FLOORBEAMS. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA982493Plate · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND PAX DOOR SILL PLATE CORRODED. REMOVED AND REPLACED THE SILL PLATE. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA982492Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND THE FOLLOWING SEAT TRACKS CORRODED. LOCATIONS WERE THE LEFT FORWARD, MIDDLE AND AFT OUTBOARD, LEFT AFT INBOARD, LEFT AND RIGHT FLIGHT ATTENDANT SEAT TRACKS. THE RIGHT MIDDLE INBOARD AND OUTBOARD, AND THE RIGHT AFT CARGO SDR 98ZZZM720Floorbeam · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND LEFT FLOORBEAM 36, 38, AND 39 CORRODED. REMOVED AND REPLACED FLOORBEAMS. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM719Floorbeam · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND LEFT FLOORBEAM 36, 38, AND 39 CORRODED. REMOVED AND REPLACED FLOORBEAMS. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM704Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND THE FOLLOWING SEAT TRACKS CORRODED. THE LEFT FORWARD, MIDDLE AND AFT OUTBOARD, LEFT AFT INBOARD, LEFT AND RIGHT FLIGHT ATTENDANT SEAT TRACKS. THE RIGHT MIDDLE INBOARD AND OUTBOARD, AND THE RIGHT AFT CARGO TRACKS CORRODEDSDR 98ZZZM703Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND THE FOLLOWING SEAT TRACKS CORRODED. LEFT FORWARD, MIDDLE AND AFT OUTBOARD, LEFT AFT INBOARD, LEFT AND RIGHT FLIGHT ATTENDANT. THE RIGHT MIDDLE INBOARD AND OUTBOARD, AND THE RIGHT AFT CARGO TRACKS CORRODED. REMOVED AND RSDR 98ZZZM702Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND CORROSION AT THE FOLLOWING TRACK LOCATIONS. LEFT FORWARDRD, MIDDLE AND AFT OUTBOARD, LEFT AFT INBOARD, LEFT AND RIGHT FLIGHT ATTENDANT. THE RIGHT MIDDLE INBOARD AND OUTBOARD, AND THE RIGHT AFT CARGO SEAT TRACKS CORRODED.SDR 98ZZZM701Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND CORROSION AT THE FOLLOWING TRACK LOCATIONS. LEFT FORWARD, MIDDLE AND AFT OUTBOARD, LEFT AFT INBOARD, LEFT AND RIGHT FLIGHT ATTENDANT SEAT SEAT TRACKS. THE RIGHT MIDDLE INBOARD AND OUTBOARD, AND THE RIGHT AFT CARGO SEAT TSDR 98ZZZM700Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND THE FOLLOWING TRACKS CORRODED. LEFT FORWARD, MIDDLE AND AFT OUTBOARD, LEFT AFT INBOARD, LEFT AND RIGHT FLIGHT ATTENDANT SEAT TRACKS. THE RIGHT MIDDLE INBOARD AND OUTBOARD, AND THE RIGHT AFT CARGO SEAT TRACKS CORRODED. RSDR 98ZZZM699Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND TRACK CORROSION AT THE FOLLOWING LOCATIONS. LEFT FORWARD,MIDDLE AND AFT OUTBOARD, LEFT AFT INBOARD, LEFT AND RIGHT FLIGH T ATTENDANT SEAT TRACKS. THE RIGHT MIDDLE INBOARD AND OUTBOARD, AND THE RIGHT AFT CARGO SEAT TRACKSSDR 98ZZZM698Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND CORROSION AT THE FOLLOWING LOCATIONS. LEFT FORWARD, MIDDLE AND AFT OUTBOARD, LEFT AFT INBOARD, LEFT AND RIGHT FLIGHT ATTENDANT SEAT TRACKS. THE RIGHT MIDDLE INBOARD AND OUTBOARD, AND THE RIGHT AFT CARGO SEAT TRACKS CORROSDR 98ZZZM697Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND CORROSION AT THE FOLLOWING TRACK LOCATIONS. LEFT FORWARD, MIDDLE AND AFT OUTBOARD, LEFT AFT INBOARD, LEFT AND RIGHT FLIGHT ATTENDANT SEAT TRACKS. THE RIGHT MIDDLE INBOARD AND OUTBOARD, AND THE RIGHT AFT CARGO SEAT TRACKSSDR SIMA970181Power Supply · inoperativeDFW - FLT 3504 - FLIGHT CREW REPORTED ON PREFLIGHT, THAT MANY OF THE EMERGENCY LIGHTS WERE INOP. RAI'D POWER SUPPLIES, PERFORMED OPS CHECK OF THE EMERGENCY LIGHT SYSTEM. NO DEFECTS NOTED. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR SIMA9700301Idler Arm · loose bearingDFW - DURING COMPLIANCE OF REPETITIVE INSPECTION OF AILERON CONTROL SYSTEM (AD 93-22-10), MAINTENANCE FOUND THE IDLER ARM IN THE LEFT WING OUTBOARD HAD A LOOSE BEARING. IDLER ARM ASSY WAS REMOVED AND REPLACED. OPERATIONAL CHECK WAS SATISFACTORY. AIRCRAFT WASDR SIMA962131Light · missingORD - FOUND SECOND FROM LAST EMERGENCY FLOOR LIGHT MISSING. INSTALLED NEW EMERGENCY FLOOR LIGHT ASSEMBLY. OPS CHECK GOOD. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR SIMA952911O-Ring · failedFWA - FLT NR 4003 - EN ROUTE TO CMH, LEFT ENGINE TORQUE DROPPED 30 PERCENT THEN BEGAN TO DECLINE STEADILY. CREW ELECTED TO DIVERT TO FWA AND PROCEEDED WITH IN FLIGHT SHUTDOWN PROCEDURES WHEN TORQUE REACHED 30 PERCENT. UNEVENTFUL LANDING WAS MADE IN FWA. MAISDR SIMA952892Ballast · malfunctionedORD - FLT NR 4119 - AFT ROW OF EMERGENCY LIGHTS STAY ON. RAI BALLAST. OPS CHECK GOOD. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA952111Fire Bottle · malfunctionedCRP - FLT 3833 - THE AFT FIRE EXTINGUISHER DISCHARGED IN THE OVERHEAD BIN AFTER TAKEOFF. REASON FOR DISCHARGE IS UNKNOWN. REPLACED FIRE EXTINGUISHER. AIRCRAFT RETURNED TO SERVICE. PART TOTAL CYCLES, 2754. (X)SDR SIMA951353Probe Pickup · malfunctionedNR 1 ENGINE TQ SURGE ON TAKEOFF. ABORTED TAKEOFF AND RETURNED TO GATE. REPLACED NR 1 NH SENSOR, IAW PW MM (PROBE PULSE PICKUP). COMPLETED SUCCESSFUL TEST FLIGHT AND RETURNED AIRCRAFT TO SERVICE. (W)SDR SIMA950552Door Assy · departed acftDURING FLIGHT 3806, THE LT MLG BI-FOLD FOLLOW UP BLEW OFF. IT WAS NOTICED MISSING DURING PRE-FLIGHT WALK AROUND FOR NEXT FLIGHT SEGMENT. (W)
Back to N410AT, cancelled May 21, 2015