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 SWAA043497Bulkhead · crackedDURING SCHEDULED 1/2D CHECK, FOUND AFT PRESSURE BULKHEAD AT BS 1016, BL 0, 4 INCHES ABOVE CENTER WEB, CRACKED. REPAIRED AFT BULKHEAD PER ER.SDR SWAA043496Stringer · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER 10R AT BS 908, CRACKED. REPAIRED STRINGER SECTION PER SRM.SDR SWAA043495Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND 2 EACH FUSELAGE SKIN CRACKS AT BS 797 AND BS 817, STRINGER 13L. REPAIRED SKIN SECTIONS PER ER.SDR SWAA043478Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP AT BS 482, STRINGER 14R, CRACKED. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA043461Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND 2 EACH CRACKS ON FLOORBEAM WEB AND FLOORBEAM UPPER CAP AT CENTER FLOORBEAM, BS 663.75. REPAIRED FLOORBEAM CHORD AND UPPER CAP PER ER.SDR SWAA043453Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN AT BS 445, STRINGER 10R, CRACKED. REPAIRED SKIN PER ACO.SDR SWAA043452Shear Tie · crackedDURING SCHEDULED 1/2D CHECK, FOUND 2 EACH SHEAR TIES CRACKED AT BS 360, BETWEEN STRINGERS 13L AND 15L. REMOVED AND REPLACED SHEAR TIES PER SRM.SDR SWAA043451Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND 2 EACH FUSELAGE SKIN CRACKS BETWEEN BS 767 AND BS 787, STRINGER 14R. REPAIRED SKIN SECTIONS PER SRM.SDR SWAA043450Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND BUTT STRAP AT BS 908, STRINGER 11L, CRACKED. REPAIRED BUTT STRAP PER SRM.SDR SWAA043430Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR UPPER FWD CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA043413Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 20L TO STR 20 R. REPAIRED FRAME PER SRM.SDR SWAA043407Stringer · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS STR 4R CRACKED AT BS 908. REPAIRED STRINGER ASSY PER SRM.SDR SWAA043406Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 482A FRAME CRACKED BETWEEN STR 20L & STR 21L. REPAIRED FRAME PER SRM.SDR SWAA043405Bulkhead · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 1016 BULKHEAD WEB CRACKED AT LBL 6, WL 208. REPAIRED WEB PER SRM.SDR SWAA043400Bracket · corrodedDURING SCHEDULED 1/2D CHECK, FOUND BOTH L1 DOOR EVACUATION SLIDE GIRT BAR FLOOR ATTACH BRACKETS CORRODED. REMOVED AND REPLACED BRACKETS PER SRM.SDR SWAA043291Skin · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN AT BS 846, STRINGER 25R CORRODED. REPAIRED SKIN PER SRM.SDR SWAA043290Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP AT BS 380, STRINGER 22L, CRACKED. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA043273Stringer · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER BETWEEN BS 695 AND BS 706, STRINGER 17L, CRACKED. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA043253Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STRINGER 21L REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA043252Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FRAME AT BS 480, BETWEEN STRINGER 20R AND STRINGER 21R, CRACKED. REPAIRED FRAME SECTION PER SRM.SDR SWAA042635Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN AT BS 790, STRINGER 18L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA042634Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN AT BS 482, STRINGER 16L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA041969Skin · crackedDURING SCHEDULED RON, FOUND FUSELAGE SKIN AT BS 516, STRINGER 16R, CRACKED. REPAIRED SKIN PER EA.SDR SWAA041586Web · crackedDURING SCHEDULED C4 CHECK, FOUND AFT CARGO DOOR FWD LOWER CORNER WEB, CRACKED. REMOVED AND REPLACED AFT CARGO DOOR PER MM.SDR SWAA041225Lens · looseDURING SCHEDULED SERVICE CHECK, FOUND EMERGENCY EXIT LIGHT BULLNOSE LENS BETWEEN ROWS 16 DEF AND 17 DEF, LOOSE. SECURED BULLNOSE LIGHT LENS PER MM.SDR SWAA041066Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 428 + 13, STRINGER 10L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA040798Slide · out of adjustR2 DOOR EVACUATION SLIDE PRESSURE INDICATOR OUT OF VIEW. ADJUSTED SLIDE ASSY PER MM.SDR SWAA040437Slide · deployedL1 DOOR EVAC SLIDE DEPLOYED AT GATE. REMOVED AND REPLACED L1 DOOR EVAC SLIDE PER MM.SDR SWAA040071Skin · crackedDURING SCHEDULED SPV, FOUND SKIN CRACKED AT BS 432, STRINGER 16L, BS 777, STRINGER 18L, BS 933, STRINGER 24L. REPAIRED SKIN PER SRM.SDR SWAA031774Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 764, STR 22L. REPAIRED SKIN PER SRM.SDR SWAA030567Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA022126Slide · looseFWD ENTRY DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR SWAA021612Gate · out of adjustAIR TURNBACK, DURING CLIMB ABRUPTLY EXTREMELY LOUD NOISE COMING FROM FWD SVC DOOR. ADJUSTED LOWER GATE ON DOOR PER MM.SDR SWAA021549Light · looseEEPLS LOOSE BETWEEN ROW'S NR 5 TO NR 8. SECURED EEPLS PER MM.SDR SWAA021079Battery · intermittentDURING SCHEDULED 1/4D CHECK, FOUND FWD EMERGENCY LIGHTS INTERMITTENT. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA021068Bear Strap · corrodedDURING SCHEDULED 1/4D CHECK, FOUND LOWER CARGO DOOR BEAR STRAP CORRODED AT BS 794.30, STR 26R TO 27R. REPAIRED BEAR STRAP PER SWA RA.SDR SWAA021071Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT FWD ENTRY DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM..SDR SWAA021061Light · inoperativeDURING SCHEDULED 1/4D CHECK, FOUND OVERHEAD BIN BULL NOSE EMERGENCY LIGHT INOP AT ROW NR 3 DEF. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA021053Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAMS CORRODED AT BS 770, BETWEEN LBL 12 TO RBL 8. REPAIRED FLOORBEAMS PER SWA RA.SDR SWAA021060Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CORRODED AT BS 754, RBL 3. REPAIRED FLOORBEAM PER SWA RA.SDR SWAA021059Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CRACKED AT BS 747, RBL 14. REPAIRED FLOORBEAM PER SWA RA.SDR SWAA012869Skin · crackedDURING SCHEDULED A1 CHECK, FOUND CAPT'S FWD WINDOW POST SKIN CRACKED .5 INCHES. REPAIRED WINDOW POST SKIN PER SRM.SDR SWAA012814Window · missingAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND VIEWING WINDOW MISSING. INSTALLED VIEWING WINDOW PER MM.SDR SWAA012544Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND VERTICAL WEB CRACKED AT BS 179, WL 227 & LBL 17.1. R&R WEB PER SRM.SDR SWAA012542Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND VERTICAL WEBS CRACKED ( 2 EA ) AT BS 183, WL 233, LBL 17.1 & RBL 17.1. R&R WEBS PER SRM.SDR SWAA012543Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND HORIZONTAL WEBS CRACKED ( 2 EA ) AT BS 180, WL 207, LBL 26.5 & RBL 26.5. R&R WEBS PER SRM.SDR SWAA012336Wire · damagedDURING SCHEDULED C2 CHECK, FOUND EEPLS INOP AND COVER BROKEN AT ROWS NR 1 & 2. REPAIRED EEPLS WIRES AND REMOVED AND REPLACED COVER PER MM.SDR SWAA012334Cover · crackedDURING SCHEDULED C2 CHECK, FOUND EEPLS COVERS CRACKED AT FWD CABIN. R&R EEPLS COVERS PER MM.SDR SWAA011756Sign · looseAFT SVC DOOR EMERGENCY EXIT SIGN LOOSE. SECURED EXIT SIGN PER MM.SDR SWAA011531Skin · crackedDURING SCHEDULED C1 CHECK, FOUND NR 1 L/E SLAT LWR SKIN CRACKED AT AFT ROW OF RIVETS, IN 4 PLACES. REMOVED AND REPLACED NR 1 L/E SLAT PER MM.
Back to N504SW, cancelled Oct 27, 2017