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 SWAA071366Flap · delaminatedDURING SCHEDULED C1 CHECK, FOUND LEFT WING INBOARD MIDFLAP DELAMINATED AT INBOARD EDGE. REMOVED AND REPLACED LEFT WING INBOARD MIDFLAP PER MM.SDR SWAA070161Sign · dislodgedRIGHT OVERWING EMERGENCY EXIT SIGN FELL OFF. INSTALLED EXIT SIGN PER MM.SDR SWAA062941Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 877, STR 23R. REPAIRED SKIN PER SWA EA.SDR SWAA062940Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 757, STR 17L. REPAIRED SKIN PER SWA EA.SDR SWAA061921Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 445, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA061860Battery · inoperativeFOUND LT FWD EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT BATTERY PER MM.SDR SWAA061452Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 787, STR 23L. REPAIRED SKIN PER SWA EA.SDR SWAA061451Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 816, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA060548Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 943, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA060547Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 872, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA060186Cover · looseDURING SCHEDULED C1 CHECK, FOUND LT EXTERIOR UPPER EMERGENCY EXIT LIGHT COVER LOOSE. SECURED COVER PER MM.SDR SWAA053192Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT BS 455, STR 24R. REPAIRED FRAME PER BFG ER.SDR SWAA053191Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 24R. REPAIRED FRAME PER BFG ER.SDR SWAA053160Stringer Clip · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 351, STR 18L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA053159Stringer Clip · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 348, STR 18L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA053132Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED AT AFT CARGO DOOR CUTOUT, FWD LOWER CORNER. REPAIRED SKIN PER SRM.SDR SWAA052888Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FLOOR WEB CRACKED BETWEEN BS 188 TO BS 196, LT & RT SIDE, WL 208. REPAIRED FLOOR WEB PER SRM.SDR SWAA052887Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STUB FRAMES CRACKED AT BS 188, LT & RT SIDE, WL 208. REPAIRED STUB FRAMES PER SRM.SDR SWAA051871Bushing · wornIN ALL PHASE OF FLIGHT - VIBRATION FELT & TAIL OSCILLATION. REMOVED AND REPLACED LT ELEVATOR TAB INBOARD HINGE HARDWARE PER MM.SDR SWAA051349Battery Pack · dischargedDURING SCHEDULED A1 CHECK, FOUND L2 DOOR EMERGENCY LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA051047Beam · crackedDURING SCHEDULED SPECIAL VISIT, FOUND VERTICAL BEAM WEB CRACKED AT BS 180, WL 180, LBL 5.7. REPAIRED WEB PER SRM.SDR SWAA051015Tru · faultyDIVERSION/DECLARED EMERGENCY. LOST CABIN PRESSURE, NR 1 TRANSFORMER RECTIFIER & EQUIPMENT COOLING FAN INOP. REMOVED AND REPLACED NR 1 TRANSFORMER RECTIFIER & NR 1 ENGINE GENERATOR PER MM.SDR SWAA050766Lens · missingRIGHT OVERWING EMERGENCY EXIT LIGHT COVER MISSING. INSTALLED LIGHT COVER PER MM.SDR SWAA050761Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. RE-INSTALLED SLIDE PER MM.SDR SWAA050321Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN AT AFT ENTRY DOOR UPPER AFT CORNER, CRACKED. REPAIRED SKIN PER EA.SDR SWAA050320Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN AT AFT SERVICE DOOR UPPER HINGE, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA050319Frame · crackedDURING SCHEDULED C2 CHECK, FOUND AFT CARGO DOOR FWD FRAME AT THIRD STOP CRACKED. REPAIRED FRAME PER EA.SDR SWAA043384Pressure Panel · crackedDURING SCHEDULED 1/2D CHECK, FOUND BEADED PRESSURE WEB AT BS 663.75, LBL 39.5, CRACKED. REPAIRED PRESSURE WEB PER EA.SDR SWAA043364Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN AT BS 932, STRINGER 23L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA043350Bulkhead · crackedDURING SCHEDULED 1/2D CHECK, FOUND 2 EACH CRACKS AT BS 1016 PRESSURE BULKHEAD DOME WEB CENTER SECTION AT 7 O'CLOCK AND 12 O'CLOCK POSITION. REPAIRED WEB SECTIONS PER EA.SDR SWAA043348Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN AT BS 790, STRINGER 17L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA043347Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN AT BS 482 + 16, STRINGER 10L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA043346Shear Tie · crackedDURING SCHEDULED 1/2D CHECK, FOUND SHEAR TIE AT BS 360, BETWEEN STRINGERS 14L AND 15L, CRACKED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA043345Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STINGER CLIP AT BS 706, STRINGER 10R, CRACKED. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA043315Rib · crackedDURING SCHEDULED 1/2D CHECK, FOUND RT WING LOWER RIB CHORD AT WBL 135.5, CRACKED. REPAIRED RT WING RIB CHORD PER EA.SDR SWAA042597Power Supply · inoperativeDURING SCHEDULED PM CHECK, FOUND AFT ENTRY AND AFT SERVICE EMERGENCY EXIT OVERHEAD LIGHTS INOP. REMOVED AND REPLACED BATTERY POWER SUPPLY PER MM.SDR SWAA042263Lamp · inoperativeDURING SCHEDULED PM CHECK, FOUND EMERGENCY EXIT LIGHTS AT ROWS 6 ABC, 8 ABC, INOP. RELAMPED EMERGENCY EXIT LIGHTS PER MM.SDR SWAA041687Slide · dislodgedR2 DOOR EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA040758Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 970, STRINGER 21L AND BS 938, STRINGER 23R. REPAIRED SKIN PER SRM.SDR SWAA040128Skin · crackedDURING SCHEDULED SC, FOUND SKIN CRACKED AT BS 515 TO BS 517 AT STRINGER 12L. REPAIRED SKIN CRACK PER SRM.SDR SWAA032537Lens · looseLT OVERWING EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR SWAA032536Light · looseEEPLS LOOSE AT MID CABIN. SECURED EEPLS PER MM.SDR SWAA032292Light · inoperativeEEPLS INOP BETWEEN ROWS NR 10 AND 11. REPAIRED EEPLS PER MM.SDR SWAA031816Cover · missingDURING SCHEDULED C1 CHECK, FOUND EEPLS COVER MISSING AT ROW NR 12. INSTALLED COVER PER MM.SDR SWAA031815Lens · missingDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR OVERHEAD EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA031736Pump · faultyAIR TURNBACK, ON GEAR RETRACT 'A' SYSTEM HYD PUMP LIGHTS AND MASTER CAUTION LIGHTS ILLUMINATED, 'A' SYSTEM HYD PRESS DROPPED TO 1000 PSI. REMOVED AND REPLACED ENGINE DRIVEN HYD PUMP 'A' AND CASE DRAIN FILTER PER MM.SDR SWAA031481Cover · crackedDURING SCHEDULED PM CHECK, FOUND EEPLS COVER CRACKED AT ROW NR 3. REMOVED AND REPLACED EEPLS COVER PER MM.SDR SWAA031188Battery · inoperativeDURING SCHEDULED SPECIAL VISIT, FOUND EEPLS SECTION INOP IN AFT CABIN. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA031175Light · looseEEPLS SECTION LOOSE NEAR GALLEY. SECURED EEPLS PER MM.SDR SWAA031160Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 780, STR 24L. REPAIRED SKIN PER SRM.
Back to N505SW, cancelled Oct 27, 2017