N506SW, cancelled Nov 8, 2013
Service difficulty reports · 277
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 = 'N506SW' AND deregistration_id = 'N506SW-2013-11-08' 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 = 'N506SW' AND deregistration_id = 'N506SW-2013-11-08' 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 SWAA000179Frame · crackedDURING SCHEDULED D-CHECK, FOUND 2 FRAMES CRACKED, BS 482A, WL 153 RT, AND BS 440 BETWEEN STRINGERS 8L-9L. REPAIRED FRAMES PER SRM AND ER.SDR SWAA000178Spar · crackedDURING SCHEDULED D-CHECK, FOUND THRU HFEC INSP INDICATED CRACKED LT WING REAR SPAR UPPER CHORD IN HOLED. REPAIRED SPAR PER SRM AND ER.SDR SWAA000173Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM UPPER SURFACE CORRODED, BS 986, RBL 14-36. REPAIRED BEAM PER ER NR 99-0047A.SDR SWAA000100Bulkhead · crackedDURING SCHEDULED D CHECK, FOUND THROUGH ULTRASONIC INSPECTION BS 178 BULKHEAD CRACKED IN 3 PLACES, LBL 6.7, RBL 6.7 AND RBL 4.7. REPAIRED BULKHEAD PER SRM.SDR SWAA992151Slide · looseAFT SERVICE DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. INSTALLED SLIDE ASSY PER MM.SDR SWAA991966Light · inoperativeEEPLS LIGHTS INOP NEAR OVERWING EXIT. RESECURED EEPLS LIGHTS PER MM. OPS CK GOOD.SDR SWAA991919Rudder · delaminatedDURING SCHEDULED SERVICE CHECK, FOUND RT SIDE OF RUDDER DELAMINATED JUST BELOW CENTER HINGE NEAR L/E. REMOVED AND REPLACED RUDDER ASSY PER MM.SDR SWAA991603Light · looseEEPLS TRACK LOOSE AT MID CABIN. REINSTALLED EEPLS TRACK LIGHT ASSY PER MM.SDR SWAA991363Light · looseSEVERAL EEPLS LIGHTS PULLED LOOSE. SECURED LIGHTS PER MM.SDR SWAA991320Door · gougedDURING SCHEDULED C2 CHECK, FOUND 2 EACH SMALL GOUGES ON RT EMERGENCY OVERWING DOOR AT FWD SKIN. REPAIRED SKIN PER SRM.SDR SWAA991050Light · inoperativeROW 18 LT FLOOR PROXIMITY LIGHT INOP AND COVER MISSING. REPAIRED WIRE AND REPLACED COVER PER MM.SDR SWAA990841Wire · exposedEMERGENCY EXIT TRACK LIGHTING HAS WIRES EXPOSED AT ROW 14. REMOVED AND REPLACED FLOOR TRACK LIGHTING ASSY PER MM.SDR SWAA982527Wire · exposedDURING SCHEDULED SERVICE CHECK, FOUND CABIN CREW REPORTS EXIT TRACK LIGHTING WIRES EXPOSED BY OVERWING EXIT. REPAIRED WIRES TO EMERGENCY TRACK LIGHT PER BOEING MM.SDR SWAA981739Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND FLOOR TRACK LIGHTS AT ROW 16-17 INOP. REPLACED SHORTED SOCKET ASSY IN FLOOR TRACK AT ROW 16 PER SWA MM.SDR SWAA981738Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND FLOOR TRACK LIGHTS AT ROW 10-11 INOP. REPLACED DAMAGED FLOOR TRACK SOCKET AT ROW 10 PER SWA MM.SDR SWAA970854Lamp · failedDURING WALKAROUND CHECK, FOUND A SECTION OF FLOOR LIGHTING INOP. RELAMPED PER BOEING M/M.SDR SWAA970259Stringer · crackedDURING SCHEDULED SERVICE CHECK, FOUND STRINGER 18A WEB CRACKED RT SIDE, AT AFT I/B FASTENER HOLE BS 727. REPAIRED PER SWA RA 1-553-1612 AND ACO 6580-53.SDR SWAA970230Skin · gougedDURING SCHEDULED BC4 CHECK, FOUND FUSLAGE SKIN GOUGED BELOW FWD ENTRY DOOR 2 BELOW AFT LOWER CORNER. REPAIRED PER BOEING SRM AND TYPICAL REPAIR T1-A53-042.SDR SWAA970209Lights · inoperativeDURING SCHEDULED BC4 CHECK, FOUND CABIN FLOOR TRACK LIGHTING INOP AND WIRES EXPOSED IN SEVERAL CABIN LOCATIONS. RECONNECTED, SECURED AND OP CHECKED PER BOEING M/M.SDR SWAA970090Light · inoperativeDURING WALKAROUND CHECK, FOUND EMERGENCY EXIT TRACK WIRES BROKEN AND 5 LIGHTS INOP. RECONNECTED WIRING, RESECURED COVER AND OP CHECKED PER BOEING M/M.SDR SWAA960957Latch · failedAIRCRAFT RETURNED TO HOU DUE TO NOT BEING ABLE TO RAISE GEAR NORMALLY. INSPECTED, REPLACED LANDING GEAR LATCH, PRESSURE WARNING SWITCH AND RETRACTION TESTED PER BOEING M/M.SDR SWAA960769Uplock Sensor · malfunctionedDIVERTED TO PHX DUE TO RIGHT MAIN GEAR UNSAFE LIGHT ILLUMINATING IN-FLIGHT. AIRCRAFT LANDED WITHOUT INCIDENT. INSPECTED AND REPLACED RIGHT GEAR UPLOCK SENSOR PER BOEING M/M.SDR SWAA960673Wire · disconnectedDURING WALKAROUND CHECK, FOUND FLOOR EMERGENCY LIGHTS AT ROW 16 INOP. REPAIRED WIRE TO CONNECTOR AT LIGHT PER BOEING M/M.SDR SWAA960406Wire · inoperativeFOUND EMERGENCY TRACK LIGHTING AT MID CABIN INOP. REPAIRED WIRING PER BOEING M/M.SDR SWAA960379Wire · damagedFOUND CABIN EMERGENCY FLOOR LIGHTING INOPERATIVE AT MID-CABIN AREA. REPAIRED TRACK WIRING PER BOEING M/M.SDR SWAA960425Battery Pack · dischargedFOUND ESCAPE PATH LIGHTING INOP AT ROW 10. RECONNECTED NUMEROUS WIRES AND REPLACED BATTERY PACK AT MID CABIN AREA PER BOEING M/M.SDR SWAA950749Door · unlockedDURING CLIMBOUT EXPERIENCED BUFFETING, THEN FWD CARGO COMPT DOOR OPEN LIGHT ILLUMINATED AND PRESSURIZATION REMAINED NORMAL. AIRCRAFT DESCENDED TO 6,000 AND RETURNED TO BOI. INSPECTED AND LOCKED DOOR NORMALLY.
Back to N506SW, cancelled Nov 8, 2013