N333SW, cancelled Sep 18, 2017
Service difficulty reports · 328
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 = 'N333SW' AND deregistration_id = 'N333SW-2017-09-18' 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 = 'N333SW' AND deregistration_id = 'N333SW-2017-09-18' 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 SWAA063013Lens · missingBULL NOSE EMERGENCY EXIT LIGHT LENS MISSING AT ROW 1 DEF. INSTALLED LIGHT LENS PER MM.SDR SWAA062928Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 970, STR 21L. REPAIRED SKIN PER SWA EA.SDR SWAA062927Lamp · inoperativeDURING SCHEDULED C4 CHECK, FOUND SIDEWALL EMERGENCY EXIT LIGHT INOP AT R2 DOOR. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA062926Lamp · inoperativeDURING SCHEDULED C4 CHECK, FOUND OVERHEAD EMERGENCY EXIT LIGHT INOP AT 16 DEF. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA062356Lamp · inoperativeDURING SCHEDULED MV1 CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA061528Glowstrip · wornDURING SCHEDULED SERVICE CHECK, FOUND MID CABIN EEPLS PHOTOLUMINESCENT STRIP WORN. REMOVED AND REPLACED PHOTOLUMINESCENT STRIP PER MM.SDR SWAA061519Slide · out of adjustL2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA053354Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 947, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA053353Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 927, STR 24L. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA053352Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND BULLNOSE EMERGENCY LIGHT INOP AT ROW 4 DEF. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA052276Battery · inoperativeDURING SCHEDULED A1 CHECK, FOUND RIGHT AFT EXTERIOR EMERGENCY LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA052041Bulb · inoperativeDURING SCHEDULED A2 CHECK, FOUND R1 DOOR LOWER EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA052040Bulb · inoperativeDURING SCHEDULED A2 CHECK, FOUND RT AFT CABIN BULLNOSE EMERGENCY LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA052039Slide · out of limitsDURING SCHEDULED A2 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE PRESSURE INDICATING OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA051988Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA051850Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA051849Skin · crackedDURING SCHEDULED C4 CHECK, FOUND RT WING NR 5 L/E SLAT T/E LOWER SKIN CRACKED. REPAIRED SKIN PER SWA EA.SDR SWAA051188Fitting · crackedDURING SCHEDULED 1/4D CHECK, FOUND LT WING MLG HYDRAULIC ACTUATOR ATTACH FITTING CRACKED AT WS 134.5. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA051171Door Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND R1 DOOR AFT FRAME CRACKED AT NR 2 & NR 3 STOP FITTING CUTOUTS. REMOVED AND REPLACED DOOR PER MM.SDR SWAA051160Rib · crackedDURING SCHEDULED 1/4D CHECK, FOUND LT WING RIB CHORD CRACKED AT WBL 135.5, FWD OF AFT SPAR. REPAIRED RIB PER SWA EA.SDR SWAA051159Pressure Panel · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE BEADED WEB CRACKED AT BS 665.5, RBL 39.5. REPAIRED WEB PER SRM.SDR SWAA051158Shim · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN SHIM CRACKED AT BS 314, STR 17R. REMOVED AND REPLACED SHIM PER SWA EA.SDR SWAA051150Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND LONGITUDINAL FLOORBEAM T-CHORD CRACKED AT BS 660.5, BL 0. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA051149Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 518, STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA051148Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 297, STR 17R. REPAIRED SKIN PER SWA EA.SDR SWAA051136Floor Support · crackedDURING SCHEDULED 1/4D CHECK, FOUND 2 EA CRACKS AT NR 2 LONGITUDINAL FLOOR SUPPORT TEE, BS 664 & BS 668.5. REPAIRED FLOOR SUPPORT PER SWA EA.SDR SWAA051135Floor Support · crackedDURING SCHEDULED 1/4D CHECK, FOUND 3 EA CRACKS AT NR 3 LONGITUDINAL FLOOR SUPPORT TEE, BS 662.5, BS 665.5 & BS 669. REPAIRED FLOOR FLOOR SUPPORT PER SWA EA.SDR SWAA051134Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA051012Skin · crackedDURING WALK AROUND INSPECTION, FOUND FUSELAGE SKIN CRACKED AT BS 727D + 2, STR 19R. REPAIRED SKIN PER SWA EA.SDR SWAA051011Skin · crackedDURING WALK AROUND INSPECTION, FOUND FUSELAGE SKIN CRACKED AT BS 312, STR 20R. REPAIRED SKIN PER SWA EA.SDR SWAA050002Glowstrip · looseEMERGENCY EXIT PHOTOLUMINESCENT STRIP AT ROW 8 ABC, LOOSE. REMOVED AND REPLACED PHOTOLUMINESCENT STRIP PER MM.SDR SWAA043369Glowstrip · wornDURING SCHEDULED C2 CHECK, FOUND FWD EPPLS PHOTOLUMINESCENT STRIPS WORN. REMOVED AND REPLACED PHOTOLUMINESCENT STRIPS PER MM.SDR SWAA043368Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN AT BS 540, STRINGER 16L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA041322Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN AT BS 328, STRINGER 28R, CRACKED. REPAIRED SKIN PER ACO.SDR SWAA041321Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN AT BS 937, STRINGER 25R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA041319Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND RT NR 4 L/E SLAT INBOARD END DELAMINATED. REMOVED AND REPLACED NR 4 L/E SLAT PER MM.SDR SWAA041305Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND R2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR SWAA041304Skin · crackedDURING SCHEDULED C4 CHECK, FOUND R1 DOOR FRAME UPPER HINGE CUTOUT LOWER RADIUS, CRACKED. REPAIRED DOOR FRAME CUTOUT LOWER RADIUS PER EA.SDR SWAA040276Cable · misroutedDURING SCHEDULED C3 CHECK, FOUND R2 DOOR EVAC SLIDE CABLE MISROUTED. REROUTED SLIDE CABLE PER MM.SDR SWAA040275Hook · looseDURING SCHEDULED C3 CHECK, FOUND L2 DOOR EVAC SLIDE HOOK LOOSE. REMOVED AND REPLACED FASTENERS SECURING SLIDE CONTAINER PER MM.SDR SWAA040274Lens · crackedDURING SCHEDULED C3 CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT LENS CRACKED. REMOVED AND REPLACED LIGHT LENS PER MM.SDR SWAA032016Spring · wornAILERONS SLUGGISH WHEN TURNING FROM EITHER DIRECTION. REMOVED AND REPLACED AILERON FEEL AND CENTERING MECHANISM SPRINGS PER MM.SDR SWAA031862Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND WINDOW CUTOUT FWD UPPER CORNER CRACKED AT RT WINDOW NR 11. REPAIRED SKIN PER SRM.SDR SWAA031861Stringer · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STRINGER CRACKED (2 EA) STR 11R, BS'S 385 AND 425. REPAIRED STRINGER PER SRM.SDR SWAA031860Splice · crackedDURING SCHEDULED SPECIAL VISIT, FOUND STRINGER SPLICES CRACKED (3 EA) BS 360 AT STR 4L, BS 360 AT STR 10L AND BS 908 AT STR 4R. REMOVED AND REPLACED STRINGER SPLICES PER SRM.SDR SWAA031821Stringer · crackedDURING SCHEDULED SPECIAL VISIT, FOUND STRINGER CRACKED AT BS 1011, STRINGER 7L. REPAIRED STRINGER PER SRM.SDR SWAA031224Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED (2 EA) AT STR 10L, BS 500C AND BS 500D. REPAIRED SKIN PER SRM.SDR SWAA031036Duct · looseDUAL AIR TURNBACK, NR 2 ENG OVERHEAT LIGHT ILLUMINATED WITH THROTTLE LEVER ADVANCEMENT. FOUND NR 2 ENG 9TH STG PNEUMATIC BLEED AIR DUCT MANIFOLD LOOSE. TIGHTENED DUCT MANIFOLD BOLTS PER MM.SDR SWAA030679Flashlight · inoperativeFWD CABIN INBD EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT AND BATTERY PER MM.SDR SWAA030472Battery Pack · dischargedDURING SCHEDULED SERVICE CHECK, FOUND AFT GALLEY EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.
Back to N333SW, cancelled Sep 18, 2017