N507SW, cancelled Jan 29, 2014
Service difficulty reports · 338
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 = 'N507SW' AND deregistration_id = 'N507SW-2014-01-29' 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 = 'N507SW' AND deregistration_id = 'N507SW-2014-01-29' 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 SWAA000158Lens · missingDURING SCHEDULED C3 CHECK, FOUND EEPLS LENS MISSING AT ROW 21. REPLACED LENS ASSY PER MM.SDR SWAA000157Indicator · looseDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE PRESS IND VIEWING WINDOW LOOSE. SECURED VIEWING WINDOW PER MM.SDR SWAA000002Trim Actuator · inoperativeDUAL CHANNEL TRIM FAIL LIGHT ILLUMINATED AND AUTOPILOT INOP. DIVERTED TO LAS. REMOVED AND REPLACED MACH TRIM ACTUATOR PER MM. C/W BITE CK AND OPS CK GOOD.SDR SWAA991880Light · inop3 EACH MOST FWD EEPLS LIGHTS INOP. REMOVED AND REPLACED LIGHT ASSY'S PER MM.SDR SWAA991726Lens · brokenLT OVERWING EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LENS ASSY PER MM.SDR SWAA991230Slide · detachedFWD SERVICE DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY INTO CONTAINER PER MM.SDR SWAA991221Wire · exposedDURING SCHEDULED C1 CHECK, FOUND EEPLS WIRING EXPOSED AND LENS COVER MISSING. REROUTED WIRES AND REPLACED LENS COVER PER MM.SDR SWAA991196Lens · looseSEVERAL EEPLS LIGHT LENS CAME OUT OF TRACK DURING LANDING. RE-INSTALLED LENS PER MM.SDR SWAA991157Wire · exposedEEPLS LIGHT HAS EXPOSED WIRES AND MISSING LENS. REPAIRED WIRES AND REPLACED LENS PER MM.SDR SWAA991131Light · damagedEMERGENCY ESCAPE FLOOR LIGHT PULLED OUT OF TRACK AT ROW 8. REPLACED WITH NEW TRACK LIGHT ASSY PER MM.SDR SWAA990881Controller · erraticAIR TURNBACK, PRESSURIZATION CONTROLLER FAILED TO RETURN TO FIELD (EVEN WITH BOTH PACKS OFF). UPON RETURN TO LAS, MANUAL A/C WAS REQUIRED TO DUMP THE CABIN. REMOVED AND REPLACED PRESSURE CONTROLLER PER MM.SDR SWAA990642Battery · dischargedFWD AND AFT EMERGENCY FLASHLIGHTS INOP. REMOVED AND REPLACED BATTERIES PER MM.SDR SWAA990399Slide · low pressureDURING SCHEDULED CHECK, FOUND AFT ENTRY EVACUATION SLIDE INDICATOR IS IN THE RED BAND. REPLACED SLIDE ASSY PER MM.SDR SWAA983091Lamps · failedDURING SCHEDULED SC CHECK, FOUND 3 FLOOR EMERGENCY EXIT LIGHTS INOP. RELAMPED PER BOEING M/M.SDR SWAA983021Bulb · failedDURING PREFLIGHT CHECK, FOUND RED EMERGENCY EXIT FLOOR TRACK LIGHTS AT OVERWING EXIT INOP. RELAMPED PER BOEING M/M.SDR SWAA982570Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND EMERGENCY FLOOR TRACK LIGHTS AT ROW 6, 10 AND 16 ARE INOPERATIVE. RELAMPED FLOOR TRACK LIGHTS PER BOEING MM.SDR SWAA982071Retract Mech · failedAIR TURNBACK TO PHX, DUE TO NR 4 SLAT FAILED TO RETRACT AFTER TAKEOFF. AIRCRAFT MADE AN UNEVENTFUL LANDING (LGPAGE 99546). REMOVED AND REPLACED FLAP/SLAT MODULE AND FULL EXT SENSOR AS REQ PER BOEING MM. OPS CHECK GOOD.SDR SWAA981474Light · damagedDURING WALKAROUND CHECK, FOUND EMERGENCY FLOOR TRACK LIGHT NEAR SEAT 12C IS RIPPED OUT. ALL OTHER LIGHTS WORK NORMALLY. INSTALLED TRACK LIGHTING ASSY PER BOEING MM, OPS CHECK GOOD.SDR SWAA980896Wire · brokenDURING WALKAROUND CHECK, FOUND EMERGENCY EXIT LIGHTS INOP IN LEFT HAND EMERGENCY EXIT LOCATION. RECONNECTED BROKEN WIRE PER BOEING MM. OPS CK GOOD.SDR SWAA970929Socket · brokenDURING WALKAROUND CHECK, FOUND EMERGENCY FLOOR TRACK LIGHT INOP. REPLACED LIGHT SOCKET PER BOEING M/M.SDR SWAA970407Light · inoperativeDURING WALKAROUND INSPECTION, FOUND WHITE FLOOR TRACK LIGHTING INOP IN AFT CABIN AREA. REMOVED AND REPLACED LIGHT ASSEMBLY AND LENS PER BOEING M/M.SDR SWAA970348Lights · inoperativeDURING WALKAROUND, FOUND A SECTION OF CABIN EMERGENCY TRACK LIGHTING INOP. RECONNECTED 2 LIGHT ASSEMBLIES AND OP CHECKED PER BOEING M/M.SDR SWAA970186Lights · inoperativeDURING SCHEDULED C3 CHECK, FOUND CABIN FLOOR TRACK LIGHTING HAD CRACKED COVERS, INOP LAMPS THROUGHOUT CABIN. REPAIRED AND REPLACED AS REQUIRED PER BOEING M/M.SDR SWAA961211Skin · gougedDURING SCHEDULED BC2 CHECK, FOUND FUSELAGE SKIN GOUGED 3 PLACES AT 986.5, 16 INCHES BELOW AFT ENTRY DOOR. REPLACED PER BOEING SRM AND TYPICAL REPAIR T1-A53-042.SDR SWAA961064Light · inoperativeDURING SCHEDULED SC-CHECK, FOUND CABIN FLOOR TRACK LIGHTING INOPERATIVE AT ROWS 7 AND 8. SECURED WIRING PER BOEING M/M.SDR SWAA960810Light · inoperativeDURING SCHEDULED C1 CHECK, FOUND 2 FLOOR TRACK LIGHTS INOPERATIVE AT EMERGENCY EXIT ROW. RELAMPED PER BOEING M/M.SDR SWAA950616Eel · inopFOUND FLOOR TRACK LIGHTING TORN UP AT ROW 6 AND SEVERAL LIGHTS INOP. REPAIRED TRACK LIGHTING AND REPLACED LIGHTS PER BOEING M/M.SDR SWAA950611Eel · inopFOUND 2 EMERGENCY FLOOR TRACK LIGHTS INOP. RELAMPED AND RECONNECTED LIGHTS PER BOEING M/M.SDR SWAA950445Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND FLOORBEAM CORROSION AT BS 312, RBL 8. REPAIRED PER SWA RA 1-553-1274.SDR SWAA950444Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND FLOORBEAM CORROSION AT BS 312, RBL 8 TO LBL 10. REPAIRED PER SWA RA 1-553-1275.SDR SWAA950443Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND FLOORBEAM CORROSION AT BS 986.5, LBL 25.75 TO 43. REPAIRED PER SWA RA 1-553-1284.SDR SWAA950442Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND FLOORBEAM CORROSION AT BS 947, RBL 15. REPAIRED PER SWA RA 1-553-1280.SDR SWAA950441Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND FLOORBEAM CORROSION AT BS 947, RBL 48 TO RBL 53. REPAIRED PER SWA RA 1-553-1283.SDR SWAA950440Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND FLOORBEAM CORROSION AT BS 947, LBL 21.0. REPAIRED PER SWA RA 1-553-1278.SDR SWAA950439Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND FLOORBEAM CORROSION AT BS 947, RBL 5.0. REPAIRED PER SWA RA 1-553-1279.SDR SWAA950438Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND FLOORBEAM CORROSION AT BS 947, LBL 5.0. REPAIRED PER SWA RA 1-553-1282.SDR SWAA950437Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND FLOORBEAM CORROSION AT BS 947, LBL 4 TO RBL 2. REPAIRED PER SWA RA 1-553-1277.SDR SWAA950436Web · crackedDURING SCHEDULED 1/2 D-CHECK, FOUND CRACK IN WEB AT BS 726, STRINGER 18A RIGHT SIDE. REPAIRED PER SWA RA 1-553-1286.
Back to N507SW, cancelled Jan 29, 2014