N692SW, cancelled Sep 7, 2017
Service difficulty reports · 434
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 = 'N692SW' AND deregistration_id = 'N692SW-2017-09-07' 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 = 'N692SW' AND deregistration_id = 'N692SW-2017-09-07' 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 SWAA062422Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 358, STR 15L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA062421Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 358, STR 14L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA062420Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 943, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA061898Casting · brokenLT WING NR 4 GROUND SPOILER HINGE CASTING BROKEN. REMOVED AND REPLACED NR 4 SPOILER PER MM.SDR SWAA061731Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 503, STR 15L, ABOVE WING ILLUMINATION LIGHT. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA061312Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 739E, STR 22R. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA060901Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 941 TO BS 944.5, STR 23R. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA060732Slide · out of positionR1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA060731Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 783, BETWEEN STR 21L TO STR 22L. REPAIRED SKIN PER SRM.SDR SWAA060730Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 272, STR 16L. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA060276Battery Pack · inoperativeDURING SCHEDULED A2 CHECK, FOUND AFT EXTERIOR EMERGENCY LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA060125Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 494 TO BS 496, STR 10R. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA060124Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 501D TO BS 503D, STR 12L. REPAIRED SKIN PER SWA EA.SDR SWAA060123Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND VERTICAL BEAM WEB CRACKED AT BS 178 BLKHD, RBL 5.7, WL 184. REPAIRED WEB PER SRM.SDR SWAA060048Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR CUTOUT, UPPER AFT CORNER. REPAIRED SKIN PER SRM.SDR SWAA060047Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 733D TO BS 740D, STR 21R. REPAIRED SKIN PER SWA EA.SDR SWAA060046Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 757, STR 21R. REPAIRED SKIN PER SWA EA.SDR SWAA060045Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 737, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA060044Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500A, STR 10R. REPAIRED SKIN PER SWA EA.SDR SWAA060043Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 510, STR 15R. REPAIRED SKIN PER SWA EA.SDR SWAA060042Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT EXTERNAL A/C SUPPLY ACCESS CUTOUT, FWD LT CORNER, BS 522.35, STR 28L. REPAIRED SKIN PER SWA EA.SDR SWAA052959Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 365, STR 19R. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA052958Skin · delaminatedDURING SCHEDULED C2 CHECK, FOUND LT WING OTBD T/E FOREFLAP DELAMINATED. REMOVED AND REPLACED FOREFLAP PER MM.SDR SWAA052957Battery Pack · inoperativeDURING SCHEDULED C2 CHECK, FOUND RT CABIN AISLE BULLNOSE EMERGENCY LIGHT INOP AT ROW 19 AND ROW 20. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA052296Bulb · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND L2 DOOR VERTICAL EMERGENCY LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA052080Controller · inoperativeAIR TURNBACK, AUTO STANDBY & DC FUNCTION INOP ON PRESSURIZATION CONTROL PANEL. REMOVED AND REPLACED AUTO PRESSURIZATION CONTROLLER PER MM.SDR SWAA051762Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA051748Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500D, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA051417Slide · out of adjustL2 & R2 EMERGENCY EVAC SLIDES OUT OF ADJUST. ADJUSTED SLIDES PER MM.SDR SWAA051178Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 969.5, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA051144Bottle · dischargedDURING SCHEDULED SERVICE CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE PRESSURE INDICATING LOW. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA050055Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 727E, STRINGER 18R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA043362Light · brokenDURING SCHEDULED C3 CHECK, FOUND RT AFT CABIN LOWER EMERGENCY EXIT LIGHT ASSEMBLY BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY PER MM.SDR SWAA043361Skin · crackedDURING SCHEDULED C3 CHECK, FOUND 2 EACH FUSELAGE SKIN CRACKS AT BS 760, STRINGER 19L AND BS 750, STRINGER 18R. REPAIRED SKIN SECTIONS PER SRM.SDR SWAA043360Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN AT BS 500A, STRINGER 10R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA042871Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 727D, STRINGER 22L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA042334Skin · crackedDURING SCHEDULED C2 CHECK, FOUND TEAR STRAP AT BS 890, STRINGER 24R, CRACKED. REPAIRED STRAP PER EA.SDR SWAA042332Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND R2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR SWAA042331Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN AT BS 877, STRINGER 24R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA041864Shear Tie · crackedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE AT BS 500D, STRINGER 27L, CRACKED. REPAIRED SHEAR TIE PER SRM.SDR SWAA041863Stiffener · corrodedDURING SCHEDULED 1/4D CHECK, FOUND RADIAL STIFFENER AT BS 1016, BL 0, CORRODED. REPAIRED STIFFENER PER SRM.SDR SWAA041862Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN AT BS 349, STRINGER 20L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA041861Window Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND BOTH LT AND RT NR 1 COCKPIT WINDOW POSTS CRACKED AT UPPER CORNERS. REPAIRED RT AND LT WINDOW POSTS PER EA.SDR SWAA041829Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIES AT BS 500B, LBL 18, BS 500C, LBL 18, BS 500D, LBL 16 TO LBL 19, CORRODED. REMOVED AND REPLACED SHEAR TIES PER SRM.SDR SWAA041828Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN AT BS 959, STRINGER 17L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA041827Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND BEADED PRESSURE WEB AT BS 665, LBL 30.5, CRACKED. REMOVED AND REPLACED BEADED PRESSURE WEB SECTION PER SRM.SDR SWAA041826Stringer · corrodedDURING SCHEDULED 1/4D CHECK, FOUND STRINGER 25L, BS 969, CORRODED. REPAIRED STRINGER SECTION PER SRM.SDR SWAA041817Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE AT BS 847, RBL 14, CORRODED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA041816Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM AT BS 727D + 6', LBL 2 TO RBL 7, CORRODED. REPAIRED FLOORBEAM PER EA.SDR SWAA041815Stringer · corrodedDURING SCHEDULED 1/4D CHECK, FOUND STRINGER 27R, BS 500B AND STRINGER 25L, BS 956, CORRODED. REPAIRED STRINGER SECTIONS PER SRM.
Back to N692SW, cancelled Sep 7, 2017