N672SW, cancelled Dec 22, 2014
Service difficulty reports · 224
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 = 'N672SW' AND deregistration_id = 'N672SW-2014-12-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 = 'N672SW' AND deregistration_id = 'N672SW-2014-12-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 SWAA970992Skin · crackedDURING SCHEDULED C1 CHECK, FOUND L2 DOOR UPPER HINGE CUTOUT CRACKED. REPAIRED PER SWA RA 1-353-1711.SDR SWAA970991Skin · crackedDURING SCHEDULED C1 CHECK, FOUND L2 DOOR LOWER HINGE CUTOUT CRACKED. REPAIRED PER SWA RA 1-353-1710.SDR SWAA970908Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FWD ENTRY DOOR LOWER HINGE CUTOUT CRACKED. REPAIRED PER SWA RA 1-352-0288.SDR SWAA970179Service Door · damagedAFTER TAKEOFF, NOTED A RUMBLING SOUND FROM RIGHT SIDE OF AIRCRAFT. RETURNED TO HOU AND MADE AN UNEVENTFUL LANDING. FOUND FORWARD LAVATORY SERVICE DOOR OPEN, BENT AND WARPED. REPLACED WITH NEW DOOR PER BOEING M/M.SDR SWAA960815Adc · malfunctionedAFTER TAKEOFF, CAPT AIRSPEED INDICATOR ROLLED BACK CAUSING STALL AND WINDSHEAR WARNING. AIRSPEED THEN WENT TO MAX SCALE WITH STICK SHAKER ACTIVATION. AIRCRAFT RETUNED TO PHX AND MADE AN UNEVENTFUL LANDING. INSPECTED AND REPLACED CAPT ADC, PERFORMED PITOT SSDR SWAA960419Skin · dentedDURING SCHEDULED SV CHECK, FOUND FUSELAGE SKIN DENTED FROM BS 947 TO 957, BETWEEN S18 AND 19L. REPAIRED PER BOEING SRM.SDR SWAA960418Bulkhead Bracket · crackedDURING SCHEDULED SV CHECK, FOUND AFT CARGO BULKHEAD SUPPORT BRACKET CRACKED AT BS 727 PLUS 4, BL 0, WL 160. REPAIRED PER BOEING SRM.SDR SWAA960417Door Frame · crackedDURING SCHEDULED SV CHECK, FOUND FWD SERV DOOR, LWR FWD FRAME CRACKED AT BS 295, RBL 56, WL 209. REPLACED FRAME PER BOEING SRM.SDR SWAA960416Skin · creaseDURING SCHEDULED SV CHECK, FOUND FUSELAGE SKIN CREASE AT BS 807, BL 0, WL 148. REPAIRED PER BOEING SRM.SDR SWAA960415Frame · crackedDURING SCHEDULED SV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 492, RBL 36, WL 162. REPAIRED PER TRAMCO EWO 96-0229.SDR SWAA960414Stiffener · crackedDURING SCHEDULED SV CHECK, FOUND VERTICAL STIFFENER CRACKED AT BS 178, LBL 5.5, WL 184. REPAIRED PER BOEING SRM.SDR SWAA960413Web · crackedDURING SCHEDULED SV CHECK, FOUND WEB CRACKED AT BS 178, BL 0, WL 188.1. REPAIRED PER TRAMCO EWO 96-0228.SDR SWAA960412Frame · dentedDURING SCHEDULED SV CHECK, FOUND FUSELAGE FRAME DENTED AT BS 727E, S25R. REPAIRED PER BOEING SRM.SDR SWAA960411Skin · crackedDURING SCHEDULED SV CHECK, FOUND FWD GALLEY DOOR UPPER HINGE CUTOUT OUTER SKIN CRACKED AT UPPER OUTER EDGE. REPAIRED PER SWA ACO 3189-52.SDR SWAA960410Angle · crackedDURING SCHEDULED SV CHECK, FOUND CRACKED SKATE ANGLE AT BS 570, WL 171, LBL 43 TO 60. REPLACED PER BOEING SRM.SDR SWAA960388Skin · creasedDURING SCHEDULED SV CHECK, FOUND FUSELAGE SKIN CREASED AT BS 460 TO BS 480, RBL 1 TO RBL 4, WL 149. REPAIRED PER BOEING SRM.SDR SWAA960387Web · crackedDURING SCHEDULED SV CHECK, FOUND WEB CRACKED AT BS 639, RBL 66, WL 221. REPLACED PER BOEING SRM.SDR SWAA960386Skin · crackedDURING SCHEDULED SV CHECK, FOUND FUSELAGE OUTER SKIN CRACKED AT BS 328, WL 211, RBL 65. REPAIRED PER BOEING SRM.SDR SWAA960385Skin · dentedDURING SCHEDULED SV CHECK, FOUND FUSELAGE SKIN DENTED AT BS 294.5 TO BS 312, BETWEEN S20 AMD 21R. REPAIRED PER BOEING SRM.SDR SWAA960384Clip · crackedDURING SCHEDULED SV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, S19L, WL 192. REPAIRED PER BOEING SRM.SDR SWAA960383Angle · crackedDURING SCHEDULED SV CHECK, FOUND INTERCOSTAL TO FRAME ANGLE CRACKED AT BS 380, LBL 24, WL 155. REPAIRED PER BOEING SRM.SDR SWAA960382Bulkhead Web · crackedDURING SCHEDULED SV CHECK, FOUND BULKHEAD AT BS 178 PRESSURE WEB CRACKED 3 PLACES AT WL 213, LBL 4.7 AND LBL 6.7, WL 209.5. REPAIRED PER BOEING SRM.SDR SWAA960381Bulkhead Web · crackedDURING SCHEDULED SV CHECK, FOUND BULKHEAD AT BS 178 PRESSURE WEB CRACKED 3 PLACES AT WL 201, WL 199 AND WL 198, RBL 4.7. REPAIRED PER BOEING SRM.SDR SWAA960380Bulkhead Web · crackedDURING SCHEDULED SV CHECK, FOUND BULKHEAD AT BS 178 PRESSURE WEB CRACKED AT WL 213, RBL 6.7. REPAIRED PER BOEING SRM.
Back to N672SW, cancelled Dec 22, 2014