N699SW, cancelled Oct 30, 2013
Service difficulty reports · 338
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 = 'N699SW' AND deregistration_id = 'N699SW-2013-10-30' 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 = 'N699SW' AND deregistration_id = 'N699SW-2013-10-30' 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 SWAA991714Rib · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE CENTER SECTION, BS 616, RBL 60 RIB ASSY CRACKED. REPAIRED RIB SECTION PER TI-153-018.SDR SWAA991713Bulkhead · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 178 BULKHEAD CRACKED, LBL 11- RBL 7. REMOVED AND REPLACED BULKHEAD WEB PER ACO 7154-53.SDR SWAA991712Floor Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND BS 947 FLOORBEAM UPPER SECTION CORRODED AT LBL 9. REPAIRED BEAM PER SRM.SDR SWAA991703Skin · corrodedDURING SCHEDULED 1/2D CHECK, FOUND RT WING UPPER SURFACE SKIN CORRODED AROUND IN SPAR, WS 345 AND WS 475. REPAIRED SKIN PER SWA RA NR 1-357-0754, REVISION 1.SDR SWAA991696Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND CRACKED FUSELAGE FRAME, BS 294, RBL 54 AT FWD GALLEY DOOR CUT OUT. REPAIRED FRAME PER SRM.SDR SWAA991695Shear Tie · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION ON FUSELAGE SHEAR TIE, BS 787, STRINGER 27R. REPAIRED SHEARTIE PER SRM.SDR SWAA991692Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION ON FLOORBEAM, BS 1006, LBL 19. REPAIRED BEAM PER SRM.SDR SWAA991687Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND BS 328 FLOORBEAM UPPER SURFACE CORRODED BETWEEN LBL 15 - RBL 58. REPAIRED FLOORBEAM PER SRM.SDR SWAA991669Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION ON FLOORBEAM UPPER FACE, BS 294.5, LBL 10.5. REPAIRED FLOORBEAM PER SRM.SDR SWAA991668Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FWD SERVICE DOOR, AFT FRAME CRACKED AT TWO PLACES. REPAIRED FRAME PER SRM.SDR SWAA991117Skin · crackedDURING SCHEDULED BC2 CHECK, FOUND 4 EA FUSELAGE SKIN CRACKS APPROX 1.5 INCHES LONG, BS 727E AND 727D, STRINGER 23R, BS 727E, STRINGER 21L, AND BS 747, STRINGER 22L. REPAIRED SKIN PER SRM.SDR SWAA990823Slide · out of positionLT FWD EMERGENCY ESCAPE SLIDE CAME OUT OF THE HOLDER. INSPECTED AND RESTOWED SLIDE ASSY PER MM.SDR SWAA983185Skin · crackedDURING SCHEDULED SC CHECK, FOUND A FUSE SKIN CRACK AT BS 747, S21R, 2.25 LONG. REPAIRED PER BOEING SRM.SDR SWAA983184Skin · crackedDURING SCHEDULED SC CHECK, FOUND 2 FUSE SKIN CRACKS BETWEEN BS 727D AND E AT S22R, 1.5 LONG AND 3 APART. REPAIRED PER BOEING SRM.SDR SWAA983023Controller · malfunctionedAT FL 350, PRESS MODE SELECTOR IN AUTO, THE ALTITUDE 'CABIN' WARNING HORN SOUNDED. EMERGENCY DECLARED. EMERGENCY DESCENT ACCOMPLISHED. PASSENGER MASK DID NOT DROP. CABIN ALT INCREASED TO APPROX 12,500 FT, MAN PRESS OK. REPLACED CABIN PRESSURIZATION CONTROSDR SWAA982815Skin · crackedDURING SCHEDULED A2 CHECK, FOUND SKIN CRACKED AT BS 887, STR 21R. REPAIRED PER BOEING SRM.SDR SWAA981143Uplock Switch · malfunctionedAIR RETURN AFTER TAKEOFF AND GEAR RETRACTION. LEFT MAIN GEAR GREEN LIGHT REMAINED ILLUMINATED, LEFT RED GEAR LIGHT DID NOT EVER ILLUMINATE. AIRCRAFT MADE AN UNEVENTFUL LANDING. REMOVED AND REPLACED LT MLG UP AND LOCK SWITCH, DOWN AND LOCK SWITCH AND LT GREESDR SWAA980370Hyd Line · ruptureRETURN TO LAS DUE TO NOSE LANDING GEAR FAILING TO RETRACT AND MADE UNEVENTFUL LANDING. INSPECTED AND FOUND NOSE GEAR ACTUATOR UPLOCK HYD LINE RUPTURE. REMOVED AND REPLACED PER BOEING MM.SDR SWAA970838Light · corrodedDURING SERVICE CHECK, FOUND AFT ENTRY DOOR EMERGENCY ESCAPE SLIDE LIGHT CORRODED AND INOP. REPLACED LIGHT ASSEMBLY PER BOEING M/M.SDR SWAA970686Skin · crackedDURING SERVICE CHECK, FOUND A 3 INCH FUSELAGE SKIN CRACK AT BS 727E, S24L. REPAIRED PER BOEING SRM.SDR SWAA970630Skin · crackedDURING SCHEDULED 1/4 D CHECK, FOUND A 4 FUSELAGE SKIN CRACK AT BS 747, S25R. REPAIRED PER BOEING SRM.SDR SWAA961282Web · crackedDURING SCHEDULED C3 CHECK, FOUND UPPER FWD DOOR STOP CRACKED IN WEB. REPAIRED PER SWA RA 1-353-1558.SDR SWAA950156Skin · oil canningDURING SCHEDULED TRANSITION CHECK, FOUND FUSELAGE SKIN OIL CANNING FROM BS 727D TO 747, STRINGER 22L TO 24L. REPAIRED PER TRAMCO EWO 95-0082.SDR SWAA950155Chord · crackedDURING SCHEDULED TRANSITION CHECK, FOUND COMPRESSION CHORD CRACKED AT BS 727, WL 199, RBL 13 TO 15. REPAIRED PER TRAMCO EWO 95-0076.SDR SWAA950090Stringer · corrodedDURING SCHEDULED TRANSITION CHECK, FOUND APU COMPARTMENT BULKHEAD AIR INLET CUTOUT WITH CORROSION ON UPPER AND LOWER STRINGERS AND STIFFENERS FROM BS 1116 TO 1127. REPLACED PARTS PER BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA950089Stringer · corrodedDURING SCHEDULED TRANSITION CHECK, FOUND STRINGER CORROSION AROUND FASTENERS AT BS 727D TO 767, S26R, AND AT BS 767 TO 807, S26R. REPAIRED PER BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA950080Stiffener · corrodedDURING SCHEDULED TRANSITION CHECK, FOUND FLOOR BEAM STIFFENER CORRODED AT BS 294.5 AND 312, WL 208. REPLACED PER BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA950079Skin · dentedDURING SCHEDULED TRANSITION CHECK, FOUND FUSELAGE SKIN DENTED, AND A PREVIOUS REPAIR AT BS 767, BETWEEN S20 AND 21R. REPAIRED BOTH PER BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA950078Angle · corrodedDURING SCHEDULED TRANSITION CHECK, FOUND AFT CARGO DOOR L ANGLE CORRODED AT BS 832 RBL 32 WL 158. REPAIRED PER BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA950076Intercostal · corrodedDURING SCHEDULED TRANSITION CHECK, FOUND INTERCOSTAL CORROSION AT BS 767-787, RBL 22, WL 150 AND AT BS 344, BL 0, WL 208. FABRICATED AND REPLACED PER BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA950075Spar · corrodedDURING SCHEDULED TRANSITION CHECK, FOUND RIGHT WING SPAR UPPER SURFACE AT WS 500 JUST AFT OF FRONT SPAR CORRODED. REPAIRED PER TRAMCO EWO 95-0051.SDR SWAA950056Web · crackedDURING SCHEDULED MAINTENANCE CHECK, FOUND CRACK IN WEB AT BS 726, S18A, LEFT SIDE. REPAIRED PER SWA RA 1-553-1222.SDR SWAA950055Angle · crackedDURING SCHEDULED TRANSITION CHECK, FOUND SKATE ANGLE CRACKED AT BS 570, WL 158, LBL 50. REPLACED PER BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA950054Floor Beam · corrodedDURING SCHEDULED TRANSITION CHECK, FOUND FLOOR BEAM CORROSION AT BS 294.5, LBL 11 TO RBL 45. REPAIRED PER SWA RA 1-353-418.SDR SWAA950053Skin · dentedDURING SCHEDULED TRANSITION CHECK, FOUND FUSELAGE SKIN DENTED AT BS 885, BETWEEN S19 AND 20R. REPAIRED PER BOEING STRUCTURAL REPAIR MANAUL.SDR SWAA950052Clip · corrodedDURING SCHEDULED TRANSITION CHECK, FOUND STRINGER CLIP CORRODED AT BS 727D, RBL 16, WL 150. REPLACED PER BOEING STRUCTURAL REPAIR MANAUL.SDR SWAA950019Skin · dentedDURING SCHEDULED TRANSITION CHECK, FOUND FUSELAGE SKIN DENTED AT BS 368, WL 205, LEFT SIDE AND A LONGITUDINAL CREASE AFT OF CARGO DOOR, BS 867, BETWEEN S22R AND 23R. REPAIRED BOTH PER BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA950018Clip · corrodedDURING SCHEDULED TRANSITION CHECK, FOUND STRINGER CLIP CORRODED AT BS 727D, RBL 8, WL 147. REPLACED STRINGER CLIP PER BOEING STRUCTURAL REPAIR MANUAL.
Back to N699SW, cancelled Oct 30, 2013