N502SW, cancelled Jan 29, 2014
Service difficulty reports · 246
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 = 'N502SW' AND deregistration_id = 'N502SW-2014-01-29' 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 = 'N502SW' AND deregistration_id = 'N502SW-2014-01-29' 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 SWAA074352Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 16L. REPAIRED FRAME PER SRM.SDR SWAA074299Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 9L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074300Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074301Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074254Stringer · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER 15L CRACKED AT BS 380. REPAIRED STRINGER PER SRM.SDR SWAA073380Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA072897Slide · low pressureDURING SCHEDULED SERVICE CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE GAUGE INDICATED OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA072421Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA070677Charger · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND LT AFT CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK AND BATTERY CHARGER PER MM.SDR SWAA064882Connector · looseDURING SCHEDULED SPV CHECK, FOUND EMERGENCY EXIT LIGHT INOP AT ROW 15 ABC. RESEATED D7274 PIN CONNECTOR PER MM.SDR SWAA064359Slide · low pressureDURING SCHEDULED A1 CHECK, L2 DOOR EMERGENCY EVAC SLIDE PRESSURE GAUGE INDICATED OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA063521Battery · faultyUPON LANDING, AFT CABIN EMERGENCY EXIT LIGHT STAYS ILLUMINATED. BATTERY BASE IAW MM.SDR SWAA063320Battery · inoperativeAFT CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA063222Flap · crackedDURING SCHEDULED C2 CHECK, FOUND LT WING NR 1 L/E KRUEGER FLAP CRACKED AT INBOARD ACTUATOR ROD END CUTOUT. REMOVED AND REPLACED KRUEGER FLAP PER MM.SDR SWAA063221Glowstrip · missingDURING SCHEDULED C2 CHECK, FOUND EEPLS PHOTOLUMINESCENT STRIP MISSING AT RT OVERWING EXIT. REPLACED EEPLS PHOTOLUMINESCENT STRIP PER MM.SDR SWAA063220Glowstrip · missingDURING SCHEDULED C2 CHECK, FOUND EEPLS PHOTOLUMINESCENT STRIP MISSING AT LT OVERWING EXIT. REPLACED EEPLS PHOTOLUMINESCENT STRIP PER MM.SDR SWAA063219Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA061615Web · crackedDURING SCHEDULED C1 CHECK, FOUND NOSE GEAR WHEEL WELL PRESSURE WEB CRACKED AT BS 251.625, FROM LBL 7.75 TO RBL 7.75. REPAIRED PRESSURE WEB PER SWA EA.SDR SWAA061518Skin · crackedFUSELAGE SKIN CRACKED AT BS 747, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA061038Cover · missingEEPLS STRIP COVER MISSING BETWEEN ROW 12 TO ROW 17. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA060330Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 971, STR 21L. REPAIRED SKIN PER SWA EA.SDR SWAA054168Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 737D, STR 23L. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA053587Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT AFT CARGO DOOR CUTOUT, FWD FRAME AT NR 5 STOP FITTING. REPAIRED FRAME PER BFG ER.SDR SWAA053586Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, FWD FRAME AT STOP FITTING, STR 24R. REPAIRED FRAME PER BFG ER.SDR SWAA053564Buttstrap · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME BUTT STRAP CRACKED AT BS 360, BETWEEN STR 14R TO STR 15R. REMOVED AND REPLACED BUTT STRAP PER BFG ER.SDR SWAA053378Stringer · damagedDURING SCHEDULED MAINTENANCE, FOUND FUSELAGE STRINGER DAMAGED AT BS 482, STR 3R. REPAIRED STRINGER IAW SRM.SDR SWAA051414Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 790, STR 17L. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA050765Ballast · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BALLAST ASSY PER MM.SDR SWAA050515Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FRAME AT BS 287,STR 16L CRACKED. REPAIRED FRAME SECTION PER EA.SDR SWAA050514Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP AT BS 287,STR 16L CRACKED. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA050479Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM TEE CAP AT BS 986, FROM RBL 48 TO BL 0, CORRODED. REPAIRED TEE CAP PER EA.SDR SWAA050454Tee Fitting · crackedDURING SCHEDULED 1/2D CHECK, FOUND AFT CARGO DOOR AFT LOWER TEE CHORD, CRACKED. REMOVED AND REPLACED TEE CHORD PER SRM.SDR SWAA050441Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM UPPER CHORD AT BS 664, RBL 24.75, CRACKED. REPAIRED FLOORBEAM CHORD PER EA.SDR SWAA050440Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND 4 EACH CRACKS ON FLOORBEAM UPPER CHORD BETWEEN BS 659 AND BS 668, RBL 24.82. REPAIRED FLOORBEAM CHORD PER EA.SDR SWAA050424Flap · delaminatedDURING SCHEDULED 1/2D CHECK, FOUND LT WING OUTBOARD FOREFLAP DELAMINATED. REPAIRED FOREFLAP PER SRM.SDR SWAA050417Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER WEB AT BS 295, STRINGER 16L, CRACKED. REMOVED AND REPLACED STRINGER WEB SECTION PER SRM.SDR SWAA050416Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND AFT CARGO COMPARTMENT STRINGER CLIP AT BS 807, STRINGER 25L, CRACKED. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA050400Hook · corrodedDURING SCHEDULED 1/2D CHECK, FOUND GIRT BAR FLOOR FITTING ASSY AT BS 344, LBL 59, CORRODED. REMOVED AND REPLACED GIRT BAR FITTING ASSY PER SRM.SDR SWAA050399Stringer · corrodedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER 25L AT BS 970, CORRODED. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA050233Skin · delaminatedDURING SCHEDULED C1 CHECK, FOUND LT WING INBOARD T/E AFT FLAP DELAMINATED. REMOVED AND REPLACED LT WING T/E AFT FLAP PER MM.SDR SWAA050146Slide · out of adjustR1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA050089Slide · out of adjustR1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA042976Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN AT BS 967, STRINGER 24L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA042352Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 525, STR 10R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA041879Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN AT BS 935, STRINGER 24L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA040827Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND R2 DOOR EVAC SLIDE CABLE MISROUTED. REROUTED R2 DOOR EVAC SLIDE CABLE PER MM.SDR SWAA040826Lens · crackedDURING SCHEDULED C2 CHECK, FOUND FWD EMERGENCY EXIT LIGHT LENS CRACKED. REMOVED AND REPLACED FWD LIGHT LENS PER MM.SDR SWAA032533Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND .75 LONG CRACK AT VERTICAL CHORD, BS 178, WL 184. REPAIRED VERTICAL CHORD PER SRM.SDR SWAA031882Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND NR 2 L/E SLAT DELAMINATED ON OUTBD UPPER SURFACE. REMOVED AND REPLACED NR 2 L/E SLAT PER MM.SDR SWAA030766Trunnion · corrodedDURING SCHEDULED SERVICE CHECK, FOUND LT MLG TRUNNION PIN CORRODED. REMOVED AND REPLACED LT MLG TRUNNION PIN PER MM.
Back to N502SW, cancelled Jan 29, 2014