N645SW, cancelled Nov 20, 2017
Service difficulty reports · 286
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 = 'N645SW' AND deregistration_id = 'N645SW-2017-11-20' 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 = 'N645SW' AND deregistration_id = 'N645SW-2017-11-20' 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 SWAA043211Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND L2 DOOR EVAC SLIDE DOOR GIRT BAR CABLE MISROUTED. REROUTED L2 DOOR EVAC SLIDE CABLE PER MM.SDR SWAA042627Pressure Panel · crackedDURING SCHEDULED 1/4D CHECK, FOUND BEADED PRESSURE WEB AT BS 663, LBL 33, CRACKED. REPAIRED WEB PER SRM.SDR SWAA042359Fitting · corrodedDURING SCHEDULED SERVICE CHECK, FOUND LT MLG FWD AND AFT STABILIZER FITTINGS CORRODED. REMOVED AND REPLACED LT MLG FWD AND AFT STABILIZER FITTINGS PER MM.SDR SWAA042358Fitting · corrodedDURING SCHEDULED SERVICE CHECK, FOUND RT AND LT MLG FWD OUTBOARD HANGER FITTINGS CORRODED. REMOVED AND REPLACED MLG FITTINGS PER EA.SDR SWAA042221Hook · looseR1 DOOR EVAC SLIDE GIRT BAR HOOKS LOOSE. SECURED R1 DOOR EVAC SLIDE GIRT BAR HOOKS PER MM.SDR SWAA042085Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND R1 DOOR EVACUATION SLIDE OUT OF ADJUST. REINSTALLED SLIDE ASSY PER MM.SDR SWAA041807Slide · looseR2 DOOR EVAC SLIDE LOOSE. SECURED R2 DOOR EVAC SLIDE PER MM.SDR SWAA041783Slide · looseR2 DOOR EVAC SLIDE LOOSE. SECURED R2 DOOR EVAC SLIDE PER MM.SDR SWAA040642Cover · deterioratedEEPLS COVER DETERIORATED AT THE RT SIDE OF AFT CABIN. REMOVED AND REPLACED EEPLS COVER PER MM.SDR SWAA040488Slide · unserviceableL1 DOOR EVAC SLIDE LOW PRESSURE INDICATION. REMOVED AND REPLACED L1 DOOR EVAC SLIDE PER MM.SDR SWAA040245Indicator · faultyINFLIGHT SHUTDOWN/DECLARED EMERGENCY, DURING FLIGHT NR 1 ENGINE OIL TEMP GAUGE READ 180-190C. ENGINE WAS SHUT DOWN IAW QRH. REMOVED AND REPLACED TEMP GAUGE PER MM.SDR SWAA032011Light · missingDURING SCHEDULED C1 CHECK, FOUND EEPLS PHOTOLUMINESCENT SECTION MISSING BETWEEN ROW NR 19 ABC AND ROW NR 21 ABC. INSTALLED STRIP PER MM.SDR SWAA030870Trunnion · corrodedDURING SCHEDULED SERVICE CHECK, FOUND LT MLG TRUNNION PIN CORRODED. REMOVED AND REPLACED LT MLG TRUNNION PIN PER MM.SDR SWAA030869Strut · corrodedDURING SCHEDULED SERVICE CHECK, FOUND LT MLG UPPER OUTER CYLINDER CORRODED. REMOVED AND REPLACED LT MLG UPPER OUTER CYLINDER PER MM.SDR SWAA022706Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA022705Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA022651Engine · flamed outNR 2 ENGINE FLAMEOUT, DECLARED EMERGENCY, AIR TURNBACK, NR 2 ENGINE FLAMED OUT DURING CLIMB. REMOVED AND REPLACED MEC AND FUEL PUMP, PROBLEMS STILL EXIST. REMOVED AND REPLACED NR 2 ENGINE PER MM.SDR SWAA021447Light · brokenRT OVERWING EMERGENCY EXIT LIGHT BROKEN. REMOVED AND REPLACED EXIT LIGHT ASSY.SDR SWAA021312Cover · crackedDURING SCHEDULED A2 CHECK, FOUND EEPLS COVERS CRACKED AT ROW'S 12 AND 9. REMOVED AND REPLACED COVERS PER MM.SDR SWAA020738Slide · unserviceableDURING SCHEDULED A2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA020581Cover · looseEEPLS COVER LOOSE AT ROW NR 6. SECURED COVER PER MM.SDR SWAA020537Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 947.5, LBL 5. REPAIRED FLOORBEAM PER SRM.SDR SWAA020524Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND LONGITUDINAL FLOORBEAM CORRODED AT BS 807, LBL 8. REPAIRED FLOORBEAM PER SWA RA.SDR SWAA020198Light · looseDURING SCHEDULED BC3 CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA013316Cover · missingEEPLS COVER MISSING. INSTALLED COVER PER MM.SDR SWAA012844Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA012232Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE PER MM.SDR SWAA012217Actuator · failedAIR TURNBACK, RT WING L/E FLAP TRANSIT LIGHT ILLUMINATED. REMOVED AND REPLACED NR 3 L/E FLAP ACTUATOR PER MM.SDR SWAA011989Lens · missingDURING SCHEDULED C1 CHECK, FOUND OVERHEAD BIN BULL NOSE EMERGENCY EXIT LIGHT LENS MISSING AT ROW 23. REMOVED AND REPLACED EXIT LIGHT ASSY PER MM.SDR SWAA011868Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER. REINSTALLED EVAC SLIDE PER MM.SDR SWAA011023Light · inoperativeDURING SCHEDULED C4 CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT INOP AT ROW 16 DEF. RELAMPED PER MM.SDR SWAA002683Flap · delaminatedDURING SCHEDULED C3 CHECK, FOUND RT WING OTBD AFT FLAP DELAMINATED AT LOWER INBD END. R&R FLAP ASSY PER MM.SDR SWAA002684Light · inoperativeDURING SCHEDULED C3 CHECK, FOUND BULLNOSE EMERGENCY LIGHT INOP AT ROW 9R. RELAMPED LIGHT ASSY PER MM.SDR SWAA001082Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND EMERGENCY EXIT LIGHT INOP AT ROW 14 LT. RELAMPED PER MM.SDR SWAA000414Light · inoperativeDURING SCHEDULED RON CHECK, FOUND EMERGENCY PROXIMITY LIGHT NEAR FWD SERVICE DOOR INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA990860Pcu · malfunctionedDURING CLIMB, 20000 FEET, 295 KTS, B AUTOPILOT IN USE. AIRCRAFT WAS IN SMOOTH AIR WHEN A SHORT KICK WAS EXPERIENCE. RUDDER KICK WINGS REMAINED LEVEL AT ALL TIMES. NO RUDDER INPUT BY PILOT WAS NOTED. REMOVED AND REPLACED RUDDER PCU ENGAGE SOLENOID PER MM.
Back to N645SW, cancelled Nov 20, 2017