N671SW, cancelled Jan 3, 2013
Service difficulty reports · 308
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 = 'N671SW' AND deregistration_id = 'N671SW-2013-01-03' 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 = 'N671SW' AND deregistration_id = 'N671SW-2013-01-03' 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 SWAA981378Skin · crackedDURING SCHEDULED D CHECK, FOUND CRACKED EXTERNAL SKIN FWD SERVICE DOOR, AFT CORNER, RBL 66.5 WL 210. REPAIRED PER BOEING SRM.SDR SWAA980713Skin · crackedDURING SCHEDULED C4 CHECK, FOUND CRACKED SKIN NR 1 SLAT LWR T/E O/B OF AND NR 2 SLAT LWR T/E OF ACTUATOR. REPAIRED PER BOEING RA T1-A57-018.SDR SWAA980712Floorbeam · corrodedDURING SCHEDULED C4 CHECK, FOUND EXFOLIATED CORROSION FLOORBEAM SUPPORT AT BS 986.5 FAR RIGHT SIDE. REPAIRED PER SWA RA NR 1-353-1808.SDR SWAA970682Rod End · out of adjustAFTER TAKEOFF, NR 3 L/E SLAT WOULD NOT RETRACT PER INDICATION. AIRCRAFT RETUNED TO PHX AND MADE AN UNEVENTFUL LANDING. ADJUSTED NR 3 SLAT ROD END AND REPAIRED ROD END WIRING PER BOEING M/M.SDR SWAA970510Skin · damagedDURING SCHEDULED B/C4 CHECK, FOUND FUSELAGE SKIN DAMAGE AT BS 378 AND 403 AT S19L. REPAIRED PER BOEING SRM.SDR SWAA970509Stringer · tornDURING SCHEDULED B/C4 CHECK, FOUND STRINGERS TORN AT BS 397, S18L. REPAIRED PER BOEING SRM.SDR SWAA961281Slide · low pressDURING SCHEDULED TERMINAL CHECK, FOUND AFT SERVICE DOOR ESCAPE SLIDE PRESSURE LOW. REPLACED PER BOEING M/M.SDR SWAA960030Engine · failedAT 37,000, EXPERIENCED NUMBER 2 ENGINE OIL PRESSURE DROP, THEN ENGINE STOPPAGE. CREW PERFORMED ENGINE SHUTDOWN CHECKLIST. AIRCRAFT DIVERTED TO TUS AND MADE AN UNEVENTFUL LANDING. REPLACED NUMBER 2 ENGINE PER BOEING M/M.
Back to N671SW, cancelled Jan 3, 2013