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 SWAA064192Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 743E, STR 25R. REPAIRED SKIN PER SWA EA.SDR SWAA064191Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 751, STR 25R. REPAIRED SKIN PER SWA EA.SDR SWAA062321Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN BEAR STRAP CRACKED AT BS 797, STR 24R. REPAIRED SKIN PER ER.SDR SWAA062320Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT AFT CARGO DOOR CUTOUT FWD LOWER CORNER. REPAIRED SKIN PER ER.SDR SWAA062319Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO DOOR CUTOUT AFT FRAME WEB CRACKED AT LOWER DOOR STOP. REMOVED AND REPLACED FRAME WEB PER SRM.SDR SWAA062318Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO DOOR CUTOUT FWD FRAME WEB CRACKED AT LOWER DOOR STOP. REMOVED AND REPLACED FRAME WEB PER BOEING DRAWING AND SRM.SDR SWAA062317Rib · crackedDURING SCHEDULED 20Y CHECK, FOUND LT WING FUEL CELL INTERIOR MAIN BOX UPPER RIB CRACKED AT WBL 114, STR 1. REPAIRED RIB PER ER.SDR SWAA062316Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND LT HORIZONTAL STAB LOWER SKIN CRACKED AT STA 135.70. REPAIRED SKIN PER ER.SDR SWAA062315Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 791, STR 14R. REPAIRED SKIN PER SWA EA.SDR SWAA062314Keelbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND KEEL BEAM CHORD CORRODED AT BS 510D TO BS 540, RBL 6. REMOVED AND REPLACED KEEL BEAM CHORD PER SRM.SDR SWAA062313Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 847, BL 3 TO LBL 3. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA062312Stringer Splice · corrodedDURING SCHEDULED 20Y CHECK, FOUND STRINGER SPLICE CORRODED AT BS 907, STR 24R. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA062311Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FWD CARGO DOOR CUTOUT, FWD FRAME CRACKED FROM NR 2 DOOR STOP TO NR 5 DOOR STOP. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA062310Keelbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND KEELBEAM CHORD CORRODED AT BS 727, LBL 6. REMOVED AND REPLACED KEELBEAM CHORD PER BOEING DRAWING AND ER.SDR SWAA062247Keelbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND KEEL BEAM CHORD CORRODED AT BS 727, LBL 7. REMOVED AND REPLACED KEEL BEAM CHORD PER SRM.SDR SWAA062236Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 303, STR 15L. REPAIRED FRAME SECTION PER ER.SDR SWAA062155Stringer Splice · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 348, STR 15L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA062146Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND RT WING NR 5 L/E SLAT LOWER SKIN CRACKED AT INBOARD RIB ATTACHMENT. REPAIRED SKIN PER SRM.SDR SWAA062145Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 751, STR 14R. REPAIRED SKIN PER SWA EA.SDR SWAA062144Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND RT ELEVATOR TAB LOWER SKIN CRACKED AT CENTER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA062143Skin · delaminatedDURING SCHEDULED 20Y CHECK, FOUND LT ELEVATOR TAB LOWER SKIN DELAMINATED AT OUTBOARD END. REPAIRED SKIN PER SRM.SDR SWAA062142Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND LT ELEVATOR TAB LOWER SKIN CRACKED AT INBOARD CENTER HINGE CUTOUT OUTBOARD CORNER. REPAIRED SKIN PER SRM.SDR SWAA062141Skin · debondedDURING SCHEDULED 20Y CHECK, FOUND LT WING MID FLAP INBOARD T/E LOWER SURFACE DISBONDED. REPAIRED MID FLAP PER SRM.SDR SWAA062140Skin · debondedDURING SCHEDULED 20Y CHECK, FOUND RT WING MID FLAP INBOARD T/E LOWER SURFACE DISBONDED. REPAIRED MID FLAP PER SRM.SDR SWAA062139Bracket · looseDURING SCHEDULED 20Y CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE GIRT BAR FWD BRACKET LOOSE. REMOVED AND REPLACED BRACKET PER SRM.SDR SWAA062138Skin · delaminatedDURING SCHEDULED 20Y CHECK, FOUND LT WING FORE FLAP INBOARD T/E SURFACE DELAMINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA062137Arm · corrodedDURING SCHEDULED 20Y CHECK, FOUND RT WING INBOARD MID FLAP OUTBOARD CARRIAGE INBOARD ARM CORRODED. REMOVED AND REPLACED INBOARD ARM PER CMM.SDR SWAA062136Arm · corrodedDURING SCHEDULED 20Y CHECK, FOUND RT WING INBOARD MID FLAP INBOARD CARRIAGE OUTBOARD ARM CORRODED. REMOVED AND REPLACED OUTBOARD ARM PER CMM.SDR SWAA062083Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT FWD CARGO DOOR CUTOUT BEAR STRAP LOWER FWD CORNER. REPAIRED SKIN PER SRM.SDR SWAA062082Door Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FWD CARGO DOOR CUTOUT AFT FRAME CRACKED AT BS 492, STR 24R. REMOVED AND REPLACED FRAME SECTION PER BOEING DRAWING AND SRM.SDR SWAA061986Angle · crackedDURING SCHEDULED 20Y CHECK, FOUND STUB FRAME ANGLE CRACKED IN RADIUS AT BS 348, STR 16L. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA061493Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 385, STR 26L. REPAIRED SKIN PER SWA EA SRM.SDR SWAA061492Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 787, STR 20L. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA061491Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 739, STR 24R. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA061490Light · wornDURING SCHEDULED C4 CHECK, FOUND EEPLS STRIP WORN AT ROW 17 ABC. REMOVED AND REPLACED EEPLS STRIP PER MM.SDR SWAA060942Battery Pack · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND FWD GALLEY LOWER EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA060261Slide · out of adjustL1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA060247Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 914 TO BS 919, STR 24R TO STR 25R. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA060246Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 860, STR 25L. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA060245Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 833, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA060244Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 800, STR 22L. REPAIRED SKIN PER SRM.SDR SWAA054032Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 261, STR 9L. REPAIRED SKIN PER SWA EA.SDR SWAA053924Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 905, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA053776Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 883, STR 23R. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA053046Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727D, STR 14R. REPAIRED SKIN PER SWA EA.SDR SWAA052920Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 907, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA052919Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 767, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA052535Cover · missingLEFT OVERWING EMERGENCY EXIT SIGN COVER MISSING. INSTALLED COVER PER MM.SDR SWAA052011Circuit Card · arcedAIR TURNBACK/DECLARED EMERGENCY. RED NOSE GEAR LIGHT ILLUMINATED, ACFT DID NOT PRESSURIZE ABOVE 10,000 FT, LOW IDLE LIGHT ILLUMINATED DURING DESCENT. FOUND ARCING ON M1112, M990 & M991 CIRCUIT CARDS. REMOVED AND REPLACED CIRCUIT CARDS PER MM.SDR SWAA051939Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 810, STR 25L. REPAIRED SKIN PER SRM.
Back to N689SW, cancelled Mar 16, 2018