N360SW, cancelled Jul 24, 2018
Service difficulty reports · 354
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 = 'N360SW' AND deregistration_id = 'N360SW-2018-07-24' 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 = 'N360SW' AND deregistration_id = 'N360SW-2018-07-24' 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 SWAA980421Skin · crackedDURING SCHEDULED C4 CHECK, FOUND NR 1 KRUEGER DEFLECTOR DOOR CUTOUT CRACKED .25 AT RADIUS. REPAIRED PER SWA RA 1-357-0540.SDR SWAA970641Cover · missingDURING WALKAROUND INSPECTION, FOUND FWD EXIT EMERGENCY EXIT COVER MISSING. REPLACED COVER PER BOEING M/M.SDR SWAA961420Pack · failedINFLIGHT, RT PACK TRIPPED OFF, ATTEMPTED TO RESET, NO HELP. TRIPPED AGAIN AND NOTED LIGHT SMOKE. AIRCRAFT RETURNED TO LAS AND MADE AN UNEVENTFUL LANDING. CHECKED SYSTEM FOR LEAKS, RT AIR CYCLE MACHINE, TURBO FAN AND ALL RELATED PACK COMPONENTS AND OPERATED SDR SWAA960964Battery · dischargedFOUND AFT EMERGENCY FLASHLIGHT INOP. REPLACED BATTERY PER BOEING M/M.
Back to N360SW, cancelled Jul 24, 2018