N104SW, cancelled Oct 17, 2005
Service difficulty reports · 119
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 = 'N104SW' AND deregistration_id = 'N104SW-2005-10-17' 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 = 'N104SW' AND deregistration_id = 'N104SW-2005-10-17' 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 SWAA001650Light · looseOVERHEAD CENTER EMERGENCY EXIT LIGHT ASSY LOOSE. REINSTALLED LIGHT ASSY PER MM.SDR SWAA001425Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY DOOR EXTERNAL EMERGENCY LIGHT INOP. RELAMPED PER MM.SDR SWAA001194Fitting · corrodedDURING SCHEDULED D CHECK, FOUND LT MLG FITTING CORRODED AT TWO FASTENER HOLES, BS 706 STRINGER 18A L. REPAIRED FITTING PER ER NR 00-0667.SDR SWAA001195Frame · crackedDURING SCHEDULED D CHECK, FOUND BS 663 FRAME CRACKED AT STRINGERS 1, 2L, 2R, 3L AND 3R. REPAIRED FRAME PER SRM.SDR SWAA001183Doubler · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE INTERNAL DOUBLER CORRODED, BS 986, BETWEEN STRINGERS 27L - 27R. REPAIRED DOUBLER PER ER NR 00-0602.SDR SWAA001166Fitting · corrodedDURING SCHEDULED D CHECK, FOUND LT HORIZONTAL STAB HINGE HOUSING LOWER INBD AND OUTBD LUGS CORRODED. REPAIRED LUGS PER ER 00-0590.SDR SWAA001129Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CORRODED AT BS 727B, LBL 6 TO RBL 6. REPAIRED SHEAR TIE PER SRM.SDR SWAA001128Stringer · crackedDURING SCHEDULED D CHECK, FOUND STRINGER 8 RT CRACKED AT BS 334. REPAIRED STRINGER SECTION PER SRM.SDR SWAA001123Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CRACKED, BS 986.5, STRINGER 26R TO STRINGER 27R. REMOVED AND REPLACED SHEAR TIE SECTION PER SRM.SDR SWAA001090Stringer · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION AT STRINGER 26R, BS 1016 TO BS 1006. REPAIRED STRINGER SECTION PER SRM.SDR SWAA001067Structure · corrodedDURING SCHEDULED D-CHECK, FOUND FWD CARGO BIN DOOR CUTOUT AFT FUSELAGE FRAME CORRODED, STRINGER 25R. REPAIRED FRAME PER SRM.SDR SWAA001066Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CORRODED, BS 990, RBL 55, WL 210. REPAIRED FRAME PER SRM.SDR SWAA001048Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE FRAME CORRODED, BS 278, STRINGER 26R-28R. REPAIRED FRAME PER SRM.SDR SWAA001032Stringer · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER 28R CRACKED, BS 460. REPAIRED STRINGER PER SRM.SDR SWAA001007Stiffener · corrodedDURING SCHEDULED D-CHECK, FOUND BULKHEAD STIFFENER CORRODED BS 1016, WL 191. REPAIRED STIFFENER SECTION PER SRM.SDR SWAA001006Stringer · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER SPLICE CRACKED, BS 907, STRINGER 4L. REMOVED AND REPLACED SPLICE SECTION PER SRM.SDR SWAA001008Window Post · crackedDURING SCHEDULED D-CHECK, FOUND COCKPIT WINDOW POST CRACKED BETWEEN NR 1 AND NR 2 WINDOWS. REPAIRED WINDOW POST PER SRM.SDR SWAA000999Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIPS CRACKED BS 747, STR 5L, 5R, 6L, 7L, 7R, BS 787, STR 4R, 5R, 10L, BS 827, STR 10R. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA000998Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIPS CRACKED, BS 360, STR 11L, BS 380, STR 5R, BS 400, STR 9L, AND BS 420, STR 7R. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA000997Frame · crackedDURING SCHEDULED D-CHECK, FOUND BS 188 LT AND RT SIDE CHORDS CRACKED AT WL 208. REMOVED AND REPLACED SIDE CHORDS PER SRM.SDR SWAA000993Stringer · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER 5L CRACKED, BS 1138 - 1142. REPAIRED STRINGER SECTION PER SRM.SDR SWAA000992Stringer · corrodedDURING SCHEDULED D-CHECK, FOUND STRINGER 27L CORRODED, BS 376. REPAIRED STRINGER SECTION PER SRM.SDR SWAA000991Stringer · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER 14L CRACKED, BS 360. REPAIRED STRINGER SECTION PER SRM.SDR SWAA000977Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIP CRACKED, BS 380 STRINGER 26L. REMOVED AND REPLACED STRINGER CLIP PER MM.SDR SWAA000976Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CORRODED, BS 947 BETWEEN STRINGERS 26L-27L. REMOVED AND REPLACED SHEAR TIE SECTION PER SRM.SDR SWAA000978Stringer · corrodedDURING SCHEDULED D-CHECK, FOUND STRINGER 24R CORRODED, BS 494. REPAIRED STRINGER SECTION PER SRM.SDR SWAA000950Stiffener · crackedDURING SCHEDULED D-CHECK, FOUND BS 178 STIFFENER CRACKED WL 178, RBL 24. REMOVED AND REPLACED STIFFENER PER SRM.SDR SWAA000949Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND BS 360 FLOORBEAM UPPER SURFACE CORRODED, LBL 33 TO RBL 33. REPAIRED BEAM PER SRM.SDR SWAA000929Light · looseDURING SCHEDULED D-CHECK, FOUND AFT ENTRY DOOR EXTERNAL EMERGENCY EXIT LIGHT ASSY LOOSE. SECURED LIGHT ASSY PER MM.SDR SWAA000468Girt Bar · out of adjDURING SCHEDULED SERVICE CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE GIRT ASSY OUT OF ADJUSTMENT. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA000372Cap · missingDURING SCHEDULED C3 CHECK, FOUND EEPLS END CAP MISSING. INSTALLED END CAP PER MM.SDR SWAA000015Line · leakingINFLIGHT ENGINE SHUTDOWN, NR 2 ENG FLAMED OUT DURING DESCENT. FOUND P/D FUEL LINE LEAKING. ENGINE WOULD NOT RESTART. REMOVED AND REPLACED NR 2 ENG P/D TO OIL COOLER FUEL LINE..SDR SWAA991850Flashlight · inopFWD EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT ASSY PER MM.SDR SWAA991689Battery · dischargedEEPLS ILLUMINATED WITH SWITCH IN ARMED POSITION. REMOVED AND REPLACED FWD OVERHEAD BATTERY PACK PER MM.SDR SWAA990974Skin · crackedDURING SCHEDULED C4 CHECK, FOUND NR 4 LE SLAT HAS A .25 INCH LONG CRACK AT INBD AUX TRACK CUT OUT. REPAIRED SLAT PER SWA RA NR 1-257-0703.SDR SWAA990973Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FWD SERVICE DOOR SKIN HAS 1 INCH LONG CRACK AT LOWER HINGE ARM CUT OUT. REPAIRED SKIN PER SRM.SDR SWAA990541Cover · missingEMERGENCY EXIT LENS COVERS, RIGHT HAND AND LEFT HAND OVERWING EXITS MISSING. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA990316Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSE SKIN CRACKED AT AFT ENTRY DOOR UPPER CUTOUT, 2 PLACES. REPAIRED PER BOEING SRM.SDR SWAA990301Chord · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD CARGO DOOR T CHORD CRACKED AT FWD STOP CASTING AND 2ND FROM BOTTOM. REMOVED AND REPLACED DOOR PER BOEING M/M.SDR SWAA990300Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND HORIZONTAL WEB CRACKED AT BS 180, RBL 26. REPAIRED PER BOEING SRM.SDR SWAA990299Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 178 BULKHEAD SKIN CRACKED AT LBL AND RBL 12. REPAIRED PER BOEING SRM.SDR SWAA982993Skin · crackedDURING SCHEDULED C2 CHECK, FOUND A 1 INCH FUSELAGE SKIN CRACK AT BS 310 FWD OF FWD ENTRY DOOR GUIDE ARM. REPAIRED PER BOEING SRM.SDR SWAA981500Slide · inoperativeDURING WALKAROUND CHECK, FOUND AFT ENTRY ESCAPE SLIDE GAUGE UNABLE TO READ. REMOVED AND REPLACED SLIDE PACK PER BOEING MM. PRESS READ NORMAL.SDR SWAA980443Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND SKIN CRACKED AT BS 767 RT SIDE 5 INCHES BELOW WHITE STRIPE. REMOVED AND REPLACED PER BOEING MM.SDR SWAA980038Engine · oil leakAFTER GEAR RETRACTION, EXPERIENCED NR 1 ENGINE OIL AND PRESSURE LOSS. RETURNED TO HOU AND MADE AN UNEVENTFUL LANDING. FOUND OIL FILTER HOUSING CAP STUDS PULLED. REMOVED AND REPLACED ENGINE PER BOEING M/M.SDR SWAA970867Bolt · fracturedDURING A NR 2 ENGINE CHANGE ON 05SEP97, IT WAS DISCOVERED THAT THE FWD I/B MOUNT ATTACH BOLT WAS FRACTURED. THE FRACTURE OCCURED IN THE THREADED AREA. FRACTURE PIECES AND NUT WERE FORWARDED TO BOEING SERVICE ENGINEERING. THE LAST ENGINE CHANGE OCCURED IN DESDR SWAA970434Wheel · brokenON LANDING, A SECTION OF NUMBER 1 MAIN WHEEL HUB SEPARATED FROM MAIN ASSEMBLY, CAUSING MINOR DAMAGE TO NUMBER 1 MAIN BRAKE PRESSURE LINE. INSPECTED AREA, REMOVED AND REPLACED NUMBER 1 AND 2 MAIN WHEEL/TIRE ASSEMBLIES, AND PRESSURE LINE PER BOEING M/M.SDR SWAA970062Slide · low pressDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY DOOR EMERGENCY SLIDE INSPECTION DUE. REPLACED SLIDE ASSEMBLY PER BOEING M/M.SDR SWAA961182Skin · crackedDURING SCHEDULED C1 CHECK, FOUND A FUSELAGE SKIN CRACK AT AFT LRRA ANTENNA AREA, FWD RIVET. REPAIRED PER BOEING SRM.SDR SWAA960859Skin · gougedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN GOUGED AT BS 947, S20L. REPAIRED PER BOEING SRM.
Back to N104SW, cancelled Oct 17, 2005