N604SW, cancelled Aug 5, 2019
Service difficulty reports · 304
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 = 'N604SW' AND deregistration_id = 'N604SW-2019-08-05' 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 = 'N604SW' AND deregistration_id = 'N604SW-2019-08-05' 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 SWAA970834Wire · exposedDURING WALKAROUND CHECK, FOUND EMERGENCY EXIT LIGHT WIRES AT EXIT ROW EXPOSED. REPAIRED WIRES PER BOEING M/M.SDR SWAA960699Linkage · misadjustedAFTER TAKEOFF, WHEN GEAR RETRACTED, NOSE GEAR UNSAFE LIGHT REMAINED ILLUMINATED. RECYCLED GEAR AND RECEIVED SAME INDICATION. VISUALLY CHECKED NOSE GEAR, UP AND LOCKED. LANDED AT STL WITHOUT INCIDENT, ADJUSTED NLG DOOR LINKAGE AND PERFORMED GEAR RETRACTION TESDR SWAA960306Battery Pack · dischargedDURING SCHEDULED A1 CHECK, FOUND OVERHEAD EXIT SIGNS INOP. REPLACED BATTERY PACK PER BOEING M/M.SDR SWAA960305Batt Pack Base · inoperativeDURING SCHEDULED C3 CHECK, FOUND LEFT AFT EMERGENCY EXIT LIGHTING INOP. REPLACED BATTERY PACK BASE PER BOEING M/M.
Back to N604SW, cancelled Aug 5, 2019