N620SW, cancelled Nov 15, 2018
Service difficulty reports · 407
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 = 'N620SW' AND deregistration_id = 'N620SW-2018-11-15' 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 = 'N620SW' AND deregistration_id = 'N620SW-2018-11-15' 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 SWAA991206Accessory Unit · malfunctionedDURING CLIMB, BOTH A/C PACKS FAILED ALTERNATELY. DIVERTED TO ABQ. REMOVED AND REPLACED A/C ACCESSORY UNIT PER MM.SDR SWAA991102Slide · detachedAFT SERVICE DOOR EMERGENCY EVACUATION SLIDE ASSY FELL OUT OF CONTAINER. RESTOWED SLIDE ASSY PER MM.SDR SWAA990654Lens · incorrectDURING SCHEDULED C2 CHECK, FOUND FLOOR EMERGENCY ESCAPE EXIT LIGHT LENS AT ROW 11 HAS INCORRECT COLOR LENS. REPLACED LENS WITH CORRECT COLOR PER MM.SDR SWAA990014Engine · bird strikeCREW EXPERIENCED A BIRD STRIKE TO NR 1 ENGINE, SLIGHT PARAMETER FLUCTUATION AND SMELL IN CABIN, ENGINE OPERATION WAS NORMAL. AIRCRAFT RETURNED TO SMF AND MADE AN UNEVENTFUL LANDING. INSPECTED AND FOUND EVIDENCE OF CORE INGESTION. NO SHINGLED BLADES OR DAMAGSDR SWAA982050Light · inoperativeDURING SCHEDULED A1 CHECK, FOUND FLOOR TRACK EGRESS LIGHTING INOP AT ROWS 5-9. RELAMPED EGRESS LIGHTS AT ROW 5-9 PER BOEING MM.SDR SWAA980407Drain Plug · leakingFLIGHT DIVERTER INTO OAK DUE TO A ENG LOW PRESSURE LIGHT ILLUMINATED. A-SYSTEM WAS DECREASING RAPIDLY. LDG GEAR SELECTOR MOVED TO OFF. A-SYS QUANTITY STABILIZED JUST UNDER 1/4 TANK. INSPECTED AND FOUND LEFT MLG ACTUATOR DRAIN PLUG NOT SAFETIED. RETORQUESDR SWAA970493Fan · failedON APPROACH, CREW NOTED AN ELECTRICAL TYPE SMOKE SMELL IN CABIN AND COCKPIT. LANDED WITHOUT INCIDENT. INSPECTED AND FOUND GASPER FAN C/B TRIPPED. REMOVED AND REPLACED GASPER FAN PER BOEING M/M.
Back to N620SW, cancelled Nov 15, 2018