N698SW, cancelled Sep 18, 2012
Service difficulty reports · 320
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 = 'N698SW' AND deregistration_id = 'N698SW-2012-09-18' 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 = 'N698SW' AND deregistration_id = 'N698SW-2012-09-18' 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 SWAA021870Battery · faultyDURING SCHEDULED PM CHECK, FWD CABIN EMERGENCY EXIT LIGHTS NOT TURNING OFF. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA021815Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKS (2 EA) AT STR 22L, BS 767 AND BS 787. REPAIRED SKIN PER SRM.SDR SWAA021493Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500C, STR 10R. REPAIRED SKIN PER SRM.SDR SWAA021492Lens · brokenDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR OVERHEAD EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LIGHT LENS PER MM.SDR SWAA021058Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021011Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA020720Flashlight · inoperativeEMERGENCY FLASHLIGHT INOP IN AFT CABIN TOP POSITION. REMOVED AND REPLACED FLASHLIGHT PER MM.SDR SWAA020717Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND BOTH FWD CABIN DOOR EMERGENCY EVAC SLIDE GIRT ASSY'S OUT OF ADJUST. ADJUSTED SLIDES PER MM.SDR SWAA020606Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA020190Pump · failedNR 2 FUEL TANK FWD FUEL BOOST PUMP LOW PRESS LIGHT ILLUMINATED. REMOVED AND REPLACED NR 2 FUEL TANK FWD BOOST PUMP AND LOW PRESS SWITCH PER MM.SDR SWAA012821Frame · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 1006, RBL 34 & WL 200. REPAIRED FRAME PER SRM.SDR SWAA012375Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 767, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA010984Slide · out of toleranceDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE ASSY PER MM.SDR SWAA010531Plate · delaminatedDURING SCHEDULED C1 CHECK, FOUND LT WING L/E INBD FORE FLAP REPAIR PLATE DISBONDED. REMOVED AND REPLACED FORE FLAP PER MM.SDR SWAA010135Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 178 BULKHEAD VERTICAL CHORD CRACKED AT LBL 5.7, AFT SIDE, INBOARD RADIUS, WL 182.5 TO WL 184. REPAIRED VERTICAL CHORD PER SRM.SDR SWAA010121Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, FOUND 4 BS 178 BULKHEAD WEB CRACKS BETWEEN RBL 26 TO LBL 12.5, WL 207 TO WL 232. REPAIRED BULKHEAD WEB PER SRM.SDR SWAA010122Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND EXTERNAL FUSELAGE SKIN CRACKED AT BS 178, WL 240 RT. REPAIRED SKIN PER ER 01-0045.SDR SWAA002670Battery Pack · dischargedDURING SCHEDULED SERVICE CHECK, FOUND EMERGENCY LIGHTING INOP IN FWD SECTION. R&R BATTERY PACK PER MM.SDR SWAA002564Skin · crackedDURING SCHEDULED A2 CHECK, FOUND .5 EXTERNAL FUSELAGE SKIN CRACK BETWEEN BS 727D & BS 727E AT STR 21L. REPAIRED SKIN PER SRM.SDR SWAA002294Cover · looseEEPLS IN AFT CABIN LOOSE. REPAIRED EEPLS TRACK COVER PER MM.SDR SWAA002152Skin · crackedDURING SCHEDULED C4 CHECK, FOUND NR 2 L/E SLAT, 6 CRACK, AT LOWER T/E SKIN, O/B OF THE O/B ACTUATOR STOP. REPAIRED SKIN PER SRM.SDR SWAA002151Lens · crazedDURING SCHEDULED C4 CHECK, FOUND LT HATCH EXTERNAL EMERGENCY EVAC LIGHT LENS CRAZED. REMOVED AND REPLACED LENS PER MM.SDR SWAA001267Line · leakingAIR TURNBACK, NLG EXTENDED WHEN HANDLE PLACED IN OFF POSITION. REMOVED AND REPLACED UPPER NLG ACTUATOR UPLOCK HYD LINE PER MM. OPS CHECK GOOD.SDR SWAA001118Rod End · out of adjAIR TURNBACK, NR 6 L/E SLAT WOULD FULLY EXTEND AND WOULD NOT RETRACT AFTER TAKEOFF. REMOVED AND REPLACED NR 6 L/E SLAT ROD END ACTUATOR PER MM.SDR SWAA001103Valve · failedAIR TURNBACK. DURING CLIMB, NR 1 ENG HYD PUMP FAILED FOLLOWED BY ELEC A-SYS HYD PUMP FAILURE. REMOVED AND REPLACED A-SYS HYD MANUAL SHUT-OFF VALVE IN TAIL COMPARTMENT.SDR SWAA000754Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE EXTERNAL SKIN CRACKED AT 4 PLACES, STRINGER 23R, BS 747, BS 730, BS 870, AND BS 747, STRINGER 24R. REPAIRED SKIN PER SRM.SDR SWAA000616Control Panel · inoperativeAIR TURNBACK - UNABLE TO CONTROL CABIN PRESSURE AFTER BECOMING AIRBORNE. R&R PRESS CONTROL PANEL, OUTFLOW VALVE, REPLACED LOOSE CLAMP AT RH A/C PACK WATER SEPARATOR, AND R&R MIXING CHAMBER DUCT PER MM.SDR SWAA000195Lens · looseRT AFT WING TO FUSELAGE OUTER EMERGENCY LIGHT LENS LOOSE. RESECURED LENS ASSY PER MM.SDR SWAA991765Module · inopAIR TURNBACK, LANDING GEAR WOULD NOT RETRACT AFTER TAKEOFF. REMOVED AND REPLACED RELAY R276, AND M991 MODULE PER MM.SDR SWAA991658Solenoid · inopAIR TURNBACK, DURING TAKEOFF, LANDING GEAR HANDLE WOULD NOT RAISE PAST OFF POSITION. LANDING GEARS WOULD NOT RETRACT. REMOVED AND REPLACED LANDING GEAR CONTROL LEVER SOLENOID PER MM.SDR SWAA991568Skin · crackedDURING WALK ARROUND INSPECTION, FOUND FUSELAGE SKIN CRACKED, BS 727D, STRINGER 18L AND STRINGER 18R. REPAIRED CRACKS PER SRM.SDR SWAA991182Skin · crackedDURING SCHEDULED RON, FOUND FUSELAGE SKIN CRACKED, BS 727E, STRINGER 24R. REPAIRED SKIN PER SRM.SDR SWAA991067Tab · crackedDURING SCHEDULED SPECIAL VISIT CHECK, FOUND RT AILERON TAB LOWER SURFACE CRACKED AND DELAMINATED. REMOVED AND REPLACED AILERON TAB PER MM.SDR SWAA981437Light · looseDURING SCHEDULED 1/2 D CHECK, FOUND 7 ABC BULLNOSE EGRESS LIGHT LOOSE. REPAIRED PER BOEING MM.SDR SWAA981436Floorbeam · crackedDURING SCHEDULED 1/2 D CHECK, FOUND CRACKED FLOORBEAM AT TIE DOWN BS 787 RBL 14. REPAIRED PER BOEING MM.SDR SWAA981435Battery Pack · dischargedDURING SCHEDULED 1/2 D CHECK, FOUND RIGHT HAND CENTER EMERGENCY LIGHTS BATTERY PACK WILL NOT CHARGE. REMOVED AND REPLACED BATTERY PACK PER BOEING MM.SDR SWAA981434Stringer · corrodedDURING SCHEDULED 1/2 D CHECK, FOUND STRINGER 27L CORRODED BETWEEN BS 500C + 500D. REPAIRED PER BOEING SRM.SDR SWAA981433Stringer · corrodedDURING SCHEDULED 1/2 D CHECK, FOUND STRINGER 26R AT BS 844 CORRODED AROUND HI-LOK. REPAIRED PER BOEING SRM.SDR SWAA981432Skin · crackedDURING SCHEDULED 1/2 D-CHECK, FOUND CORRODED FLOORBEAM AT RBL 13 BETWEEN BS 794 AND BS 847 AROUND MANY FASTENER LOCATIONS. REPAIRED PER BOEING SRM.SDR SWAA981431Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND CORRODED FLOORBEAM AT RBL 13 BETWEEN BS 794 AND BS 847 AROUND MANY FASTENER LOCATIONS. REPAIRED PER BOEING SRM.SDR SWAA981405Bulkhead · crackedDURING SCHEDULED 1/2D CHECK, FOUND CRACKED BS 178 LT BULKHEAD CHORD ANGLE WL 207. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981404Skin · buckledDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN BUCKLED/WARPED AROUND FASTENERS ON LOWER LOBE AT BS 500C, STR 28L. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981400Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND WEB CRACKED AT DOOR OPENING BS 440, STR 25R. REPAIRED PER BOEING SRM.SDR SWAA981384Floorbeam · corrodedDURING SCHEDULED 1/2 D CHECK, FOUND CORRODED FLOORBEAM AT BS 986, RBL 32; BS 986, RBL 36; AND BS 986, RBL 40. REPAIRED PER BOEING SRM.SDR SWAA981372Angle · wornDURING SCHEDULED 1/2D CHECK, FOUND PYLON SUPPORT ANGLE FOR PANEL WORN JUST BELOW HYD LINES NR 3 JACKSCREW CANOE FAIRING. REMOVED AND REPLACED PER BOEING MM.SDR SWAA981371Channel · crackedDURING SCHEDULED 1/2D CHECK, FOUND U CHANNEL SUPPORT FOR I/B PYLON PANEL CRACKED. REPAIRED PER BOEING MM.SDR SWAA981370Strap · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRAP FOR I/B PYLON PANEL CRACKED. REPAIRED PER BOEING MM.SDR SWAA981369Angle · corrodedDURING SCHEDULED 1/2D CHECK, FOUND LT TRANSITION ANGLE CORRODED AT BS 727D-727E.; BS 727E-747; BS 747-767; AND 727-727B. REPAIRED PER BOEING MM.SDR SWAA981354Web · crackedDURING SCHEDULED 1/2 D-CHECK, FOUND O/B WEB AT BS 360 TO 380, STR 17L IS BENT AND CRACKED. REPAIRED PER BOEING SRM.SDR SWAA981307Skin · crackedDURING SCHEDULED 1/2 D-CHECK, FOUND CRACKED SKIN AT BS 178 WL 188 LBL .5, WL 188 RBL .5 AND WL 198 RBL 5. REPAIRED PER BOEING SRM.
Back to N698SW, cancelled Sep 18, 2012