N504SW, cancelled Oct 27, 2017
Service difficulty reports · 277
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 = 'N504SW' AND deregistration_id = 'N504SW-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 = 'N504SW' AND deregistration_id = 'N504SW-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 SWAA073126Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 294, STR 13L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073127Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 16R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073128Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 482, STR 16R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073129Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 663.75, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073125Slat · wornDURING SCHEDULED 18Y CHECK, FOUND LEFT WING NR 5 L/E SLAT WORN AT INBOARD T/E. REPAIRED SLAT PER SRM.SDR SWAA073139Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073130Shear Tie · corrodedDURING SCHEDULED 18Y CHECK, FOUND SHEAR TIE CORRODED AT BS 967, STR 8R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA073138Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073137Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073136Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073135Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073134Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073133Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 597, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073141Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073143Skin · debondedDURING SCHEDULED 18Y CHECK, FOUND RIGHT WING OUTBOARD T/E AFT FLAP UPPER SKIN DISBONDED AT INBOARD END. REPAIRED FLAP PER SRM.SDR SWAA073109Skin · debondedDURING SCHEDULED 18Y CHECK, FOUND RIGHT WING INBOARD FORE FLAP LOWER SURFACE DISBONDED. REPAIRED FORE FLAP PER SRM.SDR SWAA073111Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073110Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072575Lamp · inoperativeDURING SCHEDULED MV1 CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA072402Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 259, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA072401Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 259, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA072399Skin · crackedFUSELAGE SKIN CRACKED AT BS 374, STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA072358Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 11L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072359Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA071047Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 777, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA071048Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 520, STR 28L. REPAIRED SKIN PER SWA EA.SDR SWAA064276Motor · seizedFLAPS WOULD NOT EXTEND PAST POSITION 5, ALTERNATE FLAPS NO HELP. REMOVED AND REPLACED FLAP ALT HYDRAULIC MOTOR PER MM.SDR SWAA063189Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 902, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA062455Spoiler · looseLEFT WING NR 4 GROUND SPOILER OUTBOARD HINGE LOOSE. REMOVED AND REPLACED NR 4 SPOILER PER MM.SDR SWAA062328Lens · missingDURING SCHEDULED A2 CHECK, FOUND EMERGENCY EXIT LIGHT LENS MISSING AT AFT SERVICE DOOR. INSTALLED LIGHT LENS PER MM.SDR SWAA061121Pressure Panel · crackedDURING SCHEDULED C2 CHECK, FOUND NLG W/W CEILING PANEL CUTOUT CRACKED AT BS 251.625, LBL 7.75 & RBL 7.75. REPAIRED PANELS PER SWA EA.SDR SWAA061093Flap · delaminatedDURING SCHEDULED C2 CHECK, FOUND LH WING OUTBD T/E AFT FLAP DELAMINATED. R&R FLAP PER MM.SDR SWAA060989Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 930, STR 21R. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA060780Lens · looseL1 DOOR LOWER EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR SWAA054091Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE LATCH CABLE ASSY MISROUTED. REROUTED CABLE ASSY PER MM.SDR SWAA053733Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 405, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA052930Skin · wornDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN WORN AT BS 865, UNDER DORSAL FIN BLADE SEAL. REPAIRED SKIN PER SRM.SDR SWAA052709Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 947, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA052190Slide · dischargedDURING SCHEDULED RON CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE PRESSURE INDICATING LOW. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA051415Wedge · delaminatedDURING SCHEDULED RON CHECK, FOUND RT WING INBOARD MIDFLAP T/E WEDGE DELAMINATED. REMOVED AND REPLACED MIDFLAP T/E WEDGE PER MM.SDR SWAA051376Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 882, STR 26R. REPAIRED SKIN PER SRM.SDR SWAA051359Slide · out of adjustR1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA050384Bolt · wornDURING SCHEDULED C2 CHECK, LT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED NR 1 TAB HINGE BOLT PER MM.SDR SWAA050383Frame · crackedDURING SCHEDULED C2 CHECK, FOUND FWD SERVICE DOOR LOWER FRAME AT AFT LOWER STOP, CRACKED. REMOVED AND REPLACED FWD SERVICE DOOR MM.SDR SWAA050382Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN AT BS 937, STRINGER 23R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA043711Slide · out of adjustL1 DOOR EVACUATION SLIDE OUT OF ADJUST. REINSTALLED SLIDE ASSY PER MM.SDR SWAA043506Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN AT WINDOW CUTOUT, BS 482A + 10, STRINGER 13R, CRACKED. REPAIRED SKIN PER ER.SDR SWAA043494Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP AT BS 380, STRINGER 20L, CRACKED. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA043493Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND R1 DOOR CUTOUT LOWER AFT CORNER SKIN CRACKED. REPAIRED SKIN PER ER.SDR SWAA043498Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND BUTT STRAP AT BS 907, STRINGER 4R, CRACKED. REPAIRED BUTT STRAP PER SRM.
Back to N504SW, cancelled Oct 27, 2017