N646SW, cancelled Nov 20, 2017
Service difficulty reports · 356
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 = 'N646SW' AND deregistration_id = 'N646SW-2017-11-20' 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 = 'N646SW' AND deregistration_id = 'N646SW-2017-11-20' 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 SWAA010958Light · inoperativeDURING SCHEDULED C4 CHECK, FOUND RT EMERGENCY EXIT SIDEWALL LIGHT INOP. RELAMPED LIGHT ASSY PER MM.SDR SWAA010663Mount · corrodedDURING SCHEDULED SERVICE CHECK, FOUND NR 1 ENGINE AFT MOUNT CORRODED. REMOVED AND REPLACED AFT ENGINE MOUNT PER MM.SDR SWAA001188Valve · inoperativeCABIN AUTO PRESS CONTROL INOPERATIVE AT 35,000 FEET. FOUND LT A/C PACK VALVE INOP, R&R SAME PER MM.SDR SWAA990538Bulb · failedDURING SCHEDULED SERVICE CHECK, FOUND FWD EMERGENCY BULL NOSE LIGHT OUT. RELAMPED LIGHT ASSY PER MM.SDR SWAA990447Light · inopDURING SCHEDULED SERVICE CHECK, FOUND EMERGENCY FLOOR TRACK LIGHTING INOP AT ROWS 19 TO 21. RESPLICED CONNECTORS PER MM.SDR SWAA982770Sign · brokenDURING SCHEDULED SERVICE CHECK, FOUND FWD SVC DOOR EMERGENCY EXIT SIGN BROKEN. REMOVED AND REPLACED LIGHT ASSY PER BOEING MM.
Back to N646SW, cancelled Nov 20, 2017