N368SW, cancelled Mar 22, 2018
Service difficulty reports · 360
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 = 'N368SW' AND deregistration_id = 'N368SW-2018-03-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 = 'N368SW' AND deregistration_id = 'N368SW-2018-03-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 SWAA050961Bulb · inoperativeDURING SCHEDULED C2 CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA043727Light · brokenLT OVERWING EMERGENCY EXIT LIGHT ASSY BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA042791Fitting · crackedDURING SCHEDULED C4 CHECK, FOUND FWD ENTRY DOOR UPPER AND LOWER HINGE BOX FITTINGS CRACKED. REMOVED AND REPLACED UPPER AND LOWER HINGE BOX FITTINGS PER SRM.SDR SWAA032581Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA032511Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 940, BETWEEN STRINGERS 24L AND 25L. REPAIRED SKIN PER SRM.SDR SWAA032257Mec · faultyNR 1 ENGINE SHUT DOWN. FOUND, NR 1 ENGINE FUEL SHUTOFF VALVE, VALVE SWITCH, FUEL PUMP AND MEC FAULTY. REMOVED AND REPLACED SHUTOFF VALVE, VALVE SWITCH, FUEL PUMP AND MEC PER MM.SDR SWAA031832Lens · looseFWD ENTRY DOOR OVERHEAD EMERGENCY EXIT LIGHT LENS LOOSE. REMOVED AND REPLACED LENS PER MM.SDR SWAA031814Cable · misroutedDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA031693Module · leakingSTRONG ODOR IN CABIN. REMOVED AND REPLACED HYD A AND B SYSTEM RESEVOIR PRESS MODULE, AND SYSTEM BLEED VALVE PER MM.SDR SWAA031341Charger · faultyCABIN EMERGENCY EXIT LIGHTS CAME ON AND OFF INTERMITTENTLY. REMOVED AND REPLACED BATTERY CHARGER PER MM.SDR SWAA031007Light · brokenDURING SCHEDULED C3 CHECK, FOUND OVERHEAD EMERGENCY EXIT LIGHT BROKEN AT FWD GALLEY. REMOVED AND REPLACED EMERGENCY EXIT LIGHT ASSY PER MM.SDR SWAA030498Beam · corrodedDURING SCHEDULED D CHECK, FOUND BS 987 FLOORBEAM UPPER CHORD CORRODED BETWEEN LBL 15 AND RBL 41, WL 208. REPAIRED FLOORBEAM PER BFG ER.SDR SWAA030487Spoiler · delaminatedDURING SCHEDULED D CHECK, FOUND NR 5 GROUND SPOILER DELAMINATED ON UPPER SURFACE. REMOVED AND REPLACED NR 5 GROUND SPOILER PER MM.SDR SWAA030477Wire · looseDURING SCHEDULED D CHECK, FOUND LOOSE CONNECTOR WIRE AT RT OVERWING EXIT LIGHT. REPAIRED WIRE PER WDM.SDR SWAA030476Rib · crackedDURING SCHEDULED D CHECK, FOUND RT WING UPPER RIB CHORD CRACKED AT WS 114, STR 2. REPAIRED RIB PER BFG ER.SDR SWAA030425Beam · crackedDURING SCHEDULED D-CHECK, FOUND VERT STAB RT T/E BEAM CRACKED AT FIN STA 81.8. REMOVED AND REPLACED RT T/E BEAM PER SRM.SDR SWAA030405Door Frame · crackedDURING SCHEDULED D CHECK, FOUND FWD CARGO DOOR FRAME CRACKED AT BS 492, AT NR 1 STOP FITTING. REPAIRED FRAME PER SWA T1.SDR SWAA030385Skin · crackedDURING SCHEDULED D-CHECK, FOUND AFT SERVICE DOOR LOWER HINGE SKIN CUTOUT CRACKED. REPAIRED SKIN PER SRM.SDR SWAA030384Beam · corrodedDURING SCHEDULED D-CHECK, FOUND LT CREASE BEAM WEB CORRODED BETWEEN BS 867 & BS 897, WL 208. REPAIRED CREASE BEAM WEB PER SRM.SDR SWAA030324Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 23R. REPAIRED FRAME PER SRM.SDR SWAA030197Shear Tie · crackedDURING SCHEDULED RON, FOUND SHEAR TIE CRACKED AT BS 907, BETWEEN STR 20L AND STR 21L. REPAIRED SHEAR TIE PER SRM.SDR SWAA022956Flap · delaminatedDURING SCHEDULED C2 CHECK, FOUND RT WING INBD T/E AFT FLAP DELAMINATED ON LOWER SURFACE. REMOVED AND REPLACED FLAP PER MM.SDR SWAA022955Slat · delaminatedDURING SCHEDULED C2 CHECK, FOUND LT WING NR 3 SLAT T/E WEDGE DELAMINATED AT INBD END. REMOVED AND REPLACED NR 3 SLAT PER MM.SDR SWAA022580Tee Fitting · crackedDURING SCHEDULED SPECIAL VISIT, FOUND AFT CARGO DOOR T-CHORD CRACKED AT AFT LOWER CORNER. REPAIRED CHORD PER SRM.SDR SWAA022550Slide · out of positionDURING SCHEDULED RON, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA021526Guide Vane · erodedAIR TURNBACK, DURING CLIMB F/A REPORTED FUMES IN CABIN. FOUND NR 2 ENGINE HPT NOZZLE GUIDE VANES ERODED. REMOVED AND REPLACED NR 2 ENGINE PER MM.SDR SWAA021497Battery · dischargedDURING SCHEDULED RON, FOUND BOTTOM AFT EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT BATTERY PER MM.SDR SWAA020552Actuator · failedDURING T/O RT PACK WENT HOT, F/A REPORTED HOT SMELL, NO SMOKE. SMELL WENT AWAY AS CLIMB PROGRESSED. SMELL RETURNED AFTER FLAPS EXTENDED FOR LANDING. REMOVED AND REPLACED RAM AIR DOOR ACTUATOR AND CONTROLLER PER MM.SDR SWAA020450Bushing · wornDURING SCHEDULED C3 CHECK, SWA SI 11111-55, BOTH LT AND RT ELEVATOR TAB FWD LOWER HANGER BUSHINGS WORN. REMOVED AND REPLACED TAB BUSHINGS PER MM.SDR SWAA020447Rod End · wornDURING SCHEDULED C3 CHECK, SWA SI 11111-55, LT ELEVATOR, FOUND TAB PUSH ROD ENDS WORN. REMOVED AND REPLACED LT ELEVATOR ROD ENDS PER MM.SDR SWAA011636Battery · dischargedAFT CABIN UPPER EMERGENCY FLASHLIGHT INOP. Removed and replaced EMERGENCY FLASHLIGHT BATTERY PER MM.SDR SWAA002094Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR GIRT BAR CABLE MISROUTED. RE-ROUTED CABLE ASSY PER MM.SDR SWAA001956Frame · crackedDURING SCHEDULED D-CHECK, FOUND FWD SVC DOOR LWR AFT FRAME CRACKED. REPAIRED FWD SVC DOOR FRAME PER SRM.SDR SWAA001939Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 178 BULKHEAD LT SIDE CHORD CRACKED. REMOVED AND REPLACED SIDE CHORD PER SRM.SDR SWAA001934Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE EXTERNAL SKIN CRACKED AT BS 440, STR 4L. REPAIRED SKIN PER SRM.SDR SWAA001918Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 178 BULKHEAD HORIZONTAL WEB CRACKED, AFT SIDE, WL 207, LBL 20 & RBL 20. REPAIRED BULKHEAD PER SRM.SDR SWAA001334Indicator · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA001333Girt Bar · out of adjDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE GIRT ASSY OUT OF ADJUST. REINSTALLED SLIDE ASSY PER MM.SDR SWAA000758Switch · failedABORTED TAKEOFF, TAKEOFF WARNING HORN SOUNDED. REMOVED AND REPLACED SPEED BRAKE SWITCH TERMINAL END AT S651 PER MM. OPS CK GOOD.SDR SWAA991601Latch · brokenAIR TURNBACK, AFTER TAKEOFF, A THUMPING NOISE HEARD ON FWD LAV. FOUND FWD LAV SINK CABINET DOOR OPENED AND LATCH BROKEN. REMOVED AND REPLACED LATCH ASSY PER MM.SDR SWAA981593Light · missingDURING SCHEDULED 1/2D CHECK, FOUND REMOVED CABIN EGRESS LIGHTING FOM. INSTALLED EGRESS TRACK LIGHTING PER BOEING MM.SDR SWAA981592Angle · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORRODED TRANSITION ANGLE NUT PLATES HOLES AT BS 727-727C, LBL 21. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981591Bulkhead Bracket · crackedDURING SCHEDULED 1/2D CHECK, FOUND FWD BULKHEAD PANEL SUPPORT BRACKET CRACKED CENTER BOTTOM NEXT TO BLEED AIR DUCT. REPAIRED PER BOEING SRM.SDR SWAA981590Angle · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORRODED TRANSITION ANGLE AT BS 727-767, RBL 21 AND BS 727C-827.SDR SWAA981589Angle · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORRODED UPPER WEB ANGLE AT BS 767 THRU 793 RBL 22. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981588Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FWD GALLEY DOOR FRAME CRACKED AT FWD LOWER CORNER AT BS 294.5 AT Z ANGLE. REPAIRED PER BOEING SRM.SDR SWAA981587Bulkhead Angle · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORRODED AFT BULKHEAD LOWER ANGLE AT BS 500D, RBL 24, LBL 24. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981586Bulkhead Angle · shearedDURING SCHEDULED 1/2D CHECK, FOUND RIVET HEAD SHEARED AT AFT BULKHEAD LOWER ANGLE AT BS 500D RBL 13.5. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981585Frame · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORRODED BELTFRAME LEG AT BS 500C, RBL 3. REMOVED AND REPLACED PER BOEING SRM.SDR SWA980660Intercostal · damagedDURING SCHEDULED 1/2 D-CHECK, FOUND LT INTERCOSTAL AT BS 500-500A UNDER TRANSITION ANGLE DAMAGED. REMOVED AND REPLACED PER BOEING SRM.
Back to N368SW, cancelled Mar 22, 2018