N505SW, cancelled Oct 27, 2017
Service difficulty reports · 313
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 = 'N505SW' AND deregistration_id = 'N505SW-2017-10-27' 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 = 'N505SW' AND deregistration_id = 'N505SW-2017-10-27' 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 SWAA095682Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095681Wedge · delaminatedDURING SCHEDULED 20Y CHECK, FOUND LT WING NR 2 SLAT O/B WEDGE DELAMINATED. REPAIRED WEDGE PER SRM.SDR SWAA095680Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND LT WING NR 1 SLAT LOWER SURFACE CRACKED. REMOVED AND REPLACED SLAT PER SRM.SDR SWAA094934Gasper Fan · faultyELECTRICAL / PLASTIC BURNING SMELL / FUMES IN CABIN AFTER 3 HRS IN FLT. TURNED OFF GASPER FAN, RECIRC FAN & GALLEY PWR. ODOR SUBSIDED WITHIN 30 SECS. REMOVED AND REPLACED GASPER FAN PER MM.SDR SWAA094079Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 482B +20, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA091734Bulkhead · crackedDURING SCHEDULED MV1 CHECK, FOUND VERTICAL BEAM WEB CRACKED AT BS 178, RBL 5.7, WL 182. REPAIRED WEB PER SWA EA.SDR SWAA091733Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 783, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA085214Slide · unwanted deployL1 EMERGENCY EXIT DOOR SLIDE INADVERTENTLY DEPLOYED. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA082638Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 847, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA082084Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 763, BETWEEN STR 19L AND STR 22L. REPAIRED SKIN PER SWA EA.SDR SWAA081295Slide · low pressureL1 DOOR EMERGENCY EVAC SLIDE PRESSURE GAUGE INDICATED OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA076263Lens · brokenL1 DOOR EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LIGHT LENS PER MM.SDR SWAA075913Slide · out of adjustDURING SCHEDULED HC1 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA075912Light · inoperativeDURING SCHEDULED HC1 CHECK, FOUND LT AFT FUSELAGE EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA075911Light · inoperativeDURING SCHEDULED HC1 CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA075914Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 952, STR 21L. REPAIRED SKIN PER SWA EA.SDR SWAA073723Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 807 AND BS 827, STR 18L AND STR 17L. REPAIRED SKIN PER SWA EA.SDR SWAA072661Skin · delaminatedDURING SCHEDULED BRDG CHECK, FOUND LEFT WING NR 2 LEADING EDGE SLAT TRAILING EDGE DELAMINATED. REPAIRED SLAT PER SRM.SDR SWAA072608Door Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FWD CARGO DOOR AFT FRAME LOWER STOP FITTING LOWER CHORD CRACKED. REMOVED AND REPLACED CHORD PER SRM.SDR SWAA072609Cover · crackedDURING SCHEDULED BRDG CHECK, FOUND FWD CABIN EMERGENCY EXIT LIGHT COVER CRACKED. REMOVED AND REPLACED LIGHT COVER PER MM.SDR SWAA072524Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 662, RBL 24.5. REPAIRED FLOORBEAM PER EA.SDR SWAA072523Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED BETWEEN BS 657 AND BS 669, LBL 24.5. REPAIRED FLOORBEAM PER EA.SDR SWAA072513Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072495Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 6R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072504Slat · delaminatedDURING SCHEDULED BRDG CHECK, FOUND RIGHT WING NR 5 L/E SLAT UPPER INBOARD T/E DELAMINATED. REPAIRED SLAT PER SRM.SDR SWAA072500Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072501Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072499Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072502Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072498Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072497Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072503Flap · delaminatedDURING SCHEDULED BRDG CHECK, FOUND LEFT WING INBOARD T/E AFT FLAP DELAMINATED AT OUTBOARD END. REPAIRED FLAP PER SRM.SDR SWAA072496Lens · brokenDURING SCHEDULED BRDG CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LIGHT LENS PER MM.SDR SWAA072379Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 9L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072380Shear Tie · crackedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CRACKED AT BS 277, STR 8L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA072360Shear Tie · crackedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CRACKED AT BS 277, STR 8L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA072361Shear Tie · crackedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CRACKED AT BS 277, STR 9L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA072344Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072346Shear Tie · crackedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CRACKED AT BS 639, STR 7L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA072345Shear Tie · crackedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CRACKED AT BS 616, STR 7L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA072343Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072342Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072341Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072281Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 783, STR 20L. REPAIRED SKIN PER SRM.SDR SWAA072254Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072253Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 5L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072255Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 787, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA072084Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 788, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA071929Window · crackedAT 18,000 FT FLIGHT DECK R2 WINDOW SHATTERED WITH ELECTRICAL ARCHING, NO PRESSURIZATION PROBLEMS NOTED. REMOVED AND REPLACED R2 WINDOW, WINDOW HEAT WIRING HARNESS AND HEAT CONTROLLER PER MM.SDR SWAA071687Attach Fitting · brokenDURING SCHEDULED A2 CHECK, FOUND LEFT WING NR 4 SPOILER INBOARD LUG BROKEN. REMOVED AND REPLACED SPOILER PER MM.
Back to N505SW, cancelled Oct 27, 2017