N689SW, cancelled Mar 16, 2018
Service difficulty reports · 360
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 = 'N689SW' AND deregistration_id = 'N689SW-2018-03-16' 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 = 'N689SW' AND deregistration_id = 'N689SW-2018-03-16' 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 SWAA096814Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 867, BETWEEN STR 27L TO 27R. REPAIRED SHEAR TIE PER BAC DWG.SDR SWAA097069Failsafe · crackedDURING SCHEDULED 24Y CHECK, FOUND FAIL-SAFE CHORD ANGLE CRACKED AT BS 460, STR 28R. REMOVED AND REPLACED CHORD PER SRM.SDR SWAA097063Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SHEAR TIE FRAME CORRODED AT BS 767, STR 26R TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA097062Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SHEAR TIE FRAME CORRODED AT BS 747, STR 26R TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA096641Hook · looseDURING SCHEDULED 24Y CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR HOOK LOOSE. REMOVED AND REPLACED HOOK PER MM.SDR SWAA096640Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 23L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096639Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 480, STR 25L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096572Stringer · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CRACKED AT BS 1008, STR 26R. REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA096571Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 14R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096570Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 22L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096569Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 21L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096568Bulkhead · corrodedDURING SCHEDULED 24Y CHECK, FOUND BULKHEAD CHORD CORRODED AT BS 1016, BETWEEN STR 26L TO STR 27L. REMOVED AND REPLACED CHORD PER SRM.SDR SWAA094564Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 291.5, RT 6 HOLES DOWN FROM THE TOP. REPAIRED FRAME PER EA.SDR SWAA094206Lens · brokenEMERGENCY BULLNOSE LIGHT LENS BROKEN AT 17 ABC. REMOVED AND REPLACED LENS PER MM.SDR SWAA093015Downlock Sensor · faultyDECLARED EMERGENCY / DIVERSION,14,000FT STEADY RED LIGHT ON NOSE GEAR. PUT GEAR DOWN, GREEN LIGHT ON MAINS NO GREEN ON NOSE GEAR. GEAR CHECK DOWN THRU VIEW PORT. LANDED NORMALLY. REMOVED AND REPLACED NOSE GEAR DOWNLOCK SENSOR PER MM.SDR SWAA090099Wedge · delaminatedDURING SCHEDULED HC2 CHECK, FOUND LT WING NR 2 SLAT T/E WEDGE DELAMINATED. REPAIRED SLAT PER SRM.SDR SWAA090098Strip · looseDURING SCHEDULED HC2 CHECK, FOUND EEPLS STRIP LOOSE AT ROW 8. SECURED EEPLS PER MM.SDR SWAA090097Hook · looseDURING SCHEDULED HC2 CHECK, FOUND L1 DOOR EMERGENCY EVACUATION SLIDE FWD GIRT BAR STOW HOOK ON CASE LOOSE. SECURED HOOK PER MM.SDR SWAA090096Fitting · looseDURING SCHEDULED HC2 CHECK, FOUND R2 DOOR EMERGENCY EVACUATION SLIDE AFT GIRT BAR FITTING LOOSE. SECURED FITTING PER MM.SDR SWAA090095Light · inoperativeDURING SCHEDULED HC2 CHECK, FOUND RT OVERWING EMERGNECY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA090094Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 270, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA084504Lens · missingDURING SCHEDULED MV3 CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT LENS MISSING AT ROW 23 DEF. INSTALLED LENS PER MM.SDR SWAA083347Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 344, STR 22L. REPAIRED FRAME PER EA.SDR SWAA083182Light · inoperativeDURING SCHEDULE 22Y CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT INOP. R&R LIGHT ASSY PER MM.SDR SWAA082924Light · inoperativeDURING SCHEDULED 22Y CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT INOP AT ROW 12 DEF. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA082925Light · inoperativeDURING SCHEDULED 22Y CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT INOP AT ROW 21 DEF. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA082926Light · inoperativeDURING SCHEDULED 22Y CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT INOP AT ROW 23 ABC. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA082765Flashlight · crackedDURING SCHEDULED 22Y CHECK, FOUND AFT CABIN EMERGENCY FLASHLIGHT LENS CRACKED. REMOVED AND REPLACED FLASHLIGHT PER MM.SDR SWAA082718Crease Beam · corrodedDURING SCHEDULED 22Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 314 AND BS 343, LBL 58 TO LBL 65. REMOVED AND REPLACED WEB PER SRM.SDR SWAA082644Wire · brokenDURING SCHEDULED 22Y CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT INOP. FOUND BROKEN WIRE. REPAIRED WIRE PER WDM.SDR SWAA082578Beam · wornDURING SCHEDULED 22Y CHECK, FOUND RIGHT MLG FWD STABILIZER LUG WORN. REMOVED AND REPLACED RIGHT MLG STABILIZER BEAM PER MM.SDR SWAA082223Floorbeam · corrodedDURING SCHEDULED HC1 CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 293.5, RBL 5. REMOVED AND REPLACED UPPER CHORD PER SRM.SDR SWAA082040Crease Beam · corrodedDURING SCHEDULED 22Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 978 AND BS 992, STR 17L. REMOVED AND REPLACED WEB PER SRM.SDR SWAA081957Fitting · crackedDURING SCHEDULED 22Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING CRACKED. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA081240Lens · missingBULLNOSE EMERGENCY EXIT LIGHT LENS MISSING AT ROW 19 DEF. INSTALLED LENS PER MM.SDR SWAA080790Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 312, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA080341Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND OVERHEAD EMERGENCY EXIT LIGHT INOP AT ROW 8 DEF. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA076267Lamp · inoperativeLEFT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA075954Battery Pack · dischargedDURING SCHEDULED MV2 CHECK, FOUND FWD CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA075347Slide · out of adjustDURING SCHEDULED HC2 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA073926Charger · inoperativeDURING SCHEDULED MV4 CHECK, FOUND BULL NOSE EMERGENCY EXIT LIGHT INOP AT ROW 19 DEF. REMOVED AND REPLACED BATTERY CHARGER PER MM.SDR SWAA072787Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 520, STR 16R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA072660Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 867, STR 20L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA072607Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CHORD CRACKED AT LEFT BS 639, WL 208. REMOVED AND REPLACED CHORD PER SRM.SDR SWAA072537Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER 8R CRACKED AT BS 727C. REPAIRED STRINGER PER SRM.SDR SWAA072536Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 5L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072535Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 7L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072534Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072493Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 7L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072492Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 6L. REMOVED AND REPLACED STRINGER CLIP PER SRM.
Back to N689SW, cancelled Mar 16, 2018