N941AS, cancelled Nov 19, 2012
Service difficulty reports · 72
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 = 'N941AS' AND deregistration_id = 'N941AS-2012-11-19' 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 = 'N941AS' AND deregistration_id = 'N941AS-2012-11-19' 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 ASAA9880039Ground · looseSEA - DURING MAINTENANCE CHECK, THE R-1 DOOR OVERHEAD EMERGENCY LIGHTS FLICKERED. RESECURED LOOSE GROUND STUD AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA9880006Light · defectivePDX - DURING MAINTENANCE CHECK, THE FORWARD PORTABLE EMERGENCY LIGHT WAS FOUND INOPERATIVE. REPLACED THE LIGHT ASSEMBLY AND OPERATED NORMALLY. (M)SDR ASAA9780300Batteries · dischargedSEA - DURING MAINTENANCE CHECK, THE FORWARD OVERWING EMERGENCY EXIT IDENTIFIERS WERE FOUND INOPERATIVE. REPLACED THE BATTERIES IN THE POWER SUPPLY AND OPERATED NORMALLY. (X)SDR ASAA9780293Batteries · dischargedSEA - DURING MAINTENANCE CHECK, THE OVERHEAD EMERGENCY LIGHTS FROM ROWS 9 TO 12 WERE FOUND INOPERATIVE. REPLACED THE BATTERIES IN THE POWER SUPPLY AND OPERATED NORMALLY. (X)SDR ASAA9780210Cooling Turbine · defectiveSEA - AIR TURN BACK OF FLT 491 - CREW REPORTED ELECTRICAL SMOKE/ODOR IN CABIN. TURNED OFF GALLEY POWER AND RETURNED TO SEA, SMOKE/ODOR DISSIPATED DURING RETURN. INSPECTED GALLEYS AND COMPONENTS, INTERIOR LIGHTS AND BALLASTS, AND E/E COMPT, NO DEFECT NOTED. SDR ASAA9780203Wire · defectiveSEA - DURING MAINTENANCE CHECK, THE FORWARD EMERGENCY LIGHT IN THE TAILCONE AREA WAS FOUND INOPERATIVE. REPAIRED WIRE AT LIGHT ASSEMBLY AND OPERATED NORMALLY. (M)SDR ASAA9780041Battery Pack · dischargedPDX - DURING MAINTENANCE CHECK, THE EMERGENCY FLOOR TRACK LIGHTS FROM 27 TO 32 WERE FOUND INOPERATIVE. REPLACED THE BATTERY PACK AND OPERATED NORMALLY. (M)SDR ASAA9680269Batteries · dischargedSEA - DURING MAINTENANCE CHECK, THE OVERHEAD EMERGENCY LIGHTS IN THE FORWARD CABIN WERE FOUND INOPERATIVE. REPLACED THE BATTERIES AND OPERATED NORMALLY. (M)SDR ASAA9680261Light · defectivePDX - DURING MAINTENANCE CHECK, THE FORWARD PORTABLE EMERGENCY LIGHT WAS FOUND INOPERATIVE. REPLACED THE LIGHT ASSEMBLY AND OPERATED NORMALLY. (M)SDR ASAA9680192Batteries · dischargedSEA - DURING MAINTENANCE CHECK, THE FORWARD LEFT AND RIGHT OVERWING EMERGENCY EXIT LIGHTS WERE FOUND INOPERATIVE. REPLACED THE BATTERIES AND OPERATED NORMALLY. (M)SDR ASAA9680176Batteries · dischargedSEA - DURING MAINTENANCE CHECK, THE EMERGENCY FLOOR TRACK LIGHTS FROM ROWS 14 TO 18 AND ROWS 29 TO 32 WERE FOUND INOPERATIVE. REPLACED THE BATTERIES AND OPERATED NORMALLY. (M)SDR ASAA9680175Battery Pack · dischargedSEA - DURING MAINTENANCE CHECK, THE EMERGENCY FLOOR TRACK LIGHTS IN THE FORWARD CABIN WERE FOUND INOPERATIVE. REPLACED THE BATTERY PACK AND OPERATED NORMALLY. (M)SDR ASAA9580193Eel Terminal · looseSEA - DURING MAINTENANCE CHECK, THE FORWARD OVERHEAD EMERGENCY LIGHT IN THE TAILCONE WAS FOUND INTERMITTENT. SECURED LOOSE TERMINAL ON LIGHT SOCKET AND OPERATED NORMALLY. (M)SDR ASAA9580174Eel Power Supply · defectivePDX - DURING MAINTENANCE CHECK, THE AFT EXTERIOR EMERGENCY LIGHTS WERE FOUND INOPERATIVE. REPLACED THE POWER SUPPLY AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA9580161Striker/Roller · bindingPDX - PRIOR TO DEPARTURE OF FLIGHT 490, CREW REPORTED THE R1 DOOR WOULD NOT CLOSE. RELEASED THE STRIKER AND ROLLER ASSY AND DOOR OPERATED NORMALLY. (M)SDR ASAA9580160Battery · dischargedSEA - DURING MAINTENANCE CHECK, THE TAILCONE EMERGENCY EXIT LIGHTS OVER EVACUATION SLIDE WERE FOUND INOPERATIVE. REPLACED BATTERIES AND LIGHTS OPERATED NORMALLY. (W)SDR ASAA9580157Eel Wiring · disconnectedSEA - DURING MAINTENANCE CHECK, THE AFT QUARTER OF EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND INOPERATIVE. FOUND WIRE PULLED OUT OF SPLICE AT TRACK, RECRIMPED WIRING AND LIGHTS OPERATED NORMALLY. (W)SDR ASAA9580151Eel Battery Pack · dischargedSEA - DURING MAINTENANCE CHECK, TWO EMERGENCY FLOOD LIGHTS IN TAILCONE AREA WERE FOUND INOPERATIVE. REPLACED BATTERY PACK AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA9580130Eel Terminal · looseSEA - DURING MAINTENANCE CHECK, THE TAILCONE FORWARD OVERHEAD EMERGENCY LIGHT WAS FOUND INTERMITTENT. SECURED LOOSE TERMINAL TO SOCKET ASSEMBLY AND LIGHT OPERATED NORMALLY. (M)SDR ASAA9580128Eel Portable · defectiveLAX - DURING MAINTENANCE CHECK, THE FORWARD PORTABLE EMERGENCY LIGHT WAS FOUND INOPERATIVE. REPLACED THE LIGHT ASSEMBLY AND OPERATED NORMALLY. (M)SDR ASAA9580123Eel Portable · defectivePDX - DURING MAINTENANCE CHECK, THE FORWARD PORTABLE EMERGENCY LIGHT WAS FOUND INOPERATIVE. REPLACED THE LIGHT ASSEMBLY AND OPERATED NORMALLY. (M)SDR ASAA9541Eel Wiring · defectiveSEA - DURING MAINTENANCE CHECK, THE FLOOR EMERGENCY EXIT LIGHTS FROM ROW 27 AFT WERE FOUND INOPERATIVE. REPAIRED WIRING AT SIDEWALL AND REPLACED PICO FUSE AND LIGHTS OPERATED NORMALLY. (W)
Back to N941AS, cancelled Nov 19, 2012