N357SW, cancelled Mar 22, 2018
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 = 'N357SW' AND deregistration_id = 'N357SW-2018-03-22' 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 = 'N357SW' AND deregistration_id = 'N357SW-2018-03-22' 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 SWAA980409Fan Blades · damagedRETURNED TO MSY AND MADE AN UNEVENTFUL LANDING DUE TO BIRD STRIKE TO RADOME AND NR 1 ENGINE. PERFORMED BIRD STRIKE INSPECTION, FOUND 8 ENGINE FAN BLADES BENT. REMOVED AND REPLACED 8 FAN BLADES PER BOEING MM, WITH A BORESCOPE SCHEDULED WITHIN 10 CYCLES.SDR SWAA971080Structure · bird strikeAFTER TAKEOFF, SUSTAINED BIRD STRIKE TO AIRCRAFT. AIRCRAFT DIVERTED TO SMF AND MADE AN UNEVENTFUL LANDING. PERFOMED BIRD STIRKE INSPECTION PER BOEING M/M WITH NO DEFECTS NOTED.SDR SWAA970835Module · failedAFTER TAKEOFF, EXPERIENCED A' SYSTEM HYD PRESSURE LOSS. ALSO, HAD NOSE LANDING GEAR RED LIGHT ILLUMINATED WITH GEAR HANDLE IN OFF. AIRCRAFT RETURNED TO PHX AND MADE AN UNEVENTFUL LANDING. REPLACED A-SYSTEM MODULE CHECK VALVE AND RETRACTTION TESTED GEAR PER SDR SWAA970315Skin · dentedDURING WALKAROUND INSPECTION, FOUND HORZ STAB L/E DENTED 4 FEET FROM ROOT AREA, LEFT SIDE. REPAIRED PER SWA RA 1-A55-0209R1.SDR SWAA961244Door · openAFTER TAKEOFF, AIRCRAFT WOULD NOT PRESSURIZE, NO WARNING INDICATION. RETURNED TO HOU AND MADE AN UNEVENTFUL LANDING. INSPECTED AND FOUND E AND E DOOR OPEN. SECURED DOOR, DEFERRED WARNING LIGHT AND CONTINUED PER MEL 52-2.SDR SWAA950327Frame · crackedDURING SCHEDULED C4 CHECK, FOUND FWD CARGO DOOR FRAME CRACKED ON INNER RADIUS OF FWD SIDE, JUST UNDER LOCK HOOK ASSY. REPAIRED PER SWA RA 1-A52-198.
Back to N357SW, cancelled Mar 22, 2018