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 SWAA051938Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 781, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA051837Bushing · wornDURING SCHEDULED C1 CHECK, LT ELEVATOR TAB FAILED THE FREE PLAY CHECK. REMOVED AND REPLACED LT ELEVATOR TAB NR 1 & 2 HINGE BUSHINGS & HARDWARE PER MM.SDR SWAA051668Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 391, STR 26L. REPAIRED SKIN PER SRM.SDR SWAA051667Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 443, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA051598Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND 2 EA FUSELAGE SKIN CRACKS AT BS 750 TO BS 752, STR 21L & STR 24L. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA051597Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727, STR 14R. REPAIRED SKIN PER SWA EA.SDR SWAA051596Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND 3 EA FUSELAGE SKIN CRACKS AT BS 500C + 5, STR 15R, BS 500D + 3, STR 16R & BS 520, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA051510Skin · crackedDURING PREFLIGHT CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 757, STR 18L TO STR 19L. TEMP REPAIRED SKIN & MX FERRY TO PHX. REPAIRED SKIN PER SRM.SDR SWAA050968Skin · crackedDURING SCHEDULED RON CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 927, BETWEEN STR 23R TO STR 24R. REPAIRED SKIN PER SRM.SDR SWAA043449Skin · crackedDURING SCHEDULED C3 CHECK, FOUND 3 EACH FUSELAGE SKIN CRACKS BETWEEN BS 747 AND BS 867, BETWEEN STRINGERS 21L AND 24L. REPAIRED SKIN SECTIONS PER EA AND SRM.SDR SWAA042444Beam · crackedDURING SCHEDULED C2 CHECK, FOUND R1 DOOR NR 1 WEB BEAM CRACKED AT RIGHT CORNER. REMOVED AND REPLACED R1 DOOR PER MM.SDR SWAA041407Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN AT BS 727D + 5, STRINGER 19R AND BS 732, STRINGER 19R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA041406Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN AT BS 727D + 5, STRINGER 21L AND BS 767, STRINGER 22L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA041111Tie · crackedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIES AT BS 706, STRINGER 1R, BS 787, STRINGER 10L, BS 847, STRINGER 14L, CRACKED. REMOVED AND REPLACED SHEAR TIES PER SRM.SDR SWAA041112Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM AT BS 663, BL 0, CRACKED. REPAIRED FLOORBEAM SECTION PER ER.SDR SWAA041091Frame · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME AT BS 727D, STRINGER 26R AND STRINGER 27R, CORRODED. REPAIRED FRAME PER SRM.SDR SWAA041090Pressure Panel · crackedDURING SCHEDULED 1/4D CHECK, FOUND MLG W/W BEADED PRESSURE WEB AT BS 663, LBL 40, CRACKED. REPAIRED WEB PER ER.SDR SWAA041089Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND BUTT STRAP AT BS 908, STRINGER 4R, CRACKED. REPAIRED STRAP PER SRM.SDR SWAA041088Splice · crackedDURING SCHEDULED 1/4D CHECK, FOUND STRINGER SPLICES AT STRINGER 4R, BS 360, AND BS 908, CRACKED. REMOVED AND REPLACED STRINGER SPLICES PER SRM.SDR SWAA041087Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, FOUND BULKHEAD WEB AT BS 1016, FROM STRINGER 6R TO STRINGER 6L, STRINGER 23R, CRACKED. REPAIRED WEB PER ER.SDR SWAA041078Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FRAME WEB AT BS 639, RT OVERWING EXIT DOOR, CRACKED. REPAIRED FRAME WEB PER ER.SDR SWAA041065Stringer · corrodedDURING SCHEDULED 1/4D CHECK, FOUND AFT CARGO COMPARTMENT BS 867, STRINGER 26 R, CORRODED. REPAIRED STRINGER PER SRM.SDR SWAA041001Tie · crackedDURING SPV, FOUND SHEAR TIES AT BS 360, STRINGER 14L AND STRINGER 14R, CRACKED. REMOVED AND REPLACED SHEAR TIES PER SRM.SDR SWAA040996Splice · crackedDURING SCHEDULED 1/4D CHECK, FOUND STRINGER SPLICE AT BS, 908, STRINGER 4L, CRACKED. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA040514Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 930, STRINGER 25R. REPAIRED SKIN PER SRM.SDR SWAA040496Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKS AT FOLLOWING LOCATIONS, BS 740, STRINGER 18R, BS 740, STRINGER 24L, BS 920, STRINGER 23R AND BS 930, STRINGER 25L. REPAIRED SKIN PER SRM.SDR SWAA040495Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND KEEL BEAM SKIN CRACKED AT LT WHEEL WELL. REPAIRED SKIN PER SRM.SDR SWAA040482Actuator · leakingDECLARED EMERGENCY, A SYSTEM HYDRAULIC FAILURE, COMPLETE LOSS OF A SYSTEM HYDRAULIC FLUID AT FL 280, COMPLIED WITH QRH. REMOVED AND REPLACED NR 3 FLIGHT SPOILER ACTUATOR PER MM.SDR SWAA040355Flap Track · wornAIRFRAME VIBRATION WHEN FLAPS SELECTED TO 5 DEGREES. REPAIRED LT WING T/E INBOARD MIDFLAP TRACK PER EA.SDR SWAA032795Skin · crackedDURING SCHEDULED C4 CHECK, FOUND 3 INCH LONG FUSELAGE SKIN CRACK AT BS 747, STR 18R. REPAIRED SKIN PER SRM.SDR SWAA032721Valve · leakingAFTER TAKEOFF LOST A SYSTEM HYDRAULIC PRESSURE. RETURNED TO BNA FOR LANDING. REMOVED AND REPLACED MANUAL SHUTOFF VALVE PER MM.SDR SWAA031978Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500B, STR 10R. REPAIRED SKIN PER SRM.SDR SWAA031960Flashlight · weakEMERGENCY FLASHLIGHT IN FWD CABIN WEAK. REMOVED AND REPLACED FLASHLIGHT PER MM.SDR SWAA031724Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED (3 EA) AT LOWER AFT CORNER OF AIRSTAIR CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA031667Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 970, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA031666Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 874, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA031182Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED (3 EA) AT STR 10R, BS 460, BS 500C AND BS 500D. REPAIRED SKIN PER SRM.SDR SWAA031181Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED (4 EA) BS 294 AT STR 14L, BS 520 AT STR 12R, BS 787 AT STR 23L AND BS 807 AT STR 22L. REPAIRED SKIN PER SRM.SDR SWAA030505Sensor · failedAIR TURNBACK, AFTER FLAP RETRACTION, NR 4 L/E FLAP TRANSIT LIGHT ILLUMINATED. REMOVED AND REPLACED NR 4 L/E FLAP RETRACT SENSOR PER MM. OPS CK GOOD.SDR SWAA030393Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 789, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA030392Light · inoperativeDURING SCHEDULED BC1 CHECK, FOUND ONE LIGHT BULB INOP AT EACH CABIN DOOR OVERHEAD EMERGENCY EXIT LIGHT. RELAMPED EACH CABIN DOOR EXIT LIGHT PER MM.SDR SWAA030391Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA030330Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BULKHEAD WEB CRACKED ( 2 EA ) AT BS 178, WL 235 AND BL 11, LT AND RT. REPAIRED BULKHEAD PER SWA EA.SDR SWAA030303Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED (2 EA) AT BS 727D + 14 AT STR 22L AND BS 770 AT STR 24L. REPAIRED SKIN PER SRM.SDR SWAA030191Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED (2 EA) AT STR 10R, BS 504 AND BS 500D + 8. REPAIRED SKIN PER SRM.SDR SWAA022208Window · crackedDIVERSION, DURING FLIGHT R-1 COCKPIT WINDOW CRACKED. REMOVED AND REPLACED R-1 COCKPIT WINDOW AND CONTROLLER PER MM.SDR SWAA021811Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA021818Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 520, STR 12L. REPAIRED SKIN PER SRM.SDR SWAA021817Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACK AT BS 500D, STR 10L. REPAIRED SKIN PER SRM.SDR SWAA021816Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKS (2 EA) AT STR 23L, BS 727E AND BS 747. REPAIRED SKIN PER SRM.
Back to N689SW, cancelled Mar 16, 2018