N670SW, cancelled Jan 8, 2022
Service difficulty reports · 454
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 = 'N670SW' AND deregistration_id = 'N670SW-2022-01-08' 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 = 'N670SW' AND deregistration_id = 'N670SW-2022-01-08' 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 SWAA960309Battery Pack · dischargedDURING SCHEDULED SERVICE CHECK, FOUND AFT SERVICE DOOR AND GALLEY EMERGENCY EXIT LIGHTS INOP. REPLACED BATTERY PACK PER BOEING M/M.SDR SWAA960310Battery Pack · dischargedDURING SCHEDULED SERVICE CHECK, FOUND AFT SERVICE DOOR EMERGENCY EXIT LIGHT INOP. REPLACED BATTERY PACK PER BOEING M/M.SDR SWAA960311Battery Pack · dischargedDURING SCHEDULED SERVICE CHECK, FOUND RIGHT AFT SERVICE DOOR EMERGENCY EXIT LIGHT INOP. REPLACED BATTERY PACK PER BOEING M/M.SDR SWAA960047Transit Light · malfunctionedAFTER FLAP RETRACTION, TRANSIT INDICATION LIGHT REMAINED ILLUMINATED ON FWD AND OVERHEAD PANELS. CYCLED FLAPS TWICE, NO HELP. AIRCRAFT RETURNED TO MDW AND MADE AN UNEVENTFUL LANDING. CYCLED SLATS/FLAPS PER BOEING M/M, VERIFIED PROBLEM TO BE INDICATION, DEFE
Back to N670SW, cancelled Jan 8, 2022