N75987, cancelled Aug 23, 2010

Service difficulty reports · 40

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 = 'N75987' AND deregistration_id = 'N75987-2010-08-23'
  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.

SDR MASA2010012400066Light · inoperativeLEFT EXT NR 3 EMERGENCY LIGHT INOP. REMOVED AND REPLACED LEFT EXT NR 3 EMERGENCY EXIT LIGHT, OPS CHECK GOOD.Jan 24, 2010 · N75987 · Cndair CL6002B19 · Emergency LightingSDR MASA2010011800051Light · inoperativeEMERGENCY ESCAPE PATH LIGHTING INOP. PLACED ON MEL. RESECURED FLOOR LIGHT PINS, OP GOOD.Jan 18, 2010 · N75987 · Cndair CL6002B19 · Emergency LightingSDR MASA2009081900264Light · inoperativeASH FLT 7167 CAE-IAD. MX FOUND DURING A SCHEDULED MX INSPECTION, THE LT FWD EXTERIOR EMERGENCY FLOOD LIGHT INOP. MX REPLACED THE LAMP. OPS CHECK GOOD.Aug 19, 2009 · N75987 · Cndair CL6002B19 · Emergency LightingSDR MASA2009032600107Light · inoperativeASH FLT 7307 ORD-MBS. FWD STRIP OF FLOOR PATH LIGHTING INOPERATIVE. MX REMOVED AND REPLACED LIGHT STRIP.Mar 26, 2009 · N75987 · Cndair CL6002B19 · Emergency LightingSDR MASA2009013000050Track · lack of lubeASH FLT 7062 ORD-GRB. CAPT REPORTED THE FA SEAT DOES NOT AUTO STOW. MX LUBED THE SEAT TRACKS. OPS GOOD.Jan 30, 2009 · N75987 · Cndair CL6002B19 · Flight Compartment EquipmentSDR MASA2008122200752Smoke Detector · malfunctionedASH 7065 IAD-EWR. CREW DECLARED AN EMERGENCY AND RETURNED TO THE FIELD DUE TO A LAV SMOKE WARNING. MX FOUND LAV FAN C/B POPPED, RESET C/B AND FAN OPS NORMAL. MX PERFORMED POWER RUNS WHILE ISOLATING PACKS AND OPERATING LAV FAN. NO SMELL OR VISUAL SMOKE PRESDec 22, 2008 · N75987 · Cndair CL6002B19 · Smoke DetectionSDR MASA2008111200769Door · malfunctionedASH FLT 7345 MHT-IAD. CAPT COULD NOT OPEN THE MAIN PASSENGER DOOR FROM THE OUTSIDE. MX COULD NOT DUPLICATE AND OPENED THE DOOR NORMALLY.Nov 12, 2008 · N75987 · Cndair CL6002B19 · Passenger/Crew DoorsSDR MASA200800451Mechanism · lack of lubeASH FLT 7197 ORD-SBN. PAX DOOR WILL NOT OPEN FROM OUTSIDE. LUBED INNER HANDLE MECHANISM. (B)Jun 6, 2008 · N75987 · Cndair CL6002B19 · Passenger/Crew DoorsSDR MASA200800370Hinge · damagedFOUND DAMAGE TO PAX DOOR HINGE. DAMAGE IS 3 SMALL GOUGES ON THE LUG OF THE PAX DOOR HINGE. REPAIRED DAMAGE.May 5, 2008 · N75987 · Cndair CL6002B19 · Passenger/Crew DoorsSDR MASA200800299Handle · lack of lubeASH FLT 7337 IAD. PAX DOOR HARD TO OPEN. LUBED PAX DOOR HANDLE.Apr 8, 2008 · N75987 · Cndair CL6002B19 · Passenger/Crew DoorsSDR MASA200800276Door · lack of lubeASH FLT 7456 IAD-ORF. PAX DOOR HARD TO OPEN FROM THE OUTSIDE. LUBED DOOR, OPS GOOD.Mar 30, 2008 · N75987 · Cndair CL6002B19 · Passenger/Crew DoorsSDR MASA200700555Light · inoperativeASH FLT 7265 ROA - EMERGENCY PATH LIGHTING INOP. MX REPLACED LIGHT STRIP, OPS GOOD.Sep 5, 2007 · N75987 · Cndair CL6002B19 · Emergency LightingSDR MASA200700478Battery · dischargedASH 7190 AVP - EMERGENCY PATH LIGHTING INOP. MX RESET AND RECHARGED SYSTEM, OPS CHECKED GOOD.Aug 3, 2007 · N75987 · Cndair CL6002B19 · Emergency LightingSDR MASA200602288Sensor · dirtyASH 7195 LGA - LT OVERWING EMERGENCY DOOR CAUTION IN FLIGHT. MX CLEANED SENSOR.Sep 15, 2006 · N75987 · Cndair CL6002B19 · Door Warning SystemSDR MASA200601864Status Message · false indicationASH 7246 ORD - SPOILERON FAULT STATUS MESSAGE. MX RESET THE SECUS.Jul 16, 2006 · N75987 · Cndair CL6002B19 · Drag Control SystemSDR MASA200601810Lamp · inoperativeASH 7253 FWA - AFT LT EMERGENCY EXIT LIGHT INOP. MX RELAMPED.Jul 11, 2006 · N75987 · Cndair CL6002B19 · Emergency LightingSDR MASA200601817Line · unsecureASH 7246 ORD - EMERGENCY LIFE LINE FOR OVERWING DOORS COVER FELL OFF. MX RESECURED COVER.Jul 11, 2006 · N75987 · Cndair CL6002B19 · Emergency EquipmentSDR MASA200601408Selector Valve · inoperativeASH 7290 ORD. THE AIRCRAFT HAD A GEAR DISAGREE WARNING MSG. AC FERRIED FOR REPAIRS. MAINTENANCE REPLACED THE NLG SELECTOR VALVE AND PRIORTY VALVE. (5-29-06)May 24, 2006 · N75987 · Cndair CL6002B19 · Landing Gear SelectorSDR MASA200600920Lamp · inoperativeDURING RON, THE CREW FOUND THE FWD CABIN OVERHEAD EMERGENCY LIGHT INOP. MAINTENANCE RELAMPED.Mar 27, 2006 · N75987 · Cndair CL6002B19 · Emergency LightingSDR MASA200600701Wire Harness · unknownASH 7020 OKC - FO PITCH TRIM INTERMITTENT. MX REMOVED AND REPLACED HORIZ STAB MOTOR CONTROL UNIT. REMOVED AND REPLACED RT STANG FAIRING AND REMOVED AND REPLACED NR 2 RED HARNESS. ALL OPS CK GOOD.Mar 8, 2006 · N75987 · Cndair CL6002B19 · Flight Control System WiringSDR MASA200600593Caution Message · activatedASH 7251 EWR - MACH TRIM INOP CAUTION. CREW COMPLIED WITH MEL PROCEDURES. MX CLEANED TRIM SWITCH.Feb 28, 2006 · N75987 · Cndair CL6002B19 · Central WarningSDR MASA200600472Inverter · inoperativeEMERGENCY FLOOR LIGHT STRIP WILL NOT ILLUM ROWS 4 - 9. MAINTENANCE REMOVED AND REPLACED THE INVERTER.Feb 17, 2006 · N75987 · Cndair CL6002B19 · Emergency LightingSDR MASA200600404Light · inoperativeASH 7355 IAD - EMERGENCY LIGHTS INOP. MAINTENANCE PERFORMED AN OPERATIONAL CHECK OF THE EMERGENCY LIGHTS. OPS CHECK GOOD.Feb 11, 2006 · N75987 · Cndair CL6002B19 · Emergency LightingSDR MASA200600332Lamp · inoperativeASH 7200 ORD - AFT CEILING EMERGENCY FLOOD LIGHT INOP. MAINTENANCE RELAMPED.Feb 4, 2006 · N75987 · Cndair CL6002B19 · Emergency LightingSDR MASA200600204Controller · malfunctionedASH 7385 IAD - LOSS OF CABIN PRESSURE AT FL 200. MX R2 OVERHEAD CONTROL PNL AND CONTROLLER.Jan 25, 2006 · N75987 · Cndair CL6002B19 · Cabin Pressure ControllerSDR MASA200501062Light · inoperativeEMERGENCY ESCAPE PATH LIGHTING AND LOWER EMERGENCY EXIT SIGN INOP. MAINTENANCE REMOVED AND REPLACED LIGHTING STRIP.Dec 20, 2005 · N75987 · Cndair CL6002B19 · Emergency LightingSDR MASA200500388Light · inoperativeTHE AIRCRAFT WAS RON LAS NIGHT AND SCHEDULED FOR A SERVICE CHECK INSPECTION. DURING THE WALK AROUND IT WAS DISCOVERED THE RIGHT SIDE FORWARD EXTERIOR EMERGENCY LIGHT WAS NOT ILLUMINATING. MAINTENANCE REPLACED THE LIGHT BULB AND OPS CHECKED GOOD.May 24, 2005 · N75987 · Cndair CL6002B19 · Emergency LightingSDR MASA200500359Lamp · blownTHE CREW NOTED THAT THE RT AFT EXTERIOR EMERGENCY LIGHT WAS INOP. MAINTENANCE RELAMPED.May 15, 2005 · N75987 · Cndair CL6002B19 · Emergency LightingSDR MASA200500314Door · lack of lubeASH 7103 IAD TO BNA. THE CREW NOTED THAT THE PASSENGER DOOR WILL NOT OPEN FROM THE OUTSIDE. MAINTENANCE CLEANED AND LUBED THE MAIN PASSENGER DOOR AND OPS CHECKED NORMAL. NO FURTHER DEFECTS NOTED.Apr 25, 2005 · N75987 · Cndair CL6002B19 · Flight Compartment WindowsSDR MASA200500049Clamp · looseASH 7106 CAE TO IAD RETURNED TO FIELD DUE TO SMOKE IN THE CABIN. MAINTENANCE FOUND A LOOSE CLAMP ON A DUCT ON THE 10TH STAGE BLEED SYSTEM. TIGHTENED CLAMP AND OPS CHECKED GOOD.Jan 21, 2005 · N75987 · Cndair CL6002B19 · Pneumatic Distribution SystemSDR MASA200500012Bulb · burned outA/C N75987 ON THE RON AND SCHEDULED FOR A ROUTINE CHECK INSPECTION DURING THE WALKAROUND IT WAS DISCOVERED THE RIGHT SIDE FORWARD EXTERIOR EMERGENCY LIGHT NOT ILLUMINATING. MAINTENANCE REPLACED THE LIGHT BULB AND OPERATIONAL CHECK GOOD.Jan 5, 2005 · N75987 · Cndair CL6002B19 · Emergency LightingSDR MASA200400702Bulb · burned outN75987 WAS ON RON LAST NIGHT AND SCHEDULED FOR A SERVICE CHECK INSPECTION. DURING THE WALK AROUND IT WAS DISCOVERED THAT THE RIGHT SIDE OVERWING EXTERIOR EMERGRNCY LIGHT WAS NOT ILLUMINATING. REPLACED THE LIGHT BULB. OPERATIONAL CHECK GOOD.Dec 17, 2004 · N75987 · Cndair CL6002B19 · Emergency LightingSDR MASA200400443Mechanism · lack of lubeASH 2843 PWM-CLT. PAX DOOR WILL NOT OPEN FROM THE OUTSIDE. MX LUBED DOOR, OPS CHECKED GOOD.Aug 8, 2004 · N75987 · Cndair CL6002B19 · Passenger/Crew DoorsSDR MASA200400427Pin · brokenASH 2914 JAX. PAX DOOR HANDLE WOULD NOT STOW. AIRCRAFT WAS FERRIED TO PHL FOR REPAIR. PHL MX REPLACED THE OUTER HANDLE SHEAR PIN.Jul 26, 2004 · N75987 · Cndair CL6002B19 · Passenger/Crew DoorsSDR MASA200400359Connector · contaminatedFLOOR EMERGENCY PROXIMITY LIGHTING BETWEEN ROWS 3-8 INOP. MX CLEANED MOISTURE SOAKED STRIPS AND CONNECTORS. OPS CHECKED GOOD, NO PARTS REPLACED.Jun 20, 2004 · N75987 · Cndair CL6002B19 · Electrical ConnectorsSDR MASA200400190Handle · brokenCREW REPORTED SERVICE DOOR STOW HANDLE BROKEN INSIDE. MX RESECURED. NO PARTS USEDApr 7, 2004 · N75987 · Cndair CL6002B19 · Service DoorsSDR MASA200400011Priority Valve · leakingASH 2750 PHL-CVG. REPORTED NOSE GEAR UNSAFE AFTER T/O WITH NWS INOP MSG. MX REPLACED MLG PRIORITY VALVE. CHECKS BAD ON CHECK FLIGHT. MX IS TROUBLESHOOTING. MX REPLACED THE NOSE LANDING GEAR. OP CHECKS GOOD.Jan 5, 2004 · N75987 · Cndair CL6002B19 · Landing Gear Retraction/Extension SystemSDR MASA200400010Priority Valve · leakingASH 2683 AVP-PHL, CREW REPORTED NOSE GEAR UNSAFE AFTER T/O. CREW TOOK A/C TO PHL. MX REPLACED THE NLG PRIORITY VALVE. OP CHECKS GOOD ON CHECK FLIGHT.Jan 5, 2004 · N75987 · Cndair CL6002B19 · Landing Gear Retraction/Extension SystemSDR MASA200400006Priority Valve · leakingASH NR 2705) DURING THE RETRACTION OF THE GEAR HANDLE, THE NOSE GEAR UNSAFE LIGHT CAME ON. A/C RETURNED TO FIELD. MECHANIC REPLACED THE NLG PRIORITY VALVE. OP CHECKS GOOD.Jan 4, 2004 · N75987 · Cndair CL6002B19 · Landing Gear Retraction/Extension SystemSDR MASA200300523Cover · missingASH FLT 2959 PHL-SDF, EMERGENCY LIGHT COVER ON THE FLOOR MISSING AND LIGHT DISCONNECTED. MX REPLACED LIGHT ASSY.Dec 31, 2003 · N75987 · Cndair CL6002B19 · Emergency Lighting
Back to N75987, cancelled Aug 23, 2010