N365SW, cancelled May 11, 2016
Service difficulty reports · 325
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 = 'N365SW' AND deregistration_id = 'N365SW-2016-05-11' 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 = 'N365SW' AND deregistration_id = 'N365SW-2016-05-11' 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 SWAA013333Lens · missingDURING SCHEDULED PM CHECK, FOUND EEPLS LENS MISSING AT ROW 12. INSTALLED LENS PER MM.SDR SWAA013298Slide · unserviceableFWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA012525Battery · dischargedDURING SCHEDULED SERVICE CHECK, FOUND LT EXTERNAL AND RT INTERNAL WING EMERGENCY LIGHTS INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA010174Bottle · dischargedFWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE ASSY PER MM.SDR SWAA002612Connector · looseIN FLIGHT ENGINE SHUT DOWN WHILE AT CRUISE AT FL290, NR 1 ENG OIL BYPASS LIGHT ILLUMINATED. INSPECTED OIL FILTER, NO DEFECTS NOTED. REPLACED FILTER & RAN ENG, NO HELP. INSPECTED HARNESS FOUND FIREWALL CONNECTOR LOOSE. SECURED CONNECTOR & RAN ENG - OPS CHECK GSDR SWAA002562Lens · looseDURING SCHEDULED C3 CHECK, FOUND OVERHEAD EMERGENCY EXIT LIGHT LENS LOOSE AT ROW 3. SECURED LENS PER MM.SDR SWAA001625Lens · brokenDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LENS PER MM.SDR SWAA001624Bottle · dischargedDURING SCHEDULED C2 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATOR LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA001062Light · inoperativeEEPLS INOP AT ROW 12. REPAIRED WIRING AND INSTALLED NEW LAMP PER MM.SDR SWAA000952Indicator · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT SERVICE DOOR PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA000803Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND WEB CRACKED BETWEEN BS 967 AND 986, STRINGER 21R. REPAIRED WEB PER SRM AND BOEING DRAWING.SDR SWAA000802Stringer · crackedDURING SCHEDULED SPECIAL VISIT, FOUND STRINGER 21R CRACKED, BS 980. REPAIRED STRINGER SECTION PER SRM.SDR SWAA000288Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 178 BULKHEAD RT SIDE CHORD CRACKED, RBL 26. REMOVED AND REPLACED CHORD SECTION PER SRM.SDR SWAA000276Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, FOUND THRU ULTRASONIC INSPECTION, BS 178 BULHEAD CRACKED, RBL 7, RBL 1 AND LBL 1. REPAIRED BULKHEAD PER SRM.SDR SWAA000268Cover · looseDURING SCHEDULED 1/4D CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE GIRT BAR COVER ATTACH BRACKETS LOOSE. TIGHTENED ATTACH BRACKETS PER MM.SDR SWAA000267Cover · looseDURING SCHEDULED 1/4D CHECK, FOUND FWD ENTRY AND AFT SERVICE DOOR EVACUATION SLIDE PRESS IND VIEWING WINDOWS LOOSE. REMOVED AND REPLACED WINDOWS PER MM.SDR SWAA000094Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND EEPLS INOP AT MID CABIN. RESECURED WIRING TO LIGHT ASSY PER MM.SDR SWAA991911Slide Assy · saggingDURING SCHEDULED SERVICE CHECK, FOUND FWD ENTRY AND AFT SERVICE DOOR EVACUATION SLIDE GIRT ASSY'S EXTENDED OUT OF LIMITS. ADJUSTED BOTH SLIDE ASSY'S PER MM.SDR SWAA991520Egt Indicator · inopAIR TURNBACK, DURING FLIGHT, NR 2 ENG EGT INDICATOR INOP. REMOVED AND REPLACED NR 2 ENG EGT INDICATOR PER MM.SDR SWAA990719Wire · brokenEMERGENCY EXIT LIGHTING WIRES BROKEN AT LT OVERWING EXIT SIGN. REMOVED AND REPLACED EXIT SIGN PER MM.SDR SWAA982558Switch · malfunctionedAIR TURNBACK DUE TO NR 5 LE SLAT INDICATED NOT RETRACTED AFTER TAKEOFF. CHECK LIST COMPLETED, STILL INDICATION ON OVERHEAD AND FWD PANEL. AIRCRAFT MADE AN UNEVENTFUL LANDING IN RNO. REMOVED AND REPLACED NR 5 SLAT MID-EXTEND SWITCH PER BOEING MM.SDR SWAA981907Light · looseDURING SCHEDULED SERVICE CHECK, FOUND EMERGENCY EXIT LIGHT TRACK LOOSE. REMOVED AND REPLACED TRACK LOOSE PER BOEING MM.SDR SWAA971084Module · failedAFTER TAKEOFF, NR 2 SLAT INDICATION REMAINED IN TRANSIT. RETURNED TO STL AND MADE AN UNEVENTFUL LANDING. RERACKED SLAT/FLAP MODULE PER BOEING M/M.SDR SWAA970927Lamp · inoperativeDURING SCHEDULED RON CHECK, FOUND MID CABIN TRACK LIGHTS INOP AND LIFTED UP. RELAMPED AND RESECURED PER BOEING M/M.SDR SWAA970871Battery · dischargedDURING SCHEDULED 1/2 D-CHECK, FOUND EMERGENCY LIGHTING INOP. REMOVED AND REPLACED BATTERY PACKS PER BOEING M/M.
Back to N365SW, cancelled May 11, 2016