N105SW, cancelled Jun 7, 2013
Service difficulty reports · 156
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 = 'N105SW' AND deregistration_id = 'N105SW-2013-06-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 = 'N105SW' AND deregistration_id = 'N105SW-2013-06-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 SWAA960854Overheat Warning · illuminatedNR 2 ENGINE OVERHEAT WARNING ILLUMINATED IN FLIGHT, CREW PERFORMED ENGINE SHUTDOWN CHECKLIST. AIRCRAFT LANDED AT MAF WITHOUT INCIDENT. INSPECTED AND FOUND NO EVIDENCE OF FIRE OR OVERHEAT CONDITION. DEFERRED DETECTION SYSTEM AND CONTINUED PER MEL 26-2.SDR SWAA960138Window · shatteredCAPTAIN'S NR 1 WINDOW OUTER PANE SHATTERED ACROSS ENTIRE LENGTH. DIVERTED TO TUL AND MADE AN UNEVENTFUL LANDING. REMOVED AND REPLACED WINDOW ASSEMBLY PER BOEING M/M.SDR SWAA960019Skin · crackedDURING SCHEDULED MAINT CHECK, FOUND FWD SERVICE DOOR LOWER HINGE CUTOUT CRACKED AT PREVIOUS REPAIR. REPAIRED PER BOEING SRM.SDR SWAA950797Bypass Switch · malfunctionedDURING DESCENT, NUMBER 1 ENGINE OIL FILTER BYPASS LIGHT ILLUMINATED. CREW PERFORMED ENGINE SHUTDOWN CHECKLIST. AIRCRAFT MADE AN UNEVENTFUL LANDING AT DAL. INSPECTED, NO CONTAMINATION NOTED. REPLACED BYPASS SWITCH, LEAK CHECKED AND PERFORMED ENGINE POWER ASSDR SWAA950595Eel Battery · dischargedDURING SCHEDULED SERVICE CHECK, FOUND EMERGENCY EXIT LIGHT ABOVE FWD SERVICE DOOR INOP. REPLACED BATTERY PACK PER BOEING M/M.SDR SWAA950568Eel Battery · dischargedDURING SCHEDULED SERVICE CHECK, FOUND FWD ENTRYWAY EMERGENCY EXIT LIGHT INOP. REPLACED BATTERY CHARGER AND BATTERY PACK PER BOEING M/M.
Back to N105SW, cancelled Jun 7, 2013