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.
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
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 MASA2010012400066Light · inoperativeLEFT EXT NR 3 EMERGENCY LIGHT INOP. REMOVED AND REPLACED LEFT EXT NR 3 EMERGENCY EXIT LIGHT, OPS CHECK GOOD.SDR MASA2010011800051Light · inoperativeEMERGENCY ESCAPE PATH LIGHTING INOP. PLACED ON MEL. RESECURED FLOOR LIGHT PINS, OP GOOD.SDR 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.SDR MASA2009032600107Light · inoperativeASH FLT 7307 ORD-MBS. FWD STRIP OF FLOOR PATH LIGHTING INOPERATIVE. MX REMOVED AND REPLACED LIGHT STRIP.SDR MASA2009013000050Track · lack of lubeASH FLT 7062 ORD-GRB. CAPT REPORTED THE FA SEAT DOES NOT AUTO STOW. MX LUBED THE SEAT TRACKS. OPS GOOD.SDR 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 PRESSDR 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.SDR MASA200800451Mechanism · lack of lubeASH FLT 7197 ORD-SBN. PAX DOOR WILL NOT OPEN FROM OUTSIDE. LUBED INNER HANDLE MECHANISM. (B)SDR MASA200800370Hinge · damagedFOUND DAMAGE TO PAX DOOR HINGE. DAMAGE IS 3 SMALL GOUGES ON THE LUG OF THE PAX DOOR HINGE. REPAIRED DAMAGE.SDR MASA200800299Handle · lack of lubeASH FLT 7337 IAD. PAX DOOR HARD TO OPEN. LUBED PAX DOOR HANDLE.SDR MASA200800276Door · lack of lubeASH FLT 7456 IAD-ORF. PAX DOOR HARD TO OPEN FROM THE OUTSIDE. LUBED DOOR, OPS GOOD.SDR MASA200700555Light · inoperativeASH FLT 7265 ROA - EMERGENCY PATH LIGHTING INOP. MX REPLACED LIGHT STRIP, OPS GOOD.SDR MASA200700478Battery · dischargedASH 7190 AVP - EMERGENCY PATH LIGHTING INOP. MX RESET AND RECHARGED SYSTEM, OPS CHECKED GOOD.SDR MASA200602288Sensor · dirtyASH 7195 LGA - LT OVERWING EMERGENCY DOOR CAUTION IN FLIGHT. MX CLEANED SENSOR.SDR MASA200601864Status Message · false indicationASH 7246 ORD - SPOILERON FAULT STATUS MESSAGE. MX RESET THE SECUS.SDR MASA200601810Lamp · inoperativeASH 7253 FWA - AFT LT EMERGENCY EXIT LIGHT INOP. MX RELAMPED.SDR MASA200601817Line · unsecureASH 7246 ORD - EMERGENCY LIFE LINE FOR OVERWING DOORS COVER FELL OFF. MX RESECURED COVER.SDR 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)SDR MASA200600920Lamp · inoperativeDURING RON, THE CREW FOUND THE FWD CABIN OVERHEAD EMERGENCY LIGHT INOP. MAINTENANCE RELAMPED.SDR 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.SDR MASA200600593Caution Message · activatedASH 7251 EWR - MACH TRIM INOP CAUTION. CREW COMPLIED WITH MEL PROCEDURES. MX CLEANED TRIM SWITCH.SDR MASA200600472Inverter · inoperativeEMERGENCY FLOOR LIGHT STRIP WILL NOT ILLUM ROWS 4 - 9. MAINTENANCE REMOVED AND REPLACED THE INVERTER.SDR MASA200600404Light · inoperativeASH 7355 IAD - EMERGENCY LIGHTS INOP. MAINTENANCE PERFORMED AN OPERATIONAL CHECK OF THE EMERGENCY LIGHTS. OPS CHECK GOOD.SDR MASA200600332Lamp · inoperativeASH 7200 ORD - AFT CEILING EMERGENCY FLOOD LIGHT INOP. MAINTENANCE RELAMPED.SDR MASA200600204Controller · malfunctionedASH 7385 IAD - LOSS OF CABIN PRESSURE AT FL 200. MX R2 OVERHEAD CONTROL PNL AND CONTROLLER.SDR MASA200501062Light · inoperativeEMERGENCY ESCAPE PATH LIGHTING AND LOWER EMERGENCY EXIT SIGN INOP. MAINTENANCE REMOVED AND REPLACED LIGHTING STRIP.SDR 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.SDR MASA200500359Lamp · blownTHE CREW NOTED THAT THE RT AFT EXTERIOR EMERGENCY LIGHT WAS INOP. MAINTENANCE RELAMPED.SDR 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.SDR 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.SDR 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.SDR 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.SDR MASA200400443Mechanism · lack of lubeASH 2843 PWM-CLT. PAX DOOR WILL NOT OPEN FROM THE OUTSIDE. MX LUBED DOOR, OPS CHECKED GOOD.SDR 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.SDR MASA200400359Connector · contaminatedFLOOR EMERGENCY PROXIMITY LIGHTING BETWEEN ROWS 3-8 INOP. MX CLEANED MOISTURE SOAKED STRIPS AND CONNECTORS. OPS CHECKED GOOD, NO PARTS REPLACED.SDR MASA200400190Handle · brokenCREW REPORTED SERVICE DOOR STOW HANDLE BROKEN INSIDE. MX RESECURED. NO PARTS USEDSDR 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.SDR 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.SDR 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.SDR MASA200300523Cover · missingASH FLT 2959 PHL-SDF, EMERGENCY LIGHT COVER ON THE FLOOR MISSING AND LIGHT DISCONNECTED. MX REPLACED LIGHT ASSY.
Back to N75987, cancelled Aug 23, 2010