N105SW, cancelled Jun 7, 2013
Service difficulty reports · 156
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 = 'N105SW' AND deregistration_id = 'N105SW-2013-06-07' 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 = 'N105SW' AND deregistration_id = 'N105SW-2013-06-07' 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 SWAA010920Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND EXTERNAL FUSELAGE SKIN CRACK AT BS 312, STR 20R. REPAIRED SKIN PER SRM.SDR SWAA010377Skin · crackedDURING SCHEDULED C3 CHECK, FOUND 2.75 EXTERNAL FUSELAGE SKIN CRACK BETWEEN BS 930 & BS 936, STR 10R. REPAIRED SKIN PER SRM.SDR SWAA010376Light · looseDURING SCHEDULED C3 CHECK, FOUND EEPLS LOOSE AT FWD SECTION. SECURED EEPLS PER MM.SDR SWAA010375Slide · tornDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY TORN AT FWD END. REMOVED AND REPLACED EVAC SLIDE ASSY PER MM.SDR SWAA010076Indicator · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR SWAA002317Web · crackedDURING SCHEDULED SERVICE CHECK, FOUND 2 CRACKS IN NOSE GEAR W/W FWD WEB. REPAIRED WEB PER SRM.SDR SWAA002284Charger · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND EEPLS AFT SECTION INOP. REMOVED AND REPLACED CHARGER ASSY PER MM.SDR SWAA002247Indicator · out of positionDURING SCHEDULED C2 CHECK, FOUND BOTH AFT DOOR EMERGENCY EVAC SLIDE PRESS INDICATORS OUT OF VIEW. REPOSITIONED SLIDE ASSY''S PER MM.SDR SWAA002219Shutoff Valve · leakingAIR TURNBACK, ON CLIMBOUT B-SYSTEM HYD LOW QUANTITY LIGHT ILLUMINATED FOLLOWED BY BOTH LOW PRESSURE LIGHTS. REMOVED AND REPLACED B-SYSTEM HYD RUDDER MANUAL SHUT-OFF VALVE PER MM.SDR SWAA001815Battery Pack · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND FWD EGRESS LIGHTS INOP. REMOVED AND REPLACED FWD BATTERY CHARGER (P/N 61-282-1) AND BATTERY PACK.SDR SWAA001690Slide · looseAFT SERVICE DOOR EVACUATION SLIDE LOOSE AFTER LANDING. SECURED SLIDE ASSY PER MM.SDR SWAA001600Engine · bird strikeABORTED TAKEOFF, AT APPROX 90 KNOTS NR 1 ENG SUFFERED BIRD STRIKE. VISUALLY INSPECTED NR 1 ENG, PERFORMED ENG RUN UP AND HIGH ENERGY STOP CHECK. NO DEFECT NOTED.SDR SWAA001543Indicator · out of positionAFT SERVICE DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA001061Slide · dislodgedAFT ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA000313Battery Pack · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA000240Flashlight · inoperativeDURING SCHEDULED 1/4D CHECK, FOUND FWD AND AFT EMERGENCY FLASHLIGHTS INOP AND SAFETY STRAPS MISSING. REMOVED AND REPLACED FLASHLIGHTS AND STRAP ASSY'S PER MM.SDR SWAA000239Slide · dischargedDURING SCHEDULED 1/4D CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE PRESS IND LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA000228Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND EXTERNAL FUSELAGE SKIN CRACKED, BS 340, STRINGER 18L. REPAIRED SKIN PER XEA X2-53-275.SDR SWAA000150Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE EXTERNAL SKIN AFT ENTRY DOOR UPPER HINGE CUT OUT CRACKED. REPAIRED SKIN PER SWA RA NR 1-253-2211.SDR SWAA000109Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 178 BULKHEAD RT CHORD CRACKED, WL 207. REPAIRED BULKHEAD CHORD PER SRM.SDR SWAA000108Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 178 BULKHEAD CRACKED, LBL 12. REPAIRED BULKHEAD PER SRM.SDR SWAA992119Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FWD CARGO DOOR OUTER SKIN, FWD LOWER CORNER CRACKED. REPAIRED SKIN PER SRM.SDR SWAA991561Light · inopFWD LOWER EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT ASSY.SDR SWAA991485Sensor · damagedAIR TURNBACK, NR 3 L/E SLAT EXTEND TRANSIT LIGHT ILLUMINATED WITH SLAT RETRACTED. REMOVED AND REPLACED NR 3 SLAT PROX SENSOR.SDR SWAA991409Skin · crackedDURING SCHEDULED RON CHECK, FOUND FUSELAGE SKIN CRACKED, BS 767, STRINGER 19R. REPAIRED SKIN PER SRM.SDR SWAA991231Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED IN 3 PLACES BETWEEN BS 480-515, STRINGER 4L. REPAIRED SKIN PER SRM.SDR SWAA991162Holder · looseDURING SCHEDULED C1 CHECK, FOUND AFT SERVICE DOOR GIRT BAR HOLDERS ON SLIDE PACK LOOSE. TIGHTENED HOLDERS PER MM.SDR SWAA991161Skin · crackedDURING SCHEDULED C1 CHECK, FOUND THRU EDDY CURRENT INSP CRACKED FUSELAGE SKIN, BS 873, STRINGER 23R. REPAIRED SKIN PER SRM.SDR SWAA991151Battery Pack · dischargedDURING SCHEDULED SERVICE CHECK, FOUND EMERGENCY EXIT LIGHT INOP ON AFT GALLEY OVERHEAD. REMOVED AND REPLACED BATTERY PACKS PER MM.SDR SWAA990944Skin · crackedDURING SCHEDULED RON CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 897, STRINGER 18R. REPAIRED SKIN PER SRM.SDR SWAA990011Coalescer Bag · dirtyDURING DESCENT PASSING APPROX 1500 FT, A STRONG SMELL WAS EVIDENT IN THE COCKPIT OF TURBO OIL. SMELL CONTINUED UNTIL SHUTDOWN AT GATE. SERVICED AIR CYCLE MACHINE AND CHANGED WATER SEPARATOR BAG, LEAK CK AND OPS CK GOOD PER M/M.SDR SWAA982822Bulb · failedDURING SCHEDULED SERVICE CHECK, FOUND EMERGENCY LIGHT INOPERATIVE ON BULLNOSE AT 14 LEFT. RELAMPED PER BOEING MM, OPS CHECK OK.SDR SWAA982424Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN DOUBLER TOP CENTER AT 178 BULKHEAD BENT & CRACKED. REPAIRED PER BOEING SRM.SDR SWAA982423Skin · crackedDURING SCHEDULED C2 CHECK, FOUND CRACKED FUSELAGE SKIN AT 962, STR 21L. REPAIRED PER BOEING SRM.SDR SWAA981788Circuit Breakers · trippedON GROUND LOSS OF ALL AC POWER, SMELL OF SMOKE MULTIPLE CB'S TRIPPED. APU POWERING BUSSES AT TIME. REMOVED AND REPLACED C803 BREAKER AND APU GCU. RAN APU ENGINES ALL CHECK NORMAL PER BOEING MM.SDR SWAA981401Light · looseDURING SCHEDULED C1 CHECK, FOUND BULLNOSE EMERGENCY LIGHT ASSY LOOSE AT SEAT 9ABC. REPAIRED PER BOEING MM.SDR SWAA980707Skin · crackedDURING SCHEDULED C4 CHECK, FOUND CRACKED FUSELAGE SKIN AT BS 924, STR 24R. REPAIRED PER BOEING SRM.SDR SWA980590Skin · crackedDURING SCHEDULED A2 CHECK, FOUND CRACKED SKIN AT BS 930, STR 25R, BS 880 STR 24R AND BS 880 STR 25R. REMOVED AND REPLACED PER BOEING SRM.SDR SWA980589Skin · crackedDURING SCHEDULED A2 CHECK, FOUND CRACKED SKIN AT BS 930, STR 23R, BS 930 STR 21R AND BS 860 STR 23R. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980201Fire Loop · malfunctionedIN FLIGHT, APU FIRE WARNING SOUNDED. PERFORMED FIRE PROCEDURES AND ACTIVATED FIRE BOTTLES. AIRCRAFT RETURNED TO HOU AND MADE AN UNEVENTFUL LANDING. INSPECTED AND FOUND NO EVIDENCE OF FIRE OR OVERHEAT CONDITION. CONTINUED PER MEL. REMOVED AND REPLACED APU SDR SWAA970993Engine · damagedDURING CLIMBOUT, EXPERIENCED NR 1 ENGINE FAILURE WITH ASSOCIATIED VIBRATION AND OIL SMELL IN CABIN. AIRCRAFT RETURNED TO DAL AND MADE AN UNEVENTFUL LANDING. INSPECTED AND DISCOVERED DAMAGE FROM BIRD STRIKE. REPLACED ENGINE ASSEMBLY PER BOEING M/M.SDR SWAA970949Skin · crackedDURING SCHEDULED RON CHECK, FOUND A 2.5 FUSELAGE SKIN CRACK AT LAP JOINT AT BS 861, S25R. REPAIRED PER BOEING SRM.SDR SWAA970677Skin · dentedDURING B1/B2 CHECK, FOUND A FUSELAGE SKIN DENT AT BS 976, BETWEEN S21 AND 22L. REPAIRED PER BOEING SRM.SDR SWAA970649Skin · crackedDURING SCHEDULED 1/2 TERM CHECK, FOUND A 3 INCH FUSELAGE SKIN CRACK AT BS 970, AT S21L. REPAIRED PER BOEING SRM.SDR SWAA970640Skin · crackedDURING WALKAROUND INSPECTION, FOUND A 3 INCH CRACK ON FUSELAGE SKIN AT BS 970, AT S21L. REPAIRED PER BOEING SRM.SDR SWAA970446Web · crackedDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR WEB CRACKED APPROX .5 INCH. REPAIRED PER BOEING SRM.SDR SWAA970445Skin · crackedDURING SCHEDULED C4 CHECK, FOUND A 3 INCH FUSELAGE SKIN CRACK AT S9L, FWD OF BS 767. REPAIRED PER BOEING SRM.SDR SWAA970444Skin · crackedDURING SCHEDULED C4 CHECK, FOUND A .25 INCH FUSELAGE SKIN CRACK AT POTABLE WATER SERVICE PANEL, AT AFT LATCH POSITION. REPAIRED PER BOEING SRM.SDR SWAA970148Skin · crackedDURING WALK-AROUND, FOUND A FUSELAGE SKIN CRACK AT 7 O'CLOCK POSITION, BS 847. REPAIRED PER BOEING SRM.SDR SWAA970103Skin · crackedDURING WALKAROUND CHECK, FOUND FUSELAGE SKIN CRACK AT BS 847, AT APPROX 7 O'CLOCK POSITION. REPAIRED PER BOEING SRM.
Back to N105SW, cancelled Jun 7, 2013