N975AS, cancelled Jul 7, 2015
Service difficulty reports · 211
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 = 'N975AS' AND deregistration_id = 'N975AS-2015-07-07' 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 = 'N975AS' AND deregistration_id = 'N975AS-2015-07-07' 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 ASAA9880218Battery · dischargedSEA - DURING MAINTENANCE CHECK, THE EMERGENCY LIGHTS IN THE FLIGHT COMPARTMENT WERE FOUND INOPERATIVE. REPLACED THE BATTERIES IN THE POWER SUPPLY AND OPERATED NORMALLY. (M)SDR ASAA9880214Connector · looseSEA - DURING MAINTENANCE CHECK, THE EMERGENCY FLOOR TRACK LIGHTS IN THE FORWARD CABIN WERE FOUND INOPERATIVE. SECURED CONNECTOR TO LIGHT ASSEMBLY AND OPERATED NORMALLY. (M)SDR ASAA9880209Wire · looseSEA - FLT 460 - CREW REPORTED FIRST BANK OF EMEGENCY EXIT FLOOR TRACK LIGHTS WERE INOPERATIVE. RECONNECTED WIRING AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA9880203Wire · disconnectedPDX - DURING MAINTENANCE CHECK, THE EMERGENCY FLOOR TRACK LIGHTS IN THE FORWARD CABIN WERE FOUND INOPERATIVE. RECONNECTED WIRING IN FLOOR TRACK AND OPERATED NORMALLY. (M)SDR ASAA9880194Guide · out of adjustSEA - PRIOR TO DEPARTURE OF FLIGHT 198, CREW REPORTED THE FLIGHT COMPARTMENT RIGHT SLIDING WINDOW WAS BINDING. ADJUSTED WINDOW UPPER GUIDE MECHANISM AND OPERATED NORMALLY. (M)SDR ASAA9880168Slide · failedOAK - DURING 15K CHECK, THE L1 DOOR EMERGENCY EVACUATION SLIDE FAILED THE EMERGENCY LIGHT AMP TEST. REPLACED THE L1 DOOR EMERGENCY EVACUATION SLIDE ASSY. (M)SDR ASAA9880049Batteries · dischargedSEA - DURING MAINTENANCE CHECK, THE OVERHEAD EMERGENCY LIGHTS IN THE CATWALK AREA WERE FOUND INOPERATIVE. REPLACED THE BATTERIES IN THE POWER SUPPLY AND OPERATED NORMALLY. (M)SDR ASAA9780045Wire · brokenSEA - DURING MAINTENANCE CHECK, THE EMERGENCY FLOOR TRACK LIGHTS FROM ROWS 10 TO 13 WERE FOUND INOPERATIVE. REPLACED WIRE SEGMENT IN TRACK ASSEMBLY AND OPERATED NORMALLY. (M)SDR ASAA9780031Hold Open Latch · lack of lubeSEA - PRIOR TO DEPARTURE OF FLT 721, CREW REPORTED THE L1 DOOR HOLD OPEN LATCH IS DIFFICULT TO RELEASE. LUBED THE HOLD OPEN LATCH MECHANISM AND OPERATED NORMALLY. (M)SDR ASAA9680273Wire · disconnectedSEA - DURING MAINTENANCE CHECK, THE EMERGENCY FLOOR TRACK LIGHTS FROM ROWS 10 TO 12 WERE FOUND INOPERATIVE. RECONNECTED WIRING AT LIGHT ASSEMBLY AND OPERATED NORMALLY. (M)SDR ASAA9580156Eel Assy · malfunctionedSEA - DURING MAINTENANCE CHECK, THE L1 DOOR PORTABLE EMERGENCY EXIT LIGHT WOULD NOT EXTINGUISH UNLESS SWITCH ON LIGHT CYCLED. REPLACED L1 DOOR PORTABLE EMERGENCY EXIT LIGHT AND OPERATED NORMALLY. (W)
Back to N975AS, cancelled Jul 7, 2015