N130SW, cancelled Oct 27, 2003
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 = 'N130SW' AND deregistration_id = 'N130SW-2003-10-27' 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 = 'N130SW' AND deregistration_id = 'N130SW-2003-10-27' 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 SWAA960023Floorbeam · corrodedDURING SCHEDULED MAINT CHECK, FOUND AFT GALLEY FLOORBEAM CORRODED AROUND FASTENER HOLE AT BS 1006 AFT FLANGE, LBL 15 TO 28. REPAIRED PER SWA RA 1-253-1417.SDR SWAA960022Floorbeam · corrodedDURING SCHEDULED MAINT CHECK, FOUND AFT GALLEY FLOORBEAM CORRODED AROUND FASTENER HOLE AT BS 986.5 LBL 10. REPAIRED PER SWA RA 1-253-1419.SDR SWAA960021Floorbeam · corrodedDURING SCHEDULED MAINT CHECK, FOUND AFT GALLEY FLOORBEAM CORRODED AROUND FASTENER HOLE AT BS 986.5 RBL 4. REPAIRED PER SWA RA 1-253-1420.SDR SWAA950596Eel Power Sup · inopDURING SCHEDULED SERVICE CHECK, FOUND EMERGENCY EXIT LIGHTS INOP. REPLACED POWER SUPPLY PER BOEING M/M.SDR SWAA950597Eel Charger · inopDURING SCHEDULED SERVICE CHECK, FOUND FWD EXTERIOR EMERGENCY EXIT LIGHTS INOP. REPLACED BATTERY CHARGER PER BOEING M/M.SDR SWAA950560Actuator · failedAFTER TAKEOFF, NUMBER 2 L/E SLAT WOULD NOT RETRACT. AIRCRAFT RETURNED TO STL AND MADE AN UNEVENTFUL LANDING. REPLACED NUMBER 2 L/E SLAT ACTUATOR PER BOEING M/M.
Back to N130SW, cancelled Oct 27, 2003